20230530 10170100 1.0 TRUE TRUE Enterprise_Utilities_Sewer In PIYN, this is a map service for displaying CIP projects to the public. This service is used in both the PIYN and other CIP web maps. Standard except for the following: The CIP layers use some fancy SQL to create a virtual field for the "LinkText" which allows popups in the web map to not display a link for records which don’t have a link url. This is done via a query layer, but because these layers use domains (which a query layer can't access), the query layer is created as a separate table and joined to the FC. There is one SQL table for each of the CIP layers. Note that for the 'completed' layers, the logic that filters out older projects is contained in the joined query layer, rather than in the layer def query. This is due to a bug that causes layers with a join to not be able to use sql functions like GetDate(). Repointed mxd to new Db GISTESTDB on Oct 19,2021. catalog-prod sewer utilities Mapshot A map service for displaying sewer utility data for Mapshot. City of Bellevue, WA iVBORw0KGgoAAAANSUhEUgAAASwAAADICAYAAABS39xVAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAO xAAADsQBlSsOGwAABSlJREFUeJzt3c1KI1kYx+HKdwzoRnrpLbj31rwNr8h7cO1WRMRdgvkc3oIK mWFmGIZU5N88D4SO6YWS8/qrcyrQPT4cDocGIMD4p38AgP9KsIAYggXEECwghmABMQQLiCFYQAzB AmIIFhBDsIAYggXEECwghmABMQQLiCFYQAzBuoD6J8cGg0Hz9PTU3N/fN+/v781+v29fG48tQbL5 fN7c3d2167rdbtv1XK1WzdXVVbNer5vpdPrTP+JvxW9LzzabTRusGtwa7IeHh/Z1g/x7+Pz8bF5e XtpITSaT4+sVL2t8foLVsxri3W7XPq9dVX1dO6vua7Ld3t42X19f7YWpdlul1rjbbXFe3tELqOEd DoftUFe86nlFq44M3ZCTq3ZXNzc37fNa4wpWrTHnJ1g9q+Ngdw+rBvn0qluxssvKVutXkep8f38f g9WtO+cjWD2rge3uZdQAd/e0RqNRu/OazWZ9/wj0qAtT93+5dOvpSNgPwbqA7gZst8vqVLTIV2tb x/uKVa1vxcvOuR+CdQE1vPWocJ0eE1yF8y2Xy2axWPxpp1xr7YZ7PwTrAmqYK1Ld4/jm+xQpXsWq Pkg5vRB1O2f3sM5PsIAYggXEECwghmABMQQLiCFYQAzBAmIIFhBDsIAYggXEECwghmABMQQLiCFY QAzBAmIIFhBDsIAYggXEECwghmABMQQLiCFYQAzBAmIIFhBDsIAYggXEECwghmABMQQLiCFYQAzB AmIIFhBDsIAYggXEECwghmABMQQLiCFYQAzBAmIIFhBDsIAYggXEECwghmABMQQLiCFYQAzBAmII FhBDsIAYggXEECwghmABMQQLiCFYQAzBAmIIFhBDsIAYggXEECwghmABMQQLiCFYQAzBAmIIFhBD sIAYggXEECwghmABMQQLiCFYQAzBAmIIFhBDsIAYggXEECwghmABMQQLiCFYQAzBAmIIFhBDsIAY ggXEECwghmABMQQLiCFYQAzBAmIIFhBDsIAYggXEECwghmABMQQLiCFYQAzBAmIIFhBDsIAYggXE ECwghmABMQQLiCFYQAzBAmIIFhBDsIAYggXEECwghmABMQQLiCFYQAzBAmIIFhBDsIAYggXEECwg hmABMQQLiCFYQAzBAmIIFhBDsIAYggXEECwghmABMQQLiCFYQAzBAmIIFhBDsIAYggXEECwghmAB MQQLiCFYQAzBAmIIFhBDsIAYggXEECwghmABMQQLiCFYQAzBAmIIFhBDsIAYggXEECwghmABMQQL iCFYQAzBAmIIVs8Oh0Oz3++b0WjU97fih9Z3s9k039/fzXw+P76+3W6b8div17l5Ry9gMBj8499V zMg1HA6b2Wx2jFWtZ623WPVDsHpWw9sFq4a5rsa73a4d9Brq+pP8XVZnvV430+n0Xy9S/H+C1bOK Uw10xamOhZPJpH383bCTp9ZvtVodvz7dWTkWnp9g9awiVdH66/GvXquBruME+TvobmdVwTq9SHFe 3tEL6G64n954r+c16BUtclWUrq+v2/WsC1Id8StWta6nO2nOQ7B6VoNbYaqBrvtX9aiBrqtxDbd7 WNne3t7aXXKt73K5bBaLRRux2nFxfoLVs+5YUB97v76+Ns/Pz83Hx0d7Na5B9ylhtl+/fh2P/N2f pS5K9XDz/bwE60IqTo+Pj5f6dvyAOhp23Jvsh2ABMQQLiCFYQAzBAmIIFhBDsIAYggXEECwghmAB MQQLiCFYQAzBAmIIFhBDsIAYggU0Kf4AyDc1V4YzDaUAAAAASUVORK5CYII=