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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 31430 | 31430 | 141865 | Undocumented 2 | :: 54 | 1198 TURK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004361.706 | 2112589.3295 | 37.7810141909048 | -122.42854057505699 | (37.7810141909048, -122.428540575057) | |||
| 31682 | 31682 | 181805 | Undocumented 2 | :: 54 | 1923 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5986623.386 | 2099578.2729 | 37.7442696318144 | -122.488948650625 | (37.7442696318144, -122.488948650625) | |||
| 31775 | 31775 | 141105 | Undocumented 2 | :: 54 | 220 Parker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5997021.7343 | 2112807.858 | 37.781196104366 | -122.45394882631399 | (37.781196104366, -122.453948826314) | |||
| 32195 | 32195 | 248555 | Undocumented 2 | :: 54 | 129 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5997396.7751 | 2107759.6103 | 37.767356421121995 | -122.452286999337 | (37.767356421122, -122.452286999337) | |||
| 32221 | 32221 | 248518 | Undocumented 2 | :: 54 | 214 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5998913.7974 | 2107668.6102 | 37.767193347530295 | -122.447033302678 | (37.7671933475303, -122.447033302678) | |||
| 32422 | 32422 | 183951 | Undocumented 2 | :: 54 | 2146 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5989786.9025 | 2100751.8318 | 37.7476760434998 | -122.478095791651 | (37.7476760434998, -122.478095791651) | |||
| 32792 | 32792 | 181569 | Undocumented 2 | :: 54 | 1349 37th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5984599.7352 | 2105972.9827 | 37.7617094244752 | -122.496417657892 | (37.7617094244752, -122.496417657892) | |||
| 32899 | 32899 | 183517 | Undocumented 2 | :: 54 | 2558 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987405.7216 | 2097878.3252 | 37.739647654239604 | -122.486118771525 | (37.7396476542396, -122.486118771525) | |||
| 32925 | 32925 | 200975 | Undocumented 2 | :: 54 | 1275 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6009315.029 | 2109918.3974 | 37.7739595082871 | -122.411215775633 | (37.7739595082871, -122.411215775633) | |||
| 33364 | 33364 | 143238 | Undocumented 2 | :: 54 | 1734 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004092.1528 | 2119775.7189 | 37.8007309359716 | -122.429985874998 | (37.8007309359716, -122.429985874998) | |||
| 33464 | 33464 | 200884 | Undocumented 2 | :: 54 | 1200 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6012817.0471 | 2107089.1245 | 37.7663867409086 | -122.39890301603998 | (37.7663867409086, -122.39890301604) | |||
| 33492 | 33492 | 185808 | Undocumented 2 | :: 54 | 1655 21st Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5989755.3501 | 2101698.7532 | 37.7502742090567 | -122.478274123288 | (37.7502742090567, -122.478274123288) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 40775 | 40775 | 138003 | Undocumented 2 | :: 54 | 1670 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004492.797 | 2114606.7181 | 37.7865608551259 | -122.428230885205 | (37.7865608551259, -122.428230885205) | |||
| 41028 | 41028 | 181794 | Undocumented 2 | :: 54 | 2306 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5988278.2686 | 2099574.5503 | 37.7443558562014 | -122.483226217668 | (37.7443558562014, -122.483226217668) | |||
| 41104 | 41104 | 140367 | Undocumented 2 | :: 54 | 690 WILLOW ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004237.6574 | 2113081.116 | 37.782357493618605 | -122.429004794114 | (37.7823574936186, -122.429004794114) | |||
| 41266 | 41266 | 140561 | Undocumented 2 | :: 54 | 50 FRIENDSHIP CT | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003695.7169 | 2111697.8997 | 37.7785288350927 | -122.43078092716401 | (37.7785288350927, -122.430780927164) | |||
| 41622 | 41622 | 183384 | Undocumented 2 | :: 54 | 2659 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5989243.3159 | 2097242.4314 | 37.7380085792734 | -122.479718714161 | (37.7380085792734, -122.479718714161) | |||
| 41665 | 41665 | 184892 | Undocumented 2 | :: 54 | 1788 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981953.7924 | 2102910.6002 | 37.753145631025 | -122.505341765185 | (37.753145631025, -122.505341765185) | |||
| 41875 | 41875 | 142271 | Undocumented 2 | :: 54 | 556 FELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004757.9319 | 2110570.0874 | 37.775492263035204 | -122.427025971185 | (37.7754922630352, -122.427025971185) | |||
| 41978 | 41978 | 184524 | Undocumented 2 | :: 54 | 1984 Lower Great Hwy | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981181.0558 | 2101584.0989 | 37.7494579320564 | -122.50791555821199 | (37.7494579320564, -122.507915558212) | |||
| 42074 | 42074 | 182122 | Undocumented 2 | :: 54 | 2532 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5988111.9343 | 2098322.8972 | 37.7409094653527 | -122.48370960803801 | (37.7409094653527, -122.483709608038) | |||
| 42482 | 42482 | 143383 | Undocumented 2 | :: 54 | 1630 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004501.2884 | 2119830.7279 | 37.8009051385339 | -122.42857401927601 | (37.8009051385339, -122.428574019276) | |||
| 42563 | 42563 | 139441 | Undocumented 2 | :: 54 | 501 GROVE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005361.8674 | 2111299.9206 | 37.7775303390293 | -122.424988750303 | (37.7775303390293, -122.424988750303) | |||
| 42883 | 42883 | 185830 | Undocumented 2 | :: 54 | 2071 34th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985698.118 | 2101152.3680000002 | 37.7485376258716 | -122.49226386921801 | (37.7485376258716, -122.492263869218) | |||
| 43147 | 43147 | 138988 | Undocumented 2 | :: 54 | 661 FILLMORE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003478.1301 | 2110687.6732 | 37.775742673405205 | -122.43146150530701 | (37.7757426734052, -122.431461505307) | |||
| 43206 | 43206 | 182874 | Undocumented 2 | :: 54 | 1691 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5988087.7378 | 2103811.4271 | 37.7559780978236 | -122.484195682649 | (37.7559780978236, -122.484195682649) | |||
| 43479 | 43479 | 122819 | Undocumented 2 | :: 54 | 121 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003309.0 | 2094407.0 | 37.7310302083694 | -122.430884409483 | (37.7310302083694, -122.430884409483) | ||||
| 43643 | 43643 | 182507 | Undocumented 2 | :: 54 | 1571 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985891.7354 | 2104539.7745 | 37.757849835001004 | -122.49184369645201 | (37.757849835001, -122.491843696452) | |||
| 43692 | 43692 | 184528 | Undocumented 2 | :: 54 | 1961 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981337.7451 | 2101542.4731 | 37.7493528701871 | -122.507370643946 | (37.7493528701871, -122.507370643946) | |||
| 43892 | 43892 | 184132 | Undocumented 2 | :: 54 | 1651 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5986834.8986 | 2104030.0865 | 37.756505452138704 | -122.488544427358 | (37.7565054521387, -122.488544427358) | |||
| 44496 | 44496 | 183722 | Undocumented 2 | :: 54 | 2251 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985428.0654 | 2099898.2603 | 37.74507839527 | -122.49310532134199 | (37.74507839527, -122.493105321342) | |||
| 44559 | 44559 | 141411 | Undocumented 2 | :: 54 | 530 IVY ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004748.0909 | 2111070.6139 | 37.776866029844996 | -122.42709567230601 | (37.776866029845, -122.427095672306) | |||
| 44907 | 44907 | 182397 | Undocumented 2 | :: 54 | 1522 33rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985924.4899 | 2104853.8684 | 37.7587141646 | -122.49175354130301 | (37.7587141646, -122.491753541303) | |||
| 44970 | 44970 | 141012 | Undocumented 2 | :: 54 | 324 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5998073.7185 | 2112632.3863 | 37.7807745654768 | -122.450296846648 | (37.7807745654768, -122.450296846648) | |||
| 45274 | 45274 | 246179 | Undocumented 2 | :: 54 | 1588 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5997977.1471 | 2108227.9355 | 37.768675553750796 | -122.45031334601101 | (37.7686755537508, -122.450313346011) | |||
| 45638 | 45638 | 183321 | Undocumented 2 | :: 54 | 3927 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983491.8186 | 2106952.5519 | 37.7643340772207 | -122.50032185889098 | (37.7643340772207, -122.500321858891) | |||
| 45872 | 45872 | 141030 | Undocumented 2 | :: 54 | 88 Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5998905.3901 | 2112810.7346 | 37.781311824276294 | -122.44743254381099 | (37.7813118242763, -122.447432543811) | |||
| 45921 | 45921 | 184684 | Undocumented 2 | :: 54 | 3341 Lawton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983838.0977 | 2104243.1006 | 37.7569150061 | -122.498924003867 | (37.7569150061, -122.498924003867) | |||
| 46023 | 46023 | 183740 | Undocumented 2 | :: 54 | 2280 31st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5986718.9493 | 2099755.7296 | 37.7447624573869 | -122.48863125822099 | (37.7447624573869, -122.488631258221) | |||
| 46068 | 46068 | 185607 | Undocumented 2 | :: 54 | 2107 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987565.6996 | 2100931.4097 | 37.74803993654071 | -122.485789668172 | (37.7480399365407, -122.485789668172) | |||
| 46079 | 46079 | 181712 | Undocumented 2 | :: 54 | 3401 Lincoln Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985144.052 | 2107009.2181 | 37.764586509150895 | -122.494611508714 | (37.7645865091509, -122.494611508714) | |||
| 46209 | 46209 | 183847 | Undocumented 2 | :: 54 | 2227 27th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987904.6422 | 2100116.537 | 37.7458222575023 | -122.484557870143 | (37.7458222575023, -122.484557870143) | |||
| 46223 | 46223 | 181942 | Undocumented 2 | :: 54 | 2398 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985816.5038 | 2098939.4172 | 37.7424683803993 | -122.49169161796499 | (37.7424683803993, -122.491691617965) | |||
| 46286 | 46286 | 138648 | Undocumented 2 | :: 54 | 600 PRESIDIO AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999215.949 | 2114570.5132 | 37.786161460452796 | -122.446484808381 | (37.7861614604528, -122.446484808381) | |||
| 46367 | 46367 | 181877 | Undocumented 2 | :: 54 | 2339 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5986687.1785 | 2099348.3153 | 37.7436419526434 | -122.48871117340201 | (37.7436419526434, -122.488711173402) | |||
| 46390 | 46390 | 183950 | Undocumented 2 | :: 54 | 2142 22nd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5989476.9277 | 2100771.7916 | 37.7477128505139 | -122.47916911508301 | (37.7477128505139, -122.479169115083) | |||
| 46565 | 46565 | 185847 | Undocumented 2 | :: 54 | 2011 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985684.8846 | 2101427.5121 | 37.749292323144495 | -122.492329887495 | (37.7492923231445, -122.492329887495) | |||
| 46705 | 46705 | 244976 | Undocumented 2 | :: 54 | 201 Rose St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005594.1388 | 2109777.4773 | 37.773363196496895 | -122.42407694938998 | (37.7733631964969, -122.42407694939) | |||
| 46723 | 46723 | 184209 | Undocumented 2 | :: 54 | 1479 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5984009.7312 | 2105100.4163 | 37.7592790208895 | -122.498393761049 | (37.7592790208895, -122.498393761049) | |||
| 46800 | 46800 | 141745 | Undocumented 2 | :: 54 | 1595 GEARY BLVD | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004047.2174 | 2113886.8031 | 37.7845589275233 | -122.429721115021 | (37.7845589275233, -122.429721115021) |
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");