{"elements":[{"textAlign":"left","mapImageId":null,"description":null,"onClick":null,"author":"6f6779fe-4a5e-4266-9485-d37d6c616363","position":[37.63797477179696,-134.3306090882997],"text":"Wired published an article analyzing a leaked database of ShotSpotter microphone locations allegedgly created late last year. Wired redacted some of these in their map due to privacy concerns.\n\nStory: https://www.wired.com/story/shotspotter-secret-sensor-locations-leak/\n\nThey published the map via Flourish Studio which embeds all of the data in json format into the source code. I extracted the json, converted it into a csv, and uploaded here.","showArea":null,"size":null,"clipSource":null,"opacity":null,"attributes":[],"rotation":0,"widthScale":1,"radiusDisplayAngle":90,"renderHoles":null,"label":null,"coordinates":[[[26.1759232,-143.2919051],[26.1759232,-125.369313],[47.5719298,-125.369313],[47.5719298,-143.2919051],[26.1759232,-143.2919051]]],"frame":null,"mapLinkId":null,"radius":null,"locked":false,"strokeStyle":null,"showLinkPreview":null,"showRadius":null,"textStyle":"light","routeMode":null,"strokeWidth":null,"showEndcaps":null,"isCollapsed":null,"ordering":1708664983801475,"fillOpacity":null,"color":"#C93535","showLength":null,"hasLongDescription":null,"symbol":null,"id":"86c9050d-f9fb-4ade-b210-73a68a9ef72f","hideFromLegend":null,"radiusDisplayUnit":null,"zoom":4.531,"parentId":null,"type":"Note","scale":1.1785966084253716,"isTextHidden":null,"icon":null,"isHidden":null,"createdAtUnixTimeMs":1708665004000,"strokeOpacity":null}],"sharing":{"publicAccess":"view_only"},"commonAnalyticsProperties":{"feature_flags":["ff_all_column_index","ff_create_layers","ff_create_layers_single_select","ff_growth_enterprise_trials","ff_photos_in_comments","ff_server_side_filtering"],"workspace_id":"e9f8875b-ae3f-4eaa-9c51-815ceb436657","workspace_name":"Ian Servin's Team","workspace_plan":"personal","workspace_age_days":787,"native_app_device_model":null,"native_app_os_version":null,"native_app_platform":null,"native_app_version":null,"platform_source":"web"},"maxImageFileSizeBytes":20000000,"felt_version":"43","onboardingNeeded":[],"validMapImageMimeTypes":["application/pdf","application/postscript","application/x-photoshop","image/apng","image/avif","image/bmp","image/heic","image/jp2","image/jpeg","image/jpm","image/jpx","image/jxr","image/pict","image/pjpeg","image/png","image/svg+xml","image/vnd.adobe.photoshop","image/vnd.microsoft.icon","image/webp","image/x-icns","image/x-icon","image/x-pict"],"ghostPresences":[],"accessControl2":{"view":{"canDownloadLayers":false,"canDuplicate":false},"edit":{"canChangePublicSharingSettings":false,"canEditMapContents":false,"canEditMapElements":false,"canEditMapLayerFeatures":false,"canInviteUsers":false,"canMove":false},"comments":{"canAttachPhotosToComments":false,"canCreateThread":false,"canDeleteAnyComment":false,"canDeleteOwnComment":false,"canEditOwnComment":false,"canExportComments":false,"canMoveAnyThread":false,"canMoveOwnThread":false,"canReplyToThread":false,"canResolveAnyComment":false,"canResolveOwnComment":false,"canTrackReadStatus":false,"canViewAllThreads":false},"teams":{"canAddSources":false,"canDeletePublishedLayer":false,"canPublishLayer":false},"kartaTeamMemberIds":[]},"teams":[],"currentTeamBannerAcknowledgement":{"plan":null,"plan_name":null,"acknowledged":true},"isAdmin":false,"folderTree":[],"mapImages":[],"layerGroups":[{"id":"41618b24-aa93-4f52-ade9-f877822618f8","name":"Microphone Locations","visible":true,"description":"","created_at":"2024-02-23T05:02:18","layers":[{"hash_url":"https://us1.data-pipeline.felt.com/hash/{hash}","column_selections":[{"type":"lng","column":"lon"},{"type":"lat","column":"lat"}],"raster_details":null,"normalized":{"filename":"locations.csv","feature_id_field":null,"filetype":"GeoPackage","layername":"locations"},"scheduled_refresh_frequency":null,"layer_name":"parsed","legendVisibility":"show","semantic_columns":[],"subtitle":"","curated_layer":false,"remote_data_url":null,"created_at":"2024-02-23T05:02:58","has_download_url":true,"stats_url":"https://us1.data-pipeline.felt.com/b5e4156f-313c-4dbd-a583-72d400004453/stats/stats.json","visible":true,"parsed_size_bytes":8867840,"processing_time_seconds":24,"runCause":"reprocess","modified_at":"2025-08-26T19:40:26","h3_geomatched_level":null,"raster_colors":null,"errorType":null,"min_zoom":0,"geometry_type":"Point","debug_layer_compaction":null,"bounding_box":{"coordinates":[[[-122.445328,-85.051129],[122.391761,-85.051129],[122.391761,45.0511679],[-122.445328,45.0511679],[-122.445328,-85.051129]]],"crs":{"properties":{"name":"EPSG:4326"},"type":"name"},"type":"Polygon"},"last_processed_at":"2024-12-10T21:21:44","source_has_custom_query":false,"h3_levels":[11,22,52,96,143,262,564,1647,6106,17928,20123,20184,20212,20242,20242,20242],"centroids_layer_name":null,"is_spreadsheet":true,"feature_url":"https://us1.data-pipeline.felt.com/onefeature/b5e4156f-313c-4dbd-a583-72d400004453/{feature}.geojson{?skip_geometry,zoom_level}","created_by":"Ian Servin","status":"completed","tile_url":"https://us1.data-pipeline.felt.com/vectortile/b5e4156f-313c-4dbd-a583-72d400004453/{z}/{x}/{y}.pbf{?attributes,layer,query}","external_refresh_frequency_ms":null,"data_last_updated_by_user_at":"2024-02-23T05:02:58","style":{"config":{"labelAttribute":["lat"]},"label":{"color":"auto","fontSize":13,"fontStyle":"Normal","fontWeight":500,"haloColor":"auto","haloWidth":1,"justify":"auto","letterSpacing":0,"lineHeight":1.2,"maxLineChars":10,"maxZoom":23,"minZoom":23,"offset":[8,8],"padding":2,"placement":"auto","textTransform":"none","visible":false},"legend":{},"paint":{"color":"#efe6a8","intensity":0.5,"opacity":0.9,"size":10,"strokeColor":"auto","strokeWidth":1},"type":"simple","version":"2.3.1"},"progress":100,"next_processing_state":null,"stats":[],"z_order":0,"source_id":null,"max_zoom":18,"geocoder_metadata":null,"geomatch_metadata":null,"errorMessage":null,"initial_fill_color":null,"id":"5c9b0a83-69c9-4917-9391-ee85f92a368b","initial_stroke_color":null,"pipeline_dataset_id":"b5e4156f-313c-4dbd-a583-72d400004453","name":"Microphone Locations","hideFromLegend":null,"legend_items":[{"id":"5c9b0a83-69c9-4917-9391-ee85f92a368b-0","visible":true}],"raster_preview_url":null,"index_json_url":"https://us1.data-pipeline.felt.com/upload/930f9c40-ea79-53cd-8a57-95b10000554c.json","ready_for_immediate_export":true,"sql_query_threads":[],"edit_version":null,"source_dataset_id":null,"html_popup_source":null,"scheduled_refresh_status":null,"pipeline_version":"0.35.11005","legendDisplay":"default","html_popup_threads":[],"tile_max_zoom":8,"excerpt_url":"https://us1.data-pipeline.felt.com/b5e4156f-313c-4dbd-a583-72d400004453/excerpt/excerpt.json","table":{"name":"parsed","columns":[{"autocomplete_url":"https://us1.data-pipeline.felt.com/autocomplete/b5e4156f-313c-4dbd-a583-72d400004453/0/1.json{?query}","count":22471,"count_distinct":20179,"max":45.0511683333,"median":39.1514883333,"min":-9999.0,"name":"lat","stats_url":"https://us1.data-pipeline.felt.com/stats/b5e4156f-313c-4dbd-a583-72d400004453/0.json{?query}","type":"REAL","values":{"-9999.0":8,"41.7254083333":5,"41.7508233333":5,"41.753722":5,"41.756595":5,"41.7578033333":5,"41.7584933333":5,"41.7601883333":7,"41.789845":5,"41.7908733333":5,"41.7917783333":5}},{"autocomplete_url":"https://us1.data-pipeline.felt.com/autocomplete/b5e4156f-313c-4dbd-a583-72d400004453/1/1.json{?query}","count":22471,"count_distinct":20213,"max":122.391761,"median":-83.526705,"min":-9999.0,"name":"lon","stats_url":"https://us1.data-pipeline.felt.com/stats/b5e4156f-313c-4dbd-a583-72d400004453/1.json{?query}","type":"REAL","values":{"-87.6220466667":6,"-87.62454":5,"-87.6248466667":5,"-87.6258616667":5,"-87.6262633333":5,"-87.626925":5,"-87.6301916667":5,"-87.6323083333":5,"-87.63419":5,"-87.634475":6,"-9999.0":8}},{"autocomplete_url":"https://us1.data-pipeline.felt.com/autocomplete/b5e4156f-313c-4dbd-a583-72d400004453/2/1.json{?query}","count":22471,"count_distinct":304,"name":"metadata-1","stats_url":"https://us1.data-pipeline.felt.com/stats/b5e4156f-313c-4dbd-a583-72d400004453/2.json{?query}","type":"TEXT","values":{"ChicagoILDistrict25":298,"ChicagoILDistrict3":256,"ChicagoILDistrict5":248,"ChicagoILDistrict7":196,"ChicagoILDistrict830":203,"ChicagoILDistrict9":316,"DanRyanExpresswayIL":222,"DetroitMIPrecinct9":202,"OaklandCA":253,"QueensNYJamaica":200,"USVIStCroix":276}},{"autocomplete_url":"https://us1.data-pipeline.felt.com/autocomplete/b5e4156f-313c-4dbd-a583-72d400004453/3/1.json{?query}","count":22471,"count_distinct":85,"name":"metadata-2","stats_url":"https://us1.data-pipeline.felt.com/stats/b5e4156f-313c-4dbd-a583-72d400004453/3.json{?query}","type":"TEXT","values":{"":813,"Albuquerque, NM":721,"Chicago-Naperville-Elgin, IL-IN":3568,"Denver-Aurora-Centennial, CO":445,"Las Vegas-Henderson-North Las Vegas, NV":426,"Miami-Fort Lauderdale-West Palm Beach, FL":1724,"New York-Newark-Jersey City, NY-NJ":2419,"Pittsburgh, PA":547,"San Francisco-Oakland-Fremont, CA":856,"San Juan-Bayam��n-Caguas, PR":783,"Washington-Arlington-Alexandria, DC-VA-MD-WV":521}}],"content_url":"https://us1.data-pipeline.felt.com/table/b5e4156f-313c-4dbd-a583-72d400004453/{page}.json{?query}","row_count":22471},"stac_url":null}],"created_by":"Ian Servin","modified_at":"2024-03-05T23:50:22","user_id":"6f6779fe-4a5e-4266-9485-d37d6c616363","index_json_url":"https://us1.data-pipeline.felt.com/upload/930f9c40-ea79-53cd-8a57-95b10000554c.json","max_zoom":18,"subtitle":"","z_order":3,"isCollapsed":false,"hideFromLegend":null,"errorMessage":null,"thumbnailUrl":null,"visibilityInteraction":"checkbox","progress_percent":100,"errorType":null,"legendVisibility":"show","created_at_unix_time_ms":1708664538000,"duplicatedFromId":null,"published_to_project_ids":null,"renderAsLayer":true}],"constraints":{"bounds":null,"maxZoom":null,"minZoom":null},"selectedDefaultBackgroundMode":"dark","allowedFeatures":{"iframePopups":false,"liveLayers":false,"basicExports":false,"h3":false,"streamVectorTiles":false,"mapActions":false,"embedActionCustomization":false,"viewerExportData":false,"transformations":false,"sameDomainJoin":false,"usageDashboard":false,"filters":false,"advancedExports":false,"sdk":false,"basicPipelineExports":false,"updateEnterpriseSettings":false,"enterprisePipelineExports":false,"sources":false,"commentsAttachedData":false,"widgets":false,"workspaceLibrary":false,"extensions":false,"stacSource":false,"createLayerFromColumns":false,"streamCogs":false,"customIcons":false,"embedTokens":false,"editableLayers":false,"commentsAttachedMedia":false,"bucketSources":false,"embeds":false,"uploadLayer":false,"enterpriseExports":false},"featureFlags":{"ff_extensions_use_next_sdk":false,"felt_is_up":true,"ff_contributor_permission":false,"ff_copy_paste_styles":false,"ff_create_layers":true,"ff_create_layers_single_select":true,"ff_growth_enterprise_trials":true,"ff_isr":false,"ff_mobile_alpha":false,"ff_more_components":false,"ff_photos_in_comments":true,"ff_server_side_filtering":true,"ff_use_our_tiles":false,"ff_wherobots":false},"isTrainingKarta":false,"canCreateMapsSomewhere":false,"curated_layers_enabled":true,"mapTeamId":null,"maxTileURLLength":2000,"workspaceBilling":{"plan_limits":{"processing_bytes":0,"api_calls":0,"map_views":5000,"storage_bytes":0,"contributor_limit":0,"editor_limit":3,"member_limit":25},"limits_enforced":true,"next_monthly_cycle_start":1767225600000,"plan_data_usage":{"data_processing":0,"data_storage":281226032},"featureGroups":{"enterprise_geocoding":false,"dashboards":false,"cloud_sources":false,"app_development":false,"raster_infrastructure":false},"inGracePeriod":false},"selectedBackgroundId":null,"kartaTeamId":"e9f8875b-ae3f-4eaa-9c51-815ceb436657","kartaChannel":"anonymous_map:eef3fdd1-5214-4d23-b405-21bfd0187190","showBasemapLabels":true,"mapUrls":{"export":"https://felt.com/map/export/eef3fdd1-5214-4d23-b405-21bfd0187190","embed":"https://felt.com/embed/map/ShotSpotter-Microphone-Locations-from-Wired-Article-7vP9A0VIUTSO0BSG9C0BhxkA","login":"/login/map/eef3fdd1-5214-4d23-b405-21bfd0187190","appHomeForKarta":"/maps/contains/eef3fdd1-5214-4d23-b405-21bfd0187190","dataTroubleshooting":"https://help.felt.com/upload-anything/troubleshooting","exportComments":"https://felt.com/map/export/eef3fdd1-5214-4d23-b405-21bfd0187190/comments","signup":"/signup/map/eef3fdd1-5214-4d23-b405-21bfd0187190","supportedFormats":"https://help.felt.com/upload-anything/files"},"mapLinks":[],"satelliteMode":false,"mapColorPalette":[],"defaultCoordinates":{"lat":37.807,"lng":-122.271},"layerProcessingEmailSubscriptions":[],"defaultControlsMode":null,"updatedAtUnixMs":1736480065000,"mapbox_api_token":"pk.eyJ1IjoiZmVsdG1hcHMiLCJhIjoiY20wZndoenl1MTFrYzJxb2czemdpNGFvZCJ9.y7NzVOMNQNTC487xOYTk7Q","teamAdminEmails":[],"amplitudeAnalyticsId":"d01926b917624c9f002b79f6016c7213","socketTokenTTLSeconds":1209600,"mapTitle":"ShotSpotter Microphone Locations from Wired Article","canPurchasePlan":true,"scripts":[],"isVirtualKarta":false,"mapId":"eef3fdd1-5214-4d23-b405-21bfd0187190","sources":[],"urls":{"api":"/api","settings":"/users/settings","dashboard":"/maps","marketing":"/","newMap":"/map/new","newWorkspace":"/join","placeholderImage":"/images/placeholder-39c4259c68cef774b08a1a06e6626c95.png?vsn=d","canonicalPath":"/map/ShotSpotter-Microphone-Locations-from-Wired-Article-7vP9A0VIUTSO0BSG9C0BhxkA","catchup":"/map/ShotSpotter-Microphone-Locations-from-Wired-Article-7vP9A0VIUTSO0BSG9C0BhxkA/catchup","spritesBaseUrl":"https://app-assets.felt.com/sprites","spritesManifest":{"/sprites/msdf.json":"/sprites/msdf-0ed695ece9e09531d79ea4daa8255599.json","/sprites/msdf.png":"/sprites/msdf-235245f7cf195ff0eb39cf7a7b8fa6e9.png","/sprites/msdf@2x.json":"/sprites/msdf@2x-1e78f109cb6438c7e87da1f75344a7b7.json","/sprites/msdf@2x.png":"/sprites/msdf@2x-73817a584887afef4c1e0188642592ab.png","/sprites/sprite.json":"/sprites/sprite-964569eef729aa4773a354b47cee5d86.json","/sprites/sprite.png":"/sprites/sprite-819511448f6f2499deff86603ff78215.png","/sprites/sprite@2x.json":"/sprites/sprite@2x-24e211e07ce576bf48740474ed7d6547.json","/sprites/sprite@2x.png":"/sprites/sprite@2x-87cb20c28d14435142f4e32339e093dd.png"},"workspaceUsage":null},"widgets":[],"individualPermissions":[],"isAdminView":false,"partnerBranding":null,"editableByCurrentSession":false,"authors":{"6f6779fe-4a5e-4266-9485-d37d6c616363":{"name":"Ian Servin"}},"resyncTimeoutMs":5250,"shareUrl":"https://felt.com/map/ShotSpotter-Microphone-Locations-from-Wired-Article-7vP9A0VIUTSO0BSG9C0BhxkA","pipeline":{"syncUploadMaxBytes":15360},"flashMessages":[],"mapProject":null,"checkerboardTiles":true,"layerAttrConstraints":{"maxNameLength":300},"customIcons":[],"validGeoDataExtensions":[".json",".geojson"],"actions":[],"folderId":null,"settings":{"path":"/map/ShotSpotter-Microphone-Locations-from-Wired-Article-7vP9A0VIUTSO0BSG9C0BhxkA","url":"https://felt.com/map/ShotSpotter-Microphone-Locations-from-Wired-Article-7vP9A0VIUTSO0BSG9C0BhxkA","mapDescription":null,"mapTitle":"ShotSpotter Microphone Locations from Wired Article","viewers":{"allowExport":false,"dataTable":true,"defaultTableLayerId":null,"duplicateMap":true,"seeMapPresence":true}},"createMapParams":null,"customViewport":{"longitude":-101.88704310727246,"latitude":37.59755874629287,"zoom":4.298},"loadedAt":1767215493,"current_user":{},"mapBackgrounds":[],"referer":null,"mapDescription":null,"isOwner":false,"embedConfig":null,"comments":{"threads":[],"users":{}},"defaultZoom":14.0,"mapFolderId":null,"buildSha":"c416eec95606283761cf3ebfe521aea8f3f014c7"}