Street_Tree_List

Data source: data.sfgov.org

1,442 rows where qSpecies = 59 sorted by Longitude

✎ 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
157150 157150 43881 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 1245 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/03/2000 12:00:00 AM 3   Permit Number 43494 5981473.1113 2106617.2091 37.7632946239394 -122.507278997702 (37.7632946239394, -122.507278997702)
58145 58145 183272 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 1251 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 0ft   5983645.262999999 2106639.9345 37.7634847239936 -122.49976803825199 (37.7634847239936, -122.499768038252)
187140 187140 183273 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 1251 40th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 0ft   5983646.3542 2106625.2038 37.7634443416971 -122.49976317535801 (37.7634443416971, -122.499763175358)
44212 44212 184648 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 1691 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   5983748.1287 2103659.9866 37.755308660398505 -122.49919205978998 (37.7553086603985, -122.49919205979)
157088 157088 184487 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 1862 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5983833.6059 2102475.6712 37.75206187373821 -122.498808969569 (37.7520618737382, -122.498808969569)
183473 183473 184489 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 1866 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5983834.6211 2102450.9664 37.7519941007524 -122.49880363397499 (37.7519941007524, -122.498803633975)
29051 29051 181932 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 2378 36th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 0ft   5985195.246 2099024.2764 37.74266505256279 -122.49384596323 (37.7426650525628, -122.49384596323)
133205 133205 62731 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 2307 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/20/1993 12:00:00 AM 10   Permit Number 32015 5985442.2939 2099497.5593 37.7439790107491 -122.49302661105 (37.7439790107491, -122.49302661105)
43401 43401 182246 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 1455 33rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 0ft   5985863.116 2105312.6885 37.759970370515106 -122.491999577939 (37.7599703705151, -122.491999577939)
58272 58272 181891 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 2362 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5985808.0433 2099163.7908 37.7430839555722 -122.491737385137 (37.7430839555722, -122.491737385137)
67059 67059 185225 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 2519 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 0ft   5985800.5083 2098072.0747 37.7400859553966 -122.491683090969 (37.7400859553966, -122.491683090969)
41163 41163 181854 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 2318 32nd Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 0ft   5986419.9945 2099457.4563 37.7439260290789 -122.48964304245001 (37.7439260290789, -122.48964304245)
39439 39439 181853 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 2318 32nd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 0ft   5986420.3329 2099445.95 37.7438944556176 -122.48964102637699 (37.7438944556176, -122.489641026377)
67589 67589 181728 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 2755 29th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   5987089.3098 2107026.595 37.7647478839827 -122.487884750055 (37.7647478839827, -122.487884750055)
40899 40899 181727 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 2755 29th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 0ft   5987094.0342 2107004.1542 37.76468654333279 -122.487866760897 (37.7646865433328, -122.487866760897)
134981 134981 182109 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 2443 28th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 0ft   5987643.897000001 2098649.745 37.741779647708995 -122.48535186527599 (37.741779647709, -122.485351865276)
44905 44905 182129 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 2650 Ulloa St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5987716.6576 2098310.3756 37.740852067466506 -122.485075392772 (37.7408520674665, -122.485075392772)
71966 71966 182128 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 2650 Ulloa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   5987739.3319 2098310.7141 37.7408543176455 -122.48499701931601 (37.7408543176455, -122.484997019316)
159251 159251 183822 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 2235 27th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 0ft   5987905.4957 2100075.9969 37.7457109948541 -122.484551945811 (37.7457109948541, -122.484551945811)
148571 148571 183823 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 2235 27th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5987905.9224 2100064.0482 37.7456782117444 -122.48454959408501 (37.7456782117444, -122.484549594085)
31784 31784 98024 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 1639 Taraval St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   5988098.058999999 2098940.517 37.742604479099 -122.483802857352 (37.742604479099, -122.483802857352)
188134 188134 181943 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 1635 Taraval St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   5988119.3796 2098941.1939 37.7426075787892 -122.483729187458 (37.7426075787892, -122.483729187458)
72332 72332 182039 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 1323 23rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 0ft   5988935.747 2106319.8798 37.7629149697028 -122.481446720354 (37.7629149697028, -122.481446720354)
156572 156572 251046 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 5625 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5989523.2215 2112593.8297 37.7801756529596 -122.479874006145 (37.7801756529596, -122.479874006145)
156594 156594 251080 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 5616 Geary Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   5989535.5879999995 2112697.0631 37.7804598215152 -122.47983878158999 (37.7804598215152, -122.47983878159)
27423 27423 251079 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 5616 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   5989547.9545 2112698.1385 37.7804634926969 -122.479796079248 (37.7804634926969, -122.479796079248)
22559 22559 9075 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 5612 Geary Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   5989561.9341 2112697.6008 37.7804628284507 -122.47974767842399 (37.7804628284507, -122.479747678424)
22784 22784 9074 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 5612 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   5989576.4513 2112697.6008 37.780463671789 -122.47969745716499 (37.780463671789, -122.479697457165)
165135 165135 101264 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 2000 Irving St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11   Permit Number 20727 5989453.6006 2106533.1127 37.7635305455459 -122.479671267422 (37.7635305455459, -122.479671267422)
26993 26993 101263 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 2000 Irving St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12   Permit Number 20727 5989478.8752 2106534.6445 37.76353621964879 -122.479583963683 (37.7635362196488, -122.479583963683)
171803 171803 60926 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 2000 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/13/1983 12:00:00 AM 13   Permit Number 20727 5989507.2134 2106536.1763 37.7635420716385 -122.479486064031 (37.7635420716385, -122.479486064031)
134348 134348 97114 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 1345 Noriega St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7   Permit Number 18860 5989801.9904 2103085.8445 37.7540855022306 -122.47821424615101 (37.7540855022306, -122.478214246151)
32530 32530 97312 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 926 Taraval St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/19/1984 12:00:00 AM 10 3x3   5990212.18 2099077.2394 37.7431027248159 -122.476502906842 (37.7431027248159, -122.476502906842)
164818 164818 87369 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 926 Taraval St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/11/2008 12:00:00 AM 10 3x3 Permit Number 50349 5990243.3148 2099080.9621 37.7431147521003 -122.476395524083 (37.7431147521003, -122.476395524083)
74885 74885 97311 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 926 Taraval St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/19/1984 12:00:00 AM 7 3x3   5990303.3847 2099082.1466 37.7431214880079 -122.47618790715099 (37.7431214880079, -122.476187907151)
22715 22715 9008 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 5255 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   5990650.4547 2112633.3493 37.7803495870008 -122.475977319009 (37.7803495870008, -122.475977319009)
180017 180017 217621 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 1830 Ocean Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 0ft   5994307.7366 2092494.0455 37.725263580598 -122.461864420033 (37.725263580598, -122.461864420033)
24837 24837 217620 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 1830 Ocean Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 0ft   5994327.7005 2092483.4396 37.7252356086447 -122.461794638623 (37.7252356086447, -122.461794638623)
184834 184834 217619 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 1830 Ocean Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 0ft   5994357.3344 2092471.2741 37.7252039110132 -122.461691316268 (37.7252039110132, -122.461691316268)
162336 162336 217617 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 1830 Ocean Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 0ft   5994396.9504 2092455.3654 37.7251625099423 -122.46155321589701 (37.7251625099423, -122.461553215897)
17676 17676 25267 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1738 Ocean Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     10 3X3   5994656.4814 2092369.8948 37.7249427634406 -122.46064985933901 (37.7249427634406, -122.460649859339)
18821 18821 25266 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1738 Ocean Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     13 3X3   5994668.335 2092363.0322 37.7249246023662 -122.460608386003 (37.7249246023662, -122.460608386003)
20249 20249 25265 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1738 Ocean Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     14 3X3   5994685.8034 2092359.9129 37.7249170424989 -122.46054777423099 (37.7249170424989, -122.460547774231)
86975 86975 53539 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 322 02nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/11/1969 12:00:00 AM     Permit Number 776401 5995280.52661988 2113383.63166464 37.78267703677329 -122.460014224406 (37.7826770367733, -122.460014224406)
35602 35602 217547 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 102 Broad St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   5995842.2441 2088093.8487 37.713269899907104 -122.45624180431801 (37.7132698999071, -122.456241804318)
22132 22132 28299 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 100 Broad St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 3X3   5995861.9776 2088092.909 37.713268452474104 -122.45617353106701 (37.7132684524741, -122.456173531067)
63167 63167 142150 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 20 Stanyan Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5996389.5624 2112799.0591 37.7811356783284 -122.456135178495 (37.7811356783284, -122.456135178495)
7961 7961 28067 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 3445 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3X3   5996427.4656 2112840.3465 37.7812512181791 -122.456007038851 (37.7812512181791, -122.456007038851)
4440 4440 28068 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 3445 Geary Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3X3   5996452.8473 2112841.7002 37.78125639187 -122.455919329089 (37.78125639187, -122.455919329089)
60580 60580 141074 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 189 COMMONWEALTH AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 0ft   5996533.2225 2113090.6095 37.7819444436309 -122.45565926922701 (37.7819444436309, -122.455659269227)
137944 137944 141075 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 189 COMMONWEALTH AVE 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5996533.8993 2113075.3805 37.7819026676704 -122.45565582670099 (37.7819026676704, -122.455655826701)
39267 39267 141082 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 188 Commonwealth Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   5996586.3547 2113042.2151 37.7818146143415 -122.455471958556 (37.7818146143415, -122.455471958556)
70703 70703 141081 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 190 Commonwealth Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 0ft   5996587.7084 2113030.7088 37.78178309876421 -122.45546644353901 (37.7817830987642, -122.455466443539)
33367 33367 141080 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 192 Commonwealth Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 0ft   5996588.0468 2113019.8793 37.7817533832417 -122.45546448989799 (37.7817533832417, -122.455464489898)
50202 50202 141078 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 196 Commonwealth Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 0ft   5996588.0468 2112978.9303 37.7816409481265 -122.455461529406 (37.7816409481265, -122.455461529406)
137853 137853 141079 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 194 Commonwealth Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 0ft   5996588.7236 2113000.2508 37.781699527411604 -122.455460729419 (37.7816995274116, -122.455460729419)
60428 60428 141088 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 3380 GEARY BLVD 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 0ft   5996627.3037 2112959.9786 37.7815911642759 -122.455324349899 (37.7815911642759, -122.455324349899)
61172 61172 141087 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 3380 GEARY BLVD 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 0ft   5996639.8253 2112960.6555 37.781593741302 -122.45528108031999 (37.781593741302, -122.45528108032)
131272 131272 141086 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 3370 GEARY BLVD 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 0ft   5996653.0238 2112962.6859999998 37.781600073776204 -122.45523556684999 (37.7816000737762, -122.45523556685)
29557 29557 141085 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 3370 GEARY BLVD 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 0ft   5996665.207 2112963.3629 37.781602631354794 -122.455193467958 (37.7816026313548, -122.455193467958)
158904 158904 141084 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 3360 GEARY BLVD 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 0ft   5996679.0822 2112965.7318 37.7816099317752 -122.45514563789 (37.7816099317752, -122.45514563789)
174864 174864 64376 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 69 Beaumont Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/21/1988 12:00:00 AM 11   Permit Number 25215 5996673.1599 2112554.0417 37.7804791997483 -122.45513636713801 (37.7804791997483, -122.455136367138)
146971 146971 141083 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 3360 GEARY BLVD 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 0ft   5996691.6039 2112967.4239 37.7816152962122 -122.45510244133001 (37.7816152962122, -122.45510244133)
181919 181919 53486 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 3360 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/31/1969 12:00:00 AM 14   Permit Number 6395 5996703.1102 2112969.116 37.7816206023811 -122.455062757544 (37.7816206023811, -122.455062757544)
182280 182280 141531 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 2901 TURK BLVD 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   5996721.1149 2111488.1108 37.777555184997894 -122.45489342919399 (37.7775551849979, -122.454893429194)
151601 151601 141533 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 2901 TURK BLVD 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 0ft   5996746.9 2111493.597 37.7775717277647 -122.45480462688101 (37.7775717277647, -122.454804626881)
152387 152387 141535 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 2901 TURK BLVD 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 0ft   5996788.0463 2111499.0832 37.777589151551 -122.454662685268 (37.777589151551, -122.454662685268)
164399 164399 141486 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 2901 TURK BLVD 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5996862.6584 2111508.4097 37.77761903893 -122.454405252217 (37.77761903893, -122.454405252217)
37099 37099 141488 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 2901 TURK BLVD 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5996896.3984 2111514.1702 37.7776367906711 -122.454288950996 (37.7776367906711, -122.454288950996)
96109 96109 141490 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 2901 TURK BLVD 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5996921.6348 2111517.4619 37.7776472759958 -122.454201888036 (37.7776472759958, -122.454201888036)
67728 67728 141494 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 2901 TURK BLVD 18 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   5996978.1424 2111525.1425 37.7776716051006 -122.45400696498899 (37.7776716051006, -122.454006964989)
51389 51389 141496 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 2901 TURK BLVD 20 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   5997041.2335 2111532.8232 37.77769631160189 -122.45378926737101 (37.7776963116019, -122.453789267371)
152752 152752 247257 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 2095 Oak St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 0ft   5997008.9956 2109086.9596 37.7709787579671 -122.45372412669902 (37.7709787579671, -122.453724126699)
171478 171478 61148 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 2237 Fulton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/28/1983 12:00:00 AM 7   Permit Number 21005 5997050.2982 2110479.7459 37.7748053558267 -122.453681848705 (37.7748053558267, -122.453681848705)
73607 73607 247258 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 2089 Oak St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   5997028.4355 2109091.0184 37.7709910168471 -122.453657177015 (37.7709910168471, -122.453657177015)
17505 17505 20093 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 2079X Oak St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   5997064.7516 2109095.7182 37.7710060031357 -122.453531898634 (37.7710060031357, -122.453531898634)
21742 21742 20094 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 2075X Oak St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   5997081.4143 2109098.2817 37.7710139970036 -122.453474447283 (37.7710139970036, -122.453474447283)
38816 38816 246090 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 700 Stanyan St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 0ft   5997084.5583 2108373.7477 37.769024793611 -122.45341125296001 (37.769024793611, -122.45341125296)
161629 161629 246091 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 700 Stanyan St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 0ft   5997087.5866 2108354.0638 37.7689709202682 -122.45339935697099 (37.7689709202682, -122.453399356971)
187956 187956 246092 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 700 Stanyan St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 0ft   5997091.8262 2108330.4431 37.7689063069149 -122.45338298694901 (37.7689063069149, -122.453382986949)
154687 154687 246093 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 700 Stanyan St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 0ft   5997094.8545 2108310.1536 37.7688507707463 -122.453371047271 (37.7688507707463, -122.453371047271)
133245 133245 246094 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 700 Stanyan St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 0ft   5997100.0026 2108265.6377 37.7687288366145 -122.453350026115 (37.7687288366145, -122.453350026115)
46704 46704 246095 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 700 Stanyan St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 0ft   5997104.5451 2108242.017 37.768664240613205 -122.45333260848801 (37.7686642406132, -122.453332608488)
167223 167223 246096 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 700 Stanyan St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 0ft   5997106.9677 2108216.5794 37.768594534360204 -122.453322392223 (37.7685945343602, -122.453322392223)
180852 180852 246097 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 700 Stanyan St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 0ft   5997110.2988 2108193.2616 37.7685307006045 -122.45330918662901 (37.7685307006045, -122.453309186629)
64636 64636 246098 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 700 Stanyan St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5997112.7214 2108174.1833 37.7684784553517 -122.45329942957198 (37.7684784553517, -122.453299429572)
155231 155231 246099 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 700 Stanyan St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 0ft   5997115.1441 2108154.4994 37.7684245472814 -122.453289628456 (37.7684245472814, -122.453289628456)
150865 150865 246100 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 700 Stanyan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 0ft   5997118.778 2108135.4212 37.7683723717283 -122.453275681682 (37.7683723717283, -122.453275681682)
149998 149998 248465 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 772 Stanyan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5997147.6982 2107925.2578 37.767796974534605 -122.45316047633601 (37.7677969745346, -122.453160476336)
21345 21345 17138 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2049 Oak St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   5997189.9355 2109110.6719 37.771054237387396 -122.453099965702 (37.7710542373874, -122.453099965702)
21485 21485 17133 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2021 Oak St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   5997314.265 2109127.7618 37.7711082865548 -122.452671141791 (37.7711082865548, -122.452671141791)
21783 21783 17132 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2017 Oak St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   5997337.3364 2109131.1798 37.7711189934376 -122.45259158414301 (37.7711189934376, -122.452591584143)
43725 43725 246164 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 1756 Waller St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 Width 0ft   5997323.9447 2108138.6009 37.768392859677896 -122.452566262235 (37.7683928596779, -122.452566262235)
161016 161016 66368 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 5 Cook St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/04/1991 12:00:00 AM 10   Permit Number 29490 5997440.3621 2113655.9431 37.7835487164216 -122.452561811691 (37.7835487164216, -122.452561811691)
134800 134800 140932 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 5 COOK ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   5997447.8074 2113631.9151 37.783483168451 -122.452534319363 (37.783483168451, -122.452534319363)
21113 21113 17130 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2001 Oak St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   5997372.7981 2109137.1613 37.7711374488605 -122.45246935322399 (37.7711374488605, -122.452469353224)
19705 19705 17131 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2001 Oak St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   5997393.7333 2109140.5793 37.771148033222794 -122.452397184671 (37.7711480332228, -122.452397184671)
169803 169803 141307 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 61 COOK ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 0ft   5997486.7259 2113348.6561 37.7827076436193 -122.452379230189 (37.7827076436193, -122.452379230189)
183087 183087 248411 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 1737 Waller St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 0ft   5997411.4623 2108107.5609 37.76831264578671 -122.45226130839701 (37.7683126457867, -122.452261308397)
67720 67720 94860 Permitted Site 1 Ficus retusa nitida :: Banyan Fig 59 2161 Grove St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 6x4   5997487.0021 2110201.3474 37.7740659715368 -122.452151115771 (37.7740659715368, -122.452151115771)

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 459.33ms · Data source: data.sfgov.org