{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 44, "name": "Condo Approval Lots", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": false, "minScale": 10000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolygon", "description": "When Condos are approved for ground lots, those lots remain in the production (active) layer and attributes updated to reflect Condominium dwelling. 1.) Approved for Ground (Record Lots)When condos are approved for ground lots, the following fields are updated and the\u201cCondo_Lot\u201dfield populated with a \u201cY\u201d valueUNDERLIES_CONDO = 1 CONDO_BOOK_NUMCONDO_PAGE_NUMCONDO_REGIME_NUMCONDOLOT = Y 2.) Approved for Ground (History Record Lots). As some have been replaced (killed) by another Record Lot, that's also a condo lot.When condos are approved for ground lots, the following fields are updated and the \u201cCondo_Lot\u201dfield populated with a \u201cY\u201d valueUNDERLIES_CONDO = 1 CONDO_BOOK_NUMCONDO_PAGE_NUMCONDO_REGIME_NUMCONDOLOT = YWhen Condos are approved for overlay lots, those lots are killed (retired / dead lots) and archived to their respective history layer. 3.) Approved for Overlays (Air Rights & Tax Lots). In the future, Parcels may be used. The following fields are updated and the \u201cCondo_Lot\u201d field populated with a \u201cY\u201d value UNDERLIES_CONDO = 1 CONDO_BOOK_NUMCONDO_PAGE_NUMCONDO_REGIME_NUMCONDOLOT = YCondo dwellings can also be queried city-wide via the individual VPM layers (active Record lots, dead Air Rights & Tax lots) where the value in the \u201cUNDERLIES_CONDO\u201d field is equal to 1.The following fields are populated once Condo Lots have been approved:Condo_Book_NumCondo_Page_NumCondo_Regime_Num", "copyrightText": "Department of Buildings", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 11, "name": "DCGIS.REGIME", "relatedTableId": 72, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "CONDO_REGIME_NUM", "composite": false, "catalogID": "{AF0E95EF-45F6-4A20-9CB6-813735BE4CFE}" }, { "id": 12, "name": "DCGIS.CONDORELATE", "relatedTableId": 52, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "SSL", "composite": false, "catalogID": "{FD0E00CD-6A83-4797-A2F4-A29A54AD021D}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDurableUrlForSyncModelNone": false, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": true, "supportsReturningGeometryEnvelope": true, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsTrueCurve": true, "supportedCurveTypes": [ "esriGeometryCircularArc", "esriGeometryEllipticArc", "esriGeometryBezier3Curve" ], "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape__Area", "shapeLengthFieldName": "Shape__Length", "units": "esriMeters" }, "hasMetadata": true, "extent": { "xmin": -8583018.693177054, "ymin": 4696215.89441766, "xmax": -8561996.918219212, "ymax": 4718922.425451464, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "sourceSpatialReference": { "wkid": 102685, "latestWkid": 2248, "xyTolerance": 0.00328083333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -120561100, "falseY": -95444400, "xyUnits": 3048.0060960121905, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 127, 127, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.4 } } }, "scaleSymbols": true, "transparency": 50, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GLOBALID", "displayField": "NARRATIVE", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "CREATION_DT", "type": "esriFieldTypeDate", "alias": "CREATION_DT", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CREATION_DT" }, { "name": "RECORDATION_DT", "type": "esriFieldTypeDate", "alias": "RECORDATION_DT", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "RECORDATION_DT" }, { "name": "NARRATIVE", "type": "esriFieldTypeString", "alias": "NARRATIVE", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "NARRATIVE" }, { "name": "EXPIRATION_DT", "type": "esriFieldTypeDate", "alias": "EXPIRATION_DT", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EXPIRATION_DT" }, { "name": "STATUS", "type": "esriFieldTypeInteger", "alias": "STATUS", "domain": null, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "Status" }, { "name": "SQUARE", "type": "esriFieldTypeString", "alias": "SQUARE", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SQUARE" }, { "name": "SUFFIX", "type": "esriFieldTypeString", "alias": "SUFFIX", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SUFFIX" }, { "name": "LOT", "type": "esriFieldTypeString", "alias": "LOT", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "LOT" }, { "name": "LOT_TYPE", "type": "esriFieldTypeInteger", "alias": "LOT_TYPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LOT_TYPE" }, { "name": "COMPUTED_AREA_SF", "type": "esriFieldTypeDouble", "alias": "COMPUTED_AREA_SF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COMPUTED_AREA_SF" }, { "name": "QUADRANT", "type": "esriFieldTypeString", "alias": "QUADRANT", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "QUADRANT" }, { "name": "RECORD_AREA_SF", "type": "esriFieldTypeDouble", "alias": "RECORD_AREA_SF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RECORD_AREA_SF" }, { "name": "OF_LOT_SEQ", "type": "esriFieldTypeInteger", "alias": "OF_LOT_SEQ", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "Of_Lot_Seq" }, { "name": "BOOK_NUM", "type": "esriFieldTypeString", "alias": "BOOK_NUM", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "BOOK_NUM" }, { "name": "PAGE_NUM", "type": "esriFieldTypeString", "alias": "PAGE_NUM", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "PAGE_NUM" }, { "name": "UNDERLIES_CONDO", "type": "esriFieldTypeInteger", "alias": "UNDERLIES_CONDO", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "Underlies_Condo" }, { "name": "CONDO_BOOK_NUM", "type": "esriFieldTypeString", "alias": "CONDO_BOOK_NUM", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "CONDO_BOOK_NUM" }, { "name": "CONDO_PAGE_NUM", "type": "esriFieldTypeString", "alias": "CONDO_PAGE_NUM", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "CONDO_PAGE_NUM" }, { "name": "KILL_DT", "type": "esriFieldTypeDate", "alias": "KILL_DT", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "KILL_DT" }, { "name": "SSL", "type": "esriFieldTypeString", "alias": "SSL", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SSL" }, { "name": "COL", "type": "esriFieldTypeString", "alias": "COL", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "COL" }, { "name": "CONDOLOT", "type": "esriFieldTypeString", "alias": "CONDOLOT", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "CONDOLOT" }, { "name": "CONDO_REGIME_NUM", "type": "esriFieldTypeString", "alias": "CONDO_REGIME_NUM", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CONDO_REGIME_NUM" }, { "name": "Shape__Area", "type": "esriFieldTypeDouble", "alias": "SHAPE.AREA", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.AREA", "required": true }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "SHAPE.LEN", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.LEN", "required": true }, { "name": "MAR_ID", "type": "esriFieldTypeInteger", "alias": "MAR_ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ADDRESS_ID" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AREA_1", "type": "esriFieldTypeDouble", "alias": "Area 1", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AREA_1" }, { "name": "LEN_1", "type": "esriFieldTypeDouble", "alias": "Length 1", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LEN_1" }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GLOBALID" }, { "name": "CREATEDBYRECORD", "type": "esriFieldTypeGUID", "alias": "Created By Record", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "CREATEDBYRECORD" }, { "name": "RETIREDBYRECORD", "type": "esriFieldTypeGUID", "alias": "Retired By Record", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "RETIREDBYRECORD" }, { "name": "STATEDAREA", "type": "esriFieldTypeDouble", "alias": "Stated Area", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "STATEDAREA" }, { "name": "STATEDAREAUNIT", "type": "esriFieldTypeInteger", "alias": "Stated Area Unit", "domain": { "type": "codedValue", "name": "PF_AreaUnits", "description": "Parcel Fabric Area Units", "codedValues": [ { "name": "Hectare", "code": 109401 }, { "name": "Acre", "code": 109402 }, { "name": "Acre US", "code": 109403 }, { "name": "Square Meter", "code": 109404 }, { "name": "Square Foot", "code": 109405 }, { "name": "Square Foot US", "code": 109406 }, { "name": "Square Foot Clarke", "code": 109407 }, { "name": "Square Fathom", "code": 109408 }, { "name": "Square Nautical Mile", "code": 109409 }, { "name": "Square Meter German", "code": 109410 }, { "name": "Square Chain US", "code": 109411 }, { "name": "Square Link US", "code": 109412 }, { "name": "Square Mile US", "code": 109413 }, { "name": "Square Kilometer", "code": 109414 }, { "name": "Square Yard Clarke", "code": 109415 }, { "name": "Square Chain Clarke", "code": 109416 }, { "name": "Square Link Clarke", "code": 109417 }, { "name": "Square Yard Sears", "code": 109418 }, { "name": "Square Foot Sears", "code": 109419 }, { "name": "Square Chain Sears", "code": 109420 }, { "name": "Square Link Sears", "code": 109421 }, { "name": "Square Yard Benoit A", "code": 109422 }, { "name": "Square Foot Benoit A", "code": 109423 }, { "name": "Square Chain Benoit A", "code": 109424 }, { "name": "Square Link Benoit A", "code": 109425 }, { "name": "Square Yard Benoit B", "code": 109426 }, { "name": "Square Foot Benoit B", "code": 109427 }, { "name": "Square Chain Benoit B", "code": 109428 }, { "name": "Square Link Benoit B", "code": 109429 }, { "name": "Square Foot 1865", "code": 109430 }, { "name": "Square Foot Indian", "code": 109431 }, { "name": "Square Foot Indian 1937", "code": 109432 }, { "name": "Square Foot Indian 1962", "code": 109433 }, { "name": "Square Foot Indian 1975", "code": 109434 }, { "name": "Square Yard Indian", "code": 109435 }, { "name": "Square Yard Indian 1937", "code": 109436 }, { "name": "Square Yard Indian 1962", "code": 109437 }, { "name": "Square Yard Indian 1975", "code": 109438 }, { "name": "Square Mile Statute", "code": 109439 }, { "name": "Square Foot Gold Coast", "code": 109440 }, { "name": "Square Foot British 1936", "code": 109441 }, { "name": "Square Yard", "code": 109442 }, { "name": "Square Yard US", "code": 109443 }, { "name": "Square Chain", "code": 109444 }, { "name": "Square Link", "code": 109445 }, { "name": "Square Yard Sears 1922 Trunc", "code": 109446 }, { "name": "Square Foot Sears 1922 Trunc", "code": 109447 }, { "name": "Square Chain Sears 1922 Trunc", "code": 109448 }, { "name": "Square Link Sears 1922 Trunc", "code": 109449 }, { "name": "Square Decimeter", "code": 109450 }, { "name": "Square Centimeter", "code": 109451 }, { "name": "Square Millimeter", "code": 109452 }, { "name": "Square Inch", "code": 109453 }, { "name": "Square Inch US", "code": 109454 }, { "name": "Square Rod", "code": 109455 }, { "name": "Square Rod US", "code": 109456 }, { "name": "Square Nautical Mile US", "code": 109457 }, { "name": "Square Nautical Mile UK", "code": 109458 }, { "name": "Square Smoot", "code": 109459 }, { "name": "Square Km50", "code": 109460 }, { "name": "Square Km150", "code": 109461 }, { "name": "Square Vara TX", "code": 109462 }, { "name": "Are", "code": 109463 }, { "name": "Square DTP Point", "code": 109464 }, { "name": "Square Micrometer", "code": 109465 }, { "name": "Square Nanometer", "code": 109466 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "STATEDAREAUNIT" }, { "name": "CALCULATEDAREA", "type": "esriFieldTypeDouble", "alias": "Calculated Area", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CALCULATEDAREA" }, { "name": "CREATED_DATE", "type": "esriFieldTypeDate", "alias": "Created Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CREATED_DATE" }, { "name": "LAST_EDITED_DATE", "type": "esriFieldTypeDate", "alias": "Last Edited Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LAST_EDITED_DATE" }, { "name": "ISHISTORIC", "type": "esriFieldTypeInteger", "alias": "Is Historic", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ISHISTORIC" }, { "name": "RECORD", "type": "esriFieldTypeString", "alias": "Record", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "RECORD" }, { "name": "RETIRING_RECORD", "type": "esriFieldTypeString", "alias": "Retiring Record", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "RETIRING_RECORD" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "indexes": [ { "name": "ATTRIBUTEINDEX_0", "isAscending": true, "isUnique": false, "description": "", "fields": "SQUARE,SUFFIX,LOT,RECORD_AREA_SF,SSL,COL,CONDO_REGIME_NUM" }, { "name": "R54567_SDE_ROWID_UK", "isAscending": true, "isUnique": true, "description": "", "fields": "OBJECTID" }, { "name": "UUID_54567", "isAscending": true, "isUnique": true, "description": "", "fields": "GLOBALID" }, { "name": "A18707_IX1", "isAscending": true, "isUnique": true, "description": "", "fields": "SHAPE" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "timeZoneIANA": "America/New_York", "respectsDaylightSaving": true }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Condo Approval Lots", "description": "", "prototype": { "attributes": { "RECORD": null, "CREATION_DT": null, "RECORDATION_DT": null, "NARRATIVE": null, "EXPIRATION_DT": null, "STATUS": 1, "SQUARE": null, "SUFFIX": null, "LOT": null, "LOT_TYPE": null, "COMPUTED_AREA_SF": null, "QUADRANT": null, "RECORD_AREA_SF": null, "OF_LOT_SEQ": 0, "BOOK_NUM": null, "PAGE_NUM": null, "UNDERLIES_CONDO": 0, "CONDO_BOOK_NUM": null, "CONDO_PAGE_NUM": null, "KILL_DT": null, "SSL": null, "COL": null, "CONDOLOT": "N", "CONDO_REGIME_NUM": null, "ISHISTORIC": null, "LAST_EDITED_DATE": null, "MAR_ID": null, "AREA_1": null, "LEN_1": null, "RETIRING_RECORD": null, "CREATEDBYRECORD": null, "RETIREDBYRECORD": null, "STATEDAREA": null, "STATEDAREAUNIT": null, "CALCULATEDAREA": null, "CREATED_DATE": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 4000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }