trees
3,709 rows where qSpecies_id = 9 sorted by PlantDate
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 11480 | 233768 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 55 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003179.19885 | 2107982.61518 | 37.7682983023649 | -122.43230234649 | (37.7682983023649, -122.43230234649) | 15 | 5 | 5 | 28862 | 3 | |||
| 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 | |||
| 11523 | 80597 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 443 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6014099.89803 | 2105040.34202 | 37.7608326316413 | -122.394322377476 | (37.7608326316413, -122.394322377476) | 10 | 3 | 8 | 28856 | 29 | |||
| 11542 | 194238 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6 Hillview Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 7ft | 6016710.45664 | 2095786.72783 | 37.7355688829898 | -122.384648921526 | (37.7355688829898, -122.384648921526) | 10 | 3 | 8 | 58 | 1 | |||
| 11665 | 233743 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 286 Cumberland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003735.38571 | 2104523.16208 | 37.7588309970763 | -122.430131725694 | (37.7588309970763, -122.430131725694) | 2 | 4 | 5 | 28862 | 3 | |||
| 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 | ||||
| 11782 | 75252 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 550 37th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5984435.27406 | 2112051.02131 | 37.7783883510577 | -122.497435187925 | (37.7783883510577, -122.497435187925) | 11 | 6 | 2 | 55 | 26 | |||
| 11877 | 210668 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 220 Ulloa St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5996107.59871 | 2098932.75932 | 37.7430461792465 | -122.456107811121 | (37.7430461792465, -122.456107811121) | 1 | 8 | 4 | 59 | 40 | |||
| 11947 | 114496 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 506 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6013514.3964 | 2111397.60401 | 37.778255690483 | -122.396793080454 | (37.778255690483, -122.396793080454) | 6 | 2 | 9 | 28856 | 34 | |||
| 11999 | 78469 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 620 Sweeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6007750.85494 | 2094230.07543 | 37.730795086422 | -122.415515595769 | (37.730795086422, -122.415515595769) | 9 | 3 | 7 | 309 | 28 | |||
| 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 | |||
| 12136 | 137985 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2281 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6003041.7191 | 2115135.3028 | 37.7879300034078 | -122.433289038266 | (37.7879300034078, -122.433289038266) | 13 | 9 | 11 | 29490 | 27 | |||
| 12171 | 84266 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 705 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5988141.50064 | 2111140.28908 | 37.7761042683076 | -122.484547303766 | (37.7761042683076, -122.484547303766) | 11 | 6 | 2 | 55 | 26 | |||
| 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 | |||
| 12433 | 210785 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 228 Moraga St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5993497.42043 | 2103949.45109 | 37.7566705638043 | -122.465497389788 | (37.7566705638043, -122.465497389788) | 1 | 8 | 4 | 56 | 12 | |||
| 12482 | 177894 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 350 Rutland St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6010334.18865 | 2088569.51073 | 37.7153972189891 | -122.406185898468 | (37.7153972189891, -122.406185898468) | 9 | 7 | 8 | 309 | 39 | |||
| 12517 | 83658 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 735 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6001863.16562 | 2089646.83142 | 37.717877833364 | -122.435542488698 | (37.717877833364, -122.435542488698) | 9 | 7 | 6 | 28861 | 5 | |||
| 12544 | 233012 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 323 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006460.26092 | 2097992.5742 | 37.7410534470593 | -122.420244329108 | (37.7410534470593, -122.420244329108) | 2 | 7 | 7 | 28859 | 2 | |||
| 12572 | 1414 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 15 Arguello Blvd | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 20 | 3X5 | 5995457.5707 | 2115860.24617 | 37.7894873341044 | -122.459581162818 | (37.7894873341044, -122.459581162818) | 11 | 6 | 1 | 54 | 11 | |||
| 12579 | 233051 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3165 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007206.48709 | 2103796.80236 | 37.7570325643122 | -122.41807552586 | (37.7570325643122, -122.41807552586) | 2 | 4 | 7 | 28859 | 19 | |||
| 12636 | 233814 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 76 Colton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6006700.12713 | 2109639.8219 | 37.7730476095043 | -122.420241401833 | (37.7730476095043, -122.420241401833) | 8 | 2 | 9 | 28853 | 19 | |||
| 12917 | 233683 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 280 Clipper St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003374.25108 | 2100995.16255 | 37.7491234846824 | -122.431128883194 | (37.7491234846824, -122.431128883194) | 2 | 4 | 5 | 28862 | 22 | |||
| 13048 | 131805 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2474 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5999492.72938 | 2119826.91207 | 37.8006099461438 | -122.445905412604 | (37.8006099461438, -122.445905412604) | 13 | 9 | 1 | 57 | 17 | |||
| 13060 | 232933 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1270 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003841.13405 | 2100936.80962 | 37.748989706922 | -122.429510235714 | (37.748989706922, -122.429510235714) | 2 | 4 | 5 | 28862 | 22 | |||
| 13090 | 131960 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1340 Lombard St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005876.90863 | 2120024.68366 | 37.8015154438506 | -122.423827585198 | (37.8015154438506, -122.423827585198) | 5 | 9 | 1 | 28858 | 32 | |||
| 13349 | 261323 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 278 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993017 | 2089051 | 37.7157354224316 | -122.466076249864 | (37.7157354224316, -122.466076249864) | 9 | 8 | 6 | 64 | 24 | ||||
| 13444 | 247158 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3998 17th St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 3ft | 6002441.05995 | 2105914.96249 | 37.7625791519331 | -122.43470762288 | (37.7625791519331, -122.43470762288) | 15 | 4 | 5 | 28862 | 3 | |||
| 13554 | 137982 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2281 Pine St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002983.8805 | 2115127.6807 | 37.7879057937101 | -122.433488604212 | (37.7879057937101, -122.433488604212) | 13 | 9 | 11 | 29490 | 27 | |||
| 13589 | 74272 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 500 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6015960.78285 | 2105386.23771 | 37.7618856523157 | -122.387910481099 | (37.7618856523157, -122.387910481099) | 10 | 3 | 8 | 28856 | 29 | |||
| 13702 | 83044 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100X Cargo Way | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6018777.54715 | 2097643.31156 | 37.7407807960029 | -122.377630926146 | (37.7407807960029, -122.377630926146) | 10 | 3 | 8 | 58 | 1 | |||
| 13797 | 120007 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 700 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5986954.13488 | 2111117.22618 | 37.7759717275571 | -122.488652969333 | (37.7759717275571, -122.488652969333) | 11 | 6 | 2 | 55 | 26 | |||
| 13889 | 75170 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 550 37th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5984437.14625 | 2112031.30929 | 37.7783343372815 | -122.497427255785 | (37.7783343372815, -122.497427255785) | 11 | 6 | 2 | 55 | 26 | |||
| 14018 | 111009 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 1801x WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003409 | 2114904 | 37.7873157334926 | -122.432001790592 | (37.7873157334926, -122.432001790592) | 13 | 9 | 11 | 29490 | 27 | ||||
| 14030 | 210744 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 5 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5995697.70658 | 2107044.30758 | 37.7652949030625 | -122.458112027667 | (37.7652949030625, -122.458112027667) | 15 | 5 | 11 | 56 | 12 | |||
| 14067 | 17211 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 221X Olive St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006417.7103 | 2113696.81595 | 37.7841712140925 | -122.421506501194 | (37.7841712140925, -122.421506501194) | 7 | 9 | 11 | 28858 | 41 | |||
| 14081 | 194133 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1301 Minnesota St | 47 | Front Yard : Yard | Tree | Private 2 | 4 | 6015360.93697 | 2102437.87419 | 37.7537568269303 | -122.389779185082 | (37.7537568269303, -122.389779185082) | 10 | 3 | 8 | 28856 | 29 | ||||
| 14239 | 210646 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1330 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5991878.87557 | 2098447.75168 | 37.7414708368091 | -122.470694133953 | (37.7414708368091, -122.470694133953) | 1 | 8 | 4 | 29491 | 40 | |||
| 14327 | 70383 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1465 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5982453.54 | 2105161.4635 | 37.759355260686 | -122.503780254641 | (37.759355260686, -122.503780254641) | 1 | 8 | 3 | 56 | 35 | |||
| 14340 | 233003 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 724 Anderson St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 6007731 | 2095537 | 37.734382501211 | -122.415676738868 | (37.734382501211, -122.415676738868) | 2 | 7 | 7 | 28859 | 2 | |||
| 14573 | 123056 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 522 Funston Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5991919.36993 | 2111862.43638 | 37.7783063640541 | -122.471531400723 | (37.7783063640541, -122.471531400723) | 11 | 6 | 2 | 54 | 11 | |||
| 14671 | 74991 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2345 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5986666.6916 | 2102296.6086 | 37.7517359771217 | -122.488998708008 | (37.7517359771217, -122.488998708008) | 1 | 8 | 3 | 29491 | 35 | |||
| 14677 | 233139 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 4317 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001074.78019 | 2102287.10424 | 37.7525402744309 | -122.439173047323 | (37.7525402744309, -122.439173047323) | 2 | 4 | 5 | 28862 | 22 | |||
| 15140 | 83033 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100X Cargo Way | 3 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 1 | 6018894.74802 | 2097554.01331 | 37.7405420574702 | -122.377219490814 | (37.7405420574702, -122.377219490814) | 10 | 3 | 8 | 58 | 1 | ||||
| 15215 | 131795 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3460 Baker St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5999250.62549 | 2120749.14861 | 37.8031283320577 | -122.446809584704 | (37.8031283320577, -122.446809584704) | 13 | 9 | 1 | 57 | 17 | |||
| 15274 | 74231 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2054 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6009468.6226 | 2120763.8774 | 37.8037471914209 | -122.411450838489 | (37.8037471914209, -122.411450838489) | 3 | 1 | 10 | 308 | 23 | |||
| 15315 | 137876 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2002 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004300.8024 | 2115368.2774 | 37.7886410402481 | -122.428949455049 | (37.7886410402481, -122.428949455049) | 13 | 9 | 11 | 29490 | 27 | |||
| 15376 | 233816 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 41 Brady St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006595.43726 | 2109656.08938 | 37.7730863765667 | -122.420604692871 | (37.7730863765667, -122.420604692871) | 8 | 2 | 9 | 28853 | 19 | |||
| 15481 | 233090 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 4626 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6000530.225 | 2101127.82855 | 37.7493261810546 | -122.440973048487 | (37.7493261810546, -122.440973048487) | 2 | 4 | 5 | 28862 | 22 | |||
| 15594 | 19769 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 STAIRWAY16 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30ST | |||||||||||||
| 15600 | 131950 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 28 Russell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6007151.45426 | 2118977.15538 | 37.7987110636187 | -122.419342718288 | (37.7987110636187, -122.419342718288) | 5 | 1 | 10 | 28858 | 32 | |||
| 15700 | 210702 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 495 Faxon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 5994735.30528 | 2091846.72997 | 37.7235108134601 | -122.460339487382 | (37.7235108134601, -122.460339487382) | 9 | 8 | 4 | 28861 | 24 | |||
| 15762 | 178016 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 202 University St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6008031.46136 | 2092923.11146 | 37.7272222130337 | -122.414453046768 | (37.7272222130337, -122.414453046768) | 9 | 3 | 7 | 309 | 28 |
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) );