Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5146 | 5146 | 228435 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 178 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004070.0 | 2107898.0 | 37.7681164387884 | -122.429215116616 | (37.7681164387884, -122.429215116616) | |||
| 70920 | 70920 | 219180 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1785 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5994012.85069 | 2103371.98784 | 37.7551147123942 | -122.463672948647 | (37.7551147123942, -122.463672948647) | |||
| 117935 | 117935 | 48637 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1785 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45930 | 5994015.63459985 | 2103366.68968447 | 37.7551003254336 | -122.463662936643 | (37.7551003254336, -122.463662936643) | ||
| 138636 | 138636 | 48636 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1785 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | 10 | 3x3 | Permit Number 45930 | 5994015.63459985 | 2103366.68968447 | 37.7551003254336 | -122.463662936643 | (37.7551003254336, -122.463662936643) |
| 178475 | 178475 | 219179 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1785 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5994014.03321 | 2103382.75983 | 37.7551443576498 | -122.46366964095199 | (37.7551443576498, -122.463669640952) | |||
| 96195 | 96195 | 122809 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1801 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005422.0 | 2107198.0 | 37.7662708507612 | -122.424488887708 | (37.7662708507612, -122.424488887708) | ||||
| 105341 | 105341 | 122811 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1801 15th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005422.0 | 2107198.0 | 37.7662708507612 | -122.424488887708 | (37.7662708507612, -122.424488887708) | ||||
| 146097 | 146097 | 122810 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1801 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005422.0 | 2107198.0 | 37.7662708507612 | -122.424488887708 | (37.7662708507612, -122.424488887708) | ||||
| 167443 | 167443 | 67430 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1803 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/1992 12:00:00 AM | 7 | Permit Number 30932 | 5989942.29027 | 2110566.40136 | 37.774633233377706 | -122.4782759878 | (37.7746332333777, -122.4782759878) | |
| 181483 | 181483 | 120833 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1803 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5989987.953 | 2110566.55394 | 37.7746363029346 | -122.478118044214 | (37.7746363029346, -122.478118044214) | |||
| 155900 | 155900 | 228461 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1813 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6005355.14245 | 2107219.1964 | 37.766325275216296 | -122.424721643507 | (37.7663252752163, -122.424721643507) | |||
| 101754 | 101754 | 36675 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1815 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1998 12:00:00 AM | 15 | 3x3 | Permit Number 39480 | 6005408.20742805 | 2107215.17723629 | 37.7663172364539 | -122.42453781561001 | (37.7663172364539, -122.42453781561) | |
| 91318 | 91318 | 44081 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 184 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2000 12:00:00 AM | Permit Number 43602 | 5998965.98666911 | 2107110.22903087 | 37.765663155156105 | -122.44681260549 | (37.7656631551561, -122.44681260549) | |||
| 122875 | 122875 | 44082 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 184 Downey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2000 12:00:00 AM | Permit Number 43602 | 5998965.98666911 | 2107110.22903087 | 37.765663155156105 | -122.44681260549 | (37.7656631551561, -122.44681260549) | |||
| 136455 | 136455 | 228479 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 184 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5998955.25722 | 2107101.1921200003 | 37.7656377291263 | -122.446849065839 | (37.7656377291263, -122.446849065839) | |||
| 39026 | 39026 | 129088 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 190 Lombard St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6011425.38411 | 2120792.86026 | 37.803936329766294 | -122.40468136238 | (37.8039363297663, -122.40468136238) | |||
| 64722 | 64722 | 129090 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 190 Lombard St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6011386.68599 | 2120789.41334 | 37.803924702438394 | -122.404815037597 | (37.8039247024384, -122.404815037597) | |||
| 70029 | 70029 | 129087 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 190 Lombard St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6011445.1234 | 2120796.34037 | 37.803946988513104 | -122.40461329806801 | (37.8039469885131, -122.404613298068) | |||
| 147535 | 147535 | 129089 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 190 Lombard St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6011405.84379 | 2120790.43469 | 37.8039285776094 | -122.40474881240601 | (37.8039285776094, -122.404748812406) | |||
| 19165 | 19165 | 10233 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 20 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005984.609 | 2109698.904 | 37.77316949126 | -122.422720671561 | (37.77316949126, -122.422720671561) | |||
| 46527 | 46527 | 30692 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 20 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52599 | 6005954.788 | 2109697.461 | 37.7731638465829 | -122.42282372387301 | (37.7731638465829, -122.422823723873) | |
| 140495 | 140495 | 30691 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 20 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/2009 12:00:00 AM | 3x3 | Permit Number 52599 | 6006108.61199537 | 2109713.28983155 | 37.773215986766296 | -122.422292750625 | (37.7732159867663, -122.422292750625) | ||
| 30449 | 30449 | 143026 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2027 POWELL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6009443.5652 | 2120635.2508 | 37.80339260933211 | -122.411528458224 | (37.8033926093321, -122.411528458224) | |||
| 167422 | 167422 | 78131 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 2040 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53996 | 6000457.66404 | 2121004.4785 | 37.8038982794373 | -122.442650952296 | (37.8038982794373, -122.442650952296) |
| 104856 | 104856 | 10264 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 212 Haight St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6005102.223809999 | 2109572.2105099997 | 37.7727717979426 | -122.42576394022 | (37.7727717979426, -122.42576394022) | |||
| 121627 | 121627 | 10266 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 212 Haight St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005102.223809999 | 2109572.2105099997 | 37.7727717979426 | -122.42576394022 | (37.7727717979426, -122.42576394022) | |||
| 140820 | 140820 | 10265 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 212 Haight St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6005102.223809999 | 2109572.2105099997 | 37.7727717979426 | -122.42576394022 | (37.7727717979426, -122.42576394022) | |||
| 54440 | 54440 | 228473 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 214 Haight St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6004983.40723 | 2109552.71485 | 37.7727115526285 | -122.426173552181 | (37.7727115526285, -122.426173552181) | |||
| 174174 | 174174 | 228474 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 214 Haight St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004967.29881 | 2109550.52085 | 37.772704617954105 | -122.42622911677601 | (37.7727046179541, -122.426229116776) | |||
| 181692 | 181692 | 228475 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 214 Haight St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6004951.6216 | 2109548.73886 | 37.772698838907 | -122.426283219097 | (37.772698838907, -122.426283219097) | |||
| 168166 | 168166 | 228462 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 227 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007175.76045 | 2107902.73822 | 37.768304778378294 | -122.418472926402 | (37.7683047783783, -122.418472926402) | |||
| 74585 | 74585 | 228472 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 227 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004182.38579 | 2107503.9785 | 37.767040912528294 | -122.428798292811 | (37.7670409125283, -122.428798292811) | |||
| 91972 | 91972 | 93314 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 227 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004180.0 | 2107540.0 | 37.7671396838414 | -122.42880911313999 | (37.7671396838414, -122.42880911314) | ||
| 116747 | 116747 | 61667 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 235 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/2016 12:00:00 AM | 3 | Permit Number 777577 | 6004178.04494694 | 2107496.55994699 | 37.7670202972864 | -122.42881277819099 | (37.7670202972864, -122.428812778191) | |
| 155607 | 155607 | 228471 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 237 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004185.6843 | 2107453.8801 | 37.7669035410995 | -122.428783311922 | (37.7669035410995, -122.428783311922) | |||
| 91782 | 91782 | 93313 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 241 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004184.0 | 2107469.0 | 37.766944961369 | -122.428790215647 | (37.766944961369, -122.428790215647) | ||
| 6152 | 6152 | 34989 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 2447 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/1997 12:00:00 AM | 10 | Permit Number 38568 | 6002987.46694 | 2116484.72723 | 37.7916321004801 | -122.433573216253 | (37.7916321004801, -122.433573216253) | ||
| 104608 | 104608 | 93312 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 245 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004185.0 | 2107449.0 | 37.7668901027922 | -122.428785330871 | (37.7668901027922, -122.428785330871) | ||
| 168299 | 168299 | 228470 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 245 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004187.12028 | 2107418.48366 | 37.766806432287 | -122.42877582146299 | (37.766806432287, -122.428775821463) | |||
| 186493 | 186493 | 228463 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 246 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006676.82806 | 2104669.9679099997 | 37.7594002490446 | -122.419969252575 | (37.7594002490446, -122.419969252575) | |||
| 85917 | 85917 | 35327 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 248 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2016 12:00:00 AM | Permit Number 775509 | 6006668.16520495 | 2104669.17235853 | 37.759397576581 | -122.41999915657499 | (37.759397576581, -122.419999156575) | ||
| 179503 | 179503 | 228469 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 251 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004187.68386 | 2107403.8081400003 | 37.766766168745896 | -122.428772825825 | (37.7667661687459, -122.428772825825) | |||
| 100180 | 100180 | 93311 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 253 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004187.0 | 2107409.0 | 37.766780385636395 | -122.428775561342 | (37.7667803856364, -122.428775561342) | ||
| 100362 | 100362 | 42081 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 254 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42391 | 6008092.42384606 | 2100220.76756697 | 37.7472634047037 | -122.41475853876999 | (37.7472634047037, -122.41475853877) | ||
| 60274 | 60274 | 228460 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2625 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010714.680480001 | 2102241.99741 | 37.7529602452298 | -122.40583328059601 | (37.7529602452298, -122.405833280596) | |||
| 161170 | 161170 | 67435 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 2632 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/1992 12:00:00 AM | 6 | Permit Number 30937 | 5990433.164530001 | 2112001.81298 | 37.7786029615899 | -122.47668286606199 | (37.7786029615899, -122.476682866062) | |
| 87419 | 87419 | 32861 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 27 Homestead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37208 | 6000989.97871227 | 2101553.81963673 | 37.7505220253917 | -122.439413745994 | (37.7505220253917, -122.439413745994) | ||
| 161401 | 161401 | 228484 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 27 Homestead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6000983.78885 | 2101507.81072 | 37.750395343677795 | -122.439431853304 | (37.7503953436778, -122.439431853304) | |||
| 21376 | 21376 | 29881 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 270 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6006056.280590001 | 2108026.10587 | 37.7685804313738 | -122.42235387246001 | (37.7685804313738, -122.42235387246) | |||
| 105905 | 105905 | 29880 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 270 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/2006 12:00:00 AM | 3 | 3x3 | 6006057.16025 | 2108040.46288 | 37.76861990192471 | -122.42235185 | (37.7686199019247, -122.42235185) | ||
| 173298 | 173298 | 228431 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 270 Valencia St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6006055.135530001 | 2108039.7727 | 37.7686178926417 | -122.42235880430799 | (37.7686178926417, -122.422358804308) | |||
| 56231 | 56231 | 228455 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 7 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009383.67351 | 2106374.02164 | 37.7642313225287 | -122.410727961341 | (37.7642313225287, -122.410727961341) | |||
| 57920 | 57920 | 228456 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 8 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009403.2734199995 | 2106375.12773 | 37.7642354585115 | -122.410660248687 | (37.7642354585115, -122.410660248687) | |||
| 68876 | 68876 | 228449 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009256.91005 | 2106366.76259 | 37.76420428262279 | -122.411165888909 | (37.7642042826228, -122.411165888909) | |||
| 73664 | 73664 | 228453 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 5 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009339.05918 | 2106371.48119 | 37.7642218454873 | -122.41088209075899 | (37.7642218454873, -122.410882090759) | |||
| 149630 | 149630 | 228454 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 6 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009362.10361 | 2106372.48972 | 37.7642259068175 | -122.410802457572 | (37.7642259068175, -122.410802457572) | |||
| 153175 | 153175 | 228452 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 4 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009318.2366 | 2106370.18067 | 37.7642171069559 | -122.41095401853799 | (37.7642171069559, -122.410954018538) | |||
| 160222 | 160222 | 228451 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009297.41402 | 2106368.8801700003 | 37.7642123684355 | -122.411025946309 | (37.7642123684355, -122.411025946309) | |||
| 166771 | 166771 | 228450 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009278.09164 | 2106368.2886 | 37.764209660560205 | -122.41109273536699 | (37.7642096605602, -122.411092735367) | |||
| 188130 | 188130 | 228457 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 9 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009423.8763 | 2106376.9257400003 | 37.7642415505399 | -122.410589115888 | (37.7642415505399, -122.410589115888) | |||
| 125756 | 125756 | 65015 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 278 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/2011 12:00:00 AM | 3 | 2x3 | Permit Number 768137 | 6007725.96636 | 2097829.89859682 | 37.74067801414021 | -122.415856451174 | (37.7406780141402, -122.415856451174) | |
| 89343 | 89343 | 36994 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 2818 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | Permit Number 39614 | 6009898.14777577 | 2102820.5904951002 | 37.754503234678005 | -122.408697833051 | (37.754503234678, -122.408697833051) | ||
| 30267 | 30267 | 228488 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2880 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008610.437969999 | 2106311.71269 | 37.7640168522296 | -122.413397964868 | (37.7640168522296, -122.413397964868) | |||
| 68672 | 68672 | 228487 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2880 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008652.20159 | 2106330.0546 | 37.764069559682206 | -122.41325481347401 | (37.7640695596822, -122.413254813474) | |||
| 102377 | 102377 | 93232 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 292 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004136.0 | 2107205.0 | 37.766217364214604 | -122.42893741621 | (37.7662173642146, -122.42893741621) | ||
| 159222 | 159222 | 228434 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 292 Church St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6004130.46793 | 2107245.14017 | 37.7663272663153 | -122.428959412666 | (37.7663272663153, -122.428959412666) | |||
| 5169 | 5169 | 228433 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 300 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004139.02513 | 2107107.02985 | 37.7659485330168 | -122.4289199675 | (37.7659485330168, -122.4289199675) | |||
| 167042 | 167042 | 228432 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 300 Church St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6004140.61494 | 2107068.90552 | 37.7658439427747 | -122.42891175039301 | (37.7658439427747, -122.428911750393) | |||
| 113551 | 113551 | 39284 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 3000X 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 5 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 142789 | 142789 | 39301 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 3000X 17th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 5 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 83968 | 83968 | 49189 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 301 Guerrero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46293 | 6005519.89358109 | 2107236.54938111 | 37.7663822259368 | -122.424153033894 | (37.7663822259368, -122.424153033894) | |||
| 50045 | 50045 | 190657 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 301 Mendell St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6016835.36544 | 2097808.79392 | 37.7411279765664 | -122.38435784693998 | (37.7411279765664, -122.38435784694) | |||
| 183998 | 183998 | 228468 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 305 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004204.63343 | 2107110.4699 | 37.765961691906796 | -122.42869328709101 | (37.7659616919068, -122.428693287091) | |||
| 143858 | 143858 | 93234 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 306 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/19/2012 12:00:00 AM | 3 | 3x3 | 6004157.4 | 2107119.9 | 37.7659849113858 | -122.428857330216 | (37.7659849113858, -122.428857330216) | ||
| 78468 | 78468 | 93310 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 307 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004202.0 | 2107132.0 | 37.7660206593376 | -122.428703930527 | (37.7660206593376, -122.428703930527) | ||
| 143449 | 143449 | 93309 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 309 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/04/2016 12:00:00 AM | 3 | 3x3 | 6004203.0 | 2107120.0 | 37.7659877668224 | -122.428699616217 | (37.7659877668224, -122.428699616217) | ||
| 186641 | 186641 | 228467 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 309 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004207.05311 | 2107076.17172 | 37.7658676543027 | -122.428682472728 | (37.7658676543027, -122.428682472728) | |||
| 69661 | 69661 | 190652 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 310 Arkansas St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6012893.9262 | 2105541.86403 | 37.7621425904374 | -122.39852852018299 | (37.7621425904374, -122.398528520183) | |||
| 31656 | 31656 | 228466 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 315 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004209.32869 | 2107056.55416 | 37.7658139179905 | -122.42867320340599 | (37.7658139179905, -122.428673203406) | |||
| 112069 | 112069 | 93308 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 315 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/23/2015 01:54:00 PM | 3 | 3x3 | 6004205.0 | 2107085.0 | 37.7658917784387 | -122.428690203394 | (37.7658917784387, -122.428690203394) | ||
| 116435 | 116435 | 53916 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 319 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/1972 12:00:00 AM | 13 | Permit Number 9628 | 6012951.97966 | 2105523.30262 | 37.762094858908206 | -122.398326431733 | (37.7620948589082, -122.398326431733) | ||
| 172245 | 172245 | 190653 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 320 Arkansas St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6012892.66651 | 2105479.7779900003 | 37.7619720457008 | -122.398528520179 | (37.7619720457008, -122.398528520179) | |||
| 141850 | 141850 | 27324 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 320 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/24/2015 09:31:00 AM | 3 | 4x4 | 6004588.93351 | 2109631.91786 | 37.7729067207461 | -122.42754372417801 | (37.7729067207461, -122.427543724178) | ||
| 159768 | 159768 | 228465 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 321 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004210.24642 | 2107036.07535 | 37.7657577400449 | -122.42866856921101 | (37.7657577400449, -122.428668569211) | |||
| 174253 | 174253 | 190654 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 330 Arkansas St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6012898.89819 | 2105464.4496299997 | 37.7619303045744 | -122.398505891451 | (37.7619303045744, -122.398505891451) | |||
| 118603 | 118603 | 35763 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 3321 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/2003 12:00:00 AM | Permit Number 39025 | 6006713.03914548 | 2106101.29867165 | 37.7633323895219 | -122.41994558786999 | (37.7633323895219, -122.41994558787) | ||
| 127481 | 127481 | 35764 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 3321 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/2003 12:00:00 AM | Permit Number 39025 | 6006713.03914548 | 2106101.29867165 | 37.7633323895219 | -122.41994558786999 | (37.7633323895219, -122.41994558787) | ||
| 117984 | 117984 | 91210 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 333 Haight St | 1 | Sidewalk: Curb side : 21 | Tree 1 | DPW 2 | 02/15/2008 12:00:00 AM | 3 | 6004540.59043 | 2109422.99046 | 37.7723303224715 | -122.427696060061 | (37.7723303224715, -122.427696060061) | |||
| 102751 | 102751 | 93183 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 353 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/2010 12:00:00 AM | 3 | 3x3 | 6004447.0 | 2109433.0 | 37.7723525117512 | -122.428020511442 | (37.7723525117512, -122.428020511442) | ||
| 180413 | 180413 | 228448 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 353 Haight St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6004452.39919 | 2109432.87501 | 37.7723524740195 | -122.42800182623002 | (37.7723524740195, -122.42800182623) | |||
| 52316 | 52316 | 190655 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 354 Arkansas St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6012900.86657 | 2105367.98453 | 37.7616655423506 | -122.398492314369 | (37.7616655423506, -122.398492314369) | |||
| 3093 | 3093 | 124473 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 356 Willard St North | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/03/2002 12:00:00 AM | 5 | Width 3ft | Permit Number 45077 | 5996305.70499 | 2110483.22678 | 37.774772198948796 | -122.456257787006 | (37.7747721989488, -122.456257787006) | |
| 35360 | 35360 | 190656 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 358 Arkansas St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6012906.49923 | 2105280.1318200002 | 37.7614246319699 | -122.39846666842101 | (37.7614246319699, -122.398466668421) | |||
| 47929 | 47929 | 228459 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 3632 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006042.870080001 | 2100850.33706 | 37.748876688223795 | -122.421890467095 | (37.7488766882238, -122.421890467095) | |||
| 85659 | 85659 | 43634 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 3632 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2000 12:00:00 AM | Permit Number 43284 | 6006090.90673928 | 2100856.20266776 | 37.7488955027959 | -122.42172477262301 | (37.7488955027959, -122.421724772623) | ||
| 99299 | 99299 | 91209 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 365 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2007 12:00:00 AM | 3 | 3x3 | 6004404.0966 | 2109354.51914 | 37.7721345950401 | -122.428163324287 | (37.7721345950401, -122.428163324287) | ||
| 165619 | 165619 | 228447 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 365 Haight St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6004400.01174 | 2109424.0096400003 | 37.7723251679145 | -122.428182407399 | (37.7723251679145, -122.428182407399) | |||
| 91452 | 91452 | 48986 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 372 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/2005 12:00:00 AM | Permit Number 46173 | 6004094.60882476 | 2100160.1254271 | 37.7468714608035 | -122.428578362797 | (37.7468714608035, -122.428578362797) | ||
| 63250 | 63250 | 228464 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 3746 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6005334.7155 | 2104318.69082 | 37.7583600194211 | -122.424585951974 | (37.7583600194211, -122.424585951974) | |||
| 89601 | 89601 | 35493 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 3746 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38903 | 6005339.71347882 | 2104322.52965211 | 37.7583708422124 | -122.42456893980601 | (37.7583708422124, -122.424568939806) |
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");