Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |
| 153054 | 153054 | 246152 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1720 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5997446.2877 | 2108155.2565 | 37.7684456006596 | -122.45214429305 | (37.7684456006596, -122.45214429305) | |||
| 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) | |||
| 39575 | 39575 | 246153 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1720 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5997461.1263 | 2108156.7707 | 37.7684506082583 | -122.45209307718099 | (37.7684506082583, -122.452093077181) |
JSON shape: default, array, newline-delimited
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");