Description: Imported into SDE via two python scripts (ArcGIS Pro) and two scheduled tasks to run consecutively weekly.- script #1 (11:10pm, tuesday): streets_esu_delete_gdb_import_wfs.py - delete temp gdb and import WFS from Geoplace- script #2 (02:40am, wednesday): streets_esu_delete_append_sde.py - delete features from the SDE layer and append features from temp gdbGeoplace's DataVia website.. https://datavia.geoplace.co.uk/Connection to Geoplace's DataVia API is managed using SL's york.go.uk email and password (hint: N********#1)WFS server (option 1: basic authentication method):https://www.datavia.geoplace.co.uk/api/OgcService/basic/nsg-services-basic
Color: [0, 0, 0, 255] Background Color: N/A Outline Color: N/A Vertical Alignment: bottom Horizontal Alignment: left Right to Left: false Angle: 0 XOffset: 0 YOffset: 0 Size: 12 Font Family: Arial Font Style: normal Font Weight: normal Font Decoration: none
Color: [0, 0, 0, 255] Background Color: N/A Outline Color: N/A Vertical Alignment: bottom Horizontal Alignment: center Right to Left: false Angle: 0 XOffset: 0 YOffset: 0 Size: 10 Font Family: Arial Font Style: normal Font Weight: normal Font Decoration: none
TERRIERTYPE
(
type: esriFieldTypeString, alias: Terrier type, length: 50
, Coded Values:
[Owned by CYC: Owned by CYC]
, [Leased by CYC on long term basis: Leased by CYC on long term basis]
, [Sold by CYC: Sold by CYC]
, ...8 more...
)
Color: [0, 0, 0, 255] Background Color: N/A Outline Color: N/A Vertical Alignment: bottom Horizontal Alignment: center Right to Left: false Angle: 0 XOffset: 0 YOffset: 0 Size: 14 Font Family: Arial Font Style: normal Font Weight: normal Font Decoration: none
Description: HRA properties derived from Excel table via LindaH (BIH) and BLPU UPRN joinNB: had to convert UPRN to number to remove the the zero (ie 010093240631 to 10093240631) Housing locations converted to BLPU extents using a spatial joinData created July 2024 SL
Color: [0, 0, 0, 255] Background Color: N/A Outline Color: N/A Vertical Alignment: bottom Horizontal Alignment: center Right to Left: false Angle: 0 XOffset: 0 YOffset: 0 Size: 8 Font Family: Arial Font Style: normal Font Weight: normal Font Decoration: none
Description: Points layer derived from lat/long table exported from the Alloy asset management system. Data imported into SDE via a scheduled task run at 4am weekdays.Python script: alloy_assets_import_project_append.py.
Description: Gritting path routeswere derived from two polyline shapefiles of quadbike and gator routes provided by Andy Vose on Feb 8th 2021. Data merged and added brine spray trial field to identify whether it's a quadbike or gator route.The map layer was added to the LV_TranStreetCare.mxd for inclusion on YorkView, embedded map on the CYC website and as open data.Data owner: Andy Vose. Updates will need to provided by Andy. BI Hub to update this SDE version of the data
Description: Bridge points layer derived from easting/northing table exported from the AMX system at North Yorkshire Council. Data imported into SDE via a scheduled task run at 4am Sundays.Python script: amx_assets_import_append.py.
Description: LoraWAN data exported from KMZ data, reprojected to OSGB and HTML popupinfo field attributes manually converted to separate fields. Data provided by Roy Grant / Pinacl 25th Nov 2019
Description: Gritting path routeswere derived from two polyline shapefiles of quadbike and gator routes provided by Andy Vose on Feb 8th 2021. Data merged and added brine spray trial field to identify whether it's a quadbike or gator route.The map layer was added to the LV_TranStreetCare.mxd for inclusion on YorkView, embedded map on the CYC website and as open data.Data owner: Andy Vose. Updates will need to provided by Andy. BI Hub to update this SDE version of the data