trees
1,381 rows where qSpecies_id = 54 sorted by Police Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4593 | 4724 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1050 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 4x4 | 6008259.9153 | 2120954.1415 | 37.8042017393393 | -122.415647128831 | (37.8042017393393, -122.415647128831) | 5 | 1 | 10 | 308 | 23 | |||
| 5517 | 4664 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 600X Columbus Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 5X5 | 6009692.468 | 2119649.5892 | 37.8007001848924 | -122.410597470914 | (37.8007001848924, -122.410597470914) | 3 | 1 | 10 | 308 | 23 | |||
| 5587 | 4662 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 600X Columbus Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 5X5 | 6009727.0981 | 2119617.2678 | 37.8006133797513 | -122.410475352391 | (37.8006133797513, -122.410475352391) | 3 | 1 | 10 | 308 | 23 | |||
| 6549 | 142706 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 567 BAY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6008189.6261 | 2121340.372 | 37.8052582795068 | -122.415917737693 | (37.8052582795068, -122.415917737693) | 5 | 1 | 10 | 308 | 23 | |||
| 7583 | 142470 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1443 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6010970.8958 | 2119887.8443 | 37.8014259659921 | -122.406190355577 | (37.8014259659921, -122.406190355577) | 3 | 1 | 10 | 308 | 23 | |||
| 7836 | 72023 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 655 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6010509.9754 | 2116460.1743 | 37.7919886256319 | -122.407543551006 | (37.7919886256319, -122.407543551006) | 5 | 1 | 10 | 28857 | 21 | |||
| 8143 | 142468 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1455 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6010964.6624 | 2119932.1708 | 37.8015473270449 | -122.406215050843 | (37.8015473270449, -122.406215050843) | 3 | 1 | 10 | 308 | 23 | |||
| 9158 | 4659 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 600X Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 5X5 | 6009780.1976 | 2119571.0943 | 37.8004895753531 | -122.410288343699 | (37.8004895753531, -122.410288343699) | 3 | 1 | 10 | 308 | 23 | |||
| 12953 | 4663 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 600X Columbus Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 5X5 | 6009710.0139 | 2119634.3519 | 37.8006593307081 | -122.41053567802 | (37.8006593307081, -122.41053567802) | 3 | 1 | 10 | 308 | 23 | |||
| 16546 | 143187 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 184 FRANCISCO ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6010390.2098 | 2121342.6183 | 37.8053879184635 | -122.408302464879 | (37.8053879184635, -122.408302464879) | 3 | 1 | 10 | 308 | 23 | |||
| 17669 | 64062 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1205 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/18/1990 12:00:00 AM | 7 | Permit Number 29268 | 6011082.0743 | 2119072.3147 | 37.799192938755 | -122.405748149412 | (37.799192938755, -122.405748149412) | 3 | 1 | 10 | 308 | 23 | |
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |
| 38348 | 142947 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 21 Bellair Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6010050.2611 | 2121139.8618 | 37.8048121576562 | -122.40946458873 | (37.8048121576562, -122.40946458873) | 3 | 1 | 10 | 308 | 23 | |||
| 38413 | 4600 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 256 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 3X3 | 6010961.6739 | 2118493.2807 | 37.7975963184564 | -122.406123962239 | (37.7975963184564, -122.406123962239) | 3 | 1 | 10 | 308 | 23 | |||
| 39581 | 142525 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 301 FRANCISCO ST | 15 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 23 | Width 0ft | 6009759.5801 | 2121214.59 | 37.8050010513122 | -122.410475804946 | (37.8050010513122, -122.410475804946) | 3 | 1 | 10 | 308 | 23 | |||
| 39600 | 143497 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 867 Kearny St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6011217.2579 | 2117938.9551 | 37.7960885666374 | -122.40520051379 | (37.7960885666374, -122.40520051379) | 3 | 1 | 10 | 28857 | 4 | |||
| 39745 | 142504 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 610 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/29/1999 12:00:00 AM | 12 | Width 0ft | 6010596.4955 | 2118942.3174 | 37.7988088315184 | -122.407419256939 | (37.7988088315184, -122.407419256939) | 3 | 1 | 10 | 308 | 23 | ||
| 40786 | 143180 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 37 MIDWAY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6010061.0151 | 2121485.1789 | 37.8057609150954 | -122.409451758875 | (37.8057609150954, -122.409451758875) | 3 | 1 | 10 | 308 | 23 | |||
| 41482 | 142934 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1201 KEARNY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6011088.1877 | 2119032.3 | 37.7990834099948 | -122.405724174807 | (37.7990834099948, -122.405724174807) | 3 | 1 | 10 | 308 | 23 | |||
| 41625 | 142631 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 241 BAY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6009683.097 | 2121540.8838 | 37.8058926846956 | -122.410763542627 | (37.8058926846956, -122.410763542627) | 3 | 1 | 10 | 308 | 23 | |||
| 41771 | 143014 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 488 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6010067.5326 | 2120604.4864 | 37.8033431173057 | -122.409367013095 | (37.8033431173057, -122.409367013095) | 3 | 1 | 10 | 308 | 23 | |||
| 42465 | 142940 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 318 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 6010703.4174 | 2118721.6624 | 37.7982089506036 | -122.407033709348 | (37.7982089506036, -122.407033709348) | 3 | 1 | 10 | 308 | 23 | |||
| 42890 | 142518 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 420 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6010399.3582 | 2119003.2321 | 37.7989650524767 | -122.408105717547 | (37.7989650524767, -122.408105717547) | 3 | 1 | 10 | 308 | 23 | |||
| 44783 | 142491 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 651 COLUMBUS AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6009641.4463 | 2119604.1083 | 37.8005724449635 | -122.410770813978 | (37.8005724449635, -122.410770813978) | 3 | 1 | 10 | 308 | 4 | |||
| 45570 | 142505 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 620 Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2014 12:00:00 AM | 22 | Width 0ft | Permit Number 774306 | 6010566.6807 | 2118940.2612 | 37.7988015168915 | -122.407522281284 | (37.7988015168915, -122.407522281284) | 3 | 1 | 10 | 308 | 23 | |
| 45707 | 142945 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 152 PFEIFFER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6010109.3364 | 2121119.0539 | 37.8047583341863 | -122.409258682298 | (37.8047583341863, -122.409258682298) | 3 | 1 | 10 | 308 | 23 | |||
| 45716 | 97934 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2133 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6009804.1904 | 2121525.9403 | 37.8058584423979 | -122.410343422594 | (37.8058584423979, -122.410343422594) | 3 | 1 | 10 | 308 | 23 | |||
| 46642 | 142949 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 20 BELLAIR PL | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6010058.1538 | 2121167.8448 | 37.8048894342531 | -122.40943925119 | (37.8048894342531, -122.40943925119) | 3 | 1 | 10 | 308 | 23 | |||
| 46849 | 99233 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1111 Columbus Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008063.2168 | 2121048.832 | 37.8044506767497 | -122.416334531861 | (37.8044506767497, -122.416334531861) | 5 | 1 | 10 | 308 | 32 | |||
| 47497 | 142605 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 700 CHESTNUT ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6008282.9909 | 2120710.7963 | 37.8035348717489 | -122.415550034395 | (37.8035348717489, -122.415550034395) | 5 | 1 | 10 | 308 | 32 | |||
| 48457 | 4725 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1050 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 4x4 | 6008238.1211 | 2120976.4945 | 37.8042618899237 | -122.415724133248 | (37.8042618899237, -122.415724133248) | 5 | 1 | 10 | 308 | 23 | |||
| 48538 | 142516 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1205 KEARNY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6011083.7416 | 2119059.5323 | 37.7991579346332 | -122.405741479105 | (37.7991579346332, -122.405741479105) | 3 | 1 | 10 | 308 | 23 | |||
| 49360 | 142923 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1249 KEARNY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6011057.7598 | 2119245.0173 | 37.7996657782982 | -122.405844458331 | (37.7996657782982, -122.405844458331) | 3 | 1 | 10 | 308 | 23 | |||
| 49487 | 143166 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2130 STOCKTON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6009846.1251 | 2121530.2463 | 37.8058726162247 | -122.410198604722 | (37.8058726162247, -122.410198604722) | 3 | 1 | 10 | 308 | 23 | |||
| 50284 | 142633 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 241 BAY ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6009714.0145 | 2121546.0367 | 37.8059085667329 | -122.410656911507 | (37.8059085667329, -122.410656911507) | 3 | 1 | 10 | 308 | 23 | |||
| 50609 | 142472 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1429 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6010978.9762 | 2119829.6657 | 37.8012666737636 | -122.406158292447 | (37.8012666737636, -122.406158292447) | 3 | 1 | 10 | 308 | 23 | |||
| 50942 | 142593 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 365 COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6008314.0969 | 2120822.0003 | 37.8038419583694 | -122.415450267897 | (37.8038419583694, -122.415450267897) | 5 | 1 | 10 | 308 | 32 | |||
| 51491 | 143169 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 185 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6009906.0036 | 2121573.3589 | 37.8059943488203 | -122.4099944305 | (37.8059943488203, -122.4099944305) | 3 | 1 | 10 | 308 | 23 | |||
| 52068 | 142514 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 624 VALLEJO ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2014 12:00:00 AM | 20 | Width 0ft | Permit Number 774306 | 6010535.3238 | 2118936.1488 | 37.7987884700296 | -122.407630496745 | (37.7987884700296, -122.407630496745) | 3 | 1 | 10 | 308 | 23 | |
| 55085 | 143481 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 626 PINE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6010890.3641 | 2116278.8196 | 37.7915119538645 | -122.40621461367 | (37.7915119538645, -122.40621461367) | 5 | 1 | 10 | 28857 | 6 | |||
| 55400 | 18519 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1700X Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 30 | 3X3 | 6009627.5943 | 2119520.0726 | 37.8003409270103 | -122.410812809398 | (37.8003409270103, -122.410812809398) | 3 | 1 | 10 | 308 | 4 | |||
| 56468 | 143504 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 3 Gerke Aly | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6010525.4571 | 2120179.6266 | 37.8022022028818 | -122.407752365718 | (37.8022022028818, -122.407752365718) | 3 | 1 | 10 | 308 | 23 | |||
| 57394 | 142946 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 154 Pfeiffer St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6010096.4211 | 2121116.6622 | 37.8047510435874 | -122.409303208326 | (37.8047510435874, -122.409303208326) | 3 | 1 | 10 | 308 | 23 | |||
| 59458 | 143246 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 647 CHESTNUT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6008746.811 | 2120723.5878 | 37.8035960540957 | -122.413945863948 | (37.8035960540957, -122.413945863948) | 3 | 1 | 10 | 308 | 23 | |||
| 60133 | 4721 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1040 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 5x5 | 6008335.3567 | 2120887.0824 | 37.8040218523597 | -122.415381307054 | (37.8040218523597, -122.415381307054) | 5 | 1 | 10 | 308 | 23 | |||
| 61057 | 143188 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 184 FRANCISCO ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6010371.7665 | 2121341.3009 | 37.8053832684295 | -122.40836619766 | (37.8053832684295, -122.40836619766) | 3 | 1 | 10 | 308 | 23 | |||
| 63571 | 4684 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 722 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6009311.9987 | 2119994.7358 | 37.8016265338502 | -122.411938460907 | (37.8016265338502, -122.411938460907) | 3 | 1 | 10 | 308 | 23 | |||
| 65586 | 59151 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 112 Pfeiffer St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/1980 12:00:00 AM | 13 | Permit Number 18460 | 6010290.1497 | 2121142.971 | 37.8048341329685 | -122.408634644798 | (37.8048341329685, -122.408634644798) | 3 | 1 | 10 | 308 | 23 | ||
| 66122 | 142987 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1871 Grant Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6010368.8695 | 2120931.1728 | 37.8042569960583 | -122.408347277199 | (37.8042569960583, -122.408347277199) | 3 | 1 | 10 | 308 | 23 | |||
| 66267 | 12998 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 348 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3X3 | 6010660.6396 | 2120687.9769 | 37.8036055743317 | -122.407320424126 | (37.8036055743317, -122.407320424126) | 3 | 1 | 10 | 308 | 23 | |||
| 67040 | 142933 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 502 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6011075.0739 | 2119008.1155 | 37.7990162718949 | -122.405767848781 | (37.7990162718949, -122.405767848781) | 3 | 1 | 10 | 308 | 23 | |||
| 67375 | 13020 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 423 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3X3 | 6010295.8571 | 2120595.8738 | 37.8033322591341 | -122.40857627636 | (37.8033322591341, -122.40857627636) | 3 | 1 | 10 | 308 | 23 | |||
| 68433 | 142988 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1861 Grant Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6010372.0828 | 2120911.5359 | 37.804203257928 | -122.408334771369 | (37.804203257928, -122.408334771369) | 3 | 1 | 10 | 308 | 23 | |||
| 72010 | 56572 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 238 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 6010130.9034 | 2121308.9776 | 37.805281025756 | -122.409197457422 | (37.805281025756, -122.409197457422) | 3 | 1 | 10 | 308 | 23 | ||||
| 76001 | 115985 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 900 Kearny St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6011253.148 | 2118063.4049 | 37.7964322821358 | -122.405085093558 | (37.7964322821358, -122.405085093558) | 3 | 1 | 10 | 308 | 4 | |||
| 76877 | 53483 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 647 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/1969 12:00:00 AM | 16 | Permit Number 6392 | 6008737.1169 | 2120721.7235 | 37.8035903907477 | -122.413979278997 | (37.8035903907477, -122.413979278997) | 3 | 1 | 10 | 308 | 23 | ||
| 77347 | 142506 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1223 KEARNY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6011074.9884 | 2119120.527 | 37.7993249217375 | -122.405776067035 | (37.7993249217375, -122.405776067035) | 3 | 1 | 10 | 308 | 23 | |||
| 78294 | 142948 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 20 BELLAIR PL | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6010061.9805 | 2121140.5793 | 37.8048147843729 | -122.409424083009 | (37.8048147843729, -122.409424083009) | 3 | 1 | 10 | 308 | 23 | |||
| 78902 | 143556 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 848 KEARNY ST | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 0ft | 6011275.0549 | 2117918.4465 | 37.7960354859857 | -122.404999078913 | (37.7960354859857, -122.404999078913) | 3 | 1 | 10 | 28857 | 4 | |||
| 80199 | 143012 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 336 LOMBARD ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6010686.888 | 2120692.5302 | 37.8036195456032 | -122.40722991099 | (37.8036195456032, -122.40722991099) | 3 | 1 | 10 | 308 | 23 | |||
| 80867 | 59153 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 20 Bellair Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/1982 12:00:00 AM | 11 | Permit Number 19779 | 6010063.4155 | 2121130.5341 | 37.8047872831513 | -122.409418407658 | (37.8047872831513, -122.409418407658) | 3 | 1 | 10 | 308 | 23 | ||
| 81395 | 4723 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1050 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 5x5 | 6008295.1213 | 2120922.8472 | 37.8041177920118 | -122.415523078458 | (37.8041177920118, -122.415523078458) | 5 | 1 | 10 | 308 | 23 | |||
| 82265 | 142992 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 455 CHESTNUT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6009662.0127 | 2120854.6155 | 37.8040071808412 | -122.410788010808 | (37.8040071808412, -122.410788010808) | 3 | 1 | 10 | 308 | 23 | |||
| 82332 | 4722 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1040 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 4x4 | 6008317.4743 | 2120903.2884 | 37.8040653448727 | -122.415444338519 | (37.8040653448727, -122.415444338519) | 5 | 1 | 10 | 308 | 23 | |||
| 83261 | 142473 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1429 Kearny St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6010981.054 | 2119812.8124 | 37.8012205149436 | -122.406149914275 | (37.8012205149436, -122.406149914275) | 3 | 1 | 10 | 308 | 23 | |||
| 84580 | 143186 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 184 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6010406.8966 | 2121345.6921 | 37.805397292747 | -122.408244934675 | (37.805397292747, -122.408244934675) | 3 | 1 | 10 | 308 | 23 | |||
| 87344 | 143503 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 24 GERKE ALY | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6010601.2344 | 2120203.101 | 37.8022708995748 | -122.407491794352 | (37.8022708995748, -122.407491794352) | 3 | 1 | 10 | 308 | 23 | |||
| 88548 | 99210 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1111 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6007993.4855 | 2121112.3432 | 37.8046211410646 | -122.416580345595 | (37.8046211410646, -122.416580345595) | 5 | 1 | 10 | 308 | 32 | |||
| 89354 | 143480 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 626 PINE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6010907.473 | 2116280.5305 | 37.7915176085666 | -122.406155537422 | (37.7915176085666, -122.406155537422) | 5 | 1 | 10 | 28857 | 6 | |||
| 89471 | 143492 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 270 COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6010909.4189 | 2118541.7123 | 37.7977263769575 | -122.406308193671 | (37.7977263769575, -122.406308193671) | 3 | 1 | 10 | 308 | 23 | |||
| 90895 | 142938 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1160 BROADWAY | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6010744.0272 | 2118552.2837 | 37.7977461503426 | -122.406881242638 | (37.7977461503426, -122.406881242638) | 3 | 1 | 10 | 308 | 4 | |||
| 94505 | 142595 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 365 COLUMBUS AVE | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6008339.7594 | 2120798.6708 | 37.8037793437918 | -122.415359808453 | (37.8037793437918, -122.415359808453) | 5 | 1 | 10 | 308 | 32 | |||
| 95252 | 143212 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 175 FRANCISCO ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6010402.9445 | 2121293.4361 | 37.8052535894305 | -122.408254923564 | (37.8052535894305, -122.408254923564) | 3 | 1 | 10 | 308 | 23 | |||
| 96661 | 99228 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1111 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2x2 | 6008013.4555 | 2121093.6827 | 37.8045710271276 | -122.416509914664 | (37.8045710271276, -122.416509914664) | 5 | 1 | 10 | 308 | 32 | |||
| 98101 | 142489 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 651 COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6009636.3672 | 2119608.7257 | 37.8005848384211 | -122.410788716085 | (37.8005848384211, -122.410788716085) | 3 | 1 | 10 | 308 | 4 | |||
| 98500 | 143247 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 153 PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6010131.5523 | 2121103.7243 | 37.8047174875245 | -122.40918071917 | (37.8047174875245, -122.40918071917) | 3 | 1 | 10 | 308 | 23 | |||
| 100156 | 143164 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2130 STOCKTON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6009854.6792 | 2121476.1846 | 37.8057246557504 | -122.410165182597 | (37.8057246557504, -122.410165182597) | 3 | 1 | 10 | 308 | 23 | |||
| 101324 | 142632 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 241 BAY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6009699.071 | 2121543.9755 | 37.8059020693628 | -122.410708480373 | (37.8059020693628, -122.410708480373) | 3 | 1 | 10 | 308 | 23 | |||
| 102293 | 142508 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 358 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6010579.9175 | 2118839.2508 | 37.798524907896 | -122.407469352253 | (37.798524907896, -122.407469352253) | 3 | 1 | 10 | 308 | 23 | |||
| 102869 | 142471 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1439 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6010974.128 | 2119867.5279 | 37.8013703629213 | -122.406177738482 | (37.8013703629213, -122.406177738482) | 3 | 1 | 10 | 308 | 23 | |||
| 104792 | 142635 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 241 BAY ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6009773.7882 | 2121554.2814 | 37.8059345556962 | -122.410450636982 | (37.8059345556962, -122.410450636982) | 3 | 1 | 10 | 308 | 23 |
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) );