Name: BUSINESS_LICENSES

Display Field: LEGALFIRSTNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Has Views: true

Source Schema Changes Allowed: true

Views

Description: The City of Philadelphia has migrated metadata for this data set to the City-wide Metadata Catalog. For any questions about the migration and administration of the Metadata Catalog, please contact maps@phila.gov. To view the metadata for this layer, please visit: https://metadata.phila.gov/#home/datasetdetails/5543865a20583086178c4ed2/representationdetails/5e985a5e344ed50018936bb8/

Copyright Text:

Min. Scale: 6000

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -20037507.0671792
YMin: -10820871.3546662
XMax: 20037507.0671792
YMax: 30240971.9583866
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[249,147,0,255],"size":8,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: objectid

Unique ID Field:

Name : objectid

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• objectid (type: esriFieldTypeOID, alias: objectid, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• posse_jobid (type: esriFieldTypeString, alias: posse_jobid, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• addressobjectid (type: esriFieldTypeDouble, alias: addressobjectid, SQL Type: sqlTypeOther, nullable: true, editable: true)
• council_district (type: esriFieldTypeString, alias: council_district, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• address (type: esriFieldTypeString, alias: address, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• unit_type (type: esriFieldTypeString, alias: unit_type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• unit_num (type: esriFieldTypeString, alias: unit_num, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• zip (type: esriFieldTypeString, alias: zip, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• censustract (type: esriFieldTypeString, alias: censustract, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• parcel_id_num (type: esriFieldTypeString, alias: parcel_id_num, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• opa_account_num (type: esriFieldTypeString, alias: opa_account_num, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• opa_owner (type: esriFieldTypeString, alias: opa_owner, SQL Type: sqlTypeOther, length: 1999, nullable: true, editable: true)
• owneroccupied (type: esriFieldTypeString, alias: owneroccupied, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• addressed_license (type: esriFieldTypeString, alias: addressed_license, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• licensenum (type: esriFieldTypeString, alias: licensenum, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• revenuecode (type: esriFieldTypeString, alias: revenuecode, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• licensetype (type: esriFieldTypeString, alias: licensetype, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• rentalcategory (type: esriFieldTypeString, alias: rentalcategory, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• initialissuedate (type: esriFieldTypeDate, alias: initialissuedate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• mostrecentissuedate (type: esriFieldTypeDate, alias: mostrecentissuedate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• expirationdate (type: esriFieldTypeDate, alias: expirationdate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• inactivedate (type: esriFieldTypeDate, alias: inactivedate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• licensestatus (type: esriFieldTypeString, alias: licensestatus, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• numberofunits (type: esriFieldTypeDouble, alias: numberofunits, SQL Type: sqlTypeOther, nullable: true, editable: true)
• legalfirstname (type: esriFieldTypeString, alias: legalfirstname, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• legallastname (type: esriFieldTypeString, alias: legallastname, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• legalname (type: esriFieldTypeString, alias: legalname, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• legalentitytype (type: esriFieldTypeString, alias: legalentitytype, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• business_name (type: esriFieldTypeString, alias: business_name, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• business_mailing_address (type: esriFieldTypeString, alias: business_mailing_address, SQL Type: sqlTypeOther, length: 1999, nullable: true, editable: true)
• ownercontact1name (type: esriFieldTypeString, alias: ownercontact1name, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ownercontact1mailingaddress (type: esriFieldTypeString, alias: ownercontact1mailingaddress, SQL Type: sqlTypeOther, length: 1999, nullable: true, editable: true)
• ownercontact1city (type: esriFieldTypeString, alias: ownercontact1city, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ownercontact1state (type: esriFieldTypeString, alias: ownercontact1state, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• ownercontact1zippostalcode (type: esriFieldTypeString, alias: ownercontact1zippostalcode, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ownercontact2name (type: esriFieldTypeString, alias: ownercontact2name, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ownercontact2mailingaddress (type: esriFieldTypeString, alias: ownercontact2mailingaddress, SQL Type: sqlTypeOther, length: 1999, nullable: true, editable: true)
• ownercontact2city (type: esriFieldTypeString, alias: ownercontact2city, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ownercontact2state (type: esriFieldTypeString, alias: ownercontact2state, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• ownercontact2zippostalcode (type: esriFieldTypeString, alias: ownercontact2zippostalcode, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• geocode_x (type: esriFieldTypeDouble, alias: geocode_x, SQL Type: sqlTypeOther, nullable: true, editable: true)
• geocode_y (type: esriFieldTypeDouble, alias: geocode_y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ownerismanagingagentinphilly (type: esriFieldTypeString, alias: ownerismanagingagentinphilly, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)

Templates:

Name: BUSINESS_LICENSES
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/31/2025 12:22:01 AM

Schema Last Edit Date: 7/31/2025 12:22:01 AM

Data Last Edit Date: 7/31/2025 12:20:36 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat