trees
508 rows where qSpecies_id = 25 sorted by qLegalStatus_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 42 | 221891 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 180 Bartlett St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006685.21207 | 2102724.39469 | 37.7540586268078 | -122.419802203518 | (37.7540586268078, -122.419802203518) | 2 | 4 | 7 | 28859 | 19 | |||
| 636 | 67551 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 655 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 8 | Permit Number 31099 | 6011561.87177 | 2105285.59303 | 37.7613646282886 | -122.403117586111 | (37.7613646282886, -122.403117586111) | 10 | 3 | 8 | 28856 | 29 | |
| 732 | 181868 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2335 28th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 02/24/2020 12:00:00 AM | 3 | 5x5 | 5987618.1769 | 2099375.389 | 37.7437705756333 | -122.485494034638 | (37.7437705756333, -122.485494034638) | 1 | 8 | 3 | 29491 | 35 | ||
| 993 | 67493 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 740 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/08/1992 12:00:00 AM | 8 | Permit Number 31018 | 6011800.9294 | 2105019.52264 | 37.7606474054712 | -122.402272073209 | (37.7606474054712, -122.402272073209) | 10 | 3 | 8 | 28856 | 29 | ||
| 1058 | 160441 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 201 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/07/2019 12:00:00 AM | 3 | 4x6 | 6001628.58163 | 2090114.34641 | 37.7191481986061 | -122.436386782123 | (37.7191481986061, -122.436386782123) | 9 | 7 | 6 | 28861 | 5 | |
| 1568 | 172155 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 649 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x5 | 6011250.4218 | 2091802.92791 | 37.7243267296922 | -122.403246295306 | (37.7243267296922, -122.403246295306) | 10 | 3 | 7 | 309 | 28 | |||
| 2041 | 160444 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 201 France Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/07/2019 12:00:00 AM | 3 | 4x6 | 6001593.49946 | 2090135.39202 | 37.7192039916542 | -122.436509553078 | (37.7192039916542, -122.436509553078) | 9 | 7 | 6 | 28861 | 5 | |
| 2212 | 225967 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3599 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005877.12817 | 2101963.64024 | 37.7519242145407 | -122.422542702196 | (37.7519242145407, -122.422542702196) | 2 | 4 | 5 | 28859 | 19 | |||
| 2617 | 247759 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 75 Alpine Ter | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6001668.74952 | 2108376.80716 | 37.7692948959648 | -122.437555068929 | (37.7692948959648, -122.437555068929) | 15 | 5 | 5 | 29492 | 9 | |||
| 2735 | 262549 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 923 Ingerson Ave | 3 | unknown : Yard | Tree | Private 2 | 08/20/2020 12:00:00 AM | Width 0ft | 6014491.3602 | 2089577.767 | 37.7183973497527 | -122.391887217647 | (37.7183973497527, -122.391887217647) | 10 | 3 | 8 | 58 | 1 | |||
| 3438 | 194171 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 740 Rhode Island St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 7ft | 6011792.75247 | 2105015.27083 | 37.7606352745052 | -122.402300054726 | (37.7606352745052, -122.402300054726) | 10 | 3 | 8 | 28856 | 29 | |||
| 4108 | 171288 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 337 Avalon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 3ft | 6003689.73978 | 2092721.91783 | 37.7264249154698 | -122.429448003531 | (37.7264249154698, -122.429448003531) | 9 | 7 | 6 | 28861 | 5 | ||
| 4771 | 261101 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1188 Jamestown Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6013127 | 2090401 | 37.7205819447786 | -122.396660953022 | (37.7205819447786, -122.396660953022) | 10 | 3 | 8 | 58 | 1 | |
| 4939 | 225906 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3749 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6005541.4535 | 2101364.78602 | 37.7502609561874 | -122.423660939909 | (37.7502609561874, -122.423660939909) | 2 | 4 | 5 | 28859 | 19 | |||
| 5319 | 26546 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 570 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/17/2020 12:45:00 PM | 3 | 4X4 | 6008578.3106 | 2121094.8201 | 37.804605899968 | -122.414555254943 | (37.804605899968, -122.414555254943) | 3 | 1 | 10 | 308 | 23 | ||
| 5483 | 83664 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 75 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/27/2019 12:00:00 AM | 3 | 3x3 | Permit Number 769750 | 6003631.23676 | 2092962.7354 | 37.7270828342867 | -122.429667413832 | (37.7270828342867, -122.429667413832) | 9 | 7 | 6 | 28861 | 5 |
| 6826 | 261100 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1900 Donner Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6011819 | 2093407 | 37.7287629192895 | -122.401393465775 | (37.7287629192895, -122.401393465775) | 10 | 3 | 8 | 58 | 1 | |
| 7119 | 160442 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 201 France Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/07/2019 12:00:00 AM | 3 | 4x6 | 6001618.67643 | 2090120.31362 | 37.7191640203955 | -122.436421447404 | (37.7191640203955, -122.436421447404) | 9 | 7 | 6 | 28861 | 5 | |
| 7174 | 225912 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1038 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6005698.15966 | 2102902.03106 | 37.7544907204839 | -122.423228299447 | (37.7544907204839, -122.423228299447) | 2 | 4 | 5 | 28859 | 19 | |||
| 7369 | 228945 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 25 Camp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/11/2020 12:00:00 AM | 3 | 3x3 | 6005777.88967 | 2106349.43528 | 37.7639609845445 | -122.423197607405 | (37.7639609845445, -122.423197607405) | 8 | 4 | 5 | 28859 | 19 | |
| 7887 | 152881 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3572 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005780.88013 | 2104928.47476 | 37.7600595303512 | -122.42308625784 | (37.7600595303512, -122.42308625784) | 2 | 4 | 5 | 28859 | 19 | |||
| 8075 | 225935 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1250 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/1994 12:00:00 AM | 10 | Width 3ft | Permit Number 33274 | 6008670.47689 | 2101262.07632 | 37.7501550682215 | -122.412833276033 | (37.7501550682215, -122.412833276033) | 2 | 4 | 7 | 28859 | 19 | |
| 9064 | 160443 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 201 France Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/07/2019 12:00:00 AM | 3 | 4x6 | 6001607.56751 | 2090126.88906 | 37.7191814438384 | -122.436460317003 | (37.7191814438384, -122.436460317003) | 9 | 7 | 6 | 28861 | 5 | |
| 9398 | 264655 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1099 Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/08/2020 04:53:00 PM | 3x3 | |||||||||||||
| 9717 | 56360 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2100 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1973 12:00:00 AM | 30 | Permit Number 12506 | 6000958.47841613 | 2115569.02150374 | 37.7890024802988 | -122.440527774143 | (37.7890024802988, -122.440527774143) | 13 | 6 | 1 | 29490 | 27 | |
| 10034 | 262181 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 299 Raymond Ave | 1 | Side Yard : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | 6009464.05793 | 2087979.76345 | 37.7137291845874 | -122.409151878423 | (37.7137291845874, -122.409151878423) | 9 | 7 | 8 | 309 | 39 | ||
| 10061 | 171232 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 83 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/13/2019 12:00:00 AM | 3 | 4x6 | 6003613.10498 | 2092939.5829 | 37.727018235977 | -122.429728444518 | (37.727018235977, -122.429728444518) | 9 | 7 | 6 | 28861 | 5 | ||
| 10451 | 225947 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 114 Rousseau St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6003497.57041 | 2095097.96573 | 37.7329381267755 | -122.430281767707 | (37.7329381267755, -122.430281767707) | 9 | 7 | 5 | 28861 | 25 | |||
| 10559 | 10061 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 490 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 2X2 | 6005517.65207 | 2106131.14555 | 37.7633469229371 | -122.424082167969 | (37.7633469229371, -122.424082167969) | 8 | 4 | 5 | 28859 | 19 | |||
| 11255 | 70154 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 339 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5992446.53753 | 2113177.4125 | 37.7819474134806 | -122.469803511026 | (37.7819474134806, -122.469803511026) | 11 | 6 | 2 | 54 | 11 | |||
| 11311 | 73919 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 179 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6007979.77962 | 2109750.06791 | 37.77342234081 | -122.415822718756 | (37.77342234081, -122.415822718756) | 8 | 2 | 9 | 28853 | 34 | |||
| 11749 | 200232 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 923 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 08/20/2020 12:00:00 AM | 3 | Width 0ft | 6014491.3602 | 2089577.767 | 37.7183973497527 | -122.391887217647 | (37.7183973497527, -122.391887217647) | 10 | 3 | 8 | 58 | 1 | ||
| 11951 | 142340 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 520 Central Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999729.6682 | 2110321.6281 | 37.7745244442512 | -122.444402018718 | (37.7745244442512, -122.444402018718) | 15 | 5 | 11 | 29492 | 16 | |||
| 12728 | 256034 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1455 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6015659 | 2093559 | 37.729393784799 | -122.388128823531 | (37.729393784799, -122.388128823531) | 10 | 3 | 8 | 58 | 1 | |||
| 13102 | 200235 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 923 Ingerson Ave | 2 | unknown : Yard | Tree | Private 2 | 08/20/2020 12:00:00 AM | 0 | Width 0ft | 6014534.9569 | 2089547.5847 | 37.7183168953073 | -122.39173441165 | (37.7183168953073, -122.39173441165) | 10 | 3 | 8 | 58 | 1 | ||
| 13467 | 70988 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 179 11th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6007961.92289 | 2109767.88075 | 37.7734702467743 | -122.415885749526 | (37.7734702467743, -122.415885749526) | 8 | 2 | 9 | 28853 | 34 | |||
| 13543 | 83275 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1639X Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6008740.14676 | 2118614.90766 | 37.7978057691893 | -122.413819676732 | (37.7978057691893, -122.413819676732) | 5 | 1 | 10 | 308 | 21 | |||
| 13990 | 142563 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 555 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2020 12:42:00 PM | 3 | Width 0ft | 6008640.5494 | 2121060.0298 | 37.8045138709312 | -122.414337407838 | (37.8045138709312, -122.414337407838) | 3 | 1 | 10 | 308 | 23 | ||
| 14624 | 261099 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1900 Donner Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6011819 | 2093407 | 37.7287629192895 | -122.401393465775 | (37.7287629192895, -122.401393465775) | 10 | 3 | 8 | 58 | 1 | |
| 14626 | 225965 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 81 Bernal Heights Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009494.27227 | 2098224.22173 | 37.7418599932559 | -122.409770124916 | (37.7418599932559, -122.409770124916) | 10 | 7 | 7 | 28859 | 2 | |||
| 15134 | 261076 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1188 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6013127 | 2090401 | 37.7205819447786 | -122.396660953022 | (37.7205819447786, -122.396660953022) | 10 | 3 | 8 | 58 | 1 | |
| 15256 | 259564 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 200 Public Park | 3 | Unaccepted Street : Cutout | Tree | Private 2 | 5x10 | 5994204 | 2098512 | 37.741781429361 | -122.462659374294 | (37.741781429361, -122.462659374294) | 1 | 8 | 4 | 59 | 40 | ||||
| 15349 | 122920 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 330 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2020 12:00:00 AM | 3 | Width 2ft | 5992493.10071 | 2113220.22773 | 37.7820676636923 | -122.469645543184 | (37.7820676636923, -122.469645543184) | 11 | 6 | 2 | 54 | 11 | ||
| 15542 | 262169 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 111 Raymond Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | 6010514.3033 | 2087552.92261 | 37.7126159475575 | -122.405491784734 | (37.7126159475575, -122.405491784734) | 9 | 7 | 8 | 309 | 39 | ||
| 16190 | 34502 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1415 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1997 12:00:00 AM | 9 | Permit Number 38224 | 6013698.3172 | 2104744.62684 | 37.7599983314835 | -122.395690557494 | (37.7599983314835, -122.395690557494) | 10 | 3 | 8 | 28856 | 29 | |
| 16692 | 78621 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2140 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6011632.94564 | 2104677.50372 | 37.7596989192821 | -122.402829001752 | (37.7596989192821, -122.402829001752) | 10 | 3 | 8 | 28856 | 29 | |||
| 16772 | 113034 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 251 06th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 2 | 3x3 | 5993975.1139 | 2113804.1265 | 37.7837564355183 | -122.464560902617 | (37.7837564355183, -122.464560902617) | 11 | 6 | 2 | 54 | 11 | |||
| 17201 | 72137 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1445 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6013608.91395 | 2104739.63414 | 37.7599796489713 | -122.395999412568 | (37.7599796489713, -122.395999412568) | 10 | 3 | 8 | 28856 | 29 | |||
| 17383 | 258113 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 144 Freelon St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 6013235.08289 | 2111410.77261 | 37.7782762981131 | -122.397760259133 | (37.7782762981131, -122.397760259133) | 6 | 2 | 9 | 28856 | 34 | |||||
| 17567 | 150775 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2004 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 3 | 4x5 | 6012077.37529 | 2103767.84682 | 37.757226007585 | -122.401228007969 | (37.757226007585, -122.401228007969) | 10 | 3 | 8 | 28856 | 29 | |
| 18508 | 79749 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 615 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6015454.74686 | 2106112.32495 | 37.7638512843329 | -122.389711390588 | (37.7638512843329, -122.389711390588) | 14 | 3 | 8 | 28856 | 29 | |||
| 19037 | 163093 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 207 Minerva St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/30/2020 12:00:00 AM | 3 | Width 0ft | 5994973.89241 | 2089001.27362 | 37.7157115895984 | -122.459308778876 | (37.7157115895984, -122.459308778876) | 9 | 8 | 6 | 28861 | 24 | ||
| 19143 | 83274 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1639X Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6008741.72565 | 2118600.65097 | 37.7977667125146 | -122.41381320433 | (37.7977667125146, -122.41381320433) | 5 | 1 | 10 | 308 | 21 | |||
| 19459 | 49782 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 327 Wheeler Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/2020 12:00:00 AM | 3 | Permit Number 46567 | 6012093.71999 | 2087090.74144 | 37.711435076735 | -122.400000354248 | (37.711435076735, -122.400000354248) | 10 | 3 | 8 | 309 | 1 | |
| 21411 | 10091 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 708 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/1992 12:00:00 AM | 50 | 3X3 | 6005589.43333 | 2104821.82229 | 37.7597558823477 | -122.423740797923 | (37.7597558823477, -122.423740797923) | 2 | 4 | 5 | 28859 | 19 | ||
| 22071 | 192422 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 80 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6012207.07921 | 2107722.19142 | 37.7680909933277 | -122.401057281578 | (37.7680909933277, -122.401057281578) | 14 | 3 | 8 | 28856 | 20 | |||
| 22267 | 82278 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 245 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50610 | 5992733.47806 | 2113805.1753 | 37.7836876598148 | -122.468856534024 | (37.7836876598148, -122.468856534024) | 11 | 6 | 2 | 54 | 11 | |
| 23417 | 128877 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1237x Robert C Levy Tunl | 6 | Median : Yard | Tree | DPW 1 | 3 | 6007635.08843 | 2118146.70213 | 37.796458073045 | -122.417610293998 | (37.796458073045, -122.417610293998) | 5 | 1 | 10 | 28858 | 32 | ||||
| 23576 | 10026 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 290 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 2x3 | 6005455.03663 | 2107324.13866 | 37.7666190630424 | -122.424383592842 | (37.7666190630424, -122.424383592842) | 8 | 4 | 5 | 28853 | 19 | |||
| 24456 | 225946 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3557 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6005893.76776 | 2102550.85426 | 37.7535375074585 | -122.422526882211 | (37.7535375074585, -122.422526882211) | 2 | 4 | 5 | 28859 | 19 | |||
| 25081 | 225931 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 337 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6007076.3964 | 2096610.27498 | 37.737292658529 | -122.418015982652 | (37.737292658529, -122.418015982652) | 2 | 7 | 7 | 28859 | 2 | |||
| 25269 | 128865 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2610 Clay St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6001864.71047 | 2116045.71849 | 37.7903629286659 | -122.437426485651 | (37.7903629286659, -122.437426485651) | 13 | 6 | 1 | 29490 | 27 | |||
| 27196 | 225957 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 38 Newman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007027 | 2096768 | 37.7377229562927 | -122.418197948284 | (37.7377229562927, -122.418197948284) | 2 | 7 | 7 | 28859 | 2 | |||
| 27374 | 176498 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 144 Brookdale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 6005795.48549 | 2087494.48765 | 37.7121905153633 | -122.421797376475 | (37.7121905153633, -122.421797376475) | 9 | 7 | 8 | 309 | 18 | |||
| 27739 | 49765 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 333 Schwerin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 5 | Permit Number 46559 | 6008653.27394 | 2086377.17589 | 37.7092833534188 | -122.411841080097 | (37.7092833534188, -122.411841080097) | 9 | 7 | 8 | 309 | 39 | |
| 27755 | 82843 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 719 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52435 | 6009401.3474 | 2110338.98679 | 37.7751191888227 | -122.410946896775 | (37.7751191888227, -122.410946896775) | 8 | 2 | 9 | 28853 | 34 | |
| 27821 | 29763 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 530 Francisco St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6008751.4918274 | 2121120.9717011 | 37.8046874335197 | -122.41395779393 | (37.8046874335197, -122.41395779393) | 3 | 1 | 10 | 308 | 23 | |||
| 29333 | 225916 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3778 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005165.83624 | 2104308.70302 | 37.7583230563848 | -122.425169300823 | (37.7583230563848, -122.425169300823) | 2 | 4 | 5 | 28859 | 19 | |||
| 29499 | 244210 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 546 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6003934.6479 | 2109752.6175 | 37.7732011032912 | -122.429815586143 | (37.7732011032912, -122.429815586143) | 7 | 9 | 11 | 29492 | 10 | |||
| 30350 | 225979 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 171 Germania St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003500.9012 | 2108793.5344 | 37.7705431243846 | -122.431247500167 | (37.7705431243846, -122.431247500167) | 15 | 9 | 11 | 29492 | 10 | |||
| 30741 | 176516 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 49 Brookdale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 6006459.4617 | 2087377.28485 | 37.7119061227438 | -122.419494165041 | (37.7119061227438, -122.419494165041) | 9 | 7 | 8 | 309 | 39 | |||
| 31931 | 219011 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 157 Miramar Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995317.53334 | 2090902.82075 | 37.7209525389978 | -122.458258556883 | (37.7209525389978, -122.458258556883) | 9 | 8 | 6 | 28861 | 24 | |||
| 32183 | 225901 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1 Camp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6005825.23106 | 2106352.45228 | 37.7639719400684 | -122.423034081872 | (37.7639719400684, -122.423034081872) | 8 | 4 | 5 | 28859 | 19 | |||
| 32550 | 59941 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1706 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1981 12:00:00 AM | 0 | Permit Number 19415 | 5999632.27517388 | 2110547.02087839 | 37.7751377580465 | -122.444755123369 | (37.7751377580465, -122.444755123369) | 15 | 5 | 11 | 29492 | 16 | |
| 33588 | 192415 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1400 20th St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6013731.20085 | 2104795.92406 | 37.7601410116297 | -122.39558042201 | (37.7601410116297, -122.39558042201) | 10 | 3 | 8 | 28856 | 29 | |||
| 34506 | 128874 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1270 Clay St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6008580.96851 | 2116980.96928 | 37.7933104368651 | -122.414254814618 | (37.7933104368651, -122.414254814618) | 5 | 1 | 10 | 28857 | 21 | |||
| 35833 | 142337 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 500 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5999743.369 | 2110239.8651 | 37.774300725553 | -122.44434874809 | (37.774300725553, -122.44434874809) | 15 | 5 | 11 | 29492 | 16 | |||
| 35950 | 10087 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 673 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4x4 | 6005642.33302 | 2105078.49447 | 37.7604636299235 | -122.423576092482 | (37.7604636299235, -122.423576092482) | 2 | 4 | 5 | 28859 | 19 | |||
| 37150 | 176505 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 178 Brookdale Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6005616.04698 | 2087112.68704 | 37.7111320510829 | -122.422390458676 | (37.7111320510829, -122.422390458676) | 9 | 7 | 8 | 309 | 18 | |||
| 38084 | 10079 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 614 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6005561.0033 | 2105378.47551 | 37.7612827162343 | -122.423878706238 | (37.7612827162343, -122.423878706238) | 2 | 4 | 5 | 28859 | 19 | |||
| 38898 | 225905 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3620 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6006092.03845 | 2100850.85024 | 37.7488808700704 | -122.421720479039 | (37.7488808700704, -122.421720479039) | 2 | 4 | 5 | 28859 | 19 | |||
| 39253 | 66067 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1425 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/06/1990 12:00:00 AM | 12 | Permit Number 29107 | 6013650.29046 | 2104740.70593 | 37.7599848938155 | -122.395856385278 | (37.7599848938155, -122.395856385278) | 10 | 3 | 8 | 28856 | 29 | |
| 40615 | 225925 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 357 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004205.07883 | 2098948.09387 | 37.7435497528103 | -122.428110007472 | (37.7435497528103, -122.428110007472) | 2 | 7 | 5 | 63 | 22 | |||
| 40882 | 219016 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 23 Gaviota Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5998493.11217 | 2097521.42795 | 37.7393076426268 | -122.447757806504 | (37.7393076426268, -122.447757806504) | 9 | 7 | 4 | 59 | 40 | |||
| 40896 | 247270 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1520 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5999196.9373 | 2109093.7955 | 37.7711227186713 | -122.446156493551 | (37.7711227186713, -122.446156493551) | 15 | 5 | 11 | 29492 | 9 | |||
| 41440 | 10174 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1038 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 2x2 | 6005692.3267338 | 2102916.9952862 | 37.7545314795937 | -122.423249534916 | (37.7545314795937, -122.423249534916) | 2 | 4 | 5 | 28859 | 19 | |||
| 41661 | 49835 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 587 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | 11 | Permit Number 46618 | 6014427.95757 | 2104386.86383 | 37.7590565524297 | -122.393142029905 | (37.7590565524297, -122.393142029905) | 10 | 3 | 8 | 28856 | 29 | |
| 42236 | 66180 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1409 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/06/1990 12:00:00 AM | 12 | Permit Number 29257 | 6013724.4666 | 2104745.52937 | 37.7600022642143 | -122.395600181905 | (37.7600022642143, -122.395600181905) | 10 | 3 | 8 | 28856 | 29 | |
| 42399 | 7700 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 640 Francisco St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6x6 | 6008187.1407969 | 2121043.7620312 | 37.8044437236489 | -122.415905321467 | (37.8044437236489, -122.415905321467) | 5 | 1 | 10 | 308 | 23 | |||
| 42562 | 192418 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2 Sierra St | 2 | : | Tree | Private 2 | 9 | Width 5ft | 6013740.02795 | 2104156.22974 | 37.7583850412574 | -122.395505075892 | (37.7583850412574, -122.395505075892) | 10 | 3 | 8 | 28856 | 29 | |||
| 43636 | 94704 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 670 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53844 | 5992265.91007 | 2110887.94739 | 37.7756507238334 | -122.470261618584 | (37.7756507238334, -122.470261618584) | 11 | 6 | 2 | 54 | 11 |
| 43646 | 176517 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 49 Brookdale Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6006489.32827 | 2087380.0454 | 37.7119153848503 | -122.419391133293 | (37.7119153848503, -122.419391133293) | 9 | 7 | 8 | 309 | 39 | |||
| 43773 | 21413 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2692X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | 1 | 8 | 3 | 29491 | 35 | ||||
| 44550 | 192417 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2 Sierra St | 1 | : | Tree | Private 2 | 11 | Width 5ft | 6013758.38911 | 2104156.54332 | 37.7583869235411 | -122.395441596376 | (37.7583869235411, -122.395441596376) | 10 | 3 | 8 | 28856 | 29 | |||
| 45175 | 225948 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 123 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6003779.75499 | 2095097.51754 | 37.7329528756765 | -122.429306150766 | (37.7329528756765, -122.429306150766) | 9 | 7 | 5 | 28861 | 25 | |||
| 45964 | 67574 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 601 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 13 | Permit Number 31129 | 6013300.57075 | 2104280.61777 | 37.7587021305084 | -122.397033645504 | (37.7587021305084, -122.397033645504) | 10 | 3 | 8 | 28856 | 29 | |
| 46410 | 6257 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1324X Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004503.4535 | 2113305.70612 | 37.782989203891 | -122.428101266861 | (37.782989203891, -122.428101266861) | 7 | 9 | 11 | 29490 | 41 | |||
| 46773 | 10037 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 351 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x2 | 6005536.77146 | 2106975.88456 | 37.765667455319 | -122.424076117338 | (37.765667455319, -122.424076117338) | 8 | 4 | 5 | 28853 | 19 | |||
| 46881 | 128878 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2507 Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006675.76572 | 2119877.35226 | 37.8011559740396 | -122.421052707221 | (37.8011559740396, -122.421052707221) | 5 | 9 | 1 | 28858 | 32 | |||
| 47916 | 128869 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2610 Clay St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6001642.59008 | 2116017.92803 | 37.7902739929064 | -122.438193013824 | (37.7902739929064, -122.438193013824) | 13 | 6 | 1 | 29490 | 27 |
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) );