trees
3,709 rows where qSpecies_id = 9
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4799 | 95481 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5986568.37611 | 2111910.32722 | 37.778126839673 | -122.490045739805 | (37.778126839673, -122.490045739805) | 11 | 6 | 2 | 55 | 26 | |
4833 | 75711 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1360 43rd Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5982781.2778 | 2105936.6274 | 37.7615029058487 | -122.502704174703 | (37.7615029058487, -122.502704174703) | 1 | 8 | 3 | 56 | 35 | |||
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 | ||
5112 | 71219 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2287 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5988225.9763 | 2099753.3826 | 37.7448438391255 | -122.483420138524 | (37.7448438391255, -122.483420138524) | 1 | 8 | 3 | 29491 | 35 | |||
5173 | 169519 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 1753 Noe St | 1 | Front Yard : Yard | Tree | Private 2 | 0 | 8x8 | Permit Number 779099 | 6003417.91334 | 2098032.77345 | 37.7409919262491 | -122.430766523865 | (37.7409919262491, -122.430766523865) | 2 | 7 | 5 | 63 | 7 | ||
5198 | 75651 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 594 19th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5990000.19108 | 2111343.54291 | 37.7767704107746 | -122.47813253045 | (37.7767704107746, -122.47813253045) | 11 | 6 | 2 | 55 | 26 | |||
5300 | 194149 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 101 Pennsylvania Ave | 40 | Front Yard : Yard | Tree | Private 2 | 1 | 6014236.41284 | 2106693.24116 | 37.765378718967 | -122.393965939285 | (37.765378718967, -122.393965939285) | 14 | 3 | 8 | 28856 | 20 | ||||
5371 | 210699 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1090 Capitol Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5995069.25472 | 2091142.27461 | 37.7215957521342 | -122.459134106263 | (37.7215957521342, -122.459134106263) | 9 | 8 | 6 | 28861 | 24 | |||
5421 | 78924 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2355 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5988240.3654 | 2099300.0902 | 37.7436000553334 | -122.483337162026 | (37.7436000553334, -122.483337162026) | 1 | 8 | 3 | 29491 | 35 | |||
5468 | 19026 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3173 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3X3 | 5999643.72529 | 2115362.65802 | 37.7883609073807 | -122.44506178917 | (37.7883609073807, -122.44506178917) | 13 | 6 | 1 | 29490 | 27 | |||
5653 | 215048 | Private 9 | Olea europaea :: Olive Tree 9 | 1719 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782897 | 5990885.18116 | 2103671.34742 | 37.7557559568771 | -122.474511074324 | (37.7557559568771, -122.474511074324) | 1 | 8 | 4 | 56 | 12 | |
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 | |||
5805 | 131998 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2526 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007014.37433 | 2120962.81861 | 37.8041554711661 | -122.419958043454 | (37.8041554711661, -122.419958043454) | 5 | 1 | 1 | 28858 | 32 | |||
5987 | 262213 | Property Tree 8 | Olea europaea :: Olive Tree 9 | 66 Clarendon Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5997837 | 2104660 | 37.7588708842054 | -122.450540844653 | (37.7588708842054, -122.450540844653) | 15 | 5 | 11 | 28862 | 12 | ||||
6043 | 235756 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 79 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/30/2019 12:00:00 AM | 3 | 6x3 | 6005437.91175 | 2099305.91889 | 37.7446019335453 | -122.423872610632 | (37.7446019335453, -122.423872610632) | 2 | 7 | 5 | 28859 | 22 | ||
6115 | 39553 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2 Connecticut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | 12 | Permit Number 40979 | 6013090.35036 | 2107006.086 | 37.7661739606766 | -122.397951878476 | (37.7661739606766, -122.397951878476) | 14 | 3 | 8 | 28856 | 20 | ||
6161 | 103626 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2729 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2013 12:00:00 AM | 2 | 3x3 | Permit Number 770186 | 5999911.184 | 2118103.33782 | 37.79590135493 | -122.444333461525 | (37.79590135493, -122.444333461525) | 13 | 9 | 1 | 57 | 17 | |
6162 | 46753 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 378 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2002 12:00:00 AM | Permit Number 44855 | 5993270.29922187 | 2089695.37971007 | 37.7175193444423 | -122.465247516931 | (37.7175193444423, -122.465247516931) | 9 | 8 | 6 | 64 | 24 | ||
6173 | 210586 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1677 16th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 5ft | 5991138.28819 | 2103959.43747 | 37.7565616379133 | -122.47365677234 | (37.7565616379133, -122.47365677234) | 1 | 8 | 4 | 56 | 12 | |||
6307 | 83045 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100X Cargo Way | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6018793.96585 | 2097631.53768 | 37.7407493718785 | -122.377573338964 | (37.7407493718785, -122.377573338964) | 10 | 3 | 8 | 58 | 1 | |||
6324 | 233656 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 579 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 6x6 | 6001434.06247 | 2101426.15638 | 37.7501967553975 | -122.437868930507 | (37.7501967553975, -122.437868930507) | 2 | 4 | 5 | 28862 | 22 | |||
6339 | 202874 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 560 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011757.6465 | 2105763.90852 | 37.7626889070017 | -122.402474114009 | (37.7626889070017, -122.402474114009) | 8 | 3 | 8 | 28856 | 29 | |||
6369 | 55285 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1255 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/1972 12:00:00 AM | 9 | Permit Number 11211 | 5988297.4779 | 2106775.5193 | 37.7641288996273 | -122.483687653384 | (37.7641288996273, -122.483687653384) | 1 | 8 | 3 | 56 | 35 | ||
6418 | 194172 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 664 Wisconsin St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6012676.7573 | 2104370.99604 | 37.7589155441312 | -122.399197435936 | (37.7589155441312, -122.399197435936) | 10 | 3 | 8 | 28856 | 29 | |||
6532 | 119947 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 326 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x4 | 5986858.05985 | 2113733.39411 | 37.783149373707 | -122.489177700438 | (37.783149373707, -122.489177700438) | 11 | 6 | 2 | 55 | 26 | |||
6614 | 233670 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 803 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002469.64412 | 2103508.89631 | 37.7559742970036 | -122.434436723671 | (37.7559742970036, -122.434436723671) | 2 | 4 | 5 | 28862 | 22 | |||
6647 | 233181 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1088 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5998975.05646 | 2106207.82472 | 37.7631858975236 | -122.446716299819 | (37.7631858975236, -122.446716299819) | 15 | 5 | 5 | 29492 | 9 | |||
6676 | 70370 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1462 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5983119.2114 | 2105188.9573 | 37.7594698688276 | -122.501480109549 | (37.7594698688276, -122.501480109549) | 1 | 8 | 3 | 56 | 35 | |||
6720 | 116625 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 5732X GEARY BLVD | 6 | Front Yard : Cutout | Tree | MTA 3 | DPW | 3x3 | 5989254 | 2112678 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | 11 | 6 | 2 | 55 | 26 | |||
6841 | 45453 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 191 Corona St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/2001 12:00:00 AM | Permit Number 44237 | 5993006.32104665 | 2092505.10355506 | 37.7252189362985 | -122.466364051503 | (37.7252189362985, -122.466364051503) | 9 | 8 | 4 | 59 | 40 | ||
6952 | 264732 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1965 Quint St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012227 | 2095019 | 37.7332118929398 | -122.40009613746 | (37.7332118929398, -122.40009613746) | 10 | 3 | 8 | 58 | 1 | ||||
6963 | 177993 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 219 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6004143.56512 | 2092257.28503 | 37.7251748209582 | -122.427846056457 | (37.7251748209582, -122.427846056457) | 9 | 7 | 6 | 28861 | 5 | |||
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 | ||||||||||||||
6968 | 106969 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 504 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/2016 12:00:00 AM | 3 | 3x3 | Permit Number 772815 | 6007433 | 2096444 | 37.7368561680545 | -122.416771259928 | (37.7368561680545, -122.416771259928) | 2 | 7 | 7 | 28859 | 2 | |
7046 | 69901 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 607 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6002511.32191 | 2089559.78285 | 37.7176756091205 | -122.433295884208 | (37.7176756091205, -122.433295884208) | 9 | 7 | 6 | 28861 | 5 | |||
7048 | 70747 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 775 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5988472.81051 | 2110739.80778 | 37.7750239462768 | -122.483371863607 | (37.7750239462768, -122.483371863607) | 11 | 6 | 2 | 55 | 26 | |||
7099 | 103526 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 1X Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6006435.6 | 2109828.8 | 37.7735515891286 | -122.421169857317 | (37.7735515891286, -122.421169857317) | 8 | 2 | 9 | 28853 | 19 | |||
7121 | 13051 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 548 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:01:00 PM | 3 | 3x3 | 6009711.5863 | 2120552.0553 | 37.803179205163 | -122.410595078527 | (37.803179205163, -122.410595078527) | 3 | 1 | 10 | 308 | 23 | ||
7198 | 233017 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 89 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 785451 | 6007345.5921 | 2098843.81852 | 37.7434406209891 | -122.417243474931 | (37.7434406209891, -122.417243474931) | 2 | 7 | 7 | 28859 | 2 | |
7300 | 183627 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1442 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5981873.5609 | 2105253.9792 | 37.759575163504 | -122.505792929352 | (37.759575163504, -122.505792929352) | 1 | 8 | 3 | 56 | 35 | |||
7307 | 17780 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1791 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6005376.6767315 | 2115458.3552628 | 37.7889492101001 | -122.425233498798 | (37.7889492101001, -122.425233498798) | 13 | 9 | 1 | 28858 | 41 | |||
7404 | 210734 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 270 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5992990.46687 | 2089001.91036 | 37.7155991032881 | -122.466164394482 | (37.7155991032881, -122.466164394482) | 9 | 8 | 6 | 64 | 24 | |||
7416 | 52562 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1267 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/2006 12:00:00 AM | 3 | Permit Number 48659 | 5983648.1273 | 2106539.2749 | 37.7632085093228 | -122.49975069135 | (37.7632085093228, -122.49975069135) | 1 | 8 | 3 | 56 | 35 | |
7457 | 2165 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 119X Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/1997 12:00:00 AM | 12 | 3X27 | 5993658.6263 | 2088481.9826 | 37.7142100327703 | -122.463817234952 | (37.7142100327703, -122.463817234952) | 9 | 8 | 6 | 64 | 24 | ||
7468 | 244539 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 410 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5998914.5258 | 2109210.0073 | 37.7714256747979 | -122.447141725905 | (37.7714256747979, -122.447141725905) | 15 | 5 | 11 | 29492 | 9 | |||
7516 | 177998 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 182 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003203.98579 | 2092372.59593 | 37.7254382413572 | -122.431102310926 | (37.7254382413572, -122.431102310926) | 9 | 7 | 6 | 28861 | 5 | |||
7522 | 131891 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3211 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 5999369.54226 | 2115325.66446 | 37.7882436798582 | -122.446007752769 | (37.7882436798582, -122.446007752769) | 13 | 6 | 1 | 29490 | 31 | |||
7572 | 210820 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1570 07th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5994025.69959 | 2104801.19481 | 37.7590396865612 | -122.463732240966 | (37.7590396865612, -122.463732240966) | 1 | 5 | 4 | 56 | 12 | |||
7639 | 178021 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 501 Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6009115.97426 | 2093800.21325 | 37.7296914141147 | -122.410765795799 | (37.7296914141147, -122.410765795799) | 9 | 3 | 7 | 309 | 28 | |||
7701 | 97237 | Property Tree 8 | Olea europaea :: Olive Tree 9 | 125 Excelsior Ave | Sidewalk: Property side : Yard | Tree | SFUSD 4 | FUF | 09/07/2011 12:00:00 AM | Permit Number 767513 | 6002911 | 2092621.3 | 37.7261045201699 | -122.432132888294 | (37.7261045201699, -122.432132888294) | 9 | 7 | 6 | 28861 | 5 | |||
7716 | 47426 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 573 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 3 | Permit Number 45337 | 5983462.70057 | 2111933.41652 | 37.7780083900123 | -122.50079093001 | (37.7780083900123, -122.50079093001) | 11 | 6 | 2 | 55 | 26 | |
7778 | 138593 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2816 PINE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6000380.1632 | 2114818.3649 | 37.7869084247529 | -122.44247474757 | (37.7869084247529, -122.44247474757) | 13 | 6 | 1 | 29490 | 27 | |||
7927 | 17200 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 200X Olive St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6006498.35844 | 2113758.48472 | 37.7843450883742 | -122.421231867498 | (37.7843450883742, -122.421231867498) | 7 | 9 | 11 | 28858 | 41 | |||
8079 | 42144 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 471 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | 10 | Permit Number 42439 | 5990590.8617 | 2112190.82997 | 37.7791310957428 | -122.476151146082 | (37.7791310957428, -122.476151146082) | 11 | 6 | 2 | 55 | 26 | |
8102 | 260181 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 66x McCoppin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2019 12:00:00 AM | 3 | 3x3 | 6006141 | 2109130 | 37.7716162396968 | -122.422139269172 | (37.7716162396968, -122.422139269172) | 8 | 2 | 9 | 28853 | 19 | ||
8316 | 260638 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 3140 25th St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3 | 3x3 | 6008726.17419 | 2101580.94088 | 37.7510337250786 | -122.412663209658 | (37.7510337250786, -122.412663209658) | 2 | 4 | 7 | 28859 | 19 | |||
8377 | 42837 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1258 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2000 12:00:00 AM | 14 | Permit Number 42769 | 6005846.59276 | 2120362.48981 | 37.8024412617221 | -122.423956527271 | (37.8024412617221, -122.423956527271) | 5 | 9 | 1 | 28858 | 32 | ||
8413 | 120008 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 700 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5986957.64552 | 2111044.59279 | 37.7757725016367 | -122.488635485438 | (37.7757725016367, -122.488635485438) | 11 | 6 | 2 | 55 | 26 | |||
8449 | 131913 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2108 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6004558.4355 | 2116754.37575 | 37.7924614957554 | -122.428156903513 | (37.7924614957554, -122.428156903513) | 13 | 9 | 1 | 28858 | 27 | |||
8713 | 261829 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 256 Casitas Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 03/05/2020 12:00:00 AM | 3 | 3x3 | Permit Number 781540 | 5994862.12068 | 2096567.59314 | 37.7364804498834 | -122.460242983215 | (37.7364804498834, -122.460242983215) | 9 | 7 | 4 | 59 | 40 | |
8816 | 177939 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Garces Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5989472.35628 | 2089125.29207 | 37.7157342731997 | -122.478333458321 | (37.7157342731997, -122.478333458321) | 1 | 8 | 4 | 64 | 14 | ||||
8979 | 210840 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 32 Malta Dr | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5999647.66435 | 2095993.4021 | 37.735177965674 | -122.443656149716 | (37.735177965674, -122.443656149716) | 9 | 7 | 4 | 63 | 40 | |||
9078 | 233225 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 317 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007069.05319 | 2097329.92608 | 37.7392682478392 | -122.41809237556 | (37.7392682478392, -122.41809237556) | 2 | 7 | 7 | 28859 | 2 | |||
9131 | 75410 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 550 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5984433.26554 | 2112138.70931 | 37.7786289992279 | -122.497448611431 | (37.7786289992279, -122.497448611431) | 11 | 6 | 2 | 55 | 26 | |||
9148 | 76641 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 148X Paris St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6002952.72216 | 2092480.76402 | 37.7257210052939 | -122.43197862653 | (37.7257210052939, -122.43197862653) | 9 | 7 | 6 | 28861 | 5 | ||
9149 | 233773 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 40 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001427.02083 | 2107882.34187 | 37.7679234703253 | -122.438355765017 | (37.7679234703253, -122.438355765017) | 15 | 5 | 5 | 29492 | 3 | |||
9185 | 177862 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 941 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6000858.94149 | 2091517.81461 | 37.7229580424721 | -122.439147663029 | (37.7229580424721, -122.439147663029) | 9 | 7 | 6 | 28861 | 25 | |||
9238 | 177934 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Bucareli Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5988635.61259 | 2089280.10032 | 37.7161107276166 | -122.481236924063 | (37.7161107276166, -122.481236924063) | 1 | 8 | 4 | 64 | 14 | ||||
9251 | 64294 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 369 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/18/1988 12:00:00 AM | 11 | Permit Number 25100 | 6004186.81103281 | 2098943.74928531 | 37.7435367899994 | -122.428172863442 | (37.7435367899994, -122.428172863442) | 2 | 7 | 5 | 63 | 22 | |
9358 | 252934 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 78 Edgar Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997141 | 2091229 | 37.7219527643602 | -122.451978930217 | (37.7219527643602, -122.451978930217) | 9 | 8 | 6 | 28861 | 24 | |||||
9397 | 194190 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1120 19th St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 6014220.74696 | 2105285.57644 | 37.7615127088737 | -122.393921578412 | (37.7615127088737, -122.393921578412) | 10 | 3 | 8 | 28856 | 29 | |||
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 | |||
9488 | 233080 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 4379 Cesar Chavez St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001430.46687 | 2100267.77544 | 37.7470159126695 | -122.437798408372 | (37.7470159126695, -122.437798408372) | 2 | 4 | 5 | 63 | 22 | |||
9594 | 138528 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2255 SUTTER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6001797.268 | 2114262.3261 | 37.7854623568286 | -122.43753206476 | (37.7854623568286, -122.43753206476) | 13 | 6 | 11 | 29490 | 13 | |||
9669 | 71248 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1853 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6009517.1243 | 2120069.0751 | 37.8018421572412 | -122.411233884286 | (37.8018421572412, -122.411233884286) | 3 | 1 | 10 | 308 | 23 | |||
9691 | 210624 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1306 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 5993034.36809 | 2106545.7737 | 37.763772669194 | -122.467287556882 | (37.763772669194, -122.467287556882) | 1 | 8 | 11 | 56 | 12 | |||
9713 | 71215 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2143 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5988194.3764 | 2100717.2109 | 37.7474884169564 | -122.483600053104 | (37.7474884169564, -122.483600053104) | 1 | 8 | 3 | 29491 | 35 | |||
9726 | 87886 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3750 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50857 | 6002562.15931 | 2121499.01412 | 37.8053758844436 | -122.4354036226 | (37.8053758844436, -122.4354036226) | 13 | 9 | 1 | 57 | 17 | |
9743 | 34866 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 579 Miramar Ave | 1 | Median : Cutout | Tree | Private 2 | FUF | 12/29/2015 12:00:00 AM | Permit Number 775311 | 5995338.59696042 | 2093168.95782094 | 37.7271760192259 | -122.458349689476 | (37.7271760192259, -122.458349689476) | 9 | 7 | 4 | 28861 | 40 | ||
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 | |||
9934 | 233207 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100X Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007340 | 2097733 | 37.7403902459184 | -122.417184114538 | (37.7403902459184, -122.417184114538) | 2 | 7 | 7 | 28859 | 2 | |||
10208 | 250096 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1701 Pine St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6005700.60971 | 2115508.13842 | 37.789104197049 | -122.42411627476 | (37.789104197049, -122.42411627476) | 13 | 9 | 1 | 28858 | 41 | |||
10271 | 262199 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 801 Sanchez St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6003778 | 2103544 | 37.7561448640021 | -122.429914501498 | (37.7561448640021, -122.429914501498) | 2 | 4 | 5 | 28862 | 22 | ||||
10318 | 78551 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2255 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5982019.5732 | 2099750.385 | 37.7444724345971 | -122.504880128796 | (37.7444724345971, -122.504880128796) | 1 | 8 | 3 | 29491 | 35 | |||
10328 | 233802 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 250 Randall St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6003925.67071 | 2097778.5347 | 37.7403225995025 | -122.428992763101 | (37.7403225995025, -122.428992763101) | 2 | 7 | 5 | 63 | 7 | |||
10431 | 48599 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1338(Revised) Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50644 | 6006556.20417 | 2119076.48456 | 37.7989502536048 | -122.42140953573 | (37.7989502536048, -122.42140953573) | 13 | 9 | 1 | 28858 | 32 | |
10555 | 18999 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3039 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6000252.38525 | 2115449.79519 | 37.7886348840283 | -122.442962190565 | (37.7886348840283, -122.442962190565) | 13 | 6 | 1 | 29490 | 27 | |||
10709 | 210631 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1446 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 5993378.13325 | 2105628.69584 | 37.7612744523625 | -122.466031944136 | (37.7612744523625, -122.466031944136) | 1 | 8 | 11 | 56 | 12 | |||
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 | |||||||||||||
10896 | 13070 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 630 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/05/2019 12:00:00 AM | 22 | 3x3 | 6009332.6794 | 2120506.3975 | 37.8030325899081 | -122.4119030734 | (37.8030325899081, -122.4119030734) | 3 | 1 | 10 | 308 | 23 | ||
10904 | 131990 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2445 Hyde St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/2020 12:00:00 AM | 3 | Width 3ft | 6006996.42169 | 2120694.04403 | 37.8034164730582 | -122.420001084983 | (37.8034164730582, -122.420001084983) | 5 | 1 | 1 | 28858 | 32 | ||
10918 | 233197 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 799 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007609.55119 | 2095754.81208 | 37.7349737377405 | -122.416112048657 | (37.7349737377405, -122.416112048657) | 2 | 7 | 7 | 28859 | 2 | |||
10929 | 233639 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 738x San Jose Ave | 1 | Median : Cutout | Tree | DPW 1 | 4 | Width 3ft | 6005705.79778 | 2098817.87018 | 37.7432769821506 | -122.422911632871 | (37.7432769821506, -122.422911632871) | 2 | 7 | 7 | 28859 | 2 | |||
10933 | 138331 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2319 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6002699 | 2115111 | 37.7878438257201 | -122.43447304438 | (37.7878438257201, -122.43447304438) | 13 | 9 | 11 | 29490 | 27 | |||
10975 | 154534 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1391 08th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 2ft | 5993623.67748 | 2106028.43629 | 37.7623861978859 | -122.465211753439 | (37.7623861978859, -122.465211753439) | 1 | 8 | 11 | 56 | 12 | |||
11031 | 194139 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 770 Illinois St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 6015990.60538 | 2105494.8516 | 37.7621855348578 | -122.387814914632 | (37.7621855348578, -122.387814914632) | 10 | 3 | 8 | 28856 | 29 | ||||
11049 | 74796 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2338 42nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5983322.3378 | 2099244.9576 | 37.7431612263111 | -122.500338147126 | (37.7431612263111, -122.500338147126) | 1 | 8 | 3 | 29491 | 35 | |||
11186 | 233023 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 377 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007268.08655 | 2096284.2929 | 37.7364083704527 | -122.417330125494 | (37.7364083704527, -122.417330125494) | 2 | 7 | 7 | 28859 | 2 | |||
11353 | 210831 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 El Verano Way | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5994495.15253 | 2094669.90963 | 37.7312487620154 | -122.461374210478 | (37.7312487620154, -122.461374210478) | 9 | 8 | 4 | 59 | 40 | |||
11455 | 71633 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 666 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5983841.90754 | 2111286.39703 | 37.7762541180901 | -122.499431311865 | (37.7762541180901, -122.499431311865) | 11 | 6 | 2 | 55 | 26 |
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) );