Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 509 | 509 | 38234 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 0 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1998 12:00:00 AM | Permit Number 40352 | ||||||||
| 2992 | 2992 | 43017 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42880 | |||||||||
| 3545 | 3545 | 43015 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42880 | |||||||||
| 3668 | 3668 | 43018 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42880 | |||||||||
| 4435 | 4435 | 34068 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 955 Kennedy Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37965 | ||||||||
| 5326 | 5326 | 38231 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 0 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1998 12:00:00 AM | Permit Number 40352 | ||||||||
| 5586 | 5586 | 43016 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42880 | |||||||||
| 6607 | 6607 | 34069 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 955 Kennedy Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37965 | ||||||||
| 7043 | 7043 | 34072 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 955 Kennedy Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37965 | ||||||||
| 7991 | 7991 | 38232 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 0 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1998 12:00:00 AM | Permit Number 40352 | ||||||||
| 9590 | 9590 | 34067 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 955 Kennedy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37965 | ||||||||
| 10500 | 10500 | 34071 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 955 Kennedy Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37965 | ||||||||
| 10511 | 10511 | 38233 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 0 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1998 12:00:00 AM | Permit Number 40352 | ||||||||
| 12244 | 12244 | 45154 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1683 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/2001 12:00:00 AM | Permit Number 44007 | ||||||||
| 12798 | 12798 | 34070 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 955 Kennedy Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37965 | ||||||||
| 81301 | 81301 | 21413 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 2692X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | ||||
| 125703 | 125703 | 69447 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 479 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | Permit Number 33557 | 5985917.32246977 | 2112668.61009419 | 37.7801708274431 | -122.492353790965 | (37.7801708274431, -122.492353790965) | ||
| 121526 | 121526 | 105214 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2400X 21ST AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 5989837.0 | 2098691.0 | 37.7420204448441 | -122.477771936587 | (37.7420204448441, -122.477771936587) | |||
| 128944 | 128944 | 105213 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2400X 21ST AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 5989837.0 | 2098691.0 | 37.7420204448441 | -122.477771936587 | (37.7420204448441, -122.477771936587) | |||
| 124791 | 124791 | 105310 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 355 17TH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3 x4 | 5990544.7 | 2113008.3 | 37.781372965217 | -122.476370566984 | (37.781372965217, -122.476370566984) | |||
| 89572 | 89572 | 105311 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 455 17TH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x3 | 5990571.2 | 2112282.7 | 37.77938220530879 | -122.476225875432 | (37.7793822053088, -122.476225875432) | |||
| 169492 | 169492 | 122086 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 459 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5990589.9425800005 | 2112248.5519999997 | 37.7792895311955 | -122.47615854280599 | (37.7792895311955, -122.476158542806) | |||
| 186145 | 186145 | 81695 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 539 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52514 | 5990609.143069999 | 2111709.86868 | 37.7778115687685 | -122.476052767078 | (37.7778115687685, -122.476052767078) | |
| 83663 | 83663 | 60140 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1807 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1982 12:00:00 AM | Permit Number 19670 | 5991211.56683637 | 2103102.96288703 | 37.7542142276367 | -122.473340885597 | (37.7542142276367, -122.473340885597) | ||
| 117714 | 117714 | 60139 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1825 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1982 12:00:00 AM | Permit Number 19669 | 5991215.553912099 | 2102985.82371421 | 37.753892825076704 | -122.473318554461 | (37.7538928250767, -122.473318554461) | ||
| 113742 | 113742 | 35091 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 920 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 15 | 3x3 | Permit Number 42238 | 5992055.93239281 | 2105259.4330846 | 37.760184186645105 | -122.47057793992701 | (37.7601841866451, -122.470577939927) |
| 122436 | 122436 | 35092 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 920 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1998 12:00:00 AM | 25 | 3x3 | Permit Number 38633 | 5992055.93239281 | 2105259.4330846 | 37.760184186645105 | -122.47057793992701 | (37.7601841866451, -122.470577939927) | |
| 66025 | 66025 | 69088 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1474 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | Permit Number 33098 | 5992145.68632685 | 2105413.48754834 | 37.7606123691548 | -122.47027874523701 | (37.7606123691548, -122.470278745237) | ||
| 116480 | 116480 | 94704 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 670 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53844 | 5992265.910069999 | 2110887.9473900003 | 37.7756507238334 | -122.470261618584 | (37.7756507238334, -122.470261618584) |
| 185667 | 185667 | 70154 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 339 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1993 12:00:00 AM | 9 | 5992446.53753 | 2113177.4125 | 37.7819474134806 | -122.469803511026 | (37.7819474134806, -122.469803511026) | ||
| 163455 | 163455 | 82278 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 245 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50610 | 5992733.47806 | 2113805.1753 | 37.783687659814795 | -122.46885653402398 | (37.7836876598148, -122.468856534024) | |
| 153095 | 153095 | 219000 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1775 11th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | Width 3ft | 5992776.7043 | 2103406.16926 | 37.7551372592989 | -122.467950350926 | (37.7551372592989, -122.467950350926) | |||
| 31692 | 31692 | 219005 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1838 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5992852.04405 | 2102933.06242 | 37.7538425808737 | -122.467655401194 | (37.7538425808737, -122.467655401194) | |||
| 126970 | 126970 | 49877 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1331@ IRVING 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2003 12:00:00 AM | Permit Number 46643 | 5992989.81423972 | 2106408.90402865 | 37.763394289018294 | -122.467431700246 | (37.7633942890183, -122.467431700246) | |||
| 181764 | 181764 | 219002 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1333 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5992990.51198 | 2106402.84909 | 37.7633777040321 | -122.46742884668501 | (37.7633777040321, -122.467428846685) | |||
| 83486 | 83486 | 108472 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 462 09th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 773779 | 5993142.3505 | 2112335.01081 | 37.7796746015568 | -122.467335065866 | (37.7796746015568, -122.467335065866) | |||
| 43658 | 43658 | 123212 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 462 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5993143.5323 | 2112325.5219 | 37.7796486158053 | -122.467330287378 | (37.7796486158053, -122.467330287378) | |||
| 26692 | 26692 | 219004 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1655 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 5993378.4627 | 2104217.9895 | 37.7574010390349 | -122.46592829725 | (37.7574010390349, -122.46592829725) | |||
| 35910 | 35910 | 219003 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1461 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5993948.08517 | 2105555.3752599997 | 37.7611059976579 | -122.464055414128 | (37.7611059976579, -122.464055414128) | |||
| 109039 | 109039 | 46907 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1461 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/2002 12:00:00 AM | Permit Number 44964 | 5993949.00931755 | 2105566.46922701 | 37.7611365120681 | -122.464053023285 | (37.7611365120681, -122.464053023285) | ||
| 36158 | 36158 | 65448 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 72 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/1989 12:00:00 AM | 9 | Permit Number 28322 | 5994279.76671 | 2115099.7417900003 | 37.7873314010144 | -122.46360098807399 | (37.7873314010144, -122.463600988074) | ||
| 28449 | 28449 | 113387 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 185 CASTENADA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 5994493.0 | 2100782.0 | 37.7480309194949 | -122.461824674651 | (37.7480309194949, -122.461824674651) | ||||
| 83902 | 83902 | 113388 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 185 CASTENADA AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 5994493.0 | 2100782.0 | 37.7480309194949 | -122.461824674651 | (37.7480309194949, -122.461824674651) | ||||
| 95528 | 95528 | 113389 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 185 CASTENADA AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 5994493.0 | 2100782.0 | 37.7480309194949 | -122.461824674651 | (37.7480309194949, -122.461824674651) | ||||
| 72606 | 72606 | 219001 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1225 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5994518.05416 | 2107169.56941 | 37.7655709877426 | -122.46220122250799 | (37.7655709877426, -122.462201222508) | |||
| 19692 | 19692 | 65477 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 400 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/12/1989 12:00:00 AM | Permit Number 28358 | 5994782.15079154 | 2091255.17859292 | 37.7218892499679 | -122.46013471597601 | (37.7218892499679, -122.460134715976) | ||
| 78037 | 78037 | 102652 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 203X Farallones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5994989.5 | 2088377.3 | 37.7139992025898 | -122.45920967451401 | (37.7139992025898, -122.459209674514) | |||||
| 97628 | 97628 | 102653 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 203X Farallones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994989.5 | 2088377.3 | 37.7139992025898 | -122.45920967451401 | (37.7139992025898, -122.459209674514) | ||||
| 9818 | 9818 | 46930 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1 Pacheco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.743524195830396 | -122.459369067857 | (37.7435241958304, -122.459369067857) | |
| 9820 | 9820 | 46927 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.743524195830396 | -122.459369067857 | (37.7435241958304, -122.459369067857) | |
| 9821 | 9821 | 46929 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1 Pacheco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.743524195830396 | -122.459369067857 | (37.7435241958304, -122.459369067857) | |
| 9825 | 9825 | 46928 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1 Pacheco St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.743524195830396 | -122.459369067857 | (37.7435241958304, -122.459369067857) | ||
| 77679 | 77679 | 73660 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 157 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/2013 12:00:00 AM | 15 | Permit Number 770522 | 5995314.794096599 | 2090940.29616255 | 37.72105528015361 | -122.45827073660101 | (37.7210552801536, -122.458270736601) | ||
| 87659 | 87659 | 71877 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 157 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/2013 12:00:00 AM | 10 | Permit Number 770522 | 5995314.794096599 | 2090940.29616255 | 37.72105528015361 | -122.45827073660101 | (37.7210552801536, -122.458270736601) | ||
| 39091 | 39091 | 219012 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 139 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5995316.47386 | 2090822.54609 | 37.720732063003396 | -122.45825641200399 | (37.7207320630034, -122.458256412004) | |||
| 131583 | 131583 | 219011 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 157 Miramar Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995317.533340001 | 2090902.82075 | 37.7209525389978 | -122.458258556883 | (37.7209525389978, -122.458258556883) | |||
| 30003 | 30003 | 219010 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 157 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995318.0566300005 | 2090927.8253099998 | 37.7210212256375 | -122.458258556898 | (37.7210212256375, -122.458258556898) | |||
| 49449 | 49449 | 219009 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 161 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5995318.799459999 | 2090948.50153 | 37.7210780403007 | -122.458257484914 | (37.7210780403007, -122.458257484914) | |||
| 136896 | 136896 | 219008 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 171 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 1ft | 5995319.46522 | 2091024.7689 | 37.7212874905944 | -122.458260700882 | (37.7212874905944, -122.458260700882) | |||
| 47738 | 47738 | 219007 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 207 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5995325.396369999 | 2091321.08064 | 37.7221014328296 | -122.45826163439501 | (37.7221014328296, -122.458261634395) | |||
| 185820 | 185820 | 219006 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 221 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5995326.9231199995 | 2091423.0850799999 | 37.7223816004164 | -122.458263736089 | (37.7223816004164, -122.458263736089) | |||
| 43253 | 43253 | 219013 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 154 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5995360.7073099995 | 2090920.7561700002 | 37.721004266213 | -122.458110615707 | (37.721004266213, -122.458110615707) | |||
| 74298 | 74298 | 219014 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 154 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995361.04968 | 2090937.1170400002 | 37.721049208941004 | -122.45811061571999 | (37.721049208941, -122.45811061572) | |||
| 172811 | 172811 | 219015 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 178 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5995362.975 | 2091073.5801900001 | 37.7214240148917 | -122.458113831693 | (37.7214240148917, -122.458113831693) | |||
| 106266 | 106266 | 65468 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 55 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1989 12:00:00 AM | Permit Number 28348 | 5995598.18541989 | 2090265.07086982 | 37.7192175521634 | -122.457242320925 | (37.7192175521634, -122.457242320925) | ||
| 50153 | 50153 | 30919 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 212 Granada Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | Permit Number 34735 | 5995669.33198455 | 2091339.19890433 | 37.722170938941005 | -122.45707405071501 | (37.722170938941, -122.457074050715) | |||
| 139408 | 139408 | 30918 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 212 Granada Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | Permit Number 34735 | 5995669.33198455 | 2091339.19890433 | 37.722170938941005 | -122.45707405071501 | (37.722170938941, -122.457074050715) | |||
| 186176 | 186176 | 141447 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 196 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5996894.8261 | 2111600.0306 | 37.7778724506652 | -122.454300593509 | (37.7778724506652, -122.454300593509) | |||
| 128826 | 128826 | 41155 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 21 Cook St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/1999 12:00:00 AM | Permit Number 41884 | 5997452.09163541 | 2113544.02640038 | 37.7832420947214 | -122.452513152989 | (37.7832420947214, -122.452513152989) | |||
| 167039 | 167039 | 140156 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2155 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997581.2766 | 2109865.28 | 37.7731486172497 | -122.451800756951 | (37.7731486172497, -122.451800756951) | |||
| 103290 | 103290 | 62468 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 400 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2011 12:00:00 AM | Permit Number 767707 | 5997942.58905548 | 2109236.69156954 | 37.7714433619175 | -122.45050561148199 | (37.7714433619175, -122.450505611482) | |||
| 4219 | 4219 | 244047 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 400 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5997955.5586 | 2109119.1735 | 37.771121429752895 | -122.450452276113 | (37.7711214297529, -122.450452276113) | |||
| 131682 | 131682 | 225928 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1106 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5998173.76607 | 2106499.88804 | 37.763942024132206 | -122.44950872894199 | (37.7639420241322, -122.449508728942) | |||
| 129311 | 129311 | 94960 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 20 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998206.0 | 2108519.0 | 37.7694878371786 | -122.44954274107599 | (37.7694878371786, -122.449542741076) | ||||
| 56399 | 56399 | 219016 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 23 Gaviota Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5998493.11217 | 2097521.42795 | 37.7393076426268 | -122.447757806504 | (37.7393076426268, -122.447757806504) | |||
| 107237 | 107237 | 65670 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 954 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1990 12:00:00 AM | Permit Number 28590 | 5998557.99448518 | 2095716.03586207 | 37.7343541747365 | -122.44740356075899 | (37.7343541747365, -122.447403560759) | ||
| 109428 | 109428 | 85304 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 417 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2007 12:00:00 AM | Permit Number 49590 | 5998857.0 | 2109314.0 | 37.7717079252645 | -122.44734819583599 | (37.7717079252645, -122.447348195836) | |||
| 71189 | 71189 | 107181 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1520 PAGE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 6x9 | 5999172.7 | 2109108.7 | 37.7711622584795 | -122.44624140323401 | (37.7711622584795, -122.446241403234) | |||
| 184487 | 184487 | 247270 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1520 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5999196.9373 | 2109093.7955 | 37.7711227186713 | -122.446156493551 | (37.7711227186713, -122.446156493551) | |||
| 38420 | 38420 | 244549 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1500 Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5999267.0062 | 2109103.195 | 37.7711525285338 | -122.44591479977801 | (37.7711525285338, -122.445914799778) | |||
| 9953 | 9953 | 107188 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1500 PAGE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/15/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773122 | 5999274.2 | 2109122.8 | 37.771206769657205 | -122.445891326497 | (37.7712067696572, -122.445891326497) | |
| 175010 | 175010 | 244548 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1500 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5999285.3779 | 2109104.904 | 37.7711582700312 | -122.44585137455499 | (37.7711582700312, -122.445851374555) | |||
| 129531 | 129531 | 59939 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1778 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1981 12:00:00 AM | 1 | Permit Number 19412 | 5999341.88585809 | 2110158.12282899 | 37.7740533674999 | -122.44573166712699 | (37.7740533674999, -122.445731667127) | |
| 106631 | 106631 | 59938 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1774 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1981 12:00:00 AM | Permit Number 19411 | 5999360.65261909 | 2110160.72458075 | 37.774061582719895 | -122.44566693704701 | (37.7740615827199, -122.445666937047) | ||
| 178195 | 178195 | 59936 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1757 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1981 12:00:00 AM | 14 | Permit Number 19409 | 5999437.2024 | 2110127.1563 | 37.773973782951295 | -122.44539972496 | (37.7739737829513, -122.44539972496) | |
| 56106 | 56106 | 59935 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1743 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1981 12:00:00 AM | 12 | Permit Number 19408 | 5999522.2814 | 2110138.642 | 37.774010176161106 | -122.445106249319 | (37.7740101761611, -122.445106249319) | |
| 141249 | 141249 | 59937 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1738 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2015 12:00:00 AM | Permit Number 19410 | 5999529.55338039 | 2110184.14033447 | 37.7741355180618 | -122.44508436599199 | (37.7741355180618, -122.445084365992) | ||
| 65348 | 65348 | 142345 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1736 HAYES ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 0ft | 5999542.2107 | 2110186.9275 | 37.7741438933316 | -122.445040782661 | (37.7741438933316, -122.445040782661) | |||
| 46231 | 46231 | 59941 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1706 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1981 12:00:00 AM | 0 | Permit Number 19415 | 5999632.27517388 | 2110547.02087839 | 37.7751377580465 | -122.444755123369 | (37.7751377580465, -122.444755123369) | |
| 133410 | 133410 | 59942 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 625 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1981 12:00:00 AM | 13 | Permit Number 19416 | 5999638.7469 | 2110673.4971 | 37.775485398815796 | -122.444741829234 | (37.7754853988158, -122.444741829234) | |
| 28224 | 28224 | 48556 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 615 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/23/2002 12:00:00 AM | 3 | Permit Number 45872 | 5999645.29400405 | 2110579.50430317 | 37.7752276921804 | -122.444712423834 | (37.7752276921804, -122.444712423834) | |
| 70095 | 70095 | 59933 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 549 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1981 12:00:00 AM | 9 | Permit Number 19406 | 5999664.8686 | 2110448.6759 | 37.77486958773171 | -122.444635305779 | (37.7748695877317, -122.444635305779) | |
| 154958 | 154958 | 112871 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 549 Central Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11 | 5999666.6578 | 2110431.976 | 37.7748238361568 | -122.444627916028 | (37.7748238361568, -122.444627916028) | |||
| 161894 | 161894 | 59931 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 521 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1981 12:00:00 AM | 12 | Permit Number 19403 | 5999683.6559 | 2110322.5324 | 37.7745243018378 | -122.444561248652 | (37.7745243018378, -122.444561248652) | |
| 160115 | 160115 | 59914 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 409 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1981 12:00:00 AM | 12 | Permit Number 19383 | 5999728.7839 | 2110019.0941 | 37.773693712339 | -122.444383331369 | (37.773693712339, -122.444383331369) | |
| 123727 | 123727 | 142340 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 520 Central Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999729.6682 | 2110321.6281 | 37.774524444251206 | -122.444402018718 | (37.7745244442512, -122.444402018718) | |||
| 181455 | 181455 | 142338 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 510 Central Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 0ft | 5999738.5075 | 2110257.1017 | 37.7743477755014 | -122.444366803816 | (37.7743477755014, -122.444366803816) | |||
| 158310 | 158310 | 142337 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 500 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5999743.369 | 2110239.8651 | 37.774300725553005 | -122.44434874808998 | (37.774300725553, -122.44434874809) | |||
| 154604 | 154604 | 116598 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 454 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 4x4 | 5999760.624 | 2110077.6149 | 37.7738562121972 | -122.444277398119 | (37.7738562121972, -122.444277398119) | |||
| 176344 | 176344 | 142206 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1693 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999789.089 | 2110173.0386 | 37.7741198453954 | -122.444185791724 | (37.7741198453954, -122.444185791724) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");