Name: PROJECTS
Display Field: PROJ_NAME
Type: Table
Description:
Copyright Text:
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Object ID Field: objectid
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- objectid (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- recordtype (type: esriFieldTypeString, alias: RecordType, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
- iscensustractbased (type: esriFieldTypeInteger, alias: ISCENSUSTRACTBASED, SQL Type: sqlTypeOther, nullable: true, editable: true)
- proj_id (type: esriFieldTypeString, alias: PROJ_ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- role_subprogram_id (type: esriFieldTypeInteger, alias: ROLE_SUBPROGRAM_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- proj_name (type: esriFieldTypeString, alias: PROJ_NAME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- proj_type (type: esriFieldTypeString, alias: PROJ_TYPE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- proj_desc (type: esriFieldTypeString, alias: PROJ_DESC, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
- proj_complete_date (type: esriFieldTypeString, alias: PROJ_COMPLETE_DATE, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
- date_awarded (type: esriFieldTypeDate, alias: DATE_AWARDED, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- proj_life (type: esriFieldTypeString, alias: PROJ_LIFE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- address (type: esriFieldTypeString, alias: ADDRESS, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
- lat_lon (type: esriFieldTypeString, alias: LAT_LON, SQL Type: sqlTypeOther, length: 1200, nullable: true, editable: true)
- total_cost (type: esriFieldTypeDouble, alias: TOTAL_COST, SQL Type: sqlTypeOther, nullable: true, editable: true)
- total_ggrf_funding (type: esriFieldTypeDouble, alias: TOTAL_GGRF_FUNDING, SQL Type: sqlTypeOther, nullable: true, editable: true)
- est_num_incentives (type: esriFieldTypeInteger, alias: EST_NUM_INCENTIVES, SQL Type: sqlTypeOther, nullable: true, editable: true)
- est_ghg_reductions (type: esriFieldTypeInteger, alias: EST_GHG_REDUCTIONS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- fy_funding (type: esriFieldTypeString, alias: FY_FUNDING, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
- total_incentives_issued (type: esriFieldTypeInteger, alias: TOTAL_INCENTIVES_ISSUED, SQL Type: sqlTypeOther, nullable: true, editable: true)
- dac_benefit_yn (type: esriFieldTypeInteger, alias: DAC_BENEFIT_YN, SQL Type: sqlTypeOther, nullable: true, editable: true)
- dac_benefit_criteria (type: esriFieldTypeString, alias: DAC_BENEFIT_CRITERIA, SQL Type: sqlTypeOther, length: 1200, nullable: true, editable: true)
- dac_amount_benefit (type: esriFieldTypeDouble, alias: DAC_AMOUNT_BENEFIT, SQL Type: sqlTypeOther, nullable: true, editable: true)
- dac_amount_within (type: esriFieldTypeDouble, alias: DAC_AMOUNT_WITHIN, SQL Type: sqlTypeOther, nullable: true, editable: true)
- dac_count_within (type: esriFieldTypeInteger, alias: DAC_COUNT_WITHIN, SQL Type: sqlTypeOther, nullable: true, editable: true)
- dac_count_benefit (type: esriFieldTypeInteger, alias: DAC_COUNT_BENEFIT, SQL Type: sqlTypeOther, nullable: true, editable: true)
- gis_id (type: esriFieldTypeString, alias: GIS_ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- source (type: esriFieldTypeString, alias: Source, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- census_tract (type: esriFieldTypeString, alias: CENSUS_TRACT, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
- dac_gis_yn (type: esriFieldTypeInteger, alias: DAC_GIS_YN, SQL Type: sqlTypeOther, nullable: false, editable: true)
- projrecid (type: esriFieldTypeString, alias: ProjRecID, SQL Type: sqlTypeOther, length: 1200, nullable: true, editable: true)
- ab_1550_choice (type: esriFieldTypeString, alias: AB_1550_CHOICE, SQL Type: sqlTypeOther, length: 1200, nullable: true, editable: true)
- buffer_amt (type: esriFieldTypeDouble, alias: BUFFER_AMT, SQL Type: sqlTypeOther, nullable: true, editable: true)
- buffer_count (type: esriFieldTypeDouble, alias: BUFFER_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ces_version (type: esriFieldTypeString, alias: CES_VERSION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- dac_census_tracts (type: esriFieldTypeString, alias: DAC_CENSUS_TRACTS, SQL Type: sqlTypeOther, length: 1200, nullable: true, editable: true)
- dac_total_funds (type: esriFieldTypeDouble, alias: DAC_TOTAL_FUNDS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- dac3_amt (type: esriFieldTypeDouble, alias: DAC3_AMT, SQL Type: sqlTypeOther, nullable: true, editable: true)
- dac3_count (type: esriFieldTypeDouble, alias: DAC3_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
- dac3_yn (type: esriFieldTypeInteger, alias: DAC3_YN, SQL Type: sqlTypeOther, nullable: true, editable: true)
- date_selected (type: esriFieldTypeString, alias: DATE_SELECTED, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
- low_income_amt (type: esriFieldTypeDouble, alias: LOW_INCOME_AMT, SQL Type: sqlTypeOther, nullable: true, editable: true)
- low_income_count (type: esriFieldTypeDouble, alias: LOW_INCOME_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
- buffer_yn (type: esriFieldTypeInteger, alias: BUFFER_YN, SQL Type: sqlTypeOther, nullable: true, editable: true)
- low_income_household_amt (type: esriFieldTypeDouble, alias: LOW_INCOME_HOUSEHOLD_AMT, SQL Type: sqlTypeOther, nullable: true, editable: true)
- low_income_household_count (type: esriFieldTypeDouble, alias: LOW_INCOME_HOUSEHOLD_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
- low_income_yn (type: esriFieldTypeInteger, alias: LOW_INCOME_YN, SQL Type: sqlTypeOther, nullable: true, editable: true)
- proj_count (type: esriFieldTypeInteger, alias: PROJ_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
- proj_funds_recip (type: esriFieldTypeString, alias: PROJ_FUNDS_RECIP, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ab1550_gis_yn (type: esriFieldTypeInteger, alias: AB1550_GIS_YN, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ab1550_buffer_gis_yn (type: esriFieldTypeInteger, alias: AB1550_BUFFER_GIS_YN, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ab1550_low_income_gis_yn (type: esriFieldTypeInteger, alias: AB1550_LOW_INCOME_GIS_YN, SQL Type: sqlTypeOther, nullable: true, editable: true)
- dac_gis_conforms (type: esriFieldTypeInteger, alias: DAC_GIS_CONFORMS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ab1550_gis_conforms (type: esriFieldTypeInteger, alias: AB1550_GIS_CONFORMS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ab1550_buffer_gis_conforms (type: esriFieldTypeInteger, alias: AB1550_BUFFER_GIS_CONFORMS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ab1550_low_income_gis_conforms (type: esriFieldTypeInteger, alias: AB1550_LOW_INCOME_GIS_CONFORMS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- is_missing_map_data (type: esriFieldTypeInteger, alias: IS_MISSING_MAP_DATA, SQL Type: sqlTypeOther, nullable: true, editable: true)
- senate_district (type: esriFieldTypeString, alias: SENATE_DISTRICT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- assembly_district (type: esriFieldTypeString, alias: ASSEMBLY_DISTRICT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- county_code (type: esriFieldTypeString, alias: COUNTY_CODE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- reportingcycleid (type: esriFieldTypeInteger, alias: REPORTINGCYCLEID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- county_name (type: esriFieldTypeString, alias: COUNTY_NAME, SQL Type: sqlTypeOther, length: 1024, nullable: true, editable: true)
- agency (type: esriFieldTypeString, alias: AGENCY, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
- subprogram_name (type: esriFieldTypeString, alias: SUBPROGRAM_NAME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- benefits_priority_yn (type: esriFieldTypeInteger, alias: BENEFITS_PRIORITY_YN, SQL Type: sqlTypeOther, nullable: true, editable: true)
- benefits_priority_funds (type: esriFieldTypeDouble, alias: BENEFITS_PRIORITY_FUNDS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- program (type: esriFieldTypeString, alias: PROGRAM, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- includeinreports (type: esriFieldTypeInteger, alias: INCLUDEINREPORTS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- stateew_nox (type: esriFieldTypeInteger, alias: stateew_nox, SQL Type: sqlTypeOther, nullable: true, editable: true)
- stateew_pm25 (type: esriFieldTypeInteger, alias: stateew_pm25, SQL Type: sqlTypeOther, nullable: true, editable: true)
- stateew_dpm (type: esriFieldTypeInteger, alias: stateew_dpm, SQL Type: sqlTypeOther, nullable: true, editable: true)
- stateew_rog (type: esriFieldTypeInteger, alias: stateew_rog, SQL Type: sqlTypeOther, nullable: true, editable: true)
- dieselpmreductionstons (type: esriFieldTypeDouble, alias: dieselpmreductionstons, SQL Type: sqlTypeOther, nullable: true, editable: true)
- noxreductionstons (type: esriFieldTypeDouble, alias: noxreductionstons, SQL Type: sqlTypeOther, nullable: true, editable: true)
- pm25reductionstons (type: esriFieldTypeDouble, alias: pm25reductionstons, SQL Type: sqlTypeOther, nullable: true, editable: true)
- rogreductionstons (type: esriFieldTypeDouble, alias: rogreductionstons, SQL Type: sqlTypeOther, nullable: true, editable: true)
- nonggrffunded (type: esriFieldTypeInteger, alias: nonggrffunded, SQL Type: sqlTypeOther, nullable: true, editable: true)
- sector (type: esriFieldTypeString, alias: Sector, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- proj_benefits_desc (type: esriFieldTypeString, alias: PROJ_BENEFITS_DESC, SQL Type: sqlTypeOther, length: 2400, nullable: true, editable: true)
- dac_qualitative (type: esriFieldTypeString, alias: DAC_QUALITATIVE, SQL Type: sqlTypeOther, length: 2400, nullable: true, editable: true)
- reportingcyclename (type: esriFieldTypeString, alias: REPORTINGCYCLENAME, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- voucher_id (type: esriFieldTypeString, alias: VOUCHER_ID, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
Templates:
Name: PROJECTS
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 5/7/2026 7:50:58 PM
Schema Last Edit Date: 5/7/2026 7:32:53 PM
Data Last Edit Date: 5/7/2026 7:50:58 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat