Name: Projects
Display Field: PROJECT_NAME
Type: Feature Layer
Geometry Type: esriGeometryPolygon
Description:
Copyright Text:
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 1000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: -118608483.211973
YMin: -91259160.5871731
XMax: 131731816.545307
YMax: 53304526.8391865
Spatial Reference: 102646 (2230)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[206,245,191,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.4}},"label":"","description":""},"transparency":0,"labelingInfo":null}
HasZ: false
HasM: false
Has Attachments: true
Has Geometry Properties: true
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field: GlobalID
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- PROJECT_NAME (type: esriFieldTypeString, alias: Project Name, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- PROJECT_LOCATION (type: esriFieldTypeString, alias: Projoect Location, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [City of Corona: City of Corona], [City of Eastvalle: City of Eastvalle], [City of Jurupa Valley: City of Jurupa Valley], ... 11 more ...)
- PROJECT_TYPE (type: esriFieldTypeString, alias: Project Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Tract: Tract], [Commercial: Commercial], [Military: Military], ... 4 more ...)
- PROJET_STATUS (type: esriFieldTypeString, alias: Project Status, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Pre-Application (Due Diligence): Pre-Application (Due Diligence)], [CEQA Review: CEQA Review], [Conditions of Approval: Conditions of Approval], ... 4 more ...)
- STATUS_NOTES (type: esriFieldTypeString, alias: Status Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- PAN_WATER_INSPECTION (type: esriFieldTypeString, alias: Project Activity Number (Water Inspection), SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- PAN_SEWER_INSPECTION (type: esriFieldTypeString, alias: Project Activity Number (Sewer Inspection), SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- PAN_RECYCLED_INSPECTION (type: esriFieldTypeString, alias: Project Activity Number (Recycled Inspection), SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- PAN_IRRIGATION_INSPECTION (type: esriFieldTypeString, alias: Project Activity Number (Irrigation Inspection), SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- PAN_WATER_PLANCHECK (type: esriFieldTypeString, alias: Project Activity Number (Water Plan Check), SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- PAN_SEWER_PLANCHECK (type: esriFieldTypeString, alias: Project Activity Number (Sewer Plan Check), SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- PAN_RECYCLED_PLANCHECK (type: esriFieldTypeString, alias: Project Activity Number (Recycled Plan Check), SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- PAN_IRRIGATION_PLANCHECK (type: esriFieldTypeString, alias: Project Activity Number (Irrigation Plan Check), SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- PAN_DUE_DILLIGENCE (type: esriFieldTypeString, alias: Project Activity Number (Due Dilligence), SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- PAN_PROJECT_PLANNING (type: esriFieldTypeString, alias: Project Activity Number (Project Planning), SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- PD_COMPANY (type: esriFieldTypeString, alias: Project Developer (Company/Entity Name), SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- PD_NAME (type: esriFieldTypeString, alias: Project Developer (Name), SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- PD_TITLE (type: esriFieldTypeString, alias: Project Developer (Title), SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- PD_ADDRESS (type: esriFieldTypeString, alias: Project Developer (Address), SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- PD_CITY_STATE_ZIP (type: esriFieldTypeString, alias: Project Developer (City, State, Zip), SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- PD_PHONE (type: esriFieldTypeString, alias: Project Developer (Phone), SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- PD_CELL (type: esriFieldTypeString, alias: Project Developer (Cell), SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- PD_EMAIL (type: esriFieldTypeString, alias: Project Developer (Email), SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- OWNER_NAME (type: esriFieldTypeString, alias: Owner (Name), SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- OWNER_COMPANY (type: esriFieldTypeString, alias: Owner (Company), SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- OWNER_ADDRESS (type: esriFieldTypeString, alias: Owner (Address), SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- OWNER_CITY_STATE_ZIP (type: esriFieldTypeString, alias: Owner (City, State, Zip), SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- OWNER_PHONE (type: esriFieldTypeString, alias: Owner (Phone), SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- OWNER_EMAIL (type: esriFieldTypeString, alias: Owner (Email), SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- APPLICANT_NAME (type: esriFieldTypeString, alias: Applicant (Name), SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- APPLICANT_COMPANY (type: esriFieldTypeString, alias: Applicant (Company), SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- APPLICANT_ADDRESS (type: esriFieldTypeString, alias: Applicant (Address), SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- APPLICANT_CITY_STATE_ZIP (type: esriFieldTypeString, alias: Applicant (City, State, Zip), SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- APPLICANT_PHONE (type: esriFieldTypeString, alias: Applicant (Phone), SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- APPLICANT_EMAIL (type: esriFieldTypeString, alias: Applicant (Email), SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- CEOR_NAME (type: esriFieldTypeString, alias: Civil Engineer of Record - Name, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- CEOR_COMPANY (type: esriFieldTypeString, alias: Civil Engineer of Record - Company, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- CEOR_ADDRESS (type: esriFieldTypeString, alias: Civil Engineer of Record - Address, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- CEOR_CITY_STATE_ZIP (type: esriFieldTypeString, alias: Civil Engineer of Record - City, State, Zip, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- CEOR_PHONE (type: esriFieldTypeString, alias: Civil Engineer of Record - Phone, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- CEOR_EMAIL (type: esriFieldTypeString, alias: Civil Engineer of Record - Email, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- CONTRACTOR_NAME (type: esriFieldTypeString, alias: Contractor (Name), SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- CONTRACTOR_COMPANY (type: esriFieldTypeString, alias: Contractor (Company), SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- CONTRACTOR_ADDRESS (type: esriFieldTypeString, alias: Contractor (Address), SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- CONTRACTOR_CITY_STATE_ZIP (type: esriFieldTypeString, alias: Contractor (City, State, Zip), SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- CONTRACTOR_PHONE (type: esriFieldTypeString, alias: Contractor (Phone), SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- CONTRACTOR_EMAIL (type: esriFieldTypeString, alias: Contractor (Email), SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- P_DWELLING_UNITS (type: esriFieldTypeSmallInteger, alias: # of Dwelling Units, SQL Type: sqlTypeOther, nullable: true, editable: true)
- P_EDUs (type: esriFieldTypeSmallInteger, alias: # of EDU's, SQL Type: sqlTypeOther, nullable: true, editable: true)
- P_COM_BLDG_SQ_FT (type: esriFieldTypeDouble, alias: Commercial Building Square Footage, SQL Type: sqlTypeOther, nullable: true, editable: true)
- P_DS_FOLDER_LINK (type: esriFieldTypeString, alias: Development Services Folder Link, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- P_NO_POTABLE_WATER_SVCS (type: esriFieldTypeSmallInteger, alias: Number of Potable Water Services, SQL Type: sqlTypeOther, nullable: true, editable: true)
- P_NO_SEWER_SVCS (type: esriFieldTypeSmallInteger, alias: Number of Sewer Services, SQL Type: sqlTypeOther, nullable: true, editable: true)
- P_NO_RW_NP_SVCS (type: esriFieldTypeSmallInteger, alias: Number of RW/NP Services, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CEQA_REVIEW_LETTER_DATE (type: esriFieldTypeDate, alias: CEQA Review Letter Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- CONDITIONS_OF_APPROVAL_DATE (type: esriFieldTypeDate, alias: Conditions of Approval Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- FIREFLOW_TESTING_LETTER_DATE (type: esriFieldTypeDate, alias: Fire Flow Testing Letter Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- WILLSERVE_LETTER_DATE (type: esriFieldTypeDate, alias: Will-Serve Letter Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- PLAN_CHECK_APPROVAL_DATE (type: esriFieldTypeDate, alias: Plan Check Approval Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- NOTICE_TO_PROCEED_DATE (type: esriFieldTypeDate, alias: Notice to Proceed (NTP) Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- NOTICE_OF_FINAL_INSPECTION_DATE (type: esriFieldTypeDate, alias: Notice of Final Inspection (NOFI) Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- RECORD_DRAWING_SIGNATURE_DATE (type: esriFieldTypeDate, alias: Record Drawing Signature Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- GRANT_DEED_RECORDING_DATE (type: esriFieldTypeDate, alias: Grant Deed Recording Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- NOTICE_OF_COMPLETION_DATE (type: esriFieldTypeDate, alias: Notice of Completion Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- BOND_RELEASE_RELEASE_90 (type: esriFieldTypeDate, alias: 90% Bond Release Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- BOND_RELEASE_RELEASE_FINAL (type: esriFieldTypeDate, alias: Final Bond Release Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- CLOSE_OF_PROJECT_DATE (type: esriFieldTypeDate, alias: Close of Project, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- YEAR_CONSTRUCTION_STARTED (type: esriFieldTypeInteger, alias: Year Construction Started, SQL Type: sqlTypeOther, nullable: true, editable: true)
- YEAR_CONSTRUCTION_ACCEPTED (type: esriFieldTypeInteger, alias: Year Construction Accepted, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ADDITIONAL_NOTES (type: esriFieldTypeString, alias: Additional Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDouble, nullable: true, editable: false)
- Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
Templates:
Name: Projects
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 2/8/2022 7:42:45 PM
Schema Last Edit Date: 2/8/2022 7:42:45 PM
Data Last Edit Date: 2/8/2022 7:42:45 PM
Supported Operations:
Query
Query Top Features
Query Analytic
Query Bins
Query Attachments
Add Features
Update Features
Delete Features
Apply Edits
Calculate
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat