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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27362 | 27362 | 137901 | Undocumented 2 | :: 54 | 402 Austin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005281.3807 | 2115310.0743 | 37.7885366835693 | -122.425552653183 | (37.7885366835693, -122.425552653183) | |||
| 27390 | 27390 | 183785 | Undocumented 2 | :: 54 | 2146 Santiago St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986125.7828 | 2099614.0525 | 37.744338818609 | -122.490671864125 | (37.744338818609, -122.490671864125) | |||
| 27474 | 27474 | 183607 | Undocumented 2 | :: 54 | 1 Quintara St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989903.61 | 2101103.2452 | 37.748647706091596 | -122.477717911497 | (37.7486477060916, -122.477717911497) | |||
| 27597 | 27597 | 184102 | Undocumented 2 | :: 54 | 1623 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985904.0693 | 2104173.8569 | 37.7568458469392 | -122.491774103994 | (37.7568458469392, -122.491774103994) | |||
| 27770 | 27770 | 181987 | Undocumented 2 | :: 54 | 2832 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987195.8265 | 2098292.1009 | 37.7407715379119 | -122.486874867312 | (37.7407715379119, -122.486874867312) | |||
| 27966 | 27966 | 184450 | Undocumented 2 | :: 54 | 2127 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982917.6673 | 2100633.8105 | 37.7469508716588 | -122.501840104956 | (37.7469508716588, -122.501840104956) | |||
| 28131 | 28131 | 200245 | Undocumented 2 | :: 54 | 1075 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6013768.3263 | 2090118.3656 | 37.71984155975311 | -122.394424294358 | (37.7198415597531, -122.394424294358) | |||
| 28244 | 28244 | 184686 | Undocumented 2 | :: 54 | 1606 39th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984083.9121 | 2104208.225 | 37.7568336628482 | -122.498071323375 | (37.7568336628482, -122.498071323375) | |||
| 28310 | 28310 | 185781 | Undocumented 2 | :: 54 | 2419 Ortega St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986496.7508 | 2102292.5013 | 37.7517147795652 | -122.489586075955 | (37.7517147795652, -122.489586075955) | |||
| 28315 | 28315 | 182384 | Undocumented 2 | :: 54 | 1539 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985884.4808 | 2104746.0177 | 37.7584156979157 | -122.49188396911 | (37.7584156979157, -122.49188396911) | |||
| 28318 | 28318 | 182661 | Undocumented 2 | :: 54 | 2500 Ortega St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986241.1388 | 2102339.3676 | 37.7518285352163 | -122.490473451437 | (37.7518285352163, -122.490473451437) | |||
| 28513 | 28513 | 200177 | Undocumented 2 | :: 54 | 1041 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014650.3204 | 2089811.8475 | 37.7190489123065 | -122.39135410876001 | (37.7190489123065, -122.39135410876) | |||
| 28564 | 28564 | 139551 | Undocumented 2 | :: 54 | 230 Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000668.9907 | 2112886.9641 | 37.7816217540269 | -122.441336837605 | (37.7816217540269, -122.441336837605) | |||
| 28625 | 28625 | 217557 | Undocumented 2 | :: 54 | 111 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5995778.3452 | 2088036.9975 | 37.7131101315221 | -122.456458551068 | (37.7131101315221, -122.456458551068) | |||
| 28871 | 28871 | 182685 | Undocumented 2 | :: 54 | 1709 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985611.9744 | 2103558.0646 | 37.7551379747053 | -122.492738908785 | (37.7551379747053, -122.492738908785) | |||
| 28948 | 28948 | 141597 | Undocumented 2 | :: 54 | 529 MASONIC AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999089.4212 | 2110974.3283 | 37.7762800409646 | -122.44666372012199 | (37.7762800409646, -122.446663720122) | |||
| 29089 | 29089 | 183590 | Undocumented 2 | :: 54 | 2630 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5989282.842 | 2097424.4506 | 37.7385106529577 | -122.47959536842899 | (37.7385106529577, -122.479595368429) | |||
| 29214 | 29214 | 182945 | Undocumented 2 | :: 54 | 2691 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981809.5051 | 2096798.8146 | 37.7363558765881 | -122.50538776138 | (37.7363558765881, -122.50538776138) | |||
| 29215 | 29215 | 182387 | Undocumented 2 | :: 54 | 1534 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984999.5267 | 2104736.7468 | 37.7583384778479 | -122.494943804575 | (37.7583384778479, -122.494943804575) | |||
| 29414 | 29414 | 182531 | Undocumented 2 | :: 54 | 1583 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985892.5986 | 2104472.9119 | 37.7576662991842 | -122.491835788899 | (37.7576662991842, -122.491835788899) | |||
| 29522 | 29522 | 184704 | Undocumented 2 | :: 54 | 1615 37th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984659.276000001 | 2104181.7734 | 37.756794751430995 | -122.496079580355 | (37.756794751431, -122.496079580355) | |||
| 29647 | 29647 | 200249 | Undocumented 2 | :: 54 | 1067 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6013803.2037 | 2090093.549 | 37.7197753570889 | -122.394301997885 | (37.7197753570889, -122.394301997885) | |||
| 29653 | 29653 | 138301 | Undocumented 2 | :: 54 | 2201 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002887.8567 | 2114766.9673 | 37.786909917993 | -122.433795036923 | (37.786909917993, -122.433795036923) | |||
| 29863 | 29863 | 200176 | Undocumented 2 | :: 54 | 1047 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014610.748 | 2089844.7127 | 37.7191369573176 | -122.391493192738 | (37.7191369573176, -122.391493192738) | |||
| 29939 | 29939 | 184629 | Undocumented 2 | :: 54 | 1646 41st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983471.6508 | 2103927.0296 | 37.7560256626113 | -122.500167928609 | (37.7560256626113, -122.500167928609) | |||
| 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) |
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");