{ "tables": [{ "preferredTimeReference": { "timeZoneIANA": "America/New_York", "respectsDaylightSaving": true, "timeZone": "Eastern Standard Time" }, "useStandardizedQueries": true, "maxRecordCount": 2000, "description": "Parcel Real Property and CAMA data", "datesInUnknownTimezone": false, "type": "Table", "subtypes": [], "relationships": [], "indexes": [ { "name": "R11_SDE_ROWID_UK", "isUnique": true, "description": "", "fields": "OBJECTID", "isAscending": true }, { "name": "PRCW_BP_IDX", "isUnique": false, "description": "", "fields": "BOOK_PAGE", "isAscending": true }, { "name": "PRCW_OWN_IDX", "isUnique": false, "description": "", "fields": "DEEDED_OWNER,PARCEL_OWNER", "isAscending": true }, { "name": "PRCW_PADD_IDX", "isUnique": false, "description": "", "fields": "PAR_ADDR_ALL", "isAscending": true }, { "name": "PRCW_PCITY_IDX", "isUnique": false, "description": "", "fields": "PAR_CITY", "isAscending": true }, { "name": "PRCW_PPN_IDX", "isUnique": false, "description": "", "fields": "PARCEL_ID", "isAscending": true }, { "name": "PRCW_TDATE_IDX", "isUnique": false, "description": "", "fields": "TRANSFER_DATE", "isAscending": true } ], "htmlPopupType": "esriServerHTMLPopupTypeNone", "cimVersion": "3.6.0", "isDataArchived": false, "id": 1, "archivingInfo": { "startArchivingMoment": -1, "supportsQueryWithHistoricMoment": false }, "hasAttachments": false, "advancedQueryCapabilities": { "supportsStatistics": true, "supportsSqlExpression": true, "supportsTrueCurve": false, "supportsOrderBy": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "useStandardizedQueries": true, "supportsQueryWithDistance": true, "supportsCountDistinct": true, "supportsCurrentUserQueries": true, "supportsAdvancedQueryRelated": true, "supportsReturningQueryExtent": true, "supportsPagination": true, "supportsDistinct": true, "supportsTimeRelation": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": null, "subtypeFieldName": null, "supportsStatistics": true, "capabilities": "Map,Query,Data", "supportsExceedsLimitStatistics": true, "isDataVersioned": false, "supportsAdvancedQueries": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": true }, "hasMetadata": true, "currentVersion": 12, "typeIdField": null, "defaultSubtypeCode": null, "supportedQueryFormats": "JSON, PBF", "name": "Parcel_RP_CAMA", "displayField": "PARCEL_ID", "copyrightText": null, "fields": [ { "nullable": false, "domain": null, "name": "OBJECTID", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": false, "domain": null, "name": "PARCEL_ID", "length": 9, "alias": "PARCEL_ID", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "BOOK_PAGE", "length": 10, "alias": "BOOK_PAGE", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "PARCEL_YEAR", "alias": "PARCEL_YEAR", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "domain": null, "name": "PARCEL_OWNER", "length": 30, "alias": "PARCEL_OWNER", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "DEEDED_OWNER", "length": 255, "alias": "DEEDED_OWNER", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "GRANTOR", "length": 255, "alias": "GRANTOR", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "GRANTEE", "length": 255, "alias": "GRANTEE", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "TRANSFER_DATE", "length": 8, "alias": "TRANSFER_DATE", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "SALES_AMOUNT", "alias": "SALES_AMOUNT", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "PAR_ADDR", "length": 15, "alias": "PAR_ADDR", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "PAR_PREDIR", "length": 1, "alias": "PAR_PREDIR", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "PAR_STREET", "length": 23, "alias": "PAR_STREET", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "PAR_SUFFIX", "length": 7, "alias": "PAR_SUFFIX", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "PAR_UNIT", "length": 6, "alias": "PAR_UNIT", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "PAR_CITY", "length": 60, "alias": "PAR_CITY", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "PAR_ZIP", "alias": "PAR_ZIP", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "PAR_ADDR_ALL", "length": 119, "alias": "PAR_ADDR_ALL", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "MAIL_NAME", "length": 109, "alias": "MAIL_NAME", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "MAIL_ADDR_STREET", "length": 50, "alias": "MAIL_ADDR_STREET", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "MAIL_UNIT", "length": 30, "alias": "MAIL_UNIT", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "MAIL_CITY", "length": 30, "alias": "MAIL_CITY", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "MAIL_STATE", "length": 2, "alias": "MAIL_STATE", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "MAIL_ZIP", "length": 10, "alias": "MAIL_ZIP", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "MAIL_COUNTRY", "length": 3, "alias": "MAIL_COUNTRY", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "TAX_LUC", "length": 4, "alias": "TAX_LUC", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "TAX_LUC_DESCRIPTION", "length": 20, "alias": "TAX_LUC_DESCRIPTION", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "EXT_LUC", "length": 4, "alias": "EXT_LUC", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "EXT_LUC_DESCRIPTION", "length": 20, "alias": "EXT_LUC_DESCRIPTION", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "ZONING_CODE", "length": 6, "alias": "ZONING_CODE", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "ZONING_USE", "length": 4, "alias": "ZONING_USE", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "PROPERTY_CLASS", "length": 2, "alias": "PROPERTY_CLASS", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "TAX_DISTRICT", "length": 3, "alias": "TAX_DISTRICT", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "NEIGHBORHOOD_CODE", "length": 5, "alias": "NEIGHBORHOOD_CODE", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "CONDO_COMPLEX_ID", "length": 9, "alias": "CONDO_COMPLEX_ID", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "TAX_ABATEMENT", "length": 4, "alias": "TAX_ABATEMENT", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "ROAD_TYPE", "length": 3, "alias": "ROAD_TYPE", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "WATER", "length": 3, "alias": "WATER", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "SEWER", "length": 3, "alias": "SEWER", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "GAS", "length": 1, "alias": "GAS", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "ELECTRICITY", "length": 1, "alias": "ELECTRICITY", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "TAX_YEAR", "alias": "TAX_YEAR", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "CERTIFIED_TAX_LUC", "length": 4, "alias": "CERTIFIED_TAX_LUC", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "CERTIFIED_TAX_LAND", "alias": "CERTIFIED_TAX_LAND", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "CERTIFIED_TAX_BUILDING", "alias": "CERTIFIED_TAX_BUILDING", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "CERTIFIED_TAX_TOTAL", "alias": "CERTIFIED_TAX_TOTAL", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "CERTIFIED_EXEMPT_LUC", "length": 4, "alias": "CERTIFIED_EXEMPT_LUC", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "CERTIFIED_EXEMPT_LAND", "alias": "CERTIFIED_EXEMPT_LAND", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "CERTIFIED_EXEMPT_BUILDING", "alias": "CERTIFIED_EXEMPT_BUILDING", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "CERTIFIED_EXEMPT_TOTAL", "alias": "CERTIFIED_EXEMPT_TOTAL", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "CERTIFIED_ABATED_LUC", "length": 4, "alias": "CERTIFIED_ABATED_LUC", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "CERTIFIED_ABATED_LAND", "alias": "CERTIFIED_ABATED_LAND", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "CERTIFIED_ABATED_BUILDING", "alias": "CERTIFIED_ABATED_BUILDING", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "CERTIFIED_ABATED_TOTAL", "alias": "CERTIFIED_ABATED_TOTAL", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "GROSS_CERTIFIED_LAND", "alias": "GROSS_CERTIFIED_LAND", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "GROSS_CERTIFIED_BUILDING", "alias": "GROSS_CERTIFIED_BUILDING", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "GROSS_CERTIFIED_TOTAL", "alias": "GROSS_CERTIFIED_TOTAL", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "RES_BLDG_COUNT", "alias": "RES_BLDG_COUNT", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "TOTAL_RES_LIV_AREA", "alias": "TOTAL_RES_LIV_AREA", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "TOTAL_RES_ROOMS", "alias": "TOTAL_RES_ROOMS", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "COM_BLDG_COUNT", "alias": "COM_BLDG_COUNT", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "TOTAL_COM_USE_AREA", "alias": "TOTAL_COM_USE_AREA", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "COM_LIVING_UNITS", "alias": "COM_LIVING_UNITS", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "TOTAL_LEGAL_FRONT", "alias": "TOTAL_LEGAL_FRONT", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "TOTAL_SQUARE_FT", "alias": "TOTAL_SQUARE_FT", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "TOTAL_ACREAGE", "alias": "TOTAL_ACREAGE", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "CAMA_PARENT_PARCEL", "length": 27, "alias": "CAMA_PARENT_PARCEL", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "NO_LIST_INFO", "length": 4000, "alias": "NO_LIST_INFO", "type": "esriFieldTypeString" } ], "dateFieldsTimeReference": { "timeZoneIANA": "America/New_York", "respectsDaylightSaving": true, "timeZone": "Eastern Standard Time" } }], "layers": [] }