20200603
04333800
1.0
FALSE
ChangePrivileges 'Database Connections\GIS_to_peak1gis.sde\sde.GIS.AddressPoints' sde_editors GRANT #
ChangePrivileges 'Database Connections\GIS_to_peak1gis.sde\sde.GIS.AddressPoints' sde_readers GRANT AS_IS
ChangePrivileges 'Database Connections\GIS_to_peak1gis.sde\sde.GIS.AddressPoints' sde_editors GRANT GRANT
Append wintergreenbuildingunits Edit\AddressPoints NO_TEST "SITUSADDRESS_ID "SITUSADDRESS_ID" true true false 4 Long 0 10 ,First,#,wintergreenbuildingunits,address_id,-1,-1;VICINITY "VICINITY" true true false 255 Text 0 0 ,First,#;X "X" true true false 8 Double 8 38 ,First,#,wintergreenbuildingunits,x,-1,-1;Y "Y" true true false 8 Double 8 38 ,First,#,wintergreenbuildingunits,y,-1,-1;LONGITUDE "LONGITUDE" true true false 8 Double 8 26 ,First,#;LATITUDE "LATITUDE" true true false 8 Double 8 26 ,First,#" #
Append wintergreenbuildingunitsBLDGSFGHJ Edit\AddressPoints NO_TEST "SITUSADDRESS_ID "SITUSADDRESS_ID" true true false 4 Long 0 10 ,First,#,wintergreenbuildingunitsBLDGSFGHJ,AddressID,-1,-1;VICINITY "VICINITY" true true false 255 Text 0 0 ,First,#;X "X" true true false 8 Double 8 38 ,First,#,wintergreenbuildingunitsBLDGSFGHJ,X,-1,-1;Y "Y" true true false 8 Double 8 38 ,First,#,wintergreenbuildingunitsBLDGSFGHJ,Y,-1,-1;LONGITUDE "LONGITUDE" true true false 8 Double 8 26 ,First,#;LATITUDE "LATITUDE" true true false 8 Double 8 26 ,First,#" #
Append clearwaterloftsunits Edit\AddressPoints NO_TEST "SITUSADDRESS_ID "SITUSADDRESS_ID" true true false 4 Long 0 10 ,First,#,clearwaterloftsunits,ID,-1,-1;VICINITY "VICINITY" true true false 255 Text 0 0 ,First,#;X "X" true true false 8 Double 8 38 ,First,#,clearwaterloftsunits,X,-1,-1;Y "Y" true true false 8 Double 8 38 ,First,#,clearwaterloftsunits,Y,-1,-1;LONGITUDE "LONGITUDE" true true false 8 Double 8 26 ,First,#;LATITUDE "LATITUDE" true true false 8 Double 8 26 ,First,#" #
Append grandcoloradopeak8 Edit\AddressPoints NO_TEST "SITUSADDRESS_ID "SITUSADDRESS_ID" true true false 4 Long 0 10 ,First,#,grandcoloradopeak8,SITUSID,-1,-1;VICINITY "VICINITY" true true false 255 Text 0 0 ,First,#;X "X" true true false 8 Double 8 38 ,First,#,grandcoloradopeak8,X,-1,-1;Y "Y" true true false 8 Double 8 38 ,First,#,grandcoloradopeak8,Y,-1,-1;LONGITUDE "LONGITUDE" true true false 8 Double 8 26 ,First,#;LATITUDE "LATITUDE" true true false 8 Double 8 26 ,First,#" #
CalculateField Edit\AddressPoints X 2839848.247131 VB #
CalculateField Edit\AddressPoints Y 1600693.754687 VB #
CalculateField Edit\AddressPoints VICINITY "Breckenridge Area" VB #
AddField "Database Connections\GIS to scg-sql-frisco.sde\sde.GIS.AddressPoints_1" ADDPNT_ID TEXT # # # ADDPNT_ID NULLABLE NON_REQUIRED #
FeatureClassToFeatureClass "Database Connections\GIS to scg-sql-frisco.sde\sde.GIS.AddressPoints_1" "Database Connections\GIS to scg-sql-frisco.sde" AddressPoints_2 # "SITUSADDRESS_ID "SITUSADDRESS_ID" true true false 4 Long 0 10 ,First,#,Database Connections\GIS to scg-sql-frisco.sde\sde.GIS.AddressPoints_1,SITUSADDRESS_ID,-1,-1;ADDPNT_ID "ADDPNT_ID" true true false 255 Text 0 0 ,First,#,Database Connections\GIS to scg-sql-frisco.sde\sde.GIS.AddressPoints_1,ADDPNT_ID,-1,-1;VICINITY "VICINITY" true true false 255 Text 0 0 ,First,#,Database Connections\GIS to scg-sql-frisco.sde\sde.GIS.AddressPoints_1,VICINITY,-1,-1;X "X" true true false 8 Double 8 38 ,First,#,Database Connections\GIS to scg-sql-frisco.sde\sde.GIS.AddressPoints_1,X,-1,-1;Y "Y" true true false 8 Double 8 38 ,First,#,Database Connections\GIS to scg-sql-frisco.sde\sde.GIS.AddressPoints_1,Y,-1,-1;LONGITUDE "LONGITUDE" true true false 8 Double 8 26 ,First,#,Database Connections\GIS to scg-sql-frisco.sde\sde.GIS.AddressPoints_1,LONGITUDE,-1,-1;LATITUDE "LATITUDE" true true false 8 Double 8 26 ,First,#,Database Connections\GIS to scg-sql-frisco.sde\sde.GIS.AddressPoints_1,LATITUDE,-1,-1" #
CalculateField sde.GIS.AddressPoints ADDPNT_ID ""ADD" & [SITUSADDRESS_ID]" VB #
sde.GIS.AddressPoints_2
002
2741944.628991
2915488.778145
1557149.744918
1762473.107413
1
Server=scg-sql-frisco; Service=sde:sqlserver:scg-sql-frisco; Database=sde; User=gis; Version=sde.DEFAULT
ArcSDE Connection
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
NAD_1983_StatePlane_Colorado_Central_FIPS_0502_Feet
<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.6'><WKT>PROJCS["NAD_1983_StatePlane_Colorado_Central_FIPS_0502_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",3000000.000316083],PARAMETER["False_Northing",999999.999996],PARAMETER["Central_Meridian",-105.5],PARAMETER["Standard_Parallel_1",38.45],PARAMETER["Standard_Parallel_2",39.75],PARAMETER["Latitude_Of_Origin",37.83333333333334],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2232]]</WKT><XOrigin>-118767899.99694154</XOrigin><YOrigin>-94525499.997813985</YOrigin><XYScale>1953.1249981810104</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.008192000007629395</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102654</WKID><LatestWKID>2232</LatestWKID></ProjectedCoordinateSystem>
20200603
04373000
20200603
04373000
50000
5000
FGDC
Version 6.2 (Build 9200) ; Esri ArcGIS 10.6.1.9270
Map
1
-106.420040
-105.798907
39.926416
39.359567
<DIV STYLE="text-align:Left;"><DIV><P><SPAN>Contains physical address points for locations of buildings, parcels, utilities, and other entities found in Summit County, CO. </SPAN></P></DIV></DIV>
Address
Points
Summit
County
Colorado
Summit County Address Points
SDE Feature Class
dataset
EPSG
5.3(9.0.0)
0
Simple
FALSE
0
TRUE
FALSE
sde.GIS.AddressPoints_2
Feature Class
0
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
SITUSADDRESS_ID
SITUSADDRESS_ID
Integer
4
10
0
ADDPNT_ID
ADDPNT_ID
String
255
0
0
VICINITY
VICINITY
String
255
0
0
X
X
Double
8
38
8
Y
Y
Double
8
38
8
LONGITUDE
LONGITUDE
Double
8
26
8
LATITUDE
LATITUDE
Double
8
26
8
SHAPE
Shape
Geometry
4
0
0
Feature geometry.
Esri
Coordinates defining the features.
20200603
/9j/4AAQSkZJRgABAgAAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0aHBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCACFAMgDASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iiigAooooA5jXpN2oBduNiAZ9e9N0lJJpmhRgoA3HP4CrfiGIlYZgvAyrH+X9ax4Lma2cvDIUYjBIAPH415s5ezruTPNnL2ddyZuanY/uInhDPLFjAAJyM+n41nzWN/E7XOxgWOTsbJFXINWt0nZ2chTGMgIeX5yelD6wrsAtwcHqNn8uK6ZKnPXm/E6ZKnN35vxMNmLMSTknqas2N49lceYMlDwy561qTabBLKIkVgFUlSMDP6fWsWWExE8HbnA3DBrlqUalN86OSpRqUnznZQzLPEsqHKsMipa5TT9Uks2COS8Pde4+lbX9tWXl7/ADTjpjac12U8RCUbt2O2niITjduxo0VFFMk8SyRtuRhkGpa3NwooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAK93D9otZYsDLKQM+vauNZSrFWGCDgiu6rk9ZgWG/bZ0kG/p0JrixkLpSOLGQulIoUquyHKsVPqDikorz02tjz02ti6up3gJdrhjwQDgdcHFJFLd31wkXmB2OSA4GDxk54qB5ENvFGqYZSxZs/eJ/+sKfZ3H2abfgZPG7rgd8V0RqPmSctDojUfMk5aFi50tok3xF3/2SvOPUVRWN3zsRmx12qTiugj1GCVRvuNioM/MOfTpTmuv3PkCMgHq3c8+1dMsLTm7xZ0ywtObvFmZpeotaS+VISYWPOf4T611CsHUMpBB5BFcXcKFuJABgBjgV0mkTCbT4x/FH8h/z9KMNNpum+gYabTdN9DSooorsOwKKKKACiiigAooooAKKKKACiiigAooooAKKKKACqGoWCXsOOBIo+Rv8av0UpRUlZilFSVmcnc6TPa23muVOD8wXsKoV28kayxlHGVYYIrmb/SZLTdIhDxZ69x9a8+vhuXWGx59fDcusNjOooorjOMUH5SMde9W7W5l3hQN/c7j+tVAQGBIyM8j1qRFaRiUIB6sAMAL3rejKSejN6MpJ6Msai00s4L/MAuRsX5QKueHpSJ5YsjBXdj3H/wCuob2ZZLCJkQAs3zOP4vb+VV9OuFtr2OWQ4QZDYGe1bTahiE7m02oV1K52FFRxyJLGsiEMrDIIqSvQPQCiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKingS5haKQZVhg1LRSauDVzltU0+KySIxlzuJ3Fv0rNrt5I0kGHVWHXDDNc3qGmXMc0syqGRn+UIMnn2rz8Rh7e9BHnYjDte9AzKOxHY0pBHUEUlcexxlqUE2MTrK5B/wBYpPAOcA/yqsVIAPHPTmr2lBpJ2iGCNpbaRkE8YpNRtmjkMzyb2duRs24rqnDnh7RHTOHPD2iL+j38MVqYZpFQqxK7uBg/5NaUuo2cKBmnTBGQFOSfwFchRRDFyjHlsOGLlGPLY6ZtcswjlS7Feg243VctLj7VapNtK7s8H64rja3rLWoI7eOKVCrLhcqOMetbUcTzS992NqOJcpe+7G7RWbHrFvLeC3XJBOA/Yn2rSrrjJS2Z1xkpbMKKKKooKKKKACiiigAooooAKKKKACiiigAooooAKKKimlWGJ5X+6oJNAGdrsStYb8DcjA5x68VzVal7q/2y18rydhJyfmzWXXlYmcZzvE8rEzjOd4lmwuJLa6EkcZfjDKB2roboQXlgvnv5OQGweq/hWBZLdyMy2jHcOSAwBxSXkV1Gw+1btzdCzZzj/wDXV0qjhT2uvwLpVHTp7XX4BeQrDIPLQ+Uy/KxB59+arE5OcAfStO2n+3iK1kiVmT7rc9OKrahaC2nCI6oMfMGO5gcHkDjIzjqRSqUuZc8XoKpT5lzxehUoqZhbsSE81Sfu5wcVEQA23Jz3yMVzuFtbnO4W1uCsUYMrYYHIrUt9duEdRNtdc88YP+FZTYHTmkOcDJxgZwB1/wA8VdNzi/dZdNzi/dZ1Vlqsd5KYxE6HsTzmtKuU0q2nF6kkSYVHw7npjuK6uvTozclqenRm5R1CiiitTUKKKKACiiigAooooAKKKKACiiigAqlqas+nzhGwdufwHWpLu4W0tnmYZ29B6mqEWqibT5pSEEyA4Qng+n1rOc4/C30M5zjrFvoc5SqCxwASfalkkMsjO2AT6DAqSJgsMvy5Y4A9h/nFeQkmzx0k2aWk3lpalkcFXbq55A9qS5FvqWqDy3dl2HcRx0HasknPc/jU9ncPa3CSoM846dR3FbRrXSg1odEa10oNaEUcrxNujYqSMZBxU15eNemNnUB1XaSO/NTanayRXhfYdsnzKAOntVN4njx5ilMnowwaiSnC8OhnJTheHQZQeST3PNOdGjcowwR1pp4rLVGWqHKjOxjKEAYJfPT1GP8APStHTNMgu1fzZ9xQ/dj447ckVmq20dOau6VJIt/GqMQGOG4zx1rppzjzRTR005x5opq51MUSQxLGgwqjAFSUUV6h6gUUUUAFFFFABRRRQAUUUUAFFFFABRRRQBQ1VI30+USNtAGRz1I6CuTrrdUWNtPlaRA+0ZXPY9M/rXJV52N+NHnY34kKAWOACT7U5oZEQO0bKpOASKaCR0JH0p2XVCmcKcHbmuRWtqcitbUZWrp0TyxRL9mRkEoYy5G4DI49e35VlVsaG0MQlkklCMcAAtj8cfjW2H+Oxth/jsaTXzMrBIpA6EgqUyTzjjtWPd3jSzKs0e2RGOWZAcD0x3/Otu7tTcPGd7AK2SBjt0/WsfUoLW3l5d2c844/UceldtdStudtZTtuU51gkJktwyrvC7XPrnBz+BqFdjRkEYYc7vUelD4BIUnYeR7/AOeadbRySXMaQnDscA+lefvLY8/eWxc0Yp9tKPHvEiFemQPrXSxQRwIEiRUUdgKqafp6WUfOGlP3n9vStCvSoU3CFnuelQpuEEnuFFFFbm4UUUUAFFFFABRRRQAUUUUAFFFFABRRRQBHLEk0TRyLuVhgiuRuLOSG9e3CMTk7eM5HauyqrGjm8lZ1BQKvlnA465rCtRVS1zCtRVS1znYNHvJ8HyxGp7ucY/DrUd/bG0lWAsWwM57c+ldXM7JC7KCWCkgAZya49/OlTe3IGSST69+fp+lctalCnG0d2ctalCnG0d2Q0+LIlTb97cMUwYHXNOVS7hF5LHArkW5yLc29UuQtwjWtyolVSrL6g88dqyJZ2lJ3ou7+WKdfSCS7kwoUKdvHfHFV+WbuSa3q1XKTsb1arlJ2L2m2v2y62uzKqrnK1uWmlQ2kzSqzsxGPmI4p2lvM9mvnIyuDj5hgketX67aNGKin1O2jRjGKfUKKKK6DoCiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK5XWbRLe83IeJMtjHQ0UVz4pL2bZzYpJ02yiq7s84xU9gN2ow9sOD+tFFefTWsfU8+mvej6ldyWYsepyf1NdNpllFbW6yAbpHXJY/wAqKK6MLFObbOnCxTm2zTooor0D0AooooAKKKKACiiigAooooA//9k=