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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19662 | 19662 | 10000 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 136 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 2X2 | 6005403.547780001 | 2108183.22689 | 37.7689750062251 | -122.424622801709 | (37.7689750062251, -122.424622801709) | |||
| 20175 | 20175 | 10089 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 700 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6005586.51976 | 2104851.24563 | 37.7598365074586 | -122.423752966647 | (37.7598365074586, -122.423752966647) | |||
| 21573 | 21573 | 10054 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 426 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X2 | 6005501.955709999 | 2106458.62904 | 37.764245228771 | -122.42415974799201 | (37.764245228771, -122.424159747992) | |||
| 21621 | 21621 | 10076 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 600 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 2x2 | 6005555.84644 | 2105437.30746 | 37.7614439637781 | -122.423900725242 | (37.7614439637781, -122.423900725242) | |||
| 21251 | 21251 | 10061 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 490 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 2X2 | 6005517.65207 | 2106131.14555 | 37.7633469229371 | -122.424082167969 | (37.7633469229371, -122.424082167969) | |||
| 17382 | 17382 | 10079 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 614 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6005561.0033 | 2105378.47551 | 37.7612827162343 | -122.423878706238 | (37.7612827162343, -122.423878706238) | |||
| 18217 | 18217 | 10091 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 708 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/1992 12:00:00 AM | 50 | 3X3 | 6005589.43333 | 2104821.82229 | 37.759755882347704 | -122.42374079792299 | (37.7597558823477, -122.423740797923) | ||
| 21782 | 21782 | 10227 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 1404 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6005821.31625 | 2100751.5734599996 | 37.7485930087737 | -122.422649583919 | (37.7485930087737, -122.422649583919) | |||
| 181038 | 181038 | 176508 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 150 Brookdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 50 | Width 6ft | 6005731.293880001 | 2087351.0784200002 | 37.71179312382829 | -122.422009060692 | (37.7117931238283, -122.422009060692) | |||
| 177304 | 177304 | 176507 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 150 Brookdale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 45 | Width 6ft | 6005719.71054 | 2087314.8851 | 37.7116930913392 | -122.422046526423 | (37.7116930913392, -122.422046526423) | |||
| 18333 | 18333 | 27660 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 1360 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3x3 | 6005798.597080001 | 2101052.0301599996 | 37.7494167122272 | -122.42274949589199 | (37.7494167122272, -122.422749495892) | |||
| 21827 | 21827 | 26513 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 2864 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6008948.96043 | 2101783.0813599997 | 37.7516012590109 | -122.41190707235701 | (37.7516012590109, -122.411907072357) | |||
| 20120 | 20120 | 10020 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 250 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | 2x2 | 6005442.42406 | 2107520.98643 | 37.767158847823 | -122.42444122050101 | (37.767158847823, -122.424441220501) | |||
| 77013 | 77013 | 56360 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 2100 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2001 12:00:00 AM | 30 | Permit Number 12506 | 6000958.47841613 | 2115569.02150374 | 37.7890024802988 | -122.440527774143 | (37.7890024802988, -122.440527774143) | |
| 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) | |||
| 81265 | 81265 | 10174 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 1038 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 2x2 | 6005692.3267338 | 2102916.9952861997 | 37.7545314795937 | -122.423249534916 | (37.7545314795937, -122.423249534916) | |||
| 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) | |||
| 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) | |
| 21505 | 21505 | 10026 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 290 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 2x3 | 6005455.03663 | 2107324.1386599997 | 37.7666190630424 | -122.424383592842 | (37.7666190630424, -122.424383592842) | |||
| 140768 | 140768 | 115822 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 122 COLLEGE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6004593.0 | 2095924.0 | 37.7352682180932 | -122.42655338079099 | (37.7352682180932, -122.426553380791) | |||
| 130263 | 130263 | 192406 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 718 De Haro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | 6012081.21103 | 2105020.2958 | 37.7606651697825 | -122.401302754214 | (37.7606651697825, -122.401302754214) | ||||
| 184026 | 184026 | 225978 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 737 Sanchez St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 3ft | 6003705.65415 | 2103955.3434599997 | 37.757270218256394 | -122.430194042444 | (37.7572702182564, -122.430194042444) | |||
| 168988 | 168988 | 192423 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 80 Carolina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 6012208.345290001 | 2107668.53767 | 37.76794374283679 | -122.401049131921 | (37.7679437428368, -122.401049131921) | |||
| 33404 | 33404 | 225968 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3599 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6005865.3441 | 2101966.56287 | 37.751931574603894 | -122.422583660903 | (37.7519315746039, -122.422583660903) | |||
| 153007 | 153007 | 192422 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 80 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 6012207.07921 | 2107722.19142 | 37.768090993327704 | -122.401057281578 | (37.7680909933277, -122.401057281578) | |||
| 70033 | 70033 | 128871 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2610 Clay St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6001562.056059999 | 2116003.40074 | 37.790229524119795 | -122.438470613846 | (37.7902295241198, -122.438470613846) | |||
| 76270 | 76270 | 67546 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1139 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | 19 | Permit Number 31092 | 6011964.43282 | 2103102.09088 | 37.755391686497205 | -122.40157181880501 | (37.7553916864972, -122.401571818805) | |
| 134868 | 134868 | 225912 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1048 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6005698.159659999 | 2102902.03106 | 37.7544907204839 | -122.423228299447 | (37.7544907204839, -122.423228299447) | |||
| 171362 | 171362 | 192424 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 80 Carolina St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6012214.215580001 | 2107593.00345 | 37.767736670334 | -122.40102351921401 | (37.767736670334, -122.401023519214) | |||
| 20351 | 20351 | 10165 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 1019 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x4 | 6005763.39401 | 2102897.6669099997 | 37.7544824188306 | -122.423002391551 | (37.7544824188306, -122.423002391551) | |||
| 21466 | 21466 | 10087 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 673 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 2X2 | 6005642.33302 | 2105078.4944700003 | 37.7604636299235 | -122.423576092482 | (37.7604636299235, -122.423576092482) | |||
| 79560 | 79560 | 7700 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 640 Francisco St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 6x6 | 6008187.1407969 | 2121043.7620312 | 37.804443723648895 | -122.415905321467 | (37.8044437236489, -122.415905321467) | |||
| 147961 | 147961 | 67495 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1126 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/1992 12:00:00 AM | 18 | Permit Number 31020 | 6011901.71261 | 2103178.79248 | 37.755598792278796 | -122.40179411682301 | (37.7555987922788, -122.401794116823) | |
| 161173 | 161173 | 225924 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 145 Guerrero St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 18 | Width 2ft | 6005469.65475 | 2108205.8081400003 | 37.7690407421536 | -122.424395748072 | (37.7690407421536, -122.424395748072) | |||
| 181307 | 181307 | 225907 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3749 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6005583.06138 | 2101365.98068 | 37.7502665850353 | -122.42351714192499 | (37.7502665850353, -122.423517141925) | |||
| 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) | |||
| 150628 | 150628 | 67548 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1120 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | 16 | Permit Number 31094 | 6011900.0943 | 2103205.59495 | 37.755672295661505 | -122.401801597389 | (37.7556722956615, -122.401801597389) | |
| 154338 | 154338 | 192414 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 740 Rhode Island St | 3 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6011806.79674 | 2104934.73644 | 37.76041492892529 | -122.40224581930799 | (37.7604149289253, -122.402245819308) | |||
| 181461 | 181461 | 128870 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2610 Clay St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6001597.99168 | 2116010.93406 | 37.790252252691495 | -122.43834681946501 | (37.7902522526915, -122.438346819465) | |||
| 17464 | 17464 | 10037 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 351 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x2 | 6005536.7714599995 | 2106975.8845599997 | 37.765667455319 | -122.424076117338 | (37.765667455319, -122.424076117338) | |||
| 33224 | 33224 | 32625 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 75 Boardman Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 15 | Permit Number 37080 | 6011878.08124 | 2109949.48586 | 37.774188278987204 | -122.402351882652 | (37.7741882789872, -122.402351882652) | |
| 36558 | 36558 | 225906 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3749 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6005541.4535 | 2101364.78602 | 37.750260956187404 | -122.423660939909 | (37.7502609561874, -122.423660939909) | |||
| 66285 | 66285 | 225948 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 123 Milton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6003779.75499 | 2095097.5175400001 | 37.732952875676496 | -122.429306150766 | (37.7329528756765, -122.429306150766) | |||
| 76617 | 76617 | 32627 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 75 Boardman Pl | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 15 | Permit Number 37080 | 6011835.142990001 | 2109991.00563 | 37.774299885758 | -122.40250333475599 | (37.774299885758, -122.402503334756) | |
| 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) | ||
| 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) |
| 146859 | 146859 | 31889 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 167 11th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1995 12:00:00 AM | 15 | Permit Number 35321 | 6007897.98767 | 2109828.50999 | 37.7736331256972 | -122.416111205987 | (37.7736331256972, -122.416111205987) | ||
| 157898 | 157898 | 128866 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2610 Clay St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6001800.9878 | 2116040.20004 | 37.790344153503604 | -122.43764656594 | (37.7903441535036, -122.43764656594) | |||
| 160109 | 160109 | 225901 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1 Camp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6005825.23106 | 2106352.45228 | 37.763971940068394 | -122.423034081872 | (37.7639719400684, -122.423034081872) | |||
| 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) | |||
| 29808 | 29808 | 225970 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2846 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6009214.745180001 | 2103362.9385 | 37.7559541000213 | -122.411099534231 | (37.7559541000213, -122.411099534231) | |||
| 38696 | 38696 | 32626 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 75 Boardman Pl | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 14 | Permit Number 37080 | 6011867.62207 | 2109962.18755 | 37.7742225710588 | -122.402388956281 | (37.7742225710588, -122.402388956281) | |
| 53261 | 53261 | 225947 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 114 Rousseau St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6003497.57041 | 2095097.9657299998 | 37.7329381267755 | -122.430281767707 | (37.7329381267755, -122.430281767707) | |||
| 65253 | 65253 | 225977 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 310 Liberty St | 61 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 6003712.20285 | 2103924.7270400003 | 37.7571865237503 | -122.43016921035499 | (37.7571865237503, -122.430169210355) | |||
| 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) | |||
| 78703 | 78703 | 105804 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 117 ALPINE TER | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 04/10/2014 12:00:00 AM | 14 | 3x3 | Permit Number 772090 | 6001724.2 | 2108149.5 | 37.7686739192463 | -122.437346990121 | (37.7686739192463, -122.437346990121) | |
| 130450 | 130450 | 225902 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 44 Camp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6005679.36245 | 2106382.2556 | 37.7640455405875 | -122.423540717652 | (37.7640455405875, -122.423540717652) | |||
| 154809 | 154809 | 225913 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 699 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6005644.87336 | 2104976.18097 | 37.760182844481 | -122.42356003238501 | (37.760182844481, -122.423560032385) | |||
| 157984 | 157984 | 225945 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 25 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006157.91256 | 2103444.1528 | 37.7560051968042 | -122.421676853797 | (37.7560051968042, -122.421676853797) | |||
| 169108 | 169108 | 225946 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3557 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6005893.76776 | 2102550.85426 | 37.7535375074585 | -122.422526882211 | (37.7535375074585, -122.422526882211) | |||
| 169326 | 169326 | 128865 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2610 Clay St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6001864.710469999 | 2116045.7184900003 | 37.7903629286659 | -122.437426485651 | (37.7903629286659, -122.437426485651) | |||
| 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) | |
| 29911 | 29911 | 245456 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2800 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6007901.4813 | 2106811.8898 | 37.765350391343496 | -122.415885464882 | (37.7653503913435, -122.415885464882) | |||
| 39266 | 39266 | 225908 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3772 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6005343.316000001 | 2101393.98229 | 37.7503299359862 | -122.424348189214 | (37.7503299359862, -122.424348189214) | |||
| 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) | |
| 134760 | 134760 | 225975 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 4337 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6001561.548219999 | 2104657.76141 | 37.7590772134726 | -122.437659488305 | (37.7590772134726, -122.437659488305) | |||
| 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) | |||
| 157340 | 157340 | 70988 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 179 11th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1995 12:00:00 AM | 13 | 6007961.92289 | 2109767.88075 | 37.773470246774295 | -122.415885749526 | (37.7734702467743, -122.415885749526) | ||
| 164420 | 164420 | 225929 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 56 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008145.90084 | 2098385.005 | 37.742225813165895 | -122.414443742389 | (37.7422258131659, -122.414443742389) | |||
| 178781 | 178781 | 225940 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 183 Bartlett St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006723.95695 | 2102704.663 | 37.7540066307184 | -122.419666814188 | (37.7540066307184, -122.419666814188) | |||
| 185706 | 185706 | 67574 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 601 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | 13 | Permit Number 31129 | 6013300.57075 | 2104280.61777 | 37.7587021305084 | -122.397033645504 | (37.7587021305084, -122.397033645504) | |
| 186358 | 186358 | 128869 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2610 Clay St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6001642.59008 | 2116017.92803 | 37.7902739929064 | -122.438193013824 | (37.7902739929064, -122.438193013824) | |||
| 260 | 260 | 221893 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3164 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008601.79804 | 2101572.78068 | 37.751004337584796 | -122.41309273944599 | (37.7510043375848, -122.413092739446) | |||
| 1016 | 1016 | 225959 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 20 Newman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/15/2005 12:00:00 AM | 12 | Width 3ft | Permit Number 48238 | 6006979.14621 | 2096796.63822 | 37.7377988968125 | -122.41836543223101 | (37.7377988968125, -122.418365432231) | |
| 5795 | 5795 | 10694 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 1250 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001838.4236 | 2110502.6134 | 37.7751414763631 | -122.43712039839399 | (37.7751414763631, -122.437120398394) | |||
| 19086 | 19086 | 10155 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 988 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2x2 | 6005676.86794 | 2103220.79798 | 37.7553647787894 | -122.423324590769 | (37.7553647787894, -122.423324590769) | |||
| 19478 | 19478 | 10071 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 563 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2x3 | 6005607.25335 | 2105721.20389 | 37.7622263784702 | -122.423743116346 | (37.7622263784702, -122.423743116346) | |||
| 20893 | 20893 | 10068 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 549 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2x3 | 6005603.73706 | 2105778.3330099997 | 37.762383043055 | -122.423759340124 | (37.762383043055, -122.423759340124) | |||
| 21713 | 21713 | 10001 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 145 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X2 | 6005474.27283 | 2108090.23028 | 37.768723653813204 | -122.42437155270201 | (37.7687236538132, -122.424371552702) | |||
| 32129 | 32129 | 225911 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 886 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6005643.7507 | 2103817.72642 | 37.75700193611971 | -122.42348155572999 | (37.7570019361197, -122.42348155573) | |||
| 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) | |||
| 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) | |||
| 49296 | 49296 | 225964 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 200 Jarboe Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007927.65948 | 2096983.8877299998 | 37.7383663914855 | -122.415099202478 | (37.7383663914855, -122.415099202478) | |||
| 49421 | 49421 | 66180 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1409 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/06/1990 12:00:00 AM | 12 | Permit Number 29257 | 6013724.4666 | 2104745.52937 | 37.76000226421429 | -122.395600181905 | (37.7600022642143, -122.395600181905) | |
| 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) | |||
| 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) | |
| 64117 | 64117 | 245459 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2800 16th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6007813.0325 | 2106805.2324 | 37.765327138725 | -122.416190917981 | (37.765327138725, -122.416190917981) | |||
| 66184 | 66184 | 225934 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1256 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008672.01096 | 2101240.80305 | 37.7500967426882 | -122.412826467282 | (37.7500967426882, -122.412826467282) | |||
| 70913 | 70913 | 32088 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 3972 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 12 | Permit Number 35461 | 6003219.31552 | 2104788.31954 | 37.759529813480604 | -122.43193546805901 | (37.7595298134806, -122.431935468059) | |
| 73632 | 73632 | 87141 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 169 11th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/29/2011 12:00:00 AM | 12 | 3x3 | Permit Number 767576 | 6007945.36003 | 2109780.43285 | 37.7735037807007 | -122.415943932067 | (37.7735037807007, -122.415943932067) |
| 84403 | 84403 | 6257 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 1324X Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004503.4535 | 2113305.70612 | 37.782989203891 | -122.428101266861 | (37.782989203891, -122.428101266861) | |||
| 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) | |||
| 90319 | 90319 | 421 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 685X Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6005653.198434 | 2104994.6037312 | 37.7602338989595 | -122.423532549649 | (37.7602338989595, -122.423532549649) | |||
| 105535 | 105535 | 10695 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 1250 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001856.34415 | 2110522.16346 | 37.7751961745675 | -122.43705980731701 | (37.7751961745675, -122.437059807317) | |||
| 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) | |||
| 140451 | 140451 | 75710 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1190 Treat Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1993 12:00:00 AM | 12 | 18x3 | 6008645.48606603 | 2101619.0486747 | 37.7511338315754 | -122.412944932355 | (37.7511338315754, -122.412944932355) | ||
| 146602 | 146602 | 66067 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1425 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1990 12:00:00 AM | 12 | Permit Number 29107 | 6013650.29046 | 2104740.7059299997 | 37.7599848938155 | -122.395856385278 | (37.7599848938155, -122.395856385278) | |
| 154308 | 154308 | 225938 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1232 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008664.0646 | 2101365.80196 | 37.7504395156908 | -122.41286278279101 | (37.7504395156908, -122.412862782791) | |||
| 158445 | 158445 | 225966 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 183 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007593.94414 | 2100298.1781200003 | 37.7474479361811 | -122.416487731444 | (37.7474479361811, -122.416487731444) | |||
| 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) |
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");