{ "layers" : [ { "currentVersion" : 12, "id" : 0, "name" : "cemeteries", "type" : "Feature Layer", "serviceItemId" : "6cfb53d9e65942dd92f55ee3e967ecb2", "cacheMaxAge" : 30, "displayField" : "FACNAME", "description" : "\u003cDIV STYLE=\"text-align:Left;\"\u003e\u003cDIV\u003e\u003cDIV\u003e\u003cP STYLE=\"margin:0 0 0 0;\"\u003e\u003cSPAN\u003eWhile each source agency classifies its facilities according to their own naming systems, we have grouped all facilities and program sites into the following seven categories to help planners navigate the data more easily:\u003c/SPAN\u003e\u003c/P\u003e\u003cUL\u003e\u003cLI\u003e\u003cP\u003e\u003cSPAN\u003eHealth and Human Services\u003c/SPAN\u003e\u003c/P\u003e\u003c/LI\u003e\u003cLI\u003e\u003cP\u003e\u003cSPAN\u003eEducation, Child Welfare, and Youth\u003c/SPAN\u003e\u003c/P\u003e\u003c/LI\u003e\u003cLI\u003e\u003cP\u003e\u003cSPAN\u003eParks, Gardens, and Historical Sites\u003c/SPAN\u003e\u003c/P\u003e\u003c/LI\u003e\u003cLI\u003e\u003cP STYLE=\"margin:0 0 0 0;\"\u003e\u003cSPAN\u003e\u003cSPAN\u003eLibraries and Cultural Programs\u003c/SPAN\u003e\u003c/SPAN\u003e\u003c/P\u003e\u003c/LI\u003e\u003cLI\u003e\u003cP STYLE=\"margin:0 0 0 0;\"\u003e\u003cSPAN\u003e\u003cSPAN\u003ePublic Safety, Emergency Services, and Administration of Justice\u003c/SPAN\u003e\u003c/SPAN\u003e\u003c/P\u003e\u003c/LI\u003e\u003cLI\u003e\u003cP STYLE=\"margin:0 0 0 0;\"\u003e\u003cSPAN\u003e\u003cSPAN\u003eCore Infrastructure and Transportation\u003c/SPAN\u003e\u003c/SPAN\u003e\u003c/P\u003e\u003c/LI\u003e\u003cLI\u003e\u003cP STYLE=\"margin:0 0 0 0;\"\u003e\u003cSPAN\u003eAdministration of Government\u003c/SPAN\u003e\u003c/P\u003e\u003c/LI\u003e\u003c/UL\u003e\u003cP STYLE=\"margin:0 0 0 0;\"\u003e\u003cSPAN\u003eWithin each of these domains, each record is further categorized into a set of facility groups, subgroups, and types that are intended to make the data easy to navigate and more useful for specific planning purposes. Facility types and names appear as they do in source datasets, wherever possible. \u003c/SPAN\u003e\u003c/P\u003e\u003cP STYLE=\"margin:0 0 0 0;\"\u003e\u003cSPAN /\u003e\u003cSPAN /\u003e\u003c/P\u003e\u003cP STYLE=\"margin:0 0 0 0;\"\u003e\u003cSPAN STYLE=\"font-weight:bold;\"\u003eNotes on version 19v1:\u003c/SPAN\u003e\u003c/P\u003e\u003cP STYLE=\"margin:0 0 0 0;\"\u003e\u003cSPAN /\u003e\u003c/P\u003e\u003cP STYLE=\"margin:0 0 0 0;\"\u003e\u003cSPAN\u003e\u003cSPAN\u003eThe code used to create the City Planning Facilities Database (FacDB) has been completely rewritten to make it more user-friendly and more maintainable. The schema has changed, as have some of the data sources. These changes are summarized below.\u003c/SPAN\u003e\u003c/SPAN\u003e\u003c/P\u003e\u003cP STYLE=\"margin:0 0 0 0;\"\u003e\u003cSPAN /\u003e\u003c/P\u003e\u003cP STYLE=\"margin:0 0 0 0;\"\u003e\u003cSPAN\u003eFacDB is compiled from approximately 50 source files. Many facilities are available in more than one source file, sometimes with conflicting information. The previous version of FacDB had several fields, including CAPACITY that were formatted as strings, showing each source file that included that facility and the value contained in the source file. \u003c/SPAN\u003e\u003c/P\u003e\u003cP STYLE=\"margin:0 0 0 0;\"\u003e\u003cSPAN /\u003e\u003c/P\u003e\u003cP STYLE=\"margin:0 0 0 0;\"\u003e\u003cSPAN\u003eIn version 19v1, one source is designated as the primary source for each facility type. All values in the record come from that single source. For some facility types, like public schools or fire stations, there is an authoritative source and no secondary sources are used. For example, the Department of Education is the only source used for public schools. While other source files, such as City Owned and Leased Properties (COLP), contain records for public schools, these are not used for FacDB.\u003c/SPAN\u003e\u003c/P\u003e\u003cP STYLE=\"margin:0 0 0 0;\"\u003e\u003cSPAN /\u003e\u003c/P\u003e\u003cP STYLE=\"margin:0 0 0 0;\"\u003e\u003cSPAN\u003eFor other facility types, like day care centers, there is not a single authoritative source. One source is designated primary. All the facilities from that source are included in FacDB. If other sources include facilities at locations not in the primary source file, additional records are added to FacDB with data from the secondary source(s).\u003c/SPAN\u003e\u003c/P\u003e\u003cP STYLE=\"margin:0 0 0 0;\"\u003e\u003cSPAN /\u003e\u003c/P\u003e\u003cP STYLE=\"margin:0 0 0 0;\"\u003e\u003cSPAN STYLE=\"font-weight:bold;\"\u003eSchema changes:\u003c/SPAN\u003e\u003cSPAN\u003e\u003cSPAN\u003eThe schema has been significantly changed for version 19v1. While field names remain the same, some fields have been removed. Some fields, like CAPACITY, which were previously text fields, have been changed to numeric fields. Please review the data dictionary for the new schema.\u003c/SPAN\u003e\u003c/SPAN\u003e\u003c/P\u003e\u003cP STYLE=\"margin:0 0 0 0;\"\u003e\u003cSPAN /\u003e\u003c/P\u003e\u003cP STYLE=\"margin:0 0 0 0;\"\u003e\u003cSPAN STYLE=\"font-weight:bold;\"\u003eData source changes:\u003c/SPAN\u003e\u003cSPAN\u003e\u003cSPAN\u003eSome city agency facilities, previously sourced from COLP, have been changed to use a source file from the agency. These agency specific files are updated more frequently than COLP and provide more accurate information. Please review the data sources file for a full list of these sources and the date each was updated.\u003c/SPAN\u003e\u003c/SPAN\u003e\u003c/P\u003e\u003cP STYLE=\"margin:0 0 0 0;\"\u003e\u003cSPAN /\u003e\u003c/P\u003e\u003cP STYLE=\"margin:0 0 0 0;\"\u003e\u003cSPAN\u003eHealth and human services facilities formerly taken from HHS Connect are now coming from the Mayor\u003c/SPAN\u003e\u003cSPAN\u003e\u003cSPAN\u003e’\u003c/SPAN\u003e\u003c/SPAN\u003e\u003cSPAN\u003e\u003cSPAN\u003es Office of Economic Opportunity. This has resulted in a number of changes to facility categorization.\u003c/SPAN\u003e\u003c/SPAN\u003e\u003c/P\u003e\u003cP STYLE=\"margin:0 0 0 0;\"\u003e\u003cSPAN /\u003e\u003c/P\u003e\u003cP STYLE=\"margin:0 0 0 0;\"\u003e\u003cSPAN STYLE=\"font-weight:bold;\"\u003eData quality improvements:\u003c/SPAN\u003e\u003cSPAN\u003e\u003cSPAN\u003eThe geocoding of facilities has been improved and there are fewer duplicate facilities.\u003c/SPAN\u003e\u003c/SPAN\u003e\u003c/P\u003e\u003c/DIV\u003e\u003c/DIV\u003e\u003c/DIV\u003e", "copyrightText" : "New York City Department of City Planning. Please direct feedback to DCPOpenDatal@planning.nyc.gov.", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1643660217025, "schemaLastEditDate" : 1643660217025, "dataLastEditDate" : 1643660217025 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : false, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : -74.255465046805242, "ymin" : 40.499615915522945, "xmax" : -73.701133304273839, "ymax" : 40.9139414662856, "spatialReference" : { "wkt" : "GEOGCS[\"WGS84(DD)\",DATUM[\"WGS84\",SPHEROID[\"WGS84\",6378137.0,298.257223563]],PRIMEM[\"Greenwich\",0.0],UNIT[\"degree\",0.0174532925199433]]" } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[33,130,54,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "FID", "uniqueIdField" : { "name" : "FID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "FID", "type" : "esriFieldTypeOID", "alias" : "FID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "FACNAME", "type" : "esriFieldTypeString", "alias" : "FACNAME", "sqlType" : "sqlTypeOther", "length" : 150, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ADDRESSNUM", "type" : "esriFieldTypeString", "alias" : "ADDRESSNUM", "sqlType" : "sqlTypeOther", "length" : 12, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STREETNAME", "type" : "esriFieldTypeString", "alias" : "STREETNAME", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ADDRESS", "type" : "esriFieldTypeString", "alias" : "ADDRESS", "sqlType" : "sqlTypeOther", "length" : 150, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CITY", "type" : "esriFieldTypeString", "alias" : "CITY", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ZIPCODE", "type" : "esriFieldTypeString", "alias" : "ZIPCODE", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BORO", "type" : "esriFieldTypeString", "alias" : "BORO", "sqlType" : "sqlTypeOther", "length" : 15, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BOROCODE", "type" : "esriFieldTypeInteger", "alias" : "BOROCODE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BIN", "type" : "esriFieldTypeInteger", "alias" : "BIN", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BBL", "type" : "esriFieldTypeDouble", "alias" : "BBL", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COMMBOARD", "type" : "esriFieldTypeInteger", "alias" : "COMMBOARD", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NTA", "type" : "esriFieldTypeString", "alias" : "NTA", "sqlType" : "sqlTypeOther", "length" : 4, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COUNCIL", "type" : "esriFieldTypeInteger", "alias" : "COUNCIL", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SCHOOLDIST", "type" : "esriFieldTypeString", "alias" : "SCHOOLDIST", "sqlType" : "sqlTypeOther", "length" : 3, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "POLICEPRCT", "type" : "esriFieldTypeInteger", "alias" : "POLICEPRCT", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CENSTRACT", "type" : "esriFieldTypeString", "alias" : "CENSTRACT", "sqlType" : "sqlTypeOther", "length" : 6, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FACTYPE", "type" : "esriFieldTypeString", "alias" : "FACTYPE", "sqlType" : "sqlTypeOther", "length" : 150, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FACSUBGRP", "type" : "esriFieldTypeString", "alias" : "FACSUBGRP", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FACGROUP", "type" : "esriFieldTypeString", "alias" : "FACGROUP", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FACDOMAIN", "type" : "esriFieldTypeString", "alias" : "FACDOMAIN", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SERVAREA", "type" : "esriFieldTypeString", "alias" : "SERVAREA", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OPNAME", "type" : "esriFieldTypeString", "alias" : "OPNAME", "sqlType" : "sqlTypeOther", "length" : 150, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OPABBREV", "type" : "esriFieldTypeString", "alias" : "OPABBREV", "sqlType" : "sqlTypeOther", "length" : 12, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OPTYPE", "type" : "esriFieldTypeString", "alias" : "OPTYPE", "sqlType" : "sqlTypeOther", "length" : 12, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OVERAGENCY", "type" : "esriFieldTypeString", "alias" : "OVERAGENCY", "sqlType" : "sqlTypeOther", "length" : 150, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OVERABBREV", "type" : "esriFieldTypeString", "alias" : "OVERABBREV", "sqlType" : "sqlTypeOther", "length" : 12, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OVERLEVEL", "type" : "esriFieldTypeString", "alias" : "OVERLEVEL", "sqlType" : "sqlTypeOther", "length" : 12, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CAPACITY", "type" : "esriFieldTypeInteger", "alias" : "CAPACITY", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CAPTYPE", "type" : "esriFieldTypeString", "alias" : "CAPTYPE", "sqlType" : "sqlTypeOther", "length" : 12, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PROPTYPE", "type" : "esriFieldTypeString", "alias" : "PROPTYPE", "sqlType" : "sqlTypeOther", "length" : 12, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LATITUDE", "type" : "esriFieldTypeDouble", "alias" : "LATITUDE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LONGITUDE", "type" : "esriFieldTypeDouble", "alias" : "LONGITUDE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "XCOORD", "type" : "esriFieldTypeDouble", "alias" : "XCOORD", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "YCOORD", "type" : "esriFieldTypeDouble", "alias" : "YCOORD", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DATASOURCE", "type" : "esriFieldTypeString", "alias" : "DATASOURCE", "sqlType" : "sqlTypeOther", "length" : 150, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "UID", "type" : "esriFieldTypeString", "alias" : "UID", "sqlType" : "sqlTypeOther", "length" : 254, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__GRID3_SE__C1BEA5A27DC75877", "fields" : "FID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_1019.GRID3_SERVICETEST_CEMETERIES_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "cemeteries", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel", "supportedConvertFileFormats" : "JSON,PBF", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query,Extract" }, { "currentVersion" : 12, "id" : 1, "name" : "boroughs", "type" : "Feature Layer", "serviceItemId" : "6cfb53d9e65942dd92f55ee3e967ecb2", "cacheMaxAge" : 30, "displayField" : "boro_name", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1643660217025, "schemaLastEditDate" : 1643660217025, "dataLastEditDate" : 1643660217025 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : false, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "hasGeometryProperties" : true, "geometryProperties" : { "shapeAreaFieldName" : "Shape__Area", "shapeLengthFieldName" : "Shape__Length" }, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : true, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolygon", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : -74.255591362951009, "ymin" : 40.496115395609081, "xmax" : -73.700009063467462, "ymax" : 40.91553277581702, "spatialReference" : { "wkt" : "GEOGCS[\"WGS84(DD)\",DATUM[\"WGS84\",SPHEROID[\"WGS84\",6378137.0,298.257223563]],PRIMEM[\"Greenwich\",0.0],UNIT[\"degree\",0.0174532925199433]]" } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[209,252,234,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "FID", "uniqueIdField" : { "name" : "FID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "FID", "type" : "esriFieldTypeOID", "alias" : "FID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "boro_code", "type" : "esriFieldTypeDouble", "alias" : "boro_code", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "boro_name", "type" : "esriFieldTypeString", "alias" : "boro_name", "sqlType" : "sqlTypeOther", "length" : 254, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "shape_leng", "type" : "esriFieldTypeDouble", "alias" : "shape_leng", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Area", "type" : "esriFieldTypeDouble", "alias" : "Shape__Area", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Length", "type" : "esriFieldTypeDouble", "alias" : "Shape__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__GRID3_SE__C1BEA5A272C25441", "fields" : "FID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_1019.GRID3_SERVICETEST_BOROUGHS_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "Shape__Area_Index", "fields" : "Shape__Area", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Length_Index", "fields" : "Shape__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "boroughs", "description" : "", "drawingTool" : "esriFeatureEditToolPolygon", "prototype" : { "attributes" : { } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel", "supportedConvertFileFormats" : "JSON,PBF", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 2000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query,Extract" } ], "tables" : [] }