trees
1,381 rows where qSpecies_id = 54
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19779 | 140264 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2100X Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 5997701.9343 | 2110276.144 | 37.7742836533846 | -122.451413027686 | (37.7742836533846, -122.451413027686) | 15 | 5 | 2 | 29492 | 16 | |||
| 20537 | 141610 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1501 Fulton St | 4 | 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 | |||
| 20716 | 5146 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 217 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6001830.6224 | 2108865.7235 | 37.7706465411236 | -122.437030167851 | (37.7706465411236, -122.437030167851) | 15 | 5 | 11 | 29492 | 9 | |||
| 20967 | 64425 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 259 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/1988 12:00:00 AM | 9 | Permit Number 25277 | 6010096.4211 | 2121261.5999 | 37.8051490065079 | -122.409313442808 | (37.8051490065079, -122.409313442808) | 3 | 1 | 10 | 308 | 23 | ||
| 21039 | 97936 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2133 Stockton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6009809.8586 | 2121486.2629 | 37.8057498158932 | -122.410321003577 | (37.8057498158932, -122.410321003577) | 3 | 1 | 10 | 308 | 23 | |||
| 21051 | 141109 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 154 WOOD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5998503.1758 | 2112860.4826 | 37.7814254265925 | -122.448827586566 | (37.7814254265925, -122.448827586566) | 15 | 6 | 2 | 54 | 16 | |||
| 21231 | 142496 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 523 UNION ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6010454.4069 | 2119574.2954 | 37.8005361345001 | -122.40795552252 | (37.8005361345001, -122.40795552252) | 3 | 1 | 10 | 308 | 23 | |||
| 21482 | 540 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2869 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6009646.1294 | 2102175.7647 | 37.7527185686087 | -122.409523875049 | (37.7527185686087, -122.409523875049) | 2 | 4 | 7 | 28859 | 19 | |||
| 21641 | 17024 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1101 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001643.357 | 2109735.2672 | 37.7730234456568 | -122.437740206634 | (37.7730234456568, -122.437740206634) | 15 | 5 | 11 | 29492 | 9 | |||
| 21747 | 143165 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2130 STOCKTON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6009847.836 | 2121509.3744 | 37.8058154030924 | -122.410191209337 | (37.8058154030924, -122.410191209337) | 3 | 1 | 10 | 308 | 23 | |||
| 22206 | 199853 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2503 Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6014209.1818 | 2092155.2364 | 37.7254588983374 | -122.393042840565 | (37.7254588983374, -122.393042840565) | 10 | 3 | 8 | 58 | 1 | |||
| 22348 | 111433 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500X Presidio Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 5999168.0016 | 2114897.9415 | 37.7870577541309 | -122.446674260217 | (37.7870577541309, -122.446674260217) | 15 | 6 | 1 | 29490 | 31 | |||
| 22419 | 138465 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1870 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6001534.446 | 2114897.4717 | 37.7871913575616 | -122.438486871914 | (37.7871913575616, -122.438486871914) | 13 | 6 | 11 | 29490 | 27 | |||
| 22448 | 143498 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 857 Kearny St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6011217.724 | 2117930.0991 | 37.7960642762572 | -122.405198277055 | (37.7960642762572, -122.405198277055) | 3 | 1 | 10 | 28857 | 4 | |||
| 22527 | 184489 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1866 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5983834.6211 | 2102450.9664 | 37.7519941007524 | -122.498803633975 | (37.7519941007524, -122.498803633975) | 1 | 8 | 3 | 56 | 35 | |||
| 22696 | 143168 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 189 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6009887.869 | 2121571.9902 | 37.8059895743176 | -122.410057091761 | (37.8059895743176, -122.410057091761) | 3 | 1 | 10 | 308 | 23 | |||
| 22833 | 244381 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 221 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6005910.0454 | 2110329.5608 | 37.7748969155572 | -122.423023430361 | (37.7748969155572, -122.423023430361) | 7 | 9 | 11 | 28852 | 10 | |||
| 23337 | 142265 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500 FELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6004973.0459 | 2110598.408 | 37.7755821860494 | -122.426283856756 | (37.7755821860494, -122.426283856756) | 7 | 9 | 11 | 28852 | 10 | |||
| 23351 | 33662 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 453 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2016 12:00:00 AM | 3 | Permit Number 37750 | 6005235.3039 | 2110769.7304 | 37.7760674161616 | -122.425388836438 | (37.7760674161616, -122.425388836438) | 7 | 9 | 11 | 28852 | 10 | ||
| 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 | |||
| 23530 | 245383 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 3720 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | Width 0ft | 6005268.7499 | 2096538.92 | 37.7369948294896 | -122.424260783275 | (37.7369948294896, -122.424260783275) | 2 | 7 | 5 | 28859 | 2 | |||
| 23537 | 143389 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1800 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6004330.7069 | 2118766.2088 | 37.7979725882879 | -122.429088360064 | (37.7979725882879, -122.429088360064) | 13 | 9 | 1 | 57 | 17 | |||
| 23592 | 7266 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1740 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 4X4 | 6003064.3461 | 2114369.1192 | 37.7858275412041 | -122.433155987425 | (37.7858275412041, -122.433155987425) | 13 | 9 | 11 | 29490 | 13 | |||
| 23620 | 141343 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 462 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6001184.3335 | 2110341.7185 | 37.7746624976237 | -122.439371501085 | (37.7746624976237, -122.439371501085) | 15 | 5 | 11 | 29492 | 10 | |||
| 23704 | 7163 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 730 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3X3 | 6003538.8779 | 2111021.3343 | 37.7766622670699 | -122.431275186 | (37.7766622670699, -122.431275186) | 7 | 9 | 11 | 29492 | 10 | |||
| 23778 | 21585 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 6005366.3574 | 2114813.7602 | 37.7871787298771 | -122.425223316098 | (37.7871787298771, -122.425223316098) | 13 | 9 | 11 | 28858 | 27 | |||
| 23864 | 38611 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1570 Revere Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 6 | Permit Number 40556 | 6015254.5205 | 2094308.8703 | 37.7314303593885 | -122.389579509324 | (37.7314303593885, -122.389579509324) | 10 | 3 | 8 | 58 | 1 | |
| 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 | |||
| 24027 | 17108 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1789 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5998462.7101 | 2109289.6892 | 37.7716186353865 | -122.448710312151 | (37.7716186353865, -122.448710312151) | 15 | 5 | 11 | 29492 | 9 | |||
| 24167 | 31656 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1708 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/1995 12:00:00 AM | 9 | 3x3 | Permit Number 35163 | 6004478.3831 | 2114720.074 | 37.7868712864461 | -122.428288835726 | (37.7868712864461, -122.428288835726) | 13 | 9 | 11 | 28858 | 27 | |
| 24256 | 245132 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1585 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999461.1138 | 2109428.314 | 37.7720563046211 | -122.445266756098 | (37.7720563046211, -122.445266756098) | 15 | 5 | 11 | 29492 | 9 | |||
| 24303 | 139447 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 508 OCTAVIA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6005464.5232 | 2111090.4798 | 37.7769610637771 | -122.424618726949 | (37.7769610637771, -122.424618726949) | 7 | 9 | 11 | 28852 | 10 | |||
| 24475 | 183822 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2235 27th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5987905.4957 | 2100075.9969 | 37.7457109948541 | -122.484551945811 | (37.7457109948541, -122.484551945811) | 1 | 8 | 3 | 29491 | 35 | |||
| 24536 | 16993 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 900 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002625.7759 | 2109923.0859 | 37.7735949613156 | -122.434355332323 | (37.7735949613156, -122.434355332323) | 15 | 5 | 11 | 29492 | 10 | |||
| 24624 | 17680 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1020 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002416.7239 | 2112103.0842 | 37.7795688238035 | -122.435234433978 | (37.7795688238035, -122.435234433978) | 15 | 5 | 11 | 29490 | 41 | |||
| 24735 | 137798 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1900 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6004365.9463 | 2115528.293 | 37.7890840898669 | -122.428735478435 | (37.7890840898669, -122.428735478435) | 13 | 9 | 11 | 28858 | 27 | |||
| 24743 | 66562 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 144 Collins St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/10/1991 12:00:00 AM | 5 | Permit Number 29750 | 5998095.4621 | 2113585.8052 | 37.7833936486138 | -122.450290371551 | (37.7833936486138, -122.450290371551) | 15 | 6 | 1 | 54 | 31 | |
| 24828 | 143520 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2174 UNION ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6002609.217 | 2118527.6063 | 37.7972198497902 | -122.435028126326 | (37.7972198497902, -122.435028126326) | 13 | 9 | 1 | 57 | 17 | |||
| 24988 | 143085 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 463 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 6010679.3104 | 2120299.3653 | 37.8025395875062 | -122.40722840197 | (37.8025395875062, -122.40722840197) | 3 | 1 | 10 | 308 | 23 | |||
| 25184 | 244323 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 719 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003563.5505 | 2110000.7658 | 37.7738614359578 | -122.431116975625 | (37.7738614359578, -122.431116975625) | 15 | 9 | 11 | 29492 | 10 | |||
| 25242 | 142827 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1714 POLK ST | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 0ft | 6006619.3625 | 2116773.8493 | 37.7926313555217 | -122.421027406021 | (37.7926313555217, -122.421027406021) | 13 | 9 | 10 | 28858 | 32 | |||
| 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 | |||
| 25346 | 139115 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2613 POST ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999526.5436 | 2113598.8751 | 37.7835113303016 | -122.445340349757 | (37.7835113303016, -122.445340349757) | 15 | 6 | 1 | 29490 | 31 | |||
| 25823 | 140682 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 21366 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5997596.5061 | 2110261.2804 | 37.7742368042101 | -122.451776648803 | (37.7742368042101, -122.451776648803) | 15 | 5 | 2 | 29492 | 16 | |||
| 26277 | 138359 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2060 SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | Width 0ft | 6002861.592 | 2114464.6761 | 37.7860784126894 | -122.433864291751 | (37.7860784126894, -122.433864291751) | 13 | 9 | 11 | 29490 | 27 | |||
| 26414 | 143167 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 195 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6009865.9706 | 2121568.5686 | 37.8059789520686 | -122.410132633272 | (37.8059789520686, -122.410132633272) | 3 | 1 | 10 | 308 | 23 | |||
| 26458 | 248312 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1375 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5999157.272 | 2108349.6728 | 37.7690772810316 | -122.446240160162 | (37.7690772810316, -122.446240160162) | 15 | 5 | 11 | 29492 | 9 | |||
| 26924 | 142123 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 15 HEMWAY TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5998622.5379 | 2110844.3781 | 37.7758965505953 | -122.448269431558 | (37.7758965505953, -122.448269431558) | 15 | 6 | 2 | 29492 | 16 | |||
| 27001 | 7264 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1730 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6003073.6496 | 2114318.6841 | 37.78568958693 | -122.433120195092 | (37.78568958693, -122.433120195092) | 13 | 9 | 11 | 29490 | 13 | |||
| 27045 | 538 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2860 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6009651.0028 | 2102218.3979 | 37.7528359029411 | -122.409510030546 | (37.7528359029411, -122.409510030546) | 2 | 4 | 7 | 28859 | 19 | |||
| 27215 | 13203 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2143 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002126.2145 | 2119425.2487 | 37.7996571038373 | -122.436763723295 | (37.7996571038373, -122.436763723295) | 13 | 9 | 1 | 57 | 17 | |||
| 27263 | 140420 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1120 STEINER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6002874.2144 | 2112292.0633 | 37.7801136820125 | -122.433665289686 | (37.7801136820125, -122.433665289686) | 15 | 9 | 11 | 29490 | 41 | |||
| 27540 | 59659 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 906 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1981 12:00:00 AM | 16 | Permit Number 19081 | 6002986.1752 | 2111478.2094 | 37.7778853946604 | -122.433219797973 | (37.7778853946604, -122.433219797973) | 15 | 9 | 11 | 29492 | 41 | ||
| 27696 | 53066 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2161 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2006 12:00:00 AM | 4 | Permit Number 49038 | 6002280.6463 | 2114328.4092 | 37.7856712745428 | -122.435864451687 | (37.7856712745428, -122.435864451687) | 13 | 6 | 11 | 29490 | 13 | ||
| 27853 | 13195 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2098 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3X3 | 6002408.3176 | 2119538.5881 | 37.7999843325384 | -122.435795658785 | (37.7999843325384, -122.435795658785) | 13 | 9 | 1 | 57 | 17 | |||
| 27911 | 121250 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 31 Orben Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 4x3 | Permit Number 778957 | 6003136.4072 | 2115361.6956 | 37.7885569916775 | -122.432977615629 | (37.7885569916775, -122.432977615629) | 13 | 9 | 1 | 29490 | 27 | ||
| 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 | |||
| 28061 | 244147 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 405 Rose St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6004529.1957 | 2109628.6007 | 37.7728942335898 | -122.427750128017 | (37.7728942335898, -122.427750128017) | 7 | 9 | 11 | 28852 | 10 | |||
| 28067 | 142120 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1218 Grove St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6001961.8598 | 2110867.3987 | 37.7761501011447 | -122.436719523648 | (37.7761501011447, -122.436719523648) | 15 | 5 | 11 | 29492 | 10 | |||
| 28390 | 140425 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1499 TURK ST | 4 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 12 | Width 0ft | 6003006.2764 | 2112357.3766 | 37.7803005084328 | -122.43321309579 | (37.7803005084328, -122.43321309579) | 15 | 9 | 11 | 29490 | 41 | |||
| 28509 | 13126 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1701 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3X3 | 6004190.6649 | 2119706.135 | 37.8005454550984 | -122.429640016754 | (37.8005454550984, -122.429640016754) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | |||
| 29027 | 65538 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2180 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/20/1990 12:00:00 AM | 16 | 6x6 | Permit Number 28435 | 6002182.4791 | 2114372.5672 | 37.7857869442252 | -122.436207242735 | (37.7857869442252, -122.436207242735) | 13 | 6 | 1 | 29490 | 27 |
| 29165 | 108003 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 520 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 4x4 | 6005338.5862 | 2110997.1319 | 37.7766976400209 | -122.425047738741 | (37.7766976400209, -122.425047738741) | 7 | 9 | 11 | 28852 | 10 | |||
| 29405 | 21724 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1942X Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/27/2003 12:00:00 AM | 17 | 4X4 | 6003291.3026 | 2114524.3217 | 37.786266559771 | -122.432381870835 | (37.786266559771, -122.432381870835) | 13 | 9 | 11 | 29490 | 27 | ||
| 29451 | 7685 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 521 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6008756.4018 | 2121076.0419 | 37.8045643433196 | -122.41393762212 | (37.8045643433196, -122.41393762212) | 3 | 1 | 10 | 308 | 23 | |||
| 29602 | 139484 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1216 FULTON ST | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 0ft | 6001778.449 | 2111192.2794 | 37.7770317168845 | -122.437377258879 | (37.7770317168845, -122.437377258879) | 15 | 5 | 11 | 29492 | 41 | |||
| 29624 | 181932 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2378 36th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 0ft | 5985195.246 | 2099024.2764 | 37.7426650525628 | -122.49384596323 | (37.7426650525628, -122.49384596323) | 1 | 8 | 3 | 29491 | 35 | |||
| 29651 | 142950 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 156 Pfeiffer St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6010083.0275 | 2121115.7055 | 37.8047476663275 | -122.409349490891 | (37.8047476663275, -122.409349490891) | 3 | 1 | 10 | 308 | 23 | |||
| 30141 | 143475 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 655 STOCKTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6010503.0699 | 2116501.51 | 37.7921017369748 | -122.407570359871 | (37.7921017369748, -122.407570359871) | 5 | 1 | 10 | 28857 | 21 | |||
| 30158 | 244277 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 595 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | Width 0ft | 6004143 | 2110087 | 37.7741310322057 | -122.429118715156 | (37.7741310322057, -122.429118715156) | 7 | 9 | 11 | 28852 | 10 | |||
| 30164 | 138611 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1711 BAKER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6000013.0072 | 2114911.1445 | 37.7871422388637 | -122.443751687038 | (37.7871422388637, -122.443751687038) | 15 | 6 | 1 | 29490 | 31 | |||
| 30570 | 9642 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1482 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3x3 | 6002517.4506 | 2111986.4237 | 37.7792542228164 | -122.434877632371 | (37.7792542228164, -122.434877632371) | 15 | 5 | 11 | 29490 | 41 | |||
| 30933 | 245077 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1387 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6000372.5007 | 2109554.1199 | 37.7724537171291 | -122.442123238035 | (37.7724537171291, -122.442123238035) | 15 | 5 | 11 | 29492 | 9 | |||
| 30976 | 143334 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1820 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6004249.5395 | 2118755.17 | 37.7979376836352 | -122.429368434888 | (37.7979376836352, -122.429368434888) | 13 | 9 | 1 | 57 | 17 | |||
| 30992 | 141781 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1480 ELLIS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6003816.5092 | 2113214.7018 | 37.7827004390473 | -122.430471315153 | (37.7827004390473, -122.430471315153) | 7 | 9 | 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 | |||
| 31175 | 7267 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1750 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6003061.8978 | 2114394.5816 | 37.7858973156258 | -122.433166277822 | (37.7858973156258, -122.433166277822) | 13 | 9 | 11 | 29490 | 13 | |||
| 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 | |||
| 32066 | 110467 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 465 Grove St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 3x3 | 6005585.7014 | 2111327.1742 | 37.7776178118347 | -122.424216371681 | (37.7776178118347, -122.424216371681) | 7 | 9 | 11 | 28852 | 10 | ||
| 32113 | 17114 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1889X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 5998005.981 | 2109225.1746 | 37.7714153673222 | -122.45028550625 | (37.7714153673222, -122.45028550625) | 15 | 5 | 11 | 29492 | 9 | |||
| 32198 | 143018 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 404 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | Width 0ft | 6010387.0782 | 2120648.4016 | 37.8034815958882 | -122.408264308054 | (37.8034815958882, -122.408264308054) | 3 | 1 | 10 | 308 | 23 | |||
| 32385 | 143482 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 601 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6010529.9358 | 2116279.9602 | 37.7914949183295 | -122.407461776619 | (37.7914949183295, -122.407461776619) | 5 | 1 | 10 | 28857 | 21 | |||
| 32493 | 244027 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 510 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5998001.7833 | 2108800.966 | 37.7702503589654 | -122.45026944288 | (37.7702503589654, -122.45026944288) | 15 | 5 | 11 | 29492 | 9 | |||
| 32823 | 248346 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1575 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5998065.2703 | 2108198.2582 | 37.7685991103156 | -122.45000639696 | (37.7685991103156, -122.45000639696) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | |||
| 33065 | 15307 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1650 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/29/2007 12:00:00 AM | 3 | 4X4 | 6006881.466 | 2109048.7514 | 37.7714348870341 | -122.419572183108 | (37.7714348870341, -122.419572183108) | 8 | 2 | 9 | 28853 | 19 | ||
| 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 | |||
| 33318 | 66182 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1819 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/06/1990 12:00:00 AM | 12 | Permit Number 29259 | 6004371.7533 | 2115130.5363 | 37.7879922787707 | -122.428687021207 | (37.7879922787707, -122.428687021207) | 13 | 9 | 11 | 29490 | 27 | ||
| 33663 | 14813 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1195 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003481.2511 | 2111720.7527 | 37.7785794305459 | -122.431524477475 | (37.7785794305459, -122.431524477475) | 15 | 9 | 11 | 29492 | 41 | |||
| 33807 | 113465 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 20 | 6x6 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | |||
| 33826 | 59960 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 492 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/1981 12:00:00 AM | 21 | Permit Number 19438 | 6005457.1486 | 2111358.1318 | 37.7776955544263 | -122.424663282479 | (37.7776955544263, -122.424663282479) | 7 | 9 | 11 | 28852 | 10 | |
| 33837 | 138854 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 519 Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004884.6976 | 2111071.1642 | 37.7768752647693 | -122.426623147275 | (37.7768752647693, -122.426623147275) | 7 | 9 | 11 | 28852 | 10 | |||
| 34326 | 138368 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2060 SUTTER ST | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6002679.2262 | 2114443.3671 | 37.786009553219 | -122.434493703661 | (37.786009553219, -122.434493703661) | 13 | 9 | 11 | 29490 | 27 | |||
| 34430 | 13280 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2524 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/15/1993 12:00:00 AM | 40 | 3X3 | 6000256.3025 | 2119240.7621 | 37.7990441048198 | -122.443221023077 | (37.7990441048198, -122.443221023077) | 13 | 9 | 1 | 57 | 17 | ||
| 34438 | 142561 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2145 POWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6009379.1154 | 2121092.3828 | 37.8046441645077 | -122.41178381072 | (37.8046441645077, -122.41178381072) | 3 | 1 | 10 | 308 | 23 | |||
| 34527 | 143179 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 37 MIDWAY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6010057.031 | 2121502.7089 | 37.8058088248802 | -122.409466784469 | (37.8058088248802, -122.409466784469) | 3 | 1 | 10 | 308 | 23 | |||
| 34586 | 143521 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2224 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6002337.2397 | 2118485.1098 | 37.7970877186103 | -122.435966192289 | (37.7970877186103, -122.435966192289) | 13 | 9 | 1 | 57 | 17 | |||
| 34608 | 201185 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 620 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6013380.1682 | 2113890.2713 | 37.7850925106546 | -122.397432285471 | (37.7850925106546, -122.397432285471) | 6 | 2 | 9 | 28855 | 6 | |||
| 34952 | 21609 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1531 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/1990 12:00:00 AM | 12 | 4X4 | 6005037.9058 | 2114711.086 | 37.7868782513618 | -122.42635237507 | (37.7868782513618, -122.42635237507) | 13 | 9 | 11 | 28858 | 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) );