| snippet:
|
Updated Aktivov Layers based on SQL Views
Broken into 5 groups:
Stormwater, Water, Sewer, Streets, and Parks
|
| summary:
|
Updated Aktivov Layers based on SQL Views
Broken into 5 groups:
Stormwater, Water, Sewer, Streets, and Parks
|
| extent:
|
[[-180,-65.4762962962963],[180,90]] |
| accessInformation:
|
|
| thumbnail:
|
thumbnail/thumbnail.png |
| maxScale:
|
1.7976931348623157E+308 |
| typeKeywords:
|
["ArcGIS","ArcGIS Server","Data","Map Service","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> |
| licenseInfo:
|
|
| catalogPath:
|
|
| title:
|
Aktivov |
| type:
|
Map Service |
| url:
|
|
| tags:
|
["Aktivov_2023","Aktivov"] |
| culture:
|
en-US |
| portalUrl:
|
|
| name:
|
Aktivov_2023 |
| guid:
|
15E2C85E-10F3-4DB8-8D55-8C0BA210B9EE |
| minScale:
|
0 |
| spatialReference:
|
NAD_1983_StatePlane_Washington_North_FIPS_4601_Feet |