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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29958 | 29958 | 182143 | Undocumented 2 | :: 54 | 1417 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5988335.378 | 2105652.5628 | 37.7610477734155 | -122.483474239769 | (37.7610477734155, -122.483474239769) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) |
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");