trees
3,247 rows where qSpecies_id = 22 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
62 | 264980 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 22 | 222 Winfield St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6006740 | 2098205 | 37.7416524795013 | -122.419292156581 | (37.7416524795013, -122.419292156581) | 2 | 7 | 7 | 28859 | 2 | ||||
692 | 61241 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3970 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/14/1984 12:00:00 AM | Permit Number 21113 | 6003879.55901956 | 2104241.51200503 | 37.7580658175007 | -122.429613020503 | (37.7580658175007, -122.429613020503) | 2 | 4 | 5 | 28862 | 3 | ||
796 | 36869 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
1069 | 49087 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 692 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/2003 12:00:00 AM | Permit Number 46237 | 6012085.19773634 | 2105185.1896517 | 37.7611181541392 | -122.401300553818 | (37.7611181541392, -122.401300553818) | 10 | 3 | 8 | 28856 | 29 | |||
1649 | 92526 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 275 10th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2009 12:00:00 AM | 3x3 | Permit Number 52874 | 6008743 | 2109634 | 37.7731465224788 | -122.413174412357 | (37.7731465224788, -122.413174412357) | 8 | 2 | 9 | 28853 | 34 | ||
1669 | 35520 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 90 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41442 | 6005793.71652674 | 2102887.49607432 | 37.7544562030797 | -122.422896805421 | (37.7544562030797, -122.422896805421) | 2 | 4 | 5 | 28859 | 19 | ||
1918 | 262485 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 500X Delta St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6009406 | 2087980 | 37.7137265813857 | -122.409352565386 | (37.7137265813857, -122.409352565386) | 9 | 7 | 8 | 309 | 39 | |||
2444 | 187616 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 55 Hawthorne St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/03/2013 12:00:00 AM | 3x3 | 6013035 | 2114021 | 37.78543223702 | -122.398635644163 | (37.78543223702, -122.398635644163) | 6 | 2 | 9 | 28855 | 6 | ||
2637 | 262319 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1616 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011556 | 2107033 | 37.7661622878471 | -122.403260820888 | (37.7661622878471, -122.403260820888) | 8 | 2 | 8 | 28853 | 20 | ||||
2803 | 39877 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1999 12:00:00 AM | Permit Number 41173 | 6015620.67363669 | 2114221.43610992 | 37.786126305998 | -122.389703911477 | (37.786126305998, -122.389703911477) | 6 | 2 | 9 | 28855 | 6 | |||
3744 | 39401 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1690 Church St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.7438431217943 | -122.426774196771 | (37.7438431217943, -122.426774196771) | 2 | 7 | 5 | 63 | 22 | |||
5372 | 256588 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 2x Stillman St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
5533 | 59035 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3367 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1980 12:00:00 AM | Permit Number 18327; Original species unknown. Removed and replaced without permit in 2000 | 6005902.92482081 | 2103717.90003873 | 37.7567424611364 | -122.422578138877 | (37.7567424611364, -122.422578138877) | 2 | 4 | 5 | 28859 | 19 | |||
5756 | 256400 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1116 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009438.01285 | 2102666.82679 | 37.7540552516703 | -122.410278250843 | (37.7540552516703, -122.410278250843) | 2 | 4 | 7 | 28859 | 19 | ||||
6217 | 44045 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 442 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/2000 12:00:00 AM | Permit Number 43576 | 6010366.61752859 | 2089364.49737601 | 37.7175819036471 | -122.406129784758 | (37.7175819036471, -122.406129784758) | 10 | 7 | 8 | 309 | 39 | |||
6920 | 32855 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 121 Hoffman Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1996 12:00:00 AM | Permit Number 37205 | 6000624.61627289 | 2102511.57259046 | 37.7531309843157 | -122.440745886867 | (37.7531309843157, -122.440745886867) | 2 | 4 | 5 | 28862 | 22 | ||
6989 | 109119 | Section 143 10 | Ginkgo biloba :: Maidenhair Tree 22 | 2036x 15TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x6 | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | ||||
8137 | 84234 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 361-363 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52253 | 5988056.84631807 | 2113563.86004854 | 37.782753781159 | -122.485017993529 | (37.782753781159, -122.485017993529) | 11 | 6 | 2 | 55 | 26 | ||
8700 | 106117 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 405 Lisbon St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/2014 12:00:00 AM | 3x3 | Permit Number 772749 | 6002458.5 | 2091056.7 | 37.7217828139374 | -122.433585385445 | (37.7217828139374, -122.433585385445) | 9 | 7 | 6 | 28861 | 5 | |||
8720 | 67850 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 485 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1993 12:00:00 AM | Permit Number 31520 | 6002735.666769 | 2098756.82734478 | 37.7429413329054 | -122.433177202226 | (37.7429413329054, -122.433177202226) | 2 | 7 | 5 | 63 | 22 | ||
9306 | 40717 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 360 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/12/1999 12:00:00 AM | Permit Number 41696 | 6008594.61699406 | 2097088.56935412 | 37.7386912826447 | -122.412800580048 | (37.7386912826447, -122.412800580048) | 10 | 7 | 7 | 28859 | 2 | ||
9492 | 104107 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 55X Clarence Pl | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | Permit Number 768392 | 6014738.33428 | 2111855.52316 | 37.7795810807004 | -122.392591035948 | (37.7795810807004, -122.392591035948) | 6 | 2 | 9 | 28856 | 6 | |||
10044 | 98961 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 302x Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x4 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | 7 | 9 | 11 | 28852 | 10 | ||||
10049 | 261052 | Private 9 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Hooper St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013012.2905 | 2108046.92839 | 37.769027533769 | -122.398294909078 | (37.769027533769, -122.398294909078) | 14 | 3 | 8 | 28856 | 20 | ||||
10523 | 262206 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 888 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000738 | 2088975 | 37.7159691653279 | -122.439383549479 | (37.7159691653279, -122.439383549479) | 9 | 7 | 6 | 28861 | 5 | ||||
11133 | 261245 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 40 Porter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006991 | 2095570 | 37.7344314860328 | -122.418237504879 | (37.7344314860328, -122.418237504879) | 2 | 7 | 7 | 28859 | 2 | ||||
11217 | 36019 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 99 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39165 | 6006729.30953986 | 2099082.13183863 | 37.7440602847413 | -122.419391331569 | (37.7440602847413, -122.419391331569) | 2 | 7 | 7 | 28859 | 2 | ||
11309 | 44191 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Harrison St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | 6 | 2 | 9 | 28855 | 6 | |||
12180 | 91455 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 680x WASHINGTON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 3x3 | Permit Number 52103 | 6011317 | 2117738 | 37.7955423680345 | -122.404841229346 | (37.7955423680345, -122.404841229346) | 3 | 1 | 10 | 28857 | 4 | ||
12479 | 66411 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 217 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2009 12:00:00 AM | 3x3 | Permit Number 52018 | 6006829.83812508 | 2097883.34846014 | 37.7407743554357 | -122.418958717737 | (37.7407743554357, -122.418958717737) | 2 | 7 | 7 | 28859 | 2 | ||
12788 | 84750 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 170 King St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2007 12:00:00 AM | Permit No. 49304 | 6014851 | 2111791 | 37.7794101710037 | -122.392196759897 | (37.7794101710037, -122.392196759897) | 6 | 2 | 9 | 28856 | 6 | |||
13115 | 51970 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1563 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2005 12:00:00 AM | Permit Number 48189 | 5999092.74097418 | 2109030.13425564 | 37.7709419701081 | -122.446512330156 | (37.7709419701081, -122.446512330156) | 15 | 5 | 11 | 29492 | 9 | |||
13947 | 109612 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 311x DAVIS ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013158 | 2117662 | 37.7954364211004 | -122.398465672767 | (37.7954364211004, -122.398465672767) | 3 | 1 | 10 | 28860 | 6 | ||||
14479 | 260995 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 1639 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999105 | 2109358 | 37.771842906315 | -122.446493517614 | (37.771842906315, -122.446493517614) | 15 | 5 | 11 | 29492 | 9 | ||||
14814 | 50011 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 99@ 20TH ST Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2003 12:00:00 AM | Permit Number 46742 | |||||||||||||
15326 | 30913 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 183 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34734 | 5995612.81318116 | 2091099.78305051 | 37.7215103139917 | -122.457252110286 | (37.7215103139917, -122.457252110286) | 9 | 8 | 6 | 28861 | 24 | ||
15866 | 87230 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2575X JUDAH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2015 12:00:00 AM | 3x3 | Permit Number 776165 | 5986584.2 | 2105636.2 | 37.7609007669433 | -122.489529520217 | (37.7609007669433, -122.489529520217) | 1 | 8 | 3 | 56 | 35 | ||
15898 | 36871 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
15922 | 62857 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 179 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/18/1986 12:00:00 AM | Permit Number 23225 | 6008674.53760188 | 2097751.18669018 | 37.7405151705193 | -122.412571078994 | (37.7405151705193, -122.412571078994) | 10 | 7 | 7 | 28859 | 2 | ||
16322 | 41156 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 455 09th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/2004 12:00:00 AM | Permit Number 47674 | 6009883.81375688 | 2109165.06157558 | 37.7719229056173 | -122.409195075279 | (37.7719229056173, -122.409195075279) | 14 | 2 | 9 | 28853 | 34 | |||
16336 | 36872 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
16941 | 85025 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 344 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2007 12:00:00 AM | 3x3 | Permit Number 49376 | 6007036 | 2096264 | 37.7363395901899 | -122.418131109854 | (37.7363395901899, -122.418131109854) | 2 | 7 | 7 | 28859 | 2 | ||
17318 | 39391 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1690 Church St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.7438431217943 | -122.426774196771 | (37.7438431217943, -122.426774196771) | 2 | 7 | 5 | 63 | 22 | |||
17433 | 36873 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
17481 | 52506 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 180 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48613 | 6000220.46380878 | 2092503.12984203 | 37.7256271406599 | -122.441425411243 | (37.7256271406599, -122.441425411243) | 9 | 7 | 6 | 28861 | 25 | ||
17837 | 260996 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 1639 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999105 | 2109358 | 37.771842906315 | -122.446493517614 | (37.771842906315, -122.446493517614) | 15 | 5 | 11 | 29492 | 9 | ||||
17856 | 68790 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2339 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/1993 12:00:00 AM | Permit Number 32727 | 5991985.43941061 | 2099518.6478439 | 37.744417405952 | -122.470403648157 | (37.744417405952, -122.470403648157) | 1 | 8 | 4 | 29491 | 40 | ||
18486 | 260997 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 1639 Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999105 | 2109358 | 37.771842906315 | -122.446493517614 | (37.771842906315, -122.446493517614) | 15 | 5 | 11 | 29492 | 9 | ||||
19071 | 260994 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 1639 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999105 | 2109358 | 37.771842906315 | -122.446493517614 | (37.771842906315, -122.446493517614) | 15 | 5 | 11 | 29492 | 9 | ||||
19265 | 44239 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 317 Harriet St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2001 12:00:00 AM | Permit Number 43677 | 6011781.7513621 | 2110406.95147967 | 37.7754389967998 | -122.402717284978 | (37.7754389967998, -122.402717284978) | 14 | 2 | 9 | 28853 | 34 | |||
19756 | 100780 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 450 Hayes St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2012 12:00:00 AM | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | |||
19891 | 61244 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3974 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/14/1984 12:00:00 AM | Permit Number 21116 | 6003854.92098549 | 2104240.14481817 | 37.7580606684354 | -122.429698131841 | (37.7580606684354, -122.429698131841) | 2 | 4 | 5 | 28862 | 3 | ||
20563 | 109121 | Section 143 10 | Ginkgo biloba :: Maidenhair Tree 22 | 2036x 15TH ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x6 | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | ||||
20649 | 87351 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3374 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2008 12:00:00 AM | Permit Number 50337 | 5998108 | 2116175 | 37.7905036111085 | -122.450433709576 | (37.7905036111085, -122.450433709576) | 13 | 6 | 1 | 54 | 31 | |||
21125 | 109116 | Section 143 10 | Ginkgo biloba :: Maidenhair Tree 22 | 2036x 15TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x6 | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | ||||
21146 | 94291 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 901 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2009 12:00:00 AM | 3x3 | Permit Number 52965 | 6009147 | 2103917 | 37.7574716284078 | -122.411372960691 | (37.7574716284078, -122.411372960691) | 2 | 4 | 7 | 28859 | 19 | ||
21207 | 33596 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 224 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/27/1996 12:00:00 AM | Permit Number 37704 | 6006764.88220944 | 2097872.66772056 | 37.7407413706298 | -122.419182553853 | (37.7407413706298, -122.419182553853) | 2 | 7 | 7 | 28859 | 2 | ||
21252 | 97555 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 245 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2011 12:00:00 AM | 3x3 | Permit Number 768266 | 6004805.6 | 2102240.4 | 37.7526236239085 | -122.42626790325 | (37.7526236239085, -122.42626790325) | 2 | 4 | 5 | 28862 | 22 | ||
21646 | 44771 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 938 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2001 12:00:00 AM | Permit Number 43877 | 6011792.18948294 | 2111489.0452941 | 37.7784107598375 | -122.402757294311 | (37.7784107598375, -122.402757294311) | 14 | 2 | 9 | 28856 | 34 | |||
22441 | 35507 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3460 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38910 | 6005335.59882734 | 2103155.12631958 | 37.7551651932954 | -122.42450013257 | (37.7551651932954, -122.42450013257) | 2 | 4 | 5 | 28859 | 19 | ||
22665 | 67038 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 140 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/1994 12:00:00 AM | Permit Number 30414 | 6004243.51306572 | 2101045.11693078 | 37.7493098678885 | -122.4281265241 | (37.7493098678885, -122.4281265241) | 2 | 4 | 5 | 28862 | 22 | ||
22774 | 121447 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 1251 03rd St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015574 | 2109248 | 37.7724677756099 | -122.389517929907 | (37.7724677756099, -122.389517929907) | 14 | 3 | 9 | 310 | 20 | |||||
22948 | 63826 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 801 Jarboe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1987 12:00:00 AM | Permit Number 24514 | 6008974.10291824 | 2096930.94751017 | 37.7382797803205 | -122.411477359627 | (37.7382797803205, -122.411477359627) | 10 | 7 | 7 | 28859 | 2 | ||
23050 | 63859 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 573 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24560 | 6002112.91730611 | 2110421.71062272 | 37.7749349366141 | -122.436165074208 | (37.7749349366141, -122.436165074208) | 15 | 5 | 11 | 29492 | 10 | ||
23454 | 63811 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 397 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24498 | 6008814.87080902 | 2096945.70760042 | 37.7383113756234 | -122.41202895062 | (37.7383113756234, -122.41202895062) | 10 | 7 | 7 | 28859 | 2 | ||
23520 | 51660 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 965 @ PARIS Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2005 12:00:00 AM | Permit Number 47940 | 6000578.12419421 | 2089000.08275614 | 37.7160289372019 | -122.439937951405 | (37.7160289372019, -122.439937951405) | 9 | 7 | 6 | 28861 | 5 | |||
23772 | 256577 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 2x Stillman St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
24058 | 34407 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 151 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38155 | 6004576.44969274 | 2097521.36031941 | 37.7396532725762 | -122.426724317666 | (37.7396532725762, -122.426724317666) | 2 | 7 | 5 | 63 | 7 | ||
24663 | 92015 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 249 Twin Peaks Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2009 12:00:00 AM | 3x3 | Permit Number 52164 | 5998485.7 | 2104379.6 | 37.7581380835524 | -122.448277156413 | (37.7581380835524, -122.448277156413) | 15 | 5 | 5 | 28862 | 12 | ||
24939 | 37321 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 445 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41123 | 6003410.55922166 | 2103870.78228446 | 37.7570213149701 | -122.431208559798 | (37.7570213149701, -122.431208559798) | 2 | 4 | 5 | 28862 | 3 | ||
25058 | 251361 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010388 | 2110913 | 37.7767505721368 | -122.407574310337 | (37.7767505721368, -122.407574310337) | 14 | 2 | 9 | 28853 | 34 | ||||
25123 | 50152 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 215 REVISED Fremont St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2003 12:00:00 AM | Permit Number 46870 | 6014159.85874387 | 2115328.34387959 | 37.7890845068427 | -122.3948355307 | (37.7890845068427, -122.3948355307) | 6 | 2 | 9 | 28855 | 6 | |||
25161 | 256581 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 2x Stillman St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
25287 | 48366 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 350& 17th ST Rhode Island St | 29 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2002 12:00:00 AM | Permit Number 45774 | 6011708.83412888 | 2106755.94348957 | 37.7654100874921 | -122.402712708416 | (37.7654100874921, -122.402712708416) | 8 | 3 | 8 | 28853 | 20 | |||
25414 | 109115 | Section 143 10 | Ginkgo biloba :: Maidenhair Tree 22 | 2036x 15TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x6 | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | ||||
26417 | 66310 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 136 Hamerton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29425 | 6001332.72327258 | 2095407.42415394 | 37.7336649686266 | -122.43778834571 | (37.7336649686266, -122.43778834571) | 9 | 7 | 5 | 63 | 40 | ||
26633 | 88961 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 583 Shotwell St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2008 12:00:00 AM | 3x3 | Permit Number 51727 | 6008031.3 | 2104525.5 | 37.7590797904057 | -122.415274584034 | (37.7590797904057, -122.415274584034) | 2 | 4 | 7 | 28859 | 19 | |||
26808 | 89205 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 662 25th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51833 | 5988199 | 2111465.2 | 37.7769997309607 | -122.48437223608 | (37.7769997309607, -122.48437223608) | 11 | 6 | 2 | 55 | 26 | |||
27248 | 42307 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 245 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42530 | 5998732.16654968 | 2093631.30703212 | 37.7286399521282 | -122.446651448677 | (37.7286399521282, -122.446651448677) | 9 | 7 | 4 | 28861 | 40 | ||
27284 | 32001 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1100 Brazil Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1995 12:00:00 AM | Permit Number 35398 | 6004626.44544717 | 2090517.44642515 | 37.7204249107717 | -122.426052988126 | (37.7204249107717, -122.426052988126) | 9 | 7 | 6 | 28861 | 5 | ||
27288 | 33750 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 845 Guerrero St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38932 | 6005705.24449579 | 2104057.07564242 | 37.7576626039009 | -122.42328590054 | (37.7576626039009, -122.42328590054) | 2 | 4 | 5 | 28859 | 19 | ||
27585 | 47159 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 200 San Fernando Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52542 | 5992116.68521556 | 2095408.98560737 | 37.7331409014555 | -122.469650709796 | (37.7331409014555, -122.469650709796) | 9 | 8 | 4 | 59 | 40 | ||
27607 | 91318 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 450 Rhode Island St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745 | 2106547 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | 8 | 3 | 8 | 28853 | 20 | ||
27624 | 256578 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 2x Stillman St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
28328 | 45196 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3379 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/01/2001 12:00:00 AM | Permit Number 44041 | 6005846.47654917 | 2103129.45360257 | 37.7551235392216 | -122.422731541054 | (37.7551235392216, -122.422731541054) | 2 | 4 | 5 | 28859 | 19 | ||
28883 | 34868 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 448 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2007 12:00:00 AM | 3x3 | Permit Number 49951 | 6003547.62609569 | 2096418.61112327 | 37.7365671542892 | -122.430202896046 | (37.7365671542892, -122.430202896046) | 2 | 7 | 5 | 63 | 7 | ||
28893 | 68505 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1957 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32383 | 5992830.56457156 | 2102309.10574943 | 37.752128116881 | -122.467684306461 | (37.752128116881, -122.467684306461) | 1 | 8 | 4 | 29491 | 12 | ||
29173 | 98963 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 302x Ivy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x4 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | 7 | 9 | 11 | 28852 | 10 | ||||
29390 | 92527 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 275 10th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2009 12:00:00 AM | 3x3 | Permit Number 52874 | 6008743 | 2109634 | 37.7731465224788 | -122.413174412357 | (37.7731465224788, -122.413174412357) | 8 | 2 | 9 | 28853 | 34 | ||
29797 | 61370 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 47 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/1984 12:00:00 AM | Permit Number 21280 | 6005657.12364045 | 2109394.65582136 | 37.772315616937 | -122.423831849588 | (37.772315616937, -122.423831849588) | 7 | 9 | 11 | 28852 | 10 | |||
29930 | 39397 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1690 Church St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.7438431217943 | -122.426774196771 | (37.7438431217943, -122.426774196771) | 2 | 7 | 5 | 63 | 22 | |||
30897 | 64364 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 562 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1988 12:00:00 AM | Permit Number 25203 | 6010163.25374355 | 2120275.04561468 | 37.8024439169341 | -122.409012506441 | (37.8024439169341, -122.409012506441) | 3 | 1 | 10 | 308 | 23 | ||
31594 | 54908 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1025 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2001 12:00:00 AM | Permit Number 10774 | 5997625.73992568 | 2107028.28129343 | 37.7653614921753 | -122.451442291891 | (37.7653614921753, -122.451442291891) | 15 | 5 | 11 | 29492 | 9 | ||
32171 | 97541 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2001 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011781.1 | 2105070.6 | 37.760786545641 | -122.402344245968 | (37.760786545641, -122.402344245968) | 10 | 3 | 8 | 28856 | 29 | ||||
32736 | 30601 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 140 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | Permit Number 34568 | 6007766.12041799 | 2109892.83524287 | 37.7738023323227 | -122.416571913724 | (37.7738023323227, -122.416571913724) | 8 | 2 | 9 | 28853 | 19 | ||
33532 | 44053 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3100 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2000 12:00:00 AM | Permit Number 43582 | 6001974.87365527 | 2118765.4026711 | 37.7978367374605 | -122.437240145023 | (37.7978367374605, -122.437240145023) | 13 | 9 | 1 | 57 | 17 | |||
33632 | 48389 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 350& 17th ST Rhode Island St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2002 12:00:00 AM | Permit Number 45774 | 6011708.83412888 | 2106755.94348957 | 37.7654100874921 | -122.402712708416 | (37.7654100874921, -122.402712708416) | 8 | 3 | 8 | 28853 | 20 | |||
33644 | 64488 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3371 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/1988 12:00:00 AM | Permit Number 25483 | 6005878.34510819 | 2103716.54334908 | 37.7567373492627 | -122.422663048235 | (37.7567373492627, -122.422663048235) | 2 | 4 | 5 | 28859 | 19 | ||
34023 | 48387 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 350& 17th ST Rhode Island St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2002 12:00:00 AM | Permit Number 45774 | 6011708.83412888 | 2106755.94348957 | 37.7654100874921 | -122.402712708416 | (37.7654100874921, -122.402712708416) | 8 | 3 | 8 | 28853 | 20 | |||
34228 | 114296 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301X 07TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010388 | 2110913 | 37.7767505721368 | -122.407574310337 | (37.7767505721368, -122.407574310337) | 14 | 2 | 9 | 28853 | 34 |
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) );