Name: Condo Approval Lots

Display Field: NARRATIVE

Type: Feature Layer

Geometry Type: 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“Condo_Lot”field populated with a “Y” 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 “Condo_Lot”field populated with a “Y” 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 “Condo_Lot” field populated with a “Y” 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 “UNDERLIES_CONDO” field is equal to 1.The following fields are populated once Condo Lots have been approved:Condo_Book_NumCondo_Page_NumCondo_Regime_Num

Copyright Text: Department of Buildings

Default Visibility: false

MaxRecordCount: 1000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 10000.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 1283176.77815072
YMin: 420793.422116876
XMax: 1336858.80989406
YMax: 478589.93874146
Spatial Reference: 102685  (2248)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [255, 127, 127, 255]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 255]
Width: 0
Label: N/A
Description: N/A
Transparency: 50
Labeling Info:

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• CREATION_DT ( type: esriFieldTypeDate, alias: CREATION_DT, length: 8 )
• RECORDATION_DT ( type: esriFieldTypeDate, alias: RECORDATION_DT, length: 8 )
• NARRATIVE ( type: esriFieldTypeString, alias: NARRATIVE, length: 200 )
• EXPIRATION_DT ( type: esriFieldTypeDate, alias: EXPIRATION_DT, length: 8 )
• STATUS ( type: esriFieldTypeInteger, alias: STATUS )
• SQUARE ( type: esriFieldTypeString, alias: SQUARE, length: 50 )
• SUFFIX ( type: esriFieldTypeString, alias: SUFFIX, length: 50 )
• LOT ( type: esriFieldTypeString, alias: LOT, length: 40 )
• LOT_TYPE ( type: esriFieldTypeInteger, alias: LOT_TYPE )
• COMPUTED_AREA_SF ( type: esriFieldTypeDouble, alias: COMPUTED_AREA_SF )
• QUADRANT ( type: esriFieldTypeString, alias: QUADRANT, length: 40 )
• RECORD_AREA_SF ( type: esriFieldTypeDouble, alias: RECORD_AREA_SF )
• OF_LOT_SEQ ( type: esriFieldTypeInteger, alias: OF_LOT_SEQ )
• BOOK_NUM ( type: esriFieldTypeString, alias: BOOK_NUM, length: 40 )
• PAGE_NUM ( type: esriFieldTypeString, alias: PAGE_NUM, length: 40 )
• UNDERLIES_CONDO ( type: esriFieldTypeInteger, alias: UNDERLIES_CONDO )
• CONDO_BOOK_NUM ( type: esriFieldTypeString, alias: CONDO_BOOK_NUM, length: 40 )
• CONDO_PAGE_NUM ( type: esriFieldTypeString, alias: CONDO_PAGE_NUM, length: 40 )
• KILL_DT ( type: esriFieldTypeDate, alias: KILL_DT, length: 8 )
• SSL ( type: esriFieldTypeString, alias: SSL, length: 50 )
• COL ( type: esriFieldTypeString, alias: COL, length: 2 )
• CONDOLOT ( type: esriFieldTypeString, alias: CONDOLOT, length: 1 )
• CONDO_REGIME_NUM ( type: esriFieldTypeString, alias: CONDO_REGIME_NUM, length: 50 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• SHAPE.AREA ( type: esriFieldTypeDouble, alias: SHAPE.AREA )
• SHAPE.LEN ( type: esriFieldTypeDouble, alias: SHAPE.LEN )
• MAR_ID ( type: esriFieldTypeInteger, alias: MAR_ID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• AREA_1 ( type: esriFieldTypeDouble, alias: Area 1 )
• LEN_1 ( type: esriFieldTypeDouble, alias: Length 1 )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• CREATEDBYRECORD ( type: esriFieldTypeGUID, alias: Created By Record, length: 38 )
• RETIREDBYRECORD ( type: esriFieldTypeGUID, alias: Retired By Record, length: 38 )
• STATEDAREA ( type: esriFieldTypeDouble, alias: Stated Area )
• STATEDAREAUNIT ( type: esriFieldTypeInteger, alias: Stated Area Unit , Coded Values: [109401: Hectare] , [109402: Acre] , [109403: Acre US] , ...63 more... )
• CALCULATEDAREA ( type: esriFieldTypeDouble, alias: Calculated Area )
• CREATED_DATE ( type: esriFieldTypeDate, alias: Created Date, length: 8 )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: Last Edited Date, length: 8 )
• ISHISTORIC ( type: esriFieldTypeInteger, alias: Is Historic )
• RECORD ( type: esriFieldTypeString, alias: Record, length: 255 )
• RETIRING_RECORD ( type: esriFieldTypeString, alias: Retiring Record, length: 255 )

Relationships:

• DCGIS.REGIME (11) -- Related To: CONDO REGIME (72)
• DCGIS.CONDORELATE (12) -- Related To: CONDORELATE (52)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata