Street_Tree_List

Data source: data.sfgov.org

1,442 rows where qSpecies = 59 sorted by rowid

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qCaretaker, PlotSize

SiteOrder ✖

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
186 186 138359 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2060 SUTTER ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     15 Width 0ft   6002861.592 2114464.6761 37.7860784126894 -122.43386429175101 (37.7860784126894, -122.433864291751)
188 188 138368 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2060 SUTTER ST 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     13 Width 0ft   6002679.2262 2114443.3671 37.786009553218996 -122.434493703661 (37.786009553219, -122.434493703661)
192 192 138369 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2060 SUTTER ST 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     16 Width 0ft   6002665.8461 2114439.4026 37.78599790817471 -122.434539711553 (37.7859979081747, -122.434539711553)
195 195 138365 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2060 SUTTER ST 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     19 Width 0ft   6002748.6045 2114451.296 37.78603526200121 -122.43425424087799 (37.7860352620012, -122.434254240878)
199 199 138362 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2060 SUTTER ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     15 Width 0ft   6002806.585 2114457.2427 37.78605488083279 -122.434054069465 (37.7860548808328, -122.434054069465)
201 201 138367 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2060 SUTTER ST 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     15 Width 0ft   6002691.6152 2114444.3582 37.7860129777854 -122.434450912019 (37.7860129777854, -122.434450912019)
211 211 138370 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2060 SUTTER ST 12 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     16 Width 0ft   6002647.5104 2114436.9248 37.7859900638921 -122.434602970779 (37.7859900638921, -122.434602970779)
216 216 138364 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2060 SUTTER ST 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 Width 0ft   6002783.7892 2114453.2783 37.7860427018539 -122.43413265320801 (37.7860427018539, -122.434132653208)
217 217 138366 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2060 SUTTER ST 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 Width 0ft   6002708.9598 2114445.3493 37.7860166836287 -122.43439097535801 (37.7860166836287, -122.434390975358)
220 220 138363 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2060 SUTTER ST 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     16 Width 0ft   6002798.656 2114455.2605 37.7860489882217 -122.434081359893 (37.7860489882217, -122.434081359893)
221 221 138361 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2060 SUTTER ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     16 Width 0ft   6002830.8674 2114461.7028 37.78606850519029 -122.433970377911 (37.7860685051903, -122.433970377911)
228 228 246283 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2125 Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     17 Width 0ft   6006872.377 2105970.5198 37.7629822769131 -122.419385210964 (37.7629822769131, -122.419385210964)
230 230 138371 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2060 SUTTER ST 13 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     17 Width 0ft   6002611.3346 2114434.4469999997 37.785981206770394 -122.434727951803 (37.7859812067704, -122.434727951803)
231 231 138360 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2060 SUTTER ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     14 Width 0ft   6002847.7164 2114462.1983 37.7860708218731 -122.433912120385 (37.7860708218731, -122.433912120385)
273 273 20166 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1155X Steiner St 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20 4X4   6002621.0 2112212.0 37.7798794773869 -122.43453554599199 (37.7798794773869, -122.434535545992)
284 284 137592 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 1125 Steiner St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/16/1990 12:00:00 AM 18 Width 0ft   6002857.6038 2112094.871 37.7795712988398 -122.433708655697 (37.7795712988398, -122.433708655697)
296 296 18021 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2725 Pine St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6000769.3896 2114817.5231 37.78692829139071 -122.44112805661501 (37.7869282913907, -122.441128056615)
325 325 21670 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1776 Sutter St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     22 4X4   6004121.8146 2114641.2436 37.786634655728605 -122.429516856277 (37.7866346557286, -122.429516856277)
342 342 21738 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2045 Sutter St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6002837.9936 2114410.7158 37.7859289122324 -122.43394207733601 (37.7859289122324, -122.433942077336)
378 378 138112 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1698 Sutter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     17 Width 0ft   6004508.5013 2114699.1479 37.7868155327596 -122.428183141793 (37.7868155327596, -122.428183141793)
523 523 247328 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 696X Oak St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 0ft   6003691.2873 2110070.3794 37.774059815342795 -122.430680081912 (37.7740598153428, -122.430680081912)
593 593 140072 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 601X Octavia St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 0ft   6005402.0 2111410.0 37.7778348570605 -122.424857751543 (37.7778348570605, -122.424857751543)
594 594 140071 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 601X Octavia St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 0ft   6005402.0 2111410.0 37.7778348570605 -122.424857751543 (37.7778348570605, -122.424857751543)
611 611 140070 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 601X Octavia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 0ft   6005402.0 2111410.0 37.7778348570605 -122.424857751543 (37.7778348570605, -122.424857751543)
879 879 246305 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2135 Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 Width 0ft   6006876.9266 2105933.3644 37.762880513109295 -122.41936683944401 (37.7628805131093, -122.419366839444)
894 894 15433 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2135 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6006876.1683 2105910.6162 37.7628180091578 -122.419367848279 (37.7628180091578, -122.419367848279)
911 911 12249 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 511 Laguna St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6004989.1563 2110705.1842 37.7758762780635 -122.42623573054199 (37.7758762780635, -122.426235730542)
935 935 143018 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 404 LOMBARD ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20 Width 0ft   6010387.0782 2120648.4016 37.80348159588821 -122.40826430805402 (37.8034815958882, -122.408264308054)
954 954 251405 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 540 LOMBARD ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/21/2016 12:08:00 PM   Width 0ft   6009678.016 2120549.6995 37.8031708545804 -122.410711083519 (37.8031708545804, -122.410711083519)
1064 1064 7177 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 827 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3X3   6003463.7289 2111198.6401 37.7771448458144 -122.431547809387 (37.7771448458144, -122.431547809387)
1072 1072 7266 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1740 Fillmore St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     16 4X4   6003064.3461 2114369.1192 37.7858275412041 -122.433155987425 (37.7858275412041, -122.433155987425)
1120 1120 7264 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1730 Fillmore St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6003073.6496 2114318.6841 37.78568958693 -122.43312019509199 (37.78568958693, -122.433120195092)
1121 1121 13143 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1800 Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     100 3X3   6003680.9036 2119717.0807 37.8005466318744 -122.431404778789 (37.8005466318744, -122.431404778789)
1154 1154 246084 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 1390 Waller St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 0ft   5999058.5497 2108380.2585 37.7691556230859 -122.446583834228 (37.7691556230859, -122.446583834228)
1164 1164 246083 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 1390 Waller St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 0ft   5999078.2336 2108382.6812 37.7691633995354 -122.446515923307 (37.7691633995354, -122.446515923307)
1169 1169 246080 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 1390 Waller St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/29/1979 12:00:00 AM 12 Width 0ft Permit Number 17683 5999123.3551 2108389.3434 37.7691842694065 -122.446360330481 (37.7691842694065, -122.446360330481)
1172 1172 143012 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 336 LOMBARD ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 0ft   6010686.887999999 2120692.5302 37.803619545603205 -122.40722991099 (37.8036195456032, -122.40722991099)
1176 1176 246082 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 1390 Waller St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 0ft   5999092.1637 2108384.801 37.7691700156221 -122.44646789257601 (37.7691700156221, -122.446467892576)
1336 1336 7171 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 801 Fillmore St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3 Permit Number 780067 6003475.9145 2111120.5411 37.7769310959731 -122.431500078765 (37.7769310959731, -122.431500078765)
1340 1340 7172 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 801 Fillmore St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3 Permit Number 780067 6003478.683999999 2111101.7087 37.7768795438362 -122.43148915347099 (37.7768795438362, -122.431489153471)
1343 1343 7169 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 801 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3 Permit Number 780067 6003470.3756 2111160.9753 37.777041804334296 -122.43152212680799 (37.7770418043343, -122.431522126808)
1345 1345 7170 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 801 Fillmore St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3 Permit Number 780067 6003473.1451 2111141.589 37.776988731328295 -122.43151116193 (37.7769887313283, -122.43151116193)
1363 1363 21606 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1525 Sutter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6005078.2447 2114724.3621 37.7869169843519 -122.426213757225 (37.7869169843519, -122.426213757225)
1448 1448 138093 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1890 Sutter St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 Width 0ft   6003632.0 2114586.0 37.7864552256154 -122.43120755079399 (37.7864552256154, -122.431207550794)
1462 1462 247381 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1001 Oak St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 Width 0ft   6002208.0 2109818.0 37.7732826991746 -122.43579295981199 (37.7732826991746, -122.435792959812)
1463 1463 13191 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2095 Lombard St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6002470.5921 2119469.4635 37.7997980716779 -122.43557521775601 (37.7997980716779, -122.435575217756)
1466 1466 247380 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1001 Oak St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     13 Width 0ft   6002208.0 2109818.0 37.7732826991746 -122.43579295981199 (37.7732826991746, -122.435792959812)
1468 1468 247377 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1001 Oak St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     15 Width 0ft   6002208.0 2109818.0 37.7732826991746 -122.43579295981199 (37.7732826991746, -122.435792959812)
1470 1470 138091 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1890 Sutter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/09/1990 12:00:00 AM 15 Width 0ft   6003632.0 2114586.0 37.7864552256154 -122.43120755079399 (37.7864552256154, -122.431207550794)
1477 1477 138092 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1890 Sutter St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     19 Width 0ft   6003632.0 2114586.0 37.7864552256154 -122.43120755079399 (37.7864552256154, -122.431207550794)
1504 1504 21609 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1531 Sutter St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/09/1990 12:00:00 AM 12 4X4   6005037.9058 2114711.086 37.7868782513618 -122.42635237507 (37.7868782513618, -122.42635237507)
1528 1528 13126 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1701 Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     21 3X3   6004190.6649 2119706.135 37.8005454550984 -122.42964001675399 (37.8005454550984, -122.429640016754)
1644 1644 14813 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1195 McAllister St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6003481.2511 2111720.7527 37.778579430545896 -122.431524477475 (37.7785794305459, -122.431524477475)
1759 1759 7200 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 949 Fillmore St 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6003420.9887 2111521.8792 37.7780299575939 -122.431718745255 (37.7780299575939, -122.431718745255)
1775 1775 245411 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2794 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 0ft   6010069.4683 2102240.5937 37.7529202865107 -122.408064458251 (37.7529202865107, -122.408064458251)
1834 1834 13113 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 1611 Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     30 3x3   6004587.0591 2119767.9005 37.8007374842012 -122.428272736084 (37.8007374842012, -122.428272736084)
1838 1838 9642 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1482 Golden Gate Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     15 3x3   6002517.4506 2111986.4237 37.7792542228164 -122.43487763237101 (37.7792542228164, -122.434877632371)
1873 1873 20151 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 1043 Steiner St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/13/2016 12:00:00 AM 3 3x3 Permit Number 778996 6002888.3687 2111863.5194 37.7789378108444 -122.433585688352 (37.7789378108444, -122.433585688352)
1904 1904 245410 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 2782 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 Width 0ft   6010125.3081 2102244.3008 37.752933591707794 -122.40787161420401 (37.7529335917078, -122.407871614204)
1906 1906 244384 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 257 Oak St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     16 Width 0ft   6005748.2149 2110309.2015 37.7748318806023 -122.423581789147 (37.7748318806023, -122.423581789147)
1971 1971 21669 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1776 Sutter St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     22 4X4   6004141.1865 2114642.4934 37.7866391841692 -122.42944992335698 (37.7866391841692, -122.429449923357)
2005 2005 7164 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 733 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6003503.3323 2110918.6468 37.7763782981407 -122.43139081647399 (37.7763782981407, -122.431390816474)
2016 2016 13112 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 1601 Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     90 3x3   6004666.807 2119779.6281 37.800774197193796 -122.42799761136001 (37.8007741971938, -122.42799761136)
2052 2052 143142 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2140 LOMBARD ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     16 Width 0ft   6002105.6639 2119495.6188 37.7998491537216 -122.43683987606899 (37.7998491537216, -122.436839876069)
2054 2054 143144 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2150 LOMBARD ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     13 Width 0ft   6002035.2938 2119489.3913 37.799828054976395 -122.437082936374 (37.7998280549764, -122.437082936374)
2056 2056 143141 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2140 LOMBARD ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     17 Width 0ft   6002153.6152 2119503.7145 37.7998741075374 -122.436674526744 (37.7998741075374, -122.436674526744)
2132 2132 13212 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 2190 Lombard St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     70 3X3   6001925.0681 2119471.9545 37.7997739121356 -122.437463108341 (37.7997739121356, -122.437463108341)
2173 2173 21585 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1500 Sutter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 2X2   6005366.3574 2114813.7602 37.7871787298771 -122.425223316098 (37.7871787298771, -122.425223316098)
2207 2207 244533 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1588 Haight St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     14 Width 0ft   5998589.1758 2108666.333 37.7699142890018 -122.448227967728 (37.7699142890018, -122.448227967728)
2225 2225 7163 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 730 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     21 3X3   6003538.8779 2111021.3343 37.776662267069895 -122.43127518600001 (37.7766622670699, -122.431275186)
2607 2607 139083 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 2512 Post St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 0ft   6000143.6633 2113744.4727 37.7839463117797 -122.443215821997 (37.7839463117797, -122.443215821997)
2797 2797 142505 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 620 Vallejo St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   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)
2799 2799 142504 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 610 Vallejo St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   09/29/1999 12:00:00 AM 12 Width 0ft   6010596.4955 2118942.3174 37.7988088315184 -122.407419256939 (37.7988088315184, -122.407419256939)
2878 2878 57526 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 501 Grove St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/19/1981 12:00:00 AM 13 3x3 Permit Number 19437 6005352.078 2111299.9206 37.7775297860553 -122.42502261513701 (37.7775297860553, -122.425022615137)
2890 2890 17680 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1020 Pierce St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6002416.7239 2112103.0842 37.7795688238035 -122.43523443397801 (37.7795688238035, -122.435234433978)
2903 2903 13280 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2524 Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   08/15/1993 12:00:00 AM 40 3X3   6000256.3025 2119240.7621 37.7990441048198 -122.44322102307699 (37.7990441048198, -122.443221023077)
2908 2908 140145 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 2077 HAYES ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 0ft   5997912.6072 2109907.6306 37.7732838718856 -122.45065770078699 (37.7732838718856, -122.450657700787)
2909 2909 140144 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 2077 HAYES ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 0ft   5997892.6775 2109904.5645 37.7732743123753 -122.450726418895 (37.7732743123753, -122.450726418895)
2910 2910 140146 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 2077 HAYES ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 0ft   5997931.7703 2109910.6967 37.773293387477395 -122.450591634422 (37.7732933874774, -122.450591634422)
2923 2923 140143 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 2077 HAYES ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/06/1981 12:00:00 AM 9 Width 0ft Permit Number 19125 5997871.2148 2109901.8816 37.7732657172386 -122.45080046745001 (37.7732657172386, -122.45080046745)
3051 3051 99233 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 1111 Columbus Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6008063.2168 2121048.832 37.8044506767497 -122.416334531861 (37.8044506767497, -122.416334531861)
3154 3154 142517 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 402 Columbus Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     19 Width 0ft   6010454.8754 2118953.3694 37.798831249998 -122.40791009059299 (37.798831249998, -122.407910090593)
3219 3219 142514 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 624 VALLEJO ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   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)
3249 3249 142515 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 624 VALLEJO ST 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/17/2014 12:00:00 AM 21 Width 0ft Permit Number 774306 6010502.9388 2118931.0084 37.7987725428783 -122.40774219721901 (37.7987725428783, -122.407742197219)
3328 3328 140422 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 1499 TURK ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Police Dept 18     14 Width 0ft   6002931.6326 2112346.6107 37.7802667133087 -122.43347055342699 (37.7802667133087, -122.433470553427)
3334 3334 140424 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 1499 TURK ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Police Dept 18     13 Width 0ft   6002981.8736 2112352.3525 37.7802853291655 -122.43329715719 (37.7802853291655, -122.43329715719)
3335 3335 140428 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 1499 TURK ST 7 Sidewalk: Curb side : Cutout 1 Tree 1 Police Dept 18     14 Width 0ft   6003076.6138 2112365.9894 37.7803281468599 -122.43297038187401 (37.7803281468599, -122.432970381874)
3337 3337 140433 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 1499 Turk St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Police Dept 18     15 Width 0ft   6003251.7396 2112391.1099 37.7804070531695 -122.432366335522 (37.7804070531695, -122.432366335522)
3338 3338 138120 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 1970 SUTTER ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 0ft   6003157.8417 2114507.235 37.7862120754355 -122.432842389477 (37.7862120754355, -122.432842389477)
3339 3339 140429 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 1499 TURK ST 8 Sidewalk: Curb side : Cutout 1 Tree 1 Police Dept 18     15 Width 0ft   6003096.7102 2112369.578 37.7803391401181 -122.432901115602 (37.7803391401181, -122.432901115602)
3342 3342 140426 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 1499 TURK ST 5 Sidewalk: Curb side : Cutout 1 Tree 1 Police Dept 18     12 Width 0ft   6003027.0905 2112359.5298 37.7803076012967 -122.43314124413601 (37.7803076012967, -122.433141244136)
3343 3343 140423 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 1499 TURK ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Police Dept 18     13 Width 0ft   6002956.7531 2112350.9171 37.7802799627924 -122.43338395792802 (37.7802799627924, -122.433383957928)
3344 3344 140425 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 1499 TURK ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 Police Dept 18     12 Width 0ft   6003006.2764 2112357.3766 37.780300508432795 -122.43321309578998 (37.7803005084328, -122.43321309579)
3347 3347 140434 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 1499 Turk St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Police Dept 18     14 Width 0ft   6003279.731000001 2112394.6985 37.780418493723204 -122.43226975660299 (37.7804184937232, -122.432269756603)
3349 3349 140427 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 1499 TURK ST 6 Sidewalk: Curb side : Cutout 1 Tree 1 Police Dept 18     14 Width 0ft   6003052.211 2112362.4007 37.7803169090148 -122.43305454594 (37.7803169090148, -122.43305454594)
3351 3351 140431 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 1499 Turk St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Police Dept 18     14 Width 0ft   6003184.2731 2112381.0617 37.7803756375453 -122.432599015585 (37.7803756375453, -122.432599015585)
3362 3362 114879 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 1454 HAYES ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6000868.0 2110394.0 37.7747880422892 -122.440469509771 (37.7747880422892, -122.440469509771)
3435 3435 13052 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 557 Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6009686.1191 2120512.8313 37.8030700779734 -122.410680437216 (37.8030700779734, -122.410680437216)
3729 3729 18005 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2683 Pine St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6001144.5248 2114870.2639 37.787094464568796 -122.43983396035101 (37.7870944645688, -122.439833960351)
3904 3904 4665 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 600X Columbus Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     100 5X5   6009675.3838 2119664.5956 37.8007404309352 -122.410657649881 (37.8007404309352, -122.410657649881)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 406.848ms · Data source: data.sfgov.org