{ "layers" : [ { "currentVersion" : 12, "id" : 0, "name" : "GISADMIN.FullTrashCaptureUnitLocations", "type" : "Feature Layer", "serviceItemId" : "42dc336ce3df4edc8ecb1f1ccde4e401", "displayField" : "NAME", "description" : "This datalayer gives locations of all full trash capture compliant devices managed by or within a Permittees jurisdiction. This may not include devices within a Permittee’s boundary that are not managed by the Permittee (i.e. private, county, state, and federal agencies). Types of devices may include public and private connector pipe screens (CPS), basket type devices, hydrodynamic separators (HDS or CDS), Gross Solid Removal Devices (GSRD), and Netting devices. These devices should have corresponding treatment areas in the full capture polygon GIS datalayer. Additional information in this GIS datalayer may include partial capture devices, removed devices, planned devices, and non-functioning devices. Devices that are not actively full capture should be noted as such, and the DisplayMap attribute should not equal “yes” for the purposes of only mapping devices that are full capture. This information has been gathered by EOA for the purposes of mapping and cataloging these devices for the Long-Term Trash Reduction Plan. The quality of this data varies in the locational accuracy of the device and in the current functioning status of the device. Many of these locations have been field verified and others have not. ", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1741800089281, "schemaLastEditDate" : 1741800089281, "dataLastEditDate" : 1603123992377 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : 6044994.9734712988, "ymin" : 2103303.6245807707, "xmax" : 6074073.9861233979, "ymax" : 2125192.1302794069, "spatialReference" : { "wkid" : 102643, "latestWkid" : 2227 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[173,0,87,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"label":"","description":""},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GLOBALID", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "NAME", "type" : "esriFieldTypeString", "alias" : "NAME", "sqlType" : "sqlTypeOther", "length" : 254, "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COMMENTS", "type" : "esriFieldTypeString", "alias" : "COMMENTS", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DISPLAYMAP", "type" : "esriFieldTypeString", "alias" : "DISPLAYMAP", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FCD_ID", "type" : "esriFieldTypeString", "alias" : "FCD_ID", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DEVICESTYPES", "type" : "esriFieldTypeString", "alias" : "DevicesTypes", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "TrashCaptureDevices", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Inlets basket (public & private connector pipe screens", "code" : "CPS" }, { "name" : "Hydrodynamic separators (HDS or CDS),", "code" : "CDS" }, { "name" : "Gross Solid Removal Devices", "code" : "GSRD" }, { "name" : "Netting devices", "code" : "NET" } ] }, "defaultValue" : null }, { "name" : "GLOBALID", "type" : "esriFieldTypeGlobalID", "alias" : "GLOBALID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__MYMAPSER__F4B70D857D07D6AD", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_4148.MYMAPSERVICE2_GISADMIN_FULLTRASHCAPTUREUNITLOCATIONS_Shape_sidx", "fields" : "SHAPE", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "FDO_GLOBALID", "fields" : "GLOBALID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "GISADMIN.FullTrashCaptureUnitLocations", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "DEVICESTYPES" : null, "FCD_ID" : " ", "NAME" : " ", "COMMENTS" : " ", "DISPLAYMAP" : " " } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Create,Delete,Query,Update,Editing" }, { "currentVersion" : 12, "id" : 1, "name" : "GISADMIN.StreetSweepingRoutes", "type" : "Feature Layer", "serviceItemId" : "42dc336ce3df4edc8ecb1f1ccde4e401", "displayField" : "NAME", "description" : "Person responsible for the data (as of September 2013): Frank Foster, Operations Manager, PWA Keep Oakland Clean and Beautiful (KOCB)Subject Matter Experts (as of September 2013): Art Watson and Robert Newman, supervisors, Keep Oakland Clean and BeautifulPerson responsible for the data in GIS (as of September 2013): Noushin AdabiIn 2013, PWA KOCB worked with a GIS intern to replace older, erroneous GIS data with correct data. Data was taken from paper-based maps and tables, and translated to GIS. KOCB staff did intial QC on the data. Further QC identified by Noushin Adabi, performed by KOCB, and updated in GIS by Noushin Adabi.;", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1741800089281, "schemaLastEditDate" : 1741800089281, "dataLastEditDate" : 1603124014330 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : true, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "hasGeometryProperties" : true, "geometryProperties" : { "shapeLengthFieldName" : "Shape__Length" }, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolyline", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : 6027573.3281508386, "ymin" : 2081670.5932097584, "xmax" : 6094722.6695773154, "ymax" : 2148911.9934993088, "spatialReference" : { "wkid" : 102643, "latestWkid" : 2227 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,48,145,255],"width":1},"label":"","description":""},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GLOBALID", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "DYNAMAP_ID", "type" : "esriFieldTypeDouble", "alias" : "DYNAMAP_ID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "L_F_ADD", "type" : "esriFieldTypeString", "alias" : "L_F_ADD", "sqlType" : "sqlTypeOther", "length" : 11, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "L_T_ADD", "type" : "esriFieldTypeString", "alias" : "L_T_ADD", "sqlType" : "sqlTypeOther", "length" : 11, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "R_F_ADD", "type" : "esriFieldTypeString", "alias" : "R_F_ADD", "sqlType" : "sqlTypeOther", "length" : 11, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "R_T_ADD", "type" : "esriFieldTypeString", "alias" : "R_T_ADD", "sqlType" : "sqlTypeOther", "length" : 11, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PREFIX", "type" : "esriFieldTypeString", "alias" : "PREFIX", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NAME", "type" : "esriFieldTypeString", "alias" : "NAME", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TYPE", "type" : "esriFieldTypeString", "alias" : "TYPE", "sqlType" : "sqlTypeOther", "length" : 6, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SUFFIX", "type" : "esriFieldTypeString", "alias" : "SUFFIX", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FCC", "type" : "esriFieldTypeString", "alias" : "FCC", "sqlType" : "sqlTypeOther", "length" : 3, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "POSTAL_L", "type" : "esriFieldTypeString", "alias" : "POSTAL_L", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "POSTAL_R", "type" : "esriFieldTypeString", "alias" : "POSTAL_R", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ACC", "type" : "esriFieldTypeString", "alias" : "ACC", "sqlType" : "sqlTypeOther", "length" : 1, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NAME_TYPE", "type" : "esriFieldTypeString", "alias" : "NAME_TYPE", "sqlType" : "sqlTypeOther", "length" : 1, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SHIELD", "type" : "esriFieldTypeString", "alias" : "SHIELD", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HWY_NUM", "type" : "esriFieldTypeString", "alias" : "HWY_NUM", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SEG_LEN", "type" : "esriFieldTypeDouble", "alias" : "SEG_LEN", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SPEED", "type" : "esriFieldTypeSmallInteger", "alias" : "SPEED", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ONE_WAY", "type" : "esriFieldTypeString", "alias" : "ONE_WAY", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "F_ZLEV", "type" : "esriFieldTypeSmallInteger", "alias" : "F_ZLEV", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "T_ZLEV", "type" : "esriFieldTypeSmallInteger", "alias" : "T_ZLEV", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FT_COST", "type" : "esriFieldTypeDouble", "alias" : "FT_COST", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TF_COST", "type" : "esriFieldTypeDouble", "alias" : "TF_COST", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FT_DIR", "type" : "esriFieldTypeString", "alias" : "FT_DIR", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TF_DIR", "type" : "esriFieldTypeString", "alias" : "TF_DIR", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NAME_FLAG", "type" : "esriFieldTypeSmallInteger", "alias" : "NAME_FLAG", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NOTES", "type" : "esriFieldTypeString", "alias" : "NOTES", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ROUTE", "type" : "esriFieldTypeString", "alias" : "ROUTE", "sqlType" : "sqlTypeOther", "length" : 4, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DAY_ODD", "type" : "esriFieldTypeString", "alias" : "DAY_ODD", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "StreetSweepingD", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Everyday", "code" : "E" }, { "name" : "No Signage", "code" : "N-S" }, { "name" : "No Sweeping (Exempt)", "code" : "N" }, { "name" : "No Odd Addresses", "code" : "N-O" }, { "name" : "No Even Addresses", "code" : "N-E" }, { "name" : "2nd Wed", "code" : "W2" }, { "name" : "4th Wed", "code" : "W4" }, { "name" : "2nd Thurs", "code" : "TH2" }, { "name" : "4th Thurs", "code" : "TH4" }, { "name" : "2nd Fri", "code" : "F2" }, { "name" : "4th Fri", "code" : "F4" }, { "name" : "Every Sat", "code" : "S" }, { "name" : "Every Sun", "code" : "SU" }, { "name" : "Every Thurs", "code" : "THE" }, { "name" : "Every Fri", "code" : "FE" }, { "name" : "2nd Mon", "code" : "M2" }, { "name" : "1st Thurs", "code" : "TH1" }, { "name" : "1st Fri", "code" : "F1" }, { "name" : "Every Mon, Wed, Fri", "code" : "MWF" }, { "name" : "Every Tues, Thurs, Sat", "code" : "TTHS" }, { "name" : "Every Tues, Thurs", "code" : "TTH" }, { "name" : "Every Mon to Fri", "code" : "MF" }, { "name" : "Every Mon", "code" : "ME" }, { "name" : "Every Wed", "code" : "WE" }, { "name" : "Every Tues", "code" : "TE" }, { "name" : "It is shown in the different map.", "code" : "DM" }, { "name" : "It is a major street so it is not using Centerline, it uses 2 lines.", "code" : "MS" }, { "name" : "No Sweeping (Within City Of Oakland Limit)", "code" : "NS" }, { "name" : "No Sweeping (Uncontrol Condition)", "code" : "NS-UC" }, { "name" : "No Sweeping (HYW)", "code" : "NS-H" }, { "name" : "No Sweeping (Outside Of The City Limit)", "code" : "NS-O" }, { "name" : "2nd Tues", "code" : "T2" }, { "name" : "1st Mon", "code" : "M1" }, { "name" : "1st Tues", "code" : "T1" }, { "name" : "No Sweeping(Alleyways)", "code" : "NS-A" }, { "name" : "There is no this side of the street", "code" : "O" }, { "name" : "1st and 3rd Mon", "code" : "M13" }, { "name" : "2nd and 4th Mon", "code" : "M24" }, { "name" : "1st and 3rd Tues", "code" : "T13" }, { "name" : "2nd and 4th Tues", "code" : "T24" }, { "name" : "1st and 3rd Wed", "code" : "W13" }, { "name" : "1st and 3rd Thurs", "code" : "TH13" }, { "name" : "1st and 3rd Fri", "code" : "F13" }, { "name" : "Every Tues and Fri", "code" : "TFE" }, { "name" : "Every Mon and Thurs", "code" : "MTHE" }, { "name" : "Every Thurs and Fri", "code" : "THFE" }, { "name" : "Every Mon and Fri", "code" : "MFE" }, { "name" : "Every Tues and Thurs", "code" : "TTHE" }, { "name" : "Everyday except Holidays", "code" : "EEH" }, { "name" : "Everyday except Saturday, Sunday & Holidays", "code" : "EESSH" }, { "name" : "First Wednesday", "code" : "FW" } ] }, "defaultValue" : null }, { "name" : "TIME_ODD", "type" : "esriFieldTypeString", "alias" : "TIME_ODD", "sqlType" : "sqlTypeOther", "length" : 15, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "StreetSweepingT", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "3:00AM-6:00AM", "code" : "M2" }, { "name" : "9:00AM-12:00PM", "code" : "M3" }, { "name" : "12:30PM-3:30PM", "code" : "A1" }, { "name" : "12:00AM-3:00AM", "code" : "M1" }, { "name" : "2:00AM-3:00AM", "code" : "M23" }, { "name" : "6:00AM-8:00AM", "code" : "M68" }, { "name" : "NA", "code" : "NA" } ] }, "defaultValue" : null }, { "name" : "DAY_EVEN", "type" : "esriFieldTypeString", "alias" : "DAY_EVEN", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "StreetSweepingD", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Everyday", "code" : "E" }, { "name" : "No Signage", "code" : "N-S" }, { "name" : "No Sweeping (Exempt)", "code" : "N" }, { "name" : "No Odd Addresses", "code" : "N-O" }, { "name" : "No Even Addresses", "code" : "N-E" }, { "name" : "2nd Wed", "code" : "W2" }, { "name" : "4th Wed", "code" : "W4" }, { "name" : "2nd Thurs", "code" : "TH2" }, { "name" : "4th Thurs", "code" : "TH4" }, { "name" : "2nd Fri", "code" : "F2" }, { "name" : "4th Fri", "code" : "F4" }, { "name" : "Every Sat", "code" : "S" }, { "name" : "Every Sun", "code" : "SU" }, { "name" : "Every Thurs", "code" : "THE" }, { "name" : "Every Fri", "code" : "FE" }, { "name" : "2nd Mon", "code" : "M2" }, { "name" : "1st Thurs", "code" : "TH1" }, { "name" : "1st Fri", "code" : "F1" }, { "name" : "Every Mon, Wed, Fri", "code" : "MWF" }, { "name" : "Every Tues, Thurs, Sat", "code" : "TTHS" }, { "name" : "Every Tues, Thurs", "code" : "TTH" }, { "name" : "Every Mon to Fri", "code" : "MF" }, { "name" : "Every Mon", "code" : "ME" }, { "name" : "Every Wed", "code" : "WE" }, { "name" : "Every Tues", "code" : "TE" }, { "name" : "It is shown in the different map.", "code" : "DM" }, { "name" : "It is a major street so it is not using Centerline, it uses 2 lines.", "code" : "MS" }, { "name" : "No Sweeping (Within City Of Oakland Limit)", "code" : "NS" }, { "name" : "No Sweeping (Uncontrol Condition)", "code" : "NS-UC" }, { "name" : "No Sweeping (HYW)", "code" : "NS-H" }, { "name" : "No Sweeping (Outside Of The City Limit)", "code" : "NS-O" }, { "name" : "2nd Tues", "code" : "T2" }, { "name" : "1st Mon", "code" : "M1" }, { "name" : "1st Tues", "code" : "T1" }, { "name" : "No Sweeping(Alleyways)", "code" : "NS-A" }, { "name" : "There is no this side of the street", "code" : "O" }, { "name" : "1st and 3rd Mon", "code" : "M13" }, { "name" : "2nd and 4th Mon", "code" : "M24" }, { "name" : "1st and 3rd Tues", "code" : "T13" }, { "name" : "2nd and 4th Tues", "code" : "T24" }, { "name" : "1st and 3rd Wed", "code" : "W13" }, { "name" : "1st and 3rd Thurs", "code" : "TH13" }, { "name" : "1st and 3rd Fri", "code" : "F13" }, { "name" : "Every Tues and Fri", "code" : "TFE" }, { "name" : "Every Mon and Thurs", "code" : "MTHE" }, { "name" : "Every Thurs and Fri", "code" : "THFE" }, { "name" : "Every Mon and Fri", "code" : "MFE" }, { "name" : "Every Tues and Thurs", "code" : "TTHE" }, { "name" : "Everyday except Holidays", "code" : "EEH" }, { "name" : "Everyday except Saturday, Sunday & Holidays", "code" : "EESSH" }, { "name" : "First Wednesday", "code" : "FW" } ] }, "defaultValue" : null }, { "name" : "TIME_EVEN", "type" : "esriFieldTypeString", "alias" : "TIME_EVEN", "sqlType" : "sqlTypeOther", "length" : 15, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "StreetSweepingT", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "3:00AM-6:00AM", "code" : "M2" }, { "name" : "9:00AM-12:00PM", "code" : "M3" }, { "name" : "12:30PM-3:30PM", "code" : "A1" }, { "name" : "12:00AM-3:00AM", "code" : "M1" }, { "name" : "2:00AM-3:00AM", "code" : "M23" }, { "name" : "6:00AM-8:00AM", "code" : "M68" }, { "name" : "NA", "code" : "NA" } ] }, "defaultValue" : null }, { "name" : "MAPNO", "type" : "esriFieldTypeString", "alias" : "MAPNO", "sqlType" : "sqlTypeOther", "length" : 4, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DOUBLECK", "type" : "esriFieldTypeString", "alias" : "DOUBLECK", "sqlType" : "sqlTypeOther", "length" : 1, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SIDEOFSTREET", "type" : "esriFieldTypeString", "alias" : "SIDEOFSTREET", "sqlType" : "sqlTypeOther", "length" : 1, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GLOBALID", "type" : "esriFieldTypeGlobalID", "alias" : "GLOBALID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Length", "type" : "esriFieldTypeDouble", "alias" : "Shape__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__MYMAPSER__F4B70D85524570B1", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_4148.MYMAPSERVICE2_GISADMIN_STREETSWEEPINGROUTES_Shape_sidx", "fields" : "SHAPE", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "FDO_GLOBALID", "fields" : "GLOBALID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Length_Index", "fields" : "Shape__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "GISADMIN.StreetSweepingRoutes", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "SIDEOFSTREET" : null, "DOUBLECK" : null, "DYNAMAP_ID" : null, "L_F_ADD" : null, "L_T_ADD" : null, "R_F_ADD" : null, "R_T_ADD" : null, "PREFIX" : null, "NAME" : null, "TYPE" : null, "SUFFIX" : null, "FCC" : null, "POSTAL_L" : null, "POSTAL_R" : null, "ACC" : null, "NAME_TYPE" : null, "SHIELD" : null, "HWY_NUM" : null, "SEG_LEN" : null, "SPEED" : null, "ONE_WAY" : null, "F_ZLEV" : null, "T_ZLEV" : null, "FT_COST" : null, "TF_COST" : null, "FT_DIR" : null, "TF_DIR" : null, "NAME_FLAG" : null, "NOTES" : null, "ROUTE" : null, "DAY_ODD" : null, "TIME_ODD" : null, "DAY_EVEN" : null, "TIME_EVEN" : null, "MAPNO" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 2000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Create,Delete,Query,Update,Editing" }, { "currentVersion" : 12, "id" : 2, "name" : "GISADMIN.FullTrashCaptureDrainageArea", "type" : "Feature Layer", "serviceItemId" : "42dc336ce3df4edc8ecb1f1ccde4e401", "displayField" : "FC_NAME", "description" : "This datalayer gives locations of all full trash capture treatment areas for full trash capture compliant devices managed by or within a Permittees jurisdiction. This datalayer may not include full trash capture areas within a Permittees boundary that are not managed by the Permittee (i.e. private, county, state, and federal agencies). Types of full trash capture areas may include public and private connector pipe screens (CPS), basket type devices, hydrodynamic separators (HDS or CDS), Gross Solid Removal Devices (GSRD), and Netting devices. These areas should have corresponding treatment points in the full capture point GIS datalayer, although often areas are combined and include many devices. Additional information in this GIS datalayer may include partial capture treatment areas, areas that drain to sanitary sewer and areas that drain removed devices, planned devices, and non-functioning devices. Devices that are not actively full capture should be noted as such, and the DisplayMap attribute should not equal “yes” for the purposes of only mapping devices that are full capture. Full capture areas should not overlap, and polygons should be merged together to avoid any potential overlaps. Care should be taken to draw adjacent polygons with no gaps or sliver overlaps so that area and trash load calculations are more accurate. This information has been gathered by EOA for the purposes of mapping and cataloging these devices for the Long-Term Trash Reduction Plan. The methodology and the assumptions used to draw treatment areas vary widely depending on agency.", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1741800089281, "schemaLastEditDate" : 1741800089281, "dataLastEditDate" : 1603124014580 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : true, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "hasGeometryProperties" : true, "geometryProperties" : { "shapeAreaFieldName" : "Shape__Area", "shapeLengthFieldName" : "Shape__Length" }, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : true, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolygon", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : 6044897.6462645829, "ymin" : 2103187.67003119, "xmax" : 6080096.6827104986, "ymax" : 2126451.4661307633, "spatialReference" : { "wkid" : 102643, "latestWkid" : 2227 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[237,242,191,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.4}},"label":"","description":""},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GLOBALID", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "FC_NAME", "type" : "esriFieldTypeString", "alias" : "FC_NAME", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FC_NOTES", "type" : "esriFieldTypeString", "alias" : "FC_NOTES", "sqlType" : "sqlTypeOther", "length" : 200, "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FC_ACRES", "type" : "esriFieldTypeDouble", "alias" : "FC_ACRES", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TTA_ID", "type" : "esriFieldTypeString", "alias" : "TTA_ID", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DEVICESTYPES", "type" : "esriFieldTypeString", "alias" : "DevicesTypes", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "TrashCaptureDevices", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Inlets basket (public & private connector pipe screens", "code" : "CPS" }, { "name" : "Hydrodynamic separators (HDS or CDS),", "code" : "CDS" }, { "name" : "Gross Solid Removal Devices", "code" : "GSRD" }, { "name" : "Netting devices", "code" : "NET" } ] }, "defaultValue" : null }, { "name" : "STATUS", "type" : "esriFieldTypeSmallInteger", "alias" : "Status", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "TrashCaptureDevicesStatus", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Installed", "code" : 1 }, { "name" : "Construction", "code" : 2 }, { "name" : "Planned", "code" : 3 } ] }, "defaultValue" : null }, { "name" : "GLOBALID", "type" : "esriFieldTypeGlobalID", "alias" : "GLOBALID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Area", "type" : "esriFieldTypeDouble", "alias" : "Shape__Area", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Length", "type" : "esriFieldTypeDouble", "alias" : "Shape__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__MYMAPSER__F4B70D85998D751D", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_4148.MYMAPSERVICE2_GISADMIN_FULLTRASHCAPTUREDRAINAGEAREA_Shape_sidx", "fields" : "SHAPE", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "FDO_GLOBALID", "fields" : "GLOBALID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Area_Index", "fields" : "Shape__Area", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Length_Index", "fields" : "Shape__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "GISADMIN.FullTrashCaptureDrainageArea", "description" : "", "drawingTool" : "esriFeatureEditToolPolygon", "prototype" : { "attributes" : { "STATUS" : 1, "DEVICESTYPES" : null, "FC_NAME" : " ", "FC_NOTES" : " ", "FC_ACRES" : 0, "TTA_ID" : " " } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 2000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Create,Delete,Query,Update,Editing" }, { "currentVersion" : 12, "id" : 3, "name" : "GISADMIN.TrashManagementAreas", "type" : "Feature Layer", "serviceItemId" : "42dc336ce3df4edc8ecb1f1ccde4e401", "displayField" : "TMA", "description" : "In this datalayer, primary and possibly secondary trash management areas are defined by each Permittee for inclusion in the Long-Term Trash Load Reduction Plan required by Provision C. 10.c of the MRP. There is a corresponding spreadsheet that describes current or future trash reduction actions within each designated management area. This datalayer has been dissolved in GIS from the Trash Management Area attributes for each Permittee’s Trash Generation GIS datalayer. For many Permittees, the Trash Management Areas datalayer was further edited by EOA for visual clarity in map displays, but can easily be re-created from the Trash Generation datalayer. ", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1741800089281, "schemaLastEditDate" : 1741800089281, "dataLastEditDate" : 1603124016486 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : true, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "hasGeometryProperties" : true, "geometryProperties" : { "shapeAreaFieldName" : "Shape__Area", "shapeLengthFieldName" : "Shape__Length" }, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : true, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolygon", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : 6029360.8219530284, "ymin" : 2081606.650095582, "xmax" : 6094772.8630446792, "ymax" : 2149549.8770697564, "spatialReference" : { "wkid" : 102643, "latestWkid" : 2227 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[195,235,247,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.4}},"label":"","description":""},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GLOBALID", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "TMA", "type" : "esriFieldTypeString", "alias" : "TMA", "sqlType" : "sqlTypeOther", "length" : 4, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "TMA_Code", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Arterial - 7th St", "code" : "1A" }, { "name" : "Arterial - 14th Ave", "code" : "1B" }, { "name" : "Arterial - 98th Ave", "code" : "1C" }, { "name" : "Arterial - Broadway", "code" : "1D" }, { "name" : "Arterial - Foothill Bancroft", "code" : "1E" }, { "name" : "Arterial - Fruitvale Ave", "code" : "1F" }, { "name" : "Arterial - Grand", "code" : "1G" }, { "name" : "Arterial - Hegenberger 73rd", "code" : "1H" }, { "name" : "Arterial - High", "code" : "1I" }, { "name" : "Arterial - International", "code" : "1J" }, { "name" : "Arterial - Lakeshore", "code" : "1K" }, { "name" : "Arterial - MacArthur", "code" : "1L" }, { "name" : "Arterial - Mandela", "code" : "1M" }, { "name" : "Arterial - Market", "code" : "1N" }, { "name" : "Arterial - Martin Luther King Jr.", "code" : "1O" }, { "name" : "Arterial - Park", "code" : "1P" }, { "name" : "Arterial - San Leandro", "code" : "1Q" }, { "name" : "Arterial - San Pablo", "code" : "1R" }, { "name" : "Arterial - Seminary", "code" : "1S" }, { "name" : "Arterial - Shattuck", "code" : "1T" }, { "name" : "Arterial - Telegraph", "code" : "1U" }, { "name" : "Commercial Chinatown", "code" : "2A" }, { "name" : "Commercial Dimond", "code" : "2B" }, { "name" : "Commercial East Bay Bridge Mall", "code" : "2C" }, { "name" : "Commercial East Lake", "code" : "2D" }, { "name" : "Commercial Eastmont Mall", "code" : "2E" }, { "name" : "Commercial Fruitvale", "code" : "2F" }, { "name" : "Commercial Grand Lakeshore", "code" : "2G" }, { "name" : "Commercial Jack London", "code" : "2H" }, { "name" : "Commercial Koreatown CBD", "code" : "2I" }, { "name" : "Commercial Laurel", "code" : "2J" }, { "name" : "Commercial Montclair", "code" : "2K" }, { "name" : "Commercial Piedmont", "code" : "2L" }, { "name" : "Commercial Rockridge", "code" : "2M" }, { "name" : "Commercial Temescal", "code" : "2N" }, { "name" : "North Oakland", "code" : "3" }, { "name" : "Former Army Base", "code" : "4" }, { "name" : "West Oakland", "code" : "5" }, { "name" : "Shoreline", "code" : "6" }, { "name" : "Lake Merritt", "code" : "7" }, { "name" : "Downtown Oakland", "code" : "8" }, { "name" : "San Antonio", "code" : "9" }, { "name" : "Sausal Creek", "code" : "10" }, { "name" : "East Oakland 1", "code" : "11" }, { "name" : "East Oakland 2", "code" : "12" }, { "name" : "Industrial East Oakland West", "code" : "13" }, { "name" : "Industrial East Oakland East", "code" : "14" }, { "name" : "Oakland Port and Airport", "code" : "15" }, { "name" : "Hills", "code" : "16" }, { "name" : "Caltrans (Freeways). This is not TMA.", "code" : "17" } ] }, "defaultValue" : null }, { "name" : "GLOBALID", "type" : "esriFieldTypeGlobalID", "alias" : "GLOBALID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Area", "type" : "esriFieldTypeDouble", "alias" : "Shape__Area", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Length", "type" : "esriFieldTypeDouble", "alias" : "Shape__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__MYMAPSER__F4B70D85BB70B713", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_4148.MYMAPSERVICE2_GISADMIN_TRASHMANAGEMENTAREAS_Shape_sidx", "fields" : "SHAPE", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "FDO_GLOBALID", "fields" : "GLOBALID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Area_Index", "fields" : "Shape__Area", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Length_Index", "fields" : "Shape__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "GISADMIN.TrashManagementAreas", "description" : "", "drawingTool" : "esriFeatureEditToolPolygon", "prototype" : { "attributes" : { "TMA" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 2000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Create,Delete,Query,Update,Editing" }, { "currentVersion" : 12, "id" : 4, "name" : "GISADMIN.TrashGeneration", "type" : "Feature Layer", "serviceItemId" : "42dc336ce3df4edc8ecb1f1ccde4e401", "displayField" : "BID_NAME", "description" : "In this datalayer, trash generation refers to the amount of trash that is littered in an area. The attributes in this layer are further defined here. Initial estimates of trash generation are based on results from a study in which land use and average income were found to best correlate with trash generation. Initial estimates were revised in some areas based on Permittee assessments of actual conditions. Med_HH_Inc: The median household income of a Census Block Group, 2010 data.  Used to initially calculate residential rates. This data can be visualized on http://www.city-data.comOneMileInc: The average median household income within one mile of a Census Block Group, 2010 data.  Used to initially calculate retail rates.Landuse: The land uses used to calculate initial trash rates. This data originated with a combination of ABAG land use data and each county’s assessors land use data. It was further edited by EOA and with feedback from cities. Acres: Area in acres.TRASH_R8: The estimated trash generation rate in gallons/acre/year. This is the amount of trash that is littered and not the amount that ends up in a storm drainage system. These rates have been changed based on requested edits to the Final Generation Category. These rates should be used only in very rough calculations of litter generation. Trash_Load: The estimated trash generation load in gallons/year. This is a very rough estimate. City: The city or county that the polygon is in.Jurisdiction: The private company, city, county, or agency that has jurisdiction from a trash perspective over the polygon.Juris_City: “yes” if the agency in the City attribute has jurisdiction over the trash originating from this polygon. This attribute is used for mapping Non-Jurisdictional areas. In order to map the appropriate generation color for Non-Jurisdictional land uses, the Final Gen Category was appended to “no, ”. It should be noted that non-jurisdictional polygons often include portions of adjacent streets that are jurisdictional. This is an error in the way this datalayer was developed because all parcels extend to roughly the centerline of the adjacent street, when in fact the street should be entirely jurisdictional. Modelled Generation Category: Level of trash predicted from land use/ income model. The scale ranges from “A” to “D”, where A represents the least trash and D represents the most trash.Assessed Generation Category: Changes in generation category based on assessments by Permittees. (In some cases, final gen. category is also edited by EOA for small parcel slivers to improve display clarity.) Final Generation Category: The most up-to-date estimate of trash generation category based on revisions from Permittee assessments. TMA Primary (or TMA_Prime): The ID of the Primary Trash Management Area that this polygon is in. This may be blank if this polygon is non-jurisdictional or is entirely a non-urban land use. The ID corresponds to differing action plans and priorities for different Permittees. TMA Secondary (or TMA_Second): The ID of the Secondary Trash Management Area that this polygon is in. This may be blank if the permittee chose to designate primary management areas only. ", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1741800089281, "schemaLastEditDate" : 1741800089281, "dataLastEditDate" : 1603124126544 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : true, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "hasGeometryProperties" : true, "geometryProperties" : { "shapeAreaFieldName" : "Shape__Area", "shapeLengthFieldName" : "Shape__Length" }, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : true, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolygon", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : 6029360.8219530284, "ymin" : 2081606.650095582, "xmax" : 6094772.8630446792, "ymax" : 2149549.8770697564, "spatialReference" : { "wkid" : 102643, "latestWkid" : 2227 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[245,212,252,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.4}},"label":"","description":""},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GLOBALID", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "MED_HH_INC", "type" : "esriFieldTypeDouble", "alias" : "MED_HH_INC", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ONEMILEINC", "type" : "esriFieldTypeInteger", "alias" : "ONEMILEINC", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ACRES", "type" : "esriFieldTypeDouble", "alias" : "ACRES", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TRASH_R8", "type" : "esriFieldTypeDouble", "alias" : "TRASH_R8", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TRASH_LOAD", "type" : "esriFieldTypeDouble", "alias" : "TRASH_LOAD", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "JURIS_CITY", "type" : "esriFieldTypeString", "alias" : "JURIS_CITY", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MODEL_CAT", "type" : "esriFieldTypeString", "alias" : "Model_Cat", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : false, "editable" : true, "domain" : { "type" : "codedValue", "name" : "TrashCategories", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Low", "code" : "A" }, { "name" : "Moderate", "code" : "B" }, { "name" : "High", "code" : "C" }, { "name" : "Very high", "code" : "D" } ] }, "defaultValue" : null }, { "name" : "ASSESS_CAT", "type" : "esriFieldTypeString", "alias" : "Assess_Cat", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : false, "editable" : true, "domain" : { "type" : "codedValue", "name" : "TrashCategories", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Low", "code" : "A" }, { "name" : "Moderate", "code" : "B" }, { "name" : "High", "code" : "C" }, { "name" : "Very high", "code" : "D" } ] }, "defaultValue" : null }, { "name" : "FINAL_CAT", "type" : "esriFieldTypeString", "alias" : "Final_Cat", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : false, "editable" : true, "domain" : { "type" : "codedValue", "name" : "TrashCategories", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Low", "code" : "A" }, { "name" : "Moderate", "code" : "B" }, { "name" : "High", "code" : "C" }, { "name" : "Very high", "code" : "D" } ] }, "defaultValue" : null }, { "name" : "USECODE", "type" : "esriFieldTypeDouble", "alias" : "USECODE", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BID_NAME", "type" : "esriFieldTypeString", "alias" : "BID_NAME", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "JURISDICTION", "type" : "esriFieldTypeSmallInteger", "alias" : "Jurisdiction", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Jurisdiction", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Airport", "code" : 1 }, { "name" : "College or University", "code" : 2 }, { "name" : "Freeway", "code" : 3 }, { "name" : "Military", "code" : 4 }, { "name" : "Oakland", "code" : 5 }, { "name" : "Port", "code" : 6 }, { "name" : "Railroad", "code" : 7 }, { "name" : "Utilities", "code" : 8 } ] }, "defaultValue" : null }, { "name" : "LANDUSES", "type" : "esriFieldTypeSmallInteger", "alias" : "Landuses", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Landuse", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Colleges and Universities", "code" : 1 }, { "name" : "Commercial", "code" : 2 }, { "name" : "Commercial/Industrial Mixed", "code" : 3 }, { "name" : "Heavy Industrial", "code" : 4 }, { "name" : "K-12 Schools", "code" : 5 }, { "name" : "Light Industrial", "code" : 6 }, { "name" : "Other - Agriculture", "code" : 7 }, { "name" : "Other - Barren", "code" : 8 }, { "name" : "Other - Comm/Power Facilities", "code" : 9 }, { "name" : "Other - Forest", "code" : 10 }, { "name" : "Other - Military", "code" : 11 }, { "name" : "Other - Rangeland", "code" : 12 }, { "name" : "Other - Transportation Airports", "code" : 13 }, { "name" : "Other - Transportation Highways", "code" : 14 }, { "name" : "Other - Transportation Ports", "code" : 15 }, { "name" : "Other - Transportation Rail", "code" : 16 }, { "name" : "Other - Transportation Station", "code" : 17 }, { "name" : "Other - Urban Open", "code" : 18 }, { "name" : "Other - Wastewater Facilities", "code" : 19 }, { "name" : "Other - Water", "code" : 20 }, { "name" : "Other - Water Supply Facilities", "code" : 21 }, { "name" : "Other - Wetland", "code" : 22 }, { "name" : "Residential - General", "code" : 23 }, { "name" : "Residential - High Density", "code" : 24 }, { "name" : "Residential - Low Density", "code" : 25 }, { "name" : "Residential - Rural", "code" : 26 }, { "name" : "Retail", "code" : 27 }, { "name" : "Urban Parks", "code" : 28 } ] }, "defaultValue" : null }, { "name" : "TMA", "type" : "esriFieldTypeString", "alias" : "TMA", "sqlType" : "sqlTypeOther", "length" : 4, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "TMA_Code", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Arterial - 7th St", "code" : "1A" }, { "name" : "Arterial - 14th Ave", "code" : "1B" }, { "name" : "Arterial - 98th Ave", "code" : "1C" }, { "name" : "Arterial - Broadway", "code" : "1D" }, { "name" : "Arterial - Foothill Bancroft", "code" : "1E" }, { "name" : "Arterial - Fruitvale Ave", "code" : "1F" }, { "name" : "Arterial - Grand", "code" : "1G" }, { "name" : "Arterial - Hegenberger 73rd", "code" : "1H" }, { "name" : "Arterial - High", "code" : "1I" }, { "name" : "Arterial - International", "code" : "1J" }, { "name" : "Arterial - Lakeshore", "code" : "1K" }, { "name" : "Arterial - MacArthur", "code" : "1L" }, { "name" : "Arterial - Mandela", "code" : "1M" }, { "name" : "Arterial - Market", "code" : "1N" }, { "name" : "Arterial - Martin Luther King Jr.", "code" : "1O" }, { "name" : "Arterial - Park", "code" : "1P" }, { "name" : "Arterial - San Leandro", "code" : "1Q" }, { "name" : "Arterial - San Pablo", "code" : "1R" }, { "name" : "Arterial - Seminary", "code" : "1S" }, { "name" : "Arterial - Shattuck", "code" : "1T" }, { "name" : "Arterial - Telegraph", "code" : "1U" }, { "name" : "Commercial Chinatown", "code" : "2A" }, { "name" : "Commercial Dimond", "code" : "2B" }, { "name" : "Commercial East Bay Bridge Mall", "code" : "2C" }, { "name" : "Commercial East Lake", "code" : "2D" }, { "name" : "Commercial Eastmont Mall", "code" : "2E" }, { "name" : "Commercial Fruitvale", "code" : "2F" }, { "name" : "Commercial Grand Lakeshore", "code" : "2G" }, { "name" : "Commercial Jack London", "code" : "2H" }, { "name" : "Commercial Koreatown CBD", "code" : "2I" }, { "name" : "Commercial Laurel", "code" : "2J" }, { "name" : "Commercial Montclair", "code" : "2K" }, { "name" : "Commercial Piedmont", "code" : "2L" }, { "name" : "Commercial Rockridge", "code" : "2M" }, { "name" : "Commercial Temescal", "code" : "2N" }, { "name" : "North Oakland", "code" : "3" }, { "name" : "Former Army Base", "code" : "4" }, { "name" : "West Oakland", "code" : "5" }, { "name" : "Shoreline", "code" : "6" }, { "name" : "Lake Merritt", "code" : "7" }, { "name" : "Downtown Oakland", "code" : "8" }, { "name" : "San Antonio", "code" : "9" }, { "name" : "Sausal Creek", "code" : "10" }, { "name" : "East Oakland 1", "code" : "11" }, { "name" : "East Oakland 2", "code" : "12" }, { "name" : "Industrial East Oakland West", "code" : "13" }, { "name" : "Industrial East Oakland East", "code" : "14" }, { "name" : "Oakland Port and Airport", "code" : "15" }, { "name" : "Hills", "code" : "16" }, { "name" : "Caltrans (Freeways). This is not TMA.", "code" : "17" } ] }, "defaultValue" : null }, { "name" : "GLOBALID", "type" : "esriFieldTypeGlobalID", "alias" : "GLOBALID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Area", "type" : "esriFieldTypeDouble", "alias" : "Shape__Area", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Length", "type" : "esriFieldTypeDouble", "alias" : "Shape__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__MYMAPSER__F4B70D852EABAE39", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_4148.MYMAPSERVICE2_GISADMIN_TRASHGENERATION_Shape_sidx", "fields" : "SHAPE", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "FDO_GLOBALID", "fields" : "GLOBALID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Area_Index", "fields" : "Shape__Area", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Length_Index", "fields" : "Shape__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "GISADMIN.TrashGeneration", "description" : "", "drawingTool" : "esriFeatureEditToolPolygon", "prototype" : { "attributes" : { "TMA" : null, "LANDUSES" : null, "MED_HH_INC" : 0, "ONEMILEINC" : 0, "ACRES" : 0, "TRASH_R8" : 0, "TRASH_LOAD" : 0, "JURIS_CITY" : " ", "MODEL_CAT" : " ", "ASSESS_CAT" : " ", "FINAL_CAT" : " ", "USECODE" : 0, "BID_NAME" : " ", "JURISDICTION" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 2000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Create,Delete,Query,Update,Editing" } ], "tables" : [] }