trees
1,013 rows where qSpecies_id = 42 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
79074 | 103375 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 22 VANDEWATER ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x2.5 | Permit Number 770057 | 6009069 | 2121391 | 37.8054466905223 | -122.412878124584 | (37.8054466905223, -122.412878124584) | 3 | 1 | 10 | 308 | 23 | ||||
94954 | 252841 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1763 Golden Gate Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/1998 12:00:00 AM | 3x3 | Permit Number 40601 | 6001163 | 2111730 | 37.7784731541065 | -122.43954484007 | (37.7784731541065, -122.43954484007) | 15 | 5 | 11 | 29490 | 41 | |||
159886 | 255452 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1300 25th St | Side Yard : Yard | Tree | Private 2 | 3x3 | 6014722 | 2102062 | 37.7526893042179 | -122.391962509783 | (37.7526893042179, -122.391962509783) | 10 | 3 | 8 | 28856 | 29 | |||||
919 | 224218 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 60 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 3ft | 6007258.1885 | 2099113.30571 | 37.7441756548749 | -122.417564790989 | (37.7441756548749, -122.417564790989) | 2 | 7 | 7 | 28859 | 2 | |||
1187 | 38340 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1517 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1998 12:00:00 AM | 14 | Permit Number 40407 | 5982158.3822 | 2104738.8652 | 37.7581775666431 | -122.504769723467 | (37.7581775666431, -122.504769723467) | 1 | 8 | 3 | 56 | 35 | |
2823 | 74090 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2301 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5986841.7666 | 2102304.3098 | 37.7517673391944 | -122.488393849306 | (37.7517673391944, -122.488393849306) | 1 | 8 | 3 | 29491 | 35 | |||
3525 | 206324 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1548 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5992470.93108 | 2104912.73942 | 37.7592562450954 | -122.469117436218 | (37.7592562450954, -122.469117436218) | 1 | 8 | 4 | 56 | 12 | |||
4201 | 191894 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1195 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017504.55596 | 2094293.80074 | 37.7315134846627 | -122.381799585104 | (37.7315134846627, -122.381799585104) | 10 | 3 | 8 | 58 | 1 | |||
4297 | 36977 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 181 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | 16 | Permit Number 39602 | 5993647.32145 | 2114324.1067 | 37.7851652576674 | -122.465732723466 | (37.7851652576674, -122.465732723466) | 11 | 6 | 2 | 54 | 11 | |
4393 | 124582 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 3969 Washington St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 9ft | 5995697.73054 | 2115463.76534 | 37.7884125114933 | -122.458721526276 | (37.7884125114933, -122.458721526276) | 11 | 6 | 1 | 54 | 31 | |||
4824 | 223930 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 400 Clipper St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 18 | Width 4ft | 6002523.62609 | 2100944.12387 | 37.7489351054853 | -122.434066703011 | (37.7489351054853, -122.434066703011) | 2 | 4 | 5 | 28862 | 22 | |||
5180 | 223976 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2 Gough St | 1 | : | Tree | Private 2 | 24 | 6006664.52423 | 2109235.55024 | 37.771935569897 | -122.420335857614 | (37.771935569897, -122.420335857614) | 8 | 2 | 9 | 28853 | 19 | ||||
5309 | 209148 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 217 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/15/1991 12:00:00 AM | 19 | Width 3ft | Permit Number 29835 | 5995023.41571 | 2107016.68952 | 37.7651803042563 | -122.460442223229 | (37.7651803042563, -122.460442223229) | 15 | 5 | 11 | 56 | 12 | |
6633 | 38868 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2439 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | 7 | Permit Number 40694 | 5987331.8721 | 2098675.8712 | 37.7418332004815 | -122.486432648249 | (37.7418332004815, -122.486432648249) | 1 | 8 | 3 | 29491 | 35 | |
7145 | 206261 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 57 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2000 12:00:00 AM | 13 | Width 3ft | Permit Number 42423 | 5999614.39843 | 2093757.95077 | 37.729038042256 | -122.443610625157 | (37.729038042256, -122.443610625157) | 9 | 7 | 4 | 63 | 40 | |
7800 | 209094 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 99X Terrace Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 10ft | 5993033 | 2097048 | 37.7376941438167 | -122.466601883437 | (37.7376941438167, -122.466601883437) | 1 | 8 | 4 | 59 | 40 | |||
8156 | 73675 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 510 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6010458.2549 | 2119616.6906 | 37.8006527567523 | -122.407945198153 | (37.8006527567523, -122.407945198153) | 3 | 1 | 10 | 308 | 23 | |||
8361 | 4468 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1497 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004583.98516 | 2100211.88347 | 37.7470412591526 | -122.426889829809 | (37.7470412591526, -122.426889829809) | 2 | 7 | 5 | 63 | 22 | |||
8534 | 140902 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2301 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6000347.067 | 2113317.3521 | 37.782785144864 | -122.442481446452 | (37.782785144864, -122.442481446452) | 15 | 5 | 1 | 29490 | 41 | |||
8703 | 72282 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 734 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5982929.57235 | 2110777.26044 | 37.7748026075919 | -122.502549585183 | (37.7748026075919, -122.502549585183) | 11 | 6 | 2 | 55 | 26 | |||
8794 | 42966 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 160 Belgrave Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2000 12:00:00 AM | Permit Number 42854 | 5997814.60948514 | 2104925.35351079 | 37.7595981967984 | -122.45063741216 | (37.7595981967984, -122.45063741216) | 15 | 5 | 11 | 29492 | 12 | |||
8803 | 72935 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1130 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 6007329.70123 | 2115191.82253 | 37.7883275164504 | -122.418457373512 | (37.7883275164504, -122.418457373512) | 13 | 9 | 10 | 28858 | 21 | |||
9703 | 264868 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 145 Guerrero St | 1 | Side Yard : Yard | Tree | Private 2 | 3x3 | 6005490 | 2108162 | 37.7689216043545 | -122.424322258789 | (37.7689216043545, -122.424322258789) | 8 | 4 | 5 | 28853 | 19 | ||||
9939 | 31372 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 608 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1995 12:00:00 AM | 16 | Permit Number 34974 | 5991288.74987 | 2099114.74799 | 37.7432680941565 | -122.472783188016 | (37.7432680941565, -122.472783188016) | 1 | 8 | 4 | 29491 | 40 | |
10014 | 30472 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 524 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1956 12:00:00 AM | 11 | 3x3 | Permit Number 119 | 6010416.9297 | 2119611.1498 | 37.8006352293469 | -122.408087810014 | (37.8006352293469, -122.408087810014) | 3 | 1 | 10 | 308 | 23 |
11313 | 224305 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 371 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | 6x12 | 6005498.30819 | 2101561.13741 | 37.7507976562932 | -122.423824099413 | (37.7507976562932, -122.423824099413) | 2 | 4 | 5 | 28859 | 19 | |||
12834 | 262134 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1221 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6012851 | 2101764 | 37.7517670092481 | -122.398411895346 | (37.7517670092481, -122.398411895346) | 10 | 3 | 8 | 28856 | 29 | ||||
13255 | 73364 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2933 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 5989451.1114 | 2111912.97182 | 37.7783020173334 | -122.480073622696 | (37.7783020173334, -122.480073622696) | 11 | 6 | 2 | 55 | 26 | |||
14021 | 209106 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 99 Marcela Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5994508.17263 | 2100476.28306 | 37.7471923713346 | -122.461750045237 | (37.7471923713346, -122.461750045237) | 1 | 8 | 4 | 29491 | 40 | |||
14164 | 262133 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1805 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6013134 | 2101730 | 37.751689413587 | -122.397430852298 | (37.751689413587, -122.397430852298) | 10 | 3 | 8 | 28856 | 29 | ||||
15434 | 209153 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2055 15th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 04/26/2004 12:00:00 AM | 10 | Width 3ft | Permit Number 47392 | 5991594.69528 | 2101440.30789 | 37.7496711879902 | -122.471894774741 | (37.7496711879902, -122.471894774741) | 1 | 8 | 4 | 29491 | 12 | |
17292 | 142278 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1775 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5999245.2812 | 2110787.8491 | 37.7757769187314 | -122.446111142987 | (37.7757769187314, -122.446111142987) | 15 | 5 | 11 | 29492 | 16 | |||
17686 | 261568 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1299 Wisconsin St | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 6013134 | 2101730 | 37.751689413587 | -122.397430852298 | (37.751689413587, -122.397430852298) | 10 | 3 | 8 | 28856 | 29 | ||||
18806 | 191830 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2090 Jerrold Ave | 1 | : | Tree | Private 2 | 17 | Width 4ft | 6012760.03048 | 2098917.92047 | 37.7439472163011 | -122.39852678988 | (37.7439472163011, -122.39852678988) | 10 | 3 | 8 | 58 | 1 | |||
19050 | 4480 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1544 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004537.43405 | 2099923.54921 | 37.7462469275435 | -122.427030266568 | (37.7462469275435, -122.427030266568) | 2 | 7 | 5 | 63 | 22 | |||
19111 | 224301 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 3750 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6005487.3192 | 2100818.51609 | 37.7487579687029 | -122.423809301967 | (37.7487579687029, -122.423809301967) | 2 | 4 | 5 | 28859 | 19 | |||
19605 | 209072 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 40 San Benito Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | Width 8ft | 5992817.92295 | 2096532.21615 | 37.7362655167426 | -122.467308008376 | (37.7362655167426, -122.467308008376) | 1 | 8 | 4 | 59 | 40 | |||
19984 | 126584 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2626 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5999652.4856 | 2117862.36135 | 37.7952249343347 | -122.445211270002 | (37.7952249343347, -122.445211270002) | 13 | 9 | 1 | 57 | 17 | |||
20574 | 223959 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 642 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002363.56363 | 2104457.3204 | 37.7585724195079 | -122.434871407414 | (37.7585724195079, -122.434871407414) | 2 | 4 | 5 | 28862 | 3 | |||
22069 | 11203 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1001X Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X4 | 6018170.9910099 | 2094117.1281791 | 37.7310651541831 | -122.379483297777 | (37.7310651541831, -122.379483297777) | 10 | 3 | 8 | 58 | 1 | |||
22075 | 187658 | Property Tree 8 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 600X Clarendon Ave | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5995637 | 2102382 | 37.7524899085688 | -122.457984564932 | (37.7524899085688, -122.457984564932) | 1 | 5 | 4 | 63 | 12 | ||||
22577 | 223952 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 3815 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6003498.40089 | 2105933.65435 | 37.7626904457239 | -122.431051999266 | (37.7626904457239, -122.431051999266) | 15 | 4 | 5 | 28862 | 3 | |||
22914 | 4245 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 4038 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003639.78589 | 2100421.53447 | 37.7475634792894 | -122.430169743652 | (37.7475634792894, -122.430169743652) | 2 | 4 | 5 | 63 | 22 | |||
23106 | 30773 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 548 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 34 | Permit Number 34652 | 6014000.72465 | 2112264.48181 | 37.7806629966488 | -122.395171417543 | (37.7806629966488, -122.395171417543) | 6 | 2 | 9 | 28856 | 34 | |
23818 | 51993 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1260 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/2005 12:00:00 AM | 14 | Permit Number 48211 | 6007573.69475 | 2118185.59644 | 37.7965614123228 | -122.417825488274 | (37.7965614123228, -122.417825488274) | 5 | 1 | 10 | 28858 | 32 | |
24021 | 249463 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 900x Van Ness Ave | 1 | Median : Yard | Tree | DPW 1 | 27 | 6006539.42856 | 2113694.50869 | 37.7841717411666 | -122.421085234814 | (37.7841717411666, -122.421085234814) | 7 | 9 | 11 | 28858 | 36 | ||||
25254 | 176379 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 33 Valmar Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6005427.69459 | 2092809.96882 | 37.7267649302459 | -122.423446220467 | (37.7267649302459, -122.423446220467) | 9 | 7 | 7 | 309 | 5 | |||
26867 | 181823 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2311 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5987302.7678 | 2099517.8646 | 37.7441433943159 | -122.486595089548 | (37.7441433943159, -122.486595089548) | 1 | 8 | 3 | 29491 | 35 | |||
26961 | 209178 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2023 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5993462.72736 | 2101706.8649 | 37.7505109982991 | -122.465454464278 | (37.7505109982991, -122.465454464278) | 1 | 8 | 4 | 29491 | 40 | |||
27698 | 209061 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 171 San Benito Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 6ft | 5992890.94183 | 2095521.3505 | 37.7334941470322 | -122.466982085951 | (37.7334941470322, -122.466982085951) | 9 | 8 | 4 | 59 | 40 | |||
27748 | 223923 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 325 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6007001.94103 | 2096306.65108 | 37.7364547835532 | -122.418251889218 | (37.7364547835532, -122.418251889218) | 2 | 7 | 7 | 28859 | 2 | |||
28300 | 11246 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1145X Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/09/2003 12:00:00 AM | 16 | 3x4 | 6017856.860905 | 2093896.4273305 | 37.7304418229718 | -122.380553976439 | (37.7304418229718, -122.380553976439) | 10 | 3 | 8 | 58 | 1 | ||
28358 | 250782 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 271 32nd Ave | 1 | : | Tree | Private 2 | 15 | Width 3ft | 5985871.45629 | 2114116.47181 | 37.7841435573231 | -122.492619123386 | (37.7841435573231, -122.492619123386) | 11 | 6 | 1 | 55 | 33 | |||
28440 | 46586 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 498 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/05/2002 12:00:00 AM | Permit Number 44715 | 6005498.22104123 | 2100816.59479858 | 37.7487533087047 | -122.423771466824 | (37.7487533087047, -122.423771466824) | 2 | 4 | 5 | 28859 | 19 | ||
28584 | 43384 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 127 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2000 12:00:00 AM | 16 | Permit Number 43132 | 5993941.8721 | 2114666.09803 | 37.7861212585447 | -122.464738521118 | (37.7861212585447, -122.464738521118) | 11 | 6 | 2 | 54 | 11 | ||
29400 | 57737 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 373 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/1976 12:00:00 AM | 16 | 3x3 | Permit Number 16655 | 6005509.467345 | 2101546.81860372 | 37.75075897011 | -122.423784491996 | (37.75075897011, -122.423784491996) | 2 | 4 | 5 | 28859 | 19 | |
30077 | 176367 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 0 Font Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 5989068.70923 | 2090618.6052 | 37.7198110969962 | -122.479837842465 | (37.7198110969962, -122.479837842465) | 1 | 8 | 4 | 64 | 14 | ||||
30316 | 64381 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1546 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1988 12:00:00 AM | 11 | Permit Number 25221 | 5982207.2717 | 2104557.9741 | 37.757683766928 | -122.504587243143 | (37.757683766928, -122.504587243143) | 1 | 8 | 3 | 56 | 35 | ||
30508 | 2008 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 500X Bosworth St | 1 | Median : Cutout | Tree | DPW 1 | 18 | 12x100 | 6002728.1222807 | 2095276.2570246 | 37.733384060718 | -122.432954679755 | (37.733384060718, -122.432954679755) | 2 | 7 | 5 | 63 | 7 | |||
31358 | 42182 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 715 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42466 | 6012416.63723338 | 2111137.79713862 | 37.7774811588558 | -122.400572401541 | (37.7774811588558, -122.400572401541) | 14 | 2 | 9 | 28856 | 34 | ||
32174 | 209187 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 156 Kensington Way | 1 | Back Yard : Yard | Tree | Private 2 | 9 | Width 3ft | 5994832.74004 | 2098518.64338 | 37.7418358608449 | -122.460485895213 | (37.7418358608449, -122.460485895213) | 1 | 8 | 4 | 59 | 40 | |||
32294 | 191857 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1196 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 29 | Width 3ft | 6016960.00983 | 2094599.69699 | 37.7323233304366 | -122.383703493915 | (37.7323233304366, -122.383703493915) | 10 | 3 | 8 | 58 | 1 | |||
32456 | 68258 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 324 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 13 | Permit Number 32064 | 6009622.37802 | 2092856.7691 | 37.7271292968784 | -122.408948556441 | (37.7271292968784, -122.408948556441) | 10 | 3 | 7 | 309 | 28 | |
32534 | 41716 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 543 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2001 12:00:00 AM | Permit Number 44133 | 6008753.21337376 | 2096281.65864333 | 37.7364845820076 | -122.412195213265 | (37.7364845820076, -122.412195213265) | 10 | 7 | 7 | 28859 | 2 | ||
32733 | 11232 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1100X Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X4 | 6018021.124713 | 2094004.401623 | 37.7307473625426 | -122.379993586815 | (37.7307473625426, -122.379993586815) | 10 | 3 | 8 | 58 | 1 | |||
33705 | 209057 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 343 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5993721.84522 | 2105262.27376 | 37.7602881757702 | -122.464816588625 | (37.7602881757702, -122.464816588625) | 1 | 8 | 4 | 56 | 12 | |||
34279 | 191848 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1951 Revere Ave | 1 | Front Yard : Yard | Tree | Private 2 | 12 | 6013055.00993 | 2095902.15156 | 37.7356829763762 | -122.397295372485 | (37.7356829763762, -122.397295372485) | 10 | 3 | 8 | 58 | 1 | ||||
35303 | 176356 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 450 Italy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 2ft | 6001754.19818 | 2089213.77814 | 37.716682575925 | -122.435888171921 | (37.716682575925, -122.435888171921) | 9 | 7 | 6 | 28861 | 5 | |||
35463 | 209119 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 80 Terrace Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | Width 8ft | 5993141.78233 | 2096981.37016 | 37.7375174719512 | -122.46622093307 | (37.7375174719512, -122.46622093307) | 1 | 8 | 4 | 59 | 40 | |||
35872 | 200227 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1079 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 11 | Width 0ft | 6013668.3894 | 2090192.8153 | 37.7200404277679 | -122.394774954905 | (37.7200404277679, -122.394774954905) | 10 | 3 | 8 | 58 | 1 | |||
36385 | 2140 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1100X Bosworth St | 1 | Median : Cutout | Tree | DPW 1 | 18 | 4 | 6001043.628513 | 2095761.867481 | 37.7346217448773 | -122.438813219285 | (37.7346217448773, -122.438813219285) | 2 | 7 | 5 | 63 | 7 | |||
36410 | 191875 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1194 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6017468.81534 | 2094257.7246 | 37.731412453026 | -122.38192064014 | (37.731412453026, -122.38192064014) | 10 | 3 | 8 | 58 | 1 | |||
36752 | 209161 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 190 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5992857.63622 | 2095503.83625 | 37.7334441348404 | -122.467095959008 | (37.7334441348404, -122.467095959008) | 9 | 8 | 4 | 59 | 40 | |||
37725 | 191808 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 459 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6010674.0232 | 2106168.96556 | 37.7637405480973 | -122.406250539041 | (37.7637405480973, -122.406250539041) | 8 | 4 | 8 | 28859 | 19 | |||
38117 | 223961 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 650 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002363.39606 | 2104418.06661 | 37.7584646285442 | -122.43486917977 | (37.7584646285442, -122.43486917977) | 2 | 4 | 5 | 28862 | 3 | |||
39323 | 17318 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 98X Otis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006649.48331 | 2109199.16396 | 37.7718348142851 | -122.420385302261 | (37.7718348142851, -122.420385302261) | 8 | 2 | 9 | 28853 | 19 | |||
39392 | 41820 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 848 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/2016 12:00:00 AM | 3 | Permit Number 42207 | 6000005.684 | 2111868.9913 | 37.7787888536845 | -122.44355840768 | (37.7787888536845, -122.44355840768) | 15 | 5 | 11 | 29490 | 16 | |
39769 | 209103 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 15 Terrace Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 10ft | 5992879.73609 | 2097124.32062 | 37.7378948553616 | -122.467137333221 | (37.7378948553616, -122.467137333221) | 1 | 8 | 4 | 59 | 40 | |||
40180 | 191993 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1395 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 3ft | 6017281.31768 | 2093927.6967 | 37.7304959053633 | -122.382545906371 | (37.7304959053633, -122.382545906371) | 10 | 3 | 8 | 58 | 1 | |||
40226 | 10730 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1100 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6018138.7903974 | 2094650.7890521 | 37.7325287066123 | -122.379631682873 | (37.7325287066123, -122.379631682873) | 10 | 3 | 8 | 58 | 1 | |||
40573 | 12056 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1330X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3X3 | 6016860.8582794 | 2094712.6673543 | 37.732628043472 | -122.384054150964 | (37.732628043472, -122.384054150964) | 10 | 3 | 8 | 58 | 1 | |||
40747 | 4482 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1551 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6004606.71516 | 2099825.83197 | 37.7459825358766 | -122.426783743093 | (37.7459825358766, -122.426783743093) | 2 | 7 | 5 | 63 | 22 | |||
41080 | 223974 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2 Miguel St | 1 | Front Yard : Yard | Tree | Private 2 | 41 | 6003823.8109 | 2097275.52934 | 37.7389356956285 | -122.429309094259 | (37.7389356956285, -122.429309094259) | 2 | 7 | 5 | 63 | 7 | ||||
41325 | 191939 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1320 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6018082.22777 | 2094639.81643 | 37.7324954580022 | -122.379826473412 | (37.7324954580022, -122.379826473412) | 10 | 3 | 8 | 58 | 1 | |||
41769 | 209123 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 254 Juanita Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5995738.13053 | 2097948.40357 | 37.7403221669414 | -122.457314127542 | (37.7403221669414, -122.457314127542) | 9 | 7 | 4 | 59 | 40 | |||
42226 | 253679 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 94 Teresita Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4x8 | 5997405 | 2099153 | 37.7437252916895 | -122.451637655142 | (37.7437252916895, -122.451637655142) | 9 | 7 | 4 | 59 | 40 | ||||
42251 | 223942 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 3278 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006627.65386 | 2103224.52704 | 37.7554286324359 | -122.420036744005 | (37.7554286324359, -122.420036744005) | 2 | 4 | 7 | 28859 | 19 | |||
42559 | 191943 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1322 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6017914.02803 | 2094650.67309 | 37.7325159886087 | -122.38040874037 | (37.7325159886087, -122.38040874037) | 10 | 3 | 8 | 58 | 1 | |||
43551 | 126602 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1326 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6006516.79051 | 2119762.46986 | 37.8008315732811 | -122.421594667478 | (37.8008315732811, -122.421594667478) | 13 | 9 | 1 | 28858 | 32 | |||
45101 | 32670 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 450 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 25 | Permit Number 37094 | 6011135.7894 | 2112024.86418 | 37.7798453222359 | -122.405065778479 | (37.7798453222359, -122.405065778479) | 14 | 2 | 9 | 28853 | 34 | |
45492 | 191821 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1001 Wisconsin St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 27 | 6012841.53271 | 2102642.16113 | 37.7541777222338 | -122.398506249384 | (37.7541777222338, -122.398506249384) | 10 | 3 | 8 | 28856 | 29 | ||||
46048 | 209086 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 55 San Benito Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 8ft | 5992858.25535 | 2096418.47498 | 37.7359555402073 | -122.467160296506 | (37.7359555402073, -122.467160296506) | 1 | 8 | 4 | 59 | 40 | |||
46540 | 202107 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1833 Egbert Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 5ft | 6011947.78492 | 2092850.29831 | 37.727241516067 | -122.400909147944 | (37.727241516067, -122.400909147944) | 10 | 3 | 8 | 58 | 1 | |||
46907 | 209149 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 503 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5994146.82687 | 2106986.49091 | 37.7650469204046 | -122.46347191779 | (37.7650469204046, -122.46347191779) | 11 | 5 | 11 | 56 | 12 | |||
46912 | 126588 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 116 Alhambra St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 6001687.92804 | 2120423.89073 | 37.8023741929754 | -122.438351935704 | (37.8023741929754, -122.438351935704) | 13 | 9 | 1 | 57 | 17 | |||
47621 | 187606 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 101 Northridge Rd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6018884 | 2094052 | 37.730925622785 | -122.377013758979 | (37.730925622785, -122.377013758979) | 10 | 3 | 8 | 58 | 1 | ||||
47668 | 209108 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 10 Terrace Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 8ft | 5992797.09947 | 2097113.71953 | 37.7378609770082 | -122.467422275337 | (37.7378609770082, -122.467422275337) | 1 | 8 | 4 | 59 | 40 | |||
47962 | 223954 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 3729 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6004037.10862 | 2105956.8889 | 37.7627847531447 | -122.429190458394 | (37.7627847531447, -122.429190458394) | 8 | 4 | 5 | 28862 | 3 | |||
48497 | 68817 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 125 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2007 12:00:00 AM | Permit Number 49379 | 6000058.92001633 | 2094143.32486819 | 37.7301215326631 | -122.442101535638 | (37.7301215326631, -122.442101535638) | 9 | 7 | 4 | 63 | 40 | ||
50066 | 201391 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1051 Ingalls St | 1 | : | Tree | Private 2 | 21 | Width 4ft | 6018035.79915 | 2094923.7562 | 37.7332725396855 | -122.380006712838 | (37.7332725396855, -122.380006712838) | 10 | 3 | 8 | 58 | 1 |
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) );