View In:   ArcGIS Online Map Viewer

Name: Condo Approval Lots

Display Field: NARRATIVE

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: Condo lots are individual lots for each condominium. The lot numbers normally range from 2000-6999. These condo lots are not geographically defined other than being within a air rights, record, tax or a combination of lots that has one or more condo buildings within it. A condo regime number is assigned to each residential Condo application or Article of Confederation regardless of how many buildings there are at any one site. The Regime number starts with a 1, 2, or 3 depending upon where the condo is located and where they fall in the tri-annual assessment process of RPTA. All numbers after the first are consecutive. RPTA maintains the master list of Regime numbers for residential properties. Commercial condos are not associated with a Regime number and in order to properly track all condos, a unique Regime number was created. RPTA then establishes individual accounts for each condominium unit and assigns a condo lot number to that account. RPTA maintains the master list of Regime numbers and their relationship to approved condos. There are roughly 66571 condo lots and there associations are as follows: 49486 condos were approved for record lots, 16867 were approved for tax lots, 2817 were approved for air rights lots, and 2600 were approved for both air rights and tax lots. The CondoPly layer was created to assist users in visualizing the relationship between ground surface lots (Record Lots), overlay lots (Air Rights & Tax Lots), and the associated Condos. When Condos are approved for ground lots, those lots remain in the production (active) layer and attributes updated to reflect the new condos. When Condos are approved for overlay lots, those lots are killed (dead lots) and archived to their respective history layer. Condo 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.

Copyright Text: Department of Buildings

Default Visibility: false

MaxRecordCount: 2000

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.69343669
YMin: 4696215.894971094
XMax: -8561996.918479037
YMax: 4718922.4253614135
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:

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 , Coded Values: [1: Current] , [2: Dead] )
• 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 , Coded Values: [1: Record_Lot] , [2: Tax_Lot] , [3: Air_Rights] , ...3 more... )
• COMPUTED_AREA_SF ( type: esriFieldTypeDouble, alias: COMPUTED_AREA_SF, editable: true, nullable: true, defaultValue: null, modelName: COMPUTED_AREA_SF )
• SURVEYED_AREA_SF ( type: esriFieldTypeDouble, alias: SURVEYED_AREA_SF, editable: true, nullable: true, defaultValue: null, modelName: SURVEYED_AREA_SF )
• IS_REAR_OF ( type: esriFieldTypeInteger, alias: IS_REAR_OF, editable: true, nullable: true, defaultValue: null, modelName: IS_REAR_OF )
• BLDG_NUM ( type: esriFieldTypeInteger, alias: BLDG_NUM, editable: true, nullable: true, defaultValue: null, modelName: BLDG_NUM )
• BLDG_NUM_EXT ( type: esriFieldTypeString, alias: BLDG_NUM_EXT, editable: true, nullable: true, length: 20, defaultValue: null, modelName: BLDG_NUM_EXT )
• BLDG_NUM_END_RANGE ( type: esriFieldTypeInteger, alias: BLDG_NUM_END_RANGE, editable: true, nullable: true, defaultValue: null, modelName: BLDG_NUM_END_RANGE )
• BLDG_EXT_END_RANGE ( type: esriFieldTypeString, alias: BLDG_EXT_END_RANGE, editable: true, nullable: true, length: 40, defaultValue: null, modelName: BLDG_EXT_END_RANGE )
• QUADRANT ( type: esriFieldTypeString, alias: QUADRANT, editable: true, nullable: true, length: 40, defaultValue: null, modelName: QUADRANT )
• ZIP5 ( type: esriFieldTypeString, alias: ZIP5, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ZIP5 )
• ZIP4 ( type: esriFieldTypeString, alias: ZIP4, editable: true, nullable: true, length: 4, defaultValue: null, modelName: ZIP4 )
• RECORD_AREA_SF ( type: esriFieldTypeDouble, alias: RECORD_AREA_SF, editable: true, nullable: true, defaultValue: null, modelName: RECORD_AREA_SF )
• CONV_TOLERANCE_TYPE ( type: esriFieldTypeInteger, alias: CONV_TOLERANCE_TYPE, editable: true, nullable: true, defaultValue: 1, modelName: Conv_Tolerance_Type )
• CONV_TOLERANCE_VALUE ( type: esriFieldTypeDouble, alias: CONV_TOLERANCE_VALUE, editable: true, nullable: true, defaultValue: null, modelName: CONV_TOLERANCE_VALUE )
• CONV_TOLERANCE_RESOLUTION ( type: esriFieldTypeString, alias: CONV_TOLERANCE_RESOLUTION, editable: true, nullable: true, length: 40, defaultValue: null, modelName: CONV_TOLERANCE_RESOLUTION )
• RECORDLOTSPLYID ( type: esriFieldTypeInteger, alias: RECORDLOTSPLYID, editable: true, nullable: true, defaultValue: null, modelName: RECORDLOTSPLYID )
• PARCELSPLYID ( type: esriFieldTypeInteger, alias: PARCELSPLYID, editable: true, nullable: true, defaultValue: null, modelName: PARCELSPLYID )
• SQUAREPLYID ( type: esriFieldTypeInteger, alias: SQUAREPLYID, editable: true, nullable: true, defaultValue: null, modelName: SQUAREPLYID )
• 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 )
• DCGIS.CONDOLOTPLY.AREA ( type: esriFieldTypeDouble, alias: AREA, editable: false, nullable: true, defaultValue: null, modelName: DCGIS.CONDOLOTPLY.AREA )
• DCGIS.CONDOLOTPLY.LEN ( type: esriFieldTypeDouble, alias: LEN, editable: false, nullable: true, defaultValue: null, modelName: DCGIS.CONDOLOTPLY.LEN )
• Shape__Area ( type: esriFieldTypeDouble, alias: SHAPE.AREA, editable: false, required: true, nullable: true, defaultValue: null, modelName: SHAPE.AREA )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE.LEN, editable: false, required: true, nullable: true, defaultValue: null, modelName: SHAPE.LEN )
• MAR_ID ( type: esriFieldTypeInteger, alias: MAR_ID, editable: true, nullable: true, defaultValue: null, modelName: MAR_ID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )

Templates:

• Name: Condo Approval Lots
  Description:
  Prototype:
  MAR_ID: 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
  SURVEYED_AREA_SF: null
  IS_REAR_OF: null
  BLDG_NUM: null
  BLDG_NUM_EXT: null
  BLDG_NUM_END_RANGE: null
  BLDG_EXT_END_RANGE: null
  QUADRANT: null
  ZIP5: null
  ZIP4: null
  RECORD_AREA_SF: null
  CONV_TOLERANCE_TYPE: 1
  CONV_TOLERANCE_VALUE: null
  CONV_TOLERANCE_RESOLUTION: null
  RECORDLOTSPLYID: null
  PARCELSPLYID: null
  SQUAREPLYID: 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
  
  Drawing Tool: esriFeatureEditToolPolygon

Relationships:

• DCGIS.SURDOCS (10) -- Related To: SURVEYOR DOCUMENT SYSTEM (69)
• DCGIS.REGIME (11) -- Related To: CONDO REGIME (72)
• CONDORELATE (12) -- Related To: CONDORELATE (52)

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

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