trees
3,709 rows where qSpecies_id = 9 sorted by YCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1005 | 39481 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 0 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | Permit Number 40941 | |||||||||||||
2927 | 35280 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38758 | ||||||||||||||
4304 | 17630 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 150 Phelps St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10M | |||||||||||||
6966 | 35281 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38758 | ||||||||||||||
10720 | 39483 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 0 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | Permit Number 40941 | |||||||||||||
13401 | 35284 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38758 | ||||||||||||||
14355 | 35285 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38758 | ||||||||||||||
15594 | 19769 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 STAIRWAY16 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30ST | |||||||||||||
16339 | 39482 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 0 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | Permit Number 40941 | |||||||||||||
17767 | 35283 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38758 | ||||||||||||||
17923 | 19768 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 STAIRWAY16 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30ST | |||||||||||||
18560 | 19875 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 STAIRWAY33 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST | |||||||||||||
39593 | 177857 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 435 Sunnydale Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010447.87727 | 2086216.06651 | 37.7089414959281 | -122.405627274705 | (37.7089414959281, -122.405627274705) | 9 | 7 | 8 | 309 | 39 | |||
69184 | 177856 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 435 Sunnydale Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010405.93473 | 2086233.77097 | 37.7089877633386 | -122.405773481086 | (37.7089877633386, -122.405773481086) | 9 | 7 | 8 | 309 | 39 | |||
103752 | 177855 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 435 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010393.78556 | 2086237.29466 | 37.7089967592527 | -122.405815718633 | (37.7089967592527, -122.405815718633) | 9 | 7 | 8 | 309 | 39 | |||
159567 | 177906 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 345 Schwerin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008626.38347 | 2086318.08135 | 37.7091195832832 | -122.411929844982 | (37.7091195832832, -122.411929844982) | 9 | 7 | 8 | 309 | 39 | |||
79174 | 177907 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 345 Schwerin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008650.42437 | 2086374.37251 | 37.7092754960461 | -122.411850730737 | (37.7092754960461, -122.411850730737) | 9 | 7 | 8 | 309 | 39 | |||
168383 | 177908 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 345 Schwerin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008656.15761 | 2086392.69055 | 37.7093261152759 | -122.411832209211 | (37.7093261152759, -122.411832209211) | 9 | 7 | 8 | 309 | 39 | |||
103165 | 177909 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 345 Schwerin St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008661.36431 | 2086409.07843 | 37.7093714051391 | -122.411815371178 | (37.7093714051391, -122.411815371178) | 9 | 7 | 8 | 309 | 39 | |||
100182 | 177910 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 345 Schwerin St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008668.51888 | 2086425.42684 | 37.7094166958987 | -122.411791798152 | (37.7094166958987, -122.411791798152) | 9 | 7 | 8 | 309 | 39 | |||
12429 | 71684 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 163 Wilson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5994555.12862 | 2086427.38157 | 37.7086202032335 | -122.460569802865 | (37.7086202032335, -122.460569802865) | 9 | 8 | 6 | 28861 | 25 | |||
12031 | 262472 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 210 Drake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5x5 | 6001697 | 2086437 | 37.7090549070704 | -122.435887307636 | (37.7090549070704, -122.435887307636) | 9 | 7 | 6 | 28861 | 5 | |||
16427 | 262473 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 210 Drake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5x5 | 6001697 | 2086437 | 37.7090549070704 | -122.435887307636 | (37.7090549070704, -122.435887307636) | 9 | 7 | 6 | 28861 | 5 | |||
74981 | 177911 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 345 Schwerin St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008674.64983 | 2086439.3705 | 37.7094553262778 | -122.411771593104 | (37.7094553262778, -122.411771593104) | 9 | 7 | 8 | 309 | 39 | |||
26752 | 114959 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 517 Cordova St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2015 12:00:00 AM | 1 | Permit Number 776031 | 6002108.88292 | 2086505.11384 | 37.7092653220046 | -122.434468647828 | (37.7092653220046, -122.434468647828) | 9 | 7 | 6 | 28861 | 5 | ||
43139 | 15961 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 5873 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2015 12:00:00 AM | 3 | 3X3 | 5997080.5771 | 2086512.68949 | 37.7089994077614 | -122.451847724407 | (37.7089994077614, -122.451847724407) | 9 | 7 | 6 | 28861 | 5 | ||
57304 | 255830 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 19 Rhine St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | Width 3ft | 5994504.97936 | 2086701.61608 | 37.7093703016665 | -122.460762984428 | (37.7093703016665, -122.460762984428) | 9 | 8 | 6 | 28861 | 25 | ||||
65046 | 177912 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 19 Rhine St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994504.97936 | 2086701.61608 | 37.7093703016665 | -122.460762984428 | (37.7093703016665, -122.460762984428) | 9 | 8 | 6 | 28861 | 25 | |||
46762 | 63750 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 257 Wilson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/1987 12:00:00 AM | 4 | 3x3 | Permit Number 53166 | 5994190.03084 | 2086756.53194 | 37.7095029615507 | -122.461855469155 | (37.7095029615507, -122.461855469155) | 9 | 8 | 6 | 28861 | 25 | |
56800 | 15929 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 5763 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/1992 12:00:00 AM | 6 | 3X3 | 5997783.78018 | 2086793.93661 | 37.7098118993789 | -122.44943761417 | (37.7098118993789, -122.44943761417) | 9 | 7 | 6 | 28861 | 5 | ||
79228 | 178039 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 215 Naylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002599.14033 | 2086803.44628 | 37.7101122954033 | -122.432795540083 | (37.7101122954033, -122.432795540083) | 9 | 7 | 6 | 28861 | 5 | |||
66485 | 15930 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 5763 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/1992 12:00:00 AM | 6 | 3X3 | 5997809.15318 | 2086804.38451 | 37.7098420383501 | -122.449350673092 | (37.7098420383501, -122.449350673092) | 9 | 7 | 6 | 28861 | 5 | ||
132925 | 178040 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 215 Naylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002585.09291 | 2086817.59549 | 37.7101503493261 | -122.432845100837 | (37.7101503493261, -122.432845100837) | 9 | 7 | 6 | 28861 | 5 | |||
13935 | 61515 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 84 De Long St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1984 12:00:00 AM | 11 | 3x3 | Permit Number 21471 | 5994704.395 | 2086819.71376 | 37.7097060419596 | -122.460082326249 | (37.7097060419596, -122.460082326249) | 9 | 8 | 6 | 28861 | 25 |
159775 | 178041 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 215 Naylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002576.29387 | 2086830.58656 | 37.7101855209097 | -122.432876439519 | (37.7101855209097, -122.432876439519) | 9 | 7 | 6 | 28861 | 5 | |||
93136 | 44455 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 95 Winding Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | Permit Number 43779 | 6002576.22413505 | 2086867.96270094 | 37.710288143695 | -122.432879348949 | (37.710288143695, -122.432879348949) | 9 | 7 | 6 | 28861 | 5 | ||
67941 | 44449 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 81 Winding Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2003 12:00:00 AM | 3 | Permit Number 43778 | 6002622.57283 | 2086916.9861 | 37.7104253799983 | -122.432722658146 | (37.7104253799983, -122.432722658146) | 9 | 7 | 6 | 28861 | 5 | ||
97859 | 44450 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 81 Winding Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2003 12:00:00 AM | 4 | Permit Number 43778 | 6002632.26196 | 2086926.65539 | 37.7104524792676 | -122.432689860747 | (37.7104524792676, -122.432689860747) | 9 | 7 | 6 | 28861 | 5 | ||
61845 | 178032 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 125 Naylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002475.30703 | 2086957.14807 | 37.7105273028639 | -122.433234507292 | (37.7105273028639, -122.433234507292) | 9 | 7 | 6 | 28861 | 5 | |||
137421 | 15901 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 5600 Mission St | 1 | Median : Cutout | Tree | DPW 1 | 03/10/1995 12:00:00 AM | 6 | 20 | 5998236.34112 | 2087033.73083 | 37.710496198018 | -122.447890739788 | (37.710496198018, -122.447890739788) | 9 | 7 | 6 | 28861 | 5 | ||
178284 | 15903 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 5600 Mission St | 3 | Median : Cutout | Tree | DPW 1 | 06/01/1992 12:00:00 AM | 6 | TR20 | 5998269.83738 | 2087060.55751 | 37.7105717725495 | -122.447776900011 | (37.7105717725495, -122.447776900011) | 9 | 7 | 6 | 28861 | 5 | ||
117765 | 31670 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 305 Wheeler Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 35178 | 6012134.6965622 | 2087196.99456235 | 37.7117291112295 | -122.399866184073 | (37.7117291112295, -122.399866184073) | 10 | 3 | 8 | 309 | 1 | ||||
71459 | 15889 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 5630 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/1992 12:00:00 AM | 3 | 3x3 | 5998415.18601 | 2087264.53084 | 37.7111401434751 | -122.447289216406 | (37.7111401434751, -122.447289216406) | 9 | 7 | 6 | 28861 | 25 | ||
31363 | 15887 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 5619 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1992 12:00:00 AM | 6 | 3X3 | 5998592.6313 | 2087274.30395 | 37.7111771161033 | -122.446676627145 | (37.7111771161033, -122.446676627145) | 9 | 7 | 6 | 28861 | 5 | ||
122916 | 177875 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 5630 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5998500.80606 | 2087290.46658 | 37.7112162492151 | -122.446995158907 | (37.7112162492151, -122.446995158907) | 9 | 7 | 6 | 28861 | 25 | |||
4405 | 78800 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 214 Curtis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6000803.49845 | 2087336.82758 | 37.7114748366708 | -122.439039819944 | (37.7114748366708, -122.439039819944) | 9 | 7 | 6 | 28861 | 5 | |||
148967 | 177874 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1222 Naples St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 8ft | 6001049.49395 | 2087346.60283 | 37.7115156712695 | -122.438190296958 | (37.7115156712695, -122.438190296958) | 9 | 7 | 6 | 28861 | 5 | |||
11500 | 80930 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 214 Curtis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6000799.22346 | 2087352.62937 | 37.7115179816306 | -122.439055727159 | (37.7115179816306, -122.439055727159) | 9 | 7 | 6 | 28861 | 5 | |||
136305 | 44441 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 31 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 10 | Permit Number 43773 | 6002845.03197 | 2087419.58283 | 37.711818015263 | -122.431989658494 | (37.711818015263, -122.431989658494) | 9 | 7 | 6 | 28861 | 5 | |
121948 | 177876 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 4117 San Bruno Ave | 1 | : Yard | Tree | Private 2 | 37 | Width 10ft | 6011467.53014 | 2087476.31968 | 37.7124588649577 | -122.402191732263 | (37.7124588649577, -122.402191732263) | 10 | 7 | 8 | 309 | 39 | |||
185540 | 31048 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 15 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 5 | Permit Number 34804 | 6002823.26013 | 2087491.091 | 37.7120131267777 | -122.432070011132 | (37.7120131267777, -122.432070011132) | 9 | 7 | 6 | 28861 | 5 | |
28966 | 177879 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 13 South Hill Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 6002815.59518 | 2087508.97249 | 37.7120617908816 | -122.432097779506 | (37.7120617908816, -122.432097779506) | 9 | 7 | 6 | 28861 | 5 | |||
143103 | 210729 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2950 San Jose Ave | 3 | : | Tree | Private 2 | 3 | Width 3ft | 5996042.96304 | 2087509.51727 | 37.711676981779 | -122.455505847225 | (37.711676981779, -122.455505847225) | 9 | 8 | 6 | 28861 | 24 | |||
115742 | 177899 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 50 Cora St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009624.90275 | 2087518.7442 | 37.7124723296001 | -122.408563436168 | (37.7124723296001, -122.408563436168) | 9 | 7 | 8 | 309 | 39 | |||
138774 | 177898 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 50 Cora St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009629.15466 | 2087530.63547 | 37.7125052187279 | -122.408549578497 | (37.7125052187279, -122.408549578497) | 9 | 7 | 8 | 309 | 39 | |||
20943 | 54784 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 201 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50703 | 6012788.79472 | 2087552.61474 | 37.7127420182918 | -122.397630353754 | (37.7127420182918, -122.397630353754) | 10 | 3 | 8 | 309 | 1 | |
88825 | 177897 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 50 Cora St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009646.02707 | 2087571.54793 | 37.7126185009114 | -122.40849414611 | (37.7126185009114, -122.40849414611) | 9 | 7 | 8 | 309 | 39 | |||
114374 | 177896 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 50 Cora St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009653.1272 | 2087592.03175 | 37.7126751429257 | -122.408471049717 | (37.7126751429257, -122.408471049717) | 9 | 7 | 8 | 309 | 39 | |||
130857 | 177895 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 50 Cora St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009660.88165 | 2087611.83636 | 37.7127299566062 | -122.40844564386 | (37.7127299566062, -122.40844564386) | 9 | 7 | 8 | 309 | 39 | |||
166361 | 178036 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1262 Athens St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001366.69902 | 2087629.73168 | 37.7123111162496 | -122.437114213161 | (37.7123111162496, -122.437114213161) | 9 | 7 | 6 | 28861 | 5 | |||
113441 | 178037 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1262 Athens St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6001347.43363 | 2087637.91162 | 37.7123324814346 | -122.437181385307 | (37.7123324814346, -122.437181385307) | 9 | 7 | 6 | 28861 | 5 | |||
88136 | 177900 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 51 Schwerin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009124.10018 | 2087641.97252 | 37.712782628998 | -122.410303065847 | (37.712782628998, -122.410303065847) | 9 | 7 | 8 | 309 | 39 | |||
160620 | 178038 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1262 Athens St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001333.95173 | 2087644.77472 | 37.7123505596017 | -122.437228473815 | (37.7123505596017, -122.437228473815) | 9 | 7 | 6 | 28861 | 5 | |||
78869 | 177878 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 271 Leland Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6009620.35706 | 2087649.33053 | 37.7128306384044 | -122.408588353684 | (37.7128306384044, -122.408588353684) | 9 | 7 | 8 | 309 | 39 | |||
131982 | 177885 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 145 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010318.89682 | 2087650.57593 | 37.7128731556567 | -122.406174049896 | (37.7128731556567, -122.406174049896) | 9 | 7 | 8 | 309 | 39 | |||
145563 | 177901 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 51 Schwerin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009128.04855 | 2087650.60904 | 37.7128065644385 | -122.410290028364 | (37.7128065644385, -122.410290028364) | 9 | 7 | 8 | 309 | 39 | |||
138938 | 177877 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 271 Leland Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6009599.34513 | 2087657.02792 | 37.7128505970487 | -122.408661520714 | (37.7128505970487, -122.408661520714) | 9 | 7 | 8 | 309 | 39 | |||
177827 | 177884 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 157 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010304.96026 | 2087658.72408 | 37.7128947492701 | -122.406222793148 | (37.7128947492701, -122.406222793148) | 9 | 7 | 8 | 309 | 39 | |||
123468 | 177902 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 51 Schwerin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009132.1984 | 2087661.60817 | 37.7128369984133 | -122.410276461197 | (37.7128369984133, -122.410276461197) | 9 | 7 | 8 | 309 | 39 | |||
125419 | 177903 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 51 Schwerin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009134.31726 | 2087671.14606 | 37.712863306274 | -122.410269810704 | (37.712863306274, -122.410269810704) | 9 | 7 | 8 | 309 | 39 | |||
126680 | 177904 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 51 Schwerin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009137.70556 | 2087680.01903 | 37.7128878595589 | -122.410258725671 | (37.7128878595589, -122.410258725671) | 9 | 7 | 8 | 309 | 39 | |||
52307 | 177905 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 51 Schwerin St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009142.42849 | 2087691.42012 | 37.7129194293531 | -122.410243206079 | (37.7129194293531, -122.410243206079) | 9 | 7 | 8 | 309 | 39 | |||
60716 | 31049 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 15 South Hill Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34804 | 6002647.46614225 | 2087728.93921016 | 37.712656237769 | -122.432694584455 | (37.712656237769, -122.432694584455) | 9 | 7 | 6 | 28861 | 5 | ||
2357 | 210723 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 221 Sadowa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5994792.87709 | 2087738.88584 | 37.7122349616579 | -122.459843056229 | (37.7122349616579, -122.459843056229) | 9 | 8 | 6 | 28861 | 24 | |||
54717 | 210722 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 289 Sadowa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5994123.30764 | 2087748.05271 | 37.7122216022051 | -122.462157933667 | (37.7122216022051, -122.462157933667) | 9 | 8 | 6 | 28861 | 24 | |||
60675 | 210721 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 291 Sadowa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5994097.27835 | 2087749.40952 | 37.7122238289438 | -122.462247996255 | (37.7122238289438, -122.462247996255) | 9 | 8 | 6 | 28861 | 24 | |||
123093 | 210720 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 293 Sadowa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5994069.59594 | 2087749.58457 | 37.7122227155888 | -122.462343686818 | (37.7122227155888, -122.462343686818) | 9 | 8 | 6 | 28861 | 24 | |||
60506 | 210719 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 293 Sadowa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5994040.58934 | 2087749.69636 | 37.7122213522043 | -122.462443949551 | (37.7122213522043, -122.462443949551) | 9 | 8 | 6 | 28861 | 24 | |||
178409 | 52763 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 214@ CAPITOL Sadowa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2006 12:00:00 AM | Permit Number 48805 | 5994863.65888503 | 2087784.21075389 | 37.7123634836076 | -122.459601695791 | (37.7123634836076, -122.459601695791) | 9 | 8 | 6 | 28861 | 24 | |||
106817 | 210724 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 290 Sadowa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5994126.31953 | 2087786.89432 | 37.712328425493 | -122.462150338865 | (37.712328425493, -122.462150338865) | 9 | 8 | 6 | 28861 | 24 | |||
130484 | 178035 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1378x Geneva Ave | 3 | Median : Yard | Tree | DPW 1 | 6 | 6002505.07902 | 2087811.4607 | 37.7128747474362 | -122.433192611453 | (37.7128747474362, -122.433192611453) | 9 | 7 | 6 | 28861 | 5 | ||||
193433 | 178034 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1378x Geneva Ave | 2 | Median : Yard | Tree | DPW 1 | 7 | 6002495.00651 | 2087816.3446 | 37.7128875861582 | -122.433227774048 | (37.7128875861582, -122.433227774048) | 9 | 7 | 6 | 28861 | 5 | ||||
124743 | 178033 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1378x Geneva Ave | 1 | Median : Yard | Tree | DPW 1 | 6 | 6002471.97564 | 2087830.38013 | 37.712924818104 | -122.433308378475 | (37.712924818104, -122.433308378475) | 9 | 7 | 6 | 28861 | 5 | ||||
9405 | 177889 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 151 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010419.89966 | 2087893.48861 | 37.7135457936846 | -122.405842049878 | (37.7135457936846, -122.405842049878) | 9 | 7 | 8 | 309 | 39 | |||
98192 | 177888 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 153 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010396.8058 | 2087905.2937 | 37.713576916505 | -122.405922701993 | (37.713576916505, -122.405922701993) | 9 | 7 | 8 | 309 | 39 | |||
111407 | 177886 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 150 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010436.54388 | 2087928.28734 | 37.7136422747528 | -122.405786970918 | (37.7136422747528, -122.405786970918) | 9 | 7 | 8 | 309 | 39 | |||
146995 | 112519 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 152x Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6010410.07132 | 2087941.8611 | 37.7136780650609 | -122.4058794257 | (37.7136780650609, -122.4058794257) | 9 | 7 | 8 | 309 | 39 | |||
88851 | 177887 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 154 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010389.20709 | 2087951.35398 | 37.7137029636965 | -122.405952208735 | (37.7137029636965, -122.405952208735) | 9 | 7 | 8 | 309 | 39 | |||
152052 | 15867 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 5425 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 5 | 5999480.67108 | 2088101.53675 | 37.7134991989131 | -122.443666741949 | (37.7134991989131, -122.443666741949) | 9 | 7 | 6 | 28861 | 5 | |||
41065 | 64630 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 68 Curtis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/1988 12:00:00 AM | 1 | Permit Number 25540 | 6000598.45356 | 2088164.29184 | 37.7137351998869 | -122.439807795106 | (37.7137351998869, -122.439807795106) | 9 | 7 | 6 | 28861 | 5 | ||
57979 | 210740 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 146 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5992981.03901 | 2088189.5314 | 37.7133679617255 | -122.466137980489 | (37.7133679617255, -122.466137980489) | 9 | 8 | 6 | 64 | 24 | |||
184092 | 187618 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 146 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993007 | 2088191 | 37.71337349192 | -122.466048357651 | (37.71337349192, -122.466048357651) | 9 | 8 | 6 | 64 | 24 | ||||
122109 | 50498 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 924 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/2003 12:00:00 AM | 6 | Permit Number 47135 | 6002542.62317 | 2088276.78564 | 37.7141545573574 | -122.433096072852 | (37.7141545573574, -122.433096072852) | 9 | 7 | 6 | 28861 | 5 | |
74360 | 177864 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 989 Naples St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001714.74238 | 2088380.40679 | 37.7143920818056 | -122.43596495334 | (37.7143920818056, -122.43596495334) | 9 | 7 | 6 | 28861 | 5 | |||
125789 | 210712 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 227 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5994692.03797 | 2088381.38184 | 37.7139933044348 | -122.460238104111 | (37.7139933044348, -122.460238104111) | 9 | 8 | 6 | 28861 | 24 | |||
193284 | 177865 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 989 Naples St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001720.67634 | 2088389.37557 | 37.7144170451902 | -122.43594508462 | (37.7144170451902, -122.43594508462) | 9 | 7 | 6 | 28861 | 5 | |||
158288 | 177866 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 989 Naples St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001726.64511 | 2088400.0268 | 37.7144466301838 | -122.43592521588 | (37.7144466301838, -122.43592521588) | 9 | 7 | 6 | 28861 | 5 | |||
175048 | 210714 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 224 Farallones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5994962.32691 | 2088416.70249 | 37.7141058302929 | -122.459306446031 | (37.7141058302929, -122.459306446031) | 9 | 8 | 6 | 28861 | 24 | |||
151450 | 210713 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 224 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5994996.38337 | 2088416.88945 | 37.7141083016242 | -122.459188748187 | (37.7141083016242, -122.459188748187) | 9 | 8 | 6 | 28861 | 24 | |||
113316 | 210715 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 224 Farallones St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5994922.2648 | 2088417.54139 | 37.7141058303022 | -122.459444975802 | (37.7141058303022, -122.459444975802) | 9 | 8 | 6 | 28861 | 24 |
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) );