20261104
19043800
1.0
FALSE
IMPACTFEEFUNDED_CIP_ALLPOINT
002
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
NAD_1983_StatePlane_California_VI_FIPS_0406_Feet
<ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.5.0'><WKT>PROJCS["NAD_1983_StatePlane_California_VI_FIPS_0406_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",6561666.666666666],PARAMETER["False_Northing",1640416.666666667],PARAMETER["Central_Meridian",-116.25],PARAMETER["Standard_Parallel_1",32.78333333333333],PARAMETER["Standard_Parallel_2",33.88333333333333],PARAMETER["Latitude_Of_Origin",32.16666666666666],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2230]]</WKT><XOrigin>-118608900</XOrigin><YOrigin>-91259500</YOrigin><XYScale>3048.0060960121928</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102646</WKID><LatestWKID>2230</LatestWKID></ProjectedCoordinateSystem>
20260925
11055700
20260925
17512800
ISO19139
150000000
5000
20260925
ArcGIS Metadata
1.0
File Geodatabase Feature Class
external
f01d7a4d9f7e9cdcca314216897e2db805f9c9c26c7d9a7e3eb38c8e192a02f8
Mike Klein
City of San Diego
Program Coordinator
True
Mike Klein
File Geodatabase Feature Class
IMPACTFEEFUNDED_CIP_ALLPOINT
2026-09-25
vector digital data
external
f01d7a4d9f7e9cdcca314216897e2db805f9c9c26c7d9a7e3eb38c8e192a02f8
Mike Klein
City of San Diego
Program Coordinator
True
Mike Klein
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>IMPACTFEEFUNDED_CIP_ALLPOINT is the production authoritative point‑based feature class representing current (“active”) Capital Improvement Program (CIP) projects within the City of San Diego. It originates from the ATLAS@SDW enterprise GIS environment and contains standardized CIP‑project attributes used for department workflows, mapping, analysis, and integration with Planning and Enterprise Capital Projects (ECP).</SPAN></P><P><SPAN>The dataset provides point geometry for active CIP projects and includes identifiers, project titles, construction dates, council district reference, status, component areas, contact information, asset type, descriptive text, and spatial X coordinate values. It is used as a core input dataset for CIP project mapping, reporting, quality control, and automated workflows including DIF‑funded CIP processing</SPAN></P></DIV></DIV></DIV>
To provide a uniform, authoritative, and up‑to‑date point representation of active CIP projects for enterprise GIS applications, automated workflows (including CIP merge/join processing), Planning analyses, operational mapping, and departmental data governance. It supports enterprise integration between Planning, ECP, DoIT‑EGIS, and internal CIP tracking systems.
Mike Klein
City of San Diego
Program Coordinator
external
f01d7a4d9f7e9cdcca314216897e2db805f9c9c26c7d9a7e3eb38c8e192a02f8
Mike Klein
City of San Diego
Program Coordinator
True
Mike Klein
City of San Diego
Capital Improvement Program
CIP
Impact Fee
DIF
Snowflake
Planning
Capital Improvement Program
CIP
Impact Fee
DIF
Planning
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Use for City planning, analysis, mapping, reporting, quality control, and related automated workflows. Users should verify project and financial information against the authoritative source systems when current authoritative values are required.</SPAN></P></DIV></DIV></DIV>
Workflow sources: CITY_CIP_ALL_POINT_VW (active CIP points), CITY_CIP_ALL_POINT_HISTORICAL_VW (historical CIP points), and PLANNING.REPORTING.IMPACT_FEE_FUNDED_CIP_PROJECTS_VW (Impact Fee funded project and financial data). Processing: active and historical CIP points are merged; normalized project IDs are matched in Python; matched records are written to IMPACTFEEFUNDED_CIP_ALLPOINT and unmatched source rows are exported to CSV.
Esri ArcGIS 13.5.5.57366
Schema for the Impact Fee Funded CIP output feature class. This template contains no feature records.
City of San Diego
0
City of San Diego
IMPACTFEEFUNDED_CIP_ALLPOINT
Schema definition for the Impact Fee Funded CIP output point feature class. Matched Snowflake project attributes are combined with active and historical CIP point attributes by the automation.
City of San Diego — Enterprise Capital Projects (ECP)
Feature Class
1886
OBJECTID
Internal feature number.
Esri
OBJECTID
Object ID
4
0
0
Sequential unique whole numbers that are automatically generated.
Shape
Feature geometry.
Esri
Shape
Geometry
0
0
0
Coordinates defining the features.
CIP_ID
Identifier assigned to each CIP project. Used for joining to financial records (CITY_PROJECT_NO) and for CIP merge workflows. Note: CIP_ID is not guaranteed unique across records.
City of San Diego
CIP_ID
String
50
0
0
TITLE
Official CIP project title or descriptive name.
City of San Diego
TITLE
String
500
0
0
START_CNST
Construction start date for the project (if applicable).
City of San Diego
START_CNST
Date
8
1
0
END_CNST
Construction end date or anticipated completion date.
City of San Diego
END_CNST
Date
8
1
0
CNCL_DIST
City Council District in which the CIP project is located.
City of San Diego
CNCL_DIST
String
50
0
0
CIP_STAT
Status of the CIP project (e.g., Active, Completed, Planned). Supports project reporting and tracking.
City of San Diego
CIP_STAT
String
200
0
0
COMP_AREA
Component or sub‑area descriptions associated with the project. May include design segments, geographic extents, or contextual descriptors.
City of San Diego
COMP_AREA
String
2000
0
0
EXT_CONTACT
External or project contact information associated with the CIP project.
City of San Diego
EXT_CONTACT
String
200
0
0
EXT_PHONE
External contact’s phone number.
City of San Diego
EXT_PHONE
String
50
0
0
ASSET_TYPE
Category or classification of the CIP asset (e.g., Facility, Park, Roadway, Utility).
City of San Diego
ASSET_TYPE
String
200
0
0
DESC_TEXT
Detailed narrative of the CIP project’s scope, purpose, and improvements.
City of San Diego
DESC_TEXT
String
2000
0
0
POINT_X
X‑coordinate stored as an attribute for reference or QA purposes. Not used as the primary geometry field.
City of San Diego
POINT_X
Double
8
0
0
POINT_Y
Y‑coordinate stored as an attribute for reference or QA purposes. Not used as the primary geometry field.
City of San Diego
POINT_Y
Double
8
0
0
CNCL_DIST_POINT
Council district value associated with the CIP project point location.
City of San Diego
CNCL_DIST_POINT
SmallInteger
2
0
0
CREATED_USER
User recorded as creating the source CIP spatial record.
City of San Diego
CREATED_USER
String
255
0
0
CREATED_DATE
Date recorded for creation of the source CIP spatial record.
City of San Diego
CREATED_DATE
Date
8
1
0
LAST_EDITED_USER
User recorded as most recently editing the source CIP spatial record.
City of San Diego
LAST_EDITED_USER
String
255
0
0
LAST_EDITED_DATE
Date recorded for the most recent edit to the source CIP spatial record.
City of San Diego
LAST_EDITED_DATE
Date
8
1
0
FUND_NUMBER
Identifier or number associated with the Impact Fee / DIF funding source for the project.
City of San Diego
FUND_NUMBER
Integer
4
0
0
FUND_NAME
Name of the Impact Fee / DIF fund associated with the project.
City of San Diego
FUND_NAME
String
255
0
0
CITY_PROJECT_NO
City project number from Snowflake used to associate the funded project record with the spatial CIP record. This field is matched to CIP_ID.
City of San Diego
CITY_PROJECT_NO
String
50
0
0
DIF_PLAN_NO
Development Impact Fee plan number associated with the funded CIP project.
City of San Diego
DIF_PLAN_NO
String
50
0
0
PROJECTS_APPROVED_BY_COUNCIL
Indicator or value identifying whether the funded project has been approved by City Council, as represented in the Snowflake source view.
City of San Diego
PROJECTS_APPROVED_BY_COUNCIL
String
255
0
0
PROJECT_NAME
Name of the Impact Fee / DIF-funded CIP project.
City of San Diego
PROJECT_NAME
String
255
0
0
PROJECT_STATUS
Project status value provided by the Snowflake Impact Fee funded project view.
City of San Diego
PROJECT_STATUS
String
50
0
0
FUNDS_EXPENDED
Amount of Impact Fee / DIF funding expended for the project as reported by the Snowflake source view.
City of San Diego
FUNDS_EXPENDED
Double
8
0
0
FUNDS_BUDGETED
Amount of Impact Fee / DIF funding budgeted for the project as reported by the Snowflake source view.
City of San Diego
FUNDS_BUDGETED
Double
8
0
0
dataset
EPSG
5.3(9.0.0)
Simple
FALSE
1886
TRUE
FALSE
external
f01d7a4d9f7e9cdcca314216897e2db805f9c9c26c7d9a7e3eb38c8e192a02f8
Mike Klein
City of San Diego
Program Coordinator
True
Mike Klein
external
f01d7a4d9f7e9cdcca314216897e2db805f9c9c26c7d9a7e3eb38c8e192a02f8
Mike Klein
City of San Diego
Program Coordinator
True
Mike Klein