trees
3,709 rows where qSpecies_id = 9 sorted by qCareAssistant
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |
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 | ||||
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 | ||||
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 | |||
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 | |||
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 | ||||
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 | |||
11914 | 262434 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 634 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 3 | Width 2ft | 6002626 | 2089963 | 37.7187892592726 | -122.43292828484 | (37.7187892592726, -122.43292828484) | 9 | 7 | 6 | 28861 | 5 | ||
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 | |||
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 | |||
12151 | 145130 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 218 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2020 12:00:00 AM | 3 | 4x4 | Permit Number 785634 | 5992772.08387 | 2113986.425 | 37.7841875521538 | -122.468736166845 | (37.7841875521538, -122.468736166845) | 11 | 6 | 2 | 54 | 11 | |
12403 | 17740 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1347 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Health Dept 13 | 12/01/1982 12:00:00 AM | 6 | 3X3 | 6002203.7996 | 2113272.0173 | 37.7827663252153 | -122.436054698673 | (37.7827663252153, -122.436054698673) | 15 | 5 | 11 | 29490 | 41 | ||
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 | |||
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 | |||
12606 | 261830 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 256 Casitas Ave | 2 | 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 | |
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 | |||
12828 | 131988 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2445 Hyde St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/2020 12:00:00 AM | 3 | Width 3ft | 6006993.00733 | 2120736.62098 | 37.8035331861796 | -122.420015923817 | (37.8035331861796, -122.420015923817) | 5 | 1 | 1 | 28858 | 32 | ||
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 | ||||
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 | ||||||||||||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||||||||||||
14364 | 107684 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 330 Seacliff Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2014 12:00:00 AM | 3 | Permit Number 773561 | 5986760.07251 | 2115557.06448 | 37.7881509278055 | -122.489650845774 | (37.7881509278055, -122.489650845774) | 11 | 6 | 1 | 55 | 33 | ||
14403 | 260183 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 66x McCoppin St | 3 | 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 | ||
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 | |||
14636 | 55313 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1100 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1972 12:00:00 AM | 8 | 9x3 | Permit Number 11242 | 6011254.56702 | 2089617.4839 | 37.7183261795882 | -122.403078315405 | (37.7183261795882, -122.403078315405) | 10 | 7 | 8 | 309 | 39 | |
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 | |||
14918 | 56281 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 318 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/1973 12:00:00 AM | 10 | Permit Number 12407 | 5992177.94818 | 2113286.20231 | 37.782230591981 | -122.470740624571 | (37.782230591981, -122.470740624571) | 11 | 6 | 2 | 54 | 11 | ||
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 | ||||
15155 | 242653 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 30 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2018 12:00:00 AM | 3 | 6x12 | 6005689.295 | 2099367.13524 | 37.7447842081356 | -122.423007726327 | (37.7447842081356, -122.423007726327) | 2 | 7 | 5 | 28859 | 22 | ||
15184 | 32343 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2885 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/1996 12:00:00 AM | Permit Number 36904 | 5999249.30586492 | 2118007.60671846 | 37.7956007178544 | -122.446616785481 | (37.7956007178544, -122.446616785481) | 13 | 9 | 1 | 57 | 17 | |||
15190 | 210598 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 44 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1972 12:00:00 AM | 16 | Width 4ft | Permit Number 9937 | 5995535.69173 | 2107072.5304 | 37.7653630851686 | -122.458674438482 | (37.7653630851686, -122.458674438482) | 15 | 5 | 11 | 56 | 12 | |
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 | |||
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 | |||
15351 | 261516 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 671 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 11:26:00 AM | 3x3 | 5983177.86359 | 2111217.50955 | 37.7760259908371 | -122.501723286949 | (37.7760259908371, -122.501723286949) | 11 | 6 | 2 | 55 | 26 | |||
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 | |||
15587 | 259045 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 255 Seacliff Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2019 12:00:00 AM | 3 | Width 4ft | Permit Number 775322 | 5986944 | 2115700 | 37.7885541240961 | -122.489025008772 | (37.7885541240961, -122.489025008772) | 11 | 6 | 1 | 55 | 33 | |
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 | |||
15702 | 66427 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 95 Carr St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/1991 12:00:00 AM | 8 | Permit Number 29569 | 6012980.71061 | 2090558.71757 | 37.7210068625643 | -122.397177686318 | (37.7210068625643, -122.397177686318) | 10 | 3 | 8 | 58 | 1 | ||
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) );