trees

1,381 rows where qSpecies_id = 54 sorted by qLegalStatus_id descending

✎ View and edit SQL

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)
2251 143510 Permitted Site 7 Ficus retusa nitida :: Banyan Fig 54 2026 UNION ST 1 Sidewalk: Curb side : Cutout Tree Private 2   08/21/2006 12:00:00 AM 14 Width 0ft Permit Number 48982 6003323.1573 2118630.9053 37.797543994409 -122.432565097779 (37.797543994409, -122.432565097779) 13 9 1 57 17
5364 245472 Permitted Site 7 Ficus retusa nitida :: Banyan Fig 54 2700 24th St 4 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 0ft   6010432.7166 2102259.7859 37.7529933156944 -122.406809623625 (37.7529933156944, -122.406809623625) 10 4 7 28859 19
7684 245413 Permitted Site 7 Ficus retusa nitida :: Banyan Fig 54 2726 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 0ft   6010382.82 2102257.4918 37.7529842245941 -122.406982014782 (37.7529842245941, -122.406982014782) 10 4 7 28859 19
8308 143512 Permitted Site 7 Ficus retusa nitida :: Banyan Fig 54 2030 UNION ST 1 Sidewalk: Curb side : Cutout Tree Private 2   08/21/2006 12:00:00 AM 16 Width 0ft Permit Number 48982 6003288.5063 2118622.406 37.7975186924595 -122.432684391924 (37.7975186924595, -122.432684391924) 13 9 1 57 17
9567 143511 Permitted Site 7 Ficus retusa nitida :: Banyan Fig 54 2026 UNION ST 2 Sidewalk: Curb side : Cutout Tree Private 2   08/21/2006 12:00:00 AM 14 Width 0ft Permit Number 48982 6003307.4663 2118627.6363 37.7975341287535 -122.432619159147 (37.7975341287535, -122.432619159147) 13 9 1 57 17
11090 38646 Permitted Site 7 Ficus retusa nitida :: Banyan Fig 54 209 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/22/1998 12:00:00 AM     Permit Number 40570 6005214.92856016 2099001.03793316 37.7437522091261 -122.424621959344 (37.7437522091261, -122.424621959344) 2 7 5 63 22
14249 245420 Permitted Site 7 Ficus retusa nitida :: Banyan Fig 54 2855 24th St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 0ft   6009712.0846 2102179.2059 37.7527317128259 -122.409296032004 (37.7527317128259, -122.409296032004) 2 4 7 28859 19
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
54460 54103 Permitted Site 7 Ficus retusa nitida :: Banyan Fig 54 2317 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/19/1972 12:00:00 AM   3x3 Permit Number 9832 6003101.11509235 2116824.39264322 37.7925711821936 -122.433204275613 (37.7925711821936, -122.433204275613) 13 9 1 29490 27
60248 53539 Permitted Site 7 Ficus retusa nitida :: Banyan Fig 54 322 02nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/11/1969 12:00:00 AM     Permit Number 776401 5995280.52661988 2113383.63166464 37.7826770367733 -122.460014224406 (37.7826770367733, -122.460014224406) 11 6 2 54 11
62099 217621 Permitted Site 7 Ficus retusa nitida :: Banyan Fig 54 1830 Ocean Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   5994307.7366 2092494.0455 37.725263580598 -122.461864420033 (37.725263580598, -122.461864420033) 9 8 4 28861 40
92667 37059 Permitted Site 7 Ficus retusa nitida :: Banyan Fig 54 1450 Sanchez St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/01/1998 12:00:00 AM   3x3 Permit Number 39663 6003906.83973736 2099821.31146391 37.7459305281666 -122.429203495744 (37.7459305281666, -122.429203495744) 2 7 5 63 22
103115 217617 Permitted Site 7 Ficus retusa nitida :: Banyan Fig 54 1830 Ocean Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   5994396.9504 2092455.3654 37.7251625099423 -122.461553215897 (37.7251625099423, -122.461553215897) 9 8 4 28861 40
103297 217620 Permitted Site 7 Ficus retusa nitida :: Banyan Fig 54 1830 Ocean Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   5994327.7005 2092483.4396 37.7252356086447 -122.461794638623 (37.7252356086447, -122.461794638623) 9 8 4 28861 40
109931 217619 Permitted Site 7 Ficus retusa nitida :: Banyan Fig 54 1830 Ocean Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   5994357.3344 2092471.2741 37.7252039110132 -122.461691316268 (37.7252039110132, -122.461691316268) 9 8 4 28861 40
116294 140576 Permitted Site 7 Ficus retusa nitida :: Banyan Fig 54 1225 McAllister St 4 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6003302.4616 2111703.7722 37.7785226712194 -122.432141765433 (37.7785226712194, -122.432141765433) 15 9 11 29492 41
142773 37061 Permitted Site 7 Ficus retusa nitida :: Banyan Fig 54 1450 Sanchez St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM   3x3 Permit Number 39663 6003906.83973736 2099821.31146391 37.7459305281666 -122.429203495744 (37.7459305281666, -122.429203495744) 2 7 5 63 22
152768 15334 Permitted Site 7 Ficus retusa nitida :: Banyan Fig 54 1720 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/30/2006 12:00:00 AM 4 3x3   6006687.4636 2108380.8364 37.7695900216736 -122.420195837478 (37.7695900216736, -122.420195837478) 8 4 7 28853 19
178861 37062 Permitted Site 7 Ficus retusa nitida :: Banyan Fig 54 1450 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/01/1998 12:00:00 AM   3x3 Permit Number 39663 6003906.83973736 2099821.31146391 37.7459305281666 -122.429203495744 (37.7459305281666, -122.429203495744) 2 7 5 63 22
187722 140048 Permitted Site 7 Ficus retusa nitida :: Banyan Fig 54 993 STEINER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft Permit Number 19087 6002927.2794 2111591.8239 37.7781940105178 -122.433431660039 (37.7781940105178, -122.433431660039) 15 9 11 29492 41
188191 140047 Permitted Site 7 Ficus retusa nitida :: Banyan Fig 54 997 STEINER ST 1 Sidewalk: Curb side : Cutout Tree Private 2   03/30/1981 12:00:00 AM 17 Width 0ft Permit Number 19087 6002926.2641 2111608.0681 37.778238555435 -122.433436333455 (37.778238555435, -122.433436333455) 15 9 11 29492 41
194296 187453 Permitted Site 7 Ficus retusa nitida :: Banyan Fig 54 4621 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6002078.4831 2091980.9842 37.724299121454 -122.434965072602 (37.724299121454, -122.434965072602) 9 7 6 28861 5
2553 140071 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 601X Octavia St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6005402 2111410 37.7778348570605 -122.424857751543 (37.7778348570605, -122.424857751543) 7 9 11 28852 10
4591 113471 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 450 CHURCH ST 28 Sidewalk: Curb side : Cutout Tree SFUSD 4       6x6   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
15342 113473 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 450 CHURCH ST 30 Sidewalk: Curb side : Cutout Tree SFUSD 4       6x6   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
17983 107661 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 1312 CLAYTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3   5999086.9 2105066.2 37.7600576690463 -122.446247345124 (37.7600576690463, -122.446247345124) 15 5 5 28862 3
18163 140072 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 601X Octavia St 3 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6005402 2111410 37.7778348570605 -122.424857751543 (37.7778348570605, -122.424857751543) 7 9 11 28852 10
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
43317 113469 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 450 CHURCH ST 26 Sidewalk: Curb side : Cutout Tree SFUSD 4       6x6   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
45788 113409 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 401x DUNCAN ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003916 2099815 37.745913716911 -122.429171370863 (37.745913716911, -122.429171370863) 2 7 5 63 22
65054 113474 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 450 CHURCH ST 31 Sidewalk: Curb side : Cutout Tree SFUSD 4       6x6   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
67077 113468 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 450 CHURCH ST 4 Sidewalk: Curb side : Cutout Tree SFUSD 4   06/21/2016 02:14:00 PM 3 6x7   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
68988 140439 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 1100 FILLMORE ST 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6003462.4449 2112120.7446 37.7796766428298 -122.431618099739 (37.7796766428298, -122.431618099739) 15 9 11 29490 41
83117 113466 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 450 CHURCH ST 2 Sidewalk: Curb side : Cutout Tree SFUSD 4       6x6   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
91889 113472 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 450 CHURCH ST 29 Sidewalk: Curb side : Cutout Tree SFUSD 4       6x6   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
101660 121389 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 2646 Post St 1 Sidewalk: Curb side : Cutout Tree Private 2     25 3x3   5999473.1272 2113649.2828 37.7836466874196 -122.445528775036 (37.7836466874196, -122.445528775036) 15 6 11 29490 31
109050 142510 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 401 COLUMBUS AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6010260.5653 2119044.3559 37.7990701962332 -122.408588891831 (37.7990701962332, -122.408588891831) 3 1 10 308 4
109940 258056 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 600 California St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011288 2116842 37.793080546408 -122.404878460446 (37.793080546408, -122.404878460446) 3 1 10 28857 4
120425 258058 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 600 California St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011288 2116842 37.793080546408 -122.404878460446 (37.793080546408, -122.404878460446) 3 1 10 28857 4
132386 113054 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 25 FILLMORE ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003823 2108493 37.7697361782825 -122.430111915017 (37.7697361782825, -122.430111915017) 15 9 5 29492 10
134819 113410 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 401x DUNCAN ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003916 2099815 37.745913716911 -122.429171370863 (37.745913716911, -122.429171370863) 2 7 5 63 22
137907 258057 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 600 California St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011288 2116842 37.793080546408 -122.404878460446 (37.793080546408, -122.404878460446) 3 1 10 28857 4
143625 113475 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 450 CHURCH ST 32 Sidewalk: Curb side : Cutout Tree SFUSD 4       6x6   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
145196 113408 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 1450 SANCHEZ ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003890 2099760 37.7457612277667 -122.429257354108 (37.7457612277667, -122.429257354108) 2 7 5 63 22
147121 113467 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 450 CHURCH ST 24 Sidewalk: Curb side : Cutout Tree SFUSD 4       6x6   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
153383 142173 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 1454 HAYES ST 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6000881.5899 2110372.1418 37.7747287989922 -122.440420931638 (37.7747287989922, -122.440420931638) 15 5 11 29492 10
188448 113470 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 450 CHURCH ST 27 Sidewalk: Curb side : Cutout Tree SFUSD 4       6x6   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
191059 258059 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 600 California St 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011288 2116842 37.793080546408 -122.404878460446 (37.793080546408, -122.404878460446) 3 1 10 28857 4
193272 113486 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 30 PRESIDIO AVE 2 Sidewalk: Property side : Cutout Tree Private 2       3x3   5998975 2116473 37.7913714231174 -122.447455414162 (37.7913714231174, -122.447455414162) 13 6 1 29490 31
194465 63910 Prune Opt Out 3 Ficus retusa nitida :: Banyan Fig 54 2135 Powell St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/18/1991 12:00:00 AM 14   Permit Number 788005 6009385.3216 2121038.8544 37.8044975370449 -122.411758548847 (37.8044975370449, -122.411758548847) 3 1 10 308 23
122 17067 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1355 Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6000506.9486 2109572.2346 37.7725111167076 -122.441659471159 (37.7725111167076, -122.441659471159) 15 5 11 29492 9
311 138787 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2714 Pine St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 0ft   6000799 2114887 37.7871207435599 -122.441030597921 (37.7871207435599, -122.441030597921) 13 6 1 29490 27
581 248465 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 772 Stanyan St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5997147.6982 2107925.2578 37.7677969745346 -122.453160476336 (37.7677969745346, -122.453160476336) 15 5 11 29492 9
766 17084 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1575 Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   5999487.0395 2109431.3054 37.7720659980909 -122.445177292475 (37.7720659980909, -122.445177292475) 15 5 11 29492 9
831 245412 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2802 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     19 Width 0ft   6009963.8161 2102233.787 37.7528956807716 -122.408429345015 (37.7528956807716, -122.408429345015) 2 4 7 28859 19
1388 49516 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1910 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2     16   Permit Number 46422 6002507.7627 2114881.9371 37.7872040200664 -122.435118299397 (37.7872040200664, -122.435118299397) 13 9 11 29490 27
1544 245421 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2895 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     16 Width 0ft   6009555.5127 2102167.7354 37.752691443998 -122.409836678395 (37.752691443998, -122.409836678395) 2 4 7 28859 19
1614 140208 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 708 Fillmore St 3 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6003569 2110758 37.7759409231905 -122.431152184499 (37.7759409231905, -122.431152184499) 7 9 11 29492 10
1620 16991 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 899 Oak St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6002773.5007 2109890.2869 37.7735132873347 -122.433841985714 (37.7735132873347, -122.433841985714) 15 5 11 29492 9
2145 140433 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1499 Turk St 12 Sidewalk: Curb side : Cutout Tree Police Dept 10     15 Width 0ft   6003251.7396 2112391.1099 37.7804070531695 -122.432366335522 (37.7804070531695, -122.432366335522) 15 9 11 29490 41
2413 201183 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 620 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6013416.1569 2113924.2034 37.7851876840649 -122.397310155353 (37.7851876840649, -122.397310155353) 6 2 9 28855 6
2761 199857 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2511 Keith St 6 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6014147.0563 2092057.1756 37.725186191812 -122.393250745752 (37.725186191812, -122.393250745752) 10 3 8 58 1
3102 245419 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2833 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     19 Width 0ft   6009862.9212 2102186.0881 37.7527590594841 -122.408774895147 (37.7527590594841, -122.408774895147) 2 4 7 28859 19
3207 111734 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 313 Ivy St 6 Sidewalk: Curb side : Cutout Tree Private 2     11 2.5x3   6005865.3001 2111209.4164 37.777310260787 -122.423240771205 (37.777310260787, -122.423240771205) 7 9 11 28852 10
3486 12249 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 511 Laguna St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6004989.1563 2110705.1842 37.7758762780635 -122.426235730542 (37.7758762780635, -122.426235730542) 7 9 11 28852 10
3502 138641 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2760 BUSH ST 1 Sidewalk: Curb side : Cutout Tree Private 2   05/27/2020 12:00:00 AM 3 Width 0ft   6000298.8786 2114459.033 37.7859171589985 -122.442730161492 (37.7859171589985, -122.442730161492) 13 6 1 29490 27
3546 138584 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2702 Pine St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   6000961.2488 2114897.5694 37.7871590042849 -122.440470012407 (37.7871590042849, -122.440470012407) 13 6 1 29490 27
3763 73629 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 530 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   20 5x7   6005222.8265 2111323.2215 37.7775864626885 -122.425471398253 (37.7775864626885, -122.425471398253) 7 9 11 28852 10
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
4913 64501 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 545 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/20/1988 12:00:00 AM 13   Permit Number 25381 6001107.084 2110608.9242 37.7753917807448 -122.439657882213 (37.7753917807448, -122.439657882213) 15 5 11 29492 10
5046 245409 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2778 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     20 Width 0ft   6010163.1606 2102247.1684 37.7529435845832 -122.40774091468 (37.7529435845832, -122.40774091468) 2 4 7 28859 19
5424 113149 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1035X Folsom St 5 Sidewalk: Curb side : Cutout Tree DPW 1     14 3x3   6010826.0688 2111360.9298 37.7780049945656 -122.406090456701 (37.7780049945656, -122.406090456701) 14 2 9 28853 34
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
6070 519 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2802 24th St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 4x4   6009998.1456 2102238.5221 37.7529106047271 -122.408310960592 (37.7529106047271, -122.408310960592) 2 4 7 28859 19
6447 38608 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1570 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/15/2002 12:00:00 AM 6   Permit Number 45423 6015284.7491 2094285.2369 37.7313671428977 -122.389473352601 (37.7313671428977, -122.389473352601) 10 3 8 58 1
6485 71703 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 530 Grove St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   14     6005189.8095 2111320.4314 37.7775769362179 -122.425585416633 (37.7775769362179, -122.425585416633) 7 9 11 28852 10
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
6605 528 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2836 24th St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6009819.9871 2102225.5005 37.7528648722833 -122.408926150195 (37.7528648722833, -122.408926150195) 2 4 7 28859 19
6829 62365 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2132 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/09/1985 12:00:00 AM 14 6x4 Permit Number 22511 6002365.7866 2114401.6807 37.7858772955002 -122.43557513482 (37.7858772955002, -122.43557513482) 13 6 1 29490 27
7218 182129 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2650 Ulloa St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   5987716.6576 2098310.3756 37.7408520674665 -122.485075392772 (37.7408520674665, -122.485075392772) 1 8 3 29491 35
7238 17116 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1899 Oak St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   5997981.6278 2109222.6111 37.7714069348749 -122.450369559944 (37.7714069348749, -122.450369559944) 15 5 11 29492 9
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
7692 199749 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1555 Yosemite Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6014744.6664 2092522.7122 37.7264976449454 -122.391217378098 (37.7264976449454, -122.391217378098) 10 3 8 58 1
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
7894 7178 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 837 Fillmore St 2 Sidewalk: Curb side : Cutout Tree DPW 1   01/24/2020 11:28:00 AM 12 6x6   6003458.7438 2111235.1971 37.7772449397217 -122.431567664925 (37.7772449397217, -122.431567664925) 15 9 11 29492 10
7900 138130 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2145 Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6003041.4675 2114785.2401 37.7869688058807 -122.433264885414 (37.7869688058807, -122.433264885414) 13 9 11 29490 27
8024 59162 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 465 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/16/1981 12:00:00 AM 16 3x3 Permit Number 19443 6005553.1697 2111320.8777 37.7775986862615 -122.424328461999 (37.7775986862615, -122.424328461999) 7 9 11 28852 10
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
8341 16938 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 595X Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6004175.1129 2110087.9596 37.7741354848182 -122.429007699423 (37.7741354848182, -122.429007699423) 7 9 11 28852 10
8710 140706 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 500 PIERCE ST 3 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   6002658.7155 2110338.0026 37.7747360892866 -122.434271058386 (37.7747360892866, -122.434271058386) 15 5 11 29492 10
8783 7166 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 745 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6003498.9011 2110946.3415 37.7764540897977 -122.431408122706 (37.7764540897977, -122.431408122706) 15 9 11 29492 10
8801 138109 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1600 SUTTER ST 1 Sidewalk: Curb side : Cutout Tree DPW 1     10 Width 0ft   6004876.0712 2114750.6655 37.7869777775164 -122.426915105637 (37.7869777775164, -122.426915105637) 13 9 11 28858 27
8916 140525 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1190 McAllister St 2 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 0ft   6003468.9224 2111772.2595 37.7787201566355 -122.431570805288 (37.7787201566355, -122.431570805288) 15 9 11 29490 41
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
9445 32298 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1616 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/19/1996 12:00:00 AM 12   Permit Number 36875 6011655.3244 2107023.9767 37.7661430585802 -122.40291664053 (37.7661430585802, -122.40291664053) 8 3 8 28853 20
9948 16864 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 230 Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6005857.5291 2110371.9412 37.7750103183132 -122.423208108745 (37.7750103183132, -122.423208108745) 7 9 11 28852 10
10282 18081 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2967 Pine St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   5999746.4018 2114674.089 37.7864761362834 -122.444657035366 (37.7864761362834, -122.444657035366) 15 6 1 29490 31
10375 138610 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1716 BAKER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   6000062.7737 2114910.7976 37.7871441247685 -122.443579481437 (37.7871441247685, -122.443579481437) 13 6 1 29490 27
10837 70252 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 500 Broderick St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     6001164.2534 2110490.0118 37.7750685309709 -122.439451594404 (37.7750685309709, -122.439451594404) 15 5 11 29492 10

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