20201118
12015000
FALSE
1.0
Server=cty-vchssdev1; Service=sde:sqlserver:cty-vchssdev1\ss2k14; Database=LocalGovernment; User=GISAdmin; Version=sde.DEFAULT
ArcSDE Connection
LocalGovernment.ADMIN.qaSanitationSchedule
002
918205.211820
952723.315684
636176.219487
683704.670362
1
Project \\GIS2\gisdata\FileGDB\LocalGovernmentSchema\QAlertSanitationNewSchema.gdb\InfrastructureOperations\qaSanitationSchedule \\GIS2\gisdata\FileGDB\LocalGovernmentSchema\QAlertSanitationNewSchema.gdb\qaSanitationSchedule_Project PROJCS['NAD_1983_StatePlane_Florida_East_FIPS_0901_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['Transverse_Mercator'],PARAMETER['False_Easting',656166.6666666665],PARAMETER['False_Northing',0.0],PARAMETER['Central_Meridian',-81.0],PARAMETER['Scale_Factor',0.9999411764705882],PARAMETER['Latitude_Of_Origin',24.33333333333333],UNIT['Foot_US',0.3048006096012192]] # PROJCS['NAD_1983_StatePlane_Florida_East_FIPS_0901_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['Transverse_Mercator'],PARAMETER['False_Easting',656166.6666666665],PARAMETER['False_Northing',0.0],PARAMETER['Central_Meridian',-81.0],PARAMETER['Scale_Factor',0.9999411764705882],PARAMETER['Latitude_Of_Origin',24.33333333333333],UNIT['Foot_US',0.3048006096012192]]
CalculateField "QAlert Sanitation Schedule" created_user "CITY-HALL\JonSt" VB #
CalculateField "QAlert Sanitation Schedule" created_date [LASTUPDATE] VB #
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
NAD_1983_StatePlane_Florida_East_FIPS_0901_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_Florida_East_FIPS_0901_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["Transverse_Mercator"],PARAMETER["False_Easting",656166.6666666665],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-81.0],PARAMETER["Scale_Factor",0.9999411764705882],PARAMETER["Latitude_Of_Origin",24.33333333333333],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2236]]</WKT><XOrigin>-17791300</XOrigin><YOrigin>-41645400</YOrigin><XYScale>3048.0060960121914</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808333333333335</XYTolerance><ZTolerance>0</ZTolerance><MTolerance>0</MTolerance><HighPrecision>true</HighPrecision><WKID>102658</WKID><LatestWKID>2236</LatestWKID></ProjectedCoordinateSystem>
20201116
11255400
20201116
11255400
Custom - The schedules and area boundaries for sanitation service pickup such as curbside trash, recycling, yard waste, and bulk trash. Used in the Qalert Citizens Request Management (CRM) software and applications.
QAlert Sanitation Schedule
X-Ray
Sanitation, trash, recycling, yard waste, bulk trash
NaN
NaN
NaN
NaN
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
ESRI
Sequential unique whole numbers that are automatically generated.
SHAPE
SHAPE
Geometry
4
0
0
Feature geometry.
ESRI
Coordinates defining the features.
BULKDAY
Bulk Day
String
20
0
0
Days bulk trash is picked up
DAY
Service Day
String
20
0
0
Pickup day for the sanitation service (used for calculating the other fields)
RECYCLDAY
Recycling Day
String
20
0
0
Days week recycling is picked up
TRASHDAY
Trash Day
String
20
0
0
Days week curbside trash is picked up
WEEK
Service Week
String
20
0
0
Pickup week for the sanitation service (used for calculating the other fields)
YARDDAY
Yardwaste Day
String
20
0
0
Days yardwaste is picked up
LocalGovernment.ADMIN.qaSanitationSchedule
Feature Class
57
created_user
created_user
String
255
0
0
created_date
created_date
Date
8
0
0
last_edited_user
last_edited_user
String
255
0
0
last_edited_date
last_edited_date
Date
8
0
0
GlobalID
GlobalID
GlobalID
38
0
0
SHAPE.STArea()
SHAPE.STArea()
Double
0
0
0
SHAPE.STLength()
SHAPE.STLength()
Double
0
0
0
Version 6.2 (Build 9200) ; Esri ArcGIS 10.6.1.9270
qaSanitationSchedule
1
-80.201660
-80.095498
26.212421
26.081048
QAlert Sanitation Schedule
Sanitation
Trash
Recycling
Yard Waste
Bulk Trash
Custom - The schedules and area boundaries for sanitation service pickup such as curbside trash, recycling, yard waste, and bulk trash. Used in the QAlert Citizens Request Management (CRM) software and applications.
SDE Feature Class
dataset
EPSG
5.3(9.0.0)
57
Simple
FALSE
57
TRUE
FALSE
20201116
/9j/4AAQSkZJRgABAgAAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0aHBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iiigAooooAKKKKACsvV22iM9+grUrO1AZvbXPT5v5VnVbUG4hdLVmXHZzzsxdjEB0BXOatWrRwQ+W0q5ViOeKt0VwczasZSk5O7Id6PcJtYNhTnB+lTUUUhBRRRQAUUUyRikZYdR60APqOaRYoyzMF7Akd6MTf3o/8Avk/41Q1F5SFhBQk/MRjFA4x5nYqqJpDK0kwZj8ocDGPpRGlxEyuk/wA6gjleuafA26MZABHBA6VJmu6FL3fe3Nm1ay2GT3l1sZmdEQJyAM5960olkMSHzeqj+Gsq7ANrIO201r2xzaxH1QfyrCvBQtYykrCN5iSR5fIJwRipqinYJsYnADDtS+fH6n/vk1gSSVHH80kj++0fQf8A180hmBB2hie3FPRdiBfTqfU0AQX8vlWcjZwSMD6mqVm6LcQhWU4YAc1LquXEUQPBbceM9Kr2y7LmBTgkyDnAFdmHVo3LijqaKKK6CwooooAKKKKACiiigAooooAKKKKACiiigAooooAKxNdGZ7YZ6k1t1ka0rl4GBbYM7lXqaT2Ar6aojaZBnHB5OfWr9c+lwyXbiN54QwAwwByRn2rTtbyM26+dOu8cHJANcNSDvzdzNrqJqrutvGFJCvIFcgdsE/0FUUWNuATn0ya1ftttuC+cmT71WuzaSsHMr+YBgeWf8inTny6NAmRQyS2xYRhCrc/MTxU1nPNNdyh2BUKOB0BrOlaRGLoHZQpPzsOvbgCtezg8mInfuL/MTVVlFK6WrCRZqOf/AFLVJTZF3RsM4rnJHVlTNvu5W9CFH4D/ABqW4v5beOFvKV/NfYAGxjr3/Cq6Z+Zm+8zFjj3rSlF88Wa01uyK2OVkx/fNTdqhtQAJOv3zU/FegMikQyRsgxkjHNaFhPvhWJkKtGig5PXiqRBKNt4OOD6VBJDMTlLhkJAGRkfyNZVafOtCZK5tzdF/3x/OpKyY7i4JWKeT+NQrIuM8985rQZWRSTM/5D/CuKUXF2Zm1YmoqFIn2jfM5P4D+lO8hfV/++z/AI1IFO+/4+ox/sE/rTbbYbyENjO7jNJdKEvRtz9zuSe/vUcLZ1O04HUnNd9D4EaR2OnooorUoKKKKACiiigAooooAKKKKACiiigAooooAKKKKACsvV/+Wf41qVmat/yzoAyDgnkZpAFzyo/KpMCkxjnpQIaqr8wwPyoAA5Ap4GQee1MyVP8AjTAU89aQTXsYCRSpsAwAy80bz7flUNwzbV/3hUypp7iumP8A7RvFbEhYAdSI8irlncrcxlZLj95uIK9DjNQFsc4pCqPyVU/UVlOhFrTQLJ7E1/JH5kMXyhU+bJI9CKjVlYZUgjPY1znibSP7S06YJbmaZOIYUfy9xPfd9Ae3epvCekT6PpTxzkh5ZTJ5e8uIwei5PWqpUVyc/MtHa3X/AIY0jyKFtb+mn33/AENsvFHxlVPeoTMw/wCWkWPrU7IrHLKDkdxTfJhHSNP++a0JI0keTOx0OO1TLnYN2M+1ARVBKqAfYUo+7QAjZyrLjKsGwfY1dtpnumYuoVYzjg9Tj/69U8H1NWtOztnz/wA9P/ZRXPiIq3MRIu0UUVxkGbdrJ9rZhE7LtABVSajt1ddRhd4nVMgZKkc5rWqKY/vbceso/ka3p1ZK0UUpGrRRRXaaBRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAVj62xXysMFJyK2Kx9cjMnkYAOGzzQBjeZIWxubnH8NWEDBfmO4/SnA5pc0AJu6jB6UwjJ70yaRlCsvGWA/CpTnrmgTG4HrUM5C7MAnLYp7xOzZWQqPTFCwuTzKePYVVybakpAIpudpwaRFZM7mLfhSkbnqG7K5SWokcZVyxbPXHtUlA449qBWdGNo376ly3shokDEqM5Xg06oIMefPx0IqetSQzimQyCWIOAQDTzwDUVrk2ydaAJatad0uB/00/wDZRVPzFK7weB1NSWtykNyQWGyQdfQ/5/lWFdXgTLY1aKZ50f8AfFJ50fqfwBriMySq0hzqNqvYZJ/TH9alE8Z6Fv8Avk/4VWVw+rLjPCr1GO5ragr1EBu0UUV3GwUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFZGtrI3l7HC8HPFa9Zer/APLOgDFEM2T++OMelSRxuh+aQv8AWn5oNAFe6O0R5IA8wdqsYDDH61HIsbAeYCQDkDGeaXDk5EUn/fBFJyS3Ym7ETwN8qid/c+vNKtse8zsPc1KFkHWKTP8Au04CXtBIf+A0uePcEyv9m4GZHODnJNNKS7ikW8hFyTWN4vm12zsIZ9MC28aufPlmAO1cHGAMk846V1GhW1zb6TB9ukEt26hpXC4BPpis691TUlaz8+3kVeKjzJ69tf8AhirAWYHdk5GQSKkxxUk8PkTkD7j5K+x9KYOBjNaQkpK6JWpXgXE85AHUVOQaYTE42b8Mf7p5oECgf6yTGPWqGPJbB4pgBjjKgk7R1PU1CSmSsUkjsO26rLAmMgfex3oArwoz2p7bsnBrZjeOe3D4UZXJHpxWRtnESBSgf+LI/lS26zi+wNgQgghRzgnv+tYV4XXN2JkjajH7tcgZxT8UAYAHpR0Ga4jMjh5Qn+8SarRndqrH0YL+mf61Zh4gXPpVOzO66Df3pCf1rpwqvNsTOgooorrNwooooAKKKKACiiigAooooAKKKKACiiigAooooAKytYI/dVq1jeIFLRRAAk5zxQBRzx0pu8Drx9aUDNQiGZZxKJwcZwrJkUne2gEiurTxBTzvFbVZEc1yJow0keC2Dtiwf51p+Uf+er/p/hXFWu5e8ZyJKKj8o/8APWT9P8KPK9Xf86xJKV4PtV9Da9UX53H+fy/GtGq1tbxo8kyg7nPUnPH+RVmklYbd7Igu4xJBtPGWGCO3NUZIpYM+YuUBwHFaM/8AqifQg/rUnUc1pCo4bAnYwxCS4feMfSpHVXTa3IPHFW3sYfNXBdQ2funoaamnx+Y4MkpAI7j0+ldP1iPYrnKihI8RxryegA606MSSsyIh3A4OegrUigjhGI1x796Iejf7x/nWcsRJ7C5ih9kuTxtUe+6pre1MM3zuGY85AxwOn8zV2o05lkPphf0z/Ws5VZS3E22SUyYhYXJ9MU+isxEDzxxwElhwtVrAESwg9RjNT3wUWkgwMkYHHeo7T/j5j+td2EWjZL3Ru0UUVsdAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFZmrdY606zNW6xmgDKpaYxOSQeKRTz1pXESZxLEf9sVdvLiSAxiMKSxP3qy7okxDaWVgwIKjJHNTHJKs8juR03VjOlzTT6CauyU3tx3aIfhV2GQy2aSNjLJk4qpZRRSSTb1DEY69qvlQsRVQAAOAK56nKnZIh2Ei/1Sf7op9Ni/1Sf7op1ZCI5/9Q/spNSDpUc//HvJ/un+VSDpQBHJ/rIv94/yNC/69/oDRL1Q/wC0KOlwxPTYP5mgB7EKCT0FNiUhOepJOPrSL+8O4/dHQevvUlABUcPR/wDeNSVHEcBz23HBoAkophljHWRR+NJ58P8Az1j/AO+hQBBfn93Gvq4/Sm2n/HxH/vUy9lR5IVR1YgknBz2p9p/x8R/71ejhVamQ9zdoooqzpCiiigAooooAKKKKACiiigAooooAKKKKACiiigArH11JHEQjcIfUjNbFY+vnEKHOMd6AMyNG2fvCCTzxUmB6UkfMan2FKKAILoZh29PmHNP8+IAc/pT2HSl25HSgCIzRhtyyOpPB2sRmtSyYy2MTMSxZBknqayAwW5myRwoOK1dOYPYRFemOK5cQkkmRMmEWAAJGwPejyj/z0f8AOpKK5bkETQllKmRsEYNN8s+cVMj42g9anqM/8fA91oAQwK2Ms/Bz981H5CyPkNJt6E7zzU0xwn1IB/OngADA6UXAi8hf70n/AH2aXyI+4J+pqSii4EX2eE9Y1P1FKIIlAxGvHtTnfYhbGcdvWmCcEDKSA+mw0agSBVHQAVGgDSyNjphfy/8A104TIWC/MCem5SM/nSQ/6v8A4E38zQBVvcefF9DS2n/HxH/vUl7/AMfEf+6aW1/4+I/rXp4b+EQ9zdooopnSFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABWZq/8AyyrTrI1syjyvLVT16mgDPH3aBmqqLfzXflxJHsABdi3TOf8ACtH7DP3kQfgazlVhF2YnJIgPSg81LJYzLGzecowCfu05dPlwCbn/AMc/+vU+3gLmRnEos8pbIwuSa19PBFmmRjriqx05nkdDOR8o5C4POauxxSRxqgmyFGMleawrVFPYmTuTUVBH5roCZB1PRfeiMM2QZW3A8j0rCxJPUbf69PoaPKP/AD0f86jePE0ZMr9D3oAkn/1R9iDUlQeWsqcTOVPoaf5WP+Wsn50ASUVXzAf+W27/AIFR+4/2j9M0WAkm+6v++v8AOpKgHlBgQjkjp8pp/mN/zyb8xQA9lVhhgCPQ1EEWOVVjUKDkkAU7zH/54t+Y/wAajjmUszuGU5xyOgHvQBXuzm7Ueif1qS1/4+I/rUErrJdyFSCAAM1Pbf8AHxH9a9XDq1JGb+I3KKKKR1BRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAVl6v/wAs61KytZO1EbjjNAEOnqotdwUBmZsnufmNW6q6cwawjYdCWP8A48atV5kt2YvcZN/qJP8AdP8AKnL90fSmzf6iT/dP8qcv3R9KQDF/4+H/AN0f1qSo/wDl4Hup/nUlAEcH+qH1P86V1JIZcbh696SD/V49Cf51JQBHmVvlwFP97rUfzT/Iy7SuNxz/ACqxUcf+skz1J/pQAxoo2uVygzsPOOeopxiO0jzH246Z/r1pT/x8L/un+lSUAQRRfulw7j/gVPxKvRgw/wBrrRB/qV/GpKAI/OA++Cp+maeGDDIINLTGj5yh2n+dAD6jj/1kv+9/QUZm/up+Zp0alVOepOTQBnS83kpHsKntv+PmP61X6zy/75qxbf8AHzH9a9eirU0Zv4jcoooqDqCiiigAooooAKKKKACiiigAooooAKKKKACiiigArK1rO1OD0PStWsrWM5j/ABoAq2Mhjs41yh6nJfnk59Kn85v7yD/gJNJZKptIztHT096s4HpXmPcxKskrmNhkEYOcIen4mpQ7kDbH/wB9HFOm/wBTJ/un+VNWLKj95J09aAExKZQ21Rxj72adib+8n/fJ/wAaISTEMkk5PJ+tSUgK8Im8vO5OSf4T6/WnOJFQt5n5AU6D/VD6n+dEpB2Lnqwp9QAJJgZlOfYD/Co443dEkMz7ivYD/CrFRwf8e8f+6KQCGFiwbznyPYf4Uvlv/wA9n/If4VJRRcCK3/1C856/zqWo4P8AUr+P86koYBRRRQAUUUUAZa/62X/fNWLb/j5j+tVouSx9WJqzbf8AHzH9a9mn/DRl9o3KKKKyOsKKKKACiiigAooooAKKKKACiiigAooooAKKKKACsvV/+Wf41qVl6xwqcZ60ARWBzZRkHPX+ZqzWfpbSjT41MRyCw5I9TVzMp/hUfU15klqzFjpOY2+hoj/1a/SmETEEYj5+tIqShAC6rgdhSARHMShWRvvYzxjk1PVH7bbrMq7nkO4LnqATx1q9TaAqRDKfNHI3JwRxjn61INqnK27A+oA/xp8PCEehNSUNgR+Y3/PJ/wAcUW//AB7x9vlFSVEsTqMCTjt8tICWio9kn/PX/wAdpYmLKdx5BIoASD/Ur+P86krIN1cea6ROqojYwVzTvtN0f+Wy/wDfArVUZvVFcrNWisQXdy1y0Zn4C54Wnme4z/rmqlhpsTVjYoPAzWN51wf+W70CWdjjzn/Oj6tO9hW6j4OYwatW3/HzH9arxqEQAdqsW3/HzH9a9NK0bGX2jcooorE6wooooAKKKKACiiigAooooAKKKKACiiigAooooAKy9XAJi5xRRWVabhDmRdOKlKzKEFzJbpsMYdMkgg4Iyc/jVkX8Bj3HcD/cI5oorKdKOj7mUopMrNqrbtqxxgk4GZOfyxUUuoPNE0B2LIxIJzjiiiqlSjG1hcqITAz7dr7CpDDHt0qy11ctG2ZFUgdUTB/XNFFaunF6tFWRftf+PaMkksygknuamoorznuZBRRRQAVGnE0g9cN+mP6UUUAYwP8Apl0pOcSU/FFFelD4UarYasREzSccjApkRkKnzMFgcHFFFWmDVyVuDxSxcsTRRTj8RnPYnHSprb/j5j+tFFbPYwW5uUUUVznYFFFFABRRRQAUUUUAFFFFAH//2Q==