trees
1,381 rows where qSpecies_id = 54 sorted by qCareAssistant
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
35064 | 138707 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2874 BUSH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5999741.1485 | 2114383.1871 | 37.7856770956012 | -122.444654293951 | (37.7856770956012, -122.444654293951) | 15 | 6 | 1 | 29490 | 31 | |||
35150 | 138369 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2060 SUTTER ST | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | Width 0ft | 6002665.8461 | 2114439.4026 | 37.7859979081747 | -122.434539711553 | (37.7859979081747, -122.434539711553) | 13 | 9 | 11 | 29490 | 27 | |||
35369 | 140725 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 508 SCOTT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6002187.9434 | 2110254.4569 | 37.7744799618741 | -122.435893573485 | (37.7744799618741, -122.435893573485) | 15 | 5 | 11 | 29492 | 10 | |||
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 | |||
36126 | 63909 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2119 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/1987 12:00:00 AM | 12 | Permit Number 24624 | 6009399.6734 | 2120957.786 | 37.8042757485475 | -122.411703151333 | (37.8042757485475, -122.411703151333) | 3 | 1 | 10 | 308 | 23 | ||
36350 | 137858 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 22 Orben Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6003153.1523 | 2115433.6928 | 37.7887556274538 | -122.43292482586 | (37.7887556274538, -122.43292482586) | 13 | 9 | 1 | 29490 | 27 | |||
36660 | 138731 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2755 BUSH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6000355.1143 | 2114408.2991 | 37.7857810625069 | -122.44253195817 | (37.7857810625069, -122.44253195817) | 15 | 6 | 1 | 29490 | 27 | |||
36701 | 59351 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 503 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52085 | 6000121.1922 | 2110676.4601 | 37.7755210539143 | -122.443073153769 | (37.7755210539143, -122.443073153769) | 15 | 5 | 11 | 29492 | 16 | |
36792 | 244324 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 717 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003593.9138 | 2110004.6215 | 37.7738737432923 | -122.431012219304 | (37.7738737432923, -122.431012219304) | 15 | 9 | 11 | 29492 | 10 | |||
36803 | 143527 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1979 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003537.8633 | 2118608.4193 | 37.7974944269949 | -122.431820551935 | (37.7974944269949, -122.431820551935) | 13 | 9 | 1 | 57 | 17 | |||
37007 | 13191 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2095 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002470.5921 | 2119469.4635 | 37.7997980716779 | -122.435575217756 | (37.7997980716779, -122.435575217756) | 13 | 9 | 1 | 57 | 17 | |||
37114 | 13143 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1800 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X3 | 6003680.9036 | 2119717.0807 | 37.8005466318744 | -122.431404778789 | (37.8005466318744, -122.431404778789) | 13 | 9 | 1 | 57 | 17 | |||
37283 | 201180 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 608 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6013469.6258 | 2113973.5593 | 37.785326180656 | -122.397128630227 | (37.785326180656, -122.397128630227) | 6 | 2 | 9 | 28855 | 6 | |||
37528 | 13212 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2190 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 70 | 3X3 | 6001925.0681 | 2119471.9545 | 37.7997739121356 | -122.437463108341 | (37.7997739121356, -122.437463108341) | 13 | 9 | 1 | 57 | 17 | |||
37790 | 142634 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 241 BAY ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6009751.1154 | 2121551.1896 | 37.8059247953292 | -122.410528881628 | (37.8059247953292, -122.410528881628) | 3 | 1 | 10 | 308 | 23 | |||
37814 | 13181 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2001 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002704.7439 | 2119503.7145 | 37.7999054122901 | -122.434767417241 | (37.7999054122901, -122.434767417241) | 13 | 9 | 1 | 57 | 17 | |||
37866 | 67753 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 900 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1992 12:00:00 AM | 11 | 3x3 | Permit Number 31377 | 6011258.7412 | 2118020.5233 | 37.79631485229 | -122.405062718866 | (37.79631485229, -122.405062718866) | 3 | 1 | 10 | 308 | 4 | |
37910 | 244243 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 150 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6005806.4217 | 2110019.2116 | 37.7740389237303 | -122.423359820085 | (37.7740389237303, -122.423359820085) | 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) );