Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qCaretaker, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
730 | 730 | 195047 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 360 06th St | 2 | : 4 | Tree 1 | DPW 2 | 03/26/2005 12:00:00 AM | 3 | Width 3ft | Permit Number 42039 | 6011214.59355 | 2111232.18316 | 37.777673209496605 | -122.404737337955 | (37.7776732094966, -122.404737337955) | |
748 | 748 | 195045 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 312 06th St | 1 | : 4 | Tree 1 | DPW 2 | 10 | Width 3ft | 6010980.17572 | 2111476.79231 | 37.7783317443601 | -122.40556550564501 | (37.7783317443601, -122.405565505645) | |||
761 | 761 | 195041 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 402 06th St | 1 | : 4 | Tree 1 | DPW 2 | 28 | Width 3ft | 6011480.36813 | 2111044.01847 | 37.777171403968296 | -122.40380468436199 | (37.7771714039683, -122.403804684362) | |||
1168 | 1168 | 218199 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 819 Ulloa St | 1 | : 4 | Tree 1 | DPW 2 | 13 | Width 3ft | 5993346.67502 | 2098141.32486 | 37.740714236277 | -122.46559677389799 | (37.740714236277, -122.465596773898) | |||
23411 | 23411 | 195158 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1188 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 4ft | 6011916.5871 | 2102892.02207 | 37.7548122137394 | -122.401722520004 | (37.7548122137394, -122.401722520004) | |||
23518 | 23518 | 247709 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 848 Waller St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6001610.36211 | 2108740.78692 | 37.7702909742819 | -122.437783100124 | (37.7702909742819, -122.437783100124) | |||
23741 | 23741 | 234546 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 390 Valencia St | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6006093.30748 | 2107339.39133 | 37.7666969650198 | -122.422177005484 | (37.7666969650198, -122.422177005484) | |||
24318 | 24318 | 195049 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 425 07th St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6011046.10585 | 2110191.14121 | 37.7748053308349 | -122.405246869567 | (37.7748053308349, -122.405246869567) | |||
24505 | 24505 | 195054 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 820 Bryant St | 1 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6011686.5663 | 2110516.6477900003 | 37.775734882702295 | -122.403054272047 | (37.7757348827023, -122.403054272047) | |||
26286 | 26286 | 247164 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 181 Buena Vista Ave East | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6001468.5616 | 2108335.5699400003 | 37.76917028501371 | -122.438244553041 | (37.7691702850137, -122.438244553041) | |||
26445 | 26445 | 195159 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1190 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 6011918.3427099995 | 2102871.98584 | 37.7547572966145 | -122.40171504034201 | (37.7547572966145, -122.401715040342) | |||
26551 | 26551 | 247735 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 Broderick St | 1 | : 4 | Tree 1 | Private 1 | 20 | Width 4ft | 6001364.01922 | 2108734.36535 | 37.770259331626896 | -122.43863473741199 | (37.7702593316269, -122.438634737412) | |||
26680 | 26680 | 234541 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 380 Valencia St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6006086.8772 | 2107446.3407400004 | 37.766990260030106 | -122.422206845872 | (37.7669902600301, -122.422206845872) | |||
26845 | 26845 | 195029 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 603 02nd St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013830.29257 | 2113762.02506 | 37.7847654277311 | -122.39586599541599 | (37.7847654277311, -122.395865995416) | |||
27339 | 27339 | 178600 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 200 Winston Dr | 6 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5989476.93903 | 2093627.59215 | 37.7280967254778 | -122.478646687712 | (37.7280967254778, -122.478646687712) | |||
27627 | 27627 | 195043 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 377 06th St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6011353.00653 | 2111183.55828 | 37.777547432096206 | -122.404255094506 | (37.7775474320962, -122.404255094506) | |||
28526 | 28526 | 218250 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2751 14th Ave | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 5992235.80201 | 2097238.62713 | 37.738171520993 | -122.469372026199 | (37.738171520993, -122.469372026199) | |||
28563 | 28563 | 236251 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 95 McCoppin St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6006130.65343 | 2109099.12846 | 37.77153089025921 | -122.42217286498501 | (37.7715308902592, -122.422172864985) | |||
29027 | 29027 | 218251 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2751 14th Ave | 2 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 5992250.04874 | 2097220.76826 | 37.738123308341706 | -122.46932146901301 | (37.7381233083417, -122.469321469013) | |||
29514 | 29514 | 247770 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 827 Waller St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6001730.80568 | 2108705.46895 | 37.77020084782 | -122.437363957589 | (37.77020084782, -122.437363957589) | |||
29631 | 29631 | 250970 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6932 California St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 5985996.4910699995 | 2113927.35673 | 37.7836316119485 | -122.49217262437 | (37.7836316119485, -122.49217262437) | |||
30229 | 30229 | 247702 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 Waller St | 4 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6001763.91466 | 2108760.8160200003 | 37.770354699327 | -122.43725339763701 | (37.770354699327, -122.437253397637) | |||
30598 | 30598 | 247170 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 145 Buena Vista Ave East | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6001370.95103 | 2108474.04291 | 37.7695449452612 | -122.438592105046 | (37.7695449452612, -122.438592105046) | |||
30749 | 30749 | 247700 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 Waller St | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6001801.87342 | 2108765.96342 | 37.7703709905579 | -122.43712246712099 | (37.7703709905579, -122.437122467121) | |||
31067 | 31067 | 249497 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1765 California St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6005893.50071 | 2115878.2456799997 | 37.7901313082605 | -122.423475218205 | (37.7901313082605, -122.423475218205) | |||
31149 | 31149 | 247701 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 Waller St | 3 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6001785.70024 | 2108763.50636 | 37.770363324741794 | -122.43717823411001 | (37.7703633247418, -122.43717823411) | |||
31305 | 31305 | 247769 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 845 Waller St | 3 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6001717.5162 | 2108703.54506 | 37.7701948097837 | -122.437409787932 | (37.7701948097837, -122.437409787932) | |||
32042 | 32042 | 247704 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 824 Waller St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 5ft | 6001711.33695 | 2108752.8722599996 | 37.7703298987379 | -122.43743469466101 | (37.7703298987379, -122.437434694661) | |||
32108 | 32108 | 247728 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 49 Broderick St | 5 | : 4 | Tree 1 | Private 1 | 25 | Width 6ft | 6001337.82386 | 2108917.42217 | 37.7707604698615 | -122.43873846612101 | (37.7707604698615, -122.438738466121) | |||
32371 | 32371 | 201999 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 200 Paul Ave | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012837.45496 | 2091269.25359 | 37.7229498748073 | -122.397722694373 | (37.7229498748073, -122.397722694373) | |||
32634 | 32634 | 195160 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1190 Rhode Island St | 2 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6011919.16564 | 2102851.6607 | 37.754701534158 | -122.401710765865 | (37.754701534158, -122.401710765865) | |||
32756 | 32756 | 195051 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 425 07th St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6011026.68286 | 2110214.90007 | 37.7748694812702 | -122.40531573155701 | (37.7748694812702, -122.405315731557) | |||
33230 | 33230 | 201628 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 401 Galvez Ave | 12 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6021496.8135400005 | 2093398.7623299998 | 37.729275520830996 | -122.36793562924 | (37.729275520831, -122.36793562924) | |||
33444 | 33444 | 236255 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 155 Valencia St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6006074.21753 | 2108882.3797400002 | 37.7709325668056 | -122.42235267724399 | (37.7709325668056, -122.422352677244) | |||
33448 | 33448 | 250973 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 7010 California St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 5985735.07087 | 2113919.4528200002 | 37.7835946246316 | -122.493076443038 | (37.7835946246316, -122.493076443038) | |||
33901 | 33901 | 195058 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1118 Harrison St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6010609.31709 | 2110367.7626099996 | 37.7752658628632 | -122.406770269844 | (37.7752658628632, -122.406770269844) | |||
33958 | 33958 | 247718 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 Broderick St | 2 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6001406.2939 | 2108761.0042 | 37.7703348800695 | -122.438490418696 | (37.7703348800695, -122.438490418696) | |||
34435 | 34435 | 247717 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 Broderick St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6001409.94207 | 2108737.73214 | 37.770271188299 | -122.43847613207399 | (37.770271188299, -122.438476132074) | |||
34448 | 34448 | 195201 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 201 Rankin St | 4 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6014735.86247 | 2099450.505 | 37.745519458775 | -122.391731990932 | (37.745519458775, -122.391731990932) | |||
34606 | 34606 | 178520 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 74 Kelloch Ave | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6008160.20585 | 2086291.9091900003 | 37.7090215544595 | -122.413539180899 | (37.7090215544595, -122.413539180899) | |||
34947 | 34947 | 247768 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 845 Waller St | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6001677.287330001 | 2108698.14738 | 37.7701777019594 | -122.437548552425 | (37.7701777019594, -122.437548552425) | |||
34963 | 34963 | 195198 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 201 Rankin St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 4ft | 6014650.6097 | 2099336.7503299997 | 37.745202379392204 | -122.392018830619 | (37.7452023793922, -122.392018830619) | |||
35225 | 35225 | 195038 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 400 02nd St | 5 | : 4 | Tree 1 | Private 1 | 10 | Width 0ft | 6014100.3392 | 2113471.11724 | 37.7839816811421 | -122.394911334515 | (37.7839816811421, -122.394911334515) | |||
35398 | 35398 | 234531 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 145 Valencia St | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6006070.04124 | 2108984.02475 | 37.771211424088705 | -122.422374346422 | (37.7712114240887, -122.422374346422) | |||
35440 | 35440 | 195056 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 403 06th St | 3 | : 4 | Tree 1 | Private 1 | 37 | Width 3ft | 6011448.2097 | 2110981.26163 | 37.7769972916145 | -122.403911513916 | (37.7769972916145, -122.403911513916) | |||
35767 | 35767 | 234556 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 389 Webster St | 2 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6004113.19649 | 2110015.3109999998 | 37.773932504618394 | -122.42921669790199 | (37.7739325046184, -122.429216697902) | |||
36059 | 36059 | 218252 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2751 14th Ave | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5992261.85147 | 2097209.38473 | 37.738092734087296 | -122.469279833118 | (37.7380927340873, -122.469279833118) | |||
36451 | 36451 | 178598 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 200 Winston Dr | 4 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5989486.74208 | 2093594.0787 | 37.728005275220795 | -122.478610348783 | (37.7280052752208, -122.478610348783) | |||
36471 | 36471 | 249578 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1075 Ofarrell St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6006167.298690001 | 2113834.65662 | 37.7845355682182 | -122.42238263454901 | (37.7845355682182, -122.422382634549) | |||
37327 | 37327 | 195182 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 469 Mississippi St | 2 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6014105.1082 | 2104950.4449299998 | 37.760586083411496 | -122.39429806340901 | (37.7605860834115, -122.394298063409) | |||
38428 | 38428 | 234555 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 389 Webster St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6004106.69081 | 2110050.7121099997 | 37.774029339102604 | -122.42924172694799 | (37.7740293391026, -122.429241726948) | |||
38717 | 38717 | 195183 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 332 Mississippi St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 4ft | 6014016.45391 | 2105493.17389 | 37.7620713704081 | -122.39464268723499 | (37.7620713704081, -122.394642687235) | |||
38838 | 38838 | 250972 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 7010 California St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 5985754.51701 | 2113919.45983 | 37.78359578115 | -122.493009168333 | (37.78359578115, -122.493009168333) | |||
39172 | 39172 | 249503 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1701 California St | 2 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6006124.55833 | 2115911.6764700003 | 37.7902361395269 | -122.42267815269 | (37.7902361395269, -122.42267815269) | |||
39835 | 39835 | 249406 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 430 Turk St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6007876.35705 | 2113080.52014 | 37.7825611516116 | -122.416416421504 | (37.7825611516116, -122.416416421504) | |||
40505 | 40505 | 247725 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 49 Broderick St | 2 | : 4 | Tree 1 | Private 1 | 19 | Width 5ft | 6001330.00617 | 2108965.19653 | 37.770891201597706 | -122.43876893155701 | (37.7708912015977, -122.438768931557) | |||
41040 | 41040 | 133604 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 680 Hayes St | 2 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6004598.25031 | 2110892.9208299997 | 37.776369653876 | -122.42760135363599 | (37.776369653876, -122.427601353636) | |||
41308 | 41308 | 249579 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1075 Ofarrell St | 2 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6006196.8635599995 | 2113838.7840400003 | 37.7845485688079 | -122.42228064334 | (37.7845485688079, -122.42228064334) | |||
42190 | 42190 | 247167 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 165 Buena Vista Ave East | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 5ft | 6001410.43001 | 2108421.56043 | 37.7694030871159 | -122.43845178832301 | (37.7694030871159, -122.438451788323) | |||
42914 | 42914 | 195153 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 747 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6011866.39234 | 2104881.06105 | 37.7602708746342 | -122.402035931016 | (37.7602708746342, -122.402035931016) | |||
44065 | 44065 | 195063 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1440 Harrison St | 25 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6009088.88483 | 2108916.86222 | 37.7711968415799 | -122.41192726035901 | (37.7711968415799, -122.411927260359) | |||
44707 | 44707 | 178595 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3353 19th Ave | 7 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5990558.26669 | 2094238.61672 | 37.729837169035896 | -122.474953123505 | (37.7298371690359, -122.474953123505) | |||
45448 | 45448 | 195069 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1532 Bryant St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6008781.51623 | 2108669.00103 | 37.7704990234538 | -122.412972936267 | (37.7704990234538, -122.412972936267) | |||
45803 | 45803 | 178597 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 200 Winston Dr | 2 | : 4 | Tree 1 | Private 1 | 11 | Width 0ft | 5989487.40549 | 2093535.0648700001 | 37.727843276732 | -122.47860374149201 | (37.727843276732, -122.478603741492) | |||
45940 | 45940 | 249496 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1765 California St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6005857.5459 | 2115873.8651400004 | 37.7901172509642 | -122.423599307579 | (37.7901172509642, -122.423599307579) | |||
46205 | 46205 | 247708 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 844 Waller St | 2 | : 4 | Tree 1 | Private 1 | 14 | Width 4ft | 6001638.27967 | 2108743.56239 | 37.770300182441396 | -122.43768673235901 | (37.7703001824414, -122.437686732359) | |||
47110 | 47110 | 249491 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1899 California St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6005331.84329 | 2115802.8856200003 | 37.7898926713456 | -122.42541314481899 | (37.7898926713456, -122.425413144819) | |||
48043 | 48043 | 195174 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2200 23rd St | 2 | : 4 | Tree 1 | Private 1 | 18 | Width 4ft | 6011890.90332 | 2102824.4567400003 | 37.75462526086329 | -122.401806593102 | (37.7546252608633, -122.401806593102) | |||
48663 | 48663 | 247726 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 49 Broderick St | 3 | : 4 | Tree 1 | Private 1 | 20 | Width 5ft | 6001333.54559 | 2108953.84659 | 37.770860238851 | -122.438755875203 | (37.770860238851, -122.438755875203) | |||
48811 | 48811 | 249561 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1336 Post St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 6005719.13803 | 2114518.05825 | 37.7863867291032 | -122.423981734369 | (37.7863867291032, -122.423981734369) | |||
48949 | 48949 | 195178 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1512 19th St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6013083.6982 | 2105226.1685599997 | 37.761286330631705 | -122.39785002128201 | (37.7612863306317, -122.397850021282) | |||
50017 | 50017 | 234534 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 250 Valencia St | 7 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6006047.6437099995 | 2108148.24766 | 37.7689153164221 | -122.42239242639499 | (37.7689153164221, -122.422392426395) | |||
50634 | 50634 | 195217 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1501 Davidson Ave | 6 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6014951.137519999 | 2099351.9188 | 37.7452607094218 | -122.390980708107 | (37.7452607094218, -122.390980708107) | |||
50863 | 50863 | 201629 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 401 Galvez Ave | 13 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6021522.6239599995 | 2093379.49172 | 37.7292240220626 | -122.36784506930599 | (37.7292240220626, -122.367845069306) | |||
51866 | 51866 | 195042 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 402 06th St | 2 | : 4 | Tree 1 | Private 1 | 26 | Width 3ft | 6011470.44747 | 2111056.37562 | 37.7772047796221 | -122.403839873012 | (37.7772047796221, -122.403839873012) | |||
53264 | 53264 | 195162 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 795 Wisconsin St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6012759.21465 | 2103840.23662 | 37.757462790085505 | -122.398875007375 | (37.7574627900855, -122.398875007375) | |||
53391 | 53391 | 247744 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 883 Waller St | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6001433.04575 | 2108666.05227 | 37.7700756873626 | -122.43839108048701 | (37.7700756873626, -122.438391080487) | |||
53811 | 53811 | 236253 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 95 McCoppin St | 5 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6006170.16969 | 2109101.8157599997 | 37.771540497736 | -122.42203636681002 | (37.771540497736, -122.42203636681) | |||
54031 | 54031 | 195048 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 972 Harrison St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6011557.47777 | 2111276.51423 | 37.7778140909953 | -122.403554297789 | (37.7778140909953, -122.403554297789) | |||
54039 | 54039 | 217737 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 715 Frederick St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5996153.98558 | 2107236.09361 | 37.7658477046389 | -122.45654774598499 | (37.7658477046389, -122.456547745985) | |||
54189 | 54189 | 195202 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 201 Rankin St | 5 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6014746.50414 | 2099463.9870599997 | 37.7455570684194 | -122.391696135872 | (37.7455570684194, -122.391696135872) | |||
54355 | 54355 | 195037 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 712 Harrison St | 8 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6013186.23723 | 2112830.2440400003 | 37.782171121043795 | -122.398028840679 | (37.7821711210438, -122.398028840679) | |||
54412 | 54412 | 195169 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 690 Wisconsin St | 8 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6012684.972080001 | 2104240.58685 | 37.7585579269363 | -122.39915987123699 | (37.7585579269363, -122.399159871237) | |||
54768 | 54768 | 249510 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1301 Van Ness Ave | 5 | : 4 | Tree 1 | Private 1 | 7 | Width 1ft | 6006317.71181 | 2114977.4898599996 | 37.7876819902699 | -122.421943465924 | (37.7876819902699, -122.421943465924) | |||
55191 | 55191 | 133603 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 662 Hayes St | 2 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6004673.73333 | 2110903.67068 | 37.776403439601395 | -122.427341002593 | (37.7764034396014, -122.427341002593) | |||
55403 | 55403 | 250969 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6924 California St | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 5986098.00978 | 2113930.24714 | 37.7836454821978 | -122.49182162619199 | (37.7836454821978, -122.491821626192) | |||
56289 | 56289 | 195170 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 859 Wisconsin St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6012783.82646 | 2103478.80555 | 37.756471750696 | -122.39876452475599 | (37.756471750696, -122.398764524756) | |||
56426 | 56426 | 250971 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 7002 California St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 5985825.16294 | 2113921.74383 | 37.783606183626105 | -122.492764932276 | (37.7836061836261, -122.492764932276) | |||
56850 | 56850 | 249576 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1099 Ofarrell St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6006111.66082 | 2113826.64553 | 37.784510433048 | -122.422574553491 | (37.784510433048, -122.422574553491) | |||
57677 | 57677 | 247175 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 123 Buena Vista Ave East | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6001310.87705 | 2108552.6778700002 | 37.7697574397749 | -122.438805533953 | (37.7697574397749, -122.438805533953) | |||
57690 | 57690 | 195191 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Industrial St | 8 | : 4 | Tree 1 | Private 1 | 18 | Width 4ft | 6011603.00952 | 2097270.79889 | 37.7393600461416 | -122.402411733411 | (37.7393600461416, -122.402411733411) | |||
58185 | 58185 | 234552 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 599 Buchanan St | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 5ft | 6004546.97055 | 2110414.43601 | 37.775052951057 | -122.42774464441999 | (37.775052951057, -122.42774464442) | |||
58618 | 58618 | 247713 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 880 Waller St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6001495.04463 | 2108722.80835 | 37.7702350517434 | -122.438180694009 | (37.7702350517434, -122.438180694009) | |||
59189 | 59189 | 195165 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 690 Wisconsin St | 2 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6012683.25425 | 2104289.74415 | 37.758692806358 | -122.39916926286301 | (37.758692806358, -122.399169262863) | |||
60565 | 60565 | 195067 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1501 Bryant St | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6008874.83792 | 2108609.10047 | 37.7703397885684 | -122.412645899583 | (37.7703397885684, -122.412645899583) | |||
60947 | 60947 | 249585 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1001 Ofarrell St | 7 | : 4 | Tree 1 | Private 1 | 15 | Width 4ft | 6006400.946280001 | 2113866.78963 | 37.7846369748603 | -122.421576574896 | (37.7846369748603, -122.421576574896) | |||
62440 | 62440 | 178519 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 74 Kelloch Ave | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6008207.90106 | 2086273.84024 | 37.7089746188665 | -122.413373061735 | (37.7089746188665, -122.413373061735) | |||
62547 | 62547 | 195059 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1118 Harrison St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6010590.86916 | 2110351.5216200002 | 37.775220236657795 | -122.406832940881 | (37.7752202366578, -122.406832940881) | |||
62830 | 62830 | 218177 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2800 15th Ave | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 5991929.371230001 | 2096655.3503299998 | 37.736552277270704 | -122.470389035343 | (37.7365522772707, -122.470389035343) | |||
63212 | 63212 | 250055 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1338 Franklin St | 5 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6005925.95493 | 2114827.43297 | 37.7872478695325 | -122.423288199717 | (37.7872478695325, -122.423288199717) |
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");