trees
508 rows where qSpecies_id = 25 sorted by XCoord
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 | |||||||||||||
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 | ||||
31262 | 69447 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 479 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/16/1994 12:00:00 AM | Permit Number 33557 | 5985917.32246977 | 2112668.61009419 | 37.7801708274431 | -122.492353790965 | (37.7801708274431, -122.492353790965) | 11 | 6 | 2 | 55 | 26 | ||
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 | ||
29569 | 105213 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 2400X 21ST AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 5989837 | 2098691 | 37.7420204448441 | -122.477771936587 | (37.7420204448441, -122.477771936587) | 1 | 8 | 3 | 29491 | 35 | |||
161550 | 105214 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 2400X 21ST AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 5989837 | 2098691 | 37.7420204448441 | -122.477771936587 | (37.7420204448441, -122.477771936587) | 1 | 8 | 3 | 29491 | 35 | |||
178381 | 254173 | Significant Tree 6 | Geijera parviflora :: Australian Willow 25 | 1850 19th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 3x6 | 5990394 | 2102783 | 37.7532883185876 | -122.476144836826 | (37.7532883185876, -122.476144836826) | 1 | 8 | 4 | 56 | 12 | ||||
37585 | 105310 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 355 17TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3 x4 | 5990544.7 | 2113008.3 | 37.781372965217 | -122.476370566984 | (37.781372965217, -122.476370566984) | 11 | 6 | 2 | 55 | 26 | |||
63451 | 105311 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 455 17TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x3 | 5990571.2 | 2112282.7 | 37.7793822053088 | -122.476225875432 | (37.7793822053088, -122.476225875432) | 11 | 6 | 2 | 55 | 26 | |||
130161 | 122086 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 459 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5990589.94258 | 2112248.552 | 37.7792895311955 | -122.476158542806 | (37.7792895311955, -122.476158542806) | 11 | 6 | 2 | 55 | 26 | |||
165027 | 81695 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 539 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52514 | 5990609.14307 | 2111709.86868 | 37.7778115687685 | -122.476052767078 | (37.7778115687685, -122.476052767078) | 11 | 6 | 2 | 55 | 26 | |
52069 | 60140 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1807 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1982 12:00:00 AM | Permit Number 19670 | 5991211.56683637 | 2103102.96288703 | 37.7542142276367 | -122.473340885597 | (37.7542142276367, -122.473340885597) | 1 | 8 | 4 | 56 | 12 | ||
164529 | 60139 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1825 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1982 12:00:00 AM | Permit Number 19669 | 5991215.5539121 | 2102985.82371421 | 37.7538928250767 | -122.473318554461 | (37.7538928250767, -122.473318554461) | 1 | 8 | 4 | 56 | 12 | ||
180292 | 217005 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 532 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2018 12:00:00 AM | 3 | 3x12 | Permit Number 782164 | 5991273.49549 | 2097061.96197 | 37.737630785637 | -122.472686293253 | (37.737630785637, -122.472686293253) | 1 | 8 | 4 | 29491 | 40 | |
151826 | 255813 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 532 Wawona St | 1 | Front Yard : Yard | Tree | Private 2 | 07/24/2018 12:00:00 AM | 3 | 3X3 | Permit Number 782164 | 5991340.67425 | 2097062.85197 | 37.7376371178542 | -122.472454091358 | (37.7376371178542, -122.472454091358) | 1 | 8 | 4 | 29491 | 40 | |
149342 | 35091 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 920 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 15 | 3x3 | Permit Number 42238 | 5992055.93239281 | 2105259.4330846 | 37.7601841866451 | -122.470577939927 | (37.7601841866451, -122.470577939927) | 1 | 8 | 4 | 56 | 12 |
163091 | 35092 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 920 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1998 12:00:00 AM | 25 | 3x3 | Permit Number 38633 | 5992055.93239281 | 2105259.4330846 | 37.7601841866451 | -122.470577939927 | (37.7601841866451, -122.470577939927) | 1 | 8 | 4 | 56 | 12 | |
8908 | 69088 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1474 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33098 | 5992145.68632685 | 2105413.48754834 | 37.7606123691548 | -122.470278745237 | (37.7606123691548, -122.470278745237) | 1 | 8 | 4 | 56 | 12 | ||
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 |
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 | |||
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 | ||
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 | |
183813 | 219000 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1775 11th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 29 | Width 3ft | 5992776.7043 | 2103406.16926 | 37.7551372592989 | -122.467950350926 | (37.7551372592989, -122.467950350926) | 1 | 8 | 4 | 56 | 12 | |||
88273 | 219005 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1838 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5992852.04405 | 2102933.06242 | 37.7538425808737 | -122.467655401194 | (37.7538425808737, -122.467655401194) | 1 | 8 | 4 | 56 | 12 | |||
22131 | 49877 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1331@ IRVING 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2003 12:00:00 AM | Permit Number 46643 | 5992989.81423972 | 2106408.90402865 | 37.7633942890183 | -122.467431700246 | (37.7633942890183, -122.467431700246) | 1 | 8 | 11 | 56 | 12 | |||
135416 | 219002 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1333 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5992990.51198 | 2106402.84909 | 37.7633777040321 | -122.467428846685 | (37.7633777040321, -122.467428846685) | 1 | 8 | 11 | 56 | 12 | |||
45794 | 108472 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 462 09th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 773779 | 5993142.3505 | 2112335.01081 | 37.7796746015568 | -122.467335065866 | (37.7796746015568, -122.467335065866) | 11 | 6 | 2 | 54 | 11 | |||
179219 | 123212 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 462 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5993143.5323 | 2112325.5219 | 37.7796486158053 | -122.467330287378 | (37.7796486158053, -122.467330287378) | 11 | 6 | 2 | 54 | 11 | |||
82591 | 219004 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1655 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 5993378.4627 | 2104217.9895 | 37.7574010390349 | -122.46592829725 | (37.7574010390349, -122.46592829725) | 1 | 8 | 4 | 56 | 12 | |||
180610 | 219003 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1461 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5993948.08517 | 2105555.37526 | 37.7611059976579 | -122.464055414128 | (37.7611059976579, -122.464055414128) | 1 | 5 | 11 | 56 | 12 | |||
129612 | 46907 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1461 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/2002 12:00:00 AM | Permit Number 44964 | 5993949.00931755 | 2105566.46922701 | 37.7611365120681 | -122.464053023285 | (37.7611365120681, -122.464053023285) | 1 | 5 | 11 | 56 | 12 | ||
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 | |||
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 | ||||
57319 | 65448 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 72 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/1989 12:00:00 AM | 9 | Permit Number 28322 | 5994279.76671 | 2115099.74179 | 37.7873314010144 | -122.463600988074 | (37.7873314010144, -122.463600988074) | 11 | 6 | 1 | 54 | 11 | ||
15108 | 113387 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 185 CASTENADA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5994493 | 2100782 | 37.7480309194949 | -122.461824674651 | (37.7480309194949, -122.461824674651) | 1 | 8 | 4 | 29491 | 40 | ||||
55201 | 113388 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 185 CASTENADA AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5994493 | 2100782 | 37.7480309194949 | -122.461824674651 | (37.7480309194949, -122.461824674651) | 1 | 8 | 4 | 29491 | 40 | ||||
89613 | 113389 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 185 CASTENADA AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5994493 | 2100782 | 37.7480309194949 | -122.461824674651 | (37.7480309194949, -122.461824674651) | 1 | 8 | 4 | 29491 | 40 | ||||
68866 | 219001 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1225 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5994518.05416 | 2107169.56941 | 37.7655709877426 | -122.462201222508 | (37.7655709877426, -122.462201222508) | 11 | 5 | 11 | 56 | 12 | |||
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 | ||
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 | ||
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 | ||||
126710 | 46930 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1 Pacheco St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.7435241958304 | -122.459369067857 | (37.7435241958304, -122.459369067857) | 1 | 8 | 4 | 59 | 40 | |
159651 | 46927 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1 Pacheco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.7435241958304 | -122.459369067857 | (37.7435241958304, -122.459369067857) | 1 | 8 | 4 | 59 | 40 | |
162728 | 46929 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1 Pacheco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.7435241958304 | -122.459369067857 | (37.7435241958304, -122.459369067857) | 1 | 8 | 4 | 59 | 40 | |
177469 | 46928 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1 Pacheco St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.7435241958304 | -122.459369067857 | (37.7435241958304, -122.459369067857) | 1 | 8 | 4 | 59 | 40 | ||
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 | ||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
189829 | 141447 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 196 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5996894.8261 | 2111600.0306 | 37.7778724506652 | -122.454300593509 | (37.7778724506652, -122.454300593509) | 15 | 6 | 2 | 54 | 16 | |||
28535 | 41155 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 21 Cook St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/1999 12:00:00 AM | Permit Number 41884 | 5997452.09163541 | 2113544.02640038 | 37.7832420947214 | -122.452513152989 | (37.7832420947214, -122.452513152989) | 15 | 6 | 1 | 54 | 31 | |||
67850 | 140156 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2155 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5997581.2766 | 2109865.28 | 37.7731486172497 | -122.451800756951 | (37.7731486172497, -122.451800756951) | 15 | 5 | 11 | 29492 | 16 | |||
102399 | 62468 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 400 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2011 12:00:00 AM | Permit Number 767707 | 5997942.58905548 | 2109236.69156954 | 37.7714433619175 | -122.450505611482 | (37.7714433619175, -122.450505611482) | 15 | 5 | 11 | 29492 | 9 | |||
136233 | 244047 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 400 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5997955.5586 | 2109119.1735 | 37.7711214297529 | -122.450452276113 | (37.7711214297529, -122.450452276113) | 15 | 5 | 11 | 29492 | 9 | |||
173191 | 225928 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1106 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5998173.76607 | 2106499.88804 | 37.7639420241322 | -122.449508728942 | (37.7639420241322, -122.449508728942) | 15 | 5 | 11 | 29492 | 9 | |||
25511 | 94960 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 20 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998206 | 2108519 | 37.7694878371786 | -122.449542741076 | (37.7694878371786, -122.449542741076) | 15 | 5 | 11 | 29492 | 9 | ||||
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 | |||
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 | ||
118274 | 85304 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 417 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2007 12:00:00 AM | Permit Number 49590 | 5998857 | 2109314 | 37.7717079252645 | -122.447348195836 | (37.7717079252645, -122.447348195836) | 15 | 5 | 11 | 29492 | 9 | |||
4752 | 107181 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 1520 PAGE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6x9 | 5999172.7 | 2109108.7 | 37.7711622584795 | -122.446241403234 | (37.7711622584795, -122.446241403234) | 15 | 5 | 11 | 29492 | 9 | |||
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 | |||
25095 | 244549 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 1500 Page St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5999267.0062 | 2109103.195 | 37.7711525285338 | -122.445914799778 | (37.7711525285338, -122.445914799778) | 15 | 5 | 11 | 29492 | 9 | |||
111282 | 244548 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1500 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5999285.3779 | 2109104.904 | 37.7711582700312 | -122.445851374555 | (37.7711582700312, -122.445851374555) | 15 | 5 | 11 | 29492 | 9 | |||
145759 | 59939 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1778 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1981 12:00:00 AM | 1 | Permit Number 19412 | 5999341.88585809 | 2110158.12282899 | 37.7740533674999 | -122.445731667127 | (37.7740533674999, -122.445731667127) | 15 | 5 | 11 | 29492 | 16 | |
131118 | 59938 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1774 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1981 12:00:00 AM | Permit Number 19411 | 5999360.65261909 | 2110160.72458075 | 37.7740615827199 | -122.445666937047 | (37.7740615827199, -122.445666937047) | 15 | 5 | 11 | 29492 | 16 | ||
98749 | 59936 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1757 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1981 12:00:00 AM | 14 | Permit Number 19409 | 5999437.2024 | 2110127.1563 | 37.7739737829513 | -122.44539972496 | (37.7739737829513, -122.44539972496) | 15 | 5 | 11 | 29492 | 16 | |
187975 | 59935 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1743 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1981 12:00:00 AM | 12 | Permit Number 19408 | 5999522.2814 | 2110138.642 | 37.7740101761611 | -122.445106249319 | (37.7740101761611, -122.445106249319) | 15 | 5 | 11 | 29492 | 16 | |
177554 | 59937 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1738 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2015 12:00:00 AM | Permit Number 19410 | 5999529.55338039 | 2110184.14033447 | 37.7741355180618 | -122.445084365992 | (37.7741355180618, -122.445084365992) | 15 | 5 | 11 | 29492 | 16 | ||
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 | |
186208 | 59942 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 625 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1981 12:00:00 AM | 13 | Permit Number 19416 | 5999638.7469 | 2110673.4971 | 37.7754853988158 | -122.444741829234 | (37.7754853988158, -122.444741829234) | 15 | 5 | 11 | 29492 | 16 | |
99856 | 48556 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 615 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/2002 12:00:00 AM | 3 | Permit Number 45872 | 5999645.29400405 | 2110579.50430317 | 37.7752276921804 | -122.444712423834 | (37.7752276921804, -122.444712423834) | 15 | 5 | 11 | 29492 | 16 | |
119488 | 59933 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 549 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1981 12:00:00 AM | 9 | Permit Number 19406 | 5999664.8686 | 2110448.6759 | 37.7748695877317 | -122.444635305779 | (37.7748695877317, -122.444635305779) | 15 | 5 | 11 | 29492 | 16 | |
87972 | 112871 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 549 Central Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 5999666.6578 | 2110431.976 | 37.7748238361568 | -122.444627916028 | (37.7748238361568, -122.444627916028) | 15 | 5 | 11 | 29492 | 16 |
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) );