trees
1,013 rows where qSpecies_id = 42 sorted by TreeID descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
54003 | 99640 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1000X Gilman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | City Owned Lot | 6015553.4063 | 2089548.403 | 37.7183756251523 | -122.38821408703 | (37.7183756251523, -122.38821408703) | 10 | 3 | 8 | 58 | 1 | ||
148520 | 99343 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 450 30th Ave | 21 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 24 | 3x3 | 5986574.07493 | 2113086.23058 | 37.781355867791 | -122.490112542148 | (37.781355867791, -122.490112542148) | 11 | 6 | 2 | 55 | 26 | ||
32232 | 99335 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 450 30th Ave | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 30 | 3.5x3.5 | 5986578.25407 | 2112899.8451 | 37.780844350584 | -122.490084370963 | (37.780844350584, -122.490084370963) | 11 | 6 | 2 | 55 | 26 | ||
80590 | 98954 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 302 Ivy St | 20 | Front Yard : Yard | Tree | Private 2 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | 7 | 9 | 11 | 28852 | 10 | |||||
71208 | 98953 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 302 Ivy St | 19 | Front Yard : Yard | Tree | Private 2 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | 7 | 9 | 11 | 28852 | 10 | |||||
151304 | 98896 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 37 Prosper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003347 | 2106314 | 37.7637262029221 | -122.431602796044 | (37.7637262029221, -122.431602796044) | 15 | 4 | 5 | 28862 | 3 | |||
147039 | 98216 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1501X 42nd Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 30 | 3x12 | 5983098.741 | 2104521.6922 | 37.7576365448231 | -122.501501543012 | (37.7576365448231, -122.501501543012) | 1 | 8 | 3 | 56 | 35 | ||
31906 | 98132 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1120X Hudson Ave | 47 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 22 | 3x4 | 6017903.8 | 2094987 | 37.733438911814 | -122.380467469044 | (37.733438911814, -122.380467469044) | 10 | 3 | 8 | 58 | 1 | |||
191713 | 97890 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 10 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 5x7 | 5994268.27564 | 2115530.11005 | 37.7885124127348 | -122.463671991785 | (37.7885124127348, -122.463671991785) | 11 | 6 | 1 | 54 | 11 | |||
116958 | 97405 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2@Melrose Stanford Heights Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5997807 | 2095590.8 | 37.7339673631019 | -122.449990957178 | (37.7339673631019, -122.449990957178) | 9 | 7 | 4 | 59 | 40 | |||||
128251 | 92101 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1076 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2009 12:00:00 AM | 3x3 | Permit Number 52984 | 6005698 | 2102695 | 37.7539222521842 | -122.423214136058 | (37.7539222521842, -122.423214136058) | 2 | 4 | 5 | 28859 | 19 | ||
63432 | 87256 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2 Garrison Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50279 | 6008242.3 | 2086782.6 | 37.7103734997874 | -122.413290127101 | (37.7103734997874, -122.413290127101) | 9 | 7 | 8 | 309 | 39 | |||
132051 | 87255 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2 Garrison Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2008 12:00:00 AM | 3x3 | Permit Number 50279 | 6008242.3 | 2086782.6 | 37.7103734997874 | -122.413290127101 | (37.7103734997874, -122.413290127101) | 9 | 7 | 8 | 309 | 39 | ||
187583 | 87251 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2 Argonaut Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50275 | 6008259 | 2086838.7 | 37.7105284764145 | -122.413236372693 | (37.7105284764145, -122.413236372693) | 9 | 7 | 8 | 309 | 39 | |||
180037 | 8595 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2355X Geary Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000490.27762 | 2113338.60243 | 37.7828516547291 | -122.441987525227 | (37.7828516547291, -122.441987525227) | 15 | 5 | 1 | 29490 | 41 | |||
147100 | 8594 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2355X Geary Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6000490.27762 | 2113338.60243 | 37.7828516547291 | -122.441987525227 | (37.7828516547291, -122.441987525227) | 15 | 5 | 1 | 29490 | 41 | |||
74441 | 8593 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2355X Geary Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000490.27762 | 2113338.60243 | 37.7828516547291 | -122.441987525227 | (37.7828516547291, -122.441987525227) | 15 | 5 | 1 | 29490 | 41 | |||
10687 | 8592 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2355X Geary Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6000490.27762 | 2113338.60243 | 37.7828516547291 | -122.441987525227 | (37.7828516547291, -122.441987525227) | 15 | 5 | 1 | 29490 | 41 | |||
122324 | 8590 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2355X Geary Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X3 | 6000490.27762 | 2113338.60243 | 37.7828516547291 | -122.441987525227 | (37.7828516547291, -122.441987525227) | 15 | 5 | 1 | 29490 | 41 | |||
88204 | 8589 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2355X Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6000490.27762 | 2113338.60243 | 37.7828516547291 | -122.441987525227 | (37.7828516547291, -122.441987525227) | 15 | 5 | 1 | 29490 | 41 | |||
182739 | 8587 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2355X Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6000490.27762 | 2113338.60243 | 37.7828516547291 | -122.441987525227 | (37.7828516547291, -122.441987525227) | 15 | 5 | 1 | 29490 | 41 | |||
62920 | 84960 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2616 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2007 12:00:00 AM | Permit Number 49352 | 5988993.8 | 2097500 | 37.7387012975774 | -122.480600253763 | (37.7387012975774, -122.480600253763) | 1 | 8 | 3 | 29491 | 35 | |||
70280 | 83074 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1120X Hudson Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 6017910.2548511 | 2094654.90941097 | 37.7325274125135 | -122.380422079616 | (37.7325274125135, -122.380422079616) | 10 | 3 | 8 | 58 | 1 | ||||
183748 | 82939 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 741 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52449 | 6009171.80953 | 2110382.94472 | 37.775227013061 | -122.411744028881 | (37.775227013061, -122.411744028881) | 8 | 2 | 9 | 28853 | 34 | |
36647 | 7687 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 521 Francisco St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6008787.0132 | 2121079.8095 | 37.8045764073538 | -122.413831954826 | (37.8045764073538, -122.413831954826) | 3 | 1 | 10 | 308 | 23 | |||
11170 | 76785 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1501X 42nd Ave | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 24 | 3x12 | 5983097.8243 | 2104541.5546 | 37.75769102754 | -122.501506182606 | (37.75769102754, -122.501506182606) | 1 | 8 | 3 | 56 | 35 | ||
14697 | 76382 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1501X 42nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 25 | 3x12 | 5983091.4072 | 2104771.8049 | 37.7583228530818 | -122.501545408351 | (37.7583228530818, -122.501545408351) | 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 | |||
11726 | 73981 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1020 Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 22 | 6007232.56543 | 2114727.76624 | 37.7870478630276 | -122.418760525075 | (37.7870478630276, -122.418760525075) | 13 | 9 | 10 | 28858 | 21 | |||
19376 | 73855 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2301 Ortega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5986859.2227 | 2102304.8233 | 37.7517697676229 | -122.488333522296 | (37.7517697676229, -122.488333522296) | 1 | 8 | 3 | 29491 | 35 | |||
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 | |||
62194 | 73475 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 340 Ritch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/04/2008 12:00:00 AM | 3x3 | Permit Number 50288 | 6014252.15043428 | 2111690.62627274 | 37.7791012985319 | -122.394261419296 | (37.7791012985319, -122.394261419296) | 6 | 2 | 9 | 28856 | 34 | ||
97941 | 73437 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 201 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2008 12:00:00 AM | 8 | 4x4 | Permit Number 50063 | 5992414.36096 | 2114080.94062 | 37.7844263939246 | -122.46998063366 | (37.7844263939246, -122.46998063366) | 11 | 6 | 2 | 54 | 11 | |
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 | |||
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 | |||
176646 | 72854 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 24 Lunado Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/1998 12:00:00 AM | 5991516.52955398 | 2091408.89207172 | 37.7221229357531 | -122.471434223035 | (37.7221229357531, -122.471434223035) | 9 | 8 | 4 | 59 | 40 | ||||
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 | |||
4375 | 70461 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1130 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 17 | 6007328.12227 | 2115219.69478 | 37.7884039579183 | -122.418464813605 | (37.7884039579183, -122.418464813605) | 13 | 9 | 10 | 28858 | 21 | |||
86577 | 69756 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2 Garrison Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2008 12:00:00 AM | 3x3 | Permit Number 50279 | 6008252.26832326 | 2086801.73422247 | 37.7104265980746 | -122.413257026566 | (37.7104265980746, -122.413257026566) | 9 | 7 | 8 | 309 | 39 | ||
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 | ||
116641 | 68269 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 424 Somerset St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 13 | Permit Number 32076 | 6010049.76216 | 2092483.07672 | 37.7261271472388 | -122.407444753275 | (37.7261271472388, -122.407444753275) | 10 | 3 | 7 | 309 | 28 | |
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 | |
97483 | 67222 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 5428 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1992 12:00:00 AM | 12 | Permit Number 30681 | 5981782.23642 | 2111693.16407 | 37.7772499233167 | -122.506586330196 | (37.7772499233167, -122.506586330196) | 11 | 6 | 2 | 55 | 26 | |
118196 | 66497 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2468 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51581 | 6001708.326 | 2114654.8124 | 37.786534966555 | -122.437867898844 | (37.786534966555, -122.437867898844) | 13 | 6 | 11 | 29490 | 27 | |
143912 | 66268 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2008 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/1990 12:00:00 AM | 12 | Permit Number 29375 | 5986711.6119 | 2096941.9622 | 37.7370361716902 | -122.488449873835 | (37.7370361716902, -122.488449873835) | 1 | 8 | 3 | 29491 | 35 | ||
97556 | 66037 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2000 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1990 12:00:00 AM | 11 | Permit Number 29074 | 5986756.4233 | 2096936.5987 | 37.7370240595256 | -122.488294548713 | (37.7370240595256, -122.488294548713) | 1 | 8 | 3 | 29491 | 35 | ||
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 | ||
57559 | 6395 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 5X Rosie Lee Ln | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/19/1993 12:00:00 AM | 3 | 3X4 | 6018168.8629005 | 2094369.8502074 | 37.7317589621466 | -122.379508204595 | (37.7317589621466, -122.379508204595) | 10 | 3 | 8 | 58 | 1 | ||
65635 | 6176 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1075 Ellis St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005893.15301 | 2113273.27935 | 37.782978696051 | -122.423291166859 | (37.782978696051, -122.423291166859) | 7 | 9 | 11 | 28858 | 41 | |||
83071 | 61348 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2415 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/1984 12:00:00 AM | 24 | Permit Number 21253 | 6004509.78876 | 2117656.60033 | 37.7949360226241 | -122.42838955723 | (37.7949360226241, -122.42838955723) | 13 | 9 | 1 | 28858 | 27 | ||
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 | |
85574 | 56997 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 469 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/1974 12:00:00 AM | 14 | 4x4 | Permit Number 14254 | 6003301.68334873 | 2103280.29729908 | 37.7553938131292 | -122.431542939454 | (37.7553938131292, -122.431542939454) | 2 | 4 | 5 | 28862 | 22 | |
50519 | 55370 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 177 San Aleso Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2011 12:00:00 AM | 2x3 | Permit Number 767959 | 5993373.59500695 | 2094436.22943113 | 37.7305425193622 | -122.465234638195 | (37.7305425193622, -122.465234638195) | 9 | 8 | 4 | 59 | 40 | ||
117156 | 54684 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1234 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1992 12:00:00 AM | 14 | 3x3 | Permit Number 30565 | 5993019.12807809 | 2107069.22790191 | 37.76520905664 | -122.467378332531 | (37.76520905664, -122.467378332531) | 11 | 8 | 11 | 56 | 12 |
88717 | 54678 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 425 Wheeler Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/1972 12:00:00 AM | 10 | Permit Number 10509 | 6011983.59997 | 2086741.21676 | 37.7104692111425 | -122.40035642553 | (37.7104692111425, -122.40035642553) | 10 | 3 | 8 | 309 | 1 | ||
65919 | 52895 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1642 12th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2006 12:00:00 AM | 3x3 | Permit Number 48894 | 5992495.5632863 | 2104272.70590883 | 37.757500303864 | -122.468985668503 | (37.757500303864, -122.468985668503) | 1 | 8 | 4 | 56 | 12 | ||
146945 | 52587 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 690@ CABRILLO 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/27/2006 12:00:00 AM | Permit Number 48680 | 5989145.55322023 | 2110639.08863484 | 37.7747865297245 | -122.481037351164 | (37.7747865297245, -122.481037351164) | 11 | 6 | 2 | 55 | 26 | |||
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 | |
54000 | 50882 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2055 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2004 12:00:00 AM | Permit Number 47392 | 5991593.93786831 | 2101441.81632133 | 37.7496752859252 | -122.471897503797 | (37.7496752859252, -122.471897503797) | 1 | 8 | 4 | 29491 | 12 | ||
101184 | 49935 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2526 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/02/2003 12:00:00 AM | 14 | Permit Number 46695 | 5988329.1563 | 2098089.6264 | 37.7402816069206 | -122.48294145156 | (37.7402816069206, -122.48294145156) | 1 | 8 | 3 | 29491 | 35 | |
52868 | 49746 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 40@ LELAND Britton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | Permit Number 46545 | 6008551.24165341 | 2087877.47374564 | 37.7133971377495 | -122.412299691068 | (37.7133971377495, -122.412299691068) | 9 | 7 | 8 | 309 | 39 | ||
71509 | 4895 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 10 Rosie Lee Ln | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/19/1993 12:00:00 AM | 12 | 3X4 | 6018140.88218 | 2094365.07214 | 37.7317442992597 | -122.379604608867 | (37.7317442992597, -122.379604608867) | 10 | 3 | 8 | 58 | 1 | ||
105632 | 48625 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1548 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | Permit Number 45922 | 5992473.51988967 | 2104913.75628044 | 37.7592591867123 | -122.469108556949 | (37.7592591867123, -122.469108556949) | 1 | 8 | 4 | 56 | 12 | ||
117506 | 47203 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2801X Clement St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/08/2002 12:00:00 AM | 10 | 3x3 | Permit Number 45157 | 5986727.74959 | 2113216.77029 | 37.7817232655044 | -122.489590512271 | (37.7817232655044, -122.489590512271) | 11 | 6 | 2 | 55 | 26 |
178939 | 47202 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2801X Clement St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/08/2002 12:00:00 AM | 12 | 3x3 | Permit Number 45157 | 5986698.68199 | 2113217.08014 | 37.7817224192006 | -122.489691093913 | (37.7817224192006, -122.489691093913) | 11 | 6 | 2 | 55 | 26 |
38966 | 47201 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2801X Clement St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/08/2002 12:00:00 AM | 8 | 3x3 | Permit Number 45157 | 5986666.18051 | 2113215.92346 | 37.7817173456419 | -122.489803447111 | (37.7817173456419, -122.489803447111) | 11 | 6 | 2 | 55 | 26 |
136473 | 47200 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2801X Clement St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/08/2002 12:00:00 AM | 6 | 3x3 | Permit Number 45157 | 5986636.79042 | 2113215.6243 | 37.7817148081587 | -122.489905099586 | (37.7817148081587, -122.489905099586) | 11 | 6 | 2 | 55 | 26 |
174849 | 47197 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2899X Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/08/2002 12:00:00 AM | 3 | 3x3 | 5986581.22601267 | 2112881.07204474 | 37.7807929786872 | -122.490072708464 | (37.7807929786872, -122.490072708464) | 11 | 6 | 2 | 55 | 26 | |
55158 | 46916 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 161 Newman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/2013 12:00:00 AM | Permit Number 769519 | 6007338.4828929 | 2096787.18196624 | 37.7377931534639 | -122.417122358052 | (37.7377931534639, -122.417122358052) | 2 | 7 | 7 | 28859 | 2 | ||
98305 | 46613 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 394 Fair Oaks St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | Permit Number 44735. Tree 4 on 25th St. | 6005464.68638444 | 2101420.18882448 | 37.750408745884 | -122.423930345056 | (37.750408745884, -122.423930345056) | 2 | 4 | 5 | 28859 | 19 | ||
170051 | 46612 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 394 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | Permit Number 44735. Tree 1 on 25th St | 6005464.68638444 | 2101420.18882448 | 37.750408745884 | -122.423930345056 | (37.750408745884, -122.423930345056) | 2 | 4 | 5 | 28859 | 19 | ||
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 | ||
149333 | 46585 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 496 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/05/2002 12:00:00 AM | Permit Number 44714 | 6005497.60346294 | 2100827.74105942 | 37.7487838789143 | -122.423774394842 | (37.7487838789143, -122.423774394842) | 2 | 4 | 5 | 28859 | 19 | ||
170110 | 45473 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1301 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2001 12:00:00 AM | Permit Number 44252 | 5993960.36650023 | 2094413.72258595 | 37.730514541433 | -122.463204465727 | (37.730514541433, -122.463204465727) | 9 | 8 | 4 | 59 | 40 | ||
189988 | 45055 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2311 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2011 12:00:00 AM | 1 | Permit Number 767715 | 5988234.443 | 2099548.661 | 37.7442822204704 | -122.483375858058 | (37.7442822204704, -122.483375858058) | 1 | 8 | 3 | 29491 | 35 | ||
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 | |||
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 | |||
184690 | 4479 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1542 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6004543.28364 | 2099929.08192 | 37.7462624498637 | -122.427010433384 | (37.7462624498637, -122.427010433384) | 2 | 7 | 5 | 63 | 22 | |||
82945 | 44723 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1946 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/2001 12:00:00 AM | 13 | Permit Number 43842 | 5989432.8015 | 2102080.7043 | 37.751304216428 | -122.479417445147 | (37.751304216428, -122.479417445147) | 1 | 8 | 3 | 29491 | 35 | |
184179 | 4470 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1500 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6004528.8343 | 2100105.60966 | 37.7467463372682 | -122.42707296864 | (37.7467463372682, -122.42707296864) | 2 | 7 | 5 | 63 | 22 | |||
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 | |||
169807 | 4466 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1484 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6004525.42539 | 2100206.65772 | 37.7470235991542 | -122.427091952431 | (37.7470235991542, -122.427091952431) | 2 | 7 | 5 | 63 | 22 | |||
193779 | 4461 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1451 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6004572.77209 | 2100404.42204 | 37.7475692915908 | -122.426942314243 | (37.7475692915908, -122.426942314243) | 2 | 7 | 5 | 63 | 22 | |||
90309 | 44205 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 341 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1986 12:00:00 AM | Permit Number 43653 | 6007751.99799899 | 2097517.30165944 | 37.739821155436 | -122.415744314793 | (37.739821155436, -122.415744314793) | 2 | 7 | 7 | 28859 | 2 | ||
143495 | 43992 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 141 Hampshire St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2000 12:00:00 AM | 13 | Permit Number 43551 | 6010011.61771 | 2107517.81839 | 37.7674071146631 | -122.408636765987 | (37.7674071146631, -122.408636765987) | 8 | 4 | 8 | 28853 | 19 | ||
120843 | 4372 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1007 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | 3X3 | 6000961.42259 | 2096155.46194 | 37.7356977864326 | -122.439125632357 | (37.7356977864326, -122.439125632357) | 2 | 7 | 5 | 63 | 7 | |||
77586 | 43523 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1442 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2000 12:00:00 AM | Permit Number 43199 | 6000900.07851404 | 2110723.16086375 | 37.7756936614931 | -122.44038215551 | (37.7756936614931, -122.44038215551) | 15 | 5 | 11 | 29492 | 10 | ||
167704 | 43517 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 165 Newman St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2000 12:00:00 AM | Permit Number 43192 | 6007354.1406378 | 2096784.95342482 | 37.7377879152119 | -122.41706806364 | (37.7377879152119, -122.41706806364) | 2 | 7 | 7 | 28859 | 2 | ||
115243 | 43516 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 165 Newman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2000 12:00:00 AM | Permit Number 43192 | 6007354.1406378 | 2096784.95342482 | 37.7377879152119 | -122.41706806364 | (37.7377879152119, -122.41706806364) | 2 | 7 | 7 | 28859 | 2 | ||
73058 | 43515 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 165 Newman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2000 12:00:00 AM | Permit Number 43192 | 6007354.1406378 | 2096784.95342482 | 37.7377879152119 | -122.41706806364 | (37.7377879152119, -122.41706806364) | 2 | 7 | 7 | 28859 | 2 | ||
103984 | 43507 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 161 Newman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2013 12:00:00 AM | Permit Number 769519 | 6007338.4828929 | 2096787.18196624 | 37.7377931534639 | -122.417122358052 | (37.7377931534639, -122.417122358052) | 2 | 7 | 7 | 28859 | 2 | |||
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 | ||
102586 | 43168 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 285 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 14 | 3x3 | Permit Number 42977 | 6005738.99154 | 2092366.96158 | 37.7255660943895 | -122.422338611837 | (37.7255660943895, -122.422338611837) | 9 | 7 | 7 | 309 | 5 |
98836 | 43022 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 71 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42883 | 6005491.3790618 | 2109225.31619528 | 37.7718412930396 | -122.424393129042 | (37.7718412930396, -122.424393129042) | 7 | 9 | 5 | 28852 | 10 | ||
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 | |||
176639 | 42670 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1575 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42698 | 6006081.0251203 | 2117910.0746574 | 37.7957207841663 | -122.422970868865 | (37.7957207841663, -122.422970868865) | 13 | 9 | 10 | 28858 | 32 | ||
156590 | 4253 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 4078 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003401.3861068 | 2100414.7966431 | 37.7475314732241 | -122.430993634389 | (37.7475314732241, -122.430993634389) | 2 | 4 | 5 | 63 | 22 | |||
132596 | 4252 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 4072 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003430.39643 | 2100411.11399 | 37.7475230052872 | -122.430893055767 | (37.7475230052872, -122.430893055767) | 2 | 4 | 5 | 63 | 22 | |||
65822 | 42484 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 50 Phelan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997088.18001 | 2092254.31401 | 37.7247650096883 | -122.452235460018 | (37.7247650096883, -122.452235460018) | 9 | 7 | 4 | 28861 | 40 | ||
85177 | 42477 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 50 Phelan Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997094.69001 | 2092414.90401 | 37.7252063248445 | -122.452224537935 | (37.7252063248445, -122.452224537935) | 9 | 7 | 4 | 28861 | 40 |
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) );