Name: crw_net.dbo.Project_Main
Display Field: PROJECT_NAME
Type: Table
Geometry Type: N/A
Description: null
Copyright Text: N/A
Default Visibility: false
MaxRecordCount: 3000
Supported Query Formats: JSON
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Extent:
Drawing Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field: null
Fields:
-
PREFIX
(
type: esriFieldTypeString, alias: PREFIX, length: 6
)
-
YRMO
(
type: esriFieldTypeDouble, alias: YRMO
)
-
SEQ_NO
(
type: esriFieldTypeDouble, alias: SEQ_NO
)
-
PROJECT_NO
(
type: esriFieldTypeString, alias: PROJECT_NO, length: 15
)
-
PROJECT_NAME
(
type: esriFieldTypeString, alias: PROJECT_NAME, length: 60
)
-
PROJECTTYPE
(
type: esriFieldTypeString, alias: PROJECTTYPE, length: 60
)
-
PROJECTSUBTYPE
(
type: esriFieldTypeString, alias: PROJECTSUBTYPE, length: 60
)
-
PRIMARY_PIN
(
type: esriFieldTypeString, alias: PRIMARY_PIN, length: 15
)
-
SITE_APN
(
type: esriFieldTypeString, alias: SITE_APN, length: 50
)
-
SITE_OWNER
(
type: esriFieldTypeString, alias: SITE_OWNER, length: 40
)
-
SITE_ADDR
(
type: esriFieldTypeString, alias: SITE_ADDR, length: 40
)
-
SITE_STREETID
(
type: esriFieldTypeInteger, alias: SITE_STREETID
)
-
SITE_NUMBER
(
type: esriFieldTypeString, alias: SITE_NUMBER, length: 12
)
-
SITE_STREETNAME
(
type: esriFieldTypeString, alias: SITE_STREETNAME, length: 30
)
-
SITE_UNIT_NO
(
type: esriFieldTypeString, alias: SITE_UNIT_NO, length: 10
)
-
SITE_CITY
(
type: esriFieldTypeString, alias: SITE_CITY, length: 30
)
-
SITE_STATE
(
type: esriFieldTypeString, alias: SITE_STATE, length: 2
)
-
SITE_ZIP
(
type: esriFieldTypeString, alias: SITE_ZIP, length: 10
)
-
SITE_LOT_NO
(
type: esriFieldTypeString, alias: SITE_LOT_NO, length: 10
)
-
SITE_BLOCK
(
type: esriFieldTypeString, alias: SITE_BLOCK, length: 10
)
-
SITE_TRACT
(
type: esriFieldTypeString, alias: SITE_TRACT, length: 50
)
-
SITE_SUBDIVISION
(
type: esriFieldTypeString, alias: SITE_SUBDIVISION, length: 100
)
-
SITE_DESCRIPTION
(
type: esriFieldTypeString, alias: SITE_DESCRIPTION, length: 2000
)
-
ZONING
(
type: esriFieldTypeString, alias: ZONING, length: 20
)
-
GENPLAN
(
type: esriFieldTypeString, alias: GENPLAN, length: 20
)
-
LAND_USE
(
type: esriFieldTypeString, alias: LAND_USE, length: 20
)
-
FEES_CHARGED
(
type: esriFieldTypeDouble, alias: FEES_CHARGED
)
-
FEES_PAID
(
type: esriFieldTypeDouble, alias: FEES_PAID
)
-
BALANCE_DUE
(
type: esriFieldTypeDouble, alias: BALANCE_DUE
)
-
PROJECT_LOC
(
type: esriFieldTypeString, alias: PROJECT_LOC, length: 200
)
-
PLANNER
(
type: esriFieldTypeString, alias: PLANNER, length: 20
)
-
DESCRIPTION
(
type: esriFieldTypeString, alias: DESCRIPTION, length: 2000
)
-
APPLIED
(
type: esriFieldTypeDate, alias: APPLIED, length: 8
)
-
APPLIED_BY
(
type: esriFieldTypeString, alias: APPLIED_BY, length: 6
)
-
APPROVED
(
type: esriFieldTypeDate, alias: APPROVED, length: 8
)
-
APPROVED_BY
(
type: esriFieldTypeString, alias: APPROVED_BY, length: 6
)
-
CLOSED
(
type: esriFieldTypeDate, alias: CLOSED, length: 8
)
-
CLOSED_BY
(
type: esriFieldTypeString, alias: CLOSED_BY, length: 6
)
-
STATUS
(
type: esriFieldTypeString, alias: STATUS, length: 60
)
-
STATUS_BY
(
type: esriFieldTypeString, alias: STATUS_BY, length: 6
)
-
STATUS_DATE
(
type: esriFieldTypeDate, alias: STATUS_DATE, length: 8
)
-
RESOLUTION_NO
(
type: esriFieldTypeString, alias: RESOLUTION_NO, length: 12
)
-
PARENT_PROJECT_NO
(
type: esriFieldTypeString, alias: PARENT_PROJECT_NO, length: 15
)
-
EXPIRED
(
type: esriFieldTypeDate, alias: EXPIRED, length: 8
)
-
EXPIRED_BY
(
type: esriFieldTypeString, alias: EXPIRED_BY, length: 6
)
-
OTHER_DATE1
(
type: esriFieldTypeDate, alias: OTHER_DATE1, length: 8
)
-
OTHER_BY1
(
type: esriFieldTypeString, alias: OTHER_BY1, length: 6
)
-
OWNER_NAME
(
type: esriFieldTypeString, alias: OWNER_NAME, length: 60
)
-
APPLICANT_NAME
(
type: esriFieldTypeString, alias: APPLICANT_NAME, length: 60
)
-
DEVELOPER_NAME
(
type: esriFieldTypeString, alias: DEVELOPER_NAME, length: 60
)
-
RECORDID
(
type: esriFieldTypeString, alias: RECORDID, length: 30
)
-
LOCKID
(
type: esriFieldTypeString, alias: LOCKID, length: 30
)
-
LOC_RECORDID
(
type: esriFieldTypeString, alias: LOC_RECORDID, length: 30
)
-
DEPOSITTYPE
(
type: esriFieldTypeString, alias: DEPOSITTYPE, length: 60
)
-
CONTRACTOR_NAME
(
type: esriFieldTypeString, alias: CONTRACTOR_NAME, length: 60
)
-
HISTORICAL_APN
(
type: esriFieldTypeString, alias: HISTORICAL_APN, length: 50
)
-
REFERENCE_NO
(
type: esriFieldTypeString, alias: REFERENCE_NO, length: 30
)
-
SITE_ALTERNATE_ID
(
type: esriFieldTypeString, alias: SITE_ALTERNATE_ID, length: 40
)
-
SITE_GEOTYPE
(
type: esriFieldTypeString, alias: SITE_GEOTYPE, length: 60
)
-
Parent_Generic1_ActivityNo
(
type: esriFieldTypeString, alias: Parent_Generic1_ActivityNo, length: 15
)
-
Parent_Generic2_ActivityNo
(
type: esriFieldTypeString, alias: Parent_Generic2_ActivityNo, length: 15
)
-
Parent_Generic3_ActivityNo
(
type: esriFieldTypeString, alias: Parent_Generic3_ActivityNo, length: 15
)
-
Parent_Generic4_ActivityNo
(
type: esriFieldTypeString, alias: Parent_Generic4_ActivityNo, length: 15
)
-
Parent_Generic5_ActivityNo
(
type: esriFieldTypeString, alias: Parent_Generic5_ActivityNo, length: 15
)
-
TSstatus
(
type: esriFieldTypeInteger, alias: TSstatus
)
-
ESRI_OID
(
type: esriFieldTypeOID, alias: ESRI_OID
)
Supported Operations:
Query
Query Attachments
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata