Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, DBH, PlotSize
qLegalStatus ✖
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 673 | 673 | 210967 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 375 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1993 12:00:00 AM | 4 | Width 3ft | Permit Number 32251 | 5992728.19812 | 2094135.00675 | 37.7296781967805 | -122.467443955276 | (37.7296781967805, -122.467443955276) | |
| 9950 | 9950 | 68298 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2100 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 3x3 | Permit Number 32107 | 5981719.63070527 | 2100774.89065863 | 37.747267790944 | -122.50599319492201 | (37.747267790944, -122.505993194922) | |
| 10910 | 10910 | 68310 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2186 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 6 | Permit Number 32121 | 5981735.8983 | 2100213.1522 | 37.7457263715271 | -122.505895303793 | (37.7457263715271, -122.505895303793) | |
| 17879 | 17879 | 68381 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 42 Uranus Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32206 | 5999268.74613245 | 2105519.44927205 | 37.76131256253829 | -122.445651023552 | (37.7613125625383, -122.445651023552) | ||
| 18371 | 18371 | 68355 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 627 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32175 | 5989388.74548019 | 2111065.82314724 | 37.7759723585503 | -122.48022734798799 | (37.7759723585503, -122.480227347988) | ||
| 20473 | 20473 | 68412 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 33 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32249 | 5993232.78328668 | 2093269.41121212 | 37.7273306024275 | -122.465636703092 | (37.7273306024275, -122.465636703092) | ||
| 27678 | 27678 | 68339 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 410 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 6 | Permit Number 32156 | 5991257.09324 | 2112608.74204 | 37.7803171779643 | -122.47387689925101 | (37.7803171779643, -122.473876899251) | |
| 28604 | 28604 | 68272 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 507 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 15 | Permit Number 32079 | 6008804.98345 | 2093624.18713 | 37.7291906419342 | -122.41182849499901 | (37.7291906419342, -122.411828494999) | |
| 30056 | 30056 | 68330 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1443 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 3 | Permit Number 32145 | 5991076.10581 | 2110608.88252 | 37.774815627769705 | -122.474357034376 | (37.7748156277697, -122.474357034376) | |
| 30583 | 30583 | 68237 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1775 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 10 | Permit Number 32032 | 6001656.99546 | 2121058.17098 | 37.8041139989306 | -122.438504449024 | (37.8041139989306, -122.438504449024) | |
| 31779 | 31779 | 68325 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 841 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 7 | Permit Number 32140 | 6006815.0166 | 2113575.49994 | 37.783860503793996 | -122.42012334783199 | (37.783860503794, -122.420123347832) | |
| 33255 | 33255 | 66536 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 555 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 7 | Permit Number 32084 | 6008859.29808 | 2093449.63302 | 37.7287144005277 | -122.41162839584999 | (37.7287144005277, -122.41162839585) | |
| 34309 | 34309 | 68307 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2167 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32118 | 5981682.0022594 | 2100343.28066189 | 37.7460804954734 | -122.50609131195101 | (37.7460804954734, -122.506091311951) | ||
| 38026 | 38026 | 68360 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 716 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 2 | Permit Number 32180 | 5990389.00128 | 2110476.58792 | 37.774412551740205 | -122.476724178706 | (37.7744125517402, -122.476724178706) | |
| 38779 | 38779 | 68329 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1342 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 12 | Permit Number 32144 | 5991421.402000001 | 2110674.853 | 37.7750167634254 | -122.47316740712401 | (37.7750167634254, -122.473167407124) | |
| 39912 | 39912 | 68348 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 518 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 9 | Permit Number 32167 | 5990339.7966 | 2111825.86021 | 37.7781144278241 | -122.476992997759 | (37.7781144278241, -122.476992997759) | |
| 41094 | 41094 | 68347 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 479 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 10 | Permit Number 32166 | 5989354.45266 | 2112083.78554 | 37.7787654076266 | -122.48042050354601 | (37.7787654076266, -122.480420503546) | |
| 43248 | 43248 | 68349 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 527 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 6 | Permit Number 32168 | 5991569.001 | 2111811.09611 | 37.7781451219305 | -122.47273970036899 | (37.7781451219305, -122.472739700369) | |
| 46907 | 46907 | 68269 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 424 Somerset St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 13 | Permit Number 32076 | 6010049.762159999 | 2092483.07672 | 37.7261271472388 | -122.40744475327499 | (37.7261271472388, -122.407444753275) | |
| 48911 | 48911 | 68331 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2338 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1993 12:00:00 AM | 9 | Permit Number 32146 | 5991366.81812 | 2112033.7901 | 37.778744872635606 | -122.473455364804 | (37.7787448726356, -122.473455364804) | ||
| 49277 | 49277 | 68253 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3825 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 10 | Permit Number 32055 | 6000581.64191 | 2121452.9297599997 | 37.805136672889205 | -122.44225413274799 | (37.8051366728892, -122.442254132748) | |
| 51041 | 51041 | 68306 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2151 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 8 | Permit Number 32117 | 5981682.7661 | 2100434.4801 | 37.746330948634295 | -122.50609543163999 | (37.7463309486343, -122.50609543164) | |
| 51552 | 51552 | 68319 | Permitted Site 1 | Heteromeles arbutifolia :: Toyon 322 | 100 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32134 | 5993677.209627 | 2114838.05789906 | 37.786578151303104 | -122.46566667324801 | (37.7865781513031, -122.465666673248) | ||
| 52023 | 52023 | 68238 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 290 Avila St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 10 | Permit Number 32036 | 6000949.5088599995 | 2120925.17442 | 37.8037085566624 | -122.440943204485 | (37.8037085566624, -122.440943204485) | |
| 54841 | 54841 | 68232 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 106 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 9 | Permit Number 32027 | 6001414.70118 | 2121097.37736 | 37.804207863862096 | -122.439345736027 | (37.8042078638621, -122.439345736027) | |
| 57890 | 57890 | 68343 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 470 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 7 | Permit Number 32162 | 5991273.13481 | 2112218.31642 | 37.779246105725996 | -122.47379291393601 | (37.779246105726, -122.473792913936) | |
| 62783 | 62783 | 68276 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 543 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 6 | Permit Number 32083 | 6008845.70964 | 2093488.4538 | 37.7288202318587 | -122.411678113946 | (37.7288202318587, -122.411678113946) | |
| 62789 | 62789 | 68290 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2022 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 4 | Permit Number 32099 | 5981387.3239 | 2101295.4251 | 37.7486774660989 | -122.507180877193 | (37.7486774660989, -122.507180877193) | |
| 63742 | 63742 | 68344 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 471 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 6 | Permit Number 32163 | 5989351.6805300005 | 2112147.42203 | 37.7789399745959 | -122.480434752609 | (37.7789399745959, -122.480434752609) | |
| 69265 | 69265 | 68351 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 547 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 8 | Permit Number 32170 | 5991572.032819999 | 2111691.1786700003 | 37.777816036941104 | -122.472720466548 | (37.7778160369411, -122.472720466548) | |
| 69349 | 69349 | 68354 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1651X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 6 | Permit Number 32174 | 5990386.23318 | 2111265.56815 | 37.776578714092004 | -122.476791411328 | (37.776578714092, -122.476791411328) | |
| 75821 | 75821 | 68256 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 243 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 16 | Permit Number 32061 | 6009551.9423 | 2093241.4503 | 37.7281816043806 | -122.40921918673901 | (37.7281816043806, -122.409219186739) | |
| 76399 | 76399 | 68359 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 683 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32179 | 5989402.03203954 | 2110700.64294356 | 37.774970446858894 | -122.48015465411899 | (37.7749704468589, -122.480154654119) | ||
| 78809 | 78809 | 68410 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 20 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32246 | 5993214.33065224 | 2093166.46893196 | 37.7270468838271 | -122.46569301740699 | (37.7270468838271, -122.465693017407) | ||
| 80031 | 80031 | 68363 | Permitted Site 1 | Tree(s) :: 17 | 754 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1993 12:00:00 AM | Permit Number 32184 | 5989472.10093334 | 2110204.9664394 | 37.773613527163796 | -122.47987599352699 | (37.7736135271638, -122.479875993527) | |||
| 80574 | 80574 | 68336 | Permitted Site 1 | Tree(s) :: 17 | 3016 Anza | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1993 12:00:00 AM | Permit Number 32153 | 5989325.38928872 | 2111959.43695487 | 37.7784222920603 | -122.480511939153 | (37.7784222920603, -122.480511939153) | |||
| 81535 | 81535 | 68227 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 700 Irving St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32021 | 5993616.93785931 | 2106672.28749806 | 37.764153656105 | -122.465281833175 | (37.764153656105, -122.465281833175) | ||
| 82116 | 82116 | 60160 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2026 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32058 | 5990694.00698191 | 2101593.62851431 | 37.7500400086591 | -122.475020546977 | (37.7500400086591, -122.475020546977) | ||
| 82259 | 82259 | 68378 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 25 Rivoli St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32202 | 5998511.40529692 | 2105993.51041649 | 37.762570947697704 | -122.448304473804 | (37.7625709476977, -122.448304473804) | ||
| 83755 | 83755 | 58440 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 929 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32226 | 5999179.41630163 | 2106960.75949559 | 37.7652649396084 | -122.44606364987301 | (37.7652649396084, -122.446063649873) | ||
| 83896 | 83896 | 68356 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 630 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32176 | 5990370.46643426 | 2111075.29935955 | 37.776055373776394 | -122.476832047274 | (37.7760553737764, -122.476832047274) | ||
| 86564 | 86564 | 68228 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 737 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32022 | 5993512.24196294 | 2106616.67074955 | 37.7639949088607 | -122.465639902196 | (37.7639949088607, -122.465639902196) | ||
| 87958 | 87958 | 68323 | Permitted Site 1 | Tree(s) :: 17 | 721 Geary St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1993 12:00:00 AM | Permit Number 32138 | 6008274.0 | 2114475.0 | 37.7864124098445 | -122.415139483637 | (37.7864124098445, -122.415139483637) | |||
| 90139 | 90139 | 54891 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 163 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32197 | 5997538.48619649 | 2107080.3370833 | 37.7654994273486 | -122.451747836229 | (37.7654994273486, -122.451747836229) | ||
| 90210 | 90210 | 68387 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 4958 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32212 | 5997610.83894832 | 2105652.72144262 | 37.7615837000936 | -122.451394610435 | (37.7615837000936, -122.451394610435) | ||
| 90711 | 90711 | 68249 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 3531 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32050 | 6001184.87724579 | 2120700.92595518 | 37.8031062325164 | -122.440112611548 | (37.8031062325164, -122.440112611548) | ||
| 92312 | 92312 | 68409 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 175 Upland Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32245 | 5993925.68682399 | 2093845.21689491 | 37.7289515662137 | -122.463283120302 | (37.7289515662137, -122.463283120302) | ||
| 94088 | 94088 | 68326 | Permitted Site 1 | Tree(s) :: 17 | 850 Geary St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1993 12:00:00 AM | Permit Number 32141 | 6007649.0 | 2114433.0 | 37.786261944850395 | -122.41729885411101 | (37.7862619448504, -122.417298854111) | |||
| 94392 | 94392 | 68407 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 165 Upland Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32242 | 5993958.38777264 | 2093823.43780185 | 37.7288936500159 | -122.463168491943 | (37.7288936500159, -122.463168491943) | ||
| 95121 | 95121 | 59667 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 31 Rivoli St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32205 | 5998489.35496183 | 2105990.50764874 | 37.762561442192705 | -122.448380521343 | (37.7625614421927, -122.448380521343) | ||
| 95527 | 95527 | 68150 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 93 Carmel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 6 | 3x3 | Permit Number 32227 | 5998365.69600435 | 2105348.58128691 | 37.7607918027393 | -122.448761972471 | (37.7607918027393, -122.448761972471) |
| 95649 | 95649 | 68328 | Permitted Site 1 | Tree(s) :: 17 | 868 Geary St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1993 12:00:00 AM | Permit Number 32143 | 6007567.13351243 | 2114425.95501654 | 37.7862379948294 | -122.417581592145 | (37.7862379948294, -122.417581592145) | |||
| 96437 | 96437 | 54616 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1299X 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32025 | 5993308.52543353 | 2106661.72314321 | 37.764106858552395 | -122.46634776597601 | (37.7641068585524, -122.466347765976) | ||
| 97004 | 97004 | 68388 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 4977 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 15 | Permit Number 32213 | 5997544.8295208 | 2105597.02046098 | 37.7614269792514 | -122.451618890925 | (37.7614269792514, -122.451618890925) | |
| 97682 | 97682 | 66655 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2651 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32063 | 6010188.22288156 | 2103954.16792005 | 37.7576320274881 | -122.407774599356 | (37.7576320274881, -122.407774599356) | ||
| 98377 | 98377 | 68411 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 30 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32248 | 5993258.01081395 | 2093218.56512079 | 37.727192446615206 | -122.46554580002399 | (37.7271924466152, -122.465545800024) | ||
| 99906 | 99906 | 68316 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4347 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32129 | 5981524.64453606 | 2101444.07698557 | 37.749093709426496 | -122.506717055822 | (37.7490937094265, -122.506717055822) | ||
| 101964 | 101964 | 68382 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 44 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32207 | 5998400.19128361 | 2107252.91823315 | 37.76602260522 | -122.448779838039 | (37.76602260522, -122.448779838039) | ||
| 103014 | 103014 | 68417 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 66 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32259 | 5993402.69224521 | 2093420.82005948 | 37.727756132824204 | -122.46506032499599 | (37.7277561328242, -122.465060324996) | ||
| 103610 | 103610 | 68413 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 36 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32250 | 5993284.21892057 | 2093249.82284553 | 37.727279784230205 | -122.46545746928601 | (37.7272797842302, -122.465457469286) | ||
| 106433 | 106433 | 68404 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 145 Manor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32237 | 5993750.97528725 | 2093754.40622845 | 37.728692155597294 | -122.46388051726002 | (37.7286921555973, -122.46388051726) | ||
| 107361 | 107361 | 68395 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 80 Uranus Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32223 | 5999327.43077396 | 2105324.17051169 | 37.7607797259037 | -122.445434016999 | (37.7607797259037, -122.445434016999) | ||
| 107844 | 107844 | 58572 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 123 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32192 | 5997916.07271729 | 2106785.3576031 | 37.7647111062921 | -122.450420589527 | (37.7647111062921, -122.450420589527) | ||
| 109625 | 109625 | 68377 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 25 Carmel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32201 | 5998862.2729582 | 2105376.5533863 | 37.760896990982395 | -122.447046553817 | (37.7608969909824, -122.447046553817) | ||
| 109997 | 109997 | 68327 | Permitted Site 1 | Tree(s) :: 17 | 860 Geary St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1993 12:00:00 AM | Permit Number 32142 | 6007602.0 | 2114427.0 | 37.786242825943496 | -122.417461036957 | (37.7862428259435, -122.417461036957) | |||
| 111071 | 111071 | 68265 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 389 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32071 | 6009742.13570335 | 2092630.55377665 | 37.7265148648795 | -122.408518603248 | (37.7265148648795, -122.408518603248) | ||
| 111074 | 111074 | 68400 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 125 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32232 | 5993536.63286132 | 2093758.58525623 | 37.7286912757131 | -122.46462180958099 | (37.7286912757131, -122.464621809581) | ||
| 115070 | 115070 | 68266 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 400 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32072 | 6009713.40649943 | 2092546.71615196 | 37.7262830554111 | -122.408612007775 | (37.7262830554111, -122.408612007775) | ||
| 115196 | 115196 | 68333 | Permitted Site 1 | Tree(s) :: 17 | 2920 Anza | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1993 12:00:00 AM | Permit Number 32149 | 5989622.99350926 | 2111970.10160903 | 37.7784688651692 | -122.47948320644 | (37.7784688651692, -122.47948320644) | |||
| 116143 | 116143 | 68415 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 46 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32255 | 5993326.4106292995 | 2093305.92849605 | 37.7274362698778 | -122.465315687643 | (37.7274362698778, -122.465315687643) | ||
| 116243 | 116243 | 68384 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 48 Uranus Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32209 | 5999261.26474275 | 2105469.44655507 | 37.7611748403811 | -122.445673302467 | (37.7611748403811, -122.445673302467) | ||
| 116552 | 116552 | 68390 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 751 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32217 | 5998557.00831722 | 2107935.75884853 | 37.767906478991 | -122.448286617718 | (37.767906478991, -122.448286617718) | ||
| 117345 | 117345 | 51287 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 726 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 47659 | 5989465.45229129 | 2110387.70383509 | 37.774114887360504 | -122.479912367003 | (37.7741148873605, -122.479912367003) | ||
| 117519 | 117519 | 68376 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 240 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32200 | 5997045.02177864 | 2107064.07514711 | 37.7654265023069 | -122.453453434564 | (37.7654265023069, -122.453453434564) | ||
| 118150 | 118150 | 68260 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 330 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32066 | 6009617.65665916 | 2092860.11678258 | 37.7271382244341 | -122.408965114302 | (37.7271382244341, -122.408965114302) | ||
| 119134 | 119134 | 68399 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 10 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32230 | 5993170.65048654 | 2093114.37273837 | 37.7269013208382 | -122.465840234227 | (37.7269013208382, -122.465840234227) | ||
| 119349 | 119349 | 68408 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 170 Upland Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32243 | 5994001.22714578 | 2093857.38366654 | 37.7289893248225 | -122.46302285625299 | (37.7289893248225, -122.463022856253) | ||
| 119576 | 119576 | 68317 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1999X 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32130 | 5981353.71840295 | 2101490.23529545 | 37.7492103807501 | -122.50731153380801 | (37.7492103807501, -122.507311533808) | ||
| 119654 | 119654 | 54923 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 375 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32251 | 5992718.00411357 | 2094089.39765086 | 37.7295523769532 | -122.46747588141001 | (37.7295523769532, -122.46747588141) | ||
| 119967 | 119967 | 68268 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 415 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32074 | 6009781.29586625 | 2092503.00404445 | 37.726166833162104 | -122.408374234767 | (37.7261668331621, -122.408374234767) | ||
| 120212 | 120212 | 68334 | Permitted Site 1 | Tree(s) :: 17 | 2927 Anza | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1993 12:00:00 AM | Permit Number 32150 | 5989607.04648962 | 2111917.49677243 | 37.7783235006068 | -122.479534522766 | (37.7783235006068, -122.479534522766) | |||
| 121277 | 121277 | 68414 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 40 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32253 | 5993303.03759904 | 2093272.49781179 | 37.7273431294638 | -122.465394060178 | (37.7273431294638, -122.465394060178) | ||
| 121687 | 121687 | 68372 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1239 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32194 | 5998975.45653157 | 2105577.19771881 | 37.7614543762476 | -122.446669539944 | (37.7614543762476, -122.446669539944) | ||
| 121811 | 121811 | 68405 | Permitted Site 1 | Tree(s) :: 17 | 18 Westgate Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1993 12:00:00 AM | Permit Number 32239 | 5993026.07905892 | 2093299.29745924 | 37.72740073793 | -122.466353444337 | (37.72740073793, -122.466353444337) | |||
| 123429 | 123429 | 68369 | Permitted Site 1 | Tree(s) :: 17 | 1219 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1993 12:00:00 AM | Permit Number 32190 | 5999787.45489561 | 2090260.77177141 | 37.7194454618366 | -122.442761341724 | (37.7194454618366, -122.442761341724) | |||
| 124297 | 124297 | 59670 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 98X PARNASSUS AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 15 | 3x3 | Permit Number 32228 | 5998297.0 | 2106864.0 | 37.76494883262271 | -122.449108733904 | (37.7649488326227, -122.449108733904) |
| 126774 | 126774 | 68364 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 779 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32185 | 5990354.65344889 | 2110080.37975644 | 37.7733226803091 | -122.47681403851801 | (37.7733226803091, -122.476814038518) | ||
| 127658 | 127658 | 68264 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 381 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32070 | 6009731.82582651 | 2092664.31257859 | 37.72660698205 | -122.408556624594 | (37.72660698205, -122.408556624594) | ||
| 127902 | 127902 | 68391 | Permitted Site 1 | Tree(s) :: 17 | 759 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1993 12:00:00 AM | 3.5x4 | Permit Number 32219 | 5998564.2772658 | 2107883.68388152 | 37.7677639098986 | -122.448257725062 | (37.7677639098986, -122.448257725062) | ||
| 128174 | 128174 | 58473 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 755 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 5x4 | Permit Number 32218 | 5998560.64278981 | 2107909.72137719 | 37.767835194479396 | -122.448272171383 | (37.7678351944794, -122.448272171383) | |
| 129235 | 129235 | 68419 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 94 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32262 | 5993499.28123568 | 2093584.8530568 | 37.728212096332996 | -122.46473832451099 | (37.728212096333, -122.464738324511) | ||
| 129760 | 129760 | 68341 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 458 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 7 | Permit Number 32160 | 5989393.00779 | 2112223.27395 | 37.779150644402705 | -122.480297340035 | (37.7791506444027, -122.480297340035) | |
| 131187 | 131187 | 68304 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2143 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 10 | Permit Number 32115 | 5981679.3819 | 2100485.9202 | 37.746471989566395 | -122.506110947061 | (37.7464719895664, -122.506110947061) | |
| 133518 | 133518 | 68285 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1894 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 9 | Permit Number 32094 | 5981358.7272 | 2102199.6882 | 37.7511586335316 | -122.50734684264 | (37.7511586335316, -122.50734684264) | |
| 136422 | 136422 | 68345 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 476 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 9 | Permit Number 32164 | 5991274.14057 | 2112187.97332 | 37.7791628501622 | -122.47378722043301 | (37.7791628501622, -122.473787220433) | |
| 138146 | 138146 | 68235 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 123 Alhambra St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 11 | Permit Number 32030 | 6001689.71032 | 2120361.77725 | 37.8022037471652 | -122.43834131560499 | (37.8022037471652, -122.438341315605) | |
| 139722 | 139722 | 68255 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 235 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32060 | 6009537.98073102 | 2093299.04188101 | 37.7283389564803 | -122.409271515047 | (37.7283389564803, -122.409271515047) | ||
| 142116 | 142116 | 68322 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 68 Sycamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32137 | 6006464.26620293 | 2105877.23148989 | 37.7627031349161 | -122.420790105401 | (37.7627031349161, -122.420790105401) | ||
| 142476 | 142476 | 68375 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 175 Alma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32198 | 5997884.42699251 | 2106160.35589629 | 37.76299319850379 | -122.45048498278999 | (37.7629931985038, -122.45048498279) | ||
| 143588 | 143588 | 68299 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4745 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32108 | 5998482.53474968 | 2105647.70536793 | 37.7616198031918 | -122.44837942241301 | (37.7616198031918, -122.448379422413) |
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");