Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1127 | 1127 | 188687 | DPW Maintained 3 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 1300 Evans Ave | 30 | : 4 | Tree 1 | DPW 2 | 03/18/2017 12:53:00 PM | 3 | Width 4ft | 6017556.40659 | 2097171.27575 | 37.7394173230594 | -122.381820390005 | (37.7394173230594, -122.381820390005) | ||
| 1132 | 1132 | 188688 | DPW Maintained 3 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 1300 Evans Ave | 37 | : 4 | Tree 1 | DPW 2 | 03/18/2017 02:16:00 PM | 3 | Width 4ft | 6017441.41972 | 2097257.16832 | 37.739646816543996 | -122.382223941884 | (37.739646816544, -122.382223941884) | ||
| 1134 | 1134 | 188691 | DPW Maintained 3 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 1300 Evans Ave | 45 | : 4 | Tree 1 | DPW 2 | 03/18/2017 02:26:00 PM | 3 | Width 3ft | 6017107.93008 | 2097506.97635 | 37.740314314066296 | -122.38339440233999 | (37.7403143140663, -122.38339440234) | ||
| 1139 | 1139 | 188692 | DPW Maintained 3 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 1300 Evans Ave | 46 | : 4 | Tree 1 | DPW 2 | 03/18/2017 02:33:00 PM | 3 | Width 3ft | 6017090.76081 | 2097520.28707 | 37.7403499137184 | -122.383454693803 | (37.7403499137184, -122.383454693803) | ||
| 1145 | 1145 | 188690 | DPW Maintained 3 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 1300 Evans Ave | 44 | : 4 | Tree 1 | DPW 2 | 03/18/2017 02:23:00 PM | 3 | Width 3ft | 6017127.64655 | 2097493.15124 | 37.7402774427419 | -122.383325267851 | (37.7402774427419, -122.383325267851) | ||
| 1158 | 1158 | 190438 | DPW Maintained 3 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 1350 Evans Ave | 4 | : 4 | Tree 1 | DPW 2 | 03/18/2017 11:59:00 AM | 3 | Width 3ft | 6016891.21359 | 2097667.15217 | 37.740742144938395 | -122.38415488076001 | (37.7407421449384, -122.38415488076) | ||
| 1167 | 1167 | 190439 | DPW Maintained 3 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 1350 Evans Ave | 6 | : 4 | Tree 1 | DPW 2 | 03/18/2017 11:54:00 AM | 3 | Width 3ft | 6016857.78658 | 2097692.82931 | 37.740810800972206 | -122.384272247659 | (37.7408108009722, -122.384272247659) | ||
| 4317 | 4317 | 37823 | DPW Maintained 3 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 450X Moscow St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/11/2017 09:49:00 AM | 3 | 3x3 | Permit Number 40134 | 6003922.69393 | 2090463.29382 | 37.7202364196636 | -122.428481771941 | (37.7202364196636, -122.428481771941) |
| 4356 | 4356 | 161318 | Undocumented 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 530 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2017 08:04:00 AM | 3 | Width 0ft | 6002775.65928 | 2090671.8623400002 | 37.7207441256113 | -122.432461575944 | (37.7207441256113, -122.432461575944) | |
| 9409 | 9409 | 6541 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 1201 Evans Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/1997 12:00:00 AM | 3 | 4X4 | 6017765.684627299 | 2096901.7583544997 | 37.7386888362962 | -122.381078057558 | (37.7386888362962, -122.381078057558) | ||
| 10118 | 10118 | 6477 | DPW Maintained 3 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 1200X Evans Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/26/2004 12:00:00 AM | 3 | 3x3 | 6017471.90101 | 2097239.05901 | 37.739598775511496 | -122.382117290159 | (37.7395987755115, -122.382117290159) | ||
| 13203 | 13203 | 174953 | Undocumented 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 42 McLea Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010005.0 | 2109213.0 | 37.7720613219198 | -122.408779264004 | (37.7720613219198, -122.408779264004) | ||||
| 17863 | 17863 | 95395 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 132 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2010 12:00:00 AM | 3x3 | Permit Number 767268 | 6004263.4 | 2101646.1 | 37.750961152597 | -122.42810057740101 | (37.750961152597, -122.428100577401) | |
| 17999 | 17999 | 108986 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 58 Belcher St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773047 | 6003766.0 | 2108010.7 | 37.768408671310205 | -122.430274662073 | (37.7684086713102, -122.430274662073) |
| 42978 | 42978 | 95737 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 445 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767484 | 6003120.3 | 2091142.7 | 37.7220564786865 | -122.431303852024 | (37.7220564786865, -122.431303852024) | |
| 53237 | 53237 | 81207 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 939-941 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50562 | 6009973.59973707 | 2103738.09495501 | 37.757026722335894 | -122.408501615607 | (37.7570267223359, -122.408501615607) | ||
| 63653 | 63653 | 108918 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 566 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772703 | 6007660.3 | 2096715.1 | 37.737613331157604 | -122.41600457408899 | (37.7376133311576, -122.416004574089) |
| 69888 | 69888 | 87784 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 48 Santa Ysabel Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50524 | 6000929.5 | 2093152.6 | 37.727450804928395 | -122.439020861215 | (37.7274508049284, -122.439020861215) | |||
| 78458 | 78458 | 87453 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 525 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/2008 12:00:00 AM | 3 | 3x3 | 5999059.32842 | 2111007.41675 | 37.7763691743336 | -122.446770200329 | (37.7763691743336, -122.446770200329) | ||
| 78670 | 78670 | 19058 | DPW Maintained 3 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 158 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/24/1996 12:00:00 AM | 3 | 3X3 | 5995383.9525713 | 2087445.9177403 | 37.7114645146324 | -122.457778951555 | (37.7114645146324, -122.457778951555) | ||
| 79161 | 79161 | 58296 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 330X Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50790 | 6002931.08600513 | 2106457.89008419 | 37.764097707139 | -122.43305159399598 | (37.764097707139, -122.433051593996) | |
| 79815 | 79815 | 82645 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 56 Julian Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52215 | 6006376.13216739 | 2107553.16833294 | 37.7672998944856 | -122.42121394313801 | (37.7672998944856, -122.421213943138) | |
| 80733 | 80733 | 95537 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 4215 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767325 | 6002474.0 | 2101197.0 | 37.749626627042296 | -122.434256385957 | (37.7496266270423, -122.434256385957) | |
| 83142 | 83142 | 96776 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 226 27TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2011 12:00:00 AM | Permit Number 767240 | 6004896.0 | 2100216.0 | 37.7470701993865 | -122.425811201312 | (37.7470701993865, -122.425811201312) | |||
| 83501 | 83501 | 95584 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 202 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767374 | 6004110.0 | 2102157.0 | 37.7523552842072 | -122.428667464963 | (37.7523552842072, -122.428667464963) | |
| 83761 | 83761 | 97253 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 364 Banks St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | Permit Number 768268 | 6008584.5 | 2096981.4 | 37.7383964511341 | -122.412827985209 | (37.7383964511341, -122.412827985209) | |||
| 84023 | 84023 | 84460 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 698X 19th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52659 | 6009314.54246303 | 2104977.65271839 | 37.760393335954795 | -122.41086843864099 | (37.7603933359548, -122.410868438641) | ||
| 84318 | 84318 | 114974 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 23 Holloway Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/28/2015 12:00:00 AM | Permit Number 775981 | 5996745.4 | 2091181.1 | 37.7217985747524 | -122.45334295571999 | (37.7217985747524, -122.45334295572) | |||
| 84726 | 84726 | 96063 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 2 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767689 | 6007319.1 | 2099659.7 | 37.745679358438004 | -122.417392885985 | (37.745679358438, -122.417392885985) | |
| 85779 | 85779 | 110615 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 200 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 12/31/2015 12:00:00 AM | 3 | 13.2x7.8 | Permit Number 773269 | 6008108.0 | 2112443.0 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | |
| 86850 | 86850 | 79383 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 339 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2015 12:00:00 AM | Permit Number 775296 | 6004813.357421299 | 2101815.69281838 | 37.7514579152774 | -122.426210842735 | (37.7514579152774, -122.426210842735) | ||
| 87170 | 87170 | 82614 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 80X Julian Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52215 | 6006376.13216739 | 2107553.16833294 | 37.7672998944856 | -122.42121394313801 | (37.7672998944856, -122.421213943138) | |
| 87615 | 87615 | 43361 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 1100X Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 3 | 5x6 | Permit Number 769743 | 6003157.69483217 | 2101814.87307727 | 37.751361942995 | -122.431936260805 | (37.751361942995, -122.431936260805) |
| 88315 | 88315 | 108412 | Undocumented 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 99x HYDE ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008108.0 | 2112443.0 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | ||
| 88431 | 88431 | 95397 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 1211 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767271 | 6003877.0 | 2101229.0 | 37.7497940241726 | -122.42940704496701 | (37.7497940241726, -122.429407044967) | |
| 88575 | 88575 | 6575 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 1331 Evans Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/2009 12:00:00 AM | 3 | 3X3 | 6017079.2770781 | 2097404.6143377 | 37.7400316650274 | -122.38348634984699 | (37.7400316650274, -122.383486349847) | ||
| 88921 | 88921 | 37694 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 587 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52664 | 6007904.99529024 | 2104523.82497992 | 37.7590680918379 | -122.415711288385 | (37.7590680918379, -122.415711288385) | ||
| 89029 | 89029 | 82764 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 326 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50236 | 6009628.04821978 | 2099623.52632894 | 37.7457096736308 | -122.40940629959 | (37.7457096736308, -122.40940629959) | ||
| 90497 | 90497 | 41383 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 3995 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/07/2004 12:00:00 AM | 3x3 | Permit Number 771193 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | ||
| 91577 | 91577 | 36710 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 56 Julian Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52215 | 6006374.23290867 | 2107587.4469069 | 37.7673939082567 | -122.42122294679501 | (37.7673939082567, -122.421222946795) | |
| 91663 | 91663 | 87201 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 198 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 776030 | 5992637.0 | 2097914.0 | 37.7400491012762 | -122.468034007919 | (37.7400491012762, -122.468034007919) | ||
| 91719 | 91719 | 82266 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 366 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50238 | 6009458.6336342 | 2099613.92832895 | 37.7456738259394 | -122.409991435275 | (37.7456738259394, -122.409991435275) | ||
| 92155 | 92155 | 109775 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 1530 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775056 | 5992490.0 | 2105022.4 | 37.7595584460972 | -122.469059468108 | (37.7595584460972, -122.469059468108) |
| 92393 | 92393 | 108411 | Undocumented 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 99x HYDE ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008108.0 | 2112443.0 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | ||
| 92796 | 92796 | 84815 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 716 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2007 12:00:00 AM | 5 | 4x4 | Permit No. 49227 | 6001220.0 | 2102216.0 | 37.75235330164271 | -122.438665759041 | (37.7523533016427, -122.438665759041) | |
| 92865 | 92865 | 95632 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 84 Cumberland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767399 | 6005074.0 | 2104592.0 | 37.759095734776395 | -122.425507072647 | (37.7590957347764, -122.425507072647) | |
| 92939 | 92939 | 95643 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 1430 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/07/2011 12:00:00 AM | 3x3` | Permit Number 767411 | 6009341.0 | 2118148.0 | 37.7965574803307 | -122.411707541294 | (37.7965574803307, -122.411707541294) | |
| 93239 | 93239 | 72659 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 56 Julian Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52215 | 6006374.23290867 | 2107587.4469069 | 37.7673939082567 | -122.42122294679501 | (37.7673939082567, -122.421222946795) | |
| 94142 | 94142 | 96162 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 130 Newman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767794 | 6007212.0 | 2096763.0 | 37.737719638878396 | -122.417557958394 | (37.7377196388784, -122.417557958394) | |
| 95269 | 95269 | 82731 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 328 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50237 | 6009619.57749446 | 2099623.04642916 | 37.7457078813161 | -122.40943555637399 | (37.7457078813161, -122.409435556374) | ||
| 95328 | 95328 | 87033 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 30 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/2010 12:00:00 AM | 3x3 | Permit Number 53735 | 6001416.0 | 2107932.0 | 37.7680591923974 | -122.43839744289 | (37.7680591923974, -122.43839744289) | |
| 95875 | 95875 | 88258 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 327 Carl St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51243 | 5996646.0 | 2106962.0 | 37.7651233493989 | -122.454826175676 | (37.7651233493989, -122.454826175676) | |||
| 96653 | 96653 | 94823 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 1247 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53903 | 5990745.7 | 2106901.7 | 37.764617562031496 | -122.475229262837 | (37.7646175620315, -122.475229262837) | |
| 97103 | 97103 | 24936 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 2099X Post St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/21/2007 12:00:00 AM | 36 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | ||
| 97133 | 97133 | 84456 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 2800 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52651 | 6009557.23570783 | 2105031.47254004 | 37.760554718378 | -122.410032871336 | (37.760554718378, -122.410032871336) | ||
| 97295 | 97295 | 88246 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 4343 17th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51232 | 6000519.0 | 2105766.0 | 37.762060831404796 | -122.44134462504 | (37.7620608314048, -122.44134462504) | |||
| 97403 | 97403 | 35400 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 527 30th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2008 12:00:00 AM | 3x3 | Permit Number 50782 | 6003213.78352736 | 2098311.09733417 | 37.7417445720019 | -122.431492193982 | (37.7417445720019, -122.431492193982) | ||
| 97506 | 97506 | 82648 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 56 Julian Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52215 | 6006376.13216739 | 2107553.16833294 | 37.7672998944856 | -122.42121394313801 | (37.7672998944856, -122.421213943138) | |
| 97824 | 97824 | 114981 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 115 Moncada Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2015 12:00:00 AM | Permit Number 776112 | 5992157.9 | 2093028.6 | 37.7266073370069 | -122.46933501824199 | (37.7266073370069, -122.469335018242) | |||
| 98249 | 98249 | 114693 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 436 Hamilton St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/2015 12:00:00 AM | Permit Number 774634 | 6009470.9 | 2092282.5 | 37.7255439885799 | -122.40943170543501 | (37.7255439885799, -122.409431705435) | ||||
| 98463 | 98463 | 60630 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 470 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 772107 | 6003622.94051992 | 2096160.25019953 | 37.735862019508204 | -122.42992407832399 | (37.7358620195082, -122.429924078324) | |
| 98820 | 98820 | 84461 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 714-716 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52661 | 6010104.93425212 | 2104957.66520048 | 37.760382742210204 | -122.408133417925 | (37.7603827422102, -122.408133417925) | ||
| 99058 | 99058 | 114988 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 1020 Ulloa St | 2 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 12/30/2015 12:00:00 AM | Permit Number 773462 | 5992930.8 | 2098449.5 | 37.741536411656604 | -122.467057099516 | (37.7415364116566, -122.467057099516) | |||
| 100340 | 100340 | 88026 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 200 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008175.0 | 2112425.0 | 37.78077804050471 | -122.415336822355 | (37.7807780405047, -122.415336822355) | ||
| 100531 | 100531 | 108438 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 200-212X Lexington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772675 | 6006463.9009300005 | 2104927.47787 | 37.7600953129132 | -122.42072394127399 | (37.7600953129132, -122.420723941274) |
| 101024 | 101024 | 43224 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 1682 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52405 | 5990924.01024208 | 2103958.73208826 | 37.756547288964796 | -122.474397763174 | (37.7565472889648, -122.474397763174) | ||
| 101246 | 101246 | 91576 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 576 Sanchez St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/2009 12:00:00 AM | 3x3 | Permit Number 52611 | 6003627.0 | 2104921.0 | 37.7599172257375 | -122.43053496073601 | (37.7599172257375, -122.430534960736) | ||
| 101338 | 101338 | 110613 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 200 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 04/27/2015 12:00:00 AM | 3 | 12.8x7.8 | Permit Number 773269 | 6008108.0 | 2112443.0 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | |
| 101803 | 101803 | 96168 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 617 Tompkins Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767800 | 6008684.2 | 2096511.3 | 37.7371112545774 | -122.412450049968 | (37.7371112545774, -122.412450049968) | |
| 101924 | 101924 | 106975 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 1020 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/2015 12:00:00 AM | Permit Number 773462 | 5992930.77277 | 2098449.45466 | 37.7415362855926 | -122.467057190372 | (37.7415362855926, -122.467057190372) | |||
| 102512 | 102512 | 14519 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 607 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/1999 12:00:00 AM | 8 | 3X3 | 5999088.24175 | 2110697.41803 | 37.775519649006796 | -122.446647872043 | (37.7755196490068, -122.446647872043) | ||
| 102942 | 102942 | 55735 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 2257 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | Permit Number 775540 | 6002523.01452093 | 2107055.09703548 | 37.765714336292 | -122.434505696133 | (37.765714336292, -122.434505696133) | |||
| 103599 | 103599 | 87856 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 330X Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50790 | 6002852.8 | 2106288.8 | 37.7636289858331 | -122.433310278834 | (37.7636289858331, -122.433310278834) | |
| 103742 | 103742 | 92227 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 587 Shotwell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52664 | 6008031.3 | 2104525.5 | 37.7590797904057 | -122.41527458403401 | (37.7590797904057, -122.415274584034) | ||
| 103873 | 103873 | 110454 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 7630 Geary Blvd | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 04/15/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774506 | 5983294.7 | 2112541.2 | 37.7796673212814 | -122.501417065582 | (37.7796673212814, -122.501417065582) | |
| 105233 | 105233 | 36711 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 56 Julian Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52215 | 6006374.23290867 | 2107587.4469069 | 37.7673939082567 | -122.42122294679501 | (37.7673939082567, -122.421222946795) | |
| 105878 | 105878 | 1404 | DPW Maintained 3 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 63 Ardath Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/30/1996 12:00:00 AM | 6 | 3X4 | 6017388.835420901 | 2095314.9218022998 | 37.7343108905935 | -122.382270670557 | (37.7343108905935, -122.382270670557) | ||
| 106916 | 106916 | 26749 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 2099X Post St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 09/28/1999 12:00:00 AM | 3 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | ||
| 107139 | 107139 | 82886 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 761 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52437 | 6009240.34446046 | 2110165.45314704 | 37.7746336766823 | -122.41149158097299 | (37.7746336766823, -122.411491580973) | ||
| 107174 | 107174 | 95631 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 47 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767397 | 6003332.1 | 2102812.2 | 37.7541102528563 | -122.431404335591 | (37.7541102528563, -122.431404335591) | |
| 107281 | 107281 | 108413 | Undocumented 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 99x HYDE ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008108.0 | 2112443.0 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | ||
| 107725 | 107725 | 87906 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 29 Gladys St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50926 | 6005790.0 | 2097546.0 | 37.7397894643754 | -122.422530125788 | (37.7397894643754, -122.422530125788) | ||
| 108356 | 108356 | 82201 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 3236 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/21/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49903 | 6006735.54842487 | 2103815.93628153 | 37.75705858412879 | -122.41970557148399 | (37.7570585841288, -122.419705571484) | |
| 108537 | 108537 | 6643 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 1499 Evans Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/17/2009 12:00:00 AM | 3 | 3X3 | 6016187.3727289 | 2098094.9741145 | 37.7418779170755 | -122.386618343631 | (37.7418779170755, -122.386618343631) | ||
| 109455 | 109455 | 73311 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 3993 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769743 | 6003233.13125919 | 2101819.03684703 | 37.7513776519742 | -122.431675690307 | (37.7513776519742, -122.431675690307) |
| 110868 | 110868 | 96775 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 226 27TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2011 12:00:00 AM | Permit Number 767240 | 6004896.0 | 2100216.0 | 37.7470701993865 | -122.425811201312 | (37.7470701993865, -122.425811201312) | |||
| 111575 | 111575 | 94128 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 420 Holladay Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53495 | 6010221.9 | 2098587.9 | 37.7428993246027 | -122.407279845082 | (37.7428993246027, -122.407279845082) | ||
| 111739 | 111739 | 113258 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 56 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/2015 12:00:00 AM | Permit Number 776598 | 6004861.1 | 2096154.7 | 37.7359168212577 | -122.42564287438 | (37.7359168212577, -122.42564287438) | |||
| 112361 | 112361 | 88245 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 4343 17th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51232 | 6000519.0 | 2105766.0 | 37.762060831404796 | -122.44134462504 | (37.7620608314048, -122.44134462504) | |||
| 112409 | 112409 | 108414 | Undocumented 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 99x HYDE ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008108.0 | 2112443.0 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | ||
| 112987 | 112987 | 91575 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 576 Sanchez St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/2009 12:00:00 AM | 3x3 | Permit Number 52611 | 6003627.0 | 2104921.0 | 37.7599172257375 | -122.43053496073601 | (37.7599172257375, -122.430534960736) | ||
| 113899 | 113899 | 46901 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 1490 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/10/2015 12:00:00 AM | Permit Number 775424 | 5991189.27223217 | 2105275.5936987 | 37.7601784073134 | -122.473576456034 | (37.7601784073134, -122.473576456034) | ||
| 114874 | 114874 | 88025 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 200 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008175.0 | 2112425.0 | 37.78077804050471 | -122.415336822355 | (37.7807780405047, -122.415336822355) | ||
| 115553 | 115553 | 88575 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 562 18th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 3x3 | Permit Number 51515 | 5990373.3 | 2111545.8 | 37.7773474033188 | -122.47685663061 | (37.7773474033188, -122.47685663061) | |||
| 116033 | 116033 | 19102 | DPW Maintained 3 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 286 Sagamore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2000 12:00:00 AM | 3 | 3X3 | 5994140.1842159005 | 2087463.5149143 | 37.7114413003767 | -122.46207898212499 | (37.7114413003767, -122.462078982125) | ||
| 116334 | 116334 | 108435 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 3467 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772675 | 6006465.10924 | 2104925.0907400004 | 37.7600888265129 | -122.42071959283199 | (37.7600888265129, -122.420719592832) |
| 117352 | 117352 | 72661 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 56 Julian Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52215 | 6006374.23290867 | 2107587.4469069 | 37.7673939082567 | -122.42122294679501 | (37.7673939082567, -122.421222946795) | |
| 117961 | 117961 | 65682 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 1301 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50609 | 6005842.98381939 | 2101391.5473786 | 37.75035145285079 | -122.422620128615 | (37.7503514528508, -122.422620128615) | ||
| 118622 | 118622 | 65507 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 169 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2015 12:00:00 AM | 3 | Permit Number 775100 | 6005433.48243483 | 2100181.63700927 | 37.747006205468004 | -122.423950186936 | (37.747006205468, -122.423950186936) | ||
| 119190 | 119190 | 67634 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 198 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 776030 | 5992640.98676311 | 2097929.31580717 | 37.740091384847496 | -122.468021337222 | (37.7400913848475, -122.468021337222) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");