trees
1,985 rows where qSpecies_id = 83 sorted by Supervisor Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 98947 | 137888 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2034 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6002938.4973 | 2115326.6052 | 37.7884494147841 | -122.433659844142 | (37.7884494147841, -122.433659844142) | 13 | 9 | 1 | 29490 | 27 | |||
| 99143 | 69369 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3715 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1994 12:00:00 AM | 7 | Permit Number 33463 | 6002534.67482 | 2121358.09542 | 37.8049873980077 | -122.435488648981 | (37.8049873980077, -122.435488648981) | 13 | 9 | 1 | 57 | 17 | |
| 99212 | 137822 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2188 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/21/2011 12:00:00 AM | 2 | Width 0ft | 6003502.3468 | 2115251.9904 | 37.7882765186021 | -122.431703685395 | (37.7882765186021, -122.431703685395) | 13 | 9 | 1 | 29490 | 27 | ||
| 100334 | 49094 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 140 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2003 12:00:00 AM | 6 | Permit Number 46242 | 5993992.46837 | 2114616.14539 | 37.7859870190843 | -122.464559844416 | (37.7859870190843, -122.464559844416) | 11 | 6 | 1 | 54 | 11 | ||
| 100410 | 7318 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2001 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/11/1996 12:00:00 AM | 6 | 3x3 | 6002895.5378 | 2115212.2273 | 37.7881329245579 | -122.43380029876 | (37.7881329245579, -122.43380029876) | 13 | 9 | 1 | 29490 | 27 | ||
| 101203 | 137831 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2000 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002949.7262 | 2115248.5641 | 37.7882357709282 | -122.433615414335 | (37.7882357709282, -122.433615414335) | 13 | 9 | 1 | 29490 | 27 | |||
| 101595 | 136229 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1695 North Point St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002733.14719 | 2120927.81311 | 37.8038172262563 | -122.434771025084 | (37.8038172262563, -122.434771025084) | 13 | 9 | 1 | 57 | 17 | |||
| 102855 | 62004 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1468 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1994 12:00:00 AM | 8 | Permit Number 33452 | 6004296.2409 | 2120497.97462 | 37.8027256192439 | -122.429331178017 | (37.8027256192439, -122.429331178017) | 13 | 9 | 1 | 57 | 17 | |
| 104527 | 124413 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3900 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5996133.62205 | 2115253.79296 | 37.7878610275159 | -122.457198225213 | (37.7878610275159, -122.457198225213) | 11 | 6 | 1 | 54 | 31 | |||
| 105107 | 85090 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Chestnut St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | 13 | 9 | 1 | 57 | 17 | |||||
| 105538 | 120251 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 160 24th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 5988366.40775 | 2114885.43189 | 37.7864004688283 | -122.484043998399 | (37.7864004688283, -122.484043998399) | 11 | 6 | 1 | 55 | 33 | |||
| 105709 | 69354 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1342 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1994 12:00:00 AM | 11 | Permit Number 33445 | 6004870.03416 | 2120576.9578 | 37.8029749544875 | -122.427351191008 | (37.8029749544875, -122.427351191008) | 13 | 9 | 1 | 57 | 17 | |
| 106396 | 136215 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3631 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996865.88259 | 2115961.8994 | 37.7898473257367 | -122.454715932203 | (37.7898473257367, -122.454715932203) | 11 | 6 | 1 | 54 | 31 | |||
| 107080 | 137614 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2250 Turk Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5999234.5899 | 2111901.9875 | 37.7788354460524 | -122.446228288937 | (37.7788354460524, -122.446228288937) | 15 | 5 | 1 | 54 | 16 | |||
| 108813 | 136193 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2914 Fillmore St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6002531.20881 | 2118254.41346 | 37.7964653035841 | -122.43527850261 | (37.7964653035841, -122.43527850261) | 13 | 9 | 1 | 57 | 17 | |||
| 109327 | 11173 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2717 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6006873.7712695 | 2121594.1615237 | 37.8058810553361 | -122.420489453273 | (37.8058810553361, -122.420489453273) | 5 | 1 | 1 | 28858 | 32 | |||
| 110160 | 17358 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2221X Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6005488.40666 | 2117587.01663 | 37.7948002909451 | -122.424998441372 | (37.7948002909451, -122.424998441372) | 13 | 9 | 1 | 28858 | 27 | |||
| 110422 | 137865 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2044 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6002933.4443 | 2115374.3282 | 37.7885801632703 | -122.433680738824 | (37.7885801632703, -122.433680738824) | 13 | 9 | 1 | 29490 | 27 | |||
| 111047 | 120252 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 160 24th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5988365.81555 | 2114876.44647 | 37.7863757629455 | -122.484045388081 | (37.7863757629455, -122.484045388081) | 11 | 6 | 1 | 55 | 33 | |||
| 111276 | 7335 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2095X Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002868.54266 | 2115466.62702 | 37.7888299094667 | -122.433911888448 | (37.7888299094667, -122.433911888448) | 13 | 9 | 1 | 29490 | 27 | |||
| 111462 | 23701 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2119X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6005103.6033 | 2116867.23334 | 37.7928022043515 | -122.426278644375 | (37.7928022043515, -122.426278644375) | 13 | 9 | 1 | 28858 | 27 | |||
| 111477 | 7332 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2056 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/03/2012 12:00:00 AM | 3 | 3X3 | 6002935.7322959 | 2115346.1432337 | 37.7885029043581 | -122.433670807541 | (37.7885029043581, -122.433670807541) | 13 | 9 | 1 | 29490 | 27 | ||
| 113153 | 136221 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2901 Steiner St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002012.26452 | 2118128.882 | 37.7960911433324 | -122.437065166822 | (37.7960911433324, -122.437065166822) | 13 | 9 | 1 | 57 | 17 | |||
| 118817 | 120253 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 150 24th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5988369.64092 | 2114933.75275 | 37.7865333323848 | -122.484036357305 | (37.7865333323848, -122.484036357305) | 11 | 6 | 1 | 55 | 33 | |||
| 118931 | 85087 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Chestnut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49476 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | 13 | 9 | 1 | 57 | 17 | ||||
| 119489 | 120777 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 57 21st Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5989253.41901 | 2114816.78103 | 37.7862635740202 | -122.480970171004 | (37.7862635740202, -122.480970171004) | 11 | 6 | 1 | 55 | 33 | |||
| 120392 | 120778 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 57 21st Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5989252.84217 | 2114809.14521 | 37.7862425746859 | -122.480971607416 | (37.7862425746859, -122.480971607416) | 11 | 6 | 1 | 55 | 33 | |||
| 121126 | 137867 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2044 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6002928.9527 | 2115414.1909 | 37.7886893612244 | -122.433699129213 | (37.7886893612244, -122.433699129213) | 13 | 9 | 1 | 29490 | 27 | |||
| 121667 | 120259 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 130 24th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5988369.32629 | 2115004.14379 | 37.7867265878172 | -122.484042609601 | (37.7867265878172, -122.484042609601) | 11 | 6 | 1 | 55 | 33 | |||
| 122176 | 7368 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2401 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/12/1996 12:00:00 AM | 7 | 3X3 | 6002726.00787 | 2116542.18674 | 37.7917750313387 | -122.434481971296 | (37.7917750313387, -122.434481971296) | 13 | 9 | 1 | 29490 | 27 | ||
| 125315 | 99597 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3001@Filbert Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 17057 | 6002820 | 2118927.7 | 37.7983303693218 | -122.434327384023 | (37.7983303693218, -122.434327384023) | 13 | 9 | 1 | 57 | 17 | ||||
| 125369 | 24568 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2261 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/03/2004 12:00:00 AM | 3 | 3X3 | 6002770.36332 | 2116069.69305 | 37.790480202582 | -122.43429470698 | (37.790480202582, -122.43429470698) | 13 | 9 | 1 | 29490 | 27 | ||
| 127151 | 69367 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3630 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1994 12:00:00 AM | 11 | Permit Number 33461 | 6002617.53648 | 2121095.37594 | 37.8042707453542 | -122.435183094434 | (37.8042707453542, -122.435183094434) | 13 | 9 | 1 | 57 | 17 | |
| 127417 | 120257 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 140 24th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5988368.87318 | 2114954.36452 | 37.7865898817391 | -122.484040525506 | (37.7865898817391, -122.484040525506) | 11 | 6 | 1 | 55 | 33 | |||
| 127420 | 69368 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3636 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1994 12:00:00 AM | 13 | Permit Number 33462 | 6002615.01621 | 2121133.09873 | 37.8043741790738 | -122.43519451582 | (37.8043741790738, -122.43519451582) | 13 | 9 | 1 | 57 | 17 | |
| 129009 | 7323 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2019 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/15/1989 12:00:00 AM | 3 | 3X3 | 6002894.20819 | 2115251.15318 | 37.7882397296612 | -122.433807682283 | (37.7882397296612, -122.433807682283) | 13 | 9 | 1 | 29490 | 27 | ||
| 129491 | 123627 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 142 02nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995231.45698 | 2114622.12535 | 37.7860747850365 | -122.460273744131 | (37.7860747850365, -122.460273744131) | 11 | 6 | 1 | 54 | 11 | |||
| 130146 | 12667 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1124 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3X3 | 5991972.94269 | 2114825.89139 | 37.7864462960863 | -122.471562077277 | (37.7864462960863, -122.471562077277) | 11 | 6 | 1 | 54 | 11 | |||
| 131447 | 136217 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2901 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001997.91666 | 2118237.10039 | 37.7963874672615 | -122.43712256518 | (37.7963874672615, -122.43712256518) | 13 | 9 | 1 | 57 | 17 | |||
| 132522 | 136259 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2110 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007679.18524 | 2119665.29199 | 37.8006302222728 | -122.417565392635 | (37.8006302222728, -122.417565392635) | 5 | 1 | 1 | 308 | 32 | |||
| 135917 | 137621 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2290 Turk Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5999066.3943 | 2111876.2674 | 37.7787552182629 | -122.446808290442 | (37.7787552182629, -122.446808290442) | 15 | 5 | 1 | 54 | 16 | |||
| 136484 | 136219 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2901 Steiner St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002007.17609 | 2118176.89143 | 37.7962226754808 | -122.437086212761 | (37.7962226754808, -122.437086212761) | 13 | 9 | 1 | 57 | 17 | |||
| 137653 | 136253 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 802 North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006835.20454 | 2121555.13749 | 37.8057717318427 | -122.420620147698 | (37.8057717318427, -122.420620147698) | 5 | 1 | 1 | 28858 | 32 | |||
| 139769 | 137616 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2260 Turk Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5999176.7198 | 2111892.1732 | 37.7788051934023 | -122.446427777449 | (37.7788051934023, -122.446427777449) | 15 | 5 | 1 | 54 | 16 | |||
| 141976 | 120254 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 150 24th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5988369.36546 | 2114920.76145 | 37.7864976459369 | -122.4840363573 | (37.7864976459369, -122.4840363573) | 11 | 6 | 1 | 55 | 33 | |||
| 142312 | 91041 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2998 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50399 | 6006464.74623 | 2121395.99646 | 37.8053138860806 | -122.421890864574 | (37.8053138860806, -122.421890864574) | 5 | 1 | 1 | 28858 | 32 | |
| 142431 | 113165 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3902 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5996094.44333 | 2115248.19615 | 37.787843410013 | -122.457333370439 | (37.787843410013, -122.457333370439) | 11 | 6 | 1 | 54 | 31 | |||
| 144919 | 120775 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 57 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5989253.50277 | 2114844.12588 | 37.7863386601165 | -122.48097188408 | (37.7863386601165, -122.48097188408) | 11 | 6 | 1 | 55 | 33 | |||
| 144958 | 120776 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 57 21st Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5989252.7771 | 2114825.68271 | 37.7862879782034 | -122.48097304382 | (37.7862879782034, -122.48097304382) | 11 | 6 | 1 | 55 | 33 | |||
| 145775 | 99598 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3001 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Permit Number 17057 | 6002874.08515 | 2118929.42484 | 37.7983381750246 | -122.434140356598 | (37.7983381750246, -122.434140356598) | 13 | 9 | 1 | 57 | 17 | |||
| 146180 | 102862 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2750X Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | Permit Number 769980 | 6000834.2 | 2116922.3 | 37.792711153164 | -122.441054886769 | (37.792711153164, -122.441054886769) | 13 | 6 | 1 | 29490 | 27 | |||
| 146253 | 91043 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2998 Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50399 | 6006460.43386 | 2121423.80416 | 37.8053899957025 | -122.421907764657 | (37.8053899957025, -122.421907764657) | 5 | 1 | 1 | 28858 | 32 | |
| 147864 | 136198 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2101 Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000083.32441 | 2120905.42804 | 37.8036049673534 | -122.443939252695 | (37.8036049673534, -122.443939252695) | 13 | 9 | 1 | 57 | 17 | |||
| 147985 | 48960 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2038 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2002 12:00:00 AM | 10 | Permit Number 46146 | 6003159.19812 | 2118949.28174 | 37.7984088743259 | -122.433155199676 | (37.7984088743259, -122.433155199676) | 13 | 9 | 1 | 57 | 17 | ||
| 148818 | 136207 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 201 Laurel St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5998025.05505 | 2115724.49244 | 37.7892618895784 | -122.450688197907 | (37.7892618895784, -122.450688197907) | 11 | 6 | 1 | 54 | 31 | |||
| 148839 | 41237 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 270 Masonic Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1999 12:00:00 AM | Permit Number 41940 | 5999013.40299918 | 2112000.64122659 | 37.7790936893244 | -122.447000559943 | (37.7790936893244, -122.447000559943) | 15 | 5 | 1 | 54 | 16 | |||
| 149168 | 93044 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 155 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 5987698.59819 | 2114939.90173 | 37.7865111255347 | -122.486358421479 | (37.7865111255347, -122.486358421479) | 11 | 6 | 1 | 55 | 33 | ||||
| 149435 | 136203 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1349 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004849.18598 | 2120525.70738 | 37.8028330549672 | -122.427419683394 | (37.8028330549672, -122.427419683394) | 13 | 9 | 1 | 57 | 17 | |||
| 149755 | 69320 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1546 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1994 12:00:00 AM | 6 | Permit Number 33401 | 6004443.14953 | 2120171.11922 | 37.8018364748398 | -122.428799484421 | (37.8018364748398, -122.428799484421) | 13 | 9 | 1 | 57 | 17 | |
| 150286 | 138298 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2035 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6002877.6376 | 2115358.1531 | 37.7885325838594 | -122.433872664746 | (37.7885325838594, -122.433872664746) | 13 | 9 | 1 | 29490 | 27 | |||
| 152827 | 136250 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2711 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006868.56519 | 2121594.39083 | 37.8058813915667 | -122.420507486038 | (37.8058813915667, -122.420507486038) | 5 | 1 | 1 | 28858 | 32 | |||
| 153182 | 56681 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2245 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 6002229.691 | 2118425.2879 | 37.7969173530103 | -122.436334053014 | (37.7969173530103, -122.436334053014) | 13 | 9 | 1 | 57 | 17 | ||||
| 153403 | 136210 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3501 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5997980.46007 | 2115787.21083 | 37.7894315448801 | -122.450847014574 | (37.7894315448801, -122.450847014574) | 11 | 6 | 1 | 54 | 31 | |||
| 153472 | 136260 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 740 Francisco St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6007759.94756 | 2120993.00482 | 37.8042803312301 | -122.417380065732 | (37.8042803312301, -122.417380065732) | 5 | 1 | 1 | 308 | 32 | |||
| 153821 | 120258 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 130 24th Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5988366.4287 | 2115019.00218 | 37.7867672160285 | -122.484053724446 | (37.7867672160285, -122.484053724446) | 11 | 6 | 1 | 55 | 33 | |||
| 153983 | 24564 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2105 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/17/2012 12:00:00 AM | 3 | 3x3 | 6002854.79509 | 2115576.81041 | 37.7891316647783 | -122.433967332204 | (37.7891316647783, -122.433967332204) | 13 | 9 | 1 | 29490 | 27 | ||
| 155084 | 50668 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3130 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2004 12:00:00 AM | 4 | Permit Number 47247 | 6002421.15482 | 2119020.47996 | 37.7985624722307 | -122.435714148614 | (37.7985624722307, -122.435714148614) | 13 | 9 | 1 | 57 | 17 | ||
| 155605 | 106807 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 167 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 5996526.1156 | 2113238.8382 | 37.7823510325114 | -122.455694573485 | (37.7823510325114, -122.455694573485) | 11 | 6 | 1 | 54 | 31 | ||||
| 156061 | 105537 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2192 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6002561.80287 | 2118173.8704 | 37.796245890587 | -122.435166876954 | (37.796245890587, -122.435166876954) | 13 | 9 | 1 | 57 | 17 | |||
| 156468 | 95159 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2721 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 54078 | 6001026.7 | 2116843.3 | 37.7925052022591 | -122.440383162252 | (37.7925052022591, -122.440383162252) | 13 | 6 | 1 | 29490 | 27 | |||
| 156687 | 140884 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 642 SPRUCE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5997209.5584 | 2113437.661 | 37.782936144733 | -122.453344534721 | (37.782936144733, -122.453344534721) | 15 | 6 | 1 | 54 | 31 | |||
| 156816 | 7326 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2033 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2005 12:00:00 AM | 3 | 3X3 | 6002897.31453 | 2115259.18608 | 37.7882619622277 | -122.433797509249 | (37.7882619622277, -122.433797509249) | 13 | 9 | 1 | 29490 | 27 | ||
| 156909 | 65517 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2028 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/1990 12:00:00 AM | 9 | Permit Number 28403 | 6003226.45222 | 2118960.15524 | 37.7984425449573 | -122.432923257305 | (37.7984425449573, -122.432923257305) | 13 | 9 | 1 | 57 | 17 | ||
| 159999 | 137866 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2044 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/03/2012 12:00:00 AM | 1 | Width 0ft | 6002931.7599 | 2115390.6101 | 37.7886247736431 | -122.433687730722 | (37.7886247736431, -122.433687730722) | 13 | 9 | 1 | 29490 | 27 | ||
| 160086 | 24574 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2052 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/1996 12:00:00 AM | 2 | 3X3 | 6002937.5533 | 2115333.01406 | 37.7884669583176 | -122.433663568449 | (37.7884669583176, -122.433663568449) | 13 | 9 | 1 | 29490 | 27 | ||
| 160665 | 50669 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3130 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2004 12:00:00 AM | 9 | Permit Number 47247 | 6002419.67533 | 2119034.32922 | 37.7986004146463 | -122.435720259485 | (37.7986004146463, -122.435720259485) | 13 | 9 | 1 | 57 | 17 | ||
| 164363 | 24810 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2412 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/12/1996 12:00:00 AM | 6 | 3X3 | 6002765.09996 | 2116553.7465 | 37.7918089904517 | -122.434347539746 | (37.7918089904517, -122.434347539746) | 13 | 9 | 1 | 29490 | 27 | ||
| 164899 | 138287 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2019 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6002887.6089 | 2115262.2788 | 37.7882699032996 | -122.433831310222 | (37.7882699032996, -122.433831310222) | 13 | 9 | 1 | 29490 | 27 | |||
| 165619 | 136216 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3330 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5998869.71206 | 2115631.48922 | 37.7890548395604 | -122.447759099698 | (37.7890548395604, -122.447759099698) | 13 | 6 | 1 | 54 | 31 | |||
| 165912 | 120183 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 160 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5987744.35264 | 2114901.48572 | 37.7864083129421 | -122.486197303246 | (37.7864083129421, -122.486197303246) | 11 | 6 | 1 | 55 | 33 | |||
| 166209 | 136214 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3601 Jackson St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5996953.55493 | 2115974.46386 | 37.7898868527455 | -122.45441350369 | (37.7898868527455, -122.45441350369) | 11 | 6 | 1 | 54 | 31 | |||
| 166803 | 48419 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2192 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2002 12:00:00 AM | 5 | Permit Number 45797 | 6002578.00127 | 2118175.76067 | 37.7962520005898 | -122.435110962497 | (37.7962520005898, -122.435110962497) | 13 | 9 | 1 | 57 | 17 | ||
| 166845 | 94791 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2 Laurel St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/2010 12:00:00 AM | 4 | Permit Number 53892 | 5997983.38903 | 2116351.46746 | 37.7909810111097 | -122.450877583428 | (37.7909810111097, -122.450877583428) | 13 | 6 | 1 | 54 | 31 | ||
| 167196 | 136228 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1695 North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002671.67342 | 2120917.48858 | 37.8037853875576 | -122.434983019554 | (37.8037853875576, -122.434983019554) | 13 | 9 | 1 | 57 | 17 | |||
| 168977 | 137615 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2256 Turk Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5999208.8698 | 2111896.2343 | 37.7788181803478 | -122.446316850598 | (37.7788181803478, -122.446316850598) | 15 | 5 | 1 | 54 | 16 | |||
| 169715 | 136196 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2102 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002856.44865 | 2118905.61709 | 37.7982718041617 | -122.43419968127 | (37.7982718041617, -122.43419968127) | 13 | 9 | 1 | 57 | 17 | |||
| 170159 | 120774 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 57 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5989253.85466 | 2114850.93568 | 37.7863573783569 | -122.480971165425 | (37.7863573783569, -122.480971165425) | 11 | 6 | 1 | 55 | 33 | |||
| 170365 | 136225 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3699 Divisadero St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000164.78748 | 2120871.42318 | 37.803516245636 | -122.443654902352 | (37.803516245636, -122.443654902352) | 13 | 9 | 1 | 57 | 17 | |||
| 171580 | 136205 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 201 Locust St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5997542.32225 | 2115652.46545 | 37.7890364790074 | -122.452353187461 | (37.7890364790074, -122.452353187461) | 11 | 6 | 1 | 54 | 31 | |||
| 173859 | 136211 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 101 Spruce St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5997026.34564 | 2115964.00812 | 37.7898623183414 | -122.454160900321 | (37.7898623183414, -122.454160900321) | 11 | 6 | 1 | 54 | 31 | |||
| 174369 | 113164 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3902 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5996104.12061 | 2115248.79576 | 37.7878456121944 | -122.457299932451 | (37.7878456121944, -122.457299932451) | 11 | 6 | 1 | 54 | 31 | |||
| 176997 | 80106 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2522 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50838 | 5999743.67056 | 2119517.2337 | 37.7997739777354 | -122.445014781615 | (37.7997739777354, -122.445014781615) | 13 | 9 | 1 | 57 | 17 | |
| 177892 | 136208 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 201 Laurel St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5998027.29878 | 2115711.03969 | 37.7892250803304 | -122.450679464593 | (37.7892250803304, -122.450679464593) | 11 | 6 | 1 | 54 | 31 | |||
| 179294 | 30566 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2245 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 9 | Permit Number 34543 | 6002231.0779 | 2118426.88679 | 37.796921821948 | -122.436329368507 | (37.796921821948, -122.436329368507) | 13 | 9 | 1 | 57 | 17 | ||
| 180083 | 120255 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 150 24th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5988367.99594 | 2114912.99225 | 37.7864762341937 | -122.484040525506 | (37.7864762341937, -122.484040525506) | 11 | 6 | 1 | 55 | 33 | |||
| 180943 | 136213 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 107 Spruce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5997027.70911 | 2115921.73522 | 37.7897463264678 | -122.454153128371 | (37.7897463264678, -122.454153128371) | 11 | 6 | 1 | 54 | 31 | |||
| 181575 | 136110 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1725 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6005929.66848 | 2117544.18385 | 37.7947075984216 | -122.423468565942 | (37.7947075984216, -122.423468565942) | 13 | 9 | 1 | 28858 | 27 | |||
| 181802 | 136223 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3699 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000162.37398 | 2120896.27063 | 37.8035843324119 | -122.443665040435 | (37.8035843324119, -122.443665040435) | 13 | 9 | 1 | 57 | 17 | |||
| 182977 | 136191 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2914 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6002535.25273 | 2118218.14981 | 37.7963659626655 | -122.435261914602 | (37.7963659626655, -122.435261914602) | 13 | 9 | 1 | 57 | 17 | |||
| 184251 | 113166 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3902 Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5996084.69058 | 2115243.98919 | 37.7878312986742 | -122.457366808459 | (37.7878312986742, -122.457366808459) | 11 | 6 | 1 | 54 | 31 |
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) );