3 ms·
My local city government also recently published a detailed interactive online GIS map of the city, including all lot boundaries, buried utilities, etc. It's gr
by nerdponx 3y ago
My local city government also recently published a detailed interactive online GIS map of the city, including all lot boundaries, buried utilities, etc. It's great to feel like the public can easily access what is meant to be public record, rather than relying on for-profit third parties to make it available to us.
- apwheele 3y agoI really like the ESRI API's (much faster than Socrata). This is a crazy url, but they do allow for different SQL operations (including spatial operations) right in the API. Here is top 10 crime street segments in Raleigh for example: https://services.arcgis.com/v400IkDOw1ad7Yad/ArcGIS/rest/services/Police_Incidents/FeatureServer/0/query?where=reported_block_address+NOT+IN+%28%27+%27%29+AND+Crime_Category+NOT+IN+%28%27MISCELLANEOUS%27%2C%27ALL+OTHER+OFFENSES%27%29&orderByFields=CrimeCount+DESC&groupByFieldsForStatistics=reported_block_address&outStatistics=%5B%7BonStatisticField%3A+%22case_number%22%2C%0D%0A++outStatisticFieldName%3A+%22CrimeCount%22%2C%0D%0A++statisticType%3A+%22count%22%7D%2C%0D%0A+%7BonStatisticField%3A+%22latitude%22%2C%0D%0A++outStatisticFieldName%3A+%22latitude%22%2C%0D%0A++statisticType%3A+%22avg%22%7D%2C%0D%0A+%7BonStatisticField%3A+%22longitude%22%2C%0D%0A++outStatisticFieldName%3A+%22longitude%22%2C%0D%0A++statisticType%3A+%22avg%22%7D%0D%0A%5D&resultRecordCount=10&f=json https://services.arcgis.com/v400IkDOw1ad7Yad/ArcGIS/rest/ser... If you go to https://services.arcgis.com/v400IkDOw1ad7Yad/ArcGIS/rest/services/Police_Incidents/FeatureServer/0/query https://services.arcgis.com/v400IkDOw1ad7Yad/ArcGIS/rest/ser... you can putz around in the query engine to figure out the API strings (easier than reading the ESRI docs anyway!)