Name: Building Permits

Display Field: contractorcompanyname

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description: Building Permits

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -20037507.8427882
YMin: -30240971.4583861
XMax: 20037507.8427882
YMax: 30240971.4583861
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"color":[0,197,255,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[255,255,255,255],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}}},"transparency":0}

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: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• permittypemapped (type: esriFieldTypeString, alias: Permit Type Mapped, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• workclass (type: esriFieldTypeString, alias: Work Class, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• permitclass (type: esriFieldTypeString, alias: Permit Class, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• proposedworkdescription (type: esriFieldTypeString, alias: Proposed Work Description, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• permitclassmapped (type: esriFieldTypeString, alias: Permit Class Mapped, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• applieddate (type: esriFieldTypeDate, alias: Applied Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• issueddate (type: esriFieldTypeDate, alias: Issued Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• estprojectcost (type: esriFieldTypeDouble, alias: Estimated Project Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• constcompletedofficial (type: esriFieldTypeString, alias: Construction Officially Completed, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• censuslanduse (type: esriFieldTypeString, alias: Census Landuse, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• censuslandusecode (type: esriFieldTypeInteger, alias: Census Landuse Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• devplanid (type: esriFieldTypeInteger, alias: Development Plan ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• corlotid (type: esriFieldTypeString, alias: City Lot ID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• cntyacctnum (type: esriFieldTypeString, alias: County Account Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• coissueddate (type: esriFieldTypeDate, alias: CO Issued Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• cocissueddate (type: esriFieldTypeDate, alias: COC Issued Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• cocnbr (type: esriFieldTypeInteger, alias: COC Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• contractorcompanyname (type: esriFieldTypeString, alias: Contractor Company Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• contractordba (type: esriFieldTypeString, alias: Contractor Doing Business As, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• contractoraddress1 (type: esriFieldTypeString, alias: Contractor Address 1, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• contractoraddress2 (type: esriFieldTypeString, alias: Contractor Address 2, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• contractorcity (type: esriFieldTypeString, alias: Contractor City, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• contractorstate (type: esriFieldTypeString, alias: Contractor State, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• contractoremail (type: esriFieldTypeString, alias: Contractor Email, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• contractorlicnum (type: esriFieldTypeString, alias: Contractor License Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• contractorphone (type: esriFieldTypeString, alias: Contractor Phone, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• contractorzip (type: esriFieldTypeString, alias: Contractor Zip, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• countylocation (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• description (type: esriFieldTypeString, alias: description, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• expirednewpermnum (type: esriFieldTypeString, alias: New Expired Permit Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• expiresdate (type: esriFieldTypeDate, alias: Expiration Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• fee (type: esriFieldTypeInteger, alias: fee, SQL Type: sqlTypeOther, nullable: true, editable: true)
• fiscalyear (type: esriFieldTypeString, alias: Fiscal Year, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• govtownedprop (type: esriFieldTypeInteger, alias: Government Owned Property, SQL Type: sqlTypeOther, nullable: true, editable: true)
• grouptenantname (type: esriFieldTypeString, alias: Group Tenant Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• housingunitstotal (type: esriFieldTypeInteger, alias: Total Housing Units, SQL Type: sqlTypeOther, nullable: true, editable: true)
• housingunitsexist (type: esriFieldTypeInteger, alias: Existing Housing Units, SQL Type: sqlTypeOther, nullable: true, editable: true)
• issueddate_mth (type: esriFieldTypeInteger, alias: Month Issued, SQL Type: sqlTypeOther, nullable: true, editable: true)
• issueddate_yr (type: esriFieldTypeInteger, alias: Year Issued, SQL Type: sqlTypeOther, nullable: true, editable: true)
• jurisdiction (type: esriFieldTypeString, alias: jurisdiction, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• jurisdiction_atissue (type: esriFieldTypeString, alias: Jurisdiction At Issue, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• jurisdiction_inout_ral (type: esriFieldTypeString, alias: Jurisdiction In Raleigh, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• landusedescription (type: esriFieldTypeString, alias: Landuse Description, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• landusenewuse (type: esriFieldTypeString, alias: Landuse Code, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• latitude_perm (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• longitude_perm (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• mapsheet (type: esriFieldTypeString, alias: Map Sheet, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• numberstories (type: esriFieldTypeInteger, alias: Stories, SQL Type: sqlTypeOther, nullable: true, editable: true)
• originaladdress1 (type: esriFieldTypeString, alias: Original Address 1, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• originaladdress2 (type: esriFieldTypeString, alias: Original Address 2, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• originalcity (type: esriFieldTypeString, alias: Original City, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• originalstate (type: esriFieldTypeString, alias: Original State, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• originalzip (type: esriFieldTypeString, alias: Original Zip, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• parc_open_space_zone_fee (type: esriFieldTypeInteger, alias: Open Space Zone Fee, SQL Type: sqlTypeOther, nullable: true, editable: true)
• parcelownername (type: esriFieldTypeString, alias: Parcel Owner Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• parcelowneraddress1 (type: esriFieldTypeString, alias: Parcel Owner Address 1, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• parcelowneraddress2 (type: esriFieldTypeString, alias: Parcel Owner Address 2, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• perm_comments (type: esriFieldTypeString, alias: Permit Comments, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• permittype (type: esriFieldTypeString, alias: Permit Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• pin (type: esriFieldTypeString, alias: PIN #, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• projectname (type: esriFieldTypeString, alias: Project Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• proposeduse (type: esriFieldTypeString, alias: Proposed Use, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• publisher (type: esriFieldTypeString, alias: publisher, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• recordupdatedate (type: esriFieldTypeDate, alias: Record Updated, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• reviewercomments (type: esriFieldTypeString, alias: Reviewer Comments, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• statelicnum (type: esriFieldTypeString, alias: State License Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• statuscurrent (type: esriFieldTypeString, alias: Current Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• statuscurrentmapped (type: esriFieldTypeString, alias: Current Status Mapped, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• streetnum (type: esriFieldTypeString, alias: Street Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• streetdirectionprefix (type: esriFieldTypeString, alias: Street Direction Prefix, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• streetname (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• streetdirectionsuffix (type: esriFieldTypeString, alias: streetdirectionsuffix, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• streettype (type: esriFieldTypeString, alias: streettype, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• totalsqft (type: esriFieldTypeInteger, alias: Total Square Footage, SQL Type: sqlTypeOther, nullable: true, editable: true)
• voiddate (type: esriFieldTypeDate, alias: Void Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• workclassmapped (type: esriFieldTypeString, alias: Work Class Mapped, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• const_type (type: esriFieldTypeString, alias: Construction Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• occupancyclass (type: esriFieldTypeString, alias: Occupancy Class, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• permitnum (type: esriFieldTypeString, alias: Permit Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)

Templates:

Name: Building Permits
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/10/2025 11:06:29 AM

Schema Last Edit Date: 8/10/2025 11:06:29 AM

Data Last Edit Date: 8/10/2025 11:06:29 AM

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