trees
1,626 rows where qSpecies_id = 53 sorted by rowid descending
This data as json, CSV (advanced)
rowid ▲ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
193965 | 108150 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2232 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003295.44003 | 2116396.66877 | 37.7914077834913 | -122.432501340527 | (37.7914077834913, -122.432501340527) | 13 | 9 | 1 | 29490 | 27 | |||||
193861 | 44757 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 480 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 43870 | 6003593.00847933 | 2105481.98628904 | 37.7614556341181 | -122.430692553071 | (37.7614556341181, -122.430692553071) | 15 | 4 | 5 | 28862 | 3 | ||||
193673 | 120592 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3773 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003806 | 2105923 | 37.7626786166025 | -122.429987363922 | (37.7626786166025, -122.429987363922) | 8 | 4 | 5 | 28862 | 3 | ||||
193656 | 16998 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 903 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3X3 | 6002629.22495 | 2109872.04506 | 37.7734550115897 | -122.434339751705 | (37.7734550115897, -122.434339751705) | 15 | 5 | 11 | 29492 | 9 | |||
193625 | 255507 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1290X Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6003415.08005 | 2112113.96459 | 37.7796553418115 | -122.431781470984 | (37.7796553418115, -122.431781470984) | 15 | 9 | 11 | 29490 | 41 | ||||
193568 | 26953 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2040 Sutter St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x6 | 6002643.91242 | 2114436.71459 | 37.7859892824562 | -122.43461540376 | (37.7859892824562, -122.43461540376) | 13 | 9 | 11 | 29490 | 27 | |||
193427 | 106524 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2510 Jackson St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | Permit Number 772624 | 6002049.7 | 2116744.4 | 37.7922918429251 | -122.436836472971 | (37.7922918429251, -122.436836472971) | 13 | 6 | 1 | 29490 | 27 | ||||
193344 | 13225 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2265 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001602.67751 | 2119341.9386 | 37.799398588794 | -122.438569375951 | (37.799398588794, -122.438569375951) | 13 | 9 | 1 | 57 | 17 | |||
193319 | 257913 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 690X Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010415 | 2118850 | 37.7985451903817 | -122.408040779349 | (37.7985451903817, -122.408040779349) | 3 | 1 | 10 | 308 | 4 | ||||
193266 | 97278 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 60 Palm Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 768156 | 5995934.7 | 2114107.9 | 37.7847032866401 | -122.457803503646 | (37.7847032866401, -122.457803503646) | 11 | 6 | 1 | 54 | 31 | |||
192852 | 16949 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 625 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003989.24409 | 2110039.43116 | 37.7739917148646 | -122.429647190447 | (37.7739917148646, -122.429647190447) | 7 | 9 | 11 | 29492 | 10 | |||
192777 | 48866 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 129 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/2002 12:00:00 AM | Permit Number 46075 | 6006370.62112219 | 2110394.65908683 | 37.7751016387897 | -122.421434823029 | (37.7751016387897, -122.421434823029) | 7 | 9 | 11 | 28852 | 10 | |||
192675 | 111390 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 298x CLINTON PARK | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004911 | 2108307 | 37.7692870280045 | -122.426335307428 | (37.7692870280045, -122.426335307428) | 8 | 4 | 5 | 28862 | 19 | ||||
192632 | 5633 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1256 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6005118.39805 | 2100997.74937 | 37.749229268656 | -122.425097781596 | (37.749229268656, -122.425097781596) | 2 | 4 | 5 | 28862 | 22 | |||
192243 | 94600 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1709 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5997540 | 2108126 | 37.7683706375079 | -122.451818041345 | (37.7683706375079, -122.451818041345) | 15 | 5 | 11 | 29492 | 9 | |||||
192030 | 256356 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1000 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3x3 | 6005985 | 2121074 | 37.804402699388 | -122.423528183462 | (37.804402699388, -122.423528183462) | 5 | 1 | 1 | 28858 | 32 | |||
191709 | 52838 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 795on Trenton Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 48857 | 6010309.20673902 | 2118158.51574656 | 37.7966406195852 | -122.408358059553 | (37.7966406195852, -122.408358059553) | 3 | 1 | 10 | 308 | 4 | ||||
191412 | 2431 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 490X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6004657.78302 | 2110211.29448 | 37.7745014417711 | -122.427346845616 | (37.7745014417711, -122.427346845616) | 7 | 9 | 11 | 28852 | 10 | |||
191336 | 505 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2766X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010189.63609 | 2102250.35484 | 37.7529538159215 | -122.407649581645 | (37.7529538159215, -122.407649581645) | 2 | 4 | 7 | 28859 | 19 | |||
191197 | 18454 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1106 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3x3 | 6010521.1889393 | 2102709.7477141 | 37.7542337610764 | -122.406535372627 | (37.7542337610764, -122.406535372627) | 10 | 4 | 7 | 28859 | 19 | |||
191157 | 16897 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 385 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6005198.99692 | 2110159.80887 | 37.7743906686767 | -122.425471016021 | (37.7743906686767, -122.425471016021) | 7 | 9 | 11 | 28852 | 10 | |||
191099 | 100527 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1728 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4.5x6 | 6008341 | 2118363 | 37.7970916696404 | -122.415182998934 | (37.7970916696404, -122.415182998934) | 5 | 1 | 10 | 308 | 21 | ||||
191064 | 21654 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1698 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004474.7477956 | 2114689.3781886 | 37.7867867977452 | -122.428299224496 | (37.7867867977452, -122.428299224496) | 13 | 9 | 11 | 28858 | 27 | |||
190734 | 6815 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1400X Fairfax Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016560.8212721 | 2097522.8211505 | 37.7403275687029 | -122.385287208511 | (37.7403275687029, -122.385287208511) | 10 | 3 | 8 | 58 | 1 | |||
190730 | 110993 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/2015 12:00:00 AM | 3 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||
190628 | 7233 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1045 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003367.24511 | 2111893.72513 | 37.7790479074603 | -122.431931222001 | (37.7790479074603, -122.431931222001) | 15 | 9 | 11 | 29490 | 41 | |||
190566 | 21751 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1787X Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002537.7996519 | 2114344.6571005 | 37.7857304915222 | -122.434975938446 | (37.7857304915222, -122.434975938446) | 13 | 9 | 11 | 29490 | 13 | |||
190383 | 17316 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 86 OTIS ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006711 | 2109331 | 37.7722002709716 | -122.420181869556 | (37.7722002709716, -122.420181869556) | 8 | 2 | 9 | 28853 | 19 | |||
190351 | 110732 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3515 25TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006381 | 2101411 | 37.7504352040325 | -122.420761009138 | (37.7504352040325, -122.420761009138) | 2 | 4 | 5 | 28859 | 19 | ||||
190159 | 225029 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 4543 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 17041 | 6000793.7951 | 2105198.47261 | 37.7605181908718 | -122.440353514511 | (37.7605181908718, -122.440353514511) | 2 | 4 | 5 | 28862 | 3 | |
190135 | 15260 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1500 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6007445.07805 | 2110006.65891 | 37.7740968045009 | -122.417690522857 | (37.7740968045009, -122.417690522857) | 8 | 2 | 9 | 28853 | 19 | |||
190125 | 52718 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1330on LARKIN Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2006 12:00:00 AM | Permit Number 48769 | 6007121.03491046 | 2115409.40396286 | 37.7889131924877 | -122.419194766666 | (37.7889131924877, -122.419194766666) | 13 | 9 | 10 | 28858 | 21 | |||
189703 | 66879 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 277 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1991 12:00:00 AM | Permit Number 768127 | 6001144.84674667 | 2104743.15871911 | 37.7592879918503 | -122.439106757133 | (37.7592879918503, -122.439106757133) | 2 | 4 | 5 | 28862 | 3 | ||
189695 | 21726 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1942 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6003284.347 | 2114523.85502 | 37.7862648839776 | -122.432405902047 | (37.7862648839776, -122.432405902047) | 13 | 9 | 11 | 29490 | 27 | |||
189650 | 15279 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1551 MISSION ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6007345 | 2109715.7 | 37.7732922684508 | -122.418016080506 | (37.7732922684508, -122.418016080506) | 8 | 2 | 9 | 28853 | 19 | |||
189496 | 255885 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 50 Columbia Square St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 3x3 | 6010942 | 2111079 | 37.7772373644855 | -122.405669544588 | (37.7772373644855, -122.405669544588) | 14 | 2 | 9 | 28853 | 34 | |||
189307 | 111392 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 298x CLINTON PARK | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004911 | 2108307 | 37.7692870280045 | -122.426335307428 | (37.7692870280045, -122.426335307428) | 8 | 4 | 5 | 28862 | 19 | ||||
189256 | 91128 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 610 Brannan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49594 | 6012704.2 | 2110820.8 | 37.7766267904106 | -122.399555358584 | (37.7766267904106, -122.399555358584) | 14 | 2 | 9 | 28856 | 34 | |||
188909 | 6818 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1400X Fairfax Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016560.8212721 | 2097522.8211505 | 37.7403275687029 | -122.385287208511 | (37.7403275687029, -122.385287208511) | 10 | 3 | 8 | 58 | 1 | |||
188867 | 121000 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 390 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | 6010815 | 2115725 | 37.7899870820688 | -122.406436332672 | (37.7899870820688, -122.406436332672) | 5 | 1 | 10 | 28857 | 6 | ||||
188786 | 99614 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3233X Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003300 | 2119605 | 37.8002172925371 | -122.432714848025 | (37.8002172925371, -122.432714848025) | 13 | 9 | 1 | 57 | 17 | |||
188704 | 57306 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3265 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/01/1992 12:00:00 AM | 5.5x9 | Permit Number 30983 | 6005094.29272651 | 2106604.42467206 | 37.7646225228273 | -122.425580116407 | (37.7646225228273, -122.425580116407) | 8 | 4 | 5 | 28859 | 19 | ||
188563 | 10618 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 350 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6006025.52151 | 2110969.11138 | 37.7766594822933 | -122.422669431679 | (37.7766594822933, -122.422669431679) | 7 | 9 | 11 | 28852 | 10 | |||
188552 | 17045 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Oak St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6001235.1914802 | 2109729.1714048 | 37.7729834911046 | -122.439151661694 | (37.7729834911046, -122.439151661694) | 15 | 5 | 11 | 29492 | 10 | |||
188536 | 117125 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 766 NOE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003023 | 2103770 | 37.7567226205836 | -122.432541687014 | (37.7567226205836, -122.432541687014) | 2 | 4 | 5 | 28862 | 3 | ||||
188517 | 109332 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1321 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 5998933 | 2105018 | 37.7599165333482 | -122.446776141106 | (37.7599165333482, -122.446776141106) | 15 | 5 | 5 | 28862 | 12 | |||
188426 | 148686 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 55 Sherman St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 10ft | 6010834.41502 | 2110868.71034 | 37.7766539412504 | -122.406026899245 | (37.7766539412504, -122.406026899245) | 14 | 2 | 9 | 28853 | 34 | |||
188290 | 100708 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 220X 01st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2012 12:00:00 AM | 3x3 | Permit Number 768932 | 6013902 | 2115015 | 37.7882097965006 | -122.395705731652 | (37.7882097965006, -122.395705731652) | 6 | 2 | 9 | 28855 | 6 | ||
188273 | 2450 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1805X Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x4 | 6003959.520066 | 2114567.2690482 | 37.7864223498862 | -122.430073076908 | (37.7864223498862, -122.430073076908) | 13 | 9 | 11 | 29490 | 13 | |||
188189 | 111222 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3150x 19TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008324 | 2105048 | 37.7605309015758 | -122.41429925401 | (37.7605309015758, -122.41429925401) | 2 | 4 | 7 | 28859 | 19 | |||
188136 | 120939 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 485 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012395 | 2105853 | 37.7629690927527 | -122.400275979648 | (37.7629690927527, -122.400275979648) | 14 | 3 | 8 | 28856 | 29 | ||||
188066 | 9689 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 332 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6006025.5202 | 2110969.11106 | 37.7766594813407 | -122.422669436188 | (37.7766594813407, -122.422669436188) | 7 | 9 | 11 | 28852 | 10 | |||
188021 | 6788 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1390 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6016787.1910829 | 2097353.9213772 | 37.7398763247169 | -122.384492742853 | (37.7398763247169, -122.384492742853) | 10 | 3 | 8 | 58 | 1 | |||
187881 | 94217 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 246 01st St | 2 | Sidewalk: Property side : Pot | Tree | Private 2 | 06/25/2010 12:00:00 AM | 2x3 | Permit Number 53568 | 6014001.8 | 2114912.7 | 37.7879344554838 | -122.395353268636 | (37.7879344554838, -122.395353268636) | 6 | 2 | 9 | 28855 | 6 | ||
187860 | 22712 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1401X Turk St | 12 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 18 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | 15 | 9 | 11 | 29490 | 41 | |||
187641 | 17308 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 70 Otis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6006766.44916 | 2109389.93705 | 37.7723652222089 | -122.419994248937 | (37.7723652222089, -122.419994248937) | 8 | 2 | 9 | 28853 | 19 | |||
187443 | 22718 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1401X Turk St | 6 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 18 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | 15 | 9 | 11 | 29490 | 41 | |||
187371 | 89021 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1500 Mission St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51766 | 6007445.1 | 2110006.7 | 37.7740969185595 | -122.417690449841 | (37.7740969185595, -122.417690449841) | 8 | 2 | 9 | 28853 | 19 | |||
187242 | 44341 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2294 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/05/1973 12:00:00 AM | Permit Number 43725 | 6002286.29088827 | 2107094.04279132 | 37.7658078311453 | -122.435327256937 | (37.7658078311453, -122.435327256937) | 15 | 5 | 5 | 28862 | 3 | |||
187091 | 100051 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3233X Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003300 | 2119605 | 37.8002172925371 | -122.432714848025 | (37.8002172925371, -122.432714848025) | 13 | 9 | 1 | 57 | 17 | |||
186730 | 120142 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 10X Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007842 | 2111812 | 37.7790761683861 | -122.416445400738 | (37.7790761683861, -122.416445400738) | 7 | 10 | 9 | 28852 | 36 | ||||
186717 | 107211 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2255 CLAY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003966.3 | 2116269.9 | 37.7910977281266 | -122.430171131086 | (37.7910977281266, -122.430171131086) | 13 | 9 | 1 | 29490 | 27 | |||||
186566 | 15267 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1531 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6007476.41024 | 2109891.28194 | 37.7737817698767 | -122.417573960108 | (37.7737817698767, -122.417573960108) | 8 | 2 | 9 | 28853 | 19 | |||
186524 | 112825 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 101X COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 6011274 | 2118052 | 37.7964021326886 | -122.405012137355 | (37.7964021326886, -122.405012137355) | 3 | 1 | 10 | 308 | 4 | |||
186502 | 18393 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 886 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6010424.2598856 | 2104075.0244367 | 37.7579770833513 | -122.406966801395 | (37.7579770833513, -122.406966801395) | 10 | 4 | 7 | 28859 | 19 | |||
186477 | 113509 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 318 TURK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008412 | 2113183 | 37.7828726439691 | -122.414570576408 | (37.7828726439691, -122.414570576408) | 7 | 10 | 9 | 28852 | 36 | ||||
186352 | 255883 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 50 Columbia Square St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 3x3 | 6010942 | 2111079 | 37.7772373644855 | -122.405669544588 | (37.7772373644855, -122.405669544588) | 14 | 2 | 9 | 28853 | 34 | |||
186331 | 122713 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 855x Kearny St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011188 | 2117923 | 37.7960431220576 | -122.40530062832 | (37.7960431220576, -122.40530062832) | 3 | 1 | 10 | 28857 | 4 | ||||
186277 | 13199 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2130X Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6002179.06604 | 2119515.41872 | 37.7999076905723 | -122.436587295662 | (37.7999076905723, -122.436587295662) | 13 | 9 | 1 | 57 | 17 | |||
186252 | 116029 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1500 PACIFIC AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006937 | 2117734 | 37.7952855901943 | -122.419996533467 | (37.7952855901943, -122.419996533467) | 13 | 9 | 10 | 28858 | 32 | ||||
186181 | 251369 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 390 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 6011351 | 2111108 | 37.7773398544385 | -122.404256716486 | (37.7773398544385, -122.404256716486) | 14 | 2 | 9 | 28853 | 34 | |||
186128 | 21645 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1657 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/1990 12:00:00 AM | 18 | 4X4 | 6004676.7022509 | 2114666.9735246 | 37.7867367053745 | -122.427598912468 | (37.7867367053745, -122.427598912468) | 13 | 9 | 11 | 28858 | 13 | ||
185861 | 18445 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1024 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 4x4 | 6010473.6370906 | 2103261.6949103 | 37.7557466249525 | -122.406738715199 | (37.7557466249525, -122.406738715199) | 10 | 4 | 7 | 28859 | 19 | |||
185775 | 117401 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 75x BEACH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009846 | 2122112 | 37.8074699595292 | -122.410240137563 | (37.8074699595292, -122.410240137563) | 3 | 1 | 10 | 308 | 23 | ||||
185695 | 60219 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1812 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/1982 12:00:00 AM | 18 | 3x3 | Permit Number 19769 | 6004928.04684857 | 2117801.00675234 | 37.795356184696 | -122.426952612815 | (37.795356184696, -122.426952612815) | 13 | 9 | 1 | 28858 | 27 | |
185458 | 91127 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 610 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49594 | 6012704.2 | 2110820.8 | 37.7766267904106 | -122.399555358584 | (37.7766267904106, -122.399555358584) | 14 | 2 | 9 | 28856 | 34 | |||
185238 | 15310 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1650 Mission St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6006887.5781181 | 2109042.9003069 | 37.7714191656036 | -122.41955062575 | (37.7714191656036, -122.41955062575) | 8 | 2 | 9 | 28853 | 19 | |||
185169 | 15159 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 895X Mission St | 13 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | Private | 18 | 4x4 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | 12 | 2 | 9 | 28853 | 34 | ||
184960 | 109002 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 525x BURNETT AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1x1 | 5999530 | 2102478 | 37.7529764040195 | -122.444528861079 | (37.7529764040195, -122.444528861079) | 2 | 5 | 5 | 63 | 38 | ||||
184950 | 18016 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2714 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000941.6382972 | 2114893.0059573 | 37.7871453575959 | -122.440537532879 | (37.7871453575959, -122.440537532879) | 13 | 6 | 1 | 29490 | 27 | |||
184916 | 20245 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1823 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/13/1989 12:00:00 AM | 12 | 3X3 | 6002519.5885419 | 2114476.0123893 | 37.7860901257054 | -122.435048341611 | (37.7860901257054, -122.435048341611) | 13 | 9 | 1 | 29490 | 27 | ||
184850 | 2719 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2185X Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003092.7695 | 2114646.14799 | 37.786589804405 | -122.433077450713 | (37.786589804405, -122.433077450713) | 13 | 9 | 11 | 29490 | 27 | |||
184672 | 113275 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2147 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6002730.25600058 | 2118492.02135193 | 37.7971290147198 | -122.43460675571 | (37.7971290147198, -122.43460675571) | 13 | 9 | 1 | 57 | 17 | |||||
184670 | 59431 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3033 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1980 12:00:00 AM | 14 | 3x3 | Permit Number 18793 | 6002899.25612306 | 2096070.04882186 | 37.7355733371118 | -122.432419698468 | (37.7355733371118, -122.432419698468) | 2 | 7 | 5 | 63 | 7 | |
184329 | 173906 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2510 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6005854.79213 | 2118988.36383 | 37.7986687249765 | -122.423830387644 | (37.7986687249765, -122.423830387644) | 13 | 9 | 1 | 28858 | 32 | |||||
184217 | 113003 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
184158 | 127219 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2864 Broadway | 8 | Front Yard : Yard | Tree | Private 2 | 8 | Width 4ft | Permit Number 782825 | 5999916.98549 | 2117117.82475 | 37.7931957274607 | -122.444242532876 | (37.7931957274607, -122.444242532876) | 13 | 9 | 1 | 57 | 27 | ||
184105 | 112108 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 699x COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6009471 | 2119722 | 37.8008865881446 | -122.411368963081 | (37.8008865881446, -122.411368963081) | 3 | 1 | 10 | 308 | 4 | |||
184073 | 8768 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3360 Geary Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5996663.11405 | 2112992.0555 | 37.7816812935668 | -122.455202782638 | (37.7816812935668, -122.455202782638) | 11 | 6 | 1 | 54 | 31 | |||
183563 | 110986 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||||
183408 | 50980 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 201 Richardson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2004 12:00:00 AM | 3x3 | Permit Number 47465 | 5999116.7 | 2119758.3 | 37.8004000774175 | -122.447201682136 | (37.8004000774175, -122.447201682136) | 13 | 9 | 1 | 57 | 17 | ||
183245 | 120146 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008026 | 2111839 | 37.7791606496002 | -122.415810780563 | (37.7791606496002, -122.415810780563) | 7 | 10 | 9 | 28852 | 36 | ||||
183181 | 108106 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1990X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Port | 6004838 | 2115780 | 37.7898019192352 | -122.427120168027 | (37.7898019192352, -122.427120168027) | 13 | 9 | 1 | 28858 | 27 | ||||
183127 | 7232 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1045 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003365.392 | 2111902.08022 | 37.7790707434033 | -122.431938229416 | (37.7790707434033, -122.431938229416) | 15 | 9 | 11 | 29490 | 41 | |||
183120 | 17367 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2308X Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005067.32521 | 2117488.78546 | 37.794506778582 | -122.426448444628 | (37.794506778582, -122.426448444628) | 13 | 9 | 1 | 28858 | 27 | |||
183113 | 18328 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 269 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6010332.3440196 | 2107072.4168362 | 37.7662021013824 | -122.407496007113 | (37.7662021013824, -122.407496007113) | 8 | 4 | 8 | 28853 | 19 | |||
183075 | 17003 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 985 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5x9 | 6002297.8184 | 2109825.1269 | 37.7733073694664 | -122.435482776108 | (37.7733073694664, -122.435482776108) | 15 | 5 | 11 | 29492 | 9 | |||
183049 | 111628 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 11X SOUTH VAN NESS AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007074 | 2110234 | 37.7747001403616 | -122.418990277193 | (37.7747001403616, -122.418990277193) | 8 | 2 | 9 | 28853 | 19 | ||||
183025 | 26841 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 100 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | Permit Number 779930 | 6006975.88726 | 2110943.04151 | 37.7766414730488 | -122.419379980819 | (37.7766414730488, -122.419379980819) | 7 | 9 | 9 | 28852 | 36 | ||
182974 | 16988 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 879 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002804.94816 | 2109899.79468 | 37.773541177823 | -122.433733884114 | (37.773541177823, -122.433733884114) | 15 | 5 | 11 | 29492 | 9 |
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) );