The latest updates to City Boundaries data are now available in the EGISDBP1 repository in the table: eGIS_Boundaries_Political.EGIS.DPW_CITY_BOUNDARIES_NEW_SCHEMA. Please take the opportunity to review the new table and take note of any changes that may affect existing map services.
Process & Schedule
Updated 10/18/22
We will maintain both city boundaries tables (DPW_CITY_BOUNDARIES and DPW_CITY_BOUNDARIES_NEW_SCHEMA) in their current state in the repository through October 6, 2022 November 18, 2022. Before this date, please republish any map services that use city boundaries to reference the NEW_SCHEMA table and test for any issues in your maps and applications. We will implement the schema changes in the main DPW_CITY_BOUNDARIES table on the 18th, after which you can republish again based on that table. On November 17 Dec 1, we will drop the NEW_SCHEMA table and expect all services to be using the updated DPW_CITY_BOUNDARIES.
Important Dates:
- August 31, 2022 – Table DPW_CITY_BOUNDARIES_NEW_SCHEMA available in repository
- November 18, 2022 – Schema changes to be implemented in DPW_CITY_BOUNDARIES table
- December 1, 2022 – Drop DPW_CITY_BOUNDARIES_NEW_SCHEMA table
Schema Changes
This table describes the schema changes reflected in DPW_CITY_BOUNDARIES_NEW_SCHEMA, and to be implemented in DPW_CITY_BOUNDARIES.
Field Name | Alias | Sample Record | Proposed Action |
OBJECTID | 48192 | KEEP | |
ABBR | ABBREVIATION | ALH | KEEP – Copy data from DESCRIPTN |
CITY | <Null> | REMOVE – Currently all NULL | |
CITY_ID | <Null> | REMOVE – Currently all NULL | |
CITY_LABEL | CITY LABEL | Alhambra | KEEP – Change ‘CO’ entries to ‘Unincorporated County’ |
CITY_NAME | CITY NAME | Alhambra | KEEP |
CITY_NO | REMOVE | ||
CITY_TYPE | CITY TYPE | City | KEEP |
COLOR_CODE | REMOVE | ||
COLOR_EGIS | DISPLAY COLOR | Pink – RGB 255,190,232 | KEEP |
COMMENT | <Null> | REMOVE – Currently all NULL | |
DESCRIPTN | ALH | REMOVE – Copy data to ABBR | |
FEAT_TYPE | FEATURE TYPE | Land | KEEP |
OF_AREA_SM | AREA SQUARE MILES RECORDED | 7.626 | KEEP |
PHONE | 6265705007 | KEEP | |
POPULATION | <Null> | REMOVE – Currently all NULL | |
Shape | Polygon | KEEP | |
Shape.STArea() | 212765306.1 | KEEP | |
Shape.STLength() | 69046.93106 | KEEP | |
URL | www.cityofalhambra.org | KEEP | |
last_edited_date | New Field |
Potentially Affected Layers
This is a preliminary list of map services on arcgis.gis.lacounty.gov that currently reference DPW_CITY_BOUNDARIES, based on a scan of MXD’s on the data01 network drive:
- \CAMS\CAMS_WorkOrders_Reference\CAMS_WorkOrders_Reference.mxd
- \DMH\DMHViewer_Geographic_Boundaries\DMHViewer – Geographic_Boundaries_20171120.mxd
- \Library\Library_Viewer\Library_Viewer_20200625.mxd
- \PARKS\Park_Planning_Viewer\Park_Planning_Viewer_New.mxd
- \PARKS\Park_Planning_Viewer\Park_Planning_Viewer_New_20200811.mxd
- \ISD\City_Boundaries\City_Boundaries.mxd
- \ISD\DRP_Equity_Development_Indicators\DRP_Equity_Development_Indicators_20181025_bivariate1_redblue.mxd
- \DRP\Equity_Development_indicators\Equity_Development_indicators_20190430.mxd
- \DRP\Gentrification\Gentrification.mxd
- \RRCC\District_Maps_EGIS\District_Maps_EGIS_10_3.mxd
- \Census_2020\CensusBlocks_City\CensusBlocks_City.mxd
- \LACounty_Dynamic\Political_Boundaries\Political_Boundaries_20180212.mxd
- \LACounty_Dynamic\Political_Boundaries_TEST\Political_Boundaries_20180212.mxd
- \LACounty_Dynamic\Political_Boundaries_Label_Test\Political_Boundaries_Label_Test.mxd
- \LACOUNTY_Connections\DMH\DMHViewer_Geographic_Boundaries\DMHViewer – Geographic_Boundaries_20171120.mxd
- \RollingHills\City_RollingHills_Viewer\City_RollingHills_Viewer.mxd