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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |
| 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) | |||
| 4221 | 4221 | 244055 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 401 Cole St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5997910.1594 | 2109123.3007 | 37.771130163517704 | -122.450609610411 | (37.7711301635177, -122.450609610411) | |||
| 4223 | 4223 | 246149 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1504 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5998439.5671 | 2108294.2551 | 37.7688841037799 | -122.44871865576 | (37.7688841037799, -122.44871865576) | |||
| 4236 | 4236 | 246150 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1504 Waller St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5998421.7001 | 2108292.1353 | 37.7688772616464 | -122.448780303512 | (37.7688772616464, -122.448780303512) | |||
| 4243 | 4243 | 246126 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1546 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5998264.228999999 | 2108270.3316 | 37.768808388052605 | -122.449323411621 | (37.7688083880526, -122.449323411621) | |||
| 4247 | 4247 | 246146 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1504 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/1980 12:00:00 AM | 16 | Width 0ft | Permit Number 18128 | 5998494.9848 | 2108301.523 | 37.76890722837079 | -122.44852749406 | (37.7689072283708, -122.44852749406) | |
| 4252 | 4252 | 244056 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 401 Cole St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5997913.0484 | 2109110.0936 | 37.771094065570296 | -122.45059866498 | (37.7710940655703, -122.45059866498) | |||
| 4265 | 4265 | 246125 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1546 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/1979 12:00:00 AM | 13 | Width 0ft | Permit Number 17701 | 5998276.9478 | 2108272.4514 | 37.7688149359981 | -122.44927957115101 | (37.7688149359981, -122.449279571151) | |
| 4278 | 4278 | 246148 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1504 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5998461.6736 | 2108298.4947 | 37.768897008730896 | -122.44864249661501 | (37.7688970087309, -122.448642496615) | |||
| 4557 | 4557 | 245383 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 3720 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | Width 0ft | 6005268.7499 | 2096538.92 | 37.7369948294896 | -122.42426078327499 | (37.7369948294896, -122.424260783275) | |||
| 4565 | 4565 | 142525 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 301 FRANCISCO ST | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 23 | Width 0ft | 6009759.5801 | 2121214.59 | 37.8050010513122 | -122.410475804946 | (37.8050010513122, -122.410475804946) | |||
| 4602 | 4602 | 245382 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 3720 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | Width 0ft | 6005277.267000001 | 2096556.8057 | 37.7370444205252 | -122.42423260748899 | (37.7370444205252, -122.424232607489) | |||
| 4603 | 4603 | 142513 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 419 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | Width 0ft | 6010363.8889 | 2118953.3694 | 37.798826155678796 | -122.408224935007 | (37.7988261556788, -122.408224935007) | |||
| 4606 | 4606 | 142512 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 427 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | Width 0ft | 6010331.5039 | 2118981.6421 | 37.798901972160294 | -122.40833899341601 | (37.7989019721603, -122.408338993416) | |||
| 4924 | 4924 | 143020 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 560 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | Width 0ft | 6009678.016 | 2120549.6995 | 37.8031708545804 | -122.410711083519 | (37.8031708545804, -122.410711083519) | |||
| 22298 | 22298 | 143213 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 175 FRANCISCO ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6010427.9747 | 2121297.8273 | 37.8052670481181 | -122.40816861291 | (37.8052670481181, -122.40816861291) | |||
| 22359 | 22359 | 246131 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1486 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5998602.7919 | 2108317.2701 | 37.768956629428395 | -122.448155732181 | (37.7689566294284, -122.448155732181) | |||
| 22888 | 22888 | 245220 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 351 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6005075.2787 | 2110089.7787 | 37.774191391909596 | -122.425893994936 | (37.7741913919096, -122.425893994936) | |||
| 23633 | 23633 | 137529 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1300 Pierce St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6002258.0131 | 2113181.285 | 37.7825202770743 | -122.43586064910801 | (37.7825202770743, -122.435860649108) | |||
| 23704 | 23704 | 138749 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1528 BAKER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6000156.6321 | 2114235.0077 | 37.785293933510104 | -122.443206197892 | (37.7852939335101, -122.443206197892) | |||
| 23797 | 23797 | 143335 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1820 UNION ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6004232.6567 | 2118749.9753 | 37.7979224644928 | -122.42942648353399 | (37.7979224644928, -122.429426483534) | |||
| 23838 | 23838 | 140159 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 251 ASHBURY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998783.859 | 2109828.5826 | 37.77311665794689 | -122.44763824308501 | (37.7731166579469, -122.447638243085) | |||
| 24010 | 24010 | 248469 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 145 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998248.1791 | 2107933.2828 | 37.7678820197346 | -122.449354639507 | (37.7678820197346, -122.449354639507) | |||
| 24233 | 24233 | 140776 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 77 TERRA VISTA AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000147.5673 | 2112813.1036 | 37.7813892348129 | -122.443135402805 | (37.7813892348129, -122.443135402805) | |||
| 24268 | 24268 | 139286 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 847 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6003452.0971 | 2111280.6163 | 37.777369272847295 | -122.431593901382 | (37.7773692728473, -122.431593901382) | |||
| 24338 | 24338 | 142592 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 365 COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6008300.8769 | 2120835.2204 | 37.803877514381 | -122.415496953155 | (37.803877514381, -122.415496953155) | |||
| 24575 | 24575 | 138501 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1799 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6002528.8099 | 2114345.6813 | 37.7857327932764 | -122.435007113669 | (37.7857327932764, -122.435007113669) | |||
| 24601 | 24601 | 138420 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1819 STEINER ST | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 0ft | 6002521.5979 | 2114452.899 | 37.786026776312596 | -122.435039736101 | (37.7860267763126, -122.435039736101) | |||
| 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) | |||
| 26124 | 26124 | 143189 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 184 FRANCISCO ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6010358.1536 | 2121339.5444 | 37.8053776832044 | -122.408413183131 | (37.8053776832044, -122.408413183131) | |||
| 26187 | 26187 | 244530 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 557 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5998936.3155 | 2108740.8879 | 37.7701388371467 | -122.44703258946998 | (37.7701388371467, -122.44703258947) | |||
| 26219 | 26219 | 201182 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 620 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6013434.6654 | 2113939.6272 | 37.785231064684204 | -122.39724720317801 | (37.7852310646842, -122.397247203178) | |||
| 26247 | 26247 | 140689 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1120 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003360.489 | 2112281.5531 | 37.780112403361294 | -122.431982295298 | (37.7801124033613, -122.431982295298) | |||
| 26256 | 26256 | 142499 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 521 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6009964.3012 | 2119317.683 | 37.7998040885057 | -122.40963337214 | (37.7998040885057, -122.40963337214) | |||
| 26431 | 26431 | 143534 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2095 UNION ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6003009.3374 | 2118534.798 | 37.797262307390795 | -122.433644124881 | (37.7972623073908, -122.433644124881) |
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");