Paul Dziemiela pauldzy
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import os,sys; | |
| import requests,csv,codecs; | |
| localdir = os.path.dirname(os.path.abspath(__file__)); | |
| target = localdir + os.sep + 'wqp_harvest_20230925.csv'; | |
| if os.path.exists(target): | |
| os.remove(target); | |
| r = requests.get('https://www.waterqualitydata.us/Codes/countrycode?mimeType=json'); |
pauldzy
/ WebgateDownload
Created
June 25, 2020 00:42
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import requests; | |
| url = "https://echo.epa.gov/files/echodownloads/npdes_biosolids_downloads.zip"; | |
| target = r"npdes_biosolids_downloads.zip"; | |
| print("\nQuerying " + str(url) + "...\n"); | |
| step1 = requests.get( | |
| url | |
| ,allow_redirects=False | |
| ); |
pauldzy
/ notify_ddl_postgrest.sql
Created
August 14, 2019 14:45
Alternative notify_ddl_postgrest event trigger
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE OR REPLACE FUNCTION public.notify_ddl_postgrest() | |
| RETURNS event_trigger | |
| AS $$ | |
| DECLARE | |
| obj RECORD; | |
| BEGIN | |
| FOR obj IN SELECT * FROM pg_event_trigger_ddl_commands() | |
| LOOP | |
| IF obj.object_type IN ('type','function','procedure') | |
| THEN |
pauldzy
/ arcgis_pro_deploy_map_service.py
Created
August 3, 2019 14:41
Python 3 arcpy script to automate the deployment of ArcGIS Pro defined map services to standalone ArcGIS Servers
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import os,sys,arcpy; | |
| import xml.dom.minidom as DOM; | |
| ############################################################################### | |
| # Alter the following constants as required | |
| ############################################################################### | |
| project_name = "HydrologicUnits"; | |
| ags_service = "HydrologicUnits"; | |
| ags_folder = "Support"; |
pauldzy
/ apex_geojson2sdo.prc
Last active
June 24, 2019 23:36
APEX_JSON GeoJSON to SDO_GEOMETRY Utility
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE OR REPLACE PROCEDURE apex_geojson2sdo( | |
| pInput IN CLOB | |
| ,pOutput OUT MDSYS.SDO_GEOMETRY | |
| ,pReturnCode OUT INTEGER | |
| ,pStatusMessage OUT VARCHAR2 | |
| ) | |
| AUTHID CURRENT_USER | |
| AS | |
| l_values APEX_JSON.T_VALUES; | |
| str_test VARCHAR2(4000 Char); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "objectIdFieldName" : "OBJECTID", | |
| "globalIdFieldName" : "GlobalID", | |
| "geometryType" : "esriGeometryPoint", | |
| "spatialReference" : { | |
| "wkid" : 102100, | |
| "latestWkid" : 3857 | |
| }, | |
| "fields" : [ | |
| { |
pauldzy
/ Esri_JSON_Example1
Created
June 7, 2018 15:56
Source: https://services2.arcgis.com/3yCQWqEMIRwEdrth/arcgis/rest/services/SOR/FeatureServer/0/query?where=1%3D1&objectIds=&time=&geometry=&geometryType=esriGeometryEnvelope&inSR=&spatialRel=esriSpatialRelIntersects&resultType=none&distance=0.0&units=esriSRUnit_Meter&returnGeodetic=false&outFields=*&returnGeometry=true&multipatchOption=xyFootpri…
This file has been truncated, but you can view the full file.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "objectIdFieldName" : "ObjectID", | |
| "globalIdFieldName" : "", | |
| "geometryType" : "esriGeometryPoint", | |
| "spatialReference" : { | |
| "wkid" : 4326, | |
| "latestWkid" : 4326 | |
| }, | |
| "fields" : [ | |
| { |
pauldzy
/ extract_feature_service.py
Last active
August 28, 2019 17:38
ArcPy script to extract feature classes from feature and map services
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import arcpy,os,http.client,json | |
| ############################################ | |
| # Edit these items per the service to scrape | |
| host = "gispub.epa.gov"; | |
| service_path = "/arcgis/rest/services/OAR/USEPA_NEI_2005/MapServer/0" | |
| output_fgdb = r"c:\esri_dump\fg.gdb"; | |
| output_fc = "USEPA_NEI_2005" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| DECLARE | |
| num_handle NUMBER; | |
| str_filename VARCHAR2(2000 Char); | |
| clb_tablelist CLOB; | |
| str_directory VARCHAR2(30 Char) := 'LOADING_DOCK'; | |
| BEGIN | |
| str_filename := 'waters_cip_OWPUB_20170823'; | |
| --Note you must single quote the table items |
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.