trees
1,381 rows where qSpecies_id = 54 sorted by SiteOrder descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5517 | 4664 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 600X Columbus Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 5X5 | 6009692.468 | 2119649.5892 | 37.8007001848924 | -122.410597470914 | (37.8007001848924, -122.410597470914) | 3 | 1 | 10 | 308 | 23 | |||
| 23493 | 199735 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 Armstrong Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6014648.3519 | 2092320.2341 | 37.7259363350419 | -122.391536186534 | (37.7259363350419, -122.391536186534) | 10 | 3 | 8 | 58 | 1 | |||
| 32828 | 140712 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500 PIERCE ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6002642.8382 | 2110450.467 | 37.7750439873946 | -122.434334023387 | (37.7750439873946, -122.434334023387) | 15 | 5 | 11 | 29492 | 10 | |||
| 66624 | 138367 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2060 SUTTER ST | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | Width 0ft | 6002691.6152 | 2114444.3582 | 37.7860129777854 | -122.434450912019 | (37.7860129777854, -122.434450912019) | 13 | 9 | 11 | 29490 | 27 | |||
| 72409 | 141798 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1280 WEBSTER ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003785.6349 | 2113107.9429 | 37.7824055567974 | -122.430570506849 | (37.7824055567974, -122.430570506849) | 7 | 9 | 11 | 29490 | 41 | |||
| 153905 | 142598 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 365 COLUMBUS AVE | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6008376.309 | 2120765.2318 | 37.8036895828586 | -122.415230957587 | (37.8036895828586, -122.415230957587) | 5 | 1 | 10 | 308 | 32 | |||
| 159295 | 246092 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 700 Stanyan St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5997091.8262 | 2108330.4431 | 37.7689063069149 | -122.453382986949 | (37.7689063069149, -122.453382986949) | 15 | 5 | 11 | 29492 | 9 | |||
| 12953 | 4663 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 600X Columbus Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 5X5 | 6009710.0139 | 2119634.3519 | 37.8006593307081 | -122.41053567802 | (37.8006593307081, -122.41053567802) | 3 | 1 | 10 | 308 | 23 | |||
| 28705 | 143354 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1651 UNION ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6005214.4581 | 2118841.5322 | 37.7982293936322 | -122.426035690785 | (37.7982293936322, -122.426035690785) | 13 | 9 | 1 | 57 | 17 | |||
| 35755 | 246093 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 700 Stanyan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5997094.8545 | 2108310.1536 | 37.7688507707463 | -122.453371047271 | (37.7688507707463, -122.453371047271) | 15 | 5 | 11 | 29492 | 9 | |||
| 46849 | 99233 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1111 Columbus Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008063.2168 | 2121048.832 | 37.8044506767497 | -122.416334531861 | (37.8044506767497, -122.416334531861) | 5 | 1 | 10 | 308 | 32 | |||
| 61153 | 140429 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1499 TURK ST | 8 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 15 | Width 0ft | 6003096.7102 | 2112369.578 | 37.7803391401181 | -122.432901115602 | (37.7803391401181, -122.432901115602) | 15 | 9 | 11 | 29490 | 41 | |||
| 109427 | 199728 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2300 Jennings St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6014985.6871 | 2092077.3996 | 37.725288278052 | -122.390353072543 | (37.725288278052, -122.390353072543) | 10 | 3 | 8 | 58 | 1 | |||
| 111176 | 138366 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2060 SUTTER ST | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | Width 0ft | 6002708.9598 | 2114445.3493 | 37.7860166836287 | -122.434390975358 | (37.7860166836287, -122.434390975358) | 13 | 9 | 11 | 29490 | 27 | |||
| 127703 | 142597 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 365 COLUMBUS AVE | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6008368.5325 | 2120773.0083 | 37.8037104981311 | -122.41525841948 | (37.8037104981311, -122.41525841948) | 5 | 1 | 10 | 308 | 32 | |||
| 136338 | 141689 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2350 TURK BLVD | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5998480.6511 | 2111795.7451 | 37.778500645915 | -122.448828794796 | (37.778500645915, -122.448828794796) | 15 | 6 | 2 | 54 | 16 | |||
| 143473 | 7201 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 949 Fillmore St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003424.6737 | 2111504.3754 | 37.7779821053868 | -122.431704747493 | (37.7779821053868, -122.431704747493) | 15 | 9 | 11 | 29492 | 41 | |||
| 156129 | 140711 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500 PIERCE ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6002645.4844 | 2110432.6051 | 37.7749950932562 | -122.434323592325 | (37.7749950932562, -122.434323592325) | 15 | 5 | 11 | 29492 | 10 | |||
| 23992 | 20166 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1155X Steiner St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 4X4 | 6002621 | 2112212 | 37.7798794773869 | -122.434535545992 | (37.7798794773869, -122.434535545992) | 15 | 5 | 11 | 29490 | 41 | |||
| 31104 | 142596 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 365 COLUMBUS AVE | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6008359.2007 | 2120780.7848 | 37.8037313259866 | -122.415291263605 | (37.8037313259866, -122.415291263605) | 5 | 1 | 10 | 308 | 32 | |||
| 32007 | 7200 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 949 Fillmore St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003420.9887 | 2111521.8792 | 37.7780299575939 | -122.431718745255 | (37.7780299575939, -122.431718745255) | 15 | 9 | 11 | 29492 | 41 | |||
| 33127 | 141688 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2350 TURK BLVD | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5998531.7594 | 2111801.3756 | 37.7785190283548 | -122.448652398208 | (37.7785190283548, -122.448652398208) | 15 | 6 | 2 | 54 | 16 | |||
| 40947 | 111735 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 313 Ivy St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 2.5x3 | 6005874.8827 | 2111210.5438 | 37.7773138971451 | -122.423207702005 | (37.7773138971451, -122.423207702005) | 7 | 9 | 11 | 28852 | 10 | |||
| 41692 | 138365 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2060 SUTTER ST | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | Width 0ft | 6002748.6045 | 2114451.296 | 37.7860352620012 | -122.434254240878 | (37.7860352620012, -122.434254240878) | 13 | 9 | 11 | 29490 | 27 | |||
| 65948 | 497 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2749X 24th St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6010516.451 | 2102220.2128 | 37.7528893415843 | -122.406517264254 | (37.7528893415843, -122.406517264254) | 10 | 4 | 7 | 28859 | 19 | |||
| 76159 | 110471 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 465 Grove St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 3x3 | 6005689.0684 | 2111342.3906 | 37.7776654283212 | -122.423859872139 | (37.7776654283212, -122.423859872139) | 7 | 9 | 11 | 28852 | 10 | ||
| 84858 | 199734 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 Armstrong Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6014741.5822 | 2092253.0007 | 37.725756899909 | -122.391209195431 | (37.725756899909, -122.391209195431) | 10 | 3 | 8 | 58 | 1 | |||
| 108876 | 199858 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2513 Keith St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6014132.4385 | 2092038.2943 | 37.7251335354362 | -122.393299957721 | (37.7251335354362, -122.393299957721) | 10 | 3 | 8 | 58 | 1 | |||
| 112434 | 137529 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1300 Pierce St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6002258.0131 | 2113181.285 | 37.7825202770743 | -122.435860649108 | (37.7825202770743, -122.435860649108) | 15 | 5 | 11 | 29490 | 41 | |||
| 123174 | 138127 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1850 FILLMORE ST | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | Width 0ft | 6003021.61 | 2114689.1851 | 37.7867039367027 | -122.433326721425 | (37.7867039367027, -122.433326721425) | 13 | 9 | 11 | 29490 | 27 | |||
| 132419 | 143353 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1651 UNION ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6005181.3418 | 2118836.9868 | 37.7982150414331 | -122.426149959367 | (37.7982150414331, -122.426149959367) | 13 | 9 | 1 | 57 | 17 | |||
| 147046 | 99232 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1111 Columbus Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008054.705 | 2121057.3439 | 37.8044735696368 | -122.416364591045 | (37.8044735696368, -122.416364591045) | 5 | 1 | 10 | 308 | 32 | |||
| 149566 | 140509 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1020 FILLMORE ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6003414.9884 | 2111885.4448 | 37.779027878196 | -122.431765467371 | (37.779027878196, -122.431765467371) | 15 | 9 | 11 | 29490 | 41 | |||
| 169091 | 246094 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 700 Stanyan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5997100.0026 | 2108265.6377 | 37.7687288366145 | -122.453350026115 | (37.7687288366145, -122.453350026115) | 15 | 5 | 11 | 29492 | 9 | |||
| 170061 | 140544 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1025 FILLMORE ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003387.6502 | 2111766.8151 | 37.7787006008552 | -122.431851568456 | (37.7787006008552, -122.431851568456) | 15 | 9 | 11 | 29490 | 41 | |||
| 178543 | 140710 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500 PIERCE ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6002647.4691 | 2110413.42 | 37.7749425283913 | -122.434315354923 | (37.7749425283913, -122.434315354923) | 15 | 5 | 11 | 29492 | 10 | |||
| 179204 | 140428 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1499 TURK ST | 7 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 14 | Width 0ft | 6003076.6138 | 2112365.9894 | 37.7803281468599 | -122.432970381874 | (37.7803281468599, -122.432970381874) | 15 | 9 | 11 | 29490 | 41 | |||
| 187827 | 15319 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1680 Mission St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006779.4102 | 2108712.5677 | 37.7705060574636 | -122.419901340101 | (37.7705060574636, -122.419901340101) | 8 | 2 | 9 | 28853 | 19 | |||
| 191059 | 258059 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 600 California St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011288 | 2116842 | 37.793080546408 | -122.404878460446 | (37.793080546408, -122.404878460446) | 3 | 1 | 10 | 28857 | 4 | ||||
| 2761 | 199857 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2511 Keith St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6014147.0563 | 2092057.1756 | 37.725186191812 | -122.393250745752 | (37.725186191812, -122.393250745752) | 10 | 3 | 8 | 58 | 1 | |||
| 3207 | 111734 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 313 Ivy St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 2.5x3 | 6005865.3001 | 2111209.4164 | 37.777310260787 | -122.423240771205 | (37.777310260787, -122.423240771205) | 7 | 9 | 11 | 28852 | 10 | |||
| 5587 | 4662 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 600X Columbus Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 5X5 | 6009727.0981 | 2119617.2678 | 37.8006133797513 | -122.410475352391 | (37.8006133797513, -122.410475352391) | 3 | 1 | 10 | 308 | 23 | |||
| 14187 | 201882 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 633 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6013405.8744 | 2113823.4352 | 37.7849104254124 | -122.397338660811 | (37.7849104254124, -122.397338660811) | 6 | 2 | 9 | 28856 | 6 | |||
| 16609 | 141535 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2901 TURK BLVD | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5996788.0463 | 2111499.0832 | 37.777589151551 | -122.454662685268 | (37.777589151551, -122.454662685268) | 15 | 6 | 2 | 54 | 16 | |||
| 25325 | 140508 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1020 FILLMORE ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6003419.5462 | 2111864.9347 | 37.778971820926 | -122.431748235324 | (37.778971820926, -122.431748235324) | 15 | 9 | 11 | 29490 | 41 | |||
| 43162 | 138126 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1850 FILLMORE ST | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | Width 0ft | 6003024.8426 | 2114663.3242 | 37.7866331126192 | -122.433313688795 | (37.7866331126192, -122.433313688795) | 13 | 9 | 11 | 29490 | 27 | |||
| 54245 | 139449 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 508 OCTAVIA ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6005461.1411 | 2111122.6096 | 37.7770490933731 | -122.42463271281 | (37.7770490933731, -122.42463271281) | 7 | 9 | 11 | 28852 | 10 | |||
| 55824 | 110470 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 465 Grove St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 3x3 | 6005644.9931 | 2111337.1436 | 37.7776485330384 | -122.424011970547 | (37.7776485330384, -122.424011970547) | 7 | 9 | 11 | 28852 | 10 | ||
| 61004 | 138507 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1701 FILLMORE ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003042.8042 | 2114198.3962 | 37.7853575570383 | -122.433218313249 | (37.7853575570383, -122.433218313249) | 13 | 9 | 11 | 29490 | 13 | |||
| 62099 | 217621 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 1830 Ocean Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5994307.7366 | 2092494.0455 | 37.725263580598 | -122.461864420033 | (37.725263580598, -122.461864420033) | 9 | 8 | 4 | 28861 | 40 | |||
| 66866 | 98473 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 16th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6011870.2645 | 2107034.4384 | 37.7661837837598 | -122.402173936122 | (37.7661837837598, -122.402173936122) | 8 | 3 | 8 | 28853 | 20 | |||
| 76752 | 140427 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1499 TURK ST | 6 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 14 | Width 0ft | 6003052.211 | 2112362.4007 | 37.7803169090148 | -122.43305454594 | (37.7803169090148, -122.43305454594) | 15 | 9 | 11 | 29490 | 41 | |||
| 79599 | 137528 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1300 Pierce St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6002263.2838 | 2113153.4253 | 37.7824440807926 | -122.435840420812 | (37.7824440807926, -122.435840420812) | 15 | 5 | 11 | 29490 | 41 | |||
| 81484 | 140709 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500 PIERCE ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6002649.4537 | 2110396.2195 | 37.7748954127382 | -122.434307259794 | (37.7748954127382, -122.434307259794) | 15 | 5 | 11 | 29492 | 10 | |||
| 87343 | 13189 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2055X Lombard St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002690.4208 | 2119498.1098 | 37.7998892100694 | -122.43481657947 | (37.7998892100694, -122.43481657947) | 13 | 9 | 1 | 57 | 17 | |||
| 96717 | 143352 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1651 UNION ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6005162.5109 | 2118835.6881 | 37.7982104111867 | -122.426215027416 | (37.7982104111867, -122.426215027416) | 13 | 9 | 1 | 57 | 17 | |||
| 107430 | 138364 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2060 SUTTER ST | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | Width 0ft | 6002783.7892 | 2114453.2783 | 37.7860427018539 | -122.434132653208 | (37.7860427018539, -122.434132653208) | 13 | 9 | 11 | 29490 | 27 | |||
| 120153 | 142993 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 365 COLUMBUS AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6008349.8689 | 2120789.339 | 37.8037542892016 | -122.415324162836 | (37.8037542892016, -122.415324162836) | 5 | 1 | 10 | 308 | 32 | |||
| 120425 | 258058 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 600 California St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011288 | 2116842 | 37.793080546408 | -122.404878460446 | (37.793080546408, -122.404878460446) | 3 | 1 | 10 | 28857 | 4 | ||||
| 122229 | 496 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2749X 24th St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6010495.2306 | 2102220.2128 | 37.7528881543902 | -122.406590648723 | (37.7528881543902, -122.406590648723) | 10 | 4 | 7 | 28859 | 19 | |||
| 123210 | 246095 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 700 Stanyan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5997104.5451 | 2108242.017 | 37.7686642406132 | -122.453332608488 | (37.7686642406132, -122.453332608488) | 15 | 5 | 11 | 29492 | 9 | |||
| 130807 | 21632 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1615 Sutter St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/04/1991 12:00:00 AM | 12 | 4X4 | 6004741.4911 | 2114677.6404 | 37.7867696583856 | -122.427375518495 | (37.7867696583856, -122.427375518495) | 13 | 9 | 11 | 28858 | 13 | ||
| 146069 | 199726 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2300 Jennings St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6015013.7839 | 2092118.9829 | 37.7254040160333 | -122.390258847729 | (37.7254040160333, -122.390258847729) | 10 | 3 | 8 | 58 | 1 | |||
| 146897 | 142493 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 651 COLUMBUS AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6009645.6019 | 2119599.491 | 37.8005599999984 | -122.410756107582 | (37.8005599999984, -122.410756107582) | 3 | 1 | 10 | 308 | 4 | |||
| 150721 | 140693 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1120 FILLMORE ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6003357.1733 | 2112337.09 | 37.780264705851 | -122.431997732698 | (37.780264705851, -122.431997732698) | 15 | 9 | 11 | 29490 | 41 | |||
| 154385 | 140543 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1025 FILLMORE ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6003386.4685 | 2111785.1308 | 37.7787508242216 | -122.431856964548 | (37.7787508242216, -122.431856964548) | 15 | 9 | 11 | 29490 | 41 | |||
| 158612 | 141687 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2350 TURK BLVD | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5998550.3836 | 2111804.4075 | 37.778528418096 | -122.448588188719 | (37.778528418096, -122.448588188719) | 15 | 6 | 2 | 54 | 16 | |||
| 159706 | 244974 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 205 Rose St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6005564.966 | 2109773.8307 | 37.7733515366804 | -122.424177602904 | (37.7733515366804, -122.424177602904) | 7 | 9 | 11 | 28852 | 10 | |||
| 172700 | 99231 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1111 Columbus Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2x2 | 6008046.5206 | 2121063.2366 | 37.8044892892651 | -122.416393331612 | (37.8044892892651, -122.416393331612) | 5 | 1 | 10 | 308 | 32 | |||
| 190740 | 21590 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 Sutter St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 6005256.9547 | 2114799.289 | 37.7871328144412 | -122.425600795702 | (37.7871328144412, -122.425600795702) | 13 | 9 | 11 | 28858 | 27 | |||
| 193449 | 244056 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 401 Cole St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5997913.0484 | 2109110.0936 | 37.7710940655703 | -122.45059866498 | (37.7710940655703, -122.45059866498) | 15 | 5 | 11 | 29492 | 9 | |||
| 5424 | 113149 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1035X Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3x3 | 6010826.0688 | 2111360.9298 | 37.7780049945656 | -122.406090456701 | (37.7780049945656, -122.406090456701) | 14 | 2 | 9 | 28853 | 34 | |||
| 28001 | 142492 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 651 COLUMBUS AVE | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6009649.7576 | 2119605.0318 | 37.8005754466702 | -122.410742118634 | (37.8005754466702, -122.410742118634) | 3 | 1 | 10 | 308 | 4 | |||
| 42047 | 97114 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1345 Noriega St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Permit Number 18860 | 5989801.9904 | 2103085.8445 | 37.7540855022306 | -122.478214246151 | (37.7540855022306, -122.478214246151) | 1 | 8 | 3 | 56 | 35 | |||
| 43602 | 140542 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1025 FILLMORE ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003382.3327 | 2111808.7639 | 37.7788154803812 | -122.431872959815 | (37.7788154803812, -122.431872959815) | 15 | 9 | 11 | 29490 | 41 | |||
| 43753 | 140708 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500 PIERCE ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6002652.7615 | 2110375.0497 | 37.7748374734767 | -122.434294303619 | (37.7748374734767, -122.434294303619) | 15 | 5 | 11 | 29492 | 10 | |||
| 47497 | 142605 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 700 CHESTNUT ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6008282.9909 | 2120710.7963 | 37.8035348717489 | -122.415550034395 | (37.8035348717489, -122.415550034395) | 5 | 1 | 10 | 308 | 32 | |||
| 56605 | 141611 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1501 Fulton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6000537 | 2110949 | 37.7762930788063 | -122.441654341711 | (37.7762930788063, -122.441654341711) | 15 | 5 | 11 | 29492 | 16 | |||
| 59245 | 141686 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2350 TURK BLVD | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5998577.2371 | 2111809.6049 | 37.7785442242281 | -122.448495667047 | (37.7785442242281, -122.448495667047) | 15 | 6 | 2 | 54 | 16 | |||
| 62896 | 199856 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2509 Keith St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6014162.2831 | 2092076.0569 | 37.7252388819994 | -122.393199428445 | (37.7252388819994, -122.393199428445) | 10 | 3 | 8 | 58 | 1 | |||
| 63827 | 246096 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 700 Stanyan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5997106.9677 | 2108216.5794 | 37.7685945343602 | -122.453322392223 | (37.7685945343602, -122.453322392223) | 15 | 5 | 11 | 29492 | 9 | |||
| 68432 | 140421 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1120 STEINER ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6002869.1903 | 2112320.0547 | 37.7801902543068 | -122.43368467143 | (37.7801902543068, -122.43368467143) | 15 | 9 | 11 | 29490 | 41 | |||
| 79204 | 15302 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1640 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006948.3596 | 2109215.1279 | 37.7718954850631 | -122.419352599105 | (37.7718954850631, -122.419352599105) | 8 | 2 | 9 | 28853 | 19 | |||
| 81097 | 140426 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1499 TURK ST | 5 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 12 | Width 0ft | 6003027.0905 | 2112359.5298 | 37.7803076012967 | -122.433141244136 | (37.7803076012967, -122.433141244136) | 15 | 9 | 11 | 29490 | 41 | |||
| 82719 | 200689 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 4705 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6015031.9275 | 2095672.1834 | 37.7351613961063 | -122.390444284047 | (37.7351613961063, -122.390444284047) | 10 | 3 | 8 | 58 | 1 | |||
| 85272 | 98472 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 16th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6011885.4815 | 2107033.4874 | 37.766182021887 | -122.402121236301 | (37.766182021887, -122.402121236301) | 8 | 3 | 8 | 28853 | 20 | |||
| 94505 | 142595 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 365 COLUMBUS AVE | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6008339.7594 | 2120798.6708 | 37.8037793437918 | -122.415359808453 | (37.8037793437918, -122.415359808453) | 5 | 1 | 10 | 308 | 32 | |||
| 98202 | 110911 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 633 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 6013393.5354 | 2113814.1809 | 37.7848843282601 | -122.397380700853 | (37.7848843282601, -122.397380700853) | 6 | 2 | 9 | 28856 | 6 | ||||
| 98584 | 139448 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 508 OCTAVIA ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6005463.3958 | 2111104.0081 | 37.7769981455225 | -122.424623589548 | (37.7769981455225, -122.424623589548) | 7 | 9 | 11 | 28852 | 10 | |||
| 103297 | 217620 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 1830 Ocean Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5994327.7005 | 2092483.4396 | 37.7252356086447 | -122.461794638623 | (37.7252356086447, -122.461794638623) | 9 | 8 | 4 | 28861 | 40 | |||
| 104305 | 143351 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1651 UNION ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6005123.5505 | 2118829.1947 | 37.7981903797597 | -122.426349379498 | (37.7981903797597, -122.426349379498) | 13 | 9 | 1 | 57 | 17 | |||
| 104792 | 142635 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 241 BAY ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6009773.7882 | 2121554.2814 | 37.8059345556962 | -122.410450636982 | (37.8059345556962, -122.410450636982) | 3 | 1 | 10 | 308 | 23 | |||
| 105740 | 247381 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1001 Oak St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | Width 0ft | 6002208 | 2109818 | 37.7732826991746 | -122.435792959812 | (37.7732826991746, -122.435792959812) | 15 | 5 | 11 | 29492 | 9 | |||
| 109156 | 110469 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 465 Grove St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 3x3 | 6005632.4002 | 2111334.52 | 37.7776406182957 | -122.424055347089 | (37.7776406182957, -122.424055347089) | 7 | 9 | 11 | 28852 | 10 | ||
| 114513 | 111733 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 313 Ivy St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 2.5x3 | 6005854.5902 | 2111208.289 | 37.777306560799 | -122.423277740102 | (37.777306560799, -122.423277740102) | 7 | 9 | 11 | 28852 | 10 | |||
| 119396 | 138363 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2060 SUTTER ST | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | Width 0ft | 6002798.656 | 2114455.2605 | 37.7860489882217 | -122.434081359893 | (37.7860489882217, -122.434081359893) | 13 | 9 | 11 | 29490 | 27 | |||
| 124199 | 138125 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1850 FILLMORE ST | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | Width 0ft | 6003026.6898 | 2114633.7688 | 37.7865520657788 | -122.433305185236 | (37.7865520657788, -122.433305185236) | 13 | 9 | 11 | 29490 | 27 | |||
| 125683 | 20094 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2075X Oak St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 5997081.4143 | 2109098.2817 | 37.7710139970036 | -122.453474447283 | (37.7710139970036, -122.453474447283) | 15 | 5 | 11 | 29492 | 9 | |||
| 128043 | 140692 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1120 FILLMORE ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003358.0022 | 2112322.1697 | 37.7802237854245 | -122.431993799423 | (37.7802237854245, -122.431993799423) | 15 | 9 | 11 | 29490 | 41 | |||
| 129005 | 106207 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1600X Fillmore St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 5x5 | 6003107.6347 | 2114075.5662 | 37.7850239743837 | -122.43298524084 | (37.7850239743837, -122.43298524084) | 13 | 9 | 11 | 29490 | 13 |
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) );