20150211
09303200
1.0
FALSE
CalculateField RetrofitToilets StrePlusNu [adnum] VB #
CalculateField RetrofitToilets StrePlusNu "[StrePlusNu] +" " + [st_name]" VB #
CalculateField RetrofitToilets Certified "Certified" VB #
CalculateField RetrofitToilets Certified "Certified" VB #
CalculateField RetrofitToilets Certified "Certified" VB #
CalculateField RetrofitToilets Certified "Certified" VB #
CalculateField RetrofitToilets Certified "Certified" VB #
CalculateField RetrofitToilets Certified "Not Certified" VB #
CalculateField RetrofitToiletsWebVersion ImageURL "http://gis.slocity.org/Images/ToiletRetrofit.png" VB #
CalculateField RetrofitToiletsWebVersion LinkURL "http://www.slocity.org/government/department-directory/utilities-department/conservation" VB #
CalculateField RetrofitToiletsWebVersion LinkURL "http://www.slocity.org/Home/Components/ServiceDirectory/ServiceDirectory/57/1041" VB #
CalculateField RetrofitToiletsWebVersion ImageURL "http://gis.slocity.org/Images/ToiletRetrofitCertified.jpg" VB #
CalculateField RetrofitToiletsWebVersion LinkURL "http://www.slocity.org/government/department-directory/utilities-department/conservation" VB #
CalculateField RetrofitToiletsWebVersion SuiteLabel [suite] VB #
CalculateField RetrofitToiletsWebVersion AddLabel [AddLabel] VB #
CalculateField RetrofitToiletsWebVersion AddLabel [streetNumb] VB #
GISSupport.GISSTAFF.ToiletRetrofit
002
Server=slosql2012p; Service=sde:sqlserver:slosql2012p; Database=GISSupport; User=gisstaff; Version=sde.DEFAULT
ArcSDE Connection
Projected
GCS_WGS_1984
Linear Unit: Meter (1.000000)
WGS_1984_Web_Mercator_Auxiliary_Sphere
<ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/10.1'><WKT>PROJCS["WGS_1984_Web_Mercator_Auxiliary_Sphere",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Mercator_Auxiliary_Sphere"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",0.0],PARAMETER["Auxiliary_Sphere_Type",0.0],UNIT["Meter",1.0],AUTHORITY["EPSG",3857]]</WKT><XOrigin>-20037700</XOrigin><YOrigin>-30241100</YOrigin><XYScale>10000</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102100</WKID><LatestWKID>3857</LatestWKID></ProjectedCoordinateSystem>
20150305
14210300
20150305
14210300
Microsoft Windows 7 Version 6.1 (Build 7601) Service Pack 1; Esri ArcGIS 10.2.2.3552
Curb Color
toilet retrofit
toilet retrofit
SDE Feature Class
dataset
EPSG
8.2.6
0
Simple
FALSE
0
TRUE
FALSE
GISSupport.GISSTAFF.ToiletRetrofit
Feature Class
0
OBJECTID_1
OBJECTID_1
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
OBJECTID
OBJECTID
Double
8
10
0
NOTES
NOTES
String
55
0
0
streetNumb
streetNumb
String
12
0
0
streetName
streetName
String
50
0
0
suite
suite
String
12
0
0
zipCode
zipCode
String
5
0
0
fullAddres
fullAddres
String
100
0
0
streetType
streetType
String
50
0
0
addressTyp
addressTyp
String
50
0
0
addressSta
addressSta
String
20
0
0
aID
aID
Double
8
10
0
AddSt
AddSt
String
100
0
0
OID_
OID_
Integer
4
10
0
uniqid
uniqid
Double
8
10
0
ofpid
ofpid
SmallInteger
2
5
0
apn
apn
String
20
0
0
adnum
adnum
Integer
4
10
0
st_name
st_name
String
19
0
0
suite_1
suite_1
String
4
0
0
totaltoi
totaltoi
SmallInteger
2
5
0
offset
offset
SmallInteger
2
5
0
offsetnum
offsetnum
SmallInteger
2
5
0
offsetnum2
offsetnum2
SmallInteger
2
5
0
offsetdate
offsetdate
Date
36
0
0
rebatenum
rebatenum
SmallInteger
2
5
0
rebatedate
rebatedate
Date
36
0
0
rebatenum2
rebatenum2
SmallInteger
2
5
0
rebatedat2
rebatedat2
Date
36
0
0
rebateamt3
rebateamt3
Double
8
9
2
certifnum
certifnum
SmallInteger
2
5
0
certifdate
certifdate
Date
36
0
0
verifiedby
verifiedby
String
50
0
0
notes_1
notes_1
String
254
0
0
OffSetDone
OffSetDone
String
10
0
0
addST_1
addST_1
String
100
0
0
Certified
Certified
String
20
0
0
StrePlusNu
StrePlusNu
String
50
0
0
ImageURL
ImageURL
String
100
0
0
LinkURL
LinkURL
String
100
0
0
AddLabel
AddLabel
String
50
0
0
SuiteLabel
SuiteLabel
String
50
0
0
Shape
Shape
Geometry
4
0
0
Feature geometry.
Esri
Coordinates defining the features.
20150305
/9j/4AAQSkZJRgABAgAAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0aHBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCACFAMgDASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iiigAooooAKKKKACiiigAooooAKKKKACiiigClLCZGSVBGJl+UO8e4hCyl1HIIyFHfqAcHGKapMqi5gdlaUR/61XxsByRsJG1iCRnAOcZB24p3mPKXWM7WSRVYyREgjgnHTOVOMgkA+uCKVSUuGjaSRjLmRQU+VANoIyBjqc4JycnHA4Cle39eosd3bzeR5c8T+dGZY9rg714+ZfUfMOR6j1q3VJZjKVZEO0uQxcFCMZGQCOeR16EcgkYq7QJ2vYKKKKBBRRSE4GaAFqr5g89I/nyylh8h28EdT0B56Hk846Gnq5k8t42HlsMnKnJ9PpSxRLEmFzjJPJJ6nPekn2FuMmV5IXVZmhZlIEiAblPqMgjI9wRRVmim0nuXGbjt+Sf5hRRRQSFFFFABRRRQAUUUUAFFFFABVaYzrA5hRGlCnYrNtUnsCQDge+D9Ks0UAFFVfLHnvJ8+WUKfnO3gnoOgPPUcnjPQUhdjOyeU6qFBEhI2sTngc5yMDqMcjGecAeglw4CD95InzpzGm5uWHBGDwehOOBk5GMhiYvIQ00KmIskkYdTuIG1gWVlBVg3bqMA8HgPghZADL5TTsqiSRE2hyB1xkkDrgZOPWrlA07LzCiiigQUUUUAFVIZVlUsN4AZl+ZCp4JHQ9uOD0I5HBqSVWYptkKBWywAB3DB4/z6VPQmAUUUUAFFVYjNg+YiK25sBG3cbjg5wOSMEjseMnrRQBaooooAKKKKACoX8zemwrtz8+RyRg9PxxU1FABRRRQBCYlMyyfNuUEfeOOcduh6VNRRQAUVB5hM5j8tsBQ2/jBznj68frSmJDMJMHeFKjk4x9OlK4ES+ZNsc+dBskbKHad4GVGevB4YYIPTOORT4YY7aBIYUWOKNQqIowFA4AAHQVYopjbCiiigQUVTL5vfLWeI7I9zxYyw3H5W68D5XHTn1GDkAS42SDzhskbAO5MkZU5HG4dcZyDwR2NA7dxQjGdX811UKQYwBtYnHJ4zkYPQ45Oc8Yt1UCMZ1fzXVQpBjAG1iccnjORg9Djk5zxh7yxo8StIqtI21ATyxwTgepwCfoDQIsUUUUAFFVpleSF1WZoWZSBIgG5T6jIIyPcEVMGUsVDDI6jPIoAhMMZuFmKIZVUqGx82DgkA+h2j8h6UVZooE1cKKKKBhRRRQAUUUUAFVoZRLCki7wHUEB0KHB9QcEH2PNMnieYxFH2OkgYElsEdGBAIzlScZyAcHBxVe1kxJthhRY2YebCgUNbyMDI3mENgk7l4AJy2ckHITdmUopxut/6/r+lfUpCMgg96rK7s0wMTqFbgkjDjAORg9OSOcHIPbBNqmSRRIsUSoM4UADJJP5nk1LRRQtACiopZY4l3SMqjIGT0yTgfrUckrLIE2g7iAuGwSO5x7UriuWarTQxzACSNXAZWAYZGVIIP1BAI9xT4o1ijVFzhQAMkk/meTU1PpqNFOFmld5Fc+VjaqtEysGVmDHJ6g8Y47ZyQRh0omwPLdFbcuS67uNwyMZHJGQD2POD0pJpViUMd5BZV+VCx5IHQdueT0A5PAp0MMcIIjjVAWZiFGBliST9SSSfc0eQ/MWaaO2geaZ1jijUs7scBQOSST0FMmiWVQp3gBlb5XKngg9R245HQjg8GrdUbRleFZI7j7RHJl1kypBVjkYKjBABwD6AZJPNAdLiWJY2qlkKyFm3KzO2G3HcAXAJXOcHAGMYGMVfqk0OLlZYlRXbAlYx5LoA2FzkYwzZ5z1PHORJCzyQozQtCzKCY3I3KfQ4JGR7EigJau6LNN2gMWwMnqadRQIKKKKACq0xnWBzCiNKFOxWbapPYEgHA98H6VZooAqyCUvFsdAof5wVyWGDwDkYOcHPPAIxzkWqqFGE7P5rspUARkDapGeRxnJyOpxwMY5yqo6tMTK7Bm4BAwgwBgYHTgnnJyT2wAwLVFFFICNHSRdyMGHTIOariNpY4HmUxzphiiTMVDbSCM8bhyeo9DgEDFyigE7BRRRQAUx2K4wpOTjjt70+mPGsiMjDKsMEUMGZV/qMdm7KxUtgMFAPyD1Y+54AHJPTNZHm3QuGlYyFiwO85JHoNo788IP+BGt3UbL7XCCufOjO5Duwc+me2eme2TiufywGFPzKuCOUG3pgf3E9/vN24rz67kpa7dP6/r8TiruSlrsdNG6XtswBZcgo+1sFT3GR39xU0fmFT5gUHJAw2cjsenXFZmjpPHb7JECRcCJCu0geuP4R6Dr6nJrUmMgiYxBWfHygnArrpy5oqTR1Qd4qTJarvLGjxK0iq0jbUBPLHBOB6nAJ+gNSq6vnawODg4PQ0+tSwooooAKKqxxBJJmG7Mj7jlyQDgDjPQcdBxnJ6k0SCUvFsdAof5wVyWGDwDkYOcHPPAIxzkAFqiiigAooooAKKKKACs51giQRpEbme0jEkcZcPKPlZQcuc5YBl3E885PWtGigadgooooEFFFFABVdJY3eVVkVmjba4B5U4BwfQ4IP0IqxVaZnjhdlhaZlUkRoRuY+gyQMn3IFAFmiqCTyeXcMbdmkiLARp/HjldrMFBJBHfAORngmr9A2mtwrNFhD/ab3JQ5IBHI2lu5x3OAOT+FaVRmNC4kKgsAQD3GetTKKla5LSe5JRUQRRKX53EAHnsPb8alqhmKbXF4d0SzOzZG9Rh0WRWBZhHw0ZZti556k5yVuwLKgKSvvKYVZCwLSDaMswCgA5zwOOh4zgSvFG7xM0as0bbkJHKnBGR6HBI+hNQXt0tnEs8hVYFP72Rs/u1/vcA8A4yTgAZJPFJLl1NHJztFLX+tv6/JF+iiimZlYQxi4aYIglZQpbHzYGSAT6DcfzPrVmiigAooooAKKKKAK0xnWBzCiNKFOxWbapPYEgHA98H6VZoooAKKKKACiiq0M0cwJjkVwGZSVORlSQR9QQQfcUAWaijMhU+YqqcnGDnjPB6VGIYxcNMEQSsoUtj5sDJAJ9BuP5n1qzQAUUUUAZ9vYW9okaxQKnlBkjA5KKxBKqT0XgfKOAFAAwBUj7IPOuH804j+YLufhcn5UGeeT0GTwOcCrlFA+Zt3bCiqsYlDzb3QqX+QBcFRgcE5OTnJzxwQMcZNqgQUUVSMU6wSLHP++IYo8qhgpJJAIXbkDIHUEgcnPNAFmSTy42faWwM4UZJpJTIEzGFLZHBOOM8/pUXljz3k+fLKFPznbwT0HQHnqOTxnoKtUWAp28QiQjcWO5m5JPVicck9M49B2wOKuUUUAFFFVZBKXi2OgUP84K5LDB4ByMHODnngEY5yAC1RRVaaISwvG28B1IJRyhwfQjBB9xzQBZooooAKKKKACiqTrM6yxBjEhTCyoQXUnOTtKkcfKRnOcnI45sSxJPE0cih0YYZT0IpPyBkUhlDxbEQqX+clsFRg8gYOTnAxxwSc8YNqkAwMUtMAooooAKKKKACiiigAooqrHEEkmYbsyPuOXJAOAOM9Bx0HGcnqTQBaooooAKKKKACiqyTR3Nss0EiOjrujkU7lYEcEY6imxSb3lQli0ZCsTGVBOAcjPUc9RkZyOoNAa9hR53nuS6eXtG1QPmB5zk56dOMcYPJzxaqrEjoMGZ5DuY5YDOCSQOAOB0HfA5yeatUAFFFFAFQuxnZPKdVCgiQkbWJzwOc5GB1GORjPOCrdFO4BVFbZ/Mt5ZjA8iQsrusO0kkqTtO47VO3lec8c8clFS9xptbDrhFYBW343oflcqchhjp29R0I4PBp0JmW3UzOjyAAOUXapPqAScD2yfrRRT6ii7pJ/1sWqKKKACiiigAooooAKKKKACiiigAooooAKq21x58twpXHlSbM568A5/Wiiom2mv66EyeqLVVH811Xy3RWJU5dS3AI3DqOSMgHsecHpRRVPYtDjDGZ1nKL5qqQHxyAcEjPvtH5D0qzRRTEFFFFABRRRQB//2Q==