View In:   ArcGIS Online Map Viewer

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: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 10000.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: -8583018.693177054
YMin: 4696215.89441766
XMax: -8561996.918219212
YMax: 4718922.425451464
Spatial Reference: 102100  (3857)  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: true
Supports Returning Geometry Centroid: true
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: false
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:

Fields:

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

Templates:

• Name: Condo Approval Lots
  Description:
  Prototype:
  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
  
  Drawing Tool: esriFeatureEditToolPolygon

Relationships:

• DCGIS.REGIME (13) -- Related To: CONDO REGIME (72)
• DCGIS.CONDORELATE (14) -- Related To: CONDORELATE (52)
• DCGIS.SURDOCS (15) -- Related To: SURVEYOR DOCUMENT SYSTEM (69)

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Analytic   Query Related Records   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata