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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29018 | 29018 | 247759 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 75 Alpine Ter | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6001668.74952 | 2108376.80716 | 37.7692948959648 | -122.437555068929 | (37.7692948959648, -122.437555068929) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 185659 | 185659 | 245457 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2800 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6007865.341 | 2106811.8898 | 37.7653483594859 | -122.41601046611099 | (37.7653483594859, -122.416010466111) | |||
| 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) | |||
| 136428 | 136428 | 245455 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2800 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6007994.6854 | 2106818.5473 | 37.7653739107422 | -122.41556356407 | (37.7653739107422, -122.41556356407) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 66905 | 66905 | 244210 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 546 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6003934.6479 | 2109752.6175 | 37.7732011032912 | -122.429815586143 | (37.7732011032912, -122.429815586143) | |||
| 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) | |||
| 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) | |||
| 177519 | 177519 | 225979 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 171 Germania St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003500.9012 | 2108793.5344 | 37.7705431243846 | -122.431247500167 | (37.7705431243846, -122.431247500167) | |||
| 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) | |||
| 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) | |||
| 130418 | 130418 | 225976 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 348 Eureka St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001460.81775 | 2103733.76138 | 37.7565344055496 | -122.437941677576 | (37.7565344055496, -122.437941677576) | |||
| 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) | |||
| 73222 | 73222 | 225974 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 478 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002948.609680001 | 2105430.29379 | 37.761277170124394 | -122.43291756641001 | (37.7612771701244, -122.43291756641) | |||
| 65167 | 65167 | 225973 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 478 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002948.31867 | 2105450.2559599997 | 37.761331964925 | -122.432919999069 | (37.761331964925, -122.432919999069) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 181544 | 181544 | 225967 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3599 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005877.128169999 | 2101963.64024 | 37.7519242145407 | -122.42254270219601 | (37.7519242145407, -122.422542702196) | |||
| 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) | |||
| 44495 | 44495 | 225965 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 81 Bernal Heights Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009494.27227 | 2098224.22173 | 37.74185999325589 | -122.409770124916 | (37.7418599932559, -122.409770124916) | |||
| 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) | |||
| 51594 | 51594 | 225963 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 200 Jarboe Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007947.91694 | 2096980.6157799999 | 37.7383585458117 | -122.41502893034401 | (37.7383585458117, -122.415028930344) | |||
| 132274 | 132274 | 225962 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 200 Jarboe Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007966.252640001 | 2096976.9069400001 | 37.738349392503 | -122.414965271836 | (37.738349392503, -122.414965271836) | |||
| 66898 | 66898 | 225961 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 202 Jarboe Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007991.11967 | 2096976.87427 | 37.7383507001153 | -122.414879291246 | (37.7383507001153, -122.414879291246) | |||
| 59772 | 59772 | 225960 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 202 Jarboe Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008021.65482 | 2096973.39205 | 37.7383428544349 | -122.41477346894699 | (37.7383428544349, -122.414773468947) | |||
| 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) | |
| 151968 | 151968 | 225958 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 22 Newman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006997.298830001 | 2096792.90464 | 37.7377896670691 | -122.41830240503599 | (37.7377896670691, -122.418302405036) | |||
| 1698 | 1698 | 225957 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 38 Newman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007027.0 | 2096768.0 | 37.7377229562927 | -122.418197948284 | (37.7377229562927, -122.418197948284) | |||
| 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) | |||
| 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) | |||
| 149617 | 149617 | 225954 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 245 Roanoke St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003654.86904 | 2095911.56632 | 37.735180998192206 | -122.429795956641 | (37.7351809981922, -122.429795956641) | |||
| 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) | |||
| 27127 | 27127 | 225952 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 800 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001178.257669999 | 2102625.59939 | 37.753475588250396 | -122.438839459988 | (37.7534755882504, -122.438839459988) | |||
| 129969 | 129969 | 225951 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 4401 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000607.24532 | 2101675.7007299997 | 37.750834892731596 | -122.440746005644 | (37.7508348927316, -122.440746005644) | |||
| 73383 | 73383 | 225950 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 646 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001193.5542 | 2102647.97152 | 37.7535378869843 | -122.438788164466 | (37.7535378869843, -122.438788164466) | |||
| 152964 | 152964 | 225949 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 119 Milton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6003777.8476 | 2095128.93714 | 37.733039038820294 | -122.429314984812 | (37.7330390388203, -122.429314984812) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 37482 | 37482 | 225944 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3386 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005759.148709999 | 2103755.79247 | 37.7568383926032 | -122.42307806320801 | (37.7568383926032, -122.423078063208) | |||
| 161053 | 161053 | 225943 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3386 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6005777.63765 | 2103756.4235799997 | 37.75684116881 | -122.423014166371 | (37.75684116881, -122.423014166371) | |||
| 182056 | 182056 | 225942 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2741 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008447.4960199995 | 2106788.1378099998 | 37.7653158554543 | -122.413995240611 | (37.7653158554543, -122.413995240611) | |||
| 170940 | 170940 | 225941 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2741 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008479.57157 | 2106789.99356 | 37.7653227523561 | -122.41388442972799 | (37.7653227523561, -122.413884429728) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 137432 | 137432 | 225937 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1232 Treat Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008665.07635 | 2101351.07554 | 37.7503991370286 | -122.412858243028 | (37.7503991370286, -122.412858243028) | |||
| 75984 | 75984 | 225936 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1232 Treat Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008666.40255 | 2101335.6889400003 | 37.7503569633096 | -122.412852569207 | (37.7503569633096, -122.412852569207) | |||
| 131309 | 131309 | 225935 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1250 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2001 12:00:00 AM | 10 | Width 3ft | Permit Number 33274 | 6008670.4768900005 | 2101262.07632 | 37.7501550682215 | -122.412833276033 | (37.7501550682215, -122.412833276033) | |
| 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) | |||
| 136709 | 136709 | 225933 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1256 Treat Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008673.75291 | 2101213.6434299997 | 37.7500222662216 | -122.41281852357001 | (37.7500222662216, -122.41281852357) | |||
| 158982 | 158982 | 225932 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 557 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6009854.01904 | 2098898.01508 | 37.743730236853 | -122.40857375230101 | (37.743730236853, -122.408573752301) | |||
| 150699 | 150699 | 225931 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 337 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6007076.3964 | 2096610.27498 | 37.737292658529 | -122.418015982652 | (37.737292658529, -122.418015982652) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 36653 | 36653 | 225927 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 172 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6004830.8864400005 | 2098735.49496 | 37.7430013921091 | -122.425930987935 | (37.7430013921091, -122.425930987935) | |||
| 76670 | 76670 | 225926 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 448 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002953.29528 | 2099219.1530400002 | 37.7442231148112 | -122.43245771787 | (37.7442231148112, -122.43245771787) | |||
| 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) | |||
| 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) | |||
| 178517 | 178517 | 225923 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1523 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009609.76682 | 2100372.8440799997 | 37.7477661109153 | -122.409522389545 | (37.7477661109153, -122.409522389545) | |||
| 64675 | 64675 | 225922 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 22 Franconia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009935.78986 | 2099989.5983599997 | 37.7467320650326 | -122.40836798561199 | (37.7467320650326, -122.408367985612) | |||
| 129939 | 129939 | 225921 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 300 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009716.79458 | 2099617.55194 | 37.7456982412969 | -122.40909900491998 | (37.7456982412969, -122.40909900492) | |||
| 166957 | 166957 | 225920 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 300 Montcalm St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009736.52173 | 2099618.93286 | 37.74570313810779 | -122.409030888471 | (37.7457031381078, -122.409030888471) | |||
| 40965 | 40965 | 225919 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1683 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009340.70254 | 2099660.4482299997 | 37.745794948977 | -122.410402509267 | (37.745794948977, -122.410402509267) | |||
| 29070 | 29070 | 225918 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1619 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009320.793740001 | 2100001.018 | 37.746728962386705 | -122.41049539576001 | (37.7467289623867, -122.41049539576) | |||
| 61102 | 61102 | 225917 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 85 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6005793.09116 | 2104012.0395299997 | 37.757543902632605 | -122.42297888958099 | (37.7575439026326, -122.422978889581) | |||
| 162031 | 162031 | 225916 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3778 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6005165.83624 | 2104308.70302 | 37.758323056384796 | -122.425169300823 | (37.7583230563848, -122.425169300823) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 44681 | 44681 | 225910 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 99 Fair Oaks St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6005408.28506 | 2103204.3544 | 37.7553044666341 | -122.42425226303101 | (37.7553044666341, -122.424252263031) | |||
| 134421 | 134421 | 225909 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 99 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6005410.68329 | 2103188.80406 | 37.755261904439394 | -122.424242863321 | (37.7552619044394, -122.424242863321) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 175971 | 175971 | 225905 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3620 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6006092.03845 | 2100850.85024 | 37.7488808700704 | -122.421720479039 | (37.7488808700704, -122.421720479039) | |||
| 44140 | 44140 | 225904 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 50 Camp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6005635.69766 | 2106380.47503 | 37.7640381868445 | -122.42369161489701 | (37.7640381868445, -122.423691614897) | |||
| 157030 | 157030 | 225903 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 50 Camp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6005652.747830001 | 2106381.31475 | 37.7640414549602 | -122.423632703012 | (37.7640414549602, -122.423632703012) | |||
| 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) | |||
| 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) | |||
| 58473 | 58473 | 225900 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1398 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6009378.42208 | 2107868.1744 | 37.768333627729504 | -122.410851658572 | (37.7683336277295, -122.410851658572) | |||
| 27884 | 27884 | 225899 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1398 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6009375.43724 | 2107898.5512099997 | 37.7684168680618 | -122.41086412858 | (37.7684168680618, -122.41086412858) | |||
| 70638 | 70638 | 225898 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1398 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009373.69267 | 2107922.6668599998 | 37.7684829862389 | -122.41087186634701 | (37.7684829862389, -122.410871866347) | |||
| 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) | |||
| 256 | 256 | 221894 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3164 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008618.9330400005 | 2101573.97925 | 37.75100859049479 | -122.41303356944799 | (37.7510085904948, -122.413033569448) | |||
| 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) | |||
| 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) | |||
| 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) |
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");