{ "layers": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 0, "name": "LeaseParcels", "type": "Feature Layer", "description": "sf_port_lgim.sde.LeaseParcels", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102643, "latestWkid": 2227, "xyTolerance": 0.00328083333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -115860600, "falseY": -93269500, "xyUnits": 3048.00609601219, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "floor", "defaultSymbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 130, 130, 130, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.7 } }, "defaultLabel": "", "uniqueValueInfos": [ { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 182, 208, 252, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.7 } }, "value": "1", "label": "Floor 1" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 199, 194, 252, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.7 } }, "value": "2", "label": "Floor 2" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 182, 202, 252, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.7 } }, "value": "3", "label": "Floor 3" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 252, 187, 203, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.7 } }, "value": "4", "label": "Floor 4" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 179, 233, 252, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.7 } }, "value": "5", "label": "Floor 5" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 236, 252, 199, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.7 } }, "value": "-1", "label": "Mezzanine" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 210, 230, 252, 255 ], "toColor": [ 210, 230, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 194, 252, 179, 255 ], "toColor": [ 194, 252, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 179, 251, 255 ], "toColor": [ 252, 179, 251, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 184, 179, 255 ], "toColor": [ 252, 184, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 246, 207, 255 ], "toColor": [ 252, 246, 207, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 182, 252, 235, 255 ], "toColor": [ 182, 252, 235, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 190, 187, 252, 255 ], "toColor": [ 190, 187, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 215, 251, 255 ], "toColor": [ 252, 215, 251, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 220, 210, 255 ], "toColor": [ 252, 220, 210, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 245, 252, 179, 255 ], "toColor": [ 245, 252, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 214, 252, 212, 255 ], "toColor": [ 214, 252, 212, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 182, 222, 255 ], "toColor": [ 252, 182, 222, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 210, 252, 252, 255 ], "toColor": [ 210, 252, 252, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 175468.9155870825, "ymin": 83942.44825355709, "xmax": 6046964.084974825, "ymax": 2153787.95291123, "spatialReference": { "wkid": 102643, "latestWkid": 2227, "xyTolerance": 0.00328083333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -115860600, "falseY": -93269500, "xyUnits": 3048.00609601219, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "agreement_number", "typeIdField": "floor", "subtypeFieldName": "floor", "subtypeField": "floor", "defaultSubtypeCode": 1, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "objectid", "domain": null }, { "name": "agreement_number", "type": "esriFieldTypeString", "alias": "agreement_number", "length": 6, "domain": null }, { "name": "leasehold_number", "type": "esriFieldTypeString", "alias": "leasehold_number", "length": 4, "domain": null }, { "name": "fin", "type": "esriFieldTypeString", "alias": "fin", "length": 20, "domain": null }, { "name": "mapbook_sheet", "type": "esriFieldTypeString", "alias": "mapbook_sheet", "length": 20, "domain": null }, { "name": "agreement_leasehold", "type": "esriFieldTypeString", "alias": "agreement_leasehold", "length": 255, "domain": null }, { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "shape", "domain": null }, { "name": "building_cpl", "type": "esriFieldTypeString", "alias": "building_cpl", "length": 25, "domain": null }, { "name": "floor", "type": "esriFieldTypeSmallInteger", "alias": "floor", "domain": null }, { "name": "st_area(shape)", "type": "esriFieldTypeDouble", "alias": "st_area(shape)", "domain": null }, { "name": "st_perimeter(shape)", "type": "esriFieldTypeDouble", "alias": "st_perimeter(shape)", "domain": null }, { "name": "facility_code", "type": "esriFieldTypeString", "alias": "facility", "length": 255, "domain": null }, { "name": "re_portfolio_type", "type": "esriFieldTypeString", "alias": "portfolio_type", "length": 255, "domain": { "type": "codedValue", "name": "Portfolio", "description": "The portfolio tells what section of the Port it is located", "codedValues": [ { "name": "01-Southeast", "code": "01-Southeast" }, { "name": "02-China Basin", "code": "02-China Basin" }, { "name": "03-FP/SB", "code": "03-FP/SB" }, { "name": "04-Northeast", "code": "04-Northeast" }, { "name": "05-Fisherman's Wharf", "code": "05-Fisherman's Wharf" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "location", "type": "esriFieldTypeString", "alias": "location", "length": 255, "domain": null }, { "name": "space_unit", "type": "esriFieldTypeString", "alias": "space_unit", "length": 255, "domain": null }, { "name": "occupancy_type", "type": "esriFieldTypeString", "alias": "occupancy_type", "length": 255, "domain": { "type": "codedValue", "name": "OccupancyType", "description": "The type of space that can be occupied", "codedValues": [ { "name": "Office", "code": "Office" }, { "name": "Office Storage", "code": "Office Storage" }, { "name": "Open Land", "code": "Open Land" }, { "name": "Apron", "code": "Apron" }, { "name": "Paved Land", "code": "Paved Land" }, { "name": "Unpaved Land", "code": "Unpaved Land" }, { "name": "Improved Land/Sidewalk", "code": "Improved Land/Sidewalk" }, { "name": "Shed", "code": "Shed" }, { "name": "Submerged Land", "code": "Submerged Land" }, { "name": "Fish Processing", "code": "Fish Processing" }, { "name": "Gear Storage", "code": "Gear Storage" }, { "name": "Parking", "code": "Parking" }, { "name": "Berthing", "code": "Berthing" }, { "name": "Telecommunication Site", "code": "Telecommunication Site" }, { "name": "Curb", "code": "Curb" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "offline", "type": "esriFieldTypeString", "alias": "offline", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ma_portfolio_type", "type": "esriFieldTypeString", "alias": "ma_portfolio_type", "length": 255, "domain": { "type": "codedValue", "name": "Wharfingers", "description": "The area that Maritime oversees", "codedValues": [ { "name": "Northern Waterfront", "code": "Northern Waterfront" }, { "name": "Cruise Pier 27-35", "code": "Cruise Pier 27-35" }, { "name": "Central Waterfront", "code": "Central Waterfront" }, { "name": "Shipyard - Pier 68", "code": "Shipyard - Pier 68" }, { "name": "Southern Waterfront", "code": "Southern Waterfront" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "occupancy_description", "type": "esriFieldTypeString", "alias": "occupancy_description", "length": 255, "domain": null }, { "name": "sq_ft", "type": "esriFieldTypeDouble", "alias": "sq_ft", "domain": null }, { "name": "offline_reason", "type": "esriFieldTypeString", "alias": "offline_reason", "length": 255, "domain": null } ], "geometryField": { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "shape" }, "indexes": [ { "name": "i618agreement_le", "fields": "agreement_leasehold", "isAscending": true, "isUnique": false, "description": "" }, { "name": "r444_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "a394_ix1", "fields": "shape", "isAscending": true, "isUnique": true, "description": "" } ], "types": [ { "domains": {}, "id": 1, "name": "Floor 1" }, { "domains": {}, "id": 2, "name": "Floor 2" }, { "domains": {}, "id": 3, "name": "Floor 3" }, { "domains": {}, "id": 4, "name": "Floor 4" }, { "domains": {}, "id": 5, "name": "Floor 5" }, { "domains": {}, "id": -1, "name": "Mezzanine" } ], "subtypes": [ { "domains": {}, "defaultValues": { "agreement_number": null, "leasehold_number": null, "fin": null, "mapbook_sheet": null, "agreement_leasehold": null, "building_cpl": null, "floor": null, "facility_code": null, "re_portfolio_type": null, "location": null, "space_unit": null, "occupancy_type": null, "offline": null, "ma_portfolio_type": null, "occupancy_description": null, "sq_ft": null, "offline_reason": null }, "code": 1, "name": "Floor 1" }, { "domains": {}, "defaultValues": { "agreement_number": null, "leasehold_number": null, "fin": null, "mapbook_sheet": null, "agreement_leasehold": null, "building_cpl": null, "floor": null, "facility_code": null, "re_portfolio_type": null, "location": null, "space_unit": null, "occupancy_type": null, "offline": null, "ma_portfolio_type": null, "occupancy_description": null, "sq_ft": null, "offline_reason": null }, "code": 2, "name": "Floor 2" }, { "domains": {}, "defaultValues": { "agreement_number": null, "leasehold_number": null, "fin": null, "mapbook_sheet": null, "agreement_leasehold": null, "building_cpl": null, "floor": null, "facility_code": null, "re_portfolio_type": null, "location": null, "space_unit": null, "occupancy_type": null, "offline": null, "ma_portfolio_type": null, "occupancy_description": null, "sq_ft": null, "offline_reason": null }, "code": 3, "name": "Floor 3" }, { "domains": {}, "defaultValues": { "agreement_number": null, "leasehold_number": null, "fin": null, "mapbook_sheet": null, "agreement_leasehold": null, "building_cpl": null, "floor": null, "facility_code": null, "re_portfolio_type": null, "location": null, "space_unit": null, "occupancy_type": null, "offline": null, "ma_portfolio_type": null, "occupancy_description": null, "sq_ft": null, "offline_reason": null }, "code": 4, "name": "Floor 4" }, { "domains": {}, "defaultValues": { "agreement_number": null, "leasehold_number": null, "fin": null, "mapbook_sheet": null, "agreement_leasehold": null, "building_cpl": null, "floor": null, "facility_code": null, "re_portfolio_type": null, "location": null, "space_unit": null, "occupancy_type": null, "offline": null, "ma_portfolio_type": null, "occupancy_description": null, "sq_ft": null, "offline_reason": null }, "code": 5, "name": "Floor 5" }, { "domains": {}, "defaultValues": { "agreement_number": null, "leasehold_number": null, "fin": null, "mapbook_sheet": null, "agreement_leasehold": null, "building_cpl": null, "floor": null, "facility_code": null, "re_portfolio_type": null, "location": null, "space_unit": null, "occupancy_type": null, "offline": null, "ma_portfolio_type": null, "occupancy_description": null, "sq_ft": null, "offline_reason": null }, "code": -1, "name": "Mezzanine" } ], "relationships": [ { "id": 0, "name": "propworks_data", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "agreement_leasehold", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "st_area(shape)", "shapeLengthFieldName": "st_perimeter(shape)", "units": "esriFeet" }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "08808a06a6324c12a4b18c6b328fdf23" } ], "tables": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 1, "name": "propworks_data", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "company_name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "objectid", "domain": null }, { "name": "facility", "type": "esriFieldTypeString", "alias": "facility", "length": 4, "domain": null }, { "name": "agreement_number", "type": "esriFieldTypeString", "alias": "agreement_number", "length": 6, "domain": null }, { "name": "company_name", "type": "esriFieldTypeString", "alias": "company_name", "length": 50, "domain": null }, { "name": "company_number", "type": "esriFieldTypeString", "alias": "company_number", "length": 10, "domain": null }, { "name": "portfolio", "type": "esriFieldTypeString", "alias": "portfolio", "length": 10, "domain": null }, { "name": "contract_number", "type": "esriFieldTypeString", "alias": "contract_number", "length": 20, "domain": null }, { "name": "leasehold_number", "type": "esriFieldTypeString", "alias": "leasehold_number", "length": 4, "domain": null }, { "name": "commenced_date", "type": "esriFieldTypeDate", "alias": "commenced_date", "length": 8, "domain": null }, { "name": "expiration_date", "type": "esriFieldTypeDate", "alias": "expiration_date", "length": 8, "domain": null }, { "name": "contract_status", "type": "esriFieldTypeString", "alias": "contract_status", "length": 4, "domain": null }, { "name": "revenue_type", "type": "esriFieldTypeString", "alias": "revenue_type", "length": 4, "domain": null }, { "name": "leasehold_type", "type": "esriFieldTypeString", "alias": "leasehold_type", "length": 10, "domain": null }, { "name": "cost_center", "type": "esriFieldTypeString", "alias": "cost_center", "length": 10, "domain": null }, { "name": "billing_status", "type": "esriFieldTypeString", "alias": "billing_status", "length": 4, "domain": null }, { "name": "bill_frequency", "type": "esriFieldTypeString", "alias": "bill_frequency", "length": 3, "domain": null }, { "name": "function_description", "type": "esriFieldTypeString", "alias": "function_description", "length": 30, "domain": null }, { "name": "space_name", "type": "esriFieldTypeString", "alias": "space_name", "length": 50, "domain": null }, { "name": "agreement_leasehold", "type": "esriFieldTypeString", "alias": "agreement_leasehold", "length": 255, "domain": null }, { "name": "sq_ft", "type": "esriFieldTypeDouble", "alias": "sq_ft", "domain": null }, { "name": "rate_per_sqft", "type": "esriFieldTypeDouble", "alias": "rate_per_sqft", "domain": null }, { "name": "monthly_rent", "type": "esriFieldTypeDouble", "alias": "monthly_rent", "domain": null } ], "indexes": [ { "name": "gdb_335_agreemen", "fields": "agreement_leasehold", "isAscending": true, "isUnique": false, "description": "" }, { "name": "r195_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "LeaseParcels", "relatedTableId": 0, "role": "esriRelRoleOrigin", "keyField": "agreement_leasehold", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "08808a06a6324c12a4b18c6b328fdf23" } ] }