Name: Project_Main

Display Field: PROJECT_NAME

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 576da40e77a843c7a093f7b549286cad

Copyright Text:

Default Visibility: false

Max Result Window: N/A

Max Record Count: 2000

Standard Max Record Count No Geometry: N/A

Max Record Count Factor: 1

Standard MaxRecord Count: 32000

Tile Max Record Count: 2000

MaxSelectionCount: 0

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

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports Result Pagination Token: false
Supports TrueCurve: false
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 Cache Hint: false
Supports Query With Current User: true
Supports Query With Result Type: true

HasZ: false

HasM: false

Has Attachments: false

Has Last Edit Time: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• PREFIX ( modelName: PREFIX, nullable: true, editable: true, defaultValue: N/A, length: 6, alias: PREFIX, type: esriFieldTypeString )
• YRMO ( modelName: YRMO, nullable: true, editable: true, defaultValue: N/A, alias: YRMO, type: esriFieldTypeDouble )
• SEQ_NO ( modelName: SEQ_NO, nullable: true, editable: true, defaultValue: N/A, alias: SEQ_NO, type: esriFieldTypeDouble )
• PROJECT_NO ( modelName: PROJECT_NO, nullable: false, editable: true, defaultValue: N/A, length: 30, alias: PROJECT_NO, type: esriFieldTypeString )
• PROJECT_NAME ( modelName: PROJECT_NAME, nullable: true, editable: true, defaultValue: N/A, length: 60, alias: PROJECT_NAME, type: esriFieldTypeString )
• PROJECTTYPE ( modelName: PROJECTTYPE, nullable: true, editable: true, defaultValue: N/A, length: 60, alias: PROJECTTYPE, type: esriFieldTypeString )
• PROJECTSUBTYPE ( modelName: PROJECTSUBTYPE, nullable: true, editable: true, defaultValue: N/A, length: 60, alias: PROJECTSUBTYPE, type: esriFieldTypeString )
• PRIMARY_PIN ( modelName: PRIMARY_PIN, nullable: true, editable: true, defaultValue: N/A, length: 15, alias: PRIMARY_PIN, type: esriFieldTypeString )
• SITE_APN ( modelName: SITE_APN, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: SITE_APN, type: esriFieldTypeString )
• SITE_OWNER ( modelName: SITE_OWNER, nullable: true, editable: true, defaultValue: N/A, length: 40, alias: SITE_OWNER, type: esriFieldTypeString )
• SITE_ADDR ( modelName: SITE_ADDR, nullable: true, editable: true, defaultValue: N/A, length: 85, alias: SITE_ADDR, type: esriFieldTypeString )
• SITE_STREETID ( modelName: SITE_STREETID, nullable: true, editable: true, defaultValue: N/A, alias: SITE_STREETID, type: esriFieldTypeInteger )
• SITE_NUMBER ( modelName: SITE_NUMBER, nullable: true, editable: true, defaultValue: N/A, length: 12, alias: SITE_NUMBER, type: esriFieldTypeString )
• SITE_STREETNAME ( modelName: SITE_STREETNAME, nullable: true, editable: true, defaultValue: N/A, length: 60, alias: SITE_STREETNAME, type: esriFieldTypeString )
• SITE_UNIT_NO ( modelName: SITE_UNIT_NO, nullable: true, editable: true, defaultValue: N/A, length: 10, alias: SITE_UNIT_NO, type: esriFieldTypeString )
• SITE_CITY ( modelName: SITE_CITY, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: SITE_CITY, type: esriFieldTypeString )
• SITE_STATE ( modelName: SITE_STATE, nullable: true, editable: true, defaultValue: N/A, length: 2, alias: SITE_STATE, type: esriFieldTypeString )
• SITE_ZIP ( modelName: SITE_ZIP, nullable: true, editable: true, defaultValue: N/A, length: 10, alias: SITE_ZIP, type: esriFieldTypeString )
• SITE_LOT_NO ( modelName: SITE_LOT_NO, nullable: true, editable: true, defaultValue: N/A, length: 20, alias: SITE_LOT_NO, type: esriFieldTypeString )
• SITE_BLOCK ( modelName: SITE_BLOCK, nullable: true, editable: true, defaultValue: N/A, length: 10, alias: SITE_BLOCK, type: esriFieldTypeString )
• SITE_TRACT ( modelName: SITE_TRACT, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: SITE_TRACT, type: esriFieldTypeString )
• SITE_SUBDIVISION ( modelName: SITE_SUBDIVISION, nullable: true, editable: true, defaultValue: N/A, length: 100, alias: SITE_SUBDIVISION, type: esriFieldTypeString )
• SITE_DESCRIPTION ( modelName: SITE_DESCRIPTION, nullable: true, editable: true, defaultValue: N/A, length: 2000, alias: SITE_DESCRIPTION, type: esriFieldTypeString )
• ZONING ( modelName: ZONING, nullable: true, editable: true, defaultValue: N/A, length: 20, alias: ZONING, type: esriFieldTypeString )
• GENPLAN ( modelName: GENPLAN, nullable: true, editable: true, defaultValue: N/A, length: 20, alias: GENPLAN, type: esriFieldTypeString )
• LAND_USE ( modelName: LAND_USE, nullable: true, editable: true, defaultValue: N/A, length: 20, alias: LAND_USE, type: esriFieldTypeString )
• FEES_CHARGED ( modelName: FEES_CHARGED, nullable: true, editable: true, defaultValue: N/A, alias: FEES_CHARGED, type: esriFieldTypeDouble )
• FEES_PAID ( modelName: FEES_PAID, nullable: true, editable: true, defaultValue: N/A, alias: FEES_PAID, type: esriFieldTypeDouble )
• BALANCE_DUE ( modelName: BALANCE_DUE, nullable: true, editable: true, defaultValue: N/A, alias: BALANCE_DUE, type: esriFieldTypeDouble )
• PROJECT_LOC ( modelName: PROJECT_LOC, nullable: true, editable: true, defaultValue: N/A, length: 200, alias: PROJECT_LOC, type: esriFieldTypeString )
• PLANNER ( modelName: PLANNER, nullable: true, editable: true, defaultValue: N/A, length: 20, alias: PLANNER, type: esriFieldTypeString )
• DESCRIPTION ( modelName: DESCRIPTION, nullable: true, editable: true, defaultValue: N/A, length: 2000, alias: DESCRIPTION, type: esriFieldTypeString )
• APPLIED ( modelName: APPLIED, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: APPLIED, type: esriFieldTypeDate )
• APPLIED_BY ( modelName: APPLIED_BY, nullable: true, editable: true, defaultValue: N/A, length: 6, alias: APPLIED_BY, type: esriFieldTypeString )
• APPROVED ( modelName: APPROVED, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: APPROVED, type: esriFieldTypeDate )
• APPROVED_BY ( modelName: APPROVED_BY, nullable: true, editable: true, defaultValue: N/A, length: 6, alias: APPROVED_BY, type: esriFieldTypeString )
• CLOSED ( modelName: CLOSED, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: CLOSED, type: esriFieldTypeDate )
• CLOSED_BY ( modelName: CLOSED_BY, nullable: true, editable: true, defaultValue: N/A, length: 6, alias: CLOSED_BY, type: esriFieldTypeString )
• STATUS ( modelName: STATUS, nullable: true, editable: true, defaultValue: N/A, length: 60, alias: STATUS, type: esriFieldTypeString )
• STATUS_BY ( modelName: STATUS_BY, nullable: true, editable: true, defaultValue: N/A, length: 6, alias: STATUS_BY, type: esriFieldTypeString )
• STATUS_DATE ( modelName: STATUS_DATE, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: STATUS_DATE, type: esriFieldTypeDate )
• RESOLUTION_NO ( modelName: RESOLUTION_NO, nullable: true, editable: true, defaultValue: N/A, length: 12, alias: RESOLUTION_NO, type: esriFieldTypeString )
• PARENT_PROJECT_NO ( modelName: PARENT_PROJECT_NO, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: PARENT_PROJECT_NO, type: esriFieldTypeString )
• EXPIRED ( modelName: EXPIRED, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: EXPIRED, type: esriFieldTypeDate )
• EXPIRED_BY ( modelName: EXPIRED_BY, nullable: true, editable: true, defaultValue: N/A, length: 6, alias: EXPIRED_BY, type: esriFieldTypeString )
• OTHER_DATE1 ( modelName: OTHER_DATE1, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: OTHER_DATE1, type: esriFieldTypeDate )
• OTHER_BY1 ( modelName: OTHER_BY1, nullable: true, editable: true, defaultValue: N/A, length: 6, alias: OTHER_BY1, type: esriFieldTypeString )
• OWNER_NAME ( modelName: OWNER_NAME, nullable: true, editable: true, defaultValue: N/A, length: 60, alias: OWNER_NAME, type: esriFieldTypeString )
• APPLICANT_NAME ( modelName: APPLICANT_NAME, nullable: true, editable: true, defaultValue: N/A, length: 60, alias: APPLICANT_NAME, type: esriFieldTypeString )
• DEVELOPER_NAME ( modelName: DEVELOPER_NAME, nullable: true, editable: true, defaultValue: N/A, length: 60, alias: DEVELOPER_NAME, type: esriFieldTypeString )
• RECORDID ( modelName: RECORDID, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: RECORDID, type: esriFieldTypeString )
• LOCKID ( modelName: LOCKID, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: LOCKID, type: esriFieldTypeString )
• LOC_RECORDID ( modelName: LOC_RECORDID, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: LOC_RECORDID, type: esriFieldTypeString )
• DEPOSITTYPE ( modelName: DEPOSITTYPE, nullable: true, editable: true, defaultValue: N/A, length: 60, alias: DEPOSITTYPE, type: esriFieldTypeString )
• HISTORICAL_APN ( modelName: HISTORICAL_APN, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: HISTORICAL_APN, type: esriFieldTypeString )
• CONTRACTOR_NAME ( modelName: CONTRACTOR_NAME, nullable: true, editable: true, defaultValue: N/A, length: 60, alias: CONTRACTOR_NAME, type: esriFieldTypeString )
• REFERENCE_NO ( modelName: REFERENCE_NO, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: REFERENCE_NO, type: esriFieldTypeString )
• SITE_ALTERNATE_ID ( modelName: SITE_ALTERNATE_ID, nullable: true, editable: true, defaultValue: N/A, length: 40, alias: SITE_ALTERNATE_ID, type: esriFieldTypeString )
• SITE_GEOTYPE ( modelName: SITE_GEOTYPE, nullable: true, editable: true, defaultValue: N/A, length: 60, alias: SITE_GEOTYPE, type: esriFieldTypeString )
• Parent_Generic1_ActivityNo ( modelName: Parent_Generic1_ActivityNo, nullable: true, editable: true, defaultValue: N/A, length: 15, alias: Parent_Generic1_ActivityNo, type: esriFieldTypeString )
• Parent_Generic2_ActivityNo ( modelName: Parent_Generic2_ActivityNo, nullable: true, editable: true, defaultValue: N/A, length: 15, alias: Parent_Generic2_ActivityNo, type: esriFieldTypeString )
• Parent_Generic3_ActivityNo ( modelName: Parent_Generic3_ActivityNo, nullable: true, editable: true, defaultValue: N/A, length: 15, alias: Parent_Generic3_ActivityNo, type: esriFieldTypeString )
• Parent_Generic4_ActivityNo ( modelName: Parent_Generic4_ActivityNo, nullable: true, editable: true, defaultValue: N/A, length: 15, alias: Parent_Generic4_ActivityNo, type: esriFieldTypeString )
• Parent_Generic5_ActivityNo ( modelName: Parent_Generic5_ActivityNo, nullable: true, editable: true, defaultValue: N/A, length: 15, alias: Parent_Generic5_ActivityNo, type: esriFieldTypeString )
• TSstatus ( modelName: TSstatus, nullable: true, editable: true, defaultValue: N/A, alias: TSstatus, type: esriFieldTypeInteger )
• ActivityTypeID ( modelName: ActivityTypeID, nullable: false, editable: true, defaultValue: N/A, alias: ActivityTypeID, type: esriFieldTypeInteger )
• Unique_Key ( modelName: Unique_Key, nullable: true, editable: true, defaultValue: N/A, length: 38, alias: Unique_Key, type: esriFieldTypeGUID )
• RowNum ( modelName: RowNum, nullable: false, editable: false, defaultValue: N/A, alias: RowNum, type: esriFieldTypeOID )

Templates:

• Name: Project_Main
  Description:
  Prototype:
  PROJECTSUBTYPE: null
  CONTRACTOR_NAME: null
  SITE_DESCRIPTION: null
  SITE_STREETNAME: null
  STATUS: null
  SITE_STREETID: null
  SITE_ALTERNATE_ID: null
  SITE_TRACT: null
  LOC_RECORDID: null
  Parent_Generic4_ActivityNo: null
  APPROVED_BY: null
  ActivityTypeID: 0
  PRIMARY_PIN: null
  STATUS_DATE: null
  Parent_Generic1_ActivityNo: null
  RECORDID: null
  LOCKID: null
  DEVELOPER_NAME: null
  Parent_Generic3_ActivityNo: null
  PREFIX: null
  PROJECT_NO:
  PROJECT_LOC: null
  HISTORICAL_APN: null
  SITE_SUBDIVISION: null
  PARENT_PROJECT_NO: null
  LAND_USE: null
  Parent_Generic2_ActivityNo: null
  CLOSED: null
  OTHER_BY1: null
  APPLICANT_NAME: null
  SITE_UNIT_NO: null
  APPLIED_BY: null
  EXPIRED: null
  PROJECT_NAME: null
  Parent_Generic5_ActivityNo: null
  GENPLAN: null
  DEPOSITTYPE: null
  YRMO: null
  SITE_BLOCK: null
  SEQ_NO: null
  DESCRIPTION: null
  OWNER_NAME: null
  CLOSED_BY: null
  Unique_Key: null
  SITE_NUMBER: null
  SITE_LOT_NO: null
  BALANCE_DUE: null
  APPLIED: null
  SITE_STATE: null
  SITE_ADDR: null
  EXPIRED_BY: null
  OTHER_DATE1: null
  TSstatus: null
  FEES_CHARGED: null
  FEES_PAID: null
  PLANNER: null
  SITE_CITY: null
  RESOLUTION_NO: null
  PROJECTTYPE: null
  SITE_GEOTYPE: null
  SITE_ZIP: null
  STATUS_BY: null
  ZONING: null
  SITE_OWNER: null
  APPROVED: null
  REFERENCE_NO: null
  SITE_APN: null
  
  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:

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