SideWalkSegmentByAPN

Robert Mazur, Transystems Corp. 4/18/07 Unknown SideWalkSegmentByAPN_SJ vector digital data withheld GISADMIN.SidewalkSegments_Citywide SideWalkSegmentByAPN:This is a newly developed sidewalk segment by APN dataset for the City of Oakland contains over ten thousand records with the City of Oakland, evolved from the existing SideWalk Segment dataset through a series of complex GIS operations to map the APN information to the sidewalk segment dataset – not only on the attribute level but also spatially by, spatially breaking up the existing sidewalk segment lines corresponding to the face width of the parcels that are adjacent to it. The purpose is to support the program to identify Maintenance responsibility for each sidewalk segment based on the adjacent parcel owners. New fields are added. See the table below. The dataset attribution collected includes LENGTH, WIDTH, AREA, GUTTER WIDTH, LANDUSE, CURB TYPE, and PAVED GUTTER.This newly developed SideWalkSegmentByAPNdataset: 101,437 records(about 10 times more than the original data after being broken down spatially)Original sidewalk segment dataset: 13,844 recordsParcels: 113,758 recordsDeveloped by David Lok, DATA STRUCTURESSideWalkSegmentByAPNFIELD NAMEDATATYPELENGTHEXPLANATIONDESCRIPTIONPOSSIBLE VALUESFACILITYIDLong Integer Unique identifier. Basis of Cityworks record management.NEWAPNText50Unformatted APN Assessor’s Parcel Number that identifies each parcel citywide. Reflects the adjacent APN for each sidewalk segment. Maintenance responsibility for each sidewalk segment is based on the adjacent parcel owner. APN_FORMATText50Formatted APNFORMATTED APN PLANAREAIDText10Retain value from PLANAREAID field of the old SideWalk_Segment datasetPlanning Areas are non-political geographies COUNCILIDText10Retain value from COUNCILID field of the old SideWalk_Segment datasetCouncil Districts LENGTHDouble New segment lengths after broken down by parcels (SHAPE_Length)Length of the sidewalk segment WIDTHText50Retain value from the WIDTH field of the old SideWalk_Segment datasetWidth of the sidewalk segment LANDUSEText50Retain value from the LANDUSE field of the old SideWalk_Segment datasetLand use of the adjacent parcel or block face TRANSITROUText50Retain value from the TRANSITROU field of the old SideWalk_Segment datasetIndicates the presence of bus service on the adjacent roadway CURBTYPEText50Retain value from CURBTYPE field of the old SideWalk_Segment datasetDesignates the type of curb adjacent to the sidewalk PAVED_GUTText50Retain value from PAVED_GUT field of the old SideWalk_Segment datasetIndicates whether the gutter is paved over SW_CERTTYPText50(New)Indicates whether there is an active sidewalk certificate for the parcel. Standard, Provisional, Exemption, NoneSW_CERTBEGText50(New)The date that certificate was obtained SW_CERTEXPText50(New)The date that certificate will expire TREEText50(New)TreeY / NGUTTERWIDTText50Retain value from GUTTERWIDT field of the old SideWalk_Segment datasetGutter width present at the sidewalk segment ADA_COMPLIText50 LEGACYIDText30 FACILITYID from Old Database CONDITIONText30 CONDITIONDATEDate WARRANTYDATEDate LOCATIONText100 INSTALLDATEDate SideWalkSegmentByAPN: This is a newly developed sidewalk segment by APN dataset for the City of Oakland contains over ten thousand records with the City of Oakland, evolved from the existing SideWalk Segment dataset through a series of complex GIS operations to map the APN information to the sidewalk segment dataset – not only on the attribute level but also spatially by, spatially breaking up the existing sidewalk segment lines corresponding to the face width of the parcels that are adjacent to it. The purpose is to support the program to identify Maintenance responsibility for each sidewalk segment based on the adjacent parcel owners. New fields are added. See the table below. The dataset attribution collected includes LENGTH, WIDTH, AREA, GUTTER WIDTH, LANDUSE, CURB TYPE, and PAVED GUTTER. • This newly developed SideWalkSegmentByAPN dataset: 101,437 records (about 10 times more than the original data after being broken down spatially) • Original sidewalk segment dataset: 13,844 records • Parcels: 113,758 records Developed by David Lok, 10/24/2024 See City of Oakland Specs for curb type diagrams. en 10/01/05 12/01/06 REQUIRED: The year (and optionally month, or month and day) for which the data set corresponds to the ground. ground condition Complete As needed -122.314418 -122.118559 37.864383 37.722039 6037905.060632 6093575.833621 2090440.816618 2141258.935451 Sidewalk Reference Segments Sidewalk Segments Oakland, CA None None Robert B. Mazur Transystems Corperation GIS Analyst 510-835-2761 ESRI ArcCatalog 9.3.1.3500 Transystems Corperation Unpublished Material Unknown Robert Mazur Feature Class No QA/QC report was done on the data collected in the Sidewalk Segments Feature Class. No QA/QC report was done on the data collected in the Sidewalk Segments Feature Class. Accuaracy for sidewalk segment locations is +/- 1 foot. +/- 1 Ft. Due to the accuracy of the orthophoto used to create the sidewalk routes, locations for the digitized features will have an accuracy of +/- 1 ft. Dataset copied. withheld Metadata imported. withheld 20070409 14543800 Vector Simple FALSE 101437 TRUE FALSE coordinate pair 0.000054 0.000054 survey feet North American Datum of 1983 Geodetic Reference System 80 6378137.000000 298.257222 GCS_North_American_1983 NAD_1983_StatePlane_California_III_FIPS_0403_Feet 1.000000 Explicit elevation coordinate included with horizontal coordinates SideWalkSegmentByAPN_MODFID_STADR_c Feature Class 101437 OBJECTID Internal feature number. ESRI Sequential unique whole numbers that are automatically generated. OBJECTID OID 4 0 0 Shape Feature geometry. ESRI Coordinates defining the features. TREE String 50 0 0 TREE APN String 50 0 0 APN SW_CERTTYP String 50 0 0 SW_CERTTYP SW_CERTBEG String 50 0 0 SW_CERTBEG SHAPE_Length Double 8 0 0 Length of feature in internal units. Esri Positive real numbers that are automatically generated. SHAPE_Length Shape Geometry 0 0 0 Length of feature in internal units. Esri Positive real numbers that are automatically generated. SHAPE ARCID String 10 0 0 Feature geometry. ESRI Coordinates defining the features. ARCID PLANAREAID String 10 0 0 PLANAREAID COUNCILID String 10 0 0 COUNCILID SEGMENTID String 50 0 0 SEGMENTID SURVEYOR String 50 0 0 SURVEYOR CURBTYPE String 50 0 0 CURBTYPE COLLDATE String 50 0 0 COLLDATE COLLTIME String 50 0 0 COLLTIME LENGTH Single 4 0 0 LENGTH WIDTH String 50 0 0 WIDTH GUTTERWIDT String 50 0 0 GUTTERWIDT ADA_COMPLI String 50 0 0 ADA_COMPLI Field left blank, may be filled in at later date LANDUSE String 50 0 0 LANDUSE PAVED_GUT String 50 0 0 PAVED_GUT LENGTH2 Double 8 0 0 LENGTH2 TRANSITROU String 50 0 0 TRANSITROU Is sidewalk segment parallel to a transit route? FACILITYID String 30 0 0 FACILITYID LEGACYID String 30 0 0 LEGACYID LOCATION String 100 0 0 LOCATION WARRANTYDATE Date 8 0 0 WARRANTYDATE INSTALLDATE Date 8 0 0 INSTALLDATE CONDITION String 30 0 0 CONDITION FORMATTED APN String 50 0 0 APN_FORMAT AREA String 50 0 0 AREA CONDITIONDATE Date 8 0 0 CONDITIONDATE FACID_CALC SmallInteger 2 0 0 Feature geometry. ESRI Coordinates defining the features. FACID_CALC FACID_PREP String 30 0 0 FACID_PREP SW_CERTEXP String 50 0 0 SW_CERTEXP SEQID String 30 0 0 SEQID MAXSLOPE Single 4 0 0 Downloadable Data 20100217 Transystems Corp Robert Mazur GIS Analyst REQUIRED: The mailing and/or physical address for the organization or individual. REQUIRED: The city of the address. REQUIRED: The state or province of the address. REQUIRED: The ZIP or other postal code of the address. 510-835-2761 FGDC Content Standards for Digital Geospatial Metadata FGDC-STD-001-1998 local time http://www.esri.com/metadata/esriprof80.html ESRI Metadata Profile en 20251209 18031100 FALSE 20251209 17413600 20251209 17474200 SideWalkSegmentByAPN_MODFID_STADR_c 002 6037905.060632 6093575.833621 2090440.816618 2141258.935451 1 Projected GCS_North_American_1983 Linear Unit: Foot_US (0.304801) NAD_1983_StatePlane_California_III_FIPS_0403_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/10.8'><WKT>PROJCS["NAD_1983_StatePlane_California_III_FIPS_0403_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",-120.5],PARAMETER["Standard_Parallel_1",37.06666666666667],PARAMETER["Standard_Parallel_2",38.43333333333333],PARAMETER["Latitude_Of_Origin",36.5],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2227]]</WKT><XOrigin>-115860599.99999</XOrigin><YOrigin>-93269499.999957398</YOrigin><XYScale>74549.2261228032</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.00010731164380998101</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102643</WKID><LatestWKID>2227</LatestWKID></ProjectedCoordinateSystem> 1.0 FGDC CSDGM Metadata 150000000 5000 ItemDescription Version 6.2 (Build 9200) ; Esri ArcGIS 10.9.1.28388 SideWalkSegmentByAPN_MODFID_STADR_c 6037905.060632 6093575.833621 2141258.935451 2090440.816618 1 -122.314418 -122.118559 37.864383 37.722039 1 1 -122.314418 -122.118559 37.864383 37.722039 The SidewalkSegmentByAPN dataset has been developed using historical block-level sidewalk line data from the SDE database. The initial block-level sidewalk lines have been divided into smaller segments corresponding to the front footage of the APN along the sidewalk. This method enables the precise assignment of responsibilities and the efficient provision of City services to parcel owners. Given that the sidewalk layer and the parcel layer do not overlap, this integration has been accomplished through various GIS operations, followed by mapping the APN information from the parcel layer to the updated sidewalk layer. Consequently, the dataset has experienced a tenfold increase in records, growing from 10,000 to over 100,000. Furthermore, it is essential to ensure that one of the segment lines in the new SidewalkSegmentByAPN dataset maintains the original facility ID value to prevent the creation of orphan records within the existing work orders in Cityworks. By David Lok, Developed 10/24/2024, revised on 12/3/2025, 12/10/2025 <DIV STYLE="text-align:Left;"><DIV><DIV>The SidewalkSegmentByAPN dataset has been developed using historical block-level sidewalk line data from the SDE database. The initial block-level sidewalk lines have been divided into smaller segments corresponding to the front footage of the APN along the sidewalk. This method enables the precise assignment of responsibilities and the efficient provision of City services to parcel owners. Given that the sidewalk layer and the parcel layer do not overlap, this integration has been accomplished through various GIS operations, followed by mapping the APN information from the parcel layer to the updated sidewalk layer. Consequently, the dataset has experienced a tenfold increase in records, growing from 10,000 to over 100,000.Furthermore, it is essential to ensure that one of the segment lines in the new SidewalkSegmentByAPN dataset retains the original facility ID to prevent orphan records from being created within the existing work orders in Cityworks. The location field is populated with street addresses; add a new field, MAXSLOPE (numeric).By David Lok, Developed 10/24/2024, revised on 12/3/2025, 12/10/2025<TABLE STYLE="margin:0 0 0 0;"><TBODY><TR><TD STYLE="padding:0 0 0 0;">FIELD NAME</TD><TD STYLE="padding:0 0 0 0;">DATATYPE</TD><TD STYLE="padding:0 0 0 0;">LENGTH</TD><TD STYLE="padding:0 0 0 0;">DESCRIPTION</TD><TD STYLE="padding:0 0 0 0;">POSSIBLE VALUES</TD><TD STYLE="padding:0 0 0 0;">NOTE</TD></TR><TR><TD STYLE="padding:0 0 0 0;">ADA_COMPLI</TD><TD STYLE="padding:0 0 0 0;">Text</TD><TD STYLE="padding:0 0 0 0;">50</TD><TD STYLE="padding:0 0 0 0;">Indicate if it is ADA-compliant</TD><TD STYLE="padding:0 0 0 0;">(TBD - NULL)</TD><TD STYLE="padding:0 0 0 0;">NEW FIELD </TD></TR><TR><TD STYLE="padding:0 0 0 0;">APN</TD><TD STYLE="padding:0 0 0 0;">Text</TD><TD STYLE="padding:0 0 0 0;">50</TD><TD STYLE="padding:0 0 0 0;">The delineated sidewalk lines require populating the associated Assessor's Parcel Number (APN) information in each of the new records. </TD><TD COLSPAN="2" STYLE="padding:0 0 0 0;">Format – text field with a value that has a space between characters.</TD></TR><TR><TD STYLE="padding:0 0 0 0;">APN_FORMAT</TD><TD STYLE="padding:0 0 0 0;">Text</TD><TD STYLE="padding:0 0 0 0;">50</TD><TD STYLE="padding:0 0 0 0;">Formatted APN information</TD><TD STYLE="padding:0 0 0 0;">APN values in "-" format</TD><TD STYLE="padding:0 0 0 0;"></TD></TR><TR><TD STYLE="padding:0 0 0 0;">ARCID</TD><TD STYLE="padding:0 0 0 0;">Text</TD><TD STYLE="padding:0 0 0 0;">10</TD><TD STYLE="padding:0 0 0 0;">Information, transferred from the original block-level sidewalk segment dataset</TD><TD STYLE="padding:0 0 0 0;">Numeric</TD><TD STYLE="padding:0 0 0 0;"></TD></TR><TR><TD STYLE="padding:0 0 0 0;">AREA</TD><TD STYLE="padding:0 0 0 0;">Text</TD><TD STYLE="padding:0 0 0 0;">50</TD><TD STYLE="padding:0 0 0 0;"></TD><TD STYLE="padding:0 0 0 0;">NULL (for now)</TD><TD STYLE="padding:0 0 0 0;"></TD></TR><TR><TD STYLE="padding:0 0 0 0;">COLLDATE</TD><TD STYLE="padding:0 0 0 0;">Text</TD><TD STYLE="padding:0 0 0 0;">50</TD><TD STYLE="padding:0 0 0 0;">Collection date data, transferred from the original block-level sidewalk segment dataset</TD><TD STYLE="padding:0 0 0 0;"> </TD><TD STYLE="padding:0 0 0 0;"> </TD></TR><TR><TD STYLE="padding:0 0 0 0;">COLLTIME</TD><TD STYLE="padding:0 0 0 0;">Text</TD><TD STYLE="padding:0 0 0 0;">50</TD><TD STYLE="padding:0 0 0 0;">Collection time data, transferred from the original block-level sidewalk segment dataset</TD><TD STYLE="padding:0 0 0 0;"> </TD><TD STYLE="padding:0 0 0 0;"> </TD></TR><TR><TD STYLE="padding:0 0 0 0;">CONDITION</TD><TD STYLE="padding:0 0 0 0;">Text</TD><TD STYLE="padding:0 0 0 0;">30</TD><TD STYLE="padding:0 0 0 0;"></TD><TD STYLE="padding:0 0 0 0;">(TBD - NULL)</TD><TD STYLE="padding:0 0 0 0;">Field required by Cityworks</TD></TR><TR><TD STYLE="padding:0 0 0 0;">CONDITIONDATE</TD><TD STYLE="padding:0 0 0 0;">Date</TD><TD STYLE="padding:0 0 0 0;"></TD><TD STYLE="padding:0 0 0 0;"></TD><TD STYLE="padding:0 0 0 0;">(TBD - NULL)</TD><TD STYLE="padding:0 0 0 0;">Field required by Cityworks</TD></TR><TR><TD STYLE="padding:0 0 0 0;">COUNCILID</TD><TD STYLE="padding:0 0 0 0;">Text</TD><TD STYLE="padding:0 0 0 0;">10</TD><TD STYLE="padding:0 0 0 0;">Council district identification information, retained from the original block-level sidewalk segment dataset.</TD><TD STYLE="padding:0 0 0 0;"> </TD><TD STYLE="padding:0 0 0 0;"> </TD></TR><TR><TD STYLE="padding:0 0 0 0;">CURBTYPE</TD><TD STYLE="padding:0 0 0 0;">Text</TD><TD STYLE="padding:0 0 0 0;">50</TD><TD STYLE="padding:0 0 0 0;">Curb type information has been retained from the original block-level sidewalk segment dataset.</TD><TD STYLE="padding:0 0 0 0;">A, B, C, D, Other</TD><TD STYLE="padding:0 0 0 0;"></TD></TR><TR><TD STYLE="padding:0 0 0 0;">FACID_CALC</TD><TD STYLE="padding:0 0 0 0;">Short</TD><TD STYLE="padding:0 0 0 0;"></TD><TD STYLE="padding:0 0 0 0;">KEEP - Required by GIS operation to compute the Facility ID formatting</TD><TD STYLE="padding:0 0 0 0;"></TD><TD STYLE="padding:0 0 0 0;">NEW FIELD - Required by GIS</TD></TR><TR><TD STYLE="padding:0 0 0 0;">FACID_PREP</TD><TD STYLE="padding:0 0 0 0;">Text</TD><TD STYLE="padding:0 0 0 0;">30</TD><TD STYLE="padding:0 0 0 0;">KEEP - Required by GIS operation to compute the Facility ID formatting</TD><TD STYLE="padding:0 0 0 0;"></TD><TD STYLE="padding:0 0 0 0;">NEW FIELD - Required by GIS</TD></TR><TR><TD STYLE="padding:0 0 0 0;">FACILITYID</TD><TD STYLE="padding:0 0 0 0;">Text</TD><TD STYLE="padding:0 0 0 0;"></TD><TD STYLE="padding:0 0 0 0;">One of the delineated segment lines from the original block-level sidewalk lines must retain its original facility ID value. This measure is essential to prevent the generation of orphan records in Cityworks on existing work orders</TD><TD STYLE="padding:0 0 0 0;">This field is essential and must be a unique identifier. Format: use '-' to separate the different segments of the group.</TD><TD STYLE="padding:0 0 0 0;">Per NEW format and requirements </TD></TR><TR><TD STYLE="padding:0 0 0 0;">GUTTERWIDT</TD><TD STYLE="padding:0 0 0 0;">Text</TD><TD STYLE="padding:0 0 0 0;">50</TD><TD COLSPAN="3" STYLE="padding:0 0 0 0;">The width of the gutter at the sidewalk segment is information carried over from the original block-level sidewalk segment dataset.</TD></TR><TR><TD STYLE="padding:0 0 0 0;">INSTALLDATE</TD><TD STYLE="padding:0 0 0 0;">Date</TD><TD STYLE="padding:0 0 0 0;"></TD><TD STYLE="padding:0 0 0 0;"></TD><TD STYLE="padding:0 0 0 0;">(TBD - NULL)</TD><TD STYLE="padding:0 0 0 0;">NEW FIELD - Field required by Cityworks</TD></TR><TR><TD STYLE="padding:0 0 0 0;">LANDUSE</TD><TD STYLE="padding:0 0 0 0;">Text</TD><TD STYLE="padding:0 0 0 0;">50</TD><TD STYLE="padding:0 0 0 0;">Land utilization data, transferred from the original block-level sidewalk segment dataset</TD><TD STYLE="padding:0 0 0 0;">Com. EssFac, Res</TD><TD STYLE="padding:0 0 0 0;"></TD></TR><TR><TD STYLE="padding:0 0 0 0;">LEGACYID</TD><TD STYLE="padding:0 0 0 0;">Text</TD><TD STYLE="padding:0 0 0 0;">30</TD><TD STYLE="padding:0 0 0 0;">Holds the original FACILITYID values before delineation of the original block-level sidewalk lines</TD><TD STYLE="padding:0 0 0 0;">Original/historical facilityID</TD><TD STYLE="padding:0 0 0 0;">NEW FIELD - Field required by Cityworks: Preserve the original FacilityID prior to segment breakdown.</TD></TR><TR><TD STYLE="padding:0 0 0 0;">LENGTH</TD><TD STYLE="padding:0 0 0 0;">Double</TD><TD STYLE="padding:0 0 0 0;"></TD><TD STYLE="padding:0 0 0 0;">Manual GIS calculated individual segment length following delineation by APN boundaries.</TD><TD STYLE="padding:0 0 0 0;"> </TD><TD STYLE="padding:0 0 0 0;">NEW FIELD ADDED</TD></TR><TR><TD STYLE="padding:0 0 0 0;">LENGTH2</TD><TD STYLE="padding:0 0 0 0;">Double</TD><TD STYLE="padding:0 0 0 0;"></TD><TD STYLE="padding:0 0 0 0;">Previous GIS software automatically calculated the block-level segment line length before delineating by APN boundaries.</TD><TD STYLE="padding:0 0 0 0;"> </TD><TD STYLE="padding:0 0 0 0;">KEEP </TD></TR><TR><TD STYLE="padding:0 0 0 0;">SHAPE_Length</TD><TD STYLE="padding:0 0 0 0;">Double</TD><TD STYLE="padding:0 0 0 0;"></TD><TD STYLE="padding:0 0 0 0;">GIS software automatically calculated the segment line length after delineation by APN boundaries.</TD><TD STYLE="padding:0 0 0 0;"> </TD><TD STYLE="padding:0 0 0 0;"> </TD></TR><TR><TD STYLE="padding:0 0 0 0;">LOCATION</TD><TD STYLE="padding:0 0 0 0;">Text</TD><TD STYLE="padding:0 0 0 0;">100</TD><TD STYLE="padding:0 0 0 0;">Street (SITUS) information </TD><TD STYLE="padding:0 0 0 0;"></TD><TD STYLE="padding:0 0 0 0;">NEW FIELD - Field required by Cityworks</TD></TR><TR><TD STYLE="padding:0 0 0 0;">OBJECTID</TD><TD STYLE="padding:0 0 0 0;"></TD><TD STYLE="padding:0 0 0 0;"></TD><TD STYLE="padding:0 0 0 0;">Auto-generated </TD><TD STYLE="padding:0 0 0 0;"></TD><TD STYLE="padding:0 0 0 0;">Required Field</TD></TR><TR><TD STYLE="padding:0 0 0 0;">PAVED_GUT</TD><TD STYLE="padding:0 0 0 0;">Text</TD><TD STYLE="padding:0 0 0 0;">50</TD><TD STYLE="padding:0 0 0 0;">Indicates whether the gutter is paved over</TD><TD STYLE="padding:0 0 0 0;">1, 0</TD><TD STYLE="padding:0 0 0 0;"></TD></TR><TR><TD STYLE="padding:0 0 0 0;">PLANAREAID</TD><TD STYLE="padding:0 0 0 0;">Text</TD><TD STYLE="padding:0 0 0 0;">10</TD><TD STYLE="padding:0 0 0 0;">Planning Areas are non-political geographies</TD><TD STYLE="padding:0 0 0 0;">Numbers</TD><TD STYLE="padding:0 0 0 0;"></TD></TR><TR><TD STYLE="padding:0 0 0 0;">SEGMENTID</TD><TD STYLE="padding:0 0 0 0;">Text</TD><TD STYLE="padding:0 0 0 0;">10</TD><TD STYLE="padding:0 0 0 0;">Segment ID</TD><TD STYLE="padding:0 0 0 0;"></TD><TD STYLE="padding:0 0 0 0;"></TD></TR><TR><TD STYLE="padding:0 0 0 0;">SURVEYOR</TD><TD STYLE="padding:0 0 0 0;">Text</TD><TD STYLE="padding:0 0 0 0;">50</TD><TD STYLE="padding:0 0 0 0;">Surveyor</TD><TD STYLE="padding:0 0 0 0;"></TD><TD STYLE="padding:0 0 0 0;"></TD></TR><TR><TD STYLE="padding:0 0 0 0;">SW_CERTBEG</TD><TD STYLE="padding:0 0 0 0;">Text</TD><TD STYLE="padding:0 0 0 0;">50</TD><TD STYLE="padding:0 0 0 0;">Date that the certificate was obtained</TD><TD STYLE="padding:0 0 0 0;">(TBD - NULL)</TD><TD STYLE="padding:0 0 0 0;">NEW FIELD ADDED</TD></TR><TR><TD STYLE="padding:0 0 0 0;">SW_CERTTYP</TD><TD STYLE="padding:0 0 0 0;">Text</TD><TD STYLE="padding:0 0 0 0;">50</TD><TD STYLE="padding:0 0 0 0;">Specifies whether the parcel currently has an active sidewalk certificate.</TD><TD COLSPAN="2" STYLE="padding:0 0 0 0;">Standard, Provisional, Exemption, None</TD></TR><TR><TD STYLE="padding:0 0 0 0;">SW_CERTEXP</TD><TD STYLE="padding:0 0 0 0;">Text</TD><TD STYLE="padding:0 0 0 0;">50</TD><TD STYLE="padding:0 0 0 0;">Date of expiration of the certificate</TD><TD STYLE="padding:0 0 0 0;">(TBD - NULL)</TD><TD STYLE="padding:0 0 0 0;">NEW FIELD ADDED</TD></TR><TR><TD STYLE="padding:0 0 0 0;">TRANSITROU</TD><TD STYLE="padding:0 0 0 0;">Text</TD><TD STYLE="padding:0 0 0 0;">50</TD><TD STYLE="padding:0 0 0 0;">Availability of bus service on the nearby roadway.</TD><TD STYLE="padding:0 0 0 0;">1 ,0</TD><TD STYLE="padding:0 0 0 0;"></TD></TR><TR><TD STYLE="padding:0 0 0 0;">TREE</TD><TD STYLE="padding:0 0 0 0;">Text</TD><TD STYLE="padding:0 0 0 0;">50</TD><TD STYLE="padding:0 0 0 0;">Tree</TD><TD STYLE="padding:0 0 0 0;">Y / N</TD><TD STYLE="padding:0 0 0 0;"></TD></TR><TR><TD STYLE="padding:0 0 0 0;">WARRANTYDATE</TD><TD STYLE="padding:0 0 0 0;">Date</TD><TD STYLE="padding:0 0 0 0;"></TD><TD STYLE="padding:0 0 0 0;"></TD><TD STYLE="padding:0 0 0 0;">(TBD - NULL)</TD><TD STYLE="padding:0 0 0 0;">NEW FIELD - Field required by Cityworks</TD></TR><TR><TD STYLE="padding:0 0 0 0;">MAXSLOPE</TD><TD STYLE="padding:0 0 0 0;">Float</TD><TD STYLE="padding:0 0 0 0;"></TD><TD STYLE="padding:0 0 0 0;">Slope</TD><TD STYLE="padding:0 0 0 0;"></TD><TD STYLE="padding:0 0 0 0;">NEW FIELD ADDED</TD></TR></TBODY></TABLE><TABLE STYLE="margin:0 0 0 0;"><TBODY><TR><TD STYLE="padding:0 0 0 0;"></TD><TD STYLE="padding:0 0 0 0;"></TD><TD STYLE="padding:0 0 0 0;"></TD><TD STYLE="padding:0 0 0 0;"></TD><TD STYLE="padding:0 0 0 0;"></TD><TD STYLE="padding:0 0 0 0;"></TD></TR></TBODY></TABLE></DIV></DIV></DIV> David Lok, City of Oakland Sidewalk Segment By APN <DIV STYLE="text-align:Left;"><DIV><DIV>None</DIV></DIV></DIV> ISO 19115 Geographic Information - Metadata DIS_ESRI1.0 dataset 002 withheld Feature Class File Geodatabase Feature Class NAD_1983_StatePlane_California_III_FIPS_0403_Feet EPSG 5.3(9.0.0) 101437 20251209 /9j/4AAQSkZJRgABAgAAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0aHBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCACFAMgDASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD1uiiikAVahvpY+H/eL79aq0UAbMN1FPwrYb+6eDU1YFWYb6WLhj5i+/X86ANak285BwfUVFDdRT8K2G/unrU1IAEhX7449RUgIIyDkVHSbcHKkqfancB7oWIIOCOnpUMrOkbYX5scc8fnUgkI++PxFSAhhkHIoAqQSyNhZUwxzyPQY5qelMQHKHb7dqaSV++Me/agBaRlDdRS0UgIWiI6ciqctmjElPkb26flWlSFQ3UVVx3MR7ecEIEJLHAYcj61swxLDCkafdUYpwUL0FLSEFIRvYL26ml6cmliB27j1bmgB7MFUk9BUSggZPU8mlkO5wvYcmihgFFFFIDAooopgFFFFABRRRQAVZhvpYuGO9fQ9fzqtRQBrx3SzAeWV3d0fg1Ksik7TlW/ut/nmsOp47uRRtfEiejdfzoA2KTbg5U7T7VVhuVfhHyf+ecnX8D3qwsisdvIb+6etAEgkI++PxFPBDDIOQajpNuDlTtPtRcBxiA5Q7fbtTSSv3xj37UokI++PxFZKxahazTSCZpYSzSfMd2c8BAO3b070Aa1FVLa6jmbytypOCQVHIbHUj2zxn1q1u2/eGPftQAtFFFIBCN7BO3U/SpSQqknoKZEDgserfypJDlwnYcmmAig4yep5NLRRSAKKKKAMCitOXT435iPln07VQlglgP7xcD+8OlMCOiiigAooooAKKKKACiiigAqeO6kUBXxIo6Buo+hqCigDUhulfhWz/sOcN+B7/55qysiucDhh1U9RWFUyXMigBvnUdA3UfQ9RQBs0m3Byp2n2qpDeB8AHJ/utw34Hof0q0rq+dp5HUHgj8KAIpYgytwEcoUEijIAPtUVlZy25ijWbMKIc4xhyTwMdsD881cpNuDlTtPtRcBxiA5Q7fbtTG3dGGB1J7YpwlK/fH4iqupXcsEOLYbpTz0zgc8479O3PWgBLK7NxJK6ypJDnONpBTsB6Hp+dWlzyT1PJpkUH7rdtRJHwW2Dg+nWnklfvjHuOlDAWijrRSAKKKKACg8jBoooApzafG+TGfLb07flVCWCWD/WLgf3hyK26Dz1oAwKK05tPjfmM+W3oOn5VQmglgP7xcD+8ORTAjooooAKKKKACiiigAooooAKmiuJBJGn38tgAnkeuD2qGrFjD5spcjjlR9P4j/IfnQBqQlmjBY5z0J647U+iikA1iOh6dT9KzYBFf3b3BZXRe6kqQvZT2YcH6cipdQuBHEIhMIpJ+Fc9AB+I/n60+ygMVsgfG9/mc9yOwJwP5UwLiykfeXA9RzUgYMMggio6QrzkEqfUUXAcYhnKnafbpTSWT7w49R0pRIy/eGR6j/CpFYMMg5oAoveeU53odhOFIH5nNFW3hR88Yz196KLAJRRRSAKKKKACmSuscTO3IA6etPrO1GbLLCOg+Zv6UAUfU4AzzxRRRTAKKKKACiiigAooooAQhmIRPvscCtm0iWKEbemAB9O3+P41nWUPmzFz93lR9P4j/IfjWxQAjMEUsxAA9TVa3aaVmEhO0ngFcYH9asSJ5i43FfcU6BAFyBgHp9KAKMtjNLqQnlYfZ1HQPn8MEdD3Gewq6vOWPU80spyQn4n6UUMAooJAGT0pkcscy5jcMPakA+k2jORwfUUtFAAHZfvDcPUdaKKKdwCiiikAUUUUANkcRxs7dFGaw2Yu7O33mOTV7UZuVhB/2m/pVCmAUUUUAFFFFABRRRQAUh3HCoMuxwv1pamsovOmLEfKMqP/AGY/0/GgDRs4lihG3oQAPp/9fk/jViiigBD8xCevX6VKcKM9hTIhnLnv0+lJKckJ68n6UAIvOWPU0tFFICpqEuyDYD8z8fh3rMBKnKkgjuDUt1L51wzA/KOF+lQ0wLkWoSJgSDePUcGr0VxFN9xxn0PWsWjuD3FAG/RWVFfTR4DfOvv1/OikBq0UUUAFNdxGjO3QDJp1Z+ozfdhB92/pQBSdzI7O3Vjmm0UUwCiiigAooooAKKKKAEO44VRlmOFHvWxZwrFCMdMYB9R6/jyfxrOs4fOnLdh8o/qfy4/GtnpwKACkPzEKO/8AKlpYhnL+vA+lAD+APQColycsepp0pzhPXk/SkoYBVe9m8q3OD8zfKKsVkXsvm3BAPyp8o/rSAr0UUUwCiiigAooooA36KKKQCO4RGdjgAZNYbuZJGdurHNXtRm4WEHry39Kz6YBRRRQAUUUUAFFFFABSHPAUZZjhR70tWdOh825Mp+7Hwvu3/wCqgDQt7dbeJVHULgn1qaiikAjc4UdT/KpeFHoBTIhklz34H0olOcIO/X6UwGjklj1P8qWiikBDdTeTAzD73RfrWNVvUJfMm8sHhP51UpgFFFFABRRRQAUUUUAb9FFFIDCkcySM7dWOabRRTAKKKKACiiigAooooAa7bUZvQZrbtIlhtY0X0yT6k0UUATU1umPU4oopATAYGB0qIcszd84/KiimwFpsjbIncfwgmiikBhEknJOSeSaKKKYBRRRQAUUUUAFFFFAH/9k=