trees
169 rows where qSpecies_id = 3 sorted by SiteOrder
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
161070 | 113256 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 45 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/2015 12:00:00 AM | Permit Number 776597 | 6004879 | 2096228.3 | 37.7361199217499 | -122.425586223473 | (37.7361199217499, -122.425586223473) | 2 | 7 | 5 | 28859 | 2 | |||
162147 | 174953 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 42 McLea Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010005 | 2109213 | 37.7720613219198 | -122.408779264004 | (37.7720613219198, -122.408779264004) | 14 | 2 | 9 | 28853 | 34 | ||||
165528 | 108435 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 3467 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772675 | 6006465.10924 | 2104925.09074 | 37.7600888265129 | -122.420719592832 | (37.7600888265129, -122.420719592832) | 2 | 4 | 7 | 28859 | 19 |
166075 | 67634 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 198 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 776030 | 5992640.98676311 | 2097929.31580717 | 37.7400913848475 | -122.468021337222 | (37.7400913848475, -122.468021337222) | 1 | 8 | 4 | 59 | 40 | ||
166290 | 95793 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1115 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767536 | 6010282 | 2102727 | 37.7542677476114 | -122.407363767722 | (37.7542677476114, -122.407363767722) | 10 | 4 | 7 | 28859 | 19 | |
170572 | 65507 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 169 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2015 12:00:00 AM | 3 | Permit Number 775100 | 6005433.48243483 | 2100181.63700927 | 37.747006205468 | -122.423950186936 | (37.747006205468, -122.423950186936) | 2 | 7 | 5 | 28859 | 22 | ||
174021 | 117327 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1762 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2016 12:00:00 AM | 3 | Permit Number 778536 | 5992852.9 | 2103474.1 | 37.7553281792803 | -122.467691786389 | (37.7553281792803, -122.467691786389) | 1 | 8 | 4 | 56 | 12 | ||
175832 | 115290 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 2642 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 774426 | 5991478.6 | 2097428.2 | 37.7386482527839 | -122.472003841981 | (37.7386482527839, -122.472003841981) | 1 | 8 | 4 | 29491 | 40 | |||
178008 | 106812 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 196X WOOL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6007325 | 2097296 | 37.7391894968596 | -122.417205020194 | (37.7391894968596, -122.417205020194) | 2 | 7 | 7 | 28859 | 2 | |||
180108 | 64097 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1275 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2009 12:00:00 AM | 4x4 | Permit Number 53106 | 5992357.42606092 | 2106782.26411484 | 37.7643829076917 | -122.469646088045 | (37.7643829076917, -122.469646088045) | 11 | 8 | 11 | 56 | 12 | ||
183243 | 69522 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 601 Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | Permit Number 768271 | 6008573.55056705 | 2096511.22734842 | 37.7371048449327 | -122.41283261137 | (37.7371048449327, -122.41283261137) | 10 | 7 | 7 | 28859 | 2 | ||
185446 | 95799 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 2737 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767541 | 6010051.6 | 2104518.5 | 37.7591739071678 | -122.408286901595 | (37.7591739071678, -122.408286901595) | 2 | 4 | 7 | 28859 | 19 | |
186303 | 32210 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 85 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/16/2018 12:00:00 AM | 3 | 3x6 | Permit Number 781715 | 6009682.7318 | 2099892.23554 | 37.7464505538497 | -122.409236169516 | (37.7464505538497, -122.409236169516) | 2 | 7 | 7 | 28859 | 2 | |
190887 | 82886 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 761 Clementina St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52437 | 6009240.34446046 | 2110165.45314704 | 37.7746336766823 | -122.411491580973 | (37.7746336766823, -122.411491580973) | 8 | 2 | 9 | 28853 | 34 | ||
193111 | 88024 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 200 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008175 | 2112425 | 37.7807780405047 | -122.415336822355 | (37.7807780405047, -122.415336822355) | 7 | 10 | 9 | 28852 | 36 | ||
193143 | 44206 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 576 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/2009 12:00:00 AM | 3x3 | Permit Number 52611 | 6003624.01893692 | 2104922.29831142 | 37.7599206217144 | -122.430545363422 | (37.7599206217144, -122.430545363422) | 2 | 4 | 5 | 28862 | 3 | |
107040 | 82648 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 56 Julian Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52215 | 6006376.13216739 | 2107553.16833294 | 37.7672998944856 | -122.421213943138 | (37.7672998944856, -122.421213943138) | 8 | 4 | 7 | 28853 | 19 | |
135346 | 108414 | Undocumented 4 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 99x HYDE ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008108 | 2112443 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | 7 | 10 | 9 | 28852 | 36 | ||
128206 | 26749 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 2099X Post St | 11 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 09/28/1999 12:00:00 AM | 3 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | 13 | 6 | 11 | 29490 | 13 | ||
184142 | 6604 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1400 Evans Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6016747.6410828 | 2097755.6169144 | 37.7409771122017 | -122.384657465748 | (37.7409771122017, -122.384657465748) | 10 | 3 | 8 | 58 | 1 | ||
80157 | 24936 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 2099X Post St | 17 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/21/2007 12:00:00 AM | 36 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | 13 | 6 | 11 | 29490 | 13 | ||
194434 | 37829 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 450X Moscow St | 17 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/11/2017 09:54:00 AM | 3 | 3x3 | Permit Number 40134 | 6003878.28183 | 2090416.42534 | 37.7201052157501 | -122.428631950629 | (37.7201052157501, -122.428631950629) | 9 | 7 | 6 | 28861 | 5 |
64293 | 6477 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1200X Evans Ave | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/26/2004 12:00:00 AM | 3 | 3x3 | 6017471.90101 | 2097239.05901 | 37.7395987755115 | -122.382117290159 | (37.7395987755115, -122.382117290159) | 10 | 3 | 8 | 58 | 1 | ||
3 | 121463 | Planning Code 138.1 required 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 415 Oxford St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2020 12:00:00 AM | 3 | 3x3 | Permit Number 778984 | 6006773.54328 | 2092061.724 | 37.7247862819155 | -122.418740608563 | (37.7247862819155, -122.418740608563) | 9 | 7 | 7 | 309 | 28 | |
5926 | 258370 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 998 Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6007899.48346 | 2093470.38454 | 37.7287174922185 | -122.414948012993 | (37.7287174922185, -122.414948012993) | 9 | 3 | 7 | 309 | 28 | |||
9308 | 262183 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 550 Delta St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | ||||||||||||
14304 | 261064 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 4278 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 11/04/2019 12:00:00 AM | 3 | 6002070.44359 | 2101212.56921 | 37.7496464627999 | -122.435653009829 | (37.7496464627999, -122.435653009829) | 2 | 4 | 5 | 28862 | 22 | ||
35005 | 6638 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1499 Evans Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/02/2016 12:00:00 AM | 3 | 3x3 | 6016187.3727289 | 2098094.9741145 | 37.7418779170755 | -122.386618343631 | (37.7418779170755, -122.386618343631) | 10 | 3 | 8 | 58 | 1 | ||
42802 | 95537 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 4215 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767325 | 6002474 | 2101197 | 37.7496266270423 | -122.434256385957 | (37.7496266270423, -122.434256385957) | 2 | 4 | 5 | 28862 | 22 | |
51160 | 96776 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 226 27TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2011 12:00:00 AM | Permit Number 767240 | 6004896 | 2100216 | 37.7470701993865 | -122.425811201312 | (37.7470701993865, -122.425811201312) | 2 | 7 | 5 | 63 | 22 | |||
61129 | 82614 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 80X Julian Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52215 | 6006376.13216739 | 2107553.16833294 | 37.7672998944856 | -122.421213943138 | (37.7672998944856, -122.421213943138) | 8 | 4 | 7 | 28853 | 19 | |
62325 | 6575 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1331 Evans Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2009 12:00:00 AM | 3 | 3X3 | 6017079.2770781 | 2097404.6143377 | 37.7400316650274 | -122.383486349847 | (37.7400316650274, -122.383486349847) | 10 | 3 | 8 | 58 | 1 | ||
85170 | 110614 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 200 McAllister St | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 12/31/2015 12:00:00 AM | 3 | 21.4x7.8 | Permit Number 773269 | 6008108 | 2112443 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | 7 | 10 | 9 | 28852 | 36 | |
89635 | 84456 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 2800 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52651 | 6009557.23570783 | 2105031.47254004 | 37.760554718378 | -122.410032871336 | (37.760554718378, -122.410032871336) | 2 | 4 | 7 | 28859 | 19 | ||
92208 | 87201 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 198 Wawona St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 776030 | 5992637 | 2097914 | 37.7400491012762 | -122.468034007919 | (37.7400491012762, -122.468034007919) | 1 | 8 | 4 | 59 | 40 | ||
97832 | 87856 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 330X Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50790 | 6002852.8 | 2106288.8 | 37.7636289858331 | -122.433310278834 | (37.7636289858331, -122.433310278834) | 15 | 4 | 5 | 28862 | 3 | |
105180 | 114988 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1020 Ulloa St | 2 | Side Yard : Cutout | Tree | Private 2 | 12/30/2015 12:00:00 AM | Permit Number 773462 | 5992930.8 | 2098449.5 | 37.7415364116566 | -122.467057099516 | (37.7415364116566, -122.467057099516) | 1 | 8 | 4 | 59 | 40 | |||
123694 | 36711 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 56 Julian Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52215 | 6006374.23290867 | 2107587.4469069 | 37.7673939082567 | -122.421222946795 | (37.7673939082567, -122.421222946795) | 8 | 4 | 7 | 28853 | 19 | |
141779 | 88025 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 200 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008175 | 2112425 | 37.7807780405047 | -122.415336822355 | (37.7807780405047, -122.415336822355) | 7 | 10 | 9 | 28852 | 36 | ||
144863 | 19102 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 286 Sagamore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2000 12:00:00 AM | 3 | 3X3 | 5994140.1842159 | 2087463.5149143 | 37.7114413003767 | -122.462078982125 | (37.7114413003767, -122.462078982125) | 9 | 8 | 6 | 28861 | 24 | ||
187369 | 24737 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 7630 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774506 | 5983294.71592 | 2112541.16992 | 37.7796672396255 | -122.501417008283 | (37.7796672396255, -122.501417008283) | 11 | 6 | 2 | 55 | 26 | |
194441 | 180986 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 363 Munich St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/11/2017 09:24:00 AM | 3 | Width 10ft | 6004214.2336 | 2090323.21202 | 37.7198682794893 | -122.427464041535 | (37.7198682794893, -122.427464041535) | 9 | 7 | 6 | 28861 | 5 | ||
2600 | 258371 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 998 Silliman St | 3 | Sidewalk: Property side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6007899.48346 | 2093470.38454 | 37.7287174922185 | -122.414948012993 | (37.7287174922185, -122.414948012993) | 9 | 3 | 7 | 309 | 28 | |||
44398 | 110615 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 200 McAllister St | 3 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 12/31/2015 12:00:00 AM | 3 | 13.2x7.8 | Permit Number 773269 | 6008108 | 2112443 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | 7 | 10 | 9 | 28852 | 36 | |
99901 | 88026 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 200 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008175 | 2112425 | 37.7807780405047 | -122.415336822355 | (37.7807780405047, -122.415336822355) | 7 | 10 | 9 | 28852 | 36 | ||
100740 | 110453 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 7630 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774506 | 5983294.7 | 2112541.2 | 37.7796673212814 | -122.501417065582 | (37.7796673212814, -122.501417065582) | 11 | 6 | 2 | 55 | 26 | |
113879 | 108438 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 200-212X Lexington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772675 | 6006463.90093 | 2104927.47787 | 37.7600953129132 | -122.420723941274 | (37.7600953129132, -122.420723941274) | 2 | 4 | 7 | 28859 | 19 |
134227 | 252890 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 301x Howth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2019 08:38:00 AM | 3 | 3x3 | 5997131 | 2090234 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | 9 | 8 | 6 | 28861 | 24 | ||
163261 | 99199 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 330X Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 50790 | 6002852.8 | 2106288.8 | 37.7636289858331 | -122.433310278834 | (37.7636289858331, -122.433310278834) | 15 | 4 | 5 | 28862 | 3 | ||
178716 | 36712 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 56 Julian Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52215 | 6006374.23290867 | 2107587.4469069 | 37.7673939082567 | -122.421222946795 | (37.7673939082567, -122.421222946795) | 8 | 4 | 7 | 28853 | 19 | |
41261 | 84460 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 698X 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52659 | 6009314.54246303 | 2104977.65271839 | 37.7603933359548 | -122.410868438641 | (37.7603933359548, -122.410868438641) | 2 | 4 | 7 | 28859 | 19 | ||
92899 | 190438 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1350 Evans Ave | 4 | : | Tree | DPW 1 | 03/18/2017 11:59:00 AM | 3 | Width 3ft | 6016891.21359 | 2097667.15217 | 37.7407421449384 | -122.38415488076 | (37.7407421449384, -122.38415488076) | 10 | 3 | 8 | 58 | 1 | ||
98016 | 92227 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 587 Shotwell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52664 | 6008031.3 | 2104525.5 | 37.7590797904057 | -122.415274584034 | (37.7590797904057, -122.415274584034) | 2 | 4 | 7 | 28859 | 19 | ||
154111 | 6541 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1201 Evans Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/1997 12:00:00 AM | 3 | 4X4 | 6017765.6846273 | 2096901.7583545 | 37.7386888362962 | -122.381078057558 | (37.7386888362962, -122.381078057558) | 10 | 3 | 8 | 58 | 1 | ||
161899 | 74044 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 56 Julian Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52215 | 6006374.23290867 | 2107587.4469069 | 37.7673939082567 | -122.421222946795 | (37.7673939082567, -122.421222946795) | 8 | 4 | 7 | 28853 | 19 | |
177500 | 188690 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1300 Evans Ave | 44 | : | Tree | DPW 1 | 03/18/2017 02:23:00 PM | 3 | Width 3ft | 6017127.64655 | 2097493.15124 | 37.7402774427419 | -122.383325267851 | (37.7402774427419, -122.383325267851) | 10 | 3 | 8 | 58 | 1 | ||
120431 | 188691 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1300 Evans Ave | 45 | : | Tree | DPW 1 | 03/18/2017 02:26:00 PM | 3 | Width 3ft | 6017107.93008 | 2097506.97635 | 37.7403143140663 | -122.38339440234 | (37.7403143140663, -122.38339440234) | 10 | 3 | 8 | 58 | 1 | ||
149263 | 188692 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1300 Evans Ave | 46 | : | Tree | DPW 1 | 03/18/2017 02:33:00 PM | 3 | Width 3ft | 6017090.76081 | 2097520.28707 | 37.7403499137184 | -122.383454693803 | (37.7403499137184, -122.383454693803) | 10 | 3 | 8 | 58 | 1 | ||
134331 | 111021 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 90x DOWNEY ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/14/2015 12:00:00 AM | 3x3 | 5998894 | 2107683 | 37.7672317271747 | -122.447102814384 | (37.7672317271747, -122.447102814384) | 15 | 5 | 11 | 29492 | 9 | |||
164488 | 72661 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 56 Julian Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52215 | 6006374.23290867 | 2107587.4469069 | 37.7673939082567 | -122.421222946795 | (37.7673939082567, -122.421222946795) | 8 | 4 | 7 | 28853 | 19 | |
91803 | 72659 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 56 Julian Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52215 | 6006374.23290867 | 2107587.4469069 | 37.7673939082567 | -122.421222946795 | (37.7673939082567, -122.421222946795) | 8 | 4 | 7 | 28853 | 19 | |
117072 | 190439 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1350 Evans Ave | 6 | : | Tree | DPW 1 | 03/18/2017 11:54:00 AM | 3 | Width 3ft | 6016857.78658 | 2097692.82931 | 37.7408108009722 | -122.384272247659 | (37.7408108009722, -122.384272247659) | 10 | 3 | 8 | 58 | 1 | ||
50039 | 82645 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 56 Julian Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52215 | 6006376.13216739 | 2107553.16833294 | 37.7672998944856 | -122.421213943138 | (37.7672998944856, -122.421213943138) | 8 | 4 | 7 | 28853 | 19 | |
82815 | 108411 | Undocumented 4 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 99x HYDE ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008108 | 2112443 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | 7 | 10 | 9 | 28852 | 36 | ||
121223 | 6643 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1499 Evans Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2009 12:00:00 AM | 3 | 3X3 | 6016187.3727289 | 2098094.9741145 | 37.7418779170755 | -122.386618343631 | (37.7418779170755, -122.386618343631) | 10 | 3 | 8 | 58 | 1 | ||
19710 | 82646 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 56 Julian Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52215 | 6006376.13216739 | 2107553.16833294 | 37.7672998944856 | -122.421213943138 | (37.7672998944856, -122.421213943138) | 8 | 4 | 7 | 28853 | 19 | |
59912 | 108412 | Undocumented 4 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 99x HYDE ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008108 | 2112443 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | 7 | 10 | 9 | 28852 | 36 | ||
115122 | 108413 | Undocumented 4 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 99x HYDE ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008108 | 2112443 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | 7 | 10 | 9 | 28852 | 36 | ||
174484 | 82647 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 56 Julian Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773693 | 6006376.13216739 | 2107553.16833294 | 37.7672998944856 | -122.421213943138 | (37.7672998944856, -122.421213943138) | 8 | 4 | 7 | 28853 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );