Name: Project_Main

Display Field: PROJECT_NAME

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 )
• PROJECT_NO ( type: esriFieldTypeString, alias: PROJECT_NO, editable: true, nullable: false, length: 30, defaultValue: null, modelName: PROJECT_NO )
• PROJECT_NAME ( type: esriFieldTypeString, alias: PROJECT_NAME, editable: true, nullable: true, length: 60, defaultValue: null, modelName: PROJECT_NAME )
• PROJECTTYPE ( type: esriFieldTypeString, alias: PROJECTTYPE, editable: true, nullable: true, length: 60, defaultValue: null, modelName: PROJECTTYPE )
• PROJECTSUBTYPE ( type: esriFieldTypeString, alias: PROJECTSUBTYPE, editable: true, nullable: true, length: 60, defaultValue: null, modelName: PROJECTSUBTYPE )
• PRIMARY_PIN ( type: esriFieldTypeString, alias: PRIMARY_PIN, editable: true, nullable: true, length: 15, defaultValue: null, modelName: PRIMARY_PIN )
• SITE_APN ( type: esriFieldTypeString, alias: SITE_APN, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SITE_APN )
• SITE_OWNER ( type: esriFieldTypeString, alias: SITE_OWNER, editable: true, nullable: true, length: 40, defaultValue: null, modelName: SITE_OWNER )
• SITE_ADDR ( type: esriFieldTypeString, alias: SITE_ADDR, editable: true, nullable: true, length: 85, defaultValue: null, modelName: SITE_ADDR )
• SITE_STREETID ( type: esriFieldTypeInteger, alias: SITE_STREETID, editable: true, nullable: true, defaultValue: null, modelName: SITE_STREETID )
• SITE_NUMBER ( type: esriFieldTypeString, alias: SITE_NUMBER, editable: true, nullable: true, length: 12, defaultValue: null, modelName: SITE_NUMBER )
• 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_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 )
• ZONING ( type: esriFieldTypeString, alias: ZONING, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ZONING )
• GENPLAN ( type: esriFieldTypeString, alias: GENPLAN, editable: true, nullable: true, length: 20, defaultValue: null, modelName: GENPLAN )
• LAND_USE ( type: esriFieldTypeString, alias: LAND_USE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LAND_USE )
• FEES_CHARGED ( type: esriFieldTypeDouble, alias: FEES_CHARGED, editable: true, nullable: true, defaultValue: null, modelName: FEES_CHARGED )
• 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 )
• PROJECT_LOC ( type: esriFieldTypeString, alias: PROJECT_LOC, editable: true, nullable: true, length: 200, defaultValue: null, modelName: PROJECT_LOC )
• PLANNER ( type: esriFieldTypeString, alias: PLANNER, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PLANNER )
• DESCRIPTION ( type: esriFieldTypeString, alias: DESCRIPTION, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: DESCRIPTION )
• 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 )
• CLOSED ( type: esriFieldTypeDate, alias: CLOSED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CLOSED )
• CLOSED_BY ( type: esriFieldTypeString, alias: CLOSED_BY, editable: true, nullable: true, length: 6, defaultValue: null, modelName: CLOSED_BY )
• STATUS ( type: esriFieldTypeString, alias: STATUS, editable: true, nullable: true, length: 60, defaultValue: null, modelName: STATUS )
• STATUS_BY ( type: esriFieldTypeString, alias: STATUS_BY, editable: true, nullable: true, length: 6, defaultValue: null, modelName: STATUS_BY )
• STATUS_DATE ( type: esriFieldTypeDate, alias: STATUS_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: STATUS_DATE )
• RESOLUTION_NO ( type: esriFieldTypeString, alias: RESOLUTION_NO, editable: true, nullable: true, length: 12, defaultValue: null, modelName: RESOLUTION_NO )
• PARENT_PROJECT_NO ( type: esriFieldTypeString, alias: PARENT_PROJECT_NO, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PARENT_PROJECT_NO )
• 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 )
• 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 )
• DEVELOPER_NAME ( type: esriFieldTypeString, alias: DEVELOPER_NAME, editable: true, nullable: true, length: 60, defaultValue: null, modelName: DEVELOPER_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 )
• 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 )
• CONTRACTOR_NAME ( type: esriFieldTypeString, alias: CONTRACTOR_NAME, editable: true, nullable: true, length: 60, defaultValue: null, modelName: CONTRACTOR_NAME )
• REFERENCE_NO ( type: esriFieldTypeString, alias: REFERENCE_NO, editable: true, nullable: true, length: 30, defaultValue: null, modelName: REFERENCE_NO )
• 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 )
• 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: Project_Main
  Description:
  Prototype:
  Unique_Key: null
  PREFIX: null
  YRMO: null
  SEQ_NO: null
  PROJECT_NO:
  PROJECT_NAME: null
  PROJECTTYPE: null
  PROJECTSUBTYPE: null
  PRIMARY_PIN: null
  SITE_APN: null
  SITE_OWNER: null
  SITE_ADDR: null
  SITE_STREETID: null
  SITE_NUMBER: null
  SITE_STREETNAME: null
  SITE_UNIT_NO: null
  SITE_CITY: null
  SITE_STATE: null
  SITE_ZIP: null
  SITE_LOT_NO: null
  SITE_BLOCK: null
  SITE_TRACT: null
  SITE_SUBDIVISION: null
  SITE_DESCRIPTION: null
  ZONING: null
  GENPLAN: null
  LAND_USE: null
  FEES_CHARGED: null
  FEES_PAID: null
  BALANCE_DUE: null
  PROJECT_LOC: null
  PLANNER: null
  DESCRIPTION: null
  APPLIED: null
  APPLIED_BY: null
  APPROVED: null
  APPROVED_BY: null
  CLOSED: null
  CLOSED_BY: null
  STATUS: null
  STATUS_BY: null
  STATUS_DATE: null
  RESOLUTION_NO: null
  PARENT_PROJECT_NO: null
  EXPIRED: null
  EXPIRED_BY: null
  OTHER_DATE1: null
  OTHER_BY1: null
  OWNER_NAME: null
  APPLICANT_NAME: null
  DEVELOPER_NAME: null
  RECORDID: null
  LOCKID: null
  LOC_RECORDID: null
  DEPOSITTYPE: null
  HISTORICAL_APN: null
  CONTRACTOR_NAME: null
  REFERENCE_NO: 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
  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