trees
3,709 rows where qSpecies_id = 9 sorted by Zip Codes
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 | |||||||||||||
3891 | 232910 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 229 Haight St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004811.55535 | 2109480.0616 | 37.7725023496476 | -122.426762832059 | (37.7725023496476, -122.426762832059) | 7 | 9 | 5 | 28852 | 10 | |||
4258 | 232897 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 188 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004783.23018 | 2109050.50758 | 37.7713212969648 | -122.426830214663 | (37.7713212969648, -122.426830214663) | 7 | 9 | 5 | 28852 | 10 | |||
4903 | 88595 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 399 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52536 | 6004228 | 2109402 | 37.7722550008378 | -122.428775842479 | (37.7722550008378, -122.428775842479) | 7 | 9 | 11 | 28852 | 10 | ||
5721 | 246522 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 155 Laguna St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 6ft | 6005173.73012 | 2109399.79549 | 37.7723024285329 | -122.425504318986 | (37.7723024285329, -122.425504318986) | 7 | 9 | 5 | 28852 | 10 | |||
9805 | 246529 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 95 Laguna St | 2 | : | Tree | Private 2 | 10 | Width 4ft | 6005210.23202 | 2109136.89842 | 37.77158263905 | -122.425359343752 | (37.77158263905, -122.425359343752) | 7 | 9 | 5 | 28852 | 10 | |||
11761 | 10268 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 215X Haight St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 6005053.18335 | 2109512.97249 | 37.7726063733294 | -122.425929359246 | (37.7726063733294, -122.425929359246) | 7 | 9 | 5 | 28852 | 10 | ||||
22169 | 232905 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 190 Buchanan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004732.02467 | 2109415.61036 | 37.7723208853186 | -122.427033345413 | (37.7723208853186, -122.427033345413) | 7 | 9 | 5 | 28852 | 10 | |||
23635 | 131926 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 811 Turk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6006096.41704 | 2112784.17992 | 37.7816472182901 | -122.422553190084 | (37.7816472182901, -122.422553190084) | 7 | 9 | 11 | 28852 | 41 | |||
25642 | 103578 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 101X Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005198.60314 | 2109385.58511 | 37.772264815602 | -122.425417269432 | (37.772264815602, -122.425417269432) | 7 | 9 | 5 | 28852 | 10 | ||||
25812 | 42775 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 595 Hayes St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42746 | 6005021.69046201 | 2110898.204752 | 37.7764081042584 | -122.426136930931 | (37.7764081042584, -122.426136930931) | 7 | 9 | 11 | 28852 | 10 | ||
26421 | 246525 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 155 Laguna St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 6005186.06731 | 2109316.74693 | 37.7720750943316 | -122.425455732201 | (37.7720750943316, -122.425455732201) | 7 | 9 | 5 | 28852 | 10 | |||
27107 | 131933 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 67 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008167.61892 | 2112668.53563 | 37.7814463160347 | -122.415379603003 | (37.7814463160347, -122.415379603003) | 7 | 10 | 9 | 28852 | 36 | |||
30260 | 114430 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 455 EDDY ST | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3x3 | 6008254 | 2113439 | 37.7835666804498 | -122.415135318852 | (37.7835666804498, -122.415135318852) | 7 | 10 | 9 | 28852 | 36 | ||||
32165 | 103580 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 55X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.425234826708 | (37.7711001201992, -122.425234826708) | 7 | 9 | 5 | 28852 | 10 | ||||
32298 | 232914 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 229 Haight St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004909.91403 | 2109494.03243 | 37.7725462707313 | -122.426423594296 | (37.7725462707313, -122.426423594296) | 7 | 9 | 5 | 28852 | 10 | |||
33522 | 140025 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 619 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6005803.6906 | 2111825.1954 | 37.7789975628417 | -122.423497687453 | (37.7789975628417, -122.423497687453) | 7 | 9 | 11 | 28852 | 41 | |||
36989 | 9731 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 641 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 4x4 | 6005777.9079 | 2111995.4394 | 37.7794635560295 | -122.423598987459 | (37.7794635560295, -122.423598987459) | 7 | 9 | 11 | 28852 | 41 | |||
38591 | 103581 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 55X Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.425234826708 | (37.7711001201992, -122.425234826708) | 7 | 9 | 5 | 28852 | 10 | ||||
38691 | 9732 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 645 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/14/2011 12:00:00 AM | 3 | 4x4 | 6005775.5462 | 2112013.5463 | 37.7795131398465 | -122.423608445305 | (37.7795131398465, -122.423608445305) | 7 | 9 | 11 | 28852 | 41 | ||
40141 | 34838 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 94 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/1997 12:00:00 AM | Permit Number 38463 | 6004273.91738669 | 2109284.40431145 | 37.7719347104397 | -122.428608626151 | (37.7719347104397, -122.428608626151) | 7 | 9 | 11 | 28852 | 10 | |||
40305 | 114742 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 188 BUCHANAN ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 4x4 | 6004735 | 2109327 | 37.7720777510232 | -122.427016741179 | (37.7720777510232, -122.427016741179) | 7 | 9 | 5 | 28852 | 10 | |||
40829 | 42773 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 595 Hayes St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42746 | 6005021.69046201 | 2110898.204752 | 37.7764081042584 | -122.426136930931 | (37.7764081042584, -122.426136930931) | 7 | 9 | 11 | 28852 | 10 | ||
41602 | 114741 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 188 BUCHANAN ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 4x4 | 6004735 | 2109327 | 37.7720777510232 | -122.427016741179 | (37.7720777510232, -122.427016741179) | 7 | 9 | 5 | 28852 | 10 | |||
43500 | 103583 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 55X Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.425234826708 | (37.7711001201992, -122.425234826708) | 7 | 9 | 5 | 28852 | 10 | ||||
44605 | 246528 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 95 Laguna St | 1 | : | Tree | Private 2 | 13 | Width 7ft | 6005204.62433 | 2109172.65839 | 37.7716805104709 | -122.425381286315 | (37.7716805104709, -122.425381286315) | 7 | 9 | 5 | 28852 | 10 | |||
47658 | 232900 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 190 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004744.51087 | 2109324.00731 | 37.7720700716203 | -122.426983629118 | (37.7720700716203, -122.426983629118) | 7 | 9 | 5 | 28852 | 10 | |||
48372 | 9726 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 621 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6005799.3606 | 2111864.1645 | 37.7791043180853 | -122.423515437911 | (37.7791043180853, -122.423515437911) | 7 | 9 | 11 | 28852 | 41 | |||
49276 | 245866 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 227 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005127.6304 | 2109748.3565 | 37.773256887823 | -122.425688595356 | (37.773256887823, -122.425688595356) | 7 | 9 | 11 | 28852 | 10 | |||
54913 | 131928 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 57 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6008190.28209 | 2112514.30533 | 37.7810241104069 | -122.41529027784 | (37.7810241104069, -122.41529027784) | 7 | 10 | 9 | 28852 | 36 | |||
55613 | 114746 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 188 BUCHANAN ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 4x4 | 6004735 | 2109327 | 37.7720777510232 | -122.427016741179 | (37.7720777510232, -122.427016741179) | 7 | 9 | 5 | 28852 | 10 | |||
56389 | 232898 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 190 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004751.04399 | 2109279.15685 | 37.771947292552 | -122.426957835644 | (37.771947292552, -122.426957835644) | 7 | 9 | 5 | 28852 | 10 | |||
58407 | 232909 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 229 Haight St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004792.08371 | 2109478.77871 | 37.7724977262242 | -122.426830095058 | (37.7724977262242, -122.426830095058) | 7 | 9 | 5 | 28852 | 10 | |||
59953 | 232901 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 190 Buchanan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004740.99603 | 2109348.33209 | 37.7721366628156 | -122.426997520024 | (37.7721366628156, -122.426997520024) | 7 | 9 | 5 | 28852 | 10 | |||
62468 | 232903 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 190 Buchanan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004735.97961 | 2109381.85311 | 37.7722284197429 | -122.427017260159 | (37.7722284197429, -122.427017260159) | 7 | 9 | 5 | 28852 | 10 | |||
64751 | 10267 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 229X Haight St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 4x5 | 6004928.57518 | 2109497.01592 | 37.7725555175436 | -122.4263592559 | (37.7725555175436, -122.4263592559) | 7 | 9 | 5 | 28852 | 10 | |||
66898 | 9727 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 621 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6005801.3288 | 2111846.4513 | 37.779055793051 | -122.423507369454 | (37.779055793051, -122.423507369454) | 7 | 9 | 11 | 28852 | 41 | |||
68843 | 232916 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 213 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6005073.54336 | 2109516.34199 | 37.7726167757681 | -122.425859171679 | (37.7726167757681, -122.425859171679) | 7 | 9 | 5 | 28852 | 10 | |||
69588 | 10276 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 215X Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3X3 | 6004948.05546 | 2109498.71961 | 37.7725612966014 | -122.426291992897 | (37.7725612966014, -122.426291992897) | 7 | 9 | 5 | 28852 | 10 | |||
69849 | 131927 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 57 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6008192.35863 | 2112492.08012 | 37.7809632020188 | -122.415281520245 | (37.7809632020188, -122.415281520245) | 7 | 10 | 9 | 28852 | 36 | |||
75801 | 232436 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 98 Laussat St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6004291.45992 | 2109275.43151 | 37.7719110660771 | -122.428547305538 | (37.7719110660771, -122.428547305538) | 7 | 9 | 11 | 28852 | 10 | |||
75859 | 114743 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 188 BUCHANAN ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 4x4 | 6004735 | 2109327 | 37.7720777510232 | -122.427016741179 | (37.7720777510232, -122.427016741179) | 7 | 9 | 5 | 28852 | 10 | |||
78736 | 232907 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 229 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004758.59906 | 2109474.41705 | 37.7724838568662 | -122.426945611154 | (37.7724838568662, -122.426945611154) | 7 | 9 | 5 | 28852 | 10 | |||
79388 | 232908 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 229 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004775.12144 | 2109476.18153 | 37.7724896359272 | -122.426888584266 | (37.7724896359272, -122.426888584266) | 7 | 9 | 5 | 28852 | 10 | |||
80665 | 31344 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 254 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39121 | 6006126.25781902 | 2111278.60753762 | 37.7775149666293 | -122.422342949952 | (37.7775149666293, -122.422342949952) | 7 | 9 | 11 | 28852 | 10 | ||
82365 | 103579 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 101X Laguna St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005198.60314 | 2109385.58511 | 37.772264815602 | -122.425417269432 | (37.772264815602, -122.425417269432) | 7 | 9 | 5 | 28852 | 10 | ||||
86508 | 34839 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 94 Laussat St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/1997 12:00:00 AM | Permit Number 38463 | 6004273.91738669 | 2109284.40431145 | 37.7719347104397 | -122.428608626151 | (37.7719347104397, -122.428608626151) | 7 | 9 | 11 | 28852 | 10 | |||
86925 | 114745 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 188 BUCHANAN ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 4x4 | 6004735 | 2109327 | 37.7720777510232 | -122.427016741179 | (37.7720777510232, -122.427016741179) | 7 | 9 | 5 | 28852 | 10 | |||
91693 | 246530 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 95 Laguna St | 3 | : | Tree | Private 2 | 13 | Width 7ft | 6005220.62037 | 2109069.23024 | 37.7713974254703 | -122.425318593679 | (37.7713974254703, -122.425318593679) | 7 | 9 | 5 | 28852 | 10 | |||
93582 | 245837 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 451 Fell St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/1995 12:00:00 AM | 3 | Width 0ft | 6005362.4532 | 2110596.2894 | 37.7755983722601 | -122.424936650191 | (37.7755983722601, -122.424936650191) | 7 | 9 | 11 | 28852 | 10 | ||
93669 | 232913 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 229 Haight St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004866.27117 | 2109489.03769 | 37.7725300892179 | -122.426574203751 | (37.7725300892179, -122.426574203751) | 7 | 9 | 5 | 28852 | 10 | |||
96437 | 6921 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 425 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/09/2010 12:00:00 AM | 3 | 3X3 | 6005385.421 | 2110602.3829 | 37.7756164008395 | -122.424857632506 | (37.7756164008395, -122.424857632506) | 7 | 9 | 11 | 28852 | 10 | ||
97365 | 131930 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 57 Hyde St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6008182.65899 | 2112562.35593 | 37.7811556173851 | -122.41532005259 | (37.7811556173851, -122.41532005259) | 7 | 10 | 9 | 28852 | 36 | |||
99005 | 232918 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 213 Haight St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6005112.96946 | 2109521.84472 | 37.7726341129051 | -122.425723184286 | (37.7726341129051, -122.425723184286) | 7 | 9 | 5 | 28852 | 10 | |||
99027 | 114744 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 188 BUCHANAN ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 4x4 | 6004735 | 2109327 | 37.7720777510232 | -122.427016741179 | (37.7720777510232, -122.427016741179) | 7 | 9 | 5 | 28852 | 10 | |||
100306 | 258518 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 50 Hermann St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | ||||
103550 | 232915 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 215 Haight St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6005030.31421 | 2109510.9176 | 37.7725994386426 | -122.426008319741 | (37.7725994386426, -122.426008319741) | 7 | 9 | 5 | 28852 | 10 | |||
104105 | 246518 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 155 Laguna St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 7ft | 6005162.55314 | 2109484.17323 | 37.7725334778669 | -122.425548987397 | (37.7725334778669, -122.425548987397) | 7 | 9 | 5 | 28852 | 10 | |||
107094 | 9725 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 621 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6005796.9989 | 2111889.3567 | 37.779173356417 | -122.42352539952 | (37.779173356417, -122.42352539952) | 7 | 9 | 11 | 28852 | 41 | |||
112119 | 103587 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 55X Laguna St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.425234826708 | (37.7711001201992, -122.425234826708) | 7 | 9 | 5 | 28852 | 10 | ||||
115164 | 42776 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 595 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/03/2001 12:00:00 AM | Permit Number 42746 | 6005021.69046201 | 2110898.204752 | 37.7764081042584 | -122.426136930931 | (37.7764081042584, -122.426136930931) | 7 | 9 | 11 | 28852 | 10 | ||
115230 | 103577 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 101X Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005198.60314 | 2109385.58511 | 37.772264815602 | -122.425417269432 | (37.772264815602, -122.425417269432) | 7 | 9 | 5 | 28852 | 10 | ||||
116069 | 232917 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 213 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6005093.48055 | 2109519.72022 | 37.7726271782419 | -122.425790447293 | (37.7726271782419, -122.425790447293) | 7 | 9 | 5 | 28852 | 10 | |||
117169 | 42771 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 595 Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42746 | 6005021.69046201 | 2110898.204752 | 37.7764081042584 | -122.426136930931 | (37.7764081042584, -122.426136930931) | 7 | 9 | 11 | 28852 | 10 | ||
117399 | 139985 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 635 GOUGH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6005789.3231 | 2111954.5021 | 37.7793517965316 | -122.42355658612 | (37.7793517965316, -122.42355658612) | 7 | 9 | 11 | 28852 | 41 | |||
118437 | 96380 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 553 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6005168.9792 | 2111274.178 | 37.7774487586726 | -122.425654182863 | (37.7774487586726, -122.425654182863) | 7 | 9 | 11 | 28852 | 10 | |||
118629 | 9724 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 605X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 4x4 | 6005802.58314 | 2111825.66599 | 37.7789987924589 | -122.423501552072 | (37.7789987924589, -122.423501552072) | 7 | 9 | 11 | 28852 | 41 | |||
123392 | 131931 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 67 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008173.40343 | 2112629.59757 | 37.7813397265891 | -122.415356833968 | (37.7813397265891, -122.415356833968) | 7 | 10 | 9 | 28852 | 36 | |||
128220 | 22588 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 801 Turk St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/11/1990 12:00:00 AM | 12 | 4x4 | 6006166.11327 | 2112793.0062544 | 37.7816753849136 | -122.422312701127 | (37.7816753849136, -122.422312701127) | 7 | 9 | 11 | 28852 | 41 | ||
130649 | 232899 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 190 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004747.90641 | 2109304.15251 | 37.7720157471575 | -122.426970469322 | (37.7720157471575, -122.426970469322) | 7 | 9 | 5 | 28852 | 10 | |||
132496 | 42770 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 595 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42746 | 6005021.69046201 | 2110898.204752 | 37.7764081042584 | -122.426136930931 | (37.7764081042584, -122.426136930931) | 7 | 9 | 11 | 28852 | 10 | ||
133367 | 42772 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 595 Hayes St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42746 | 6005021.69046201 | 2110898.204752 | 37.7764081042584 | -122.426136930931 | (37.7764081042584, -122.426136930931) | 7 | 9 | 11 | 28852 | 10 | ||
133585 | 88022 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 198 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 51047 | 6008282.3 | 2112522.3 | 37.7810512330082 | -122.41497250722 | (37.7810512330082, -122.41497250722) | 7 | 10 | 9 | 28852 | 36 | ||
134479 | 232906 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 190 Buchanan St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004730.20675 | 2109429.96028 | 37.7723601839173 | -122.427040656018 | (37.7723601839173, -122.427040656018) | 7 | 9 | 5 | 28852 | 10 | |||
136925 | 103576 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 101X Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005198.60314 | 2109385.58511 | 37.772264815602 | -122.425417269432 | (37.772264815602, -122.425417269432) | 7 | 9 | 5 | 28852 | 10 | ||||
138939 | 88021 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 198 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 51047 | 6008282.3 | 2112522.3 | 37.7810512330082 | -122.41497250722 | (37.7810512330082, -122.41497250722) | 7 | 10 | 9 | 28852 | 36 | ||
140075 | 131934 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 67 Hyde St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008167.55656 | 2112690.21522 | 37.7815058394753 | -122.415381353982 | (37.7815058394753, -122.415381353982) | 7 | 10 | 9 | 28852 | 36 | |||
140784 | 103575 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 101X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005198.60314 | 2109385.58511 | 37.772264815602 | -122.425417269432 | (37.772264815602, -122.425417269432) | 7 | 9 | 5 | 28852 | 10 | ||||
146315 | 232904 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 190 Buchanan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004735.06721 | 2109399.13084 | 37.7722758086024 | -122.427021647038 | (37.7722758086024, -122.427021647038) | 7 | 9 | 5 | 28852 | 10 | |||
150536 | 88023 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 198 McAllister St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 51047 | 6008282.3 | 2112522.3 | 37.7810512330082 | -122.41497250722 | (37.7810512330082, -122.41497250722) | 7 | 10 | 9 | 28852 | 36 | ||
152077 | 114739 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 188 BUCHANAN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6004735 | 2109327 | 37.7720777510232 | -122.427016741179 | (37.7720777510232, -122.427016741179) | 7 | 9 | 5 | 28852 | 10 | ||||
157691 | 131929 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 57 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6008185.16924 | 2112536.59269 | 37.781085018795 | -122.415309543996 | (37.781085018795, -122.415309543996) | 7 | 10 | 9 | 28852 | 36 | |||
159269 | 42774 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 595 Hayes St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42746 | 6005021.69046201 | 2110898.204752 | 37.7764081042584 | -122.426136930931 | (37.7764081042584, -122.426136930931) | 7 | 9 | 11 | 28852 | 10 | ||
165363 | 10278 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 215X Haight St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/12/1996 12:00:00 AM | 6 | 6X6 | 6005000.61509 | 2109505.63565 | 37.7725832571536 | -122.426110676071 | (37.7725832571536, -122.426110676071) | 7 | 9 | 5 | 28852 | 10 | ||
166388 | 114740 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 188 BUCHANAN ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 4x4 | 6004735 | 2109327 | 37.7720777510232 | -122.427016741179 | (37.7720777510232, -122.427016741179) | 7 | 9 | 5 | 28852 | 10 | |||
167357 | 232912 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 229 Haight St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004848.4378 | 2109485.19544 | 37.7725185311402 | -122.426635617559 | (37.7725185311402, -122.426635617559) | 7 | 9 | 5 | 28852 | 10 | |||
168149 | 232911 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 229 Haight St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004830.21653 | 2109483.04502 | 37.7725115964545 | -122.426698493634 | (37.7725115964545, -122.426698493634) | 7 | 9 | 5 | 28852 | 10 | |||
168479 | 88702 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 225 Laguna St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2008 12:00:00 AM | 3x3 | Permit Number 51652 | 6005143 | 2109639 | 37.7729574898546 | -122.425627645138 | (37.7729574898546, -122.425627645138) | 7 | 9 | 11 | 28852 | 10 | |||
169863 | 9728 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 629 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6005789.7168 | 2111936.3952 | 37.7793021016267 | -122.423553936469 | (37.7793021016267, -122.423553936469) | 7 | 9 | 11 | 28852 | 41 |
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) );