trees
508 rows where qSpecies_id = 25 sorted by YCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1940 | 43017 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42880 | ||||||||||||||
2319 | 34069 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 955 Kennedy Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/1997 12:00:00 AM | Permit Number 37965 | |||||||||||||
3439 | 43015 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42880 | ||||||||||||||
5259 | 45154 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1683 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2001 12:00:00 AM | Permit Number 44007 | |||||||||||||
5523 | 38232 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 0 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1998 12:00:00 AM | Permit Number 40352 | |||||||||||||
6572 | 34068 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 955 Kennedy Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/1997 12:00:00 AM | Permit Number 37965 | |||||||||||||
6767 | 38234 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 0 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1998 12:00:00 AM | Permit Number 40352 | |||||||||||||
7060 | 38233 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 0 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1998 12:00:00 AM | Permit Number 40352 | |||||||||||||
7097 | 34072 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 955 Kennedy Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/1997 12:00:00 AM | Permit Number 37965 | |||||||||||||
7436 | 43016 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42880 | ||||||||||||||
9043 | 43018 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42880 | ||||||||||||||
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 | |||||||||||||
12809 | 38231 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 0 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1998 12:00:00 AM | Permit Number 40352 | |||||||||||||
14576 | 34071 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 955 Kennedy Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/1997 12:00:00 AM | Permit Number 37965 | |||||||||||||
16742 | 34070 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 955 Kennedy Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/1997 12:00:00 AM | Permit Number 37965 | |||||||||||||
17098 | 34067 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 955 Kennedy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/1997 12:00:00 AM | Permit Number 37965 | |||||||||||||
123054 | 49771 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 333 Schwerin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 1 | Permit Number 46559 | 6008634.11039 | 2086335.40293 | 37.7091675783038 | -122.411904362692 | (37.7091675783038, -122.411904362692) | 9 | 7 | 8 | 309 | 39 | |
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 | |
132781 | 49769 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 333 Schwerin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 4 | Permit Number 46559 | 6008658.89925 | 2086391.11579 | 37.7093219451162 | -122.411822622426 | (37.7093219451162, -122.411822622426) | 9 | 7 | 8 | 309 | 39 | |
85756 | 49772 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 333 Schwerin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 6 | Permit Number 46559 | 6008665.3182 | 2086406.55888 | 37.7093647087858 | -122.411801527923 | (37.7093647087858, -122.411801527923) | 9 | 7 | 8 | 309 | 39 | |
153977 | 49768 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 333 Schwerin St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 7 | Permit Number 46559 | 6008671.05987 | 2086426.1944 | 37.7094189460104 | -122.411783070238 | (37.7094189460104, -122.411783070238) | 9 | 7 | 8 | 309 | 39 | |
70165 | 49767 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 333 Schwerin St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 7 | Permit Number 46559 | 6008676.28834 | 2086439.38255 | 37.7094554512839 | -122.41176593097 | (37.7094554512839, -122.41176593097) | 9 | 7 | 8 | 309 | 39 | |
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 | |
95703 | 176506 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 178 Brookdale Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6005608.52394 | 2087094.53344 | 37.7110817807597 | -122.42241517113 | (37.7110817807597, -122.42241517113) | 9 | 7 | 8 | 309 | 18 | |||
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 | |||
157138 | 176504 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 178 Brookdale Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6005618.83947 | 2087124.32667 | 37.711164168567 | -122.422381633625 | (37.711164168567, -122.422381633625) | 9 | 7 | 8 | 309 | 18 | |||
101446 | 176503 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 170 Brookdale Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6005661.68615 | 2087270.92863 | 37.7115691233988 | -122.422243953714 | (37.7115691233988, -122.422243953714) | 9 | 7 | 8 | 309 | 18 | |||
49249 | 176502 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 170 Brookdale Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6005669.88649 | 2087297.20509 | 37.7116417355373 | -122.42221747678 | (37.7116417355373, -122.42221747678) | 9 | 7 | 8 | 309 | 18 | |||
155738 | 176507 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 150 Brookdale Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 45 | Width 6ft | 6005719.71054 | 2087314.8851 | 37.7116930913392 | -122.422046526423 | (37.7116930913392, -122.422046526423) | 9 | 7 | 8 | 309 | 39 | |||
55179 | 176501 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 170 Brookdale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 6005674.86736 | 2087315.91925 | 37.7116934016018 | -122.422201590246 | (37.7116934016018, -122.422201590246) | 9 | 7 | 8 | 309 | 18 | |||
143314 | 176508 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 150 Brookdale Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 50 | Width 6ft | 6005731.29388 | 2087351.07842 | 37.7117931238283 | -122.422009060692 | (37.7117931238283, -122.422009060692) | 9 | 7 | 8 | 309 | 39 | |||
63017 | 176519 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1501 Sunnydale Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 6007411.664 | 2087356.69589 | 37.7119031774593 | -122.416201620236 | (37.7119031774593, -122.416201620236) | 9 | 7 | 8 | 309 | 39 | |||
113428 | 176518 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1501 Sunnydale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 6007403.12553 | 2087360.36514 | 37.7119127723386 | -122.416231391376 | (37.7119127723386, -122.416231391376) | 9 | 7 | 8 | 309 | 39 | |||
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 | |||
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 | |||
71647 | 176515 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 154 Brookdale Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 6006304.71292 | 2087396.6514 | 37.7119505816242 | -122.420030394781 | (37.7119505816242, -122.420030394781) | 9 | 7 | 8 | 309 | 39 | |||
128154 | 176514 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 154 Brookdale Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 6006291.2518 | 2087400.97553 | 37.7119616963423 | -122.420077226985 | (37.7119616963423, -122.420077226985) | 9 | 7 | 8 | 309 | 39 | |||
86316 | 176513 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 154 Brookdale Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6006276.40846 | 2087403.97862 | 37.7119691058641 | -122.420128742862 | (37.7119691058641, -122.420128742862) | 9 | 7 | 8 | 309 | 39 | |||
164183 | 176512 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 154 Brookdale Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6006244.01324 | 2087410.04073 | 37.711983925792 | -122.420241140118 | (37.711983925792, -122.420241140118) | 9 | 7 | 8 | 309 | 39 | |||
164299 | 176500 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 162 Brookdale Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6005731.33862 | 2087429.69303 | 37.712008985404 | -122.422014487205 | (37.712008985404, -122.422014487205) | 9 | 7 | 8 | 309 | 18 | |||
138266 | 176511 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 127 Brookdale Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 6006104.31545 | 2087436.52069 | 37.7120487615086 | -122.420725854912 | (37.7120487615086, -122.420725854912) | 9 | 7 | 8 | 309 | 39 | |||
62095 | 176509 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 127 Brookdale Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6006088.90588 | 2087444.93251 | 37.7120709900614 | -122.420779711712 | (37.7120709900614, -122.420779711712) | 9 | 7 | 8 | 309 | 39 | |||
144609 | 176499 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 162 Brookdale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 6005745.58119 | 2087451.77686 | 37.7120704261874 | -122.421966828522 | (37.7120704261874, -122.421966828522) | 9 | 7 | 8 | 309 | 18 | |||
145603 | 176510 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2 Brookdale Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6006143.81597 | 2087479.56194 | 37.7121691699409 | -122.420592382928 | (37.7121691699409, -122.420592382928) | 9 | 7 | 8 | 309 | 39 | |||
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 | |||
105310 | 176497 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2 Brookdale Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6005989.52225 | 2087517.96508 | 37.7122659199214 | -122.421128393261 | (37.7122659199214, -122.421128393261) | 9 | 7 | 8 | 309 | 39 | |||
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 | ||
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 | ||
35598 | 102652 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 203X Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5994989.5 | 2088377.3 | 37.7139992025898 | -122.459209674514 | (37.7139992025898, -122.459209674514) | 9 | 8 | 6 | 28861 | 24 | |||||
109140 | 102653 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 203X Farallones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994989.5 | 2088377.3 | 37.7139992025898 | -122.459209674514 | (37.7139992025898, -122.459209674514) | 9 | 8 | 6 | 28861 | 24 | ||||
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 | ||
17037 | 264800 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 330 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011202 | 2089015 | 37.7166689455126 | -122.403217660421 | (37.7166689455126, -122.403217660421) | 10 | 7 | 8 | 309 | 39 | ||||
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 | ||
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 | |||
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 | ||
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 | |
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 | |
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 | |
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 | |
116552 | 65468 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 55 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/08/1989 12:00:00 AM | Permit Number 28348 | 5995598.18541989 | 2090265.07086982 | 37.7192175521634 | -122.457242320925 | (37.7192175521634, -122.457242320925) | 9 | 8 | 6 | 28861 | 24 | ||
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 | |
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 | |
123075 | 219012 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 139 Miramar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5995316.47386 | 2090822.54609 | 37.7207320630034 | -122.458256412004 | (37.7207320630034, -122.458256412004) | 9 | 8 | 6 | 28861 | 24 | |||
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 | |||
166847 | 219013 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 154 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5995360.70731 | 2090920.75617 | 37.721004266213 | -122.458110615707 | (37.721004266213, -122.458110615707) | 9 | 8 | 6 | 28861 | 24 | |||
161331 | 219010 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 157 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995318.05663 | 2090927.82531 | 37.7210212256375 | -122.458258556898 | (37.7210212256375, -122.458258556898) | 9 | 8 | 6 | 28861 | 24 | |||
110586 | 219014 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 154 Miramar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995361.04968 | 2090937.11704 | 37.721049208941 | -122.45811061572 | (37.721049208941, -122.45811061572) | 9 | 8 | 6 | 28861 | 24 | |||
35443 | 73660 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 157 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/14/2013 12:00:00 AM | 15 | Permit Number 770522 | 5995314.7940966 | 2090940.29616255 | 37.7210552801536 | -122.458270736601 | (37.7210552801536, -122.458270736601) | 9 | 8 | 6 | 28861 | 24 | ||
76115 | 71877 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 157 Miramar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/14/2013 12:00:00 AM | 10 | Permit Number 770522 | 5995314.7940966 | 2090940.29616255 | 37.7210552801536 | -122.458270736601 | (37.7210552801536, -122.458270736601) | 9 | 8 | 6 | 28861 | 24 | ||
114891 | 219009 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 161 Miramar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5995318.79946 | 2090948.50153 | 37.7210780403007 | -122.458257484914 | (37.7210780403007, -122.458257484914) | 9 | 8 | 6 | 28861 | 24 | |||
94709 | 219008 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 171 Miramar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 1ft | Permit Number 781866 | 5995303 | 2091035 | 37.7213146365991 | -122.45831835627 | (37.7213146365991, -122.45831835627) | 9 | 8 | 6 | 28861 | 24 | ||
138084 | 219015 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 178 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5995362.975 | 2091073.58019 | 37.7214240148917 | -122.458113831693 | (37.7214240148917, -122.458113831693) | 9 | 8 | 6 | 28861 | 24 | |||
6809 | 65477 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 400 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/12/1989 12:00:00 AM | Permit Number 28358 | 5994782.15079154 | 2091255.17859292 | 37.7218892499679 | -122.460134715976 | (37.7218892499679, -122.460134715976) | 9 | 8 | 4 | 28861 | 24 | ||
76881 | 219007 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 207 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5995325.39637 | 2091321.08064 | 37.7221014328296 | -122.458261634395 | (37.7221014328296, -122.458261634395) | 9 | 8 | 4 | 28861 | 24 | |||
9850 | 30919 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 212 Granada Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/1995 12:00:00 AM | Permit Number 34735 | 5995669.33198455 | 2091339.19890433 | 37.722170938941 | -122.457074050715 | (37.722170938941, -122.457074050715) | 9 | 8 | 4 | 28861 | 24 | |||
179902 | 30918 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 212 Granada Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/1995 12:00:00 AM | Permit Number 34735 | 5995669.33198455 | 2091339.19890433 | 37.722170938941 | -122.457074050715 | (37.722170938941, -122.457074050715) | 9 | 8 | 4 | 28861 | 24 | |||
165638 | 219006 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 221 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5995326.92312 | 2091423.08508 | 37.7223816004164 | -122.458263736089 | (37.7223816004164, -122.458263736089) | 9 | 8 | 4 | 28861 | 24 | |||
142128 | 109686 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 190 Onondaga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772797 | 6000260.82873 | 2091434.8524 | 37.7226961949641 | -122.441209260793 | (37.7226961949641, -122.441209260793) | 9 | 7 | 6 | 28861 | 25 |
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 | |||
117463 | 95134 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 450@ Wayland Somerset St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781342 | 6010117.36612 | 2092259.39432 | 37.7255167458877 | -122.407195288535 | (37.7255167458877, -122.407195288535) | 10 | 3 | 7 | 309 | 28 |
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 | ||
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 | ||
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 | |
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 | |
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 | |||
189015 | 192421 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 53 Pomona St | 1 | : | Tree | Private 2 | 2 | Width 5ft | 6014148.28892 | 2094395.14028 | 37.7316058387373 | -122.393410025148 | (37.7316058387373, -122.393410025148) | 10 | 3 | 8 | 58 | 1 | |||
136527 | 108571 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 223 Sweeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772573 | 6009406.56 | 2094751.33642 | 37.7323192844032 | -122.409828317318 | (37.7323192844032, -122.409828317318) | 10 | 3 | 7 | 309 | 28 |
164054 | 67684 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 312 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1992 12:00:00 AM | 3.5x6 | Permit Number 31288 | 6000001.77226965 | 2094984.07917219 | 37.7324267912213 | -122.442359437007 | (37.7324267912213, -122.442359437007) | 9 | 7 | 4 | 63 | 40 | ||
69462 | 67933 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 114 Rousseau St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31646 | 6003490.5816971 | 2095075.42432118 | 37.7328758373096 | -122.43030432183 | (37.7328758373096, -122.43030432183) | 9 | 7 | 5 | 28861 | 25 | ||
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 | |||
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 | |||
44918 | 67927 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 123 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31640 | 6003789.22877148 | 2095116.32621568 | 37.7330050563948 | -122.429274738173 | (37.7330050563948, -122.429274738173) | 9 | 7 | 5 | 28861 | 25 | ||
61119 | 225949 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 119 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6003777.8476 | 2095128.93714 | 37.7330390388203 | -122.429314984812 | (37.7330390388203, -122.429314984812) | 9 | 7 | 5 | 28861 | 25 | |||
71850 | 47716 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 47 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2002 12:00:00 AM | Permit Number 45512 | 6003756.95954941 | 2095440.56895285 | 37.7338935267661 | -122.429409415665 | (37.7338935267661, -122.429409415665) | 2 | 7 | 5 | 28861 | 25 | ||
52646 | 59406 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 31 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 770712 | 6003751.60013387 | 2095492.67978387 | 37.7340363078834 | -122.42943165971 | (37.7340363078834, -122.42943165971) | 2 | 7 | 5 | 28861 | 25 | ||
132169 | 65670 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 954 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/1990 12:00:00 AM | Permit Number 28590 | 5998557.99448518 | 2095716.03586207 | 37.7343541747365 | -122.447403560759 | (37.7343541747365, -122.447403560759) | 9 | 7 | 4 | 59 | 40 | ||
128927 | 225953 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 245 Roanoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003670.68661 | 2095891.30011 | 37.7351262474841 | -122.429739824559 | (37.7351262474841, -122.429739824559) | 2 | 7 | 5 | 63 | 7 | |||
154480 | 225954 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 245 Roanoke St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003654.86904 | 2095911.56632 | 37.7351809981922 | -122.429795956641 | (37.7351809981922, -122.429795956641) | 2 | 7 | 5 | 63 | 7 | |||
171972 | 115822 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 122 COLLEGE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6004593 | 2095924 | 37.7352682180932 | -122.426553380791 | (37.7352682180932, -122.426553380791) | 2 | 7 | 5 | 28861 | 2 |
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) );