trees
1,381 rows where qSpecies_id = 54 sorted by rowid 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 194465 | 63910 | Prune Opt Out 3 | Ficus retusa nitida :: Banyan Fig 54 | 2135 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/1991 12:00:00 AM | 14 | Permit Number 788005 | 6009385.3216 | 2121038.8544 | 37.8044975370449 | -122.411758548847 | (37.8044975370449, -122.411758548847) | 3 | 1 | 10 | 308 | 23 | ||
| 194296 | 187453 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 4621 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6002078.4831 | 2091980.9842 | 37.724299121454 | -122.434965072602 | (37.724299121454, -122.434965072602) | 9 | 7 | 6 | 28861 | 5 | |||
| 194293 | 15750 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 4621 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4X4 | 6002067.6674 | 2091962.7327 | 37.7242483928285 | -122.435001156163 | (37.7242483928285, -122.435001156163) | 9 | 7 | 6 | 28861 | 5 | |||
| 194022 | 59752 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2375 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1981 12:00:00 AM | 11 | Permit Number 19189 | 6000826.215 | 2113783.3508 | 37.7840919573447 | -122.440857239763 | (37.7840919573447, -122.440857239763) | 15 | 6 | 11 | 29490 | 13 | ||
| 193632 | 248365 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 701 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5998521.6337 | 2108231.8723 | 37.7687175089215 | -122.448430301142 | (37.7687175089215, -122.448430301142) | 15 | 5 | 11 | 29492 | 9 | |||
| 193541 | 143069 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1709 Grant Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6010441.5711 | 2120399.4535 | 37.8028010970412 | -122.408058165055 | (37.8028010970412, -122.408058165055) | 3 | 1 | 10 | 308 | 23 | |||
| 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 | |||
| 193272 | 113486 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 30 PRESIDIO AVE | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5998975 | 2116473 | 37.7913714231174 | -122.447455414162 | (37.7913714231174, -122.447455414162) | 13 | 6 | 1 | 29490 | 31 | ||||
| 193191 | 138110 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1600 SUTTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6004839.6037 | 2114746.6136 | 37.7869645899648 | -122.427040986298 | (37.7869645899648, -122.427040986298) | 13 | 9 | 11 | 28858 | 27 | |||
| 192913 | 142130 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 24 HEMWAY TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5998647.6806 | 2110905.5745 | 37.7760660175212 | -122.448186864357 | (37.7760660175212, -122.448186864357) | 15 | 6 | 2 | 29492 | 16 | |||
| 192634 | 244321 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 255 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6005987.0957 | 2110521.4851 | 37.7754282408756 | -122.422770539085 | (37.7754282408756, -122.422770539085) | 7 | 9 | 11 | 28852 | 10 | |||
| 192594 | 99227 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1111 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2x2 | 6008003.9616 | 2121103.5041 | 37.8045974602939 | -122.416543465428 | (37.8045974602939, -122.416543465428) | 5 | 1 | 10 | 308 | 32 | |||
| 192522 | 8181 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1212 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X3 | 6001826.5111 | 2111197.1465 | 37.7770478129311 | -122.43721134601 | (37.7770478129311, -122.43721134601) | 15 | 5 | 11 | 29492 | 41 | |||
| 192358 | 10629 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 817 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/02/1990 12:00:00 AM | 12 | 3X3 | 6003911.8012 | 2110745.3047 | 37.7759254847018 | -122.429965440473 | (37.7759254847018, -122.429965440473) | 7 | 9 | 11 | 29492 | 10 | ||
| 192123 | 143020 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 560 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | Width 0ft | 6009678.016 | 2120549.6995 | 37.8031708545804 | -122.410711083519 | (37.8031708545804, -122.410711083519) | 3 | 1 | 10 | 308 | 23 | |||
| 192110 | 140209 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 708 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003569 | 2110758 | 37.7759409231905 | -122.431152184499 | (37.7759409231905, -122.431152184499) | 7 | 9 | 11 | 29492 | 10 | |||
| 192060 | 244242 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 151 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6005776.1437 | 2110149.7201 | 37.7743955596449 | -122.423473837096 | (37.7743955596449, -122.423473837096) | 7 | 9 | 11 | 28852 | 10 | |||
| 191893 | 54834 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 109 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1972 12:00:00 AM | 17 | Permit Number 10688 | 5998714.6082 | 2110323.5588 | 37.7744717777818 | -122.447913432558 | (37.7744717777818, -122.447913432558) | 15 | 5 | 11 | 29492 | 16 | ||
| 191861 | 248318 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5998789.7889 | 2108283.5046 | 37.768874606083 | -122.447506493604 | (37.768874606083, -122.447506493604) | 15 | 5 | 11 | 29492 | 9 | |||
| 191640 | 12985 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 306 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | 3X3 | 6010818.9339 | 2120706.9936 | 37.8036666476299 | -122.406773977327 | (37.8036666476299, -122.406773977327) | 3 | 1 | 10 | 308 | 23 | |||
| 191595 | 142969 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 155 PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6010117.5609 | 2121101.8588 | 37.8047115814823 | -122.409229006305 | (37.8047115814823, -122.409229006305) | 3 | 1 | 10 | 308 | 23 | |||
| 191363 | 140422 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1499 TURK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 14 | Width 0ft | 6002931.6326 | 2112346.6107 | 37.7802667133087 | -122.433470553427 | (37.7802667133087, -122.433470553427) | 15 | 9 | 11 | 29490 | 41 | |||
| 191265 | 143377 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1851 UNION ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6004143.6971 | 2118693.4827 | 37.7977623133526 | -122.429730277572 | (37.7977623133526, -122.429730277572) | 13 | 9 | 1 | 57 | 17 | |||
| 191174 | 13286 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2599 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/16/1993 12:00:00 AM | 12 | 3X3 | 6000047.9587 | 2119131.9019 | 37.7987333214715 | -122.443934134594 | (37.7987333214715, -122.443934134594) | 13 | 9 | 1 | 57 | 17 | ||
| 191153 | 140423 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1499 TURK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 13 | Width 0ft | 6002956.7531 | 2112350.9171 | 37.7802799627924 | -122.433383957928 | (37.7802799627924, -122.433383957928) | 15 | 9 | 11 | 29490 | 41 | |||
| 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 | ||||
| 191040 | 254075 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 901 Brannan St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6010957 | 2108832 | 37.7710684598289 | -122.405459366064 | (37.7710684598289, -122.405459366064) | 14 | 2 | 9 | 28853 | 34 | ||||
| 190808 | 7213 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 950 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6003452.6284 | 2111644.2112 | 37.7783676442869 | -122.43161802827 | (37.7783676442869, -122.43161802827) | 15 | 9 | 11 | 29492 | 41 | |||
| 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 | |||
| 190736 | 143523 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1931 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6003741.1066 | 2118636.3409 | 37.7975826116174 | -122.431119270729 | (37.7975826116174, -122.431119270729) | 13 | 9 | 1 | 57 | 17 | |||
| 190613 | 7021 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1105 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6002080.4157 | 2110140.9294 | 37.7741621348105 | -122.436257405533 | (37.7741621348105, -122.436257405533) | 15 | 5 | 11 | 29492 | 10 | |||
| 190509 | 27413 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1125 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6002017.7522 | 2110131.5591 | 37.7741328457417 | -122.436473498525 | (37.7741328457417, -122.436473498525) | 15 | 5 | 11 | 29492 | 10 | |||
| 190495 | 55481 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 530 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1972 12:00:00 AM | 13 | Permit Number 11434 | 6002173.9724 | 2110343.1732 | 37.7747227610629 | -122.435948251092 | (37.7747227610629, -122.435948251092) | 15 | 5 | 11 | 29492 | 10 | ||
| 190419 | 113773 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1718 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 4x6 | 6000060.5464 | 2114943.4646 | 37.7872336928249 | -122.443589534945 | (37.7872336928249, -122.443589534945) | 13 | 6 | 1 | 29490 | 27 | |||
| 190297 | 141778 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 9 Hollis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6003916.891 | 2113262.7794 | 37.7828381339765 | -122.430127467778 | (37.7828381339765, -122.430127467778) | 7 | 9 | 11 | 29490 | 41 | |||
| 190035 | 143371 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1801 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6004332.6549 | 2118719.4563 | 37.7978443281947 | -122.429078284228 | (37.7978443281947, -122.429078284228) | 13 | 9 | 1 | 57 | 17 | |||
| 189942 | 141780 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1480 ELLIS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6003842.3971 | 2113219.4567 | 37.7827149612606 | -122.430382093414 | (37.7827149612606, -122.430382093414) | 7 | 9 | 11 | 29490 | 41 | |||
| 189603 | 244508 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 470 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003685.2048 | 2109943.0159 | 37.7737097618778 | -122.430692031876 | (37.7737097618778, -122.430692031876) | 7 | 9 | 11 | 29492 | 10 | |||
| 189533 | 532 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2850 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6009709.5998 | 2102220.1735 | 37.7528440615121 | -122.409307515735 | (37.7528440615121, -122.409307515735) | 2 | 4 | 7 | 28859 | 19 | |||
| 189470 | 245460 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2940 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6007306.1163 | 2106778.6027 | 37.7652255036159 | -122.417942338761 | (37.7652255036159, -122.417942338761) | 8 | 4 | 7 | 28853 | 19 | |||
| 189309 | 140143 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2077 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/1981 12:00:00 AM | 9 | Width 0ft | Permit Number 19125 | 5997871.2148 | 2109901.8816 | 37.7732657172386 | -122.45080046745 | (37.7732657172386, -122.45080046745) | 15 | 5 | 11 | 29492 | 16 | |
| 189104 | 7169 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 801 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | Permit Number 780067 | 6003470.3756 | 2111160.9753 | 37.7770418043343 | -122.431522126808 | (37.7770418043343, -122.431522126808) | 15 | 9 | 11 | 29492 | 10 | ||
| 188527 | 247347 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1563 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999077.9485 | 2109033.7671 | 37.7709511000472 | -122.446563758939 | (37.7709511000472, -122.446563758939) | 15 | 5 | 11 | 29492 | 9 | |||
| 188448 | 113470 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 27 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6x6 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||||
| 188275 | 59956 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 426 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/1981 12:00:00 AM | 16 | Permit Number 19433 | 6005279.4106 | 2111149.1414 | 37.7771116781194 | -122.42526326419 | (37.7771116781194, -122.42526326419) | 7 | 9 | 11 | 28852 | 10 | ||
| 188191 | 140047 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 997 STEINER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1981 12:00:00 AM | 17 | Width 0ft | Permit Number 19087 | 6002926.2641 | 2111608.0681 | 37.778238555435 | -122.433436333455 | (37.778238555435, -122.433436333455) | 15 | 9 | 11 | 29492 | 41 | |
| 188166 | 7161 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 726 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003541.3006 | 2110998.0762 | 37.7765985433792 | -122.431265144599 | (37.7765985433792, -122.431265144599) | 7 | 9 | 11 | 29492 | 10 | |||
| 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 | |||
| 187807 | 248407 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 39 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5999275.3753 | 2108109.8322 | 37.7684254834855 | -122.445814398115 | (37.7684254834855, -122.445814398115) | 15 | 5 | 11 | 29492 | 9 | |||
| 187722 | 140048 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 993 STEINER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | Permit Number 19087 | 6002927.2794 | 2111591.8239 | 37.7781940105178 | -122.433431660039 | (37.7781940105178, -122.433431660039) | 15 | 9 | 11 | 29492 | 41 | ||
| 187565 | 33694 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 401 Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | 12 | Permit Number 37765 | 6005381.091 | 2111139.6901 | 37.7770914710207 | -122.424910846803 | (37.7770914710207, -122.424910846803) | 7 | 9 | 11 | 28852 | 10 | ||
| 187119 | 524 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2826 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6009890.4218 | 2102229.0519 | 37.7528785688198 | -122.408682823354 | (37.7528785688198, -122.408682823354) | 2 | 4 | 7 | 28859 | 19 | |||
| 186972 | 246125 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1546 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/1979 12:00:00 AM | 13 | Width 0ft | Permit Number 17701 | 5998276.9478 | 2108272.4514 | 37.7688149359981 | -122.449279571151 | (37.7688149359981, -122.449279571151) | 15 | 5 | 11 | 29492 | 9 | |
| 186831 | 16865 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 230 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005838.6934 | 2110371.3705 | 37.7750076883115 | -122.423273225017 | (37.7750076883115, -122.423273225017) | 7 | 9 | 11 | 28852 | 10 | |||
| 186769 | 143518 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2162 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6002654.3286 | 2118533.4904 | 37.797238567372 | -122.434872450071 | (37.797238567372, -122.434872450071) | 13 | 9 | 1 | 57 | 17 | |||
| 186726 | 143519 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2174 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6002630.1383 | 2118528.26 | 37.7972228325878 | -122.434955780242 | (37.7972228325878, -122.434955780242) | 13 | 9 | 1 | 57 | 17 | |||
| 186358 | 247445 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 811 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003098.9445 | 2109936.0688 | 37.7736574554899 | -122.432719499751 | (37.7736574554899, -122.432719499751) | 15 | 5 | 11 | 29492 | 9 | |||
| 186344 | 140691 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1120 FILLMORE ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003358.8311 | 2112311.3938 | 37.7801942444853 | -122.431990162179 | (37.7801942444853, -122.431990162179) | 15 | 9 | 11 | 29490 | 41 | |||
| 186282 | 138371 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2060 SUTTER ST | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | Width 0ft | 6002611.3346 | 2114434.447 | 37.7859812067704 | -122.434727951803 | (37.7859812067704, -122.434727951803) | 13 | 9 | 11 | 29490 | 27 | |||
| 186155 | 16983 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 847 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002927.3278 | 2109904.9371 | 37.7735622410817 | -122.433310922729 | (37.7735622410817, -122.433310922729) | 15 | 5 | 11 | 29492 | 9 | |||
| 186087 | 140145 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2077 HAYES ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5997912.6072 | 2109907.6306 | 37.7732838718856 | -122.450657700787 | (37.7732838718856, -122.450657700787) | 15 | 5 | 11 | 29492 | 16 | |||
| 186082 | 108616 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 289 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6010459.7673 | 2120958.2392 | 37.8043364033733 | -122.408034626667 | (37.8043364033733, -122.408034626667) | 3 | 1 | 10 | 308 | 23 | |||
| 185736 | 138539 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1700 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003089.8085 | 2114203.6138 | 37.7853745495912 | -122.433056065597 | (37.7853745495912, -122.433056065597) | 13 | 9 | 11 | 29490 | 13 | |||
| 185720 | 139434 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 406 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6005390.0639 | 2111164.7368 | 37.7771607499747 | -122.424881589077 | (37.7771607499747, -122.424881589077) | 7 | 9 | 11 | 28852 | 10 | |||
| 185698 | 143162 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 175 Bay St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6009943.6415 | 2121579.1756 | 37.8060124294215 | -122.409864588833 | (37.8060124294215, -122.409864588833) | 3 | 1 | 10 | 308 | 23 | |||
| 185363 | 10403 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1369 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3X3 | 5999594.2543 | 2108755.1609 | 37.7702155954819 | -122.44475781987 | (37.7702155954819, -122.44475781987) | 15 | 5 | 11 | 29492 | 9 | |||
| 185324 | 57510 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 630 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/1976 12:00:00 AM | 16 | Permit Number 16363 | 6005412.5487 | 2111488.2587 | 37.7780503321524 | -122.424826828837 | (37.7780503321524, -122.424826828837) | 7 | 9 | 11 | 28852 | 10 | ||
| 184958 | 140491 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1396 Turk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6003381.0328 | 2112450.7507 | 37.7805781423675 | -122.431923310003 | (37.7805781423675, -122.431923310003) | 15 | 9 | 11 | 29490 | 41 | |||
| 184887 | 137574 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1135 STEINER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6002846.9387 | 2112168.7066 | 37.7797734277366 | -122.433750829498 | (37.7797734277366, -122.433750829498) | 15 | 9 | 11 | 29490 | 41 | |||
| 184798 | 140713 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500 PIERCE ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6002640.192 | 2110470.3137 | 37.775098331299 | -122.434344596397 | (37.775098331299, -122.434344596397) | 15 | 5 | 11 | 29492 | 10 | |||
| 184765 | 142517 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 402 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | Width 0ft | 6010454.8754 | 2118953.3694 | 37.798831249998 | -122.407910090593 | (37.798831249998, -122.407910090593) | 3 | 1 | 10 | 308 | 23 | |||
| 184752 | 142629 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 725 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6009330.2372 | 2119895.0012 | 37.8013537106151 | -122.41186829545 | (37.8013537106151, -122.41186829545) | 3 | 1 | 10 | 308 | 4 | |||
| 184681 | 16981 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 837 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002980.1732 | 2109918.2793 | 37.7736018732822 | -122.433129076252 | (37.7736018732822, -122.433129076252) | 15 | 5 | 11 | 29492 | 9 | |||
| 184520 | 113774 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1716 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 6000066.4859 | 2114892.9793 | 37.7870954120643 | -122.443565357608 | (37.7870954120643, -122.443565357608) | 13 | 6 | 1 | 29490 | 27 | |||
| 184369 | 13052 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 557 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6009686.1191 | 2120512.8313 | 37.8030700779734 | -122.410680437216 | (37.8030700779734, -122.410680437216) | 3 | 1 | 10 | 308 | 23 | |||
| 184353 | 142464 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1456 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6010990.4041 | 2119956.0656 | 37.8016143761567 | -122.406127656852 | (37.8016143761567, -122.406127656852) | 3 | 1 | 10 | 308 | 23 | |||
| 184065 | 15445 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2250 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006857.7723 | 2105245.8857 | 37.7609917781074 | -122.419384314212 | (37.7609917781074, -122.419384314212) | 2 | 4 | 7 | 28859 | 19 | |||
| 183700 | 141776 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 5 Hollis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6003896.2863 | 2113355.7647 | 37.783092281356 | -122.430205387238 | (37.783092281356, -122.430205387238) | 7 | 9 | 11 | 29490 | 41 | |||
| 183591 | 138360 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2060 SUTTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | Width 0ft | 6002847.7164 | 2114462.1983 | 37.7860708218731 | -122.433912120385 | (37.7860708218731, -122.433912120385) | 13 | 9 | 11 | 29490 | 27 | |||
| 183457 | 14559 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1595X Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5999419.8987 | 2109421.334 | 37.772034786606 | -122.445408819898 | (37.772034786606, -122.445408819898) | 15 | 5 | 11 | 29492 | 9 | |||
| 183288 | 491 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2749X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6010371.9231 | 2102214.4775 | 37.7528655070754 | -122.407016666927 | (37.7528655070754, -122.407016666927) | 10 | 4 | 7 | 28859 | 19 | |||
| 183064 | 246151 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1622 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5997783.0336 | 2108202.195 | 37.7685937659628 | -122.450982909765 | (37.7685937659628, -122.450982909765) | 15 | 5 | 11 | 29492 | 9 | |||
| 182991 | 21588 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 Sutter St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 6005294.0011 | 2114805.6563 | 37.7871523906748 | -122.425473076473 | (37.7871523906748, -122.425473076473) | 13 | 9 | 11 | 28858 | 27 | |||
| 182958 | 138718 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1605 Lyon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5999603.495 | 2114383.6783 | 37.7856705883683 | -122.445130569247 | (37.7856705883683, -122.445130569247) | 15 | 6 | 1 | 29490 | 31 | |||
| 182947 | 33693 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 401 Ivy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | 13 | Permit Number 37765 | 6005397.8063 | 2111143.0332 | 37.7771015944949 | -122.424853261184 | (37.7771015944949, -122.424853261184) | 7 | 9 | 11 | 28852 | 10 | ||
| 182946 | 244167 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 443 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5997917.5884 | 2109065.1071 | 37.7709708040394 | -122.450579717232 | (37.7709708040394, -122.450579717232) | 15 | 5 | 11 | 29492 | 9 | |||
| 182944 | 245112 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1511 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999762.5828 | 2109470.1939 | 37.7721884999222 | -122.444226964495 | (37.7721884999222, -122.444226964495) | 15 | 5 | 11 | 29492 | 9 | |||
| 182903 | 21608 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1531 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/1990 12:00:00 AM | 12 | 4X4 | 6005005.2261 | 2114710.5754 | 37.7868750020607 | -122.42646540299 | (37.7868750020607, -122.42646540299) | 13 | 9 | 11 | 28858 | 13 | ||
| 182746 | 10463 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1584 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3x3 | 5998533.6334 | 2108659.497 | 37.7698923436585 | -122.448419594554 | (37.7698923436585, -122.448419594554) | 15 | 5 | 11 | 29492 | 9 | |||
| 182571 | 246085 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 668 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5999025.5413 | 2108408.7245 | 37.7692318980119 | -122.446700056431 | (37.7692318980119, -122.446700056431) | 15 | 5 | 11 | 29492 | 9 | |||
| 182384 | 16962 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 729 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003498.0043 | 2109990.6447 | 37.7738299314263 | -122.431342987883 | (37.7738299314263, -122.431342987883) | 15 | 9 | 11 | 29492 | 10 | |||
| 181998 | 138373 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1801 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | Width 0ft | 6002557.3186 | 2114515.2232 | 37.7861999309178 | -122.434920611081 | (37.7861999309178, -122.434920611081) | 13 | 9 | 11 | 29490 | 27 | |||
| 181995 | 16963 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 741 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003456.556 | 2109979.0777 | 37.7737958222062 | -122.431485538257 | (37.7737958222062, -122.431485538257) | 15 | 9 | 11 | 29492 | 10 | |||
| 181674 | 245078 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1387 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6000393.4407 | 2109556.4466 | 37.7724612989944 | -122.442050971779 | (37.7724612989944, -122.442050971779) | 15 | 5 | 11 | 29492 | 9 | |||
| 181651 | 59592 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1610 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/1981 12:00:00 AM | 13 | Permit Number 18989 | 6000112.8301 | 2114568.7427 | 37.7862077855538 | -122.443381719167 | (37.7862077855538, -122.443381719167) | 13 | 6 | 1 | 29490 | 27 | ||
| 181551 | 244967 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 290 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6005160.4976 | 2110090.7807 | 37.7741989587748 | -122.425599278654 | (37.7741989587748, -122.425599278654) | 7 | 9 | 11 | 28852 | 10 | |||
| 181493 | 143163 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2130 STOCKTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6009857.4165 | 2121454.9705 | 37.8056665605493 | -122.410154211058 | (37.8056665605493, -122.410154211058) | 3 | 1 | 10 | 308 | 23 | |||
| 181350 | 140504 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1020 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6003445.3738 | 2111793.5292 | 37.7787772231874 | -122.431653787974 | (37.7787772231874, -122.431653787974) | 15 | 9 | 11 | 29490 | 41 | |||
| 181278 | 7170 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 801 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | Permit Number 780067 | 6003473.1451 | 2111141.589 | 37.7769887313283 | -122.43151116193 | (37.7769887313283, -122.43151116193) | 15 | 9 | 11 | 29492 | 10 | ||
| 181093 | 139436 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 410 Ivy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6005361.8436 | 2111159.167 | 37.7771438626442 | -122.424978815742 | (37.7771438626442, -122.424978815742) | 7 | 9 | 11 | 28852 | 10 |
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) );