Name: Permit_Main

Display Field: SITE_STREETNAME

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 576da40e77a843c7a093f7b549286cad

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• PREFIX ( type: esriFieldTypeString, alias: PREFIX, editable: true, nullable: true, length: 6, defaultValue: null, modelName: PREFIX )
• YRMO ( type: esriFieldTypeDouble, alias: YRMO, editable: true, nullable: true, defaultValue: null, modelName: YRMO )
• SEQ_NO ( type: esriFieldTypeDouble, alias: SEQ_NO, editable: true, nullable: true, defaultValue: null, modelName: SEQ_NO )
• PERMIT_NO ( type: esriFieldTypeString, alias: PERMIT_NO, editable: true, nullable: false, length: 30, defaultValue: null, modelName: PERMIT_NO )
• APPLICATION_NO ( type: esriFieldTypeString, alias: APPLICATION_NO, editable: true, nullable: true, length: 15, defaultValue: null, modelName: APPLICATION_NO )
• PLANCHECK_NO ( type: esriFieldTypeString, alias: PLANCHECK_NO, editable: true, nullable: true, length: 15, defaultValue: null, modelName: PLANCHECK_NO )
• REFERENCE_NO ( type: esriFieldTypeString, alias: REFERENCE_NO, editable: true, nullable: true, length: 15, defaultValue: null, modelName: REFERENCE_NO )
• APPLIED ( type: esriFieldTypeDate, alias: APPLIED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: APPLIED )
• APPLIED_BY ( type: esriFieldTypeString, alias: APPLIED_BY, editable: true, nullable: true, length: 6, defaultValue: null, modelName: APPLIED_BY )
• APPROVED ( type: esriFieldTypeDate, alias: APPROVED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: APPROVED )
• APPROVED_BY ( type: esriFieldTypeString, alias: APPROVED_BY, editable: true, nullable: true, length: 6, defaultValue: null, modelName: APPROVED_BY )
• ISSUED ( type: esriFieldTypeDate, alias: ISSUED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ISSUED )
• ISSUED_BY ( type: esriFieldTypeString, alias: ISSUED_BY, editable: true, nullable: true, length: 6, defaultValue: null, modelName: ISSUED_BY )
• FINALED ( type: esriFieldTypeDate, alias: FINALED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FINALED )
• FINALED_BY ( type: esriFieldTypeString, alias: FINALED_BY, editable: true, nullable: true, length: 6, defaultValue: null, modelName: FINALED_BY )
• EXPIRED ( type: esriFieldTypeDate, alias: EXPIRED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EXPIRED )
• EXPIRED_BY ( type: esriFieldTypeString, alias: EXPIRED_BY, editable: true, nullable: true, length: 6, defaultValue: null, modelName: EXPIRED_BY )
• VALID_FOR ( type: esriFieldTypeDouble, alias: VALID_FOR, editable: true, nullable: true, defaultValue: null, modelName: VALID_FOR )
• PARENT_PROJECT_NO ( type: esriFieldTypeString, alias: PARENT_PROJECT_NO, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PARENT_PROJECT_NO )
• PARENT_PERMIT_NO ( type: esriFieldTypeString, alias: PARENT_PERMIT_NO, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PARENT_PERMIT_NO )
• PermitType ( type: esriFieldTypeString, alias: PermitType, editable: true, nullable: true, length: 60, defaultValue: null, modelName: PermitType )
• PermitSubType ( type: esriFieldTypeString, alias: PermitSubType, editable: true, nullable: true, length: 60, defaultValue: null, modelName: PermitSubType )
• STATUS ( type: esriFieldTypeString, alias: STATUS, editable: true, nullable: true, length: 60, defaultValue: null, modelName: STATUS )
• OCCUPANCY_TYPE ( type: esriFieldTypeString, alias: OCCUPANCY_TYPE, editable: true, nullable: true, length: 60, defaultValue: null, modelName: OCCUPANCY_TYPE )
• GROUPCODE ( type: esriFieldTypeString, alias: GROUPCODE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: GROUPCODE )
• ZONING_CODE1 ( type: esriFieldTypeString, alias: ZONING_CODE1, editable: true, nullable: true, length: 12, defaultValue: null, modelName: ZONING_CODE1 )
• ZONING_CODE2 ( type: esriFieldTypeString, alias: ZONING_CODE2, editable: true, nullable: true, length: 12, defaultValue: null, modelName: ZONING_CODE2 )
• CONST_TYPE ( type: esriFieldTypeString, alias: CONST_TYPE, editable: true, nullable: true, length: 60, defaultValue: null, modelName: CONST_TYPE )
• SITE_LOT_NO ( type: esriFieldTypeString, alias: SITE_LOT_NO, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SITE_LOT_NO )
• SITE_BLOCK ( type: esriFieldTypeString, alias: SITE_BLOCK, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SITE_BLOCK )
• SITE_TRACT ( type: esriFieldTypeString, alias: SITE_TRACT, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SITE_TRACT )
• SITE_SUBDIVISION ( type: esriFieldTypeString, alias: SITE_SUBDIVISION, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SITE_SUBDIVISION )
• SITE_DESCRIPTION ( type: esriFieldTypeString, alias: SITE_DESCRIPTION, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: SITE_DESCRIPTION )
• TAX_RATE_AREA ( type: esriFieldTypeString, alias: TAX_RATE_AREA, editable: true, nullable: true, length: 10, defaultValue: null, modelName: TAX_RATE_AREA )
• SCHOOL ( type: esriFieldTypeString, alias: SCHOOL, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SCHOOL )
• CENSUS ( type: esriFieldTypeString, alias: CENSUS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CENSUS )
• FWDODGE ( type: esriFieldTypeString, alias: FWDODGE, editable: true, nullable: true, length: 6, defaultValue: null, modelName: FWDODGE )
• SITE_APN ( type: esriFieldTypeString, alias: SITE_APN, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SITE_APN )
• SITE_ADDR ( type: esriFieldTypeString, alias: SITE_ADDR, editable: true, nullable: true, length: 85, defaultValue: null, modelName: SITE_ADDR )
• SITE_NUMBER ( type: esriFieldTypeString, alias: SITE_NUMBER, editable: true, nullable: true, length: 12, defaultValue: null, modelName: SITE_NUMBER )
• SITE_STREETID ( type: esriFieldTypeDouble, alias: SITE_STREETID, editable: true, nullable: true, defaultValue: null, modelName: SITE_STREETID )
• SITE_STREETNAME ( type: esriFieldTypeString, alias: SITE_STREETNAME, editable: true, nullable: true, length: 60, defaultValue: null, modelName: SITE_STREETNAME )
• SITE_UNIT_NO ( type: esriFieldTypeString, alias: SITE_UNIT_NO, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SITE_UNIT_NO )
• SITE_CITY ( type: esriFieldTypeString, alias: SITE_CITY, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SITE_CITY )
• SITE_STATE ( type: esriFieldTypeString, alias: SITE_STATE, editable: true, nullable: true, length: 2, defaultValue: null, modelName: SITE_STATE )
• SITE_ZIP ( type: esriFieldTypeString, alias: SITE_ZIP, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SITE_ZIP )
• SITE_ST_NO ( type: esriFieldTypeString, alias: SITE_ST_NO, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SITE_ST_NO )
• LOCATION_DESC ( type: esriFieldTypeString, alias: LOCATION_DESC, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: LOCATION_DESC )
• DESCRIPTION ( type: esriFieldTypeString, alias: DESCRIPTION, editable: true, nullable: true, length: 60, defaultValue: null, modelName: DESCRIPTION )
• NOTES ( type: esriFieldTypeString, alias: NOTES, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: NOTES )
• LOT_SF ( type: esriFieldTypeDouble, alias: LOT_SF, editable: true, nullable: true, defaultValue: null, modelName: LOT_SF )
• BLDG_SF ( type: esriFieldTypeDouble, alias: BLDG_SF, editable: true, nullable: true, defaultValue: null, modelName: BLDG_SF )
• BLDG2_SF ( type: esriFieldTypeDouble, alias: BLDG2_SF, editable: true, nullable: true, defaultValue: null, modelName: BLDG2_SF )
• GAR_SF ( type: esriFieldTypeDouble, alias: GAR_SF, editable: true, nullable: true, defaultValue: null, modelName: GAR_SF )
• GAR2_SF ( type: esriFieldTypeDouble, alias: GAR2_SF, editable: true, nullable: true, defaultValue: null, modelName: GAR2_SF )
• PORCH_SF ( type: esriFieldTypeDouble, alias: PORCH_SF, editable: true, nullable: true, defaultValue: null, modelName: PORCH_SF )
• PORCH2_SF ( type: esriFieldTypeDouble, alias: PORCH2_SF, editable: true, nullable: true, defaultValue: null, modelName: PORCH2_SF )
• HEIGHT ( type: esriFieldTypeDouble, alias: HEIGHT, editable: true, nullable: true, defaultValue: null, modelName: HEIGHT )
• NO_STORIES ( type: esriFieldTypeDouble, alias: NO_STORIES, editable: true, nullable: true, defaultValue: null, modelName: NO_STORIES )
• NO_UNITS ( type: esriFieldTypeDouble, alias: NO_UNITS, editable: true, nullable: true, defaultValue: null, modelName: NO_UNITS )
• NO_BLDGS ( type: esriFieldTypeDouble, alias: NO_BLDGS, editable: true, nullable: true, defaultValue: null, modelName: NO_BLDGS )
• JOBVALUE ( type: esriFieldTypeDouble, alias: JOBVALUE, editable: true, nullable: true, defaultValue: null, modelName: JOBVALUE )
• FEES_CHARGED ( type: esriFieldTypeDouble, alias: FEES_CHARGED, editable: true, nullable: true, defaultValue: null, modelName: FEES_CHARGED )
• FEE_ADJUSTMENTS ( type: esriFieldTypeDouble, alias: FEE_ADJUSTMENTS, editable: true, nullable: true, defaultValue: null, modelName: FEE_ADJUSTMENTS )
• FEES_PAID ( type: esriFieldTypeDouble, alias: FEES_PAID, editable: true, nullable: true, defaultValue: null, modelName: FEES_PAID )
• BALANCE_DUE ( type: esriFieldTypeDouble, alias: BALANCE_DUE, editable: true, nullable: true, defaultValue: null, modelName: BALANCE_DUE )
• OTHER_DATE1 ( type: esriFieldTypeDate, alias: OTHER_DATE1, editable: true, nullable: true, length: 8, defaultValue: null, modelName: OTHER_DATE1 )
• OTHER_BY1 ( type: esriFieldTypeString, alias: OTHER_BY1, editable: true, nullable: true, length: 6, defaultValue: null, modelName: OTHER_BY1 )
• OWNER_NAME ( type: esriFieldTypeString, alias: OWNER_NAME, editable: true, nullable: true, length: 60, defaultValue: null, modelName: OWNER_NAME )
• APPLICANT_NAME ( type: esriFieldTypeString, alias: APPLICANT_NAME, editable: true, nullable: true, length: 60, defaultValue: null, modelName: APPLICANT_NAME )
• CONTRACTOR_NAME ( type: esriFieldTypeString, alias: CONTRACTOR_NAME, editable: true, nullable: true, length: 60, defaultValue: null, modelName: CONTRACTOR_NAME )
• RECORDID ( type: esriFieldTypeString, alias: RECORDID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: RECORDID )
• LOCKID ( type: esriFieldTypeString, alias: LOCKID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: LOCKID )
• LOC_RECORDID ( type: esriFieldTypeString, alias: LOC_RECORDID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: LOC_RECORDID )
• PIN ( type: esriFieldTypeInteger, alias: PIN, editable: true, nullable: true, defaultValue: null, modelName: PIN )
• DEPOSITTYPE ( type: esriFieldTypeString, alias: DEPOSITTYPE, editable: true, nullable: true, length: 60, defaultValue: null, modelName: DEPOSITTYPE )
• HISTORICAL_APN ( type: esriFieldTypeString, alias: HISTORICAL_APN, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HISTORICAL_APN )
• SITE_ALTERNATE_ID ( type: esriFieldTypeString, alias: SITE_ALTERNATE_ID, editable: true, nullable: true, length: 40, defaultValue: null, modelName: SITE_ALTERNATE_ID )
• SITE_GEOTYPE ( type: esriFieldTypeString, alias: SITE_GEOTYPE, editable: true, nullable: true, length: 60, defaultValue: null, modelName: SITE_GEOTYPE )
• Parent_Generic1_ActivityNo ( type: esriFieldTypeString, alias: Parent_Generic1_ActivityNo, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Parent_Generic1_ActivityNo )
• Parent_Generic2_ActivityNo ( type: esriFieldTypeString, alias: Parent_Generic2_ActivityNo, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Parent_Generic2_ActivityNo )
• Parent_Generic3_ActivityNo ( type: esriFieldTypeString, alias: Parent_Generic3_ActivityNo, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Parent_Generic3_ActivityNo )
• Parent_Generic4_ActivityNo ( type: esriFieldTypeString, alias: Parent_Generic4_ActivityNo, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Parent_Generic4_ActivityNo )
• Parent_Generic5_ActivityNo ( type: esriFieldTypeString, alias: Parent_Generic5_ActivityNo, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Parent_Generic5_ActivityNo )
• PARENT_BUS_LIC_NO ( type: esriFieldTypeString, alias: PARENT_BUS_LIC_NO, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PARENT_BUS_LIC_NO )
• TSstatus ( type: esriFieldTypeInteger, alias: TSstatus, editable: true, nullable: true, defaultValue: null, modelName: TSstatus )
• ActivityTypeID ( type: esriFieldTypeInteger, alias: ActivityTypeID, editable: true, nullable: false, defaultValue: null, modelName: ActivityTypeID )
• Unique_Key ( type: esriFieldTypeGUID, alias: Unique_Key, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Unique_Key )
• RowNum ( type: esriFieldTypeOID, alias: RowNum, editable: false, nullable: false, defaultValue: null, modelName: RowNum )

Templates:

• Name: Permit_Main
  Description:
  Prototype:
  Unique_Key: null
  PREFIX: null
  YRMO: null
  SEQ_NO: null
  PERMIT_NO:
  APPLICATION_NO: null
  PLANCHECK_NO: null
  REFERENCE_NO: null
  APPLIED: null
  APPLIED_BY: null
  APPROVED: null
  APPROVED_BY: null
  ISSUED: null
  ISSUED_BY: null
  FINALED: null
  FINALED_BY: null
  EXPIRED: null
  EXPIRED_BY: null
  VALID_FOR: null
  PARENT_PROJECT_NO: null
  PARENT_PERMIT_NO: null
  PermitType: null
  PermitSubType: null
  STATUS: null
  OCCUPANCY_TYPE: null
  GROUPCODE: null
  ZONING_CODE1: null
  ZONING_CODE2: null
  CONST_TYPE: null
  SITE_LOT_NO: null
  SITE_BLOCK: null
  SITE_TRACT: null
  SITE_SUBDIVISION: null
  SITE_DESCRIPTION: null
  TAX_RATE_AREA: null
  SCHOOL: null
  CENSUS: null
  FWDODGE: null
  SITE_APN: null
  SITE_ADDR: null
  SITE_NUMBER: null
  SITE_STREETID: null
  SITE_STREETNAME: null
  SITE_UNIT_NO: null
  SITE_CITY: null
  SITE_STATE: null
  SITE_ZIP: null
  SITE_ST_NO: null
  LOCATION_DESC: null
  DESCRIPTION: null
  NOTES: null
  LOT_SF: null
  BLDG_SF: null
  BLDG2_SF: null
  GAR_SF: null
  GAR2_SF: null
  PORCH_SF: null
  PORCH2_SF: null
  HEIGHT: null
  NO_STORIES: null
  NO_UNITS: null
  NO_BLDGS: null
  JOBVALUE: null
  FEES_CHARGED: null
  FEE_ADJUSTMENTS: null
  FEES_PAID: null
  BALANCE_DUE: null
  OTHER_DATE1: null
  OTHER_BY1: null
  OWNER_NAME: null
  APPLICANT_NAME: null
  CONTRACTOR_NAME: null
  RECORDID: null
  LOCKID: null
  LOC_RECORDID: null
  PIN: null
  DEPOSITTYPE: null
  HISTORICAL_APN: null
  SITE_ALTERNATE_ID: null
  SITE_GEOTYPE: null
  Parent_Generic1_ActivityNo: null
  Parent_Generic2_ActivityNo: null
  Parent_Generic3_ActivityNo: null
  Parent_Generic4_ActivityNo: null
  Parent_Generic5_ActivityNo: null
  PARENT_BUS_LIC_NO: null
  TSstatus: null
  ActivityTypeID: 0
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata