Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 33688 | 33688 | 185805 | Undocumented 2 | :: 54 | 1655 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5989756.6889 | 2101643.8628 | 37.750123572207706 | -122.478265480697 | (37.7501235722077, -122.478265480697) | |||
| 33709 | 33709 | 185819 | Undocumented 2 | :: 54 | 2039 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986926.728999999 | 2101375.0645 | 37.7492208393265 | -122.488031768826 | (37.7492208393265, -122.488031768826) | |||
| 33727 | 33727 | 140005 | Undocumented 2 | :: 54 | 580 FULTON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005138.6408 | 2111659.5949 | 37.7785053047816 | -122.425786573599 | (37.7785053047816, -122.425786573599) | |||
| 33783 | 33783 | 184628 | Undocumented 2 | :: 54 | 1796 38th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984434.1354 | 2102998.0252 | 37.7535313177823 | -122.49677082792499 | (37.7535313177823, -122.496770827925) | |||
| 33830 | 33830 | 244279 | Undocumented 2 | :: 54 | 585 Oak St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004230.7823 | 2110095.8419999997 | 37.7741602789386 | -122.42881569121799 | (37.7741602789386, -122.428815691218) | |||
| 33871 | 33871 | 183766 | Undocumented 2 | :: 54 | 2282 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986098.8983 | 2099716.8964 | 37.744619629849794 | -122.49077238951 | (37.7446196298498, -122.49077238951) | |||
| 33938 | 33938 | 182209 | Undocumented 2 | :: 54 | 1590 34th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985630.9934 | 2104420.723 | 37.75750770910879 | -122.492736670044 | (37.7575077091088, -122.492736670044) | |||
| 33983 | 33983 | 142497 | Undocumented 2 | :: 54 | 555 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6009877.0468 | 2119393.2664 | 37.8000067321588 | -122.40994064461901 | (37.8000067321588, -122.409940644619) | |||
| 34038 | 34038 | 140392 | Undocumented 2 | :: 54 | 1460 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002728.4059 | 2113323.2276 | 37.782936725289204 | -122.434243446651 | (37.7829367252892, -122.434243446651) | |||
| 34204 | 34204 | 183601 | Undocumented 2 | :: 54 | 2647 22nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989550.5846 | 2097326.397 | 37.7382569723881 | -122.47866248497401 | (37.7382569723881, -122.478662484974) | |||
| 34425 | 34425 | 184635 | Undocumented 2 | :: 54 | 1646 42nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983160.6342 | 2103926.3557 | 37.7560055530367 | -122.50124346024299 | (37.7560055530367, -122.501243460243) | |||
| 34444 | 34444 | 139926 | Undocumented 2 | :: 54 | 1001 TURK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005215.378 | 2112666.1069 | 37.78127327564229 | -122.425592763682 | (37.7812732756423, -122.425592763682) | |||
| 34454 | 34454 | 182862 | Undocumented 2 | :: 54 | 1832 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987236.1292 | 2102771.2926 | 37.7530725498124 | -122.487064401227 | (37.7530725498124, -122.487064401227) | |||
| 34474 | 34474 | 183741 | Undocumented 2 | :: 54 | 2274 31st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986719.376 | 2099760.8505 | 37.74477654290771 | -122.48863015911199 | (37.7447765429077, -122.488630159112) | |||
| 34580 | 34580 | 184144 | Undocumented 2 | :: 54 | 1651 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985908.7501 | 2103985.2837 | 37.7563283503706 | -122.49174403472799 | (37.7563283503706, -122.491744034728) | |||
| 34634 | 34634 | 183835 | Undocumented 2 | :: 54 | 2210 32nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5986395.4815 | 2100173.9333 | 37.7458918514691 | -122.489780482903 | (37.7458918514691, -122.489780482903) | |||
| 34729 | 34729 | 182011 | Undocumented 2 | :: 54 | 2483 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985479.3511 | 2098339.1415 | 37.7408004743688 | -122.49281317123501 | (37.7408004743688, -122.492813171235) | |||
| 34742 | 34742 | 183206 | Undocumented 2 | :: 54 | 2486 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981807.3053 | 2098184.1443 | 37.7401594813682 | -122.50549802177 | (37.7401594813682, -122.50549802177) | |||
| 34796 | 34796 | 138319 | Undocumented 2 | :: 54 | 1915 PIERCE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001944.4165 | 2115111.5373 | 37.7878024384193 | -122.437083797069 | (37.7878024384193, -122.437083797069) | |||
| 34821 | 34821 | 184604 | Undocumented 2 | :: 54 | 1771 38th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984386.4179 | 2103133.394 | 37.753900207001294 | -122.496945833428 | (37.7539002070013, -122.496945833428) | |||
| 34873 | 34873 | 184590 | Undocumented 2 | :: 54 | 1727 43rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982826.6318 | 2103356.0755 | 37.7544201042603 | -122.502356328834 | (37.7544201042603, -122.502356328834) | |||
| 34953 | 34953 | 184142 | Undocumented 2 | :: 54 | 1642 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985022.0549 | 2104003.3385 | 37.7563260608013 | -122.494811820237 | (37.7563260608013, -122.494811820237) | |||
| 35054 | 35054 | 183614 | Undocumented 2 | :: 54 | 1675 27th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987775.1316 | 2103912.4276 | 37.756237211758105 | -122.48528417545201 | (37.7562372117581, -122.485284175452) | |||
| 35073 | 35073 | 183948 | Undocumented 2 | :: 54 | 2142 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5989477.2684 | 2100748.2781 | 37.7476483084144 | -122.479166217201 | (37.7476483084144, -122.479166217201) | |||
| 35127 | 35127 | 185838 | Undocumented 2 | :: 54 | 2000 35th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985430.142000001 | 2101125.3499 | 37.7484477718341 | -122.493188522588 | (37.7484477718341, -122.493188522588) | |||
| 35204 | 35204 | 181568 | Undocumented 2 | :: 54 | 1349 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5984597.8609 | 2105995.9427 | 37.7617723563961 | -122.496425834494 | (37.7617723563961, -122.496425834494) | |||
| 35329 | 35329 | 182648 | Undocumented 2 | :: 54 | 2100 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987488.2882 | 2102382.8225 | 37.752020615345 | -122.486163882157 | (37.752020615345, -122.486163882157) | |||
| 35383 | 35383 | 182496 | Undocumented 2 | :: 54 | 1567 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985890.2792 | 2104567.4262 | 37.7579256738328 | -122.491850768207 | (37.7579256738328, -122.491850768207) | |||
| 35618 | 35618 | 182710 | Undocumented 2 | :: 54 | 1707 23rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989018.9578 | 2103687.0641 | 37.755690805560896 | -122.48096614821199 | (37.7556908055609, -122.480966148212) | |||
| 35754 | 35754 | 182933 | Undocumented 2 | :: 54 | 2646 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981845.0394 | 2097064.8142 | 37.7370883295038 | -122.505284615423 | (37.7370883295038, -122.505284615423) | |||
| 35894 | 35894 | 183324 | Undocumented 2 | :: 54 | 3945 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983417.0741 | 2106949.5512 | 37.7643214505987 | -122.50058015311001 | (37.7643214505987, -122.50058015311) | |||
| 35957 | 35957 | 183110 | Undocumented 2 | :: 54 | 3474 Santiago St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982112.0542 | 2099478.6077 | 37.7437316497768 | -122.504540222201 | (37.7437316497768, -122.504540222201) | |||
| 36129 | 36129 | 184472 | Undocumented 2 | :: 54 | 2191 44th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982622.5635 | 2100219.2438 | 37.7457952471339 | -122.50282984708001 | (37.7457952471339, -122.50282984708) | |||
| 36154 | 36154 | 184467 | Undocumented 2 | :: 54 | 2182 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981733.5294 | 2100249.3634 | 37.7458256579494 | -122.50590617914699 | (37.7458256579494, -122.505906179147) | |||
| 36197 | 36197 | 185614 | Undocumented 2 | :: 54 | 2130 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5986064.8446 | 2100725.7169 | 37.747387589615705 | -122.49096436045001 | (37.7473875896157, -122.49096436045) | |||
| 36394 | 36394 | 184614 | DPW Maintained 3 | :: 54 | 3600x Noriega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 0ft | 5982812.7565 | 2102876.5318 | 37.7531025964328 | -122.502368824356 | (37.7531025964328, -122.502368824356) | |||
| 36416 | 36416 | 183338 | Undocumented 2 | :: 54 | 1200 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5980889.0479 | 2106803.3028 | 37.7637711641625 | -122.50931286551399 | (37.7637711641625, -122.509312865514) | |||
| 36422 | 36422 | 181608 | Undocumented 2 | :: 54 | 1251 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5986743.9567 | 2106741.3672 | 37.763944576281794 | -122.489058249622 | (37.7639445762818, -122.489058249622) | |||
| 36431 | 36431 | 137758 | Undocumented 2 | :: 54 | 101 Saint Joseph's Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000707.9938 | 2112291.934 | 37.7799901751967 | -122.44115920153799 | (37.7799901751967, -122.441159201538) | |||
| 36535 | 36535 | 139766 | Undocumented 2 | :: 54 | 1308 Laguna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004662.1567 | 2113418.8231 | 37.7833087728144 | -122.427560280444 | (37.7833087728144, -122.427560280444) | |||
| 36590 | 36590 | 182200 | Undocumented 2 | :: 54 | 1591 32nd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986205.3811 | 2104418.9832 | 37.757536502339704 | -122.490750106029 | (37.7575365023397, -122.490750106029) | |||
| 36620 | 36620 | 184152 | Undocumented 2 | :: 54 | 1585 44th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982483.9557 | 2104316.7349 | 37.7570376635662 | -122.503612507973 | (37.7570376635662, -122.503612507973) | |||
| 36634 | 36634 | 247287 | Undocumented 2 | :: 54 | 640 Stanyan St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5997019.8905 | 2108844.4958 | 37.770313639572 | -122.453668930321 | (37.770313639572, -122.453668930321) | |||
| 36680 | 36680 | 200762 | Undocumented 2 | :: 54 | 1999 Lane St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 6014632.1803 | 2093750.8421 | 37.7298635995705 | -122.39169207228201 | (37.7298635995705, -122.391692072282) | |||
| 36780 | 36780 | 143122 | Undocumented 2 | :: 54 | 1965 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003008.0203 | 2119542.9474 | 37.8000303489096 | -122.433720773421 | (37.8000303489096, -122.433720773421) | |||
| 36846 | 36846 | 183277 | Undocumented 2 | :: 54 | 1255 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981785.9112 | 2106543.1909 | 37.7631098104891 | -122.506191655726 | (37.7631098104891, -122.506191655726) | |||
| 36850 | 36850 | 141882 | Undocumented 2 | :: 54 | 1160 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003839.6945 | 2112655.4467 | 37.7811661774464 | -122.430351190021 | (37.7811661774464, -122.430351190021) | |||
| 36871 | 36871 | 141519 | Undocumented 2 | :: 54 | 200 STANYAN ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5996701.0904 | 2111096.9463 | 37.7764800010927 | -122.454934429435 | (37.7764800010927, -122.454934429435) | |||
| 36898 | 36898 | 182668 | Undocumented 2 | :: 54 | 2860 Ortega St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985110.0164 | 2102301.626 | 37.751658775563506 | -122.49438218913001 | (37.7516587755635, -122.49438218913) | |||
| 36994 | 36994 | 139027 | Undocumented 2 | :: 54 | 2501 SUTTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000525.7297 | 2114092.4384 | 37.784923514385 | -122.441918999732 | (37.784923514385, -122.441918999732) | |||
| 36998 | 36998 | 184372 | Undocumented 2 | :: 54 | 2263 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981709.435 | 2099687.8805 | 37.7442825640676 | -122.50594787141 | (37.7442825640676, -122.50594787141) | |||
| 37163 | 37163 | 140497 | Undocumented 2 | :: 54 | 1390 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002947.4227 | 2112049.4711 | 37.7794517381965 | -122.433394688734 | (37.7794517381965, -122.433394688734) | |||
| 37225 | 37225 | 182352 | Undocumented 2 | :: 54 | 3131 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985102.3355 | 2104969.5539 | 37.7589837192753 | -122.49460541441401 | (37.7589837192753, -122.494605414414) | |||
| 37240 | 37240 | 182497 | Undocumented 2 | :: 54 | 1567 33rd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985891.0491 | 2104555.5597 | 37.7578931366951 | -122.491847232012 | (37.7578931366951, -122.491847232012) | |||
| 37254 | 37254 | 140262 | Undocumented 2 | :: 54 | 70 Cole St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5997786.9682 | 2110316.587 | 37.7743995682404 | -122.451121798449 | (37.7743995682404, -122.451121798449) | |||
| 37419 | 37419 | 141003 | Undocumented 2 | :: 54 | 166 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5996581.6168 | 2113251.3598 | 37.7823885984174 | -122.45550347026399 | (37.7823885984174, -122.455503470264) | |||
| 37520 | 37520 | 182712 | Undocumented 2 | :: 54 | 1719 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985923.1814 | 2103513.3913 | 37.7550335068364 | -122.49165939101002 | (37.7550335068364, -122.49165939101) | |||
| 37539 | 37539 | 184416 | Undocumented 2 | :: 54 | 3535 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982452.1681 | 2100793.038 | 37.7473607109551 | -122.50346152129801 | (37.7473607109551, -122.503461521298) | |||
| 37581 | 37581 | 200170 | Undocumented 2 | :: 54 | 1001 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014099.661 | 2089867.5171 | 37.71917119290661 | -122.393261433304 | (37.7191711929066, -122.393261433304) | |||
| 37651 | 37651 | 184147 | Undocumented 2 | :: 54 | 1591 37th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984655.1204 | 2104363.1652 | 37.757292559487 | -122.496107333876 | (37.757292559487, -122.496107333876) | |||
| 37652 | 37652 | 141525 | Undocumented 2 | :: 54 | 200 STANYAN ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5996673.9338 | 2111292.1171 | 37.7770143310958 | -122.455042477562 | (37.7770143310958, -122.455042477562) | |||
| 37734 | 37734 | 137587 | Undocumented 2 | :: 54 | 1150 PIERCE ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002352.8955 | 2112542.7356 | 37.78077237103221 | -122.435486703411 | (37.7807723710322, -122.435486703411) | |||
| 37787 | 37787 | 184683 | Undocumented 2 | :: 54 | 3343 Lawton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983825.9671 | 2104243.1006 | 37.7569142945607 | -122.498965955362 | (37.7569142945607, -122.498965955362) | |||
| 37937 | 37937 | 182392 | Undocumented 2 | :: 54 | 1542 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985927.969 | 2104719.9248 | 37.7583465957731 | -122.491731648895 | (37.7583465957731, -122.491731648895) | |||
| 37938 | 37938 | 181831 | Undocumented 2 | :: 54 | 2312 32nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986419.3177 | 2099473.0237 | 37.743968733475704 | -122.489646527203 | (37.7439687334757, -122.489646527203) | |||
| 38023 | 38023 | 183701 | Undocumented 2 | :: 54 | 1349 37th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5984598.3295 | 2105986.1027 | 37.7617453659671 | -122.49642348771098 | (37.7617453659671, -122.496423487711) | |||
| 38295 | 38295 | 182332 | Undocumented 2 | :: 54 | 1494 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985606.7756 | 2105058.9207 | 37.759258607335795 | -122.49286743066601 | (37.7592586073358, -122.492867430666) | |||
| 38433 | 38433 | 181714 | Undocumented 2 | :: 54 | 1215 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987051.5149 | 2106949.2334 | 37.764533265698 | -122.488009786224 | (37.764533265698, -122.488009786224) | |||
| 38604 | 38604 | 139030 | Undocumented 2 | :: 54 | 1535 Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000620.3764 | 2114029.1087 | 37.784755020167395 | -122.441587007239 | (37.7847550201674, -122.441587007239) | |||
| 38706 | 38706 | 182449 | Undocumented 2 | :: 54 | 1566 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988104.5754 | 2104637.7922 | 37.7582480531421 | -122.48419805393999 | (37.7582480531421, -122.48419805394) | |||
| 38788 | 38788 | 183753 | Undocumented 2 | :: 54 | 2275 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985433.613 | 2099748.0483 | 37.744666278187296 | -122.49307507571501 | (37.7446662781873, -122.493075075715) | |||
| 38904 | 38904 | 182360 | Undocumented 2 | :: 54 | 1507 33rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985877.3228 | 2104935.7779 | 37.7589363086434 | -122.491922694782 | (37.7589363086434, -122.491922694782) | |||
| 39009 | 39009 | 183902 | Undocumented 2 | :: 54 | 2101 22nd Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5989433.6077 | 2100684.129 | 37.7474696361105 | -122.479312499521 | (37.7474696361105, -122.479312499521) | |||
| 39023 | 39023 | 184457 | Undocumented 2 | :: 54 | 2151 45th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982303.7701 | 2100458.8464 | 37.746434388466 | -122.503949913871 | (37.746434388466, -122.503949913871) | |||
| 39107 | 39107 | 139604 | Undocumented 2 | :: 54 | 1173 SCOTT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001838.238 | 2112425.6952 | 37.7804217645564 | -122.437258767268 | (37.7804217645564, -122.437258767268) | |||
| 39214 | 39214 | 184146 | Undocumented 2 | :: 54 | 1583 41st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983412.2604 | 2104390.9064 | 37.757295852249 | -122.500407612857 | (37.757295852249, -122.500407612857) | |||
| 39314 | 39314 | 140416 | Undocumented 2 | :: 54 | 1360 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003047.9047 | 2112063.8256 | 37.7794968522113 | -122.433048105114 | (37.7794968522113, -122.433048105114) | |||
| 39404 | 39404 | 181754 | Undocumented 2 | :: 54 | 1240 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987099.9397 | 2106850.6122 | 37.7642653039062 | -122.487835053811 | (37.7642653039062, -122.487835053811) | |||
| 39413 | 39413 | 182439 | Undocumented 2 | :: 54 | 1524 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984994.4728 | 2104793.4765 | 37.758493945986 | -122.494965465844 | (37.758493945986, -122.494965465844) | |||
| 39530 | 39530 | 184555 | Undocumented 2 | :: 54 | 3601 Moraga St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983107.8094 | 2103539.071 | 37.754939075681705 | -122.50139749571501 | (37.7549390756817, -122.501397495715) | |||
| 39591 | 39591 | 181680 | Undocumented 2 | :: 54 | 1290 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985868.4858 | 2106459.7761 | 37.7631202685599 | -122.492065465074 | (37.7631202685599, -122.492065465074) | |||
| 39726 | 39726 | 182241 | Undocumented 2 | :: 54 | 1438 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987144.2667 | 2105475.1293 | 37.7604911919338 | -122.48758068859199 | (37.7604911919338, -122.487580688592) | |||
| 39749 | 39749 | 139753 | Undocumented 2 | :: 54 | 1171 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005547.6328 | 2113641.325 | 37.7839697525349 | -122.424512713511 | (37.7839697525349, -122.424512713511) | |||
| 39779 | 39779 | 183215 | Undocumented 2 | :: 54 | 3318 Rivera St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982838.8142 | 2100183.1408 | 37.7457088250993 | -122.50207942434601 | (37.7457088250993, -122.502079424346) | |||
| 39782 | 39782 | 184722 | Undocumented 2 | :: 54 | 1643 37th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984666.6891 | 2104002.5093 | 37.7563029761962 | -122.49604071877899 | (37.7563029761962, -122.496040718779) | |||
| 39813 | 39813 | 200248 | Undocumented 2 | :: 54 | 1107 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014274.7183 | 2090092.8783 | 37.719799714154504 | -122.392672078819 | (37.7197997141545, -122.392672078819) | |||
| 39826 | 39826 | 183322 | Undocumented 2 | :: 54 | 3927 Lincoln Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983510.9139 | 2106953.643 | 37.764338193887504 | -122.50025589533001 | (37.7643381938875, -122.50025589533) | |||
| 39829 | 39829 | 183315 | Undocumented 2 | :: 54 | 4540 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981596.8931 | 2106261.3364 | 37.7623247898963 | -122.506824486966 | (37.7623247898963, -122.506824486966) | |||
| 39868 | 39868 | 142767 | Undocumented 2 | :: 54 | 724 LARKIN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6007520.0381 | 2113832.9802 | 37.7846071803113 | -122.41770248523599 | (37.7846071803113, -122.417702485236) | |||
| 39908 | 39908 | 183623 | Undocumented 2 | :: 54 | 1443 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983380.9044 | 2105304.9531 | 37.7598037265775 | -122.50058363770201 | (37.7598037265775, -122.500583637702) | |||
| 39959 | 39959 | 141131 | Undocumented 2 | :: 54 | 1760 Ellis St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002332.7569 | 2113004.3119 | 37.7820385992621 | -122.435589403585 | (37.7820385992621, -122.435589403585) | |||
| 39979 | 39979 | 185836 | Undocumented 2 | :: 54 | 2000 35th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985432.8989 | 2101036.5759 | 37.748204183826395 | -122.4931724505 | (37.7482041838264, -122.4931724505) | |||
| 40047 | 40047 | 182426 | Undocumented 2 | :: 54 | 1527 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985880.4219 | 2104826.6158 | 37.758636760808294 | -122.49190394010901 | (37.7586367608083, -122.491903940109) | |||
| 40078 | 40078 | 182086 | Undocumented 2 | :: 54 | 2425 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988468.6309 | 2098276.195 | 37.7408019901024 | -122.482472876934 | (37.7408019901024, -122.482472876934) | |||
| 40140 | 40140 | 182694 | Undocumented 2 | :: 54 | 1715 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985923.1814 | 2103540.9984 | 37.7551093083613 | -122.491661423134 | (37.7551093083613, -122.491661423134) | |||
| 40189 | 40189 | 183398 | Undocumented 2 | :: 54 | 2676 23rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989291.1458 | 2097146.7716 | 37.7377487006662 | -122.479546347444 | (37.7377487006662, -122.479546347444) | |||
| 40193 | 40193 | 183285 | Undocumented 2 | :: 54 | 1266 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983382.4298 | 2106528.4997 | 37.763163328933295 | -122.50066883897 | (37.7631633289333, -122.50066883897) | |||
| 40307 | 40307 | 184619 | DPW Maintained 3 | :: 54 | 3000x Noriega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 0ft | 5984675.7685 | 2102938.8014 | 37.7533828605842 | -122.495930852185 | (37.7533828605842, -122.495930852185) | |||
| 40638 | 40638 | 141425 | Undocumented 2 | :: 54 | 301 LINDEN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005907.6073 | 2110863.9151 | 37.7763639855674 | -122.42306985316401 | (37.7763639855674, -122.423069853164) | |||
| 40717 | 40717 | 184162 | Undocumented 2 | :: 54 | 3542 Lawton St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983197.136 | 2104275.0936 | 37.7569652328272 | -122.501143019632 | (37.7569652328272, -122.501143019632) |
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");