1,626 rows where qSpecies_id = 53 sorted by rowid descending

View and edit SQL

Zip Codes

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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);