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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30182 | 30182 | 184584 | Undocumented 2 | :: 54 | 1750 38th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984424.998 | 2103256.5795 | 37.7542407008981 | -122.496821507327 | (37.7542407008981, -122.496821507327) | |||
30188 | 30188 | 182737 | Undocumented 2 | :: 54 | 1751 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985623.647000001 | 2103292.6533 | 37.7544099107452 | -122.492678995508 | (37.7544099107452, -122.492678995508) | |||
30792 | 30792 | 200164 | Undocumented 2 | :: 54 | 1027 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014014.4798 | 2089939.2839 | 37.7193635176037 | -122.393560894555 | (37.7193635176037, -122.393560894555) | |||
30846 | 30846 | 182211 | Undocumented 2 | :: 54 | 1591 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985585.3014 | 2104403.0433 | 37.75745649361671 | -122.49289338685 | (37.7574564936167, -122.49289338685) | |||
30889 | 30889 | 245370 | Undocumented 2 | :: 54 | 3943 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005173.0525 | 2095986.3930000002 | 37.7354723102432 | -122.42455236124201 | (37.7354723102432, -122.424552361242) | |||
30926 | 30926 | 245835 | Undocumented 2 | :: 54 | 451 Fell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005269.6444 | 2110584.5711 | 37.7755609539167 | -122.42525686469999 | (37.7755609539167, -122.4252568647) | |||
30940 | 30940 | 185841 | Undocumented 2 | :: 54 | 2000 35th Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985424.0767 | 2101308.9631 | 37.748951568943205 | -122.493223020907 | (37.7489515689432, -122.493223020907) | |||
31028 | 31028 | 139809 | Undocumented 2 | :: 54 | 1101 GOUGH ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005660.0139 | 2112868.3262 | 37.7818536339515 | -122.424068925498 | (37.7818536339515, -122.424068925498) | |||
31070 | 31070 | 138278 | Undocumented 2 | :: 54 | 2181 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001737.3169 | 2113910.2795 | 37.784492318138106 | -122.437714255164 | (37.7844923181381, -122.437714255164) | |||
31109 | 31109 | 184715 | Undocumented 2 | :: 54 | 1631 37th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984663.3195 | 2104077.315 | 37.7565081745164 | -122.496057890447 | (37.7565081745164, -122.496057890447) | |||
31121 | 31121 | 185816 | Undocumented 2 | :: 54 | 2519 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987136.8132 | 2101635.9994 | 37.7499495497007 | -122.487324467521 | (37.7499495497007, -122.487324467521) | |||
31182 | 31182 | 183814 | Undocumented 2 | :: 54 | 2125 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5986527.3437 | 2100252.4532 | 37.7461151442862 | -122.489330300147 | (37.7461151442862, -122.489330300147) | |||
31188 | 31188 | 181929 | Undocumented 2 | :: 54 | 2427 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985466.1527 | 2098683.3165 | 37.7417447146597 | -122.492884150676 | (37.7417447146597, -122.492884150676) | |||
31203 | 31203 | 182476 | Undocumented 2 | :: 54 | 1559 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985886.8002 | 2104622.5113 | 37.7580767189836 | -122.491866855206 | (37.7580767189836, -122.491866855206) | |||
31222 | 31222 | 182419 | Undocumented 2 | :: 54 | 1548 35th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985308.8008 | 2104684.9478 | 37.7582143519431 | -122.493870396795 | (37.7582143519431, -122.493870396795) | |||
31225 | 31225 | 184643 | Undocumented 2 | :: 54 | 3324 Moraga St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983935.3115 | 2103621.2359 | 37.7552132408568 | -122.49854187345801 | (37.7552132408568, -122.498541873458) | |||
31404 | 31404 | 181902 | Undocumented 2 | :: 54 | 2370 31st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986740.6492 | 2099140.1859 | 37.7430736050662 | -122.488510993633 | (37.7430736050662, -122.488510993633) | |||
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) | |||
31766 | 31766 | 184717 | Undocumented 2 | :: 54 | 1630 39th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984088.6295 | 2104052.5482 | 37.756406494372705 | -122.498043512944 | (37.7564064943727, -122.498043512944) | |||
31770 | 31770 | 183463 | Undocumented 2 | :: 54 | 2530 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988329.4378 | 2098069.925 | 37.740227528416796 | -122.482939034698 | (37.7402275284168, -122.482939034698) | |||
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) | |||
31862 | 31862 | 183821 | Undocumented 2 | :: 54 | 2226 32nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986398.8954 | 2100073.2231 | 37.745615527653996 | -122.48976127310301 | (37.745615527654, -122.489761273103) | |||
32086 | 32086 | 182494 | Undocumented 2 | :: 54 | 1589 20th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989920.8647 | 2104571.2003 | 37.758170793630704 | -122.47791173356899 | (37.7581707936307, -122.477911733569) | |||
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) | |||
32307 | 32307 | 181866 | Undocumented 2 | :: 54 | 2333 27th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987926.6484 | 2099416.8457 | 37.7439023721205 | -122.484430466696 | (37.7439023721205, -122.484430466696) | |||
32319 | 32319 | 138821 | Undocumented 2 | :: 54 | 745 BUCHANAN ST | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 6004449.5065 | 2111116.3546 | 37.776974733592205 | -122.428131826933 | (37.7769747335922, -122.428131826933) | |||
32375 | 32375 | 183437 | Undocumented 2 | :: 54 | 2509 24th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988899.1764 | 2098219.7887 | 37.7406721500335 | -122.480980100642 | (37.7406721500335, -122.480980100642) | |||
32403 | 32403 | 182450 | Undocumented 2 | :: 54 | 1566 26th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988103.6039 | 2104651.3921 | 37.75828533821571 | -122.484202411136 | (37.7582853382157, -122.484202411136) | |||
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) | |||
32428 | 32428 | 182575 | Undocumented 2 | :: 54 | 2444 23rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989239.9887 | 2098703.075 | 37.742018933713105 | -122.479837071242 | (37.7420189337131, -122.479837071242) | |||
32483 | 32483 | 182444 | Undocumented 2 | :: 54 | 1530 34th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985615.2362 | 2104790.3432 | 37.758521662620296 | -122.49281838798099 | (37.7585216626203, -122.492818387981) | |||
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) | |||
33065 | 33065 | 185060 | DPW Maintained 3 | :: 54 | 10x El Mirasol Pl | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 0ft | 5987413.8008 | 2096060.1353 | 37.7346558528299 | -122.485957413668 | (37.7346558528299, -122.485957413668) | |||
33122 | 33122 | 185071 | Undocumented 2 | :: 54 | 2800 37th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984981.8139 | 2096034.5991 | 37.7344437114318 | -122.49436361071899 | (37.7344437114318, -122.494363610719) | |||
33144 | 33144 | 182431 | Undocumented 2 | :: 54 | 1550 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985622.7002 | 2104651.6438 | 37.7581412688876 | -122.492782358773 | (37.7581412688876, -122.492782358773) | |||
33203 | 33203 | 181890 | Undocumented 2 | :: 54 | 2342 31st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986735.2344 | 2099299.921 | 37.74351187906971 | -122.488541453894 | (37.7435118790697, -122.488541453894) | |||
33211 | 33211 | 200211 | Undocumented 2 | :: 54 | 974 Jamestown Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 6014078.3317 | 2089599.8969999999 | 37.7184351760665 | -122.39331644356001 | (37.7184351760665, -122.39331644356) | |||
33271 | 33271 | 184161 | Undocumented 2 | :: 54 | 3540 Lawton St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983209.359 | 2104274.4825 | 37.7569642726582 | -122.501100703383 | (37.7569642726582, -122.501100703383) | |||
33310 | 33310 | 185231 | Undocumented 2 | :: 54 | 2526 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986157.8975 | 2098028.4291 | 37.7399869968702 | -122.49044419216101 | (37.7399869968702, -122.490444192161) | |||
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) | |||
33516 | 33516 | 181822 | Undocumented 2 | :: 54 | 2325 Santiago St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985695.095 | 2099543.4155 | 37.7441197008564 | -122.492155870544 | (37.7441197008564, -122.492155870544) | |||
33521 | 33521 | 182182 | Undocumented 2 | :: 54 | 1643 21st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989628.9520000005 | 2104174.9651 | 37.7570658909994 | -122.478892302116 | (37.7570658909994, -122.478892302116) | |||
33564 | 33564 | 182573 | Undocumented 2 | :: 54 | 2185 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989329.4471 | 2098306.2746 | 37.740934619914796 | -122.479498731562 | (37.7409346199148, -122.479498731562) | |||
33583 | 33583 | 182803 | Undocumented 2 | :: 54 | 1782 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987536.9059 | 2103168.9213 | 37.7541818639362 | -122.486053455677 | (37.7541818639362, -122.486053455677) | |||
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) |
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");