Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
128278 | 128278 | 32806 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1686 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37166 | 5999791.91343358 | 2110220.51293563 | 37.7742503589901 | -122.44417943364999 | (37.7742503589901, -122.44417943365) | ||
128444 | 128444 | 36065 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1398 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/1998 12:00:00 AM | Permit Number 39186 | 6009394.0 | 2107812.0 | 37.76818025927739 | -122.410793808029 | (37.7681802592774, -122.410793808029) | |||
128600 | 128600 | 95394 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 208 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767264 | 6004579.0 | 2098715.0 | 37.742930879183604 | -122.426800483584 | (37.7429308791836, -122.426800483584) | |
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) | |||
129299 | 129299 | 108168 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 2x FRANCONIA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6009949.0 | 2099997.0 | 37.74675312806 | -122.40832282803001 | (37.74675312806, -122.40832282803) | ||||
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) | ||||
129468 | 129468 | 32983 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 618 Texas St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | Permit Number 37296 | 6013812.07366772 | 2104214.5102771 | 37.7585490739971 | -122.395259990599 | (37.7585490739971, -122.395259990599) | ||
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) | |||
139759 | 139759 | 69160 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 3272 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1994 12:00:00 AM | Permit Number 33197 | 6007895.60997349 | 2101540.97783702 | 37.750877345046604 | -122.415532563624 | (37.7508773450466, -122.415532563624) | ||
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) | ||
141466 | 141466 | 51066 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 10 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | Permit Number 47529 | 6006972.51081745 | 2110293.55168859 | 37.7748579396097 | -122.419345575047 | (37.7748579396097, -122.419345575047) | |||
142985 | 142985 | 35568 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 25 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38937 | 6006180.09920883 | 2103440.54844158 | 37.7559965511416 | -122.421599868894 | (37.7559965511416, -122.421599868894) | ||
144700 | 144700 | 32984 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 10X Sierra St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 5x9 | Permit Number 37296 | 6013812.07366772 | 2104214.5102771 | 37.7585490739971 | -122.395259990599 | (37.7585490739971, -122.395259990599) | |
144912 | 144912 | 93025 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 3772 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6005372.0 | 2101391.0 | 37.7503233669919 | -122.424248785816 | (37.7503233669919, -122.424248785816) | |||||
145592 | 145592 | 59773 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 136 Newman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1991 12:00:00 AM | Permit Number 19218 | 6007237.20914714 | 2096749.07204327 | 37.7376828142423 | -122.417469811222 | (37.7376828142423, -122.417469811222) | ||
146207 | 146207 | 119913 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 225 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013509.0 | 2106013.0 | 37.7634704729857 | -122.396434224989 | (37.7634704729857, -122.396434224989) | ||||
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) | |
25801 | 25801 | 225955 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 245 Roanoke St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003637.7380800005 | 2095933.74555 | 37.735240927214704 | -122.42985676608299 | (37.7352409272147, -122.429856766083) | |||
31526 | 31526 | 95134 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 450@ Wayland Somerset St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6010117.366119999 | 2092259.39432 | 37.7255167458877 | -122.40719528853501 | (37.7255167458877, -122.407195288535) | |||
39534 | 39534 | 244202 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 546 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6003923.0756 | 2109749.7244 | 37.7731925042221 | -122.429855409854 | (37.7731925042221, -122.429855409854) | |||
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) | |
130809 | 130809 | 142235 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 689 HAYES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6004665.6696 | 2110849.8982 | 37.7762553374912 | -122.42736506585 | (37.7762553374912, -122.42736506585) | |||
163115 | 163115 | 112711 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 782 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 1 | 6009126.82605 | 2110111.36785 | 37.774478803191 | -122.411880442527 | (37.774478803191, -122.411880442527) | ||
163367 | 163367 | 225953 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 245 Roanoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003670.68661 | 2095891.30011 | 37.735126247484104 | -122.42973982455901 | (37.7351262474841, -122.429739824559) | |||
174678 | 174678 | 128878 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2507 Larkin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006675.76572 | 2119877.35226 | 37.8011559740396 | -122.421052707221 | (37.8011559740396, -122.421052707221) | |||
178778 | 178778 | 225914 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 611 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009855.21876 | 2105398.0408099997 | 37.7615779286091 | -122.409028144648 | (37.7615779286091, -122.409028144648) | |||
179575 | 179575 | 49771 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 333 Schwerin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 1 | Permit Number 46559 | 6008634.11039 | 2086335.4029299999 | 37.70916757830379 | -122.411904362692 | (37.7091675783038, -122.411904362692) | |
184254 | 184254 | 225897 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2770 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6009476.04285 | 2103963.05006 | 37.7576165210915 | -122.410238245413 | (37.7576165210915, -122.410238245413) | |||
185415 | 185415 | 246444 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 467 Duncan St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 6003499.43256 | 2099785.6606799997 | 37.7458095674622 | -122.430609709989 | (37.7458095674622, -122.430609709989) | |||
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) | |||
31018 | 31018 | 244415 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 630 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6003443.0612 | 2109684.1199 | 37.7729851758016 | -122.43151115772899 | (37.7729851758016, -122.431511157729) | |||
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) | |||
45304 | 45304 | 225930 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 269 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006712.58135 | 2098072.63553 | 37.7412874920181 | -122.41937757332899 | (37.7412874920181, -122.419377573329) | |||
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) | ||||
116317 | 116317 | 114483 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 784 CLEMENTINA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x2 | 6009096.0 | 2110140.0 | 37.7745556909018 | -122.41198909995701 | (37.7745556909018, -122.411989099957) | |||
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) |
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) | |||
147884 | 147884 | 142233 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 600 BUCHANAN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004546.0223 | 2110772.1475 | 37.7760350855974 | -122.427773417679 | (37.7760350855974, -122.427773417679) | |||
159645 | 159645 | 225939 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1037 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6009456.84269 | 2103117.56685 | 37.75529393828 | -122.410244954342 | (37.75529393828, -122.410244954342) | |||
168685 | 168685 | 192421 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 53 Pomona St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 5ft | 6014148.288919999 | 2094395.14028 | 37.731605838737295 | -122.39341002514799 | (37.7316058387373, -122.393410025148) | |||
182998 | 182998 | 128875 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 1237x Robert C Levy Tunl | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6007636.05536 | 2118136.6748900004 | 37.7964305951503 | -122.417606237154 | (37.7964305951503, -122.417606237154) | ||||
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) | |||
3164 | 3164 | 10171 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1032 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/23/2017 12:00:00 AM | 3 | 2x3 | Permit Number 779560 | 6005695.79144 | 2102951.17521 | 37.7546255252659 | -122.423239982539 | (37.7546255252659, -122.423239982539) | |
7187 | 7187 | 22760 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 1620 Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4X4 | 6002287.3238 | 2112301.156 | 37.7801053300032 | -122.43569625863701 | (37.7801053300032, -122.435696258637) | |||
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) | ||
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) | |
10930 | 10930 | 109686 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 190 Onondaga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772797 | 6000260.82873 | 2091434.8524 | 37.7226961949641 | -122.441209260793 | (37.7226961949641, -122.441209260793) |
11919 | 11919 | 108571 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 223 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772573 | 6009406.56 | 2094751.33642 | 37.732319284403204 | -122.409828317318 | (37.7323192844032, -122.409828317318) |
13795 | 13795 | 78433 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 870 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/2016 12:00:00 AM | 3 | 6011558.925919999 | 2104265.3143 | 37.7585630053957 | -122.403056007737 | (37.7585630053957, -122.403056007737) | ||
14322 | 14322 | 115881 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1663 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2016 12:00:00 AM | 3 | Permit Number 773046 | 6015043.9945 | 2096491.0960099997 | 37.737410632491 | -122.39045976502199 | (37.737410632491, -122.390459765022) | ||
24867 | 24867 | 128872 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1270 Clay St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6008617.8933 | 2116985.80522 | 37.7933257892186 | -122.414127394165 | (37.7933257892186, -122.414127394165) | |||
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) | |
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) | ||||
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) | |||
35780 | 35780 | 128877 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 1237x Robert C Levy Tunl | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6007635.0884300005 | 2118146.70213 | 37.796458073045 | -122.417610293998 | (37.796458073045, -122.417610293998) | ||||
39742 | 39742 | 192410 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 650 Rhode Island St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6011779.1081300005 | 2105360.6424 | 37.761582826304604 | -122.402371529224 | (37.7615828263046, -122.402371529224) | |||
77438 | 77438 | 51908 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 490X Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52601 | 6002971.47862471 | 2105361.83743697 | 37.7610905025589 | -122.43283358188299 | (37.7610905025589, -122.432833581883) |
82775 | 82775 | 51909 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 490X Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2005 12:00:00 AM | 3 | 3x3 | Permit Number 48114 | 6002971.47862471 | 2105361.83743697 | 37.7610905025589 | -122.43283358188299 | (37.7610905025589, -122.432833581883) | |
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) | ||||
90002 | 90002 | 10124 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 877 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6005714.7162163 | 2103867.2939474997 | 37.7571420422058 | -122.42323965318998 | (37.7571420422058, -122.42323965319) | |||
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) | ||||
96915 | 96915 | 103262 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 53 Woodward St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770698 | 6006511.0 | 2108178.0 | 37.769023136516 | -122.420791817714 | (37.769023136516, -122.420791817714) | |
101465 | 101465 | 96194 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1640 Jerrold Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4x50 | 6015077.4 | 2097255.4 | 37.7395111076977 | -122.39039765239299 | (37.7395111076977, -122.390397652393) | |||
107364 | 107364 | 26544 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 530 Francisco St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/19/1997 12:00:00 AM | 3 | 4X4 | 6008751.4918274 | 2121120.9717011 | 37.8046874335197 | -122.41395779393 | (37.8046874335197, -122.41395779393) | ||
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) | |||
133659 | 133659 | 142688 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 552 FRANCISCO ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6008641.5861 | 2121102.2307 | 37.8046298022358 | -122.414336807992 | (37.8046298022358, -122.414336807992) | |||
142869 | 142869 | 116342 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 611 YORK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778005 | 6009887.0 | 2105445.0 | 37.7617086481783 | -122.40892153916599 | (37.7617086481783, -122.408921539166) | |
151682 | 151682 | 128876 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 1237x Robert C Levy Tunl | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6007635.33447 | 2118142.36056 | 37.7964461660197 | -122.417609134775 | (37.7964461660197, -122.417609134775) | ||||
153603 | 153603 | 128862 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 689 Hayes St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6004674.24665 | 2110845.64244 | 37.7762441372985 | -122.427335092236 | (37.7762441372985, -122.427335092236) | |||
158147 | 158147 | 247455 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 541 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6003122.801 | 2110193.1484 | 37.7743646855214 | -122.432655343876 | (37.7743646855214, -122.432655343876) | |||
158771 | 158771 | 176498 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 144 Brookdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6005795.48549 | 2087494.48765 | 37.7121905153633 | -122.42179737647498 | (37.7121905153633, -122.421797376475) | |||
162647 | 162647 | 47473 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 2713 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 3 | Permit Number 45374 | 6001758.37714 | 2115982.9514900004 | 37.790184540925395 | -122.43778989361601 | (37.7901845409254, -122.437789893616) | |
163531 | 163531 | 128879 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1 Balance St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 1ft | 6012011.137630001 | 2118129.24016 | 37.796655394198204 | -122.40246690323099 | (37.7966553941982, -122.402466903231) | |||
164012 | 164012 | 128873 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1270 Clay St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6008597.37413 | 2116983.75832 | 37.7933190163979 | -122.414198247271 | (37.7933190163979, -122.414198247271) | |||
167018 | 167018 | 225971 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3446 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006565.68979 | 2104973.1411599996 | 37.7602264301236 | -122.420375142719 | (37.7602264301236, -122.420375142719) | |||
27086 | 27086 | 225956 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 126 Fairmount St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004690.92985 | 2097272.0847099996 | 37.738975290087104 | -122.426310750952 | (37.7389752900871, -122.426310750952) | |||
31008 | 31008 | 49769 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 333 Schwerin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 4 | Permit Number 46559 | 6008658.89925 | 2086391.1157900002 | 37.70932194511621 | -122.411822622426 | (37.7093219451162, -122.411822622426) | |
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) | |||
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) | |||
43000 | 43000 | 176515 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 154 Brookdale Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6006304.71292 | 2087396.6514 | 37.7119505816242 | -122.420030394781 | (37.7119505816242, -122.420030394781) | |||
43922 | 43922 | 176514 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 154 Brookdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6006291.2518 | 2087400.97553 | 37.7119616963423 | -122.420077226985 | (37.7119616963423, -122.420077226985) | |||
60881 | 60881 | 192409 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 650 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6011776.86645 | 2105375.28628 | 37.7616229099979 | -122.40238031202 | (37.7616229099979, -122.40238031202) | |||
72097 | 72097 | 176499 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 162 Brookdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6005745.58119 | 2087451.7768599999 | 37.7120704261874 | -122.421966828522 | (37.7120704261874, -122.421966828522) | |||
93765 | 93765 | 52137 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 541 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2005 12:00:00 AM | 4 | 3x3 | Permit Number 48316 | 6003127.26918681 | 2110108.47893411 | 37.774132457488896 | -122.432633838295 | (37.7741324574889, -122.432633838295) | |
131813 | 131813 | 82990 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 737 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50125 | 6009298.17418 | 2110240.35937 | 37.774842595135205 | -122.41129682837901 | (37.7748425951352, -122.411296828379) | |
148398 | 148398 | 225925 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 357 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004205.07883 | 2098948.09387 | 37.743549752810296 | -122.428110007472 | (37.7435497528103, -122.428110007472) | |||
151104 | 151104 | 225972 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 111 Hancock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003502.63381 | 2105046.7258599997 | 37.760255392804496 | -122.430974055914 | (37.7602553928045, -122.430974055914) | |||
154398 | 154398 | 82843 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 719 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52435 | 6009401.3474 | 2110338.98679 | 37.7751191888227 | -122.410946896775 | (37.7751191888227, -122.410946896775) | |
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) | |||
183419 | 183419 | 128864 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 628 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6004541.11924 | 2110775.90598 | 37.7760451281037 | -122.42779064652599 | (37.7760451281037, -122.427790646526) | |||
13521 | 13521 | 49830 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 225 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2003 12:00:00 AM | 5 | 3x3 | Permit Number 46613 | 6013486.20588 | 2106002.24827 | 37.7634396826096 | -122.396512309398 | (37.7634396826096, -122.396512309398) | |
24547 | 24547 | 83274 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1639X Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2006 12:00:00 AM | 5 | 6008741.72565 | 2118600.6509700003 | 37.7977667125146 | -122.41381320433001 | (37.7977667125146, -122.41381320433) | ||
28869 | 28869 | 83275 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1639X Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2006 12:00:00 AM | 5 | 6008740.14676 | 2118614.90766 | 37.797805769189296 | -122.413819676732 | (37.7978057691893, -122.413819676732) | ||
35324 | 35324 | 245162 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1308 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000247.8581 | 2109240.6853 | 37.7715860006418 | -122.44253187989901 | (37.7715860006418, -122.442531879899) | |||
35468 | 35468 | 49765 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 333 Schwerin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 5 | Permit Number 46559 | 6008653.27394 | 2086377.17589 | 37.7092833534188 | -122.411841080097 | (37.7092833534188, -122.411841080097) | |
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) |
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");