ArcGIS REST Services Directory Login
Home > services > Aktivov_2023 (MapServer) API Reference
JSON | SOAP

Aktivov_2023 (MapServer)

View In:   ArcGIS JavaScript   ArcGIS Online Map Viewer   ArcGIS Earth   ArcGIS Pro

Service Description: <div>Feb 2025 update - SQL agent jobs and views update</div><div><div><ul><li>Adjusting pressure zone joins to remove the chance of duplicate features being generated </li><li>Changing lat/long function call from LGDM to Aktivov DB</li></ul></div></div><div>Mar 2024 update - instead of SQL views feeding the larger datasets, SQL agent jobs instead take those same view definitions and create standalone feature classes resulting in vastly improved performance and stability. </div><div><br /></div><div>Park Maintenance Areas added in 8/14/23</div><div><br /></div><div>This Map service forms the foundation for a systematic overhaul in how we process data and import it into aktivov.<br /></div><div>It is broken into <b>5</b> group layers with relevant sublayers beneath</div><div><ul><li><b>Layers:</b><span style='color:rgb(0, 0, 0); font-family:Verdana, Arial, Helvetica, sans-serif; font-size:14.4px;'></span><ul><li> <a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/67'>Aktivov Street Layers</a> (67) <ul><li> <a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/74'>Street Lights</a> (74) </li><li> <a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/72'>Signal Poles</a> (72) </li><li> <a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/71'>Signal Cabinet</a> (71) </li><li> <a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/70'>Service Cabinet</a> (70) </li><li> <a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/77'>Signs</a> (77) </li><li> <a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/91'>Sign Beacons</a> (91) </li><li> <a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/69'>Posts</a> (69) </li><li> <a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/68'>Junction Box</a> (68) </li><li> <a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/90'>Sidewalks</a> (90) </li><li> <a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/73'>Streets</a> (73) </li></ul> </li><li><a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/78'>Aktivov Water Layers</a> (78)<ul><li><a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/45'>Water Wells</a> (45)</li><li><a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/43'>Water Valves</a> (43)</li><li><a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/41'>Water Treatment Plant</a> (41)</li><li><a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/39'>Water Storage Facilities</a> (39)</li><li><a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/37'>Water Sampling Sites</a> (37)</li><li><a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/34'>Water PRVs</a> (34)</li><li><a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/32'>Water Meters</a> (32)</li><li><a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/28'>Water Hydrants</a> (28)</li><li><a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/26'>Water Control Valves</a> (26)</li><li><a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/24'>Water Blowoffs</a> (24)</li><li><a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/22'>Water Airvacs</a> (22)</li><li><a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/30'>Water Mains</a> (30)</li><li><a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/35'>Water Pump Station</a> (35)</li><li><a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/29'>Water Maintenance Watershed</a> (29)</li></ul></li><li><a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/79'>Aktivov Sewer Layers</a> (79)<ul><li><a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/1'>Sewer WWTP</a> (1)</li><li><a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/2'>Sewer Manholes</a> (2)</li><li><a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/3'>Sewer Lift Stations</a> (3)</li><li><a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/4'>Sewer Cleanouts</a> (4)</li><li><a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/5'>Sewer Gravity Mains</a> (5)</li><li><a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/6'>Sewer Force Mains</a> (6)</li><li><a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/7'>Sewer Maintenance Grid</a> (7)</li><li><a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/81'>Sewer Quarterly Jetting</a> (81)</li></ul></li><li><a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/80'>Aktivov Stormwater Layers</a> (80)<ul><li><a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/19'>Stormwater Lines</a> (19)</li><li><a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/17'>Stormwater Culverts</a> (17)</li><li><a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/16'>Stormwater Catchbasins</a> (16)</li><li><a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/15'>Stormwater Private Catchbasins</a> (15)</li><li><a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/20'>Stormwater Facilities</a> (20)</li><li><a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/18'>Stormwater Maintenance Grid</a> (18)</li></ul></li><li><a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/8'>Parks and Facilities Layers</a> (8)<ul><li><a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/88'>Park Maintenance Areas</a> (88)</li><li><a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/82'>City Buildings</a> (82)</li><li><a href='https://gisservice.marysvillewa.gov/server/rest/services/Aktivov_2023/MapServer/89'>Park Opening</a> (89)</li></ul></li></ul></li></ul></div><div>Previously data was copied and transformed across multiple locations and databases leaving it susceptible to locks or general python issues. </div><div>This service aims to rectify that by pointing all layers and sub layers at SQL views. These views are immutable and provide the necessary data transformations in place all while referencing the source data. </div><div><br /></div><div><b>Assumptions</b>: All data requires LAT/LONG data in decimal degrees as well as an Asset_ID field (AKTID first, then MVID if former is null)</div><div><br /></div><div>With this in place no python scripts will need to be run and the overall data ingestion into Aktivov should be vastly simplified and fully automated.</div><div>Kerwin - 6/6/23<br /></div><div><br /></div> <br /><br /><font size='2'>########################################################################################################################<font size='2'><br />Item ID: 3869777d2a6b4e9a90a8cf947ffb4bf3 <br />Aktivov_PARKMAINTENANCEAREAS_VIEW<br />Aktivov_stPosts_PUBLISH<br />Aktivov_stStreetLightsMSVL_PUBLISH<br />Aktivov_stServiceCabinet_VIEW<br />Aktivov_stSignalPoles_VIEW<br />Aktivov_stSignalCabinet_VIEW<br />Aktivov_Sidewalks_PUBLISH<br />Aktivov_stSigns_PUBLISH<br />Aktivov_Beacons_View<br />Aktivov_stJunctionBox_PUBLISH<br />Aktivov_stStreetCenterlinesMSVL_PUBLISH<br />Aktivov_Facilities_Maintenance_VIEW<br />Aktivov_wWells_VIEW_16_17 (query layer)<br />Aktivov_ssForceMain_PUBLISH<br />Aktivov_wValves_PUBLISH<br />Aktivov_wControlValves_View<br />Aktivov_wTreatmentPlant_VIEW<br />Aktivov_swCatchbasin_Private_PUBLISH<br />Aktivov_wStorageFacilities_VIEW<br />Aktivov_wSamplingSites_View<br />Aktivov_wPRVs_View<br />Aktivov_wHydrants_PUBLISH<br />Aktivov_wMeter_PUBLISH<br />Aktivov_wMAIN_PUBLISH<br />Aktivov_wBlowOffs_PUBLISH<br />Aktivov_wAirVacs_VIEW_19_20 (query layer)<br />Aktivov_wPumpStation_VIEW<br />Aktivov_wMaintWS_VIEW<br />Aktivov_ssWWTP_VIEW<br />Aktivov_ssManholes_PUBLISH<br />Aktivov_ssLiftStations_VIEW<br />Aktivov_ssCleanouts_PUBLISH<br />Aktivov_swCulvert_PUBLISH<br />Aktivov_ssGravityMain_PUBLISH<br />Aktivov_ssGrid_VIEW<br />Aktivov_ssQuarterlyCleaning_VIEW_22_23 (query layer)<br />Aktivov_swLines_PUBLISH<br />Aktivov_swCatchbasin_PUBLISH<br />Aktivov_swFacility_PUBLISH<br />Aktivov_swGRID_VIEW<br />ParkOpening_VIEW<br /><b>DATABASE=Aktivov</b><br /><b><i>VERSION=dbo.DEFAULT<i></b> <br />Published from B658RT3 at P:\GIS\Projects\HostingAPRXs\AktivovHosting.aprx<br /><i>This section generated by python script 10/23/2025</i><br /></font>########################################################################################################################</i></i></font>

Map Name: Map

Legend

All Layers and Tables

Dynamic Legend

Dynamic All Layers

Layers: Description: Feb 2025 update - SQL agent jobs and views updateAdjusting pressure zone joins to remove the chance of duplicate features being generated Changing lat/long function call from LGDM to Aktivov DBMar 2024 update - instead of SQL views feeding the larger datasets, SQL agent jobs instead take those same view definitions and create standalone feature classes resulting in vastly improved performance and stability. Park Maintenance Areas added in 8/14/23This Map service forms the foundation for a systematic overhaul in how we process data and import it into aktivov.It is broken into 5 group layers with relevant sublayers beneathLayers: Aktivov Street Layers (67) Street Lights (74) Signal Poles (72) Signal Cabinet (71) Service Cabinet (70) Signs (77) Sign Beacons (91) Posts (69) Junction Box (68) Sidewalks (90) Streets (73) Aktivov Water Layers (78)Water Wells (45)Water Valves (43)Water Treatment Plant (41)Water Storage Facilities (39)Water Sampling Sites (37)Water PRVs (34)Water Meters (32)Water Hydrants (28)Water Control Valves (26)Water Blowoffs (24)Water Airvacs (22)Water Mains (30)Water Pump Station (35)Water Maintenance Watershed (29)Aktivov Sewer Layers (79)Sewer WWTP (1)Sewer Manholes (2)Sewer Lift Stations (3)Sewer Cleanouts (4)Sewer Gravity Mains (5)Sewer Force Mains (6)Sewer Maintenance Grid (7)Sewer Quarterly Jetting (81)Aktivov Stormwater Layers (80)Stormwater Lines (19)Stormwater Culverts (17)Stormwater Catchbasins (16)Stormwater Private Catchbasins (15)Stormwater Facilities (20)Stormwater Maintenance Grid (18)Parks and Facilities Layers (8)Park Maintenance Areas (88)City Buildings (82)Park Opening (89)Previously data was copied and transformed across multiple locations and databases leaving it susceptible to locks or general python issues. This service aims to rectify that by pointing all layers and sub layers at SQL views. These views are immutable and provide the necessary data transformations in place all while referencing the source data. Assumptions: All data requires LAT/LONG data in decimal degrees as well as an Asset_ID field (AKTID first, then MVID if former is null)With this in place no python scripts will need to be run and the overall data ingestion into Aktivov should be vastly simplified and fully automated.Kerwin - 6/6/23 ########################################################################################################################Item ID: 3869777d2a6b4e9a90a8cf947ffb4bf3 Aktivov_PARKMAINTENANCEAREAS_VIEWAktivov_stPosts_PUBLISHAktivov_stStreetLightsMSVL_PUBLISHAktivov_stServiceCabinet_VIEWAktivov_stSignalPoles_VIEWAktivov_stSignalCabinet_VIEWAktivov_Sidewalks_PUBLISHAktivov_stSigns_PUBLISHAktivov_Beacons_ViewAktivov_stJunctionBox_PUBLISHAktivov_stStreetCenterlinesMSVL_PUBLISHAktivov_Facilities_Maintenance_VIEWAktivov_wWells_VIEW_16_17 (query layer)Aktivov_ssForceMain_PUBLISHAktivov_wValves_PUBLISHAktivov_wControlValves_ViewAktivov_wTreatmentPlant_VIEWAktivov_swCatchbasin_Private_PUBLISHAktivov_wStorageFacilities_VIEWAktivov_wSamplingSites_ViewAktivov_wPRVs_ViewAktivov_wHydrants_PUBLISHAktivov_wMeter_PUBLISHAktivov_wMAIN_PUBLISHAktivov_wBlowOffs_PUBLISHAktivov_wAirVacs_VIEW_19_20 (query layer)Aktivov_wPumpStation_VIEWAktivov_wMaintWS_VIEWAktivov_ssWWTP_VIEWAktivov_ssManholes_PUBLISHAktivov_ssLiftStations_VIEWAktivov_ssCleanouts_PUBLISHAktivov_swCulvert_PUBLISHAktivov_ssGravityMain_PUBLISHAktivov_ssGrid_VIEWAktivov_ssQuarterlyCleaning_VIEW_22_23 (query layer)Aktivov_swLines_PUBLISHAktivov_swCatchbasin_PUBLISHAktivov_swFacility_PUBLISHAktivov_swGRID_VIEWParkOpening_VIEWDATABASE=AktivovVERSION=dbo.DEFAULT Published from B658RT3 at P:\GIS\Projects\HostingAPRXs\AktivovHosting.aprxThis section generated by python script 10/23/2025########################################################################################################################

Service Item Id: 3869777d2a6b4e9a90a8cf947ffb4bf3

Copyright Text:

Spatial Reference: 102748  (2285)


Single Fused Map Cache: false

Initial Extent: Full Extent: Units: esriFeet

Supported Image Format Types: PNG32,PNG24,PNG,JPG,DIB,TIFF,EMF,PS,PDF,GIF,SVG,SVGZ,BMP

Document Info: Supports Dynamic Layers: true

MaxRecordCount: 20000

MaxSelectionCount: 2000

MaxImageHeight: 4096

MaxImageWidth: 4096

Supported Query Formats: JSON, geoJSON, PBF

Supports Query Data Elements: true

Min Scale: 0

Max Scale: 0

Supports Datum Transformation: true



Child Resources:   Info   Dynamic Layer

Supported Operations:   Export Map   Identify   QueryLegends   QueryDomains   Find   Return Updates