{"data":{"id":"ac877684ad8b45e8b539af65ce475fe2_0","type":"dataset","attributes":{"errors":[],"access":"public","additionalResources":[],"advancedQueryCapabilities":{"supportsSqlExpression":true,"supportsQueryWithResultType":true,"supportsTranslations":false,"supportsQueryRelatedPagination":true,"supportedOperationsWithCacheHint":["query","queryTopFilter","queryAnalytics","queryAttachments","queryRelated","queryBins","queryPivot"],"supportsQueryWithCacheHint":true,"supportsQueryWithDatumTransformation":true,"supportsCurrentUserQueries":true,"supportsAggIds":true,"supportsOutFieldSQLExpression":true,"supportsDefaultSR":true,"fullTextSearchCapabilities":{"supportsStopWords":true,"supportsOperator":true,"supportsSearchOperator":true,"supportsAccentSensitivity":true},"supportsQueryBins":true,"supportsQueryWithCollation":true,"supportsQueryPivot":true,"supportsApproxPercentileStatistics":true,"supportsQueryWithLodSR":false,"supportsPaginationOnAggregatedQueries":true,"supportsPagination":true,"supportsMaxRecordCountFactor":true,"supportsStatistics":true,"supportsOutDistance":true,"supportsOrderBy":true,"supportsDisjointSpatialRel":true,"supportsFullTextSearch":true,"supportsQueryWithDistance":true,"supportsLod":true,"supportsSpatialAggregationStatistics":true,"supportsCountDistinct":true,"supportedLodTypes":["geohash"],"supportsAdvancedQueryRelated":true,"supportsReturningQueryExtent":true,"supportsISODOW":true,"supportsTopFeaturesQuery":true,"supportsReturningGeometryEnvelope":false,"supportsDistinct":true,"supportsReturningGeometryCentroid":false,"supportsTimeRelation":true,"supportsQueryAnalytic":true,"supportsPercentileStatistics":true,"supportedSpatialAggregationStatistics":["EnvelopeAggregate","CentroidAggregate","ConvexHullAggregate"],"supportsISOWeek":true,"supportsHavingClause":true},"collection":["Dataset"],"categories":["Business, Development and Housing"],"commentsEnabled":true,"composeStatus":{"pass":true,"lastSuccessAt":1790326330602,"retries":0,"lastRetriedAt":1790326330603},"composedAt":1790326330602,"content":"Feature Service","contentSecurityPolicy":null,"created":1683048089000,"currentVersion":12,"description":"Details of active contractors of various types registered with the Metro Codes Administration.  This dataset is updated daily.

Source Link: https://epermits.nashville.gov/
Metadata Document: Registered-Professional-Contractors-Metadata.pdf
Contact Data Owner: opendata@nashville.gov


","displayField":"","downloadable":true,"enrichCoverage":"local","enrichQuality":79,"extent":{"type":"envelope","coordinates":[[-87.0281,35.9693],[-86.5445,36.3822]]},"fieldNames":["Company_Name","Company Name","Prof__Type","Profession Type","Address","City","ST","ZIP","Lon","Lat","ObjectId"],"fields":[{"sqlType":"sqlTypeNVarchar","actualType":"nvarchar","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Company_Name","length":4000,"alias":"Company Name","type":"esriFieldTypeString"},{"sqlType":"sqlTypeNVarchar","actualType":"nvarchar","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Prof__Type","length":4000,"alias":"Profession Type","type":"esriFieldTypeString"},{"sqlType":"sqlTypeNVarchar","actualType":"nvarchar","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Address","length":4000,"alias":"Address","type":"esriFieldTypeString"},{"sqlType":"sqlTypeNVarchar","actualType":"nvarchar","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"City","length":4000,"alias":"City","type":"esriFieldTypeString"},{"sqlType":"sqlTypeNVarchar","actualType":"nvarchar","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"ST","length":4000,"alias":"ST","type":"esriFieldTypeString"},{"sqlType":"sqlTypeNVarchar","actualType":"nvarchar","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"ZIP","length":256,"alias":"ZIP","type":"esriFieldTypeString"},{"sqlType":"sqlTypeFloat","actualType":"float","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Lon","alias":"Lon","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeFloat","actualType":"float","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Lat","alias":"Lat","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeInteger","actualType":"int","nullable":false,"editable":false,"defaultValue":null,"domain":null,"name":"ObjectId","alias":"ObjectId","type":"esriFieldTypeOID"}],"geometryType":"esriGeometryPoint","groupIds":["8c9c6d0ef3434041b84116fdff861259"],"hasApi":true,"hubType":"Feature Layer","id":"ac877684ad8b45e8b539af65ce475fe2_0","itemId":"ac877684ad8b45e8b539af65ce475fe2","itemModified":1790326330000,"itemExtent":[[-87.02814470056286,35.96925492527408],[-86.54451869910959,36.38216686967881]],"layer":{"extent":null,"supportedContingentValuesFormats":"JSON, PBF","guidFormat":"","supportsApplyEditsWithGlobalIds":false,"maxRecordCount":1000,"infoInEstimates":["extent","count"],"type":"Feature Layer","hasStaticData":true,"editingInfo":{"lastEditDate":1790326321839,"schemaLastEditDate":1790326321839,"dataLastEditDate":1790326321839},"supportsAttachmentsByUploadId":true,"relationships":[],"supportsEditingContingentValues":true,"supportsAttachmentsResizing":true,"id":0,"collation":{"caseSensitive":false,"accentSensitive":true,"locale":"neutral"},"supportsStatistics":true,"supportedExportFormats":"csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet","standardMaxRecordCount":16000,"isDataVersioned":false,"templates":[{"name":"New Feature","description":"","drawingTool":"esriFeatureEditToolPoint","prototype":{"attributes":{"ZIP":null,"ST":null,"Address":null,"Lon":null,"City":null,"Date_Last_Pmt_":null,"E_Mail":null,"Alt__Phone":null,"Phone":null,"Company_Name":null,"Prof__Type":null,"FAX":null,"Lat":null}}}],"supportsAdvancedQueries":true,"supportsTilesAndBasicQueriesMode":true,"currentVersion":12,"hasZ":false,"advancedEditingCapabilities":{"supportsAsyncApplyEdits":true,"supportsApplyEditsbyUploadID":true,"supportsTranslation":false,"supportsReturnEditResults":true,"supportsMaxTranslations":10,"supportedSqlFormatsInCalculate":["standard"],"supportedApplyEditsUploadIDFormats":"JSON,PBF"},"supportsQuantizationEditMode":true,"objectIdField":"ObjectId","hasContingentValuesDefinition":false,"maxIdsCount":1000000,"viewSourceHasAttachments":false,"name":"RegisteredProfessionalContractors","displayField":"","supportsCalculate":true,"fields":[{"sqlType":"sqlTypeNVarchar","actualType":"nvarchar","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Company_Name","length":4000,"alias":"Company Name","type":"esriFieldTypeString"},{"sqlType":"sqlTypeNVarchar","actualType":"nvarchar","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Prof__Type","length":4000,"alias":"Profession Type","type":"esriFieldTypeString"},{"sqlType":"sqlTypeNVarchar","actualType":"nvarchar","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Address","length":4000,"alias":"Address","type":"esriFieldTypeString"},{"sqlType":"sqlTypeNVarchar","actualType":"nvarchar","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"City","length":4000,"alias":"City","type":"esriFieldTypeString"},{"sqlType":"sqlTypeNVarchar","actualType":"nvarchar","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"ST","length":4000,"alias":"ST","type":"esriFieldTypeString"},{"sqlType":"sqlTypeNVarchar","actualType":"nvarchar","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"ZIP","length":256,"alias":"ZIP","type":"esriFieldTypeString"},{"sqlType":"sqlTypeFloat","actualType":"float","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Lon","alias":"Lon","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeFloat","actualType":"float","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Lat","alias":"Lat","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeInteger","actualType":"int","nullable":false,"editable":false,"defaultValue":null,"domain":null,"name":"ObjectId","alias":"ObjectId","type":"esriFieldTypeOID"}],"maxRecordCountFactor":1,"dateFieldsTimeReference":{"timeZoneIANA":"Etc/UTC","respectsDaylightSaving":false,"timeZone":"UTC"},"supportsFieldDescriptionProperty":true,"hasM":false,"allowGeometryUpdates":true,"preferredTimeReference":null,"isView":true,"useStandardizedQueries":true,"globalIdField":"","supportedConvertContentFormats":"LayerEditCollection,FeatureCollection","description":"","enableNullGeometry":false,"isUpdatableView":true,"supportedOperationsWithCollation":"query,addField,updateField","supportedSpatialRelationships":["esriSpatialRelIntersects","esriSpatialRelContains","esriSpatialRelCrosses","esriSpatialRelEnvelopeIntersects","esriSpatialRelIndexIntersects","esriSpatialRelOverlaps","esriSpatialRelTouches","esriSpatialRelWithin","esriSpatialRelDisjoint","esriSpatialRelRelation"],"supportsRollbackOnFailureParameter":true,"supportsTruncate":false,"standardMaxRecordCountNoGeometry":32000,"indexes":[{"indexType":"Attribute","name":"PK__REGISTER__9A6192915A2E8E89","isUnique":true,"description":"clustered, unique, primary key","fields":"ObjectId","isAscending":true},{"indexType":"Spatial","name":"user_8986.REGISTEREDPROFESSIONALCONTRACTORS_REGISTEREDPROFESSIONALCONTRACTORS_Shape_sidx","isUnique":false,"description":"Shape Index","fields":"Shape","isAscending":true}],"supportedAppendSourceFilterFormats":"sqlite,geoPackage,shapefile,filegdb,featureService","htmlPopupType":"esriServerHTMLPopupTypeNone","supportsReturningQueryGeometry":true,"minScale":0,"hasAttachments":false,"queryBinsCapabilities":{"supportsReturnStackValueRange":true,"supportedNormalizationTypes":["boxCox","field","inverse","log","naturalLog","percentOfTotal","squareRoot"],"supportsNormalization":true,"supportsSnapToData":true,"supportsFixedIntervalBin":true,"supportsStackBy":true,"supportsDateBin":true,"supportsSplitBy":true,"supportsClassificationBin":true,"supportsReturnFullIntervalBin":true,"supportsAsync":true,"supportsFirstDayOfWeek":true,"supportedStatisticTypes":["COUNT","SUM","AVG","VAR","STDDEV","MIN","MAX","PERCENTILE_CONT","PERCENTILE_DISC","APPROX_PERCENTILE_CONT","APPROX_PERCENTILE_DISC","CentroidAggregate","EnvelopeAggregate","ConvexHullAggregate"],"supportsAutoIntervalBin":true,"supportsFixedBoundariesBin":true},"supportedConvertFileFormats":"JSON,PBF,Parquet","advancedQueryCapabilities":{"supportsSqlExpression":true,"supportsQueryWithResultType":true,"supportsTranslations":false,"supportsQueryRelatedPagination":true,"supportedOperationsWithCacheHint":["query","queryTopFilter","queryAnalytics","queryAttachments","queryRelated","queryBins","queryPivot"],"supportsQueryWithCacheHint":true,"supportsQueryWithDatumTransformation":true,"supportsCurrentUserQueries":true,"supportsAggIds":true,"supportsOutFieldSQLExpression":true,"supportsDefaultSR":true,"fullTextSearchCapabilities":{"supportsStopWords":true,"supportsOperator":true,"supportsSearchOperator":true,"supportsAccentSensitivity":true},"supportsQueryBins":true,"supportsQueryWithCollation":true,"supportsQueryPivot":true,"supportsApproxPercentileStatistics":true,"supportsQueryWithLodSR":false,"supportsPaginationOnAggregatedQueries":true,"supportsPagination":true,"supportsMaxRecordCountFactor":true,"supportsStatistics":true,"supportsOutDistance":true,"supportsOrderBy":true,"supportsDisjointSpatialRel":true,"supportsFullTextSearch":true,"supportsQueryWithDistance":true,"supportsLod":true,"supportsSpatialAggregationStatistics":true,"supportsCountDistinct":true,"supportedLodTypes":["geohash"],"supportsAdvancedQueryRelated":true,"supportsReturningQueryExtent":true,"supportsISODOW":true,"supportsTopFeaturesQuery":true,"supportsReturningGeometryEnvelope":false,"supportsDistinct":true,"supportsReturningGeometryCentroid":false,"supportsTimeRelation":true,"supportsQueryAnalytic":true,"supportsPercentileStatistics":true,"supportedSpatialAggregationStatistics":["EnvelopeAggregate","CentroidAggregate","ConvexHullAggregate"],"supportsISOWeek":true,"supportsHavingClause":true},"serviceItemId":"ac877684ad8b45e8b539af65ce475fe2","supportsValidateSql":true,"cacheMaxAge":3600,"supportsCoordinatesQuantization":true,"types":[],"capabilities":"Query,Extract","supportsAppend":true,"maxScale":0,"supportsExceedsLimitStatistics":true,"supportedSyncDataOptions":260,"sourceSchemaChangesAllowed":true,"supportsContingentValues":true,"defaultVisibility":true,"advancedQueryAnalyticCapabilities":{"supportsAsync":true,"supportsLinearRegression":true,"supportsTrendlineRegression":true,"supportsPercentileAnalytic":true},"supportedAppendFormats":"sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf","uniqueIdField":{"isSystemMaintained":true,"name":"ObjectId"},"tileMaxRecordCount":8000,"supportsFieldGroups":true,"typeIdField":"","supportsASyncCalculate":true,"supportedQueryFormats":"JSON, geoJSON, PBF","drawingInfo":{"renderer":{"symbol":{"imageData":"iVBORw0KGgoAAAANSUhEUgAAAEAAAABACAYAAACqaXHeAAAABGdBTUEAALGPC/xhBQAAACBjSFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAACXBIWXMAAA7DAAAOwwHHb6hkAAAAGXRFWHRTb2Z0d2FyZQBQYWludC5ORVQgdjMuNS4xTuc4+QAAB3VJREFUeF7tmPlTlEcexnve94U5mANQbgQSbgiHXHINlxpRIBpRI6wHorLERUmIisKCQWM8cqigESVQS1Kx1piNi4mW2YpbcZONrilE140RCTcy3DDAcL/zbJP8CYPDL+9Ufau7uqb7eZ7P+/a8PS8hwkcgIBAQCAgEBAICAYGAQEAgIBAQCAgEBAICAYGAQEAgIBAQCDx/AoowKXFMUhD3lQrioZaQRVRS+fxl51eBTZUTdZ41U1Rox13/0JF9csGJ05Qv4jSz/YPWohtvLmSKN5iTGGqTm1+rc6weICOBRbZs1UVnrv87T1PUeovxyNsUP9P6n5cpHtCxu24cbrmwKLdj+osWiqrVKhI0xzbmZ7m1SpJ+1pFpvE2DPvGTomOxAoNLLKGLscZYvB10cbYYjrJCb7A5mrxleOBqim+cWJRakZY0JfnD/LieI9V1MrKtwokbrAtU4Vm0A3TJnphJD4B+RxD0u0LA7w7FTE4oprOCMbklEGNrfdGf4IqnQTb4wc0MFTYibZqM7JgjO8ZdJkpMln/sKu16pHZGb7IfptIWg389DPp9kcChWODoMuDdBOhL1JgpisbUvghM7AqFbtNiaFP80RLnhbuBdqi0N+1dbUpWGde9gWpuhFi95yL7sS7BA93JAb+Fn8mh4QujgPeTgb9kAZf3Apd2A+fXQ38yHjOHozB1IAJjOSEY2RSIwVUv4dd4X9wJccGHNrJ7CYQ4GGjLeNNfM+dyvgpzQstKf3pbB2A6m97uBRE0/Ergcxr8hyqg7hrwn0vAtRIKIRX6Y2pMl0RhIj8co9nBGFrvh55l3ngU7YObng7IVnFvGS+BYUpmHziY/Ls2zgP9SX50by/G9N5w6I+ogYvpwK1SoOlHQNsGfWcd9Peqof88B/rTyzF9hAIopAByQzC0JQB9ST5oVnvhnt+LOGsprvUhxNIwa0aY7cGR6Cp7tr8+whkjawIxkRWC6YJI6N+lAKq3Qf/Tx+B77oGfaQc/8hB8w2Xwtw9Bf3kzZspXY/JIDEbfpAB2BKLvVV90Jvjgoac9vpRxE8kciTVCBMMkNirJ7k/tRHyjtxwjKV4Yp3t/6s+R4E+/DH3N6+BrS8E314Dvvg2+/Sb4hxfBf5sP/up2TF3ZhonK1zD6dhwGdwail26DzqgX8MRKiq9ZBpkSkmeYOyPM3m9Jjl+1Z9D8AgNtlAq6bZ70qsZi+q+bwV/7I/hbB8D/dAr8Axq89iz474p/G5++koHJy1sx/lkGdBc2YjA3HF0rHNHuboomuQj/5DgclIvOGCGCYRKFFuTMV7YUAD3VDQaLMfyqBcZORGPy01QKYSNm/rYV/Nd/Av9NHvgbueBrsjDzRQamKKDxT9Kgq1iLkbIUDOSHoiNcgnYHgnYZi+9ZExSbiSoMc2eE2flKcuJLa4KGRQz6/U0wlGaP0feiMH4uFpMXEjBVlYjp6lWY+SSZtim0kulYMiYuJEJXuhTDJ9UYPByOvoIwdCxfgE4bAo0Jh39xLAoVpMwIEQyTyFCQvGpLon9sJ0K3J4OBDDcMH1dj9FQsxkrjMPFRPCbOx2GyfLal9VEcxstioTulxjAFNfROJPqLl6Bnfyg6V7ugz5yBhuHwrZjBdiU5YJg7I8wOpifAKoVIW7uQ3rpOBH2b3ekVjYT2WCRG3o+mIGKgO0OrlIaebU/HYOQDNbQnojB4NJyGD0NPfjA0bwTRE6Q7hsUcWhkWN8yZqSQlWWGECAZLmJfJmbrvVSI8taK37xpbdB/wQW8xPee/8xIGjvlj8IQ/hk4G0JbWcX8MHPVDX4kveoq8ocn3xLM33NCZRcPHOGJYZIKfpQyq7JjHS6yJjcHujLHADgkpuC7h8F8zEVqXSNC2awE69lqhs8AamkO26HrbDt2H7dBVQov2NcW26CiwQtu+BWjdY4n2nZboTbfCmKcCnRyDO/YmyLPnDlHvjDH8G6zhS9/wlEnYR7X00fWrFYuWdVI0ZpuhcbcczW/R2qdAcz6t/bRov4mONeaaoYl+p22rHF0bVNAmKtBvweIXGxNcfFH8eNlC4m6wMWMusEnKpn5hyo48pj9gLe4SNG9QoGGLAk8z5XiaJUd99u8122/IpBA2K9BGg2vWWKAvRYVeLzEa7E1R422m2+MsSTem97nSYnfKyN6/mzATv7AUgqcMrUnmaFlLX3ysM0fj+t/b5lQLtK22QEfyAmiSLKFZpUJ7kBRPXKW4HqCYynWVHKSG2LkyZex1uO1mZM9lKem9Tx9jjY5iNEYo0bKMhn7ZAu0r6H5PpLXCAq0rKJClSjSGynE/QIkrQYqBPe6S2X+AJsY2Ped6iWZk6RlL0c2r5szofRsO9R5S1IfQLRCpQL1aifoYFerpsbkuTImaUJXuXIDiH6/Ys8vm3Mg8L2i20YqsO7fItKLcSXyn0kXccclVqv3MS6at9JU/Ox+ouns+SF6Z4cSupz7l8+z1ucs7LF1AQjOdxfGZzmx8Iu1TRcfnrioICAQEAgIBgYBAQCAgEBAICAQEAgIBgYBAQCAgEBAICAQEAv8H44b/6ZiGvGAAAAAASUVORK5CYII=","width":15,"type":"esriPMS","contentType":"image/png","url":"RedSphere.png","height":15},"type":"simple"}},"copyrightText":"","supportsColumnStoreIndex":true,"supportsLayerOverrides":true,"geometryType":"esriGeometryPoint"},"layers":[{"extent":null,"supportedContingentValuesFormats":"JSON, PBF","guidFormat":"","supportsApplyEditsWithGlobalIds":false,"maxRecordCount":1000,"infoInEstimates":["extent","count"],"type":"Feature Layer","hasStaticData":true,"editingInfo":{"lastEditDate":1790326321839,"schemaLastEditDate":1790326321839,"dataLastEditDate":1790326321839},"supportsAttachmentsByUploadId":true,"relationships":[],"supportsEditingContingentValues":true,"supportsAttachmentsResizing":true,"id":0,"collation":{"caseSensitive":false,"accentSensitive":true,"locale":"neutral"},"supportsStatistics":true,"supportedExportFormats":"csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet","standardMaxRecordCount":16000,"isDataVersioned":false,"templates":[{"name":"New Feature","description":"","drawingTool":"esriFeatureEditToolPoint","prototype":{"attributes":{"ZIP":null,"ST":null,"Address":null,"Lon":null,"City":null,"Date_Last_Pmt_":null,"E_Mail":null,"Alt__Phone":null,"Phone":null,"Company_Name":null,"Prof__Type":null,"FAX":null,"Lat":null}}}],"supportsAdvancedQueries":true,"supportsTilesAndBasicQueriesMode":true,"currentVersion":12,"hasZ":false,"advancedEditingCapabilities":{"supportsAsyncApplyEdits":true,"supportsApplyEditsbyUploadID":true,"supportsTranslation":false,"supportsReturnEditResults":true,"supportsMaxTranslations":10,"supportedSqlFormatsInCalculate":["standard"],"supportedApplyEditsUploadIDFormats":"JSON,PBF"},"supportsQuantizationEditMode":true,"objectIdField":"ObjectId","hasContingentValuesDefinition":false,"maxIdsCount":1000000,"viewSourceHasAttachments":false,"name":"RegisteredProfessionalContractors","displayField":"","supportsCalculate":true,"fields":[{"sqlType":"sqlTypeNVarchar","actualType":"nvarchar","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Company_Name","length":4000,"alias":"Company Name","type":"esriFieldTypeString"},{"sqlType":"sqlTypeNVarchar","actualType":"nvarchar","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Prof__Type","length":4000,"alias":"Profession Type","type":"esriFieldTypeString"},{"sqlType":"sqlTypeNVarchar","actualType":"nvarchar","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Address","length":4000,"alias":"Address","type":"esriFieldTypeString"},{"sqlType":"sqlTypeNVarchar","actualType":"nvarchar","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"City","length":4000,"alias":"City","type":"esriFieldTypeString"},{"sqlType":"sqlTypeNVarchar","actualType":"nvarchar","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"ST","length":4000,"alias":"ST","type":"esriFieldTypeString"},{"sqlType":"sqlTypeNVarchar","actualType":"nvarchar","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"ZIP","length":256,"alias":"ZIP","type":"esriFieldTypeString"},{"sqlType":"sqlTypeFloat","actualType":"float","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Lon","alias":"Lon","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeFloat","actualType":"float","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Lat","alias":"Lat","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeInteger","actualType":"int","nullable":false,"editable":false,"defaultValue":null,"domain":null,"name":"ObjectId","alias":"ObjectId","type":"esriFieldTypeOID"}],"maxRecordCountFactor":1,"dateFieldsTimeReference":{"timeZoneIANA":"Etc/UTC","respectsDaylightSaving":false,"timeZone":"UTC"},"supportsFieldDescriptionProperty":true,"hasM":false,"allowGeometryUpdates":true,"preferredTimeReference":null,"isView":true,"useStandardizedQueries":true,"globalIdField":"","supportedConvertContentFormats":"LayerEditCollection,FeatureCollection","description":"","enableNullGeometry":false,"isUpdatableView":true,"supportedOperationsWithCollation":"query,addField,updateField","supportedSpatialRelationships":["esriSpatialRelIntersects","esriSpatialRelContains","esriSpatialRelCrosses","esriSpatialRelEnvelopeIntersects","esriSpatialRelIndexIntersects","esriSpatialRelOverlaps","esriSpatialRelTouches","esriSpatialRelWithin","esriSpatialRelDisjoint","esriSpatialRelRelation"],"supportsRollbackOnFailureParameter":true,"supportsTruncate":false,"standardMaxRecordCountNoGeometry":32000,"indexes":[{"indexType":"Attribute","name":"PK__REGISTER__9A6192915A2E8E89","isUnique":true,"description":"clustered, unique, primary key","fields":"ObjectId","isAscending":true},{"indexType":"Spatial","name":"user_8986.REGISTEREDPROFESSIONALCONTRACTORS_REGISTEREDPROFESSIONALCONTRACTORS_Shape_sidx","isUnique":false,"description":"Shape Index","fields":"Shape","isAscending":true}],"supportedAppendSourceFilterFormats":"sqlite,geoPackage,shapefile,filegdb,featureService","htmlPopupType":"esriServerHTMLPopupTypeNone","supportsReturningQueryGeometry":true,"minScale":0,"hasAttachments":false,"queryBinsCapabilities":{"supportsReturnStackValueRange":true,"supportedNormalizationTypes":["boxCox","field","inverse","log","naturalLog","percentOfTotal","squareRoot"],"supportsNormalization":true,"supportsSnapToData":true,"supportsFixedIntervalBin":true,"supportsStackBy":true,"supportsDateBin":true,"supportsSplitBy":true,"supportsClassificationBin":true,"supportsReturnFullIntervalBin":true,"supportsAsync":true,"supportsFirstDayOfWeek":true,"supportedStatisticTypes":["COUNT","SUM","AVG","VAR","STDDEV","MIN","MAX","PERCENTILE_CONT","PERCENTILE_DISC","APPROX_PERCENTILE_CONT","APPROX_PERCENTILE_DISC","CentroidAggregate","EnvelopeAggregate","ConvexHullAggregate"],"supportsAutoIntervalBin":true,"supportsFixedBoundariesBin":true},"supportedConvertFileFormats":"JSON,PBF,Parquet","advancedQueryCapabilities":{"supportsSqlExpression":true,"supportsQueryWithResultType":true,"supportsTranslations":false,"supportsQueryRelatedPagination":true,"supportedOperationsWithCacheHint":["query","queryTopFilter","queryAnalytics","queryAttachments","queryRelated","queryBins","queryPivot"],"supportsQueryWithCacheHint":true,"supportsQueryWithDatumTransformation":true,"supportsCurrentUserQueries":true,"supportsAggIds":true,"supportsOutFieldSQLExpression":true,"supportsDefaultSR":true,"fullTextSearchCapabilities":{"supportsStopWords":true,"supportsOperator":true,"supportsSearchOperator":true,"supportsAccentSensitivity":true},"supportsQueryBins":true,"supportsQueryWithCollation":true,"supportsQueryPivot":true,"supportsApproxPercentileStatistics":true,"supportsQueryWithLodSR":false,"supportsPaginationOnAggregatedQueries":true,"supportsPagination":true,"supportsMaxRecordCountFactor":true,"supportsStatistics":true,"supportsOutDistance":true,"supportsOrderBy":true,"supportsDisjointSpatialRel":true,"supportsFullTextSearch":true,"supportsQueryWithDistance":true,"supportsLod":true,"supportsSpatialAggregationStatistics":true,"supportsCountDistinct":true,"supportedLodTypes":["geohash"],"supportsAdvancedQueryRelated":true,"supportsReturningQueryExtent":true,"supportsISODOW":true,"supportsTopFeaturesQuery":true,"supportsReturningGeometryEnvelope":false,"supportsDistinct":true,"supportsReturningGeometryCentroid":false,"supportsTimeRelation":true,"supportsQueryAnalytic":true,"supportsPercentileStatistics":true,"supportedSpatialAggregationStatistics":["EnvelopeAggregate","CentroidAggregate","ConvexHullAggregate"],"supportsISOWeek":true,"supportsHavingClause":true},"serviceItemId":"ac877684ad8b45e8b539af65ce475fe2","supportsValidateSql":true,"cacheMaxAge":3600,"supportsCoordinatesQuantization":true,"types":[],"capabilities":"Query,Extract","supportsAppend":true,"maxScale":0,"supportsExceedsLimitStatistics":true,"supportedSyncDataOptions":260,"sourceSchemaChangesAllowed":true,"supportsContingentValues":true,"defaultVisibility":true,"advancedQueryAnalyticCapabilities":{"supportsAsync":true,"supportsLinearRegression":true,"supportsTrendlineRegression":true,"supportsPercentileAnalytic":true},"supportedAppendFormats":"sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf","uniqueIdField":{"isSystemMaintained":true,"name":"ObjectId"},"tileMaxRecordCount":8000,"supportsFieldGroups":true,"typeIdField":"","supportsASyncCalculate":true,"supportedQueryFormats":"JSON, geoJSON, PBF","drawingInfo":{"renderer":{"symbol":{"imageData":"iVBORw0KGgoAAAANSUhEUgAAAEAAAABACAYAAACqaXHeAAAABGdBTUEAALGPC/xhBQAAACBjSFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAACXBIWXMAAA7DAAAOwwHHb6hkAAAAGXRFWHRTb2Z0d2FyZQBQYWludC5ORVQgdjMuNS4xTuc4+QAAB3VJREFUeF7tmPlTlEcexnve94U5mANQbgQSbgiHXHINlxpRIBpRI6wHorLERUmIisKCQWM8cqigESVQS1Kx1piNi4mW2YpbcZONrilE140RCTcy3DDAcL/zbJP8CYPDL+9Ufau7uqb7eZ7P+/a8PS8hwkcgIBAQCAgEBAICAYGAQEAgIBAQCAgEBAICAYGAQEAgIBAQCDx/AoowKXFMUhD3lQrioZaQRVRS+fxl51eBTZUTdZ41U1Rox13/0JF9csGJ05Qv4jSz/YPWohtvLmSKN5iTGGqTm1+rc6weICOBRbZs1UVnrv87T1PUeovxyNsUP9P6n5cpHtCxu24cbrmwKLdj+osWiqrVKhI0xzbmZ7m1SpJ+1pFpvE2DPvGTomOxAoNLLKGLscZYvB10cbYYjrJCb7A5mrxleOBqim+cWJRakZY0JfnD/LieI9V1MrKtwokbrAtU4Vm0A3TJnphJD4B+RxD0u0LA7w7FTE4oprOCMbklEGNrfdGf4IqnQTb4wc0MFTYibZqM7JgjO8ZdJkpMln/sKu16pHZGb7IfptIWg389DPp9kcChWODoMuDdBOhL1JgpisbUvghM7AqFbtNiaFP80RLnhbuBdqi0N+1dbUpWGde9gWpuhFi95yL7sS7BA93JAb+Fn8mh4QujgPeTgb9kAZf3Apd2A+fXQ38yHjOHozB1IAJjOSEY2RSIwVUv4dd4X9wJccGHNrJ7CYQ4GGjLeNNfM+dyvgpzQstKf3pbB2A6m97uBRE0/Ergcxr8hyqg7hrwn0vAtRIKIRX6Y2pMl0RhIj8co9nBGFrvh55l3ngU7YObng7IVnFvGS+BYUpmHziY/Ls2zgP9SX50by/G9N5w6I+ogYvpwK1SoOlHQNsGfWcd9Peqof88B/rTyzF9hAIopAByQzC0JQB9ST5oVnvhnt+LOGsprvUhxNIwa0aY7cGR6Cp7tr8+whkjawIxkRWC6YJI6N+lAKq3Qf/Tx+B77oGfaQc/8hB8w2Xwtw9Bf3kzZspXY/JIDEbfpAB2BKLvVV90Jvjgoac9vpRxE8kciTVCBMMkNirJ7k/tRHyjtxwjKV4Yp3t/6s+R4E+/DH3N6+BrS8E314Dvvg2+/Sb4hxfBf5sP/up2TF3ZhonK1zD6dhwGdwail26DzqgX8MRKiq9ZBpkSkmeYOyPM3m9Jjl+1Z9D8AgNtlAq6bZ70qsZi+q+bwV/7I/hbB8D/dAr8Axq89iz474p/G5++koHJy1sx/lkGdBc2YjA3HF0rHNHuboomuQj/5DgclIvOGCGCYRKFFuTMV7YUAD3VDQaLMfyqBcZORGPy01QKYSNm/rYV/Nd/Av9NHvgbueBrsjDzRQamKKDxT9Kgq1iLkbIUDOSHoiNcgnYHgnYZi+9ZExSbiSoMc2eE2flKcuJLa4KGRQz6/U0wlGaP0feiMH4uFpMXEjBVlYjp6lWY+SSZtim0kulYMiYuJEJXuhTDJ9UYPByOvoIwdCxfgE4bAo0Jh39xLAoVpMwIEQyTyFCQvGpLon9sJ0K3J4OBDDcMH1dj9FQsxkrjMPFRPCbOx2GyfLal9VEcxstioTulxjAFNfROJPqLl6Bnfyg6V7ugz5yBhuHwrZjBdiU5YJg7I8wOpifAKoVIW7uQ3rpOBH2b3ekVjYT2WCRG3o+mIGKgO0OrlIaebU/HYOQDNbQnojB4NJyGD0NPfjA0bwTRE6Q7hsUcWhkWN8yZqSQlWWGECAZLmJfJmbrvVSI8taK37xpbdB/wQW8xPee/8xIGjvlj8IQ/hk4G0JbWcX8MHPVDX4kveoq8ocn3xLM33NCZRcPHOGJYZIKfpQyq7JjHS6yJjcHujLHADgkpuC7h8F8zEVqXSNC2awE69lqhs8AamkO26HrbDt2H7dBVQov2NcW26CiwQtu+BWjdY4n2nZboTbfCmKcCnRyDO/YmyLPnDlHvjDH8G6zhS9/wlEnYR7X00fWrFYuWdVI0ZpuhcbcczW/R2qdAcz6t/bRov4mONeaaoYl+p22rHF0bVNAmKtBvweIXGxNcfFH8eNlC4m6wMWMusEnKpn5hyo48pj9gLe4SNG9QoGGLAk8z5XiaJUd99u8122/IpBA2K9BGg2vWWKAvRYVeLzEa7E1R422m2+MsSTem97nSYnfKyN6/mzATv7AUgqcMrUnmaFlLX3ysM0fj+t/b5lQLtK22QEfyAmiSLKFZpUJ7kBRPXKW4HqCYynWVHKSG2LkyZex1uO1mZM9lKem9Tx9jjY5iNEYo0bKMhn7ZAu0r6H5PpLXCAq0rKJClSjSGynE/QIkrQYqBPe6S2X+AJsY2Ped6iWZk6RlL0c2r5szofRsO9R5S1IfQLRCpQL1aifoYFerpsbkuTImaUJXuXIDiH6/Ys8vm3Mg8L2i20YqsO7fItKLcSXyn0kXccclVqv3MS6at9JU/Ox+ouns+SF6Z4cSupz7l8+z1ucs7LF1AQjOdxfGZzmx8Iu1TRcfnrioICAQEAgIBgYBAQCAgEBAICAQEAgIBgYBAQCAgEBAICAQEAv8H44b/6ZiGvGAAAAAASUVORK5CYII=","width":15,"type":"esriPMS","contentType":"image/png","url":"RedSphere.png","height":15},"type":"simple"}},"copyrightText":"","supportsColumnStoreIndex":true,"supportsLayerOverrides":true,"geometryType":"esriGeometryPoint"}],"licenseInfo":null,"maxRecordCount":1000,"metadata":null,"modified":1790326321839,"modifiedProvenance":"layer.editingInfo.lastEditDate","name":"Registered Professional Contractors and Licenses","objectIdField":"ObjectId","openData":false,"orgId":"HdTo6HJqh92wn4D8","orgName":"Nashville GIS","organization":"Nashville GIS","orgExtent":{"ymin":4295228.852216443,"xmin":-9698309.88519694,"ymax":4357295.044720508,"xmax":-9623402.999842146,"spatialReference":{"wkid":102100}},"orgContactEmail":"mailto: gisdatateam@nashville.gov","owner":"NashvilleOpenData","recordCount":7140,"region":"US","searchDescription":"Details of active contractors of various types registered with the Metro Codes Administration.  This dataset is updated daily. Source Link: https://epermits.nashville.gov/ Metadata Document: Registered-Professional-Contractors-Metadata.pdf Contact Data Owner: opendata@nashville.gov ","sector":"Local and State Government","server":{"supportedContingentValuesFormats":"JSON, PBF","supportsApplyEditsWithGlobalIds":false,"maxRecordCount":1000,"onlyAllowTrueCurveUpdatesByTrueCurveClients":true,"supportsSharedDomains":true,"hasStaticData":true,"syncEnabled":false,"supportedAppendCapabilities":"Features","tables":[],"layerOverridesEnabled":true,"layers":[{"subLayerIds":null,"maxScale":0,"name":"RegisteredProfessionalContractors","defaultVisibility":true,"id":0,"minScale":0,"type":"Feature Layer","parentLayerId":-1,"geometryType":"esriGeometryPoint"}],"spatialReference":{"latestWkid":3857,"wkid":102100},"fullExtent":{"ymin":4296391.721415075,"xmin":-9687928.752749987,"ymax":4353335.16659965,"xmax":-9634091.752533823,"spatialReference":{"latestWkid":3857,"wkid":102100}},"supportedExportFormats":"csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel","xssPreventionInfo":{"xssInputRule":"rejectInvalid","xssPreventionRule":"InputOnly","xssPreventionEnabled":true},"supportsDisconnectedEditing":false,"supportsTilesAndBasicQueriesMode":true,"currentVersion":12,"hasSharedDomains":false,"supportsWebHooks":true,"advancedEditingCapabilities":{"supportsAsyncApplyEdits":true,"supportsApplyEditsbyUploadID":true,"supportsSplit":false,"supportsReturnEditResults":true,"supportsReturnServiceEditsInSourceSR":false,"supportedApplyEditsUploadIDFormats":"JSON,PBF"},"maxIdsCount":1000000,"initialExtent":{"ymin":4296391.721415075,"xmin":-9687928.752749987,"ymax":4353335.16659965,"xmax":-9634091.752533823,"spatialReference":{"latestWkid":3857,"wkid":102100}},"supportedCurveTypes":["esriGeometryCircularArc"],"allowTrueCurvesUpdates":true,"supportsTemporalLayers":true,"allowGeometryUpdates":true,"supportsQueryContingentValues":true,"isView":true,"supportedFullTextLocales":["neutral","ar-SA","bg-BG","bn-IN","ca-ES","cs-CZ","da-DK","de-DE","el-GR","en-GB","en-US","es-ES","fr-FR","gu-IN","he-IL","hi-IN","hr-HR","id-ID","is-IS","it-IT","ja-JP","kn-IN","ko-KR","lt-LT","lv-LV","ml-IN","mr-IN","ms-MY","nb-NO","nl-NL","pa-IN","pl-PL","pt-BR","pt-PT","ro-RO","ru-RU","sk-SK","sl-SI","sr-Cyrl-CS","sr-Latn-CS","sv-SE","ta-IN","te-IN","th-TH","tr-TR","uk-UA","ur-PK","vi-VN","zh-CN","zh-HK","zh-MO","zh-SG","zh-TW"],"supportedConvertContentFormats":"LayerEditCollection","description":"","units":"esriMeters","isUpdatableView":true,"hasVersionedData":false,"supportedConvertFileFormats":"JSON,PBF","supportsSharedTemplates":true,"serviceItemId":"ac877684ad8b45e8b539af65ce475fe2","capabilities":"Query,Extract","supportsTrueCurve":true,"supportsAppend":true,"sourceSchemaChangesAllowed":true,"supportsContingentValuesJson":2,"supportedTrueCurvePbfFeatureEncodings":["esriCompressedShapeBuffer","esriDefault"],"preserveLayerIds":true,"supportsReturnDeleteResults":true,"supportsVCSProjection":false,"supportedQueryFormats":"JSON","trueCurveSupportMode":"OGC","serviceDescription":"","hasSharedTemplates":true,"copyrightText":"","supportsLayerOverrides":true},"serverCapabilities":"Query,Extract","serviceSpatialReference":{"latestWkid":3857,"wkid":102100},"size":0,"slug":"Nashville::registered-professional-contractors-and-licenses","source":"Nashville GIS","sourceProvenance":"org.name","statistics":{"string":{"zip":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":277.7572879999643,"values":[],"count":0,"uniqueCount":0}},"st":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":272.37114299996756,"values":[{"count":7138,"value":"TN"},{"count":2,"value":"TM"}],"count":7140,"uniqueCount":2}},"address":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":170.13566000002902,"values":[{"count":22,"value":"1106 LEBANON PIKE"},{"count":18,"value":"1024 HARRISON ST"},{"count":18,"value":"2005 ELM HILL PIKE"},{"count":18,"value":"3401 JOHN MALLETTE DRIVE"},{"count":18,"value":"649 OLD HICKORY BLVD"},{"count":17,"value":"3868 DICKERSON PIKE STE 200"},{"count":16,"value":"1717 ELM HILL PIKE B2"},{"count":16,"value":"659 THOMPSON LN"},{"count":15,"value":"148 PARK SOUTH COURT"},{"count":15,"value":"2001 PITTWAY DRIVE"},{"count":15,"value":"3017 OAKLAND AVE"},{"count":15,"value":"411 E CAMPBELL RD"},{"count":15,"value":"4124 FRANKLIN RD"},{"count":15,"value":"4839 JONQUIL DRIVE"},{"count":15,"value":"506 FREDA VILLA"},{"count":15,"value":"915 MURFREESBORO PIKE"},{"count":14,"value":"15115 OLD HICKORY BLVD SUITE B"},{"count":14,"value":"1877 AIR LANE DR"},{"count":14,"value":"219 LANIER DR"},{"count":14,"value":"2525 PERIMETER PLACE DRIVE"},{"count":14,"value":"2703 GRANDVIEW AVE"},{"count":14,"value":"305 HILL AVE"},{"count":14,"value":"3512 RICHARDSON AVE"},{"count":14,"value":"50 VISCO CT"},{"count":14,"value":"5751 CANE RIDGE ROAD"},{"count":14,"value":"600 12TH AVE S APT 822"},{"count":14,"value":"6636 WHITTEMORE LN"},{"count":13,"value":"109 WOODRUFF STREET"},{"count":13,"value":"1277 BARNES RD"},{"count":13,"value":"200 CRUTCHFIELD AVE"},{"count":13,"value":"2404 WINFORD AVE"},{"count":13,"value":"2949 BRICK CHURCH PIKE"},{"count":13,"value":"3305 COBBLE ST"},{"count":13,"value":"4071 POWELL AVE"},{"count":13,"value":"5160 RICE RD APT 367"},{"count":13,"value":"7101 OLD HICKORY BLVD"},{"count":13,"value":"7556 OLD HICKORY BLVD"},{"count":12,"value":"1720 ED TEMPLE BLVD."},{"count":12,"value":"1814 STATE ST."},{"count":12,"value":"2426 WINFORD AVE"},{"count":12,"value":"310 MADISON ST"},{"count":12,"value":"3868 B DICKERSON RD"},{"count":12,"value":"45 WILLOW STREET"},{"count":12,"value":"718 THOMPSON LANE #108-115"},{"count":11,"value":"1016 NINTH AVENUE NORTH"},{"count":11,"value":"1100 TUCKAHOE DRIVE"},{"count":11,"value":"1508 SAUNDERS AVE"},{"count":11,"value":"1521 GALLATIN PIKE N"},{"count":11,"value":"1610 HEIL QUAKER BLVD."},{"count":11,"value":"2139 CANADY AVE"}],"count":5221,"uniqueCount":1000}},"prof__type":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":271.77954199991655,"values":[{"count":1859,"value":"General Contractor License"},{"count":858,"value":"State Residential Building"},{"count":309,"value":"State Commercial Building"},{"count":298,"value":"State Building Contractor All"},{"count":276,"value":"State Commercial Small Building"},{"count":264,"value":"Alarm Contractor License"},{"count":250,"value":"Low Voltage Installation"},{"count":238,"value":"State Home Improvement"},{"count":228,"value":"Equipment Installation"},{"count":219,"value":"Electrical S/M Contractor Lic"},{"count":192,"value":"State Electrical Contractor"},{"count":171,"value":"Gas/Mechanical Up to 750 BTUS"},{"count":164,"value":"Gas/Mechanical Up to 1500 BTUS"},{"count":159,"value":"Septic Tank Installation"},{"count":155,"value":"Plumbing S/M Contractor Lic"},{"count":144,"value":"Gas/Mechanical S/M Contractor Lic"},{"count":141,"value":"State Gas/Mechanical Contractor"},{"count":128,"value":"State Plumbing Contractor"},{"count":105,"value":"Excavation Contractor"},{"count":53,"value":"State Residential Restricted To $125K"},{"count":49,"value":"Metro Electrical Co. Designation #"},{"count":44,"value":"Metro Plumbing Co Designation #"},{"count":43,"value":"Metro Elect Low Voltage Designation #"},{"count":41,"value":"State Alarm Designation #"},{"count":37,"value":"Metro Master Plumber"},{"count":34,"value":"Electrical Low Voltage Installer License"},{"count":33,"value":"Metro HVAC Contractor Designation"},{"count":33,"value":"State Municipal Underground Piping"},{"count":31,"value":"Master Electrician License"},{"count":30,"value":"State Roofing"},{"count":26,"value":"Metro Elect Equipment Co Designation #"},{"count":22,"value":"State Swimming Pools"},{"count":21,"value":"State Alarm License"},{"count":21,"value":"State Municipal And Utility Construction"},{"count":21,"value":"State Municipal Grading & Drainage"},{"count":20,"value":"Metro HVAC License"},{"count":20,"value":"State Industrial"},{"count":16,"value":"State Concrete"},{"count":15,"value":"Metro Gas/App Contractor Designation"},{"count":15,"value":"State Demolition"},{"count":14,"value":"State Carpentry, Framming And Millwork"},{"count":14,"value":"State Highway, Railroad, & Airport Const"},{"count":14,"value":"State Municipal Water & Sewer"},{"count":13,"value":"Metro Gas/Mech Designation #"},{"count":11,"value":"State Heavy Construction"},{"count":11,"value":"State Landscaping"},{"count":11,"value":"State Municipal Piping Sewer, Storm"},{"count":10,"value":"Electrical Equipment Installer 1 License"},{"count":10,"value":"State Excavation"},{"count":10,"value":"State Municipal Base And Paving"}],"count":7140,"uniqueCount":111}},"city":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":280.1230119999964,"values":[{"count":5318,"value":"NASHVILLE"},{"count":369,"value":"GOODLETTSVILLE"},{"count":322,"value":"MADISON"},{"count":318,"value":"ANTIOCH"},{"count":219,"value":"HERMITAGE"},{"count":151,"value":"OLD HICKORY"},{"count":109,"value":"JOELTON"},{"count":100,"value":"BRENTWOOD"},{"count":93,"value":"WHITES CREEK"},{"count":39,"value":"PEGRAM"},{"count":28,"value":"NOLENSVILLE"},{"count":12,"value":"ASHLAND CITY"},{"count":11,"value":"LAVERGNE"},{"count":9,"value":"MT JULIET"},{"count":8,"value":"NASHVILE"},{"count":5,"value":"WHTIES CREEK"},{"count":4,"value":"GOODLETTESVILLE"},{"count":3,"value":"NASHIVLLE"},{"count":3,"value":"NASHVLLE"},{"count":3,"value":"NSHVILLE"},{"count":2,"value":"ANITOCH"},{"count":2,"value":"DONELSON"},{"count":2,"value":"FRANKLIN"},{"count":2,"value":"MT. JULIET"},{"count":2,"value":"NASHILLE"},{"count":2,"value":"NASHVIILE"},{"count":2,"value":"NASVHILLE"},{"count":2,"value":"NOLENSIVLLE"}],"count":7140,"uniqueCount":28}},"phone":{"meta":{"pass":false,"missingStats":["count"],"error":""},"statistics":{"duration":456.4788690000423,"values":[{"count":22,"value":"615-515-1270"},{"count":20,"value":"6155551212"},{"count":18,"value":"(615)256-0112"},{"count":18,"value":"615-356-0755"},{"count":17,"value":"(615)860-5411"},{"count":17,"value":"6152632900"},{"count":16,"value":"(615)405-4595"},{"count":16,"value":"6155730174"},{"count":16,"value":"6298888400"},{"count":15,"value":"(615)226-8929"},{"count":15,"value":"6152397035"},{"count":15,"value":"6152972888"},{"count":15,"value":"615-477-2761"},{"count":15,"value":"6155004289"},{"count":15,"value":"6155791082"},{"count":15,"value":"6156872993"},{"count":15,"value":"6157964846"},{"count":15,"value":"6158182316"},{"count":14,"value":"(615)254-8050"},{"count":14,"value":"(615)256-8919"},{"count":14,"value":"(615)577-1777"},{"count":14,"value":"(615)832-8500"},{"count":14,"value":"4232503553"},{"count":14,"value":"6152623777"},{"count":14,"value":"6154814029"},{"count":14,"value":"6155870697"},{"count":14,"value":"6156790680"},{"count":14,"value":"615-900-6873"},{"count":13,"value":"(615)256-1444"},{"count":13,"value":"(615)883-7335"},{"count":13,"value":"6153507975"},{"count":13,"value":"6155726897"},{"count":13,"value":"6156905523"},{"count":13,"value":"6157832513"},{"count":13,"value":"6158299746"},{"count":13,"value":"6158396946"},{"count":13,"value":"6158768603"},{"count":12,"value":"(615)255-2527"},{"count":12,"value":"615-394-2117"},{"count":12,"value":"6155153015"},{"count":12,"value":"6158687620"},{"count":11,"value":"(615)227-2811"},{"count":11,"value":"(615)244-3676"},{"count":11,"value":"(615)254-3491"},{"count":11,"value":"(615)292-8497"},{"count":11,"value":"(615)320-1889"},{"count":11,"value":"(615)361-6100"},{"count":11,"value":"(615)397-5911"},{"count":11,"value":"(615)832-9549"},{"count":11,"value":"(615)865-1060"}],"count":5310,"uniqueCount":1000}},"e_mail":{"meta":{"pass":false,"missingStats":["count"],"error":""},"statistics":{"duration":473.0294199999771,"values":[{"count":22,"value":"RICHARD@JARRETTBUILDERSINC.COM"},{"count":18,"value":"ANDY.MADDOX@JBOUCHARD.COM"},{"count":18,"value":"OFFICE@CONTRACTPROPERTIES.NET"},{"count":17,"value":"CUSTOMER.SERVICE@WHEELERINCORPORATED.COM"},{"count":17,"value":"JUSTINSOUTH@THECOMFORTGROUP.COM"},{"count":16,"value":"AMERICAN.FARMS@YAHOO.COM"},{"count":16,"value":"PERMITS@COOLRAYTN.COM"},{"count":16,"value":"STEPHEN@ABSOFTN.COM"},{"count":15,"value":"AMANDA.ALKHATIB@HAPPYHILLER.COM"},{"count":15,"value":"BOBBYHUFFINE@YAHOO.COM"},{"count":15,"value":"CHRIS.CORBY@SFMSERVICE.COM"},{"count":15,"value":"INFO@JAC-CONSTRUCTION.COM"},{"count":15,"value":"JNICHOLAS770@YAHOO.COM"},{"count":15,"value":"JOHN@MISTLERCOMPANY.COM"},{"count":15,"value":"PEYTON@P2ELECTRICALCONTRACTING.COM"},{"count":15,"value":"THEPROS@REALHANDY.PRO"},{"count":15,"value":"WCI2@BELLSOUTH.NET"},{"count":14,"value":"ASCENSIONSERVICES2012@GMAIL.COM"},{"count":14,"value":"BOBBY.HILL@JCI.COM"},{"count":14,"value":"DUNROVINLANE@AOL.COM"},{"count":14,"value":"EWALLIN@MERRYMAN-FARR.COM"},{"count":14,"value":"INFO@TOTALTRANS4MATION.COM"},{"count":14,"value":"MLEMUS1586@HOTMAIL.COM"},{"count":14,"value":"OFFICE@APLESCONSTRUCTION.COM"},{"count":14,"value":"PERMITS@INTERSTATEAC.COM"},{"count":14,"value":"RES-4331-SCHEDULE@IES-CO.COM"},{"count":14,"value":"SCAWTHORN@TURNTOTOTAL.COM"},{"count":13,"value":"CASEY@TUFFOELECTRICAL.COM"},{"count":13,"value":"DEBCSHEATAIR@YAHOO.COM"},{"count":13,"value":"EMILY.BAGGETT@PIONEERCOMFORT.COM"},{"count":13,"value":"LICENSING@GARNEY.COM"},{"count":13,"value":"NASHVILLEPERMITS@ARS.COM"},{"count":13,"value":"PAYABLES@THEMAYNARDMAN.COM"},{"count":13,"value":"PERMITS@PRECISIONPLUMBINGCOMPANY.COM"},{"count":13,"value":"POP.POLA33@GMAIL.COM"},{"count":13,"value":"RLIGONSR@ICFBUILDERSINC.COM"},{"count":12,"value":"JEMHVAC.KENNY@GMAIL.COM"},{"count":12,"value":"JIMMY@MORTONPLUMBING.NET"},{"count":12,"value":"TJEJASONZIMMER@GMAIL.COM"},{"count":11,"value":"ALICAL5718@YAHOO.COM"},{"count":11,"value":"BANDYELECTRICCOMPANY@GMAIL.COM"},{"count":11,"value":"BBURNETTE@WARDP-M.COM"},{"count":11,"value":"BCARVER@AMERICANHOMEDESIGN.COM"},{"count":11,"value":"BPROCTOR@FMSYLVAN.COM"},{"count":11,"value":"BRETTDURHAM@SUNRISECONTRACTING.NET"},{"count":11,"value":"CHARLIECOLLINS777@GMAIL.COM"},{"count":11,"value":"CONCORDIADEV@ATT.NET"},{"count":11,"value":"DSTEVENS@MAINTMECHSYSTEMS.COM"},{"count":11,"value":"GONGENG@YAHOO.COM"},{"count":11,"value":"hlferguson29@gmail.com"}],"count":5133,"uniqueCount":1000}},"company_name":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":149.36356700002216,"values":[{"count":22,"value":"JARRETT BUILDERS INC"},{"count":18,"value":"BOUCHARD, JOHN & SONS CO"},{"count":18,"value":"CONTRACT PROPERTIES INC"},{"count":18,"value":"ICF BUILDERS"},{"count":17,"value":"WHEELER INC"},{"count":16,"value":"COMFORT GROUP INC, THE"},{"count":16,"value":"COOLRAY OF TENNESSEE LLC"},{"count":15,"value":"B & C CONSTRUCTION CO"},{"count":15,"value":"HILLER PLUMBING, HEATING, COOLING & ELECTRICAL DBA HILLER LL"},{"count":15,"value":"HUFFINE FIRST SERVICE"},{"count":15,"value":"JAC CONSTRUCTION SERVICES LLC"},{"count":15,"value":"REAL HANDY PRO LLC"},{"count":15,"value":"SCHOOL FACILITY MANAGEMENT LLC DBA SFM CONSTRUCTION"},{"count":15,"value":"WARNER CONSTRUCTION INC"},{"count":14,"value":"ASCENSION SERVICES"},{"count":14,"value":"IES RESIDENTIAL INC"},{"count":14,"value":"INTERSTATE AC SERVICE LLC"},{"count":14,"value":"JGC INC"},{"count":14,"value":"JOHNSON CONTROLS FIRE PROTECTION LP"},{"count":14,"value":"LAKE RESIDENTIAL SERVICES"},{"count":14,"value":"LEMUS, MARCELO HVAC INC"},{"count":14,"value":"MERRYMAN-FARR LLC"},{"count":14,"value":"MISTLER COMPANY LLC"},{"count":14,"value":"PIONEER HEATING, COOLING, ELECTRICAL & PLUMBING LLC"},{"count":14,"value":"TOTAL GROUP LLC"},{"count":13,"value":"AMERICAN RESIDENTIAL SERVICES LLC DBA ARS/RESCUE ROOTER"},{"count":13,"value":"C & S HEATING AIR & ELECTRIC INC"},{"count":13,"value":"DEDICATED HVAC & ELECTRIC LLC"},{"count":13,"value":"GARNEY COMPANIES INC - (FORMERLY GARNEY HOLDING CO & SUBSIDI"},{"count":13,"value":"PRECISION PLUMBING CO"},{"count":13,"value":"PRO ELECTRICIANS LLC"},{"count":13,"value":"TUFFO ELECTRICAL LLC"},{"count":12,"value":"HOFFMANN BROTHERS LLC"},{"count":12,"value":"JARVIS AWARD SIGN AND FLAG CO"},{"count":12,"value":"JEM MECHANICAL INC"},{"count":12,"value":"MAYNARD SELECT LLC *** LICENSE EXPIRED"},{"count":12,"value":"MORTON PLUMBING INC"},{"count":12,"value":"TJ ELECTRIC"},{"count":11,"value":"AMERICAN HOME DESIGN INC"},{"count":11,"value":"BANDY ELECTRIC CO"},{"count":11,"value":"CART ELECTRIC CO"},{"count":11,"value":"CHRISTIAN, C O & SONS CO INC"},{"count":11,"value":"CLAUD HEATING & AIR LLC"},{"count":11,"value":"CONCORDIA DEVELOPMENT INC"},{"count":11,"value":"FERGUSON HVAC & ELECTRICAL"},{"count":11,"value":"MORLEY, J J ENTERPRISES INC"},{"count":11,"value":"MSJD INC MAINTENANCE SYSTEMS"},{"count":11,"value":"NASHVILLE DESIGN BUILDERS LLC"},{"count":11,"value":"NEW HORIZON CONTRACTORS LLC"},{"count":11,"value":"PRO BUILD LLC"}],"count":5105,"uniqueCount":1000}},"alt__phone":{"meta":{"pass":false,"missingStats":["count"],"error":""},"statistics":{"duration":336.51081700000213,"values":[{"count":22,"value":"6159795369"},{"count":16,"value":"6156699389"},{"count":15,"value":"6153943654"},{"count":15,"value":"6158182315"},{"count":15,"value":"6292086600"},{"count":15,"value":"9316372187"},{"count":14,"value":"615-349-0200"},{"count":14,"value":"6157196011"},{"count":13,"value":"6157153229"},{"count":13,"value":"8167467240"},{"count":12,"value":"3143024784"},{"count":12,"value":"6154441413"},{"count":11,"value":"6156863953"},{"count":10,"value":"6152071557"},{"count":10,"value":"6155693615"},{"count":10,"value":"615-804-7611"},{"count":9,"value":"6153335952"},{"count":9,"value":"6153946071"},{"count":9,"value":"6154059710"},{"count":9,"value":"6154711214"},{"count":8,"value":"6154250305"},{"count":8,"value":"6155330784"},{"count":8,"value":"6156425820"},{"count":8,"value":"6159530088"},{"count":7,"value":"615-242-0284"},{"count":7,"value":"6152445646"},{"count":7,"value":"6152952473"},{"count":7,"value":"615-405-2894"},{"count":7,"value":"6154784984"},{"count":7,"value":"6158042063"},{"count":7,"value":"6159004000"},{"count":7,"value":"6159997544"},{"count":6,"value":"6153301292"},{"count":6,"value":"6153475986"},{"count":6,"value":"615-356-1680"},{"count":6,"value":"6154569087"},{"count":6,"value":"6154818292"},{"count":6,"value":"6155964862"},{"count":6,"value":"6157931000"},{"count":6,"value":"8007609496"},{"count":6,"value":"9013861521"},{"count":5,"value":"5413247112"},{"count":5,"value":"6088297413"},{"count":5,"value":"6152079721"},{"count":5,"value":"6152622205"},{"count":5,"value":"6152817970"},{"count":5,"value":"615-306-4386"},{"count":5,"value":"6153541840"},{"count":5,"value":"6154057914"},{"count":5,"value":"6154773477"}],"count":825,"uniqueCount":186}},"fax":{"meta":{"pass":false,"missingStats":["count"],"error":""},"statistics":{"duration":332.60125399997924,"values":[{"count":22,"value":"615-515-1271"},{"count":18,"value":"(615)256-2427"},{"count":18,"value":"(615)356-0751"},{"count":17,"value":"(615)263-2939"},{"count":17,"value":"(615)860-1004"},{"count":15,"value":"(615)226-8903"},{"count":15,"value":"(615)292-5903"},{"count":15,"value":"(615)297-2888"},{"count":15,"value":"(615)320-9845"},{"count":15,"value":"6158552721"},{"count":14,"value":"(615)254-0107"},{"count":14,"value":"(615)493-2996"},{"count":14,"value":"(615)577-1778"},{"count":14,"value":"615-620-0602"},{"count":14,"value":"770-795-7903"},{"count":13,"value":"(615)251-0099"},{"count":13,"value":"(615)259-3557"},{"count":13,"value":"615-255-0637"},{"count":13,"value":"615-876-2403"},{"count":13,"value":"6158893264"},{"count":13,"value":"816-746-7288"},{"count":12,"value":"(615)244-9513"},{"count":12,"value":"615-742-0950"},{"count":11,"value":"(615)227-4363"},{"count":11,"value":"(615)244-9246"},{"count":11,"value":"(615)329-9737"},{"count":11,"value":"(615)361-6405"},{"count":11,"value":"(615)726-3019"},{"count":11,"value":"(615)865-6083"},{"count":11,"value":"(615)941-2328"},{"count":11,"value":"615-356-5578"},{"count":11,"value":"6153600088"},{"count":11,"value":"615-367-4806"},{"count":11,"value":"615-460-9742"},{"count":11,"value":"615-641-5080"},{"count":10,"value":"(615)331-5574"},{"count":10,"value":"(615)459-3155"},{"count":10,"value":"(615)883-4144"},{"count":10,"value":"440 220 9173"},{"count":10,"value":"615-254-3313"},{"count":10,"value":"615-256-5035"},{"count":10,"value":"615-352-1546"},{"count":10,"value":"6153710141"},{"count":10,"value":"6154691408"},{"count":10,"value":"615-885-8905"},{"count":10,"value":"931-380-1235"},{"count":9,"value":"(615)236-9001"},{"count":9,"value":"(615)244-6884"},{"count":9,"value":"(615)279-5325"},{"count":9,"value":"(615)391-2242"}],"count":2763,"uniqueCount":658}}},"date":{"date_last_pmt_":{"meta":{"pass":false,"missingStats":["min","max","count"],"error":""},"statistics":{"duration":259.7203720000107,"values":{"min":null,"max":null,"count":0}}}},"numeric":{"lon":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":271.5529089999618,"values":{"avg":-86.75911463136217,"min":-87.0415821,"max":-86.54452042,"var":0.006873863805432433,"count":7140,"sum":-619460.0784679259,"stddev":0.08290876796474805}}},"lat":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":271.5529089999618,"values":{"avg":36.15430589121555,"min":35.96928886,"max":36.38495815,"var":0.0061155792990015044,"count":7140,"sum":258141.744063279,"stddev":0.07820216940086448}}}},"objectid":{"objectid":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":117.8636810000753,"values":{"avg":3570.5,"min":1,"max":7140,"count":7140,"sum":25493370}}}}},"structuredLicense":{"type":"none"},"license":"none","supportedQueryFormats":"JSON, geoJSON, PBF","supportsAdvancedQueries":true,"tags":["codes","building","contractor","construction","renovation","plumbing","alarm","electrical","gas","mechanical","license","permit","hvac","roofing","industrial"],"thumbnail":"thumbnail/thumbnail1683048180018.png","thumbnailUrl":"thumbnail/thumbnail1683048180018.png","type":"Feature Layer","typeCategories":["Dataset"],"typeKeywords":["ArcGIS Server","Data","Feature Access","Feature Service","Service","Singlelayer","Hosted Service","View Service"],"url":"https://services2.arcgis.com/HdTo6HJqh92wn4D8/arcgis/rest/services/Registered_Professional_Contractors_view_2/FeatureServer/0","useStandardizedQueries":true,"validExtent":true,"xFrameOptions":null,"boundary":{"geometry":{"type":"polygon","rings":[[[-87.02814470056286,36.38216686967881],[-86.54451869910959,36.38216686967881],[-86.54451869910959,35.96925492527408],[-87.02814470056286,35.96925492527408],[-87.02814470056286,36.38216686967881]]],"spatialReference":{"wkid":4326}},"center":[-86.78633169983623,36.17571089747645],"provenance":"item","setBy":null},"snippet":"Registered Professional Contractors ","culture":""},"links":{"self":"https://hub.arcgis.com/api/v3/datasets/ac877684ad8b45e8b539af65ce475fe2_0","rawEs":"https://hub.arcgis.com/api/es/datasets/ac877684ad8b45e8b539af65ce475fe2_0","itemPage":"https://www.arcgis.com/home/item.html?id=ac877684ad8b45e8b539af65ce475fe2","esriRest":"https://www.arcgis.com/sharing/content/items/ac877684ad8b45e8b539af65ce475fe2?f=json"},"meta":{"highlights":{},"matchedFields":[]}},"meta":{"apiRoot":"https://hub.arcgis.com/api/v3/","resourceRoot":"https://hub.arcgis.com/api/v3/datasets","request":"https://hub.arcgis.com/api/v3/datasets/ac877684ad8b45e8b539af65ce475fe2_0"}}