trees
74 rows where qSpecies_id = 236
This data as json, CSV (advanced)
| rowid ▼ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2526 | 236248 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 3436 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006579.89851 | 2105554.96639 | 37.7618247871083 | -122.42036729883 | (37.7618247871083, -122.42036729883) | 8 | 4 | 7 | 28859 | 19 | |||
| 5293 | 211866 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 205 Granada Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5995618.9525 | 2091298.42556 | 37.7220560916948 | -122.457245251185 | (37.7220560916948, -122.457245251185) | 9 | 8 | 4 | 28861 | 24 | |||
| 6600 | 139319 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 1322 Geary Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6005281.603 | 2114195.139 | 37.7854753615205 | -122.42547250629 | (37.7854753615205, -122.42547250629) | 13 | 9 | 11 | 28858 | 13 | |||
| 7173 | 70648 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 239 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6004288.74767 | 2092010.61731 | 37.7245057379221 | -122.427326611657 | (37.7245057379221, -122.427326611657) | 9 | 7 | 6 | 28861 | 5 | |||
| 15732 | 142619 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 725 GREENWICH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6009396.4961 | 2120122.6363 | 37.8019824571048 | -122.411655102339 | (37.8019824571048, -122.411655102339) | 3 | 1 | 10 | 308 | 23 | |||
| 20992 | 236212 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 1440 Treat Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008697.40292 | 2100727.7342 | 37.748689395406 | -122.41270239321 | (37.748689395406, -122.41270239321) | 2 | 4 | 7 | 28859 | 19 | |||
| 24961 | 236216 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 156 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007329.10102 | 2098137.78644 | 37.741501086421 | -122.417250476125 | (37.741501086421, -122.417250476125) | 2 | 7 | 7 | 28859 | 2 | |||
| 31314 | 236221 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 766 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006214.88989 | 2105148.65621 | 37.7606885791281 | -122.421600862005 | (37.7606885791281, -122.421600862005) | 2 | 4 | 5 | 28859 | 19 | |||
| 35490 | 236228 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 584 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006156.95969 | 2106198.14584 | 37.7635669645678 | -122.421875767666 | (37.7635669645678, -122.421875767666) | 8 | 4 | 5 | 28859 | 19 | |||
| 40253 | 139320 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 1330 Geary Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6005252.9062 | 2114191.0395 | 37.7854624838826 | -122.425571496934 | (37.7854624838826, -122.425571496934) | 13 | 9 | 11 | 28858 | 13 | |||
| 40562 | 236239 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 538 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006143.58613 | 2106470.49534 | 37.7643140178894 | -122.421941370505 | (37.7643140178894, -122.421941370505) | 8 | 4 | 5 | 28859 | 19 | |||
| 42419 | 139326 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 1360 Geary Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6005071.5013 | 2114164.734 | 37.7853800038342 | -122.426197231039 | (37.7853800038342, -122.426197231039) | 13 | 9 | 11 | 28858 | 13 | |||
| 48544 | 236233 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 560 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006154.35869 | 2106335.36124 | 37.7639435790469 | -122.421894511333 | (37.7639435790469, -122.421894511333) | 8 | 4 | 5 | 28859 | 19 | |||
| 50098 | 236237 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 542 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006148.19059 | 2106430.82622 | 37.7642053555191 | -122.421922626833 | (37.7642053555191, -122.421922626833) | 8 | 4 | 5 | 28859 | 19 | |||
| 50327 | 142617 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 725 GREENWICH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6009365.5599 | 2120118.4807 | 37.8019693114427 | -122.411761862829 | (37.8019693114427, -122.411761862829) | 3 | 1 | 10 | 308 | 23 | |||
| 52085 | 211865 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 1274 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993644.44801 | 2106831.85611 | 37.7645933761047 | -122.465198275302 | (37.7645933761047, -122.465198275302) | 11 | 8 | 11 | 56 | 12 | |||
| 52710 | 23006 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 766 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/1994 12:00:00 AM | 8 | 3X3 | 6006218.84128 | 2105121.14144 | 37.7606132528131 | -122.421585241678 | (37.7606132528131, -122.421585241678) | 2 | 4 | 5 | 28859 | 19 | ||
| 55092 | 236227 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 620 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006175.69314 | 2105878.91297 | 37.762691482659 | -122.421788297817 | (37.762691482659, -122.421788297817) | 8 | 4 | 5 | 28859 | 19 | |||
| 66015 | 22998 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 714 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/23/1994 12:00:00 AM | 8 | 6006205.20873 | 2105402.95089 | 37.7613862668816 | -122.421652406646 | (37.7613862668816, -122.421652406646) | 2 | 4 | 5 | 28859 | 19 | |||
| 66052 | 236229 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 582 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006153.79144 | 2106219.79715 | 37.7636262352912 | -122.421888263736 | (37.7636262352912, -122.421888263736) | 8 | 4 | 5 | 28859 | 19 | |||
| 68905 | 236230 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 580 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006152.80663 | 2106237.80569 | 37.7636756269614 | -122.421892949195 | (37.7636756269614, -122.421892949195) | 8 | 4 | 5 | 28859 | 19 | |||
| 69934 | 110114 | Undocumented 4 | Platanus racemosa :: California Sycamore 236 | 463 TEXAS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013849.1 | 2104943.7 | 37.76055332945 | -122.395183013377 | (37.76055332945, -122.395183013377) | 10 | 3 | 8 | 28856 | 29 | ||||
| 72824 | 245048 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 156 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6000820.7156 | 2109539.1628 | 37.7724381819414 | -122.440571749918 | (37.7724381819414, -122.440571749918) | 15 | 5 | 11 | 29492 | 9 | |||
| 72958 | 236217 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 328 Highland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007040.37256 | 2096523.99487 | 37.7370537248361 | -122.418134418894 | (37.7370537248361, -122.418134418894) | 2 | 7 | 7 | 28859 | 2 | |||
| 73705 | 236232 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 560 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006154.39468 | 2106315.12369 | 37.7638880135333 | -122.421892949197 | (37.7638880135333, -122.421892949197) | 8 | 4 | 5 | 28859 | 19 | |||
| 76700 | 112037 | Permitted Site 7 | Platanus racemosa :: California Sycamore 236 | 147 Buena Vista Ave East | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775853 | 6001347.6 | 2108501.5 | 37.7696190072387 | -122.438674842908 | (37.7696190072387, -122.438674842908) | 15 | 5 | 5 | 29492 | 9 | |
| 77153 | 236223 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 748 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006211.88041 | 2105222.02359 | 37.7608898590889 | -122.421616481433 | (37.7608898590889, -122.421616481433) | 2 | 4 | 5 | 28859 | 19 | |||
| 81402 | 236219 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 786 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006236 | 2105017 | 37.760328272277 | -122.421518501011 | (37.760328272277, -122.421518501011) | 2 | 4 | 5 | 28859 | 19 | |||
| 85946 | 139307 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 1499 Post St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6005420.8268 | 2114423.2928 | 37.7861096804798 | -122.425007071523 | (37.7861096804798, -122.425007071523) | 13 | 9 | 11 | 28858 | 13 | |||
| 86208 | 23004 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 762 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | 3X3 | 6006215.9045 | 2105176.06867 | 37.7607639045409 | -122.421599299894 | (37.7607639045409, -122.421599299894) | 2 | 4 | 5 | 28859 | 19 | |||
| 86252 | 236245 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 521 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006205.90235 | 2106536.22169 | 37.7644980012145 | -122.421730504658 | (37.7644980012145, -122.421730504658) | 8 | 4 | 7 | 28859 | 19 | |||
| 88946 | 236246 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 525 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006205.9381 | 2106515.98414 | 37.7644424356907 | -122.421728943463 | (37.7644424356907, -122.421728943463) | 8 | 4 | 7 | 28859 | 19 | |||
| 91589 | 236243 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 504 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/24/2017 02:20:00 PM | 3 | Width 3ft | 6006138.12079 | 2106622.15868 | 37.7647301413986 | -122.421971048125 | (37.7647301413986, -122.421971048125) | 8 | 4 | 5 | 28859 | 19 | ||
| 92402 | 108658 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 30 Almaden Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774610 | 5995890.4686 | 2112526.48313 | 37.7803585963561 | -122.457842053153 | (37.7803585963561, -122.457842053153) | 11 | 6 | 2 | 54 | 16 |
| 99610 | 23002 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 742 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/23/1994 12:00:00 AM | 20 | 3X3 | 6006210.14027 | 2105247.24413 | 37.7609590106658 | -122.421624291141 | (37.7609590106658, -122.421624291141) | 2 | 4 | 5 | 28859 | 19 | ||
| 102278 | 236210 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 147 Carmel St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5997997.44772 | 2105333.13475 | 37.7607283255725 | -122.450034460036 | (37.7607283255725, -122.450034460036) | 15 | 5 | 11 | 29492 | 12 | |||
| 104411 | 236214 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 158 Bocana St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007313.34504 | 2098108.27694 | 37.7414191734549 | -122.417302864348 | (37.7414191734549, -122.417302864348) | 2 | 7 | 7 | 28859 | 2 | |||
| 107650 | 236231 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 560 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006156.6323 | 2106292.1424 | 37.7638250385181 | -122.42188357737 | (37.7638250385181, -122.42188357737) | 8 | 4 | 5 | 28859 | 19 | |||
| 112609 | 236241 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 522 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006144.62946 | 2106521.29096 | 37.7644535495198 | -122.421941370498 | (37.7644535495198, -122.421941370498) | 8 | 4 | 5 | 28859 | 19 | |||
| 115791 | 236240 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 528 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006144.58233 | 2106497.00749 | 37.7643868701822 | -122.421939808379 | (37.7643868701822, -122.421939808379) | 8 | 4 | 5 | 28859 | 19 | |||
| 120078 | 139297 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 1499 Post St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6005181.8124 | 2114392.183 | 37.7860107566115 | -122.425831783054 | (37.7860107566115, -122.425831783054) | 13 | 9 | 11 | 28858 | 13 | |||
| 122167 | 236242 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 510 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006140.29277 | 2106573.99555 | 37.7645980193081 | -122.421960114183 | (37.7645980193081, -122.421960114183) | 8 | 4 | 5 | 28859 | 19 | |||
| 122228 | 6357 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 2020X Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/14/2012 12:00:00 AM | 12 | 4X4 | Permit Number 768573 | 6001173.6622 | 2112841.531 | 37.7815257425696 | -122.439587660215 | (37.7815257425696, -122.439587660215) | 15 | 5 | 11 | 29490 | 41 | |
| 123741 | 22968 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 572 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/04/2010 12:00:00 AM | 3 | 3x3 | 6006154.71472 | 2106264.74945 | 37.7637497157878 | -122.421888263744 | (37.7637497157878, -122.421888263744) | 8 | 4 | 5 | 28859 | 19 | ||
| 128160 | 245049 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 156 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6000818.7213 | 2109552.7904 | 37.7724754863462 | -122.440579625992 | (37.7724754863462, -122.440579625992) | 15 | 5 | 11 | 29492 | 9 | |||
| 129063 | 22965 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 522 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3X3 | 6006140.66017 | 2106547.90509 | 37.7645264017829 | -122.421956989922 | (37.7645264017829, -122.421956989922) | 8 | 4 | 5 | 28859 | 19 | |||
| 129244 | 236226 | Undocumented 4 | Platanus racemosa :: California Sycamore 236 | 686 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006191.11311 | 2105618.20849 | 37.7619765189329 | -122.421716447361 | (37.7619765189329, -122.421716447361) | 8 | 4 | 5 | 28859 | 19 | |||
| 130157 | 6358 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 2020X Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/14/2012 12:00:00 AM | 12 | 4X4 | Permit Number 768573 | 6001159.1101 | 2112838.4852 | 37.7815165513387 | -122.43963778496 | (37.7815165513387, -122.43963778496) | 15 | 5 | 11 | 29490 | 41 | |
| 131376 | 139325 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 1352 Geary Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6005111.8135 | 2114171.5666 | 37.7854010428944 | -122.426058249419 | (37.7854010428944, -122.426058249419) | 13 | 9 | 11 | 28858 | 13 | |||
| 133286 | 139293 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 1499 Post St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6005109.4757 | 2114379.0309 | 37.7859705561221 | -122.426081111968 | (37.7859705561221, -122.426081111968) | 13 | 9 | 11 | 28858 | 13 | |||
| 134450 | 236208 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 147 Carmel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5997930.12293 | 2105328.91939 | 37.7607128985969 | -122.450267001345 | (37.7607128985969, -122.450267001345) | 15 | 5 | 11 | 29492 | 12 | |||
| 135564 | 22995 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 692 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/13/2017 12:00:00 AM | 7 | 3X6 | 6006189.81318 | 2105598.89712 | 37.7619234211376 | -122.421719571617 | (37.7619234211376, -122.421719571617) | 8 | 4 | 5 | 28859 | 19 | ||
| 142500 | 236244 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 515 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006205.61798 | 2106566.35806 | 37.7645807325428 | -122.421733628917 | (37.7645807325428, -122.421733628917) | 8 | 4 | 7 | 28859 | 19 | |||
| 146061 | 236236 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 546 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006147.12053 | 2106400.71799 | 37.764122625071 | -122.421924188966 | (37.764122625071, -122.421924188966) | 8 | 4 | 5 | 28859 | 19 | |||
| 147611 | 195017 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 400 Bay Shore Blvd | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6010318.42243 | 2097886.76378 | 37.7409795578731 | -122.406896690241 | (37.7409795578731, -122.406896690241) | 10 | 3 | 7 | 58 | 2 | |||
| 157017 | 236234 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 550 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006151.62345 | 2106356.10426 | 37.7640003802343 | -122.421905445301 | (37.7640003802343, -122.421905445301) | 8 | 4 | 5 | 28859 | 19 | |||
| 157621 | 236238 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 540 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006147.07627 | 2106442.54162 | 37.7642374604008 | -122.421927313222 | (37.7642374604008, -122.421927313222) | 8 | 4 | 5 | 28859 | 19 | |||
| 159006 | 99716 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 1415 Scott St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6001693.2243 | 2113487.1552 | 37.7833280195253 | -122.437836484122 | (37.7833280195253, -122.437836484122) | 15 | 5 | 11 | 29490 | 41 | |||
| 160688 | 236218 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 121 Montcalm St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6010287.26729 | 2099820.79013 | 37.7462882307142 | -122.407140708685 | (37.7462882307142, -122.407140708685) | 2 | 7 | 7 | 28859 | 2 | |||
| 160721 | 142618 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 725 GREENWICH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6009381.7206 | 2120120.7894 | 37.8019765571324 | -122.41170610218 | (37.8019765571324, -122.41170610218) | 3 | 1 | 10 | 308 | 23 | |||
| 160940 | 236225 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 720 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006208.17404 | 2105371.4094 | 37.7612998285493 | -122.421639910554 | (37.7612998285493, -122.421639910554) | 2 | 4 | 5 | 28859 | 19 | |||
| 161618 | 256559 | Undocumented 4 | Platanus racemosa :: California Sycamore 236 | 1x Berwick Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010388 | 2110191 | 37.7747681281905 | -122.407523394765 | (37.7747681281905, -122.407523394765) | 8 | 2 | 9 | 28853 | 34 | ||||
| 162314 | 236211 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 332 Highland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6007085.90123 | 2096525.95828 | 37.7370616784392 | -122.417977144556 | (37.7370616784392, -122.417977144556) | 2 | 7 | 7 | 28859 | 2 | |||
| 162800 | 236213 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 25 Woodland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5997032.77964 | 2106429.41468 | 37.7636831848474 | -122.453449950272 | (37.7636831848474, -122.453449950272) | 15 | 5 | 11 | 29492 | 12 | |||
| 164781 | 141158 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 2013 Geary Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6001875.9402 | 2113580.1259 | 37.7835936815677 | -122.437211019524 | (37.7835936815677, -122.437211019524) | 13 | 5 | 11 | 29490 | 41 | |||
| 166968 | 139315 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 1302 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6005403.9061 | 2114211.5372 | 37.7855272963528 | -122.425050540554 | (37.7855272963528, -122.425050540554) | 13 | 9 | 11 | 28858 | 13 | |||
| 168329 | 236235 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 550 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006150.31645 | 2106380.41521 | 37.7640670586624 | -122.42191169288 | (37.7640670586624, -122.42191169288) | 8 | 4 | 5 | 28859 | 19 | |||
| 175121 | 236222 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 758 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6006212.30332 | 2105198.62923 | 37.7608256474983 | -122.421613357168 | (37.7608256474983, -122.421613357168) | 2 | 4 | 5 | 28859 | 19 | |||
| 180029 | 236224 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 740 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/23/1994 12:00:00 AM | 7 | Width 3ft | 6006211.6156 | 2105275.09716 | 37.7610355717565 | -122.421621166906 | (37.7610355717565, -122.421621166906) | 2 | 4 | 5 | 28859 | 19 | ||
| 182695 | 236247 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 533 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006207.20848 | 2106489.87514 | 37.7643708181708 | -122.421722694953 | (37.7643708181708, -122.421722694953) | 8 | 4 | 7 | 28859 | 19 | |||
| 185108 | 236209 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 147 Carmel St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5997968.35291 | 2105330.47298 | 37.7607193521288 | -122.45013489361 | (37.7607193521288, -122.45013489361) | 15 | 5 | 11 | 29492 | 12 | |||
| 185534 | 236215 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 158 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007320.88948 | 2098123.55291 | 37.7414615423295 | -122.417277860482 | (37.7414615423295, -122.417277860482) | 2 | 7 | 7 | 28859 | 2 | |||
| 190449 | 236220 | DPW Maintained 1 | Platanus racemosa :: California Sycamore 236 | 780 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006220.52605 | 2105093.22352 | 37.7605366917327 | -122.421577431964 | (37.7605366917327, -122.421577431964) | 2 | 4 | 5 | 28859 | 19 | |||
| 191263 | 112038 | Permitted Site 7 | Platanus racemosa :: California Sycamore 236 | 147 Buena Vista Ave East | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775853 | 6001347.6 | 2108501.5 | 37.7696190072387 | -122.438674842908 | (37.7696190072387, -122.438674842908) | 15 | 5 | 5 | 29492 | 9 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );