Skip to main content
fastcrw
All providersProvider terms
fastCRW Pergamon
Government

cityoffairfaxpd.data.socrata.com

cityoffairfaxpd.data.socrata.com

Socrata open data portal at cityoffairfaxpd.data.socrata.com, publishing 8 public datasets from the publishing organisation.

Showing the catalogue

1Request

Full-text query over dataset names and descriptions.

Zero-based offset into the results; step by 20 to page.

1 credit⌘ ↵
Code follows the fields above
curl "https://api.fastcrw.com/v1/data/cityoffairfaxpd-data-socrata-com/catalog-search?offset=0" \
  -H "Authorization: Bearer $FASTCRW_API_KEY"

2Response example

A sample shape. Press Run to see live data from cityoffairfaxpd.data.socrata.com.

resourceclassificationmetadatapermalinklinkownercreator
{"name":"Subdivisions","id":"iukt-5n9q","resource_name":null,"parent_fxf":[],"description":"","attribution":null,"attribution_link":null,"contact_email":null,"type":"dataset","updatedAt":"2020-07-16T13:17:41.000Z","createdAt":"2020-07-16T13:16:47.000Z","metadata_updated_at":"2020-07-16T13:17:41.000Z","data_updated_at":"2020-07-16T13:17:41.000Z","page_views":{"page_views_last_week":1,"page_views_last_month":4,"page_views_total":167,"page_views_last_week_log":1,"page_views_last_month_log":2.321928094887362,"page_views_total_log":7.392317422778761},"columns_name":["SHAPE_area","SBDVNAME","OBJECTID","GlobalID","SHAPE_len","TYPE","the_geom"],"columns_field_name":["shape_area","sbdvname","objectid","globalid","shape_len","type","the_geom"],"columns_datatype":["Number","Text","Number","Text","Number","Text","MultiPolygon"],"columns_description":["","","","","","",""],"columns_format":[{},{},{},{},{},{},{}],"download_count":33,"provenance":"official","lens_view_type":"tabular","lens_display_type":"table","locked":false,"backend":"nbe","blob_mime_type":null,"hide_from_data_json":false,"publication_date":"2020-07-16T13:17:41.000Z"}{"categories":[],"tags":[],"domain_tags":[],"domain_metadata":[]}{"domain":"cityoffairfaxpd.data.socrata.com"}https://cityoffairfaxpd.data.socrata.com/d/iukt-5n9qhttps://cityoffairfaxpd.data.socrata.com/dataset/Subdivisions/iukt-5n9q{"id":"hn99-fusv","user_type":"interactive","display_name":"Robin Kremer"}{"id":"hn99-fusv","user_type":"interactive","display_name":"Robin Kremer"}
{"name":"Patrol Areas","id":"2hqv-mgek","resource_name":null,"parent_fxf":[],"description":"","attribution":null,"attribution_link":null,"contact_email":null,"type":"dataset","updatedAt":"2024-02-08T05:06:29.000Z","createdAt":"2020-07-16T13:14:21.000Z","metadata_updated_at":"2024-02-08T05:06:29.000Z","data_updated_at":"2024-02-08T05:06:29.000Z","page_views":{"page_views_last_week":1,"page_views_last_month":6,"page_views_total":160,"page_views_last_week_log":1,"page_views_last_month_log":2.807354922057604,"page_views_total_log":7.330916878114618},"columns_name":["SHAPE_len","OBJECTID","PATROL","SHAPE_area","GlobalID","the_geom"],"columns_field_name":["shape_len","objectid","patrol","shape_area","globalid","the_geom"],"columns_datatype":["Number","Number","Number","Number","Number","MultiPolygon"],"columns_description":["","","","","",""],"columns_format":[{},{},{},{},{},{}],"download_count":34,"provenance":"official","lens_view_type":"tabular","lens_display_type":"table","locked":false,"backend":"nbe","blob_mime_type":null,"hide_from_data_json":false,"publication_date":"2021-06-11T18:47:11.000Z"}{"categories":[],"tags":[],"domain_tags":[],"domain_metadata":[]}{"domain":"cityoffairfaxpd.data.socrata.com"}https://cityoffairfaxpd.data.socrata.com/d/2hqv-mgekhttps://cityoffairfaxpd.data.socrata.com/dataset/Patrol-Areas/2hqv-mgek{"id":"hn99-fusv","user_type":"interactive","display_name":"Robin Kremer"}{"id":"hn99-fusv","user_type":"interactive","display_name":"Robin Kremer"}
{"name":"Patrol","id":"7aye-7uq3","resource_name":null,"parent_fxf":[],"description":"","attribution":null,"attribution_link":null,"contact_email":null,"type":"dataset","updatedAt":"2024-02-08T05:11:06.000Z","createdAt":"2021-06-14T15:52:08.000Z","metadata_updated_at":"2024-02-08T05:11:05.000Z","data_updated_at":"2024-02-08T05:11:06.000Z","page_views":{"page_views_last_week":1,"page_views_last_month":6,"page_views_total":145,"page_views_last_week_log":1,"page_views_last_month_log":2.807354922057604,"page_views_total_log":7.189824558880018},"columns_name":["Shape.STLength()","the_geom","ID","PATROL_ID","PATROL","Shape.STArea()","OBJECTID","PATROL_"],"columns_field_name":["shape_stlength","the_geom","id","patrol_id","patrol","shape_starea","objectid","patrol_"],"columns_datatype":["Number","MultiPolygon","Number","Number","Text","Number","Number","Number"],"columns_description":["","","","","","","",""],"columns_format":[{},{},{},{},{},{},{},{}],"download_count":28,"provenance":"official","lens_view_type":"tabular","lens_display_type":"table","locked":false,"backend":"nbe","blob_mime_type":null,"hide_from_data_json":false,"publication_date":"2021-06-14T15:57:15.000Z"}{"categories":[],"tags":[],"domain_tags":[],"domain_metadata":[]}{"domain":"cityoffairfaxpd.data.socrata.com"}https://cityoffairfaxpd.data.socrata.com/d/7aye-7uq3https://cityoffairfaxpd.data.socrata.com/dataset/Patrol/7aye-7uq3{"id":"v8mb-e6v2","user_type":"interactive","display_name":"Greg Davis"}{"id":"v8mb-e6v2","user_type":"interactive","display_name":"Greg Davis"}
{"name":"Neighborhoods","id":"4iz6-3ayq","resource_name":null,"parent_fxf":[],"description":"","attribution":null,"attribution_link":null,"contact_email":null,"type":"dataset","updatedAt":"2021-07-08T23:32:52.000Z","createdAt":"2021-07-08T23:32:07.000Z","metadata_updated_at":"2021-07-08T23:32:52.000Z","data_updated_at":"2021-07-08T23:32:52.000Z","page_views":{"page_views_last_week":1,"page_views_last_month":5,"page_views_total":128,"page_views_last_week_log":1,"page_views_last_month_log":2.584962500721156,"page_views_total_log":7.011227255423254},"columns_name":["the_geom","GlobalID","Shape.STArea()","OBJECTID_1","Shape.STLength()","SBDVNAME","OBJECTID","TYPE"],"columns_field_name":["the_geom","globalid","shape_starea","objectid_1","shape_stlength","sbdvname","objectid","type"],"columns_datatype":["MultiPolygon","Text","Number","Number","Number","Text","Number","Text"],"columns_description":["","","","","","","",""],"columns_format":[{},{},{},{},{},{},{},{}],"download_count":23,"provenance":"official","lens_view_type":"tabular","lens_display_type":"table","locked":false,"backend":"nbe","blob_mime_type":null,"hide_from_data_json":false,"publication_date":"2021-07-08T23:32:52.000Z"}{"categories":[],"tags":[],"domain_tags":[],"domain_metadata":[]}{"domain":"cityoffairfaxpd.data.socrata.com"}https://cityoffairfaxpd.data.socrata.com/d/4iz6-3ayqhttps://cityoffairfaxpd.data.socrata.com/dataset/Neighborhoods/4iz6-3ayq{"id":"v8mb-e6v2","user_type":"interactive","display_name":"Greg Davis"}{"id":"v8mb-e6v2","user_type":"interactive","display_name":"Greg Davis"}
{"name":"Buildings","id":"4dfu-m95p","resource_name":null,"parent_fxf":[],"description":"","attribution":null,"attribution_link":null,"contact_email":null,"type":"dataset","updatedAt":"2021-06-24T11:46:18.000Z","createdAt":"2021-06-24T10:54:50.000Z","metadata_updated_at":"2021-06-24T11:46:18.000Z","data_updated_at":"2021-06-24T11:46:12.000Z","page_views":{"page_views_last_week":1,"page_views_last_month":6,"page_views_total":123,"page_views_last_week_log":1,"page_views_last_month_log":2.807354922057604,"page_views_total_log":6.954196310386876},"columns_name":["OBJECTID","TYPE","Shape.STArea()","LEVELS","PREPLAN_STATUS","Patrol Areas","Beat","SOURCE","Shape.STLength()","the_geom","… 2 more items"],"columns_field_name":["objectid","type","shape_starea","levels","preplan_status",":@computed_region_nw4n_tsvk",":@computed_region_vzwk_dfvh","source","shape_stlength","the_geom","… 2 more items"],"columns_datatype":["Number","Text","Number","Text","Text","Number","Number","Text","Number","Point","… 2 more items"],"columns_description":["","","","","","This column was automatically created in order to record in what polygon from the dataset 'Patrol Areas' (nw4n-tsvk) the point in column 'the_geom' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.","This column was automatically created in order to record in what polygon from the dataset 'Beat' (vzwk-dfvh) the point in column 'the_geom' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.","","","","… 2 more items"],"columns_format":[{},{},{},{},{},{},{},{},{},{},"… 2 more items"],"download_count":31,"provenance":"official","lens_view_type":"tabular","lens_display_type":"table","locked":false,"backend":"nbe","blob_mime_type":null,"hide_from_data_json":false,"publication_date":"2021-06-24T11:46:18.000Z"}{"categories":[],"tags":[],"domain_tags":[],"domain_metadata":[]}{"domain":"cityoffairfaxpd.data.socrata.com"}https://cityoffairfaxpd.data.socrata.com/d/4dfu-m95phttps://cityoffairfaxpd.data.socrata.com/dataset/Buildings/4dfu-m95p{"id":"v8mb-e6v2","user_type":"interactive","display_name":"Greg Davis"}{"id":"v8mb-e6v2","user_type":"interactive","display_name":"Greg Davis"}
{"name":"Beats","id":"ccbu-z5dp","resource_name":null,"parent_fxf":[],"description":"","attribution":null,"attribution_link":null,"contact_email":null,"type":"dataset","updatedAt":"2022-02-21T19:59:52.000Z","createdAt":"2021-06-24T12:41:03.000Z","metadata_updated_at":"2022-02-21T19:59:51.000Z","data_updated_at":"2022-02-21T19:59:52.000Z","page_views":{"page_views_last_week":1,"page_views_last_month":4,"page_views_total":113,"page_views_last_week_log":1,"page_views_last_month_log":2.321928094887362,"page_views_total_log":6.832890014164742},"columns_name":["the_geom","ID","Shape.STLength()","PATROL","OBJECTID","SHP 1","PATROL_ID","Shape.STArea()","PATROL_"],"columns_field_name":["the_geom","id","shape_stlength","patrol","objectid","shp_1","patrol_id","shape_starea","patrol_"],"columns_datatype":["MultiPolygon","Number","Number","Number","Number","Number","Number","Number","Number"],"columns_description":["","","","","","","","",""],"columns_format":[{},{},{},{},{},{},{},{},{}],"download_count":29,"provenance":"official","lens_view_type":"tabular","lens_display_type":"table","locked":false,"backend":"nbe","blob_mime_type":null,"hide_from_data_json":false,"publication_date":"2021-06-24T12:45:57.000Z"}{"categories":[],"tags":[],"domain_tags":[],"domain_metadata":[]}{"domain":"cityoffairfaxpd.data.socrata.com"}https://cityoffairfaxpd.data.socrata.com/d/ccbu-z5dphttps://cityoffairfaxpd.data.socrata.com/dataset/Beats/ccbu-z5dp{"id":"v8mb-e6v2","user_type":"interactive","display_name":"Greg Davis"}{"id":"v8mb-e6v2","user_type":"interactive","display_name":"Greg Davis"}
{"name":"Icon","id":"dj2k-zu7g","resource_name":null,"parent_fxf":[],"description":"","attribution":null,"attribution_link":null,"contact_email":null,"type":"file","updatedAt":"2021-07-06T18:22:23.000Z","createdAt":"2021-07-06T18:21:32.000Z","metadata_updated_at":"2021-07-06T18:22:23.000Z","data_updated_at":"2021-07-06T18:21:32.000Z","page_views":{"page_views_last_week":0,"page_views_last_month":3,"page_views_total":95,"page_views_last_week_log":0,"page_views_last_month_log":2,"page_views_total_log":6.584962500721156},"columns_name":[],"columns_field_name":[],"columns_datatype":[],"columns_description":[],"columns_format":[],"download_count":124801,"provenance":"official","lens_view_type":"blobby","lens_display_type":"blob","locked":false,"backend":"not_a_dataset","blob_mime_type":"image/png","hide_from_data_json":false,"publication_date":"2021-07-06T18:22:23.000Z"}{"categories":[],"tags":[],"domain_tags":[],"domain_metadata":[]}{"domain":"cityoffairfaxpd.data.socrata.com"}https://cityoffairfaxpd.data.socrata.com/d/dj2k-zu7ghttps://cityoffairfaxpd.data.socrata.com/dataset/Icon/dj2k-zu7g{"id":"v8mb-e6v2","user_type":"interactive","display_name":"Greg Davis"}{"id":"v8mb-e6v2","user_type":"interactive","display_name":"Greg Davis"}
{"name":"test","id":"cg82-k45i","resource_name":null,"parent_fxf":["iukt-5n9q"],"description":"","attribution":null,"attribution_link":null,"contact_email":null,"type":"filter","updatedAt":"2024-07-20T13:47:22.000Z","createdAt":"2024-07-20T13:47:01.000Z","metadata_updated_at":"2024-07-20T13:47:22.000Z","data_updated_at":"2020-07-16T13:17:41.000Z","page_views":{"page_views_last_week":1,"page_views_last_month":4,"page_views_total":34,"page_views_last_week_log":1,"page_views_last_month_log":2.321928094887362,"page_views_total_log":5.129283016944966},"columns_name":["OBJECTID","TYPE","GlobalID","SHAPE_area","SHAPE_len","the_geom","SBDVNAME"],"columns_field_name":["objectid","type","globalid","shape_area","shape_len","the_geom","sbdvname"],"columns_datatype":["Number","Text","Text","Number","Number","MultiPolygon","Text"],"columns_description":["","","","","","",""],"columns_format":[{},{},{},{},{},{},{}],"download_count":14,"provenance":"community","lens_view_type":"tabular","lens_display_type":"table","locked":false,"backend":"nbe","blob_mime_type":null,"hide_from_data_json":false,"publication_date":"2024-07-20T13:47:21.000Z"}{"categories":[],"tags":[],"domain_tags":[],"domain_metadata":[]}{"domain":"cityoffairfaxpd.data.socrata.com"}https://cityoffairfaxpd.data.socrata.com/d/cg82-k45ihttps://cityoffairfaxpd.data.socrata.com/dataset/test/cg82-k45i{"id":"6xuc-er95","user_type":"interactive","display_name":"ricochet"}{"id":"6xuc-er95","user_type":"interactive","display_name":"ricochet"}

Attribution: Source: cityoffairfaxpd.data.socrata.com. Dataset attribution as stated by each publishing agency.

Licence: No licence is declared in the dataset metadata this portal exposes through its catalogue API. No reuse grant is made here: commercial use and redistribution are recorded as false and no rights are claimed over the upstream data.

Ask with this source

A prompt for your agent that names this source and how to call it through the crw MCP.

  • Catalogue search

    Use cityoffairfaxpd.data.socrata.com (cityoffairfaxpd-data-socrata-com) from fastCRW Pergamon, capability "Catalogue search" (catalog-search). You want to find a dataset on this portal by keyword and do not know its four-by-four id. Example options: q=taxi, offset=0, order=page_views_total DESC. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "cityoffairfaxpd-data-socrata-com" and capability "catalog-search". Tell me the credits used and cite the licence from the response. If the crw MCP tools are missing, install them with: npx -y crw-mcp install --api-key <your fastCRW API key>

  • Dataset metadata

    Use cityoffairfaxpd.data.socrata.com (cityoffairfaxpd-data-socrata-com) from fastCRW Pergamon, capability "Dataset metadata" (dataset). You already hold a dataset id and need its columns, licence or description before querying rows. Example options: id=4iz6-3ayq. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "cityoffairfaxpd-data-socrata-com" and capability "dataset". Tell me the credits used and cite the licence from the response. If the crw MCP tools are missing, install them with: npx -y crw-mcp install --api-key <your fastCRW API key>

  • Dataset inventory

    Use cityoffairfaxpd.data.socrata.com (cityoffairfaxpd-data-socrata-com) from fastCRW Pergamon, capability "Dataset inventory" (datasets). You need to enumerate what this portal publishes, or page through its newest datasets. Example options: offset=0, order=createdAt, category=Transportation. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "cityoffairfaxpd-data-socrata-com" and capability "datasets". Tell me the credits used and cite the licence from the response. If the crw MCP tools are missing, install them with: npx -y crw-mcp install --api-key <your fastCRW API key>

  • Row count

    Use cityoffairfaxpd.data.socrata.com (cityoffairfaxpd-data-socrata-com) from fastCRW Pergamon, capability "Row count" (row-count). You need to know how large a dataset is before downloading it, or want a cheap liveness check. Example options: id=4iz6-3ayq. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "cityoffairfaxpd-data-socrata-com" and capability "row-count". Tell me the credits used and cite the licence from the response. If the crw MCP tools are missing, install them with: npx -y crw-mcp install --api-key <your fastCRW API key>