Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantDate, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3019 | 3019 | 20034 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100 STAIRWAY51 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | ST | ||||||||
| 3951 | 3951 | 20035 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100 STAIRWAY51 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | ST | ||||||||
| 7527 | 7527 | 20039 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100 STAIRWAY51 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | ST | ||||||||
| 10575 | 10575 | 20040 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100 STAIRWAY51 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | ST | ||||||||
| 11812 | 11812 | 20044 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100 STAIRWAY51 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | ST | ||||||||
| 12976 | 12976 | 20042 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100 STAIRWAY51 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | ST | ||||||||
| 14695 | 14695 | 20043 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100 STAIRWAY51 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | ST | ||||||||
| 102609 | 102609 | 89562 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 5027 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5983024.08969 | 2111679.84197 | 37.7772863874511 | -122.50228944566099 | (37.7772863874511, -122.502289445661) | ||
| 175620 | 175620 | 117840 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 600x 39th Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 6ft | 5983808.599090001 | 2111637.58628 | 37.777216427782896 | -122.499572493795 | (37.7772164277829, -122.499572493795) | |||
| 60634 | 60634 | 117841 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 600x 39th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 6ft | 5983809.68656 | 2111621.06726 | 37.7771711351486 | -122.499567510814 | (37.7771711351486, -122.499567510814) | |||
| 51598 | 51598 | 117842 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 620x 39th Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 6ft | 5983810.65643 | 2111554.107 | 37.7769873385843 | -122.499559205901 | (37.7769873385843, -122.499559205901) | |||
| 82643 | 82643 | 20854 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1892X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | 5984852.8466778 | 2102317.5089788004 | 37.7516873322231 | -122.49527267334 | (37.7516873322231, -122.49527267334) | |||
| 90456 | 90456 | 21221 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 2392X Sunset Blvd | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984971.116957701 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | |||
| 105157 | 105157 | 21218 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 2392X Sunset Blvd | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984971.116957701 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | |||
| 143219 | 143219 | 21220 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 2392X Sunset Blvd | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984971.116957701 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | |||
| 99194 | 99194 | 90973 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 3201 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/13/2008 12:00:00 AM | 3 | 3x3 | 5985628.516480001 | 2111090.85012 | 37.775821861569 | -122.493236620395 | (37.775821861569, -122.493236620395) | ||
| 103854 | 103854 | 446 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 700x 23rd Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5988817.30903 | 2110408.41055 | 37.7741340651206 | -122.48215589864901 | (37.7741340651206, -122.482155898649) | ||||
| 58709 | 58709 | 445 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 700X 23rd Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8-HOA | 5988818.925419999 | 2110381.03816 | 37.774059002147204 | -122.482148301598 | (37.7740590021472, -122.482148301598) | |||
| 127444 | 127444 | 12766 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1816 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 5989782.53842 | 2114745.3914099997 | 37.7860983011374 | -122.479134351427 | (37.7860983011374, -122.479134351427) | |||
| 126393 | 126393 | 89073 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 574 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990364.51379 | 2111466.25843 | 37.77712849442079 | -122.47688121138901 | (37.7771284944208, -122.476881211389) | ||
| 78348 | 78348 | 89062 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 718 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990389.96787 | 2110449.49481 | 37.774338217555794 | -122.476718855278 | (37.7743382175558, -122.476718855278) | ||
| 106552 | 106552 | 12610 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 724 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 5993191.3891199995 | 2114869.36762 | 37.7866360851499 | -122.46734975656099 | (37.7866360851499, -122.467349756561) | |||
| 177543 | 177543 | 214300 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 200x Terrace Dr | 42 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 5993888.01583 | 2096515.6983900003 | 37.7362818799091 | -122.46360708499701 | (37.7362818799091, -122.463607084997) | ||||
| 165194 | 165194 | 212538 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 200x Terrace Dr | 38 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 5993893.90506 | 2096479.6500900001 | 37.736183239558 | -122.463584108238 | (37.736183239558, -122.463584108238) | ||||
| 46004 | 46004 | 212540 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 200x Terrace Dr | 40 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 5993897.21452 | 2096501.63961 | 37.7362438080119 | -122.46357426156 | (37.7362438080119, -122.46357426156) | ||||
| 55258 | 55258 | 212539 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 200x Terrace Dr | 39 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 5993900.48922 | 2096491.80191 | 37.736216984813105 | -122.463562225914 | (37.7362169848131, -122.463562225914) | ||||
| 91150 | 91150 | 11948 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 298 Kensington Way | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 5994171.1384101 | 2099119.7549802 | 37.743448279624 | -122.462817078393 | (37.743448279624, -122.462817078393) | |||
| 100288 | 100288 | 11949 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 298 Kensington Way | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 5994171.1384101 | 2099119.7549802 | 37.743448279624 | -122.462817078393 | (37.743448279624, -122.462817078393) | |||
| 163567 | 163567 | 212376 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 350x Kensington Way | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 6ft | 5994225.30573 | 2099058.0744 | 37.743282039932794 | -122.462625309526 | (37.7432820399328, -122.462625309526) | |||
| 57154 | 57154 | 212375 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 350x Kensington Way | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 6ft | 5994268.67075 | 2099029.19032 | 37.743205228833205 | -122.46247327105101 | (37.7432052288332, -122.462473271051) | |||
| 19524 | 19524 | 8290 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 50 Garcia Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 8 | 5995181.45452 | 2099378.2291200003 | 37.7442161243666 | -122.45934239824899 | (37.7442161243666, -122.459342398249) | |||
| 20164 | 20164 | 8289 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 50 Garcia Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8 | 5995199.8326 | 2099398.11528 | 37.7442717834334 | -122.459280291049 | (37.7442717834334, -122.459280291049) | |||
| 148511 | 148511 | 212576 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100x Idora Ave | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 9ft | 5995353.74805 | 2099410.49817 | 37.74431463161879 | -122.458748984199 | (37.7443146316188, -122.458748984199) | |||
| 94053 | 94053 | 8779 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 3520 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5996174.45541 | 2112935.09179 | 37.78149683844121 | -122.45688917879801 | (37.7814968384412, -122.456889178798) | |||
| 123086 | 123086 | 22830 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 88 Turquoise Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 5999067.1751904 | 2099480.26243 | 37.7447189259574 | -122.44591380563101 | (37.7447189259574, -122.445913805631) | |||
| 8439 | 8439 | 19025 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 3170 Sacramento St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 8 | 2X2 | 5999621.132119999 | 2115414.4338700003 | 37.7885017807754 | -122.445143681435 | (37.7885017807754, -122.445143681435) | |||
| 7408 | 7408 | 19027 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 3170 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2x2 | 5999630.40201 | 2115407.06556 | 37.7884820784247 | -122.44511107923 | (37.7884820784247, -122.44511107923) | |||
| 54957 | 54957 | 214207 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 400x Marietta Dr | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 3ft | 5999489.79352 | 2097033.53781 | 37.7380249270166 | -122.444276686425 | (37.7380249270166, -122.444276686425) | |||
| 23254 | 23254 | 22843 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 120 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 3X3 | 5999765.52429 | 2099012.7663 | 37.7434751450586 | -122.443465482663 | (37.7434751450586, -122.443465482663) | |||
| 23107 | 23107 | 1354 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 290 Amber Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 3X3 | 5999954.53574 | 2099301.98481 | 37.7442800472965 | -122.442832694476 | (37.7442800472965, -122.442832694476) | |||
| 19919 | 19919 | 22857 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 140 Turquoise Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 5999962.5857 | 2099158.01646 | 37.743885203545396 | -122.442794523662 | (37.7438852035454, -122.442794523662) | ||||
| 127211 | 127211 | 5818 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 959 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000256.5254907 | 2099603.3351939 | 37.7451246954454 | -122.441810105191 | (37.7451246954454, -122.441810105191) | |||
| 19522 | 19522 | 17054 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1267 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000942.0344 | 2109636.8826 | 37.77271340359871 | -122.44015910616301 | (37.7727134035987, -122.440159106163) | |||
| 9608 | 9608 | 16823 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 2139X O'Farrell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6001040.8337 | 2113118.4303 | 37.7822784765294 | -122.440067043321 | (37.7822784765294, -122.440067043321) | |||
| 8873 | 8873 | 8201 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1360 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6001243.6294 | 2111120.8056 | 37.7768050488635 | -122.439222237812 | (37.7768050488635, -122.439222237812) | |||
| 9526 | 9526 | 14741 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 900 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002478.8616 | 2111661.3163 | 37.7783593683998 | -122.434987870066 | (37.7783593683998, -122.434987870066) | |||
| 18906 | 18906 | 5095 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 2611 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/2004 12:00:00 AM | 6 | 3X3 | 6002301.7516 | 2096545.88638 | 37.7368459778655 | -122.43451950896099 | (37.7368459778655, -122.434519508961) | ||
| 104519 | 104519 | 5100 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 2621 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 6002314.2781061 | 2096520.2165863998 | 37.7367762056107 | -122.43447436453998 | (37.7367762056107, -122.43447436454) | |||
| 21743 | 21743 | 5096 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 2617 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/08/2005 12:00:00 AM | 15 | 4x7 | 6002321.1773 | 2096442.08451 | 37.7365620645731 | -122.43444492640499 | (37.7365620645731, -122.434444926405) | ||
| 21429 | 21429 | 4275 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 4215 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002481.0949 | 2100316.7179400004 | 37.7472099827631 | -122.434168929879 | (37.7472099827631, -122.434168929879) | |||
| 84153 | 84153 | 21725 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1938X Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6003302.068331299 | 2114526.316247 | 37.786272646739796 | -122.43234476672501 | (37.7862726467398, -122.432344766725) | |||
| 45341 | 45341 | 23899 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1600X Webster St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6003605.147696201 | 2114190.7261663 | 37.785368381567004 | -122.431272227533 | (37.785368381567, -122.431272227533) | |||
| 124198 | 124198 | 28645 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1600X Webster St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6003605.147696201 | 2114190.7261663 | 37.785368381567004 | -122.431272227533 | (37.785368381567, -122.431272227533) | |||
| 125348 | 125348 | 23901 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1600X Webster St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 6003605.147696201 | 2114190.7261663 | 37.785368381567004 | -122.431272227533 | (37.785368381567, -122.431272227533) | |||
| 125690 | 125690 | 28649 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1600X Webster St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 6 | 6003605.147696201 | 2114190.7261663 | 37.785368381567004 | -122.431272227533 | (37.785368381567, -122.431272227533) | |||
| 138849 | 138849 | 28652 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1600X Webster St | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 6 | 6003605.147696201 | 2114190.7261663 | 37.785368381567004 | -122.431272227533 | (37.785368381567, -122.431272227533) | |||
| 142975 | 142975 | 28653 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1600X Webster St | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6003605.147696201 | 2114190.7261663 | 37.785368381567004 | -122.431272227533 | (37.785368381567, -122.431272227533) | |||
| 100147 | 100147 | 72943 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 4082 CESAR CHAVEZ ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/19/1999 12:00:00 AM | 6 | 6003377.0 | 2100406.0 | 37.747505937876 | -122.431077332232 | (37.747505937876, -122.431077332232) | |||
| 187999 | 187999 | 140339 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1300x WEBSTER ST | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6003689.95 | 2113371.7397 | 37.7831244557567 | -122.430920367043 | (37.7831244557567, -122.430920367043) | |||
| 1535 | 1535 | 28642 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1300 Webster St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | 20 | 6003705.0759 | 2113297.4854 | 37.782921429068395 | -122.430862736641 | (37.7829214290684, -122.430862736641) | |||
| 107509 | 107509 | 87402 | Prunus cerasifera :: Cherry Plum 16 | 1300 Webster St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 6003725.160049 | 2113179.0694110002 | 37.7825974263114 | -122.430784800607 | (37.7825974263114, -122.430784800607) | |||
| 2555 | 2555 | 138187 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1865 Buchanan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/18/1998 12:00:00 AM | 6 | Width 0ft | 6003949.1621 | 2114685.5907 | 37.7867466447295 | -122.43011735683599 | (37.7867466447295, -122.430117356836) | ||
| 6439 | 6439 | 2463 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1826 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/23/1997 12:00:00 AM | 3 | 4X4 | 6003987.7732 | 2114755.2881 | 37.7869402029829 | -122.429988745219 | (37.7869402029829, -122.429988745219) | ||
| 6925 | 6925 | 2462 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1826 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/17/1998 12:00:00 AM | 3 | 4X4 | 6003992.7724 | 2114732.7916 | 37.78687871637621 | -122.429969843785 | (37.7868787163762, -122.429969843785) | ||
| 21692 | 21692 | 26 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 736 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/12/1992 12:00:00 AM | 12 | 3X3 | 6003885.725319999 | 2107769.72577 | 37.7677537952191 | -122.4298433527 | (37.7677537952191, -122.4298433527) | ||
| 141587 | 141587 | 12438 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1595X Laguna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2005 12:00:00 AM | 3 | 3X3 | 6004488.80475 | 2114299.5475 | 37.785717215657 | -122.428222797765 | (37.785717215657, -122.428222797765) | ||
| 135968 | 135968 | 139119 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1501 LAGUNA ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2005 12:00:00 AM | 4 | Width 0ft | 6004503.5822 | 2114180.7007 | 37.7853917281698 | -122.42816319919201 | (37.7853917281698, -122.428163199192) | ||
| 157716 | 157716 | 139120 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1501 LAGUNA ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | Width 0ft | 6004505.7981 | 2114155.2180000003 | 37.7853218844175 | -122.428153716152 | (37.7853218844175, -122.428153716152) | |||
| 22236 | 22236 | 4405 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1050 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/01/1993 12:00:00 AM | 12 | 3X3 | 6004381.0178 | 2102775.98302 | 37.7540702011025 | -122.42777434091299 | (37.7540702011025, -122.427774340913) | ||
| 20087 | 20087 | 4439 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1302 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004459.83721 | 2101280.4453 | 37.749968261937106 | -122.42739523262699 | (37.7499682619371, -122.427395232627) | |||
| 21625 | 21625 | 27417 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1368 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6004484.17444 | 2100908.10154 | 37.7489472688119 | -122.427284553046 | (37.7489472688119, -122.427284553046) | |||
| 21867 | 21867 | 4450 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1368 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6004484.29512 | 2100913.96053 | 37.748963363065 | -122.427284553034 | (37.748963363065, -122.427284553034) | |||
| 21005 | 21005 | 4464 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1467 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/1992 12:00:00 AM | 6 | 3X3 | 6004576.21057 | 2100336.17551 | 37.7473820968062 | -122.42692556438801 | (37.7473820968062, -122.426925564388) | ||
| 22000 | 22000 | 4189 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 3854 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/17/1998 12:00:00 AM | 6 | 3X3 | 6004813.31142 | 2100488.37375 | 37.747813401782 | -122.426116518959 | (37.747813401782, -122.426116518959) | ||
| 19389 | 19389 | 9994 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 102 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6005389.27087 | 2108406.08421 | 37.7695861126487 | -122.424688040346 | (37.7695861126487, -122.424688040346) | |||
| 21918 | 21918 | 26668 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 102 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 2X2 | 6005390.51366 | 2108390.09444 | 37.769542278768505 | -122.42468260394199 | (37.7695422787685, -122.424682603942) | |||
| 17743 | 17743 | 9991 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 43 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6005443.377280001 | 2108628.68203 | 37.7702003684767 | -122.424516723968 | (37.7702003684767, -122.424516723968) | |||
| 10080 | 10080 | 10041 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 360 Guerrero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/1991 12:00:00 AM | 20 | 3X3 | 6005475.31081 | 2106892.46038 | 37.765434922114295 | -122.42428276264299 | (37.7654349221143, -122.424282762643) | ||
| 19778 | 19778 | 10042 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 360 Guerrero St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6005475.5325 | 2106875.27322 | 37.7653877427782 | -122.424280773365 | (37.7653877427782, -122.424280773365) | |||
| 20708 | 20708 | 10039 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 360 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1991 12:00:00 AM | 20 | 3X3 | 6005477.1925800005 | 2106955.99773 | 37.765609486820004 | -122.424280773358 | (37.76560948682, -122.424280773358) | ||
| 21906 | 21906 | 10040 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 360 Guerrero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005476.568580001 | 2106925.6543400004 | 37.7655261358546 | -122.424280773346 | (37.7655261358546, -122.424280773346) | |||
| 20643 | 20643 | 26635 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 359 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/24/1998 12:00:00 AM | 3 | 3X3 | 6005539.477000001 | 2106921.88393 | 37.7655193351826 | -122.42406291888001 | (37.7655193351826, -122.42406291888) | ||
| 102338 | 102338 | 10097 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 744 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 2X2 | 6005593.39843 | 2104652.72108 | 37.759291793936896 | -122.423715061076 | (37.7592917939369, -122.423715061076) | |||
| 22175 | 22175 | 10077 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 611 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005621.78486 | 2105416.8204099997 | 37.761391433480895 | -122.423671214664 | (37.7613914334809, -122.423671214664) | |||
| 20555 | 20555 | 10100 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 750 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/22/1995 12:00:00 AM | 40 | 2x2 | 6005607.26399 | 2104540.55602 | 37.758984597670896 | -122.423659132264 | (37.7589845976709, -122.423659132264) | ||
| 19892 | 19892 | 10082 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 635 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6005631.678069999 | 2105272.5638099997 | 37.7609958972634 | -122.42362674139 | (37.7609958972634, -122.42362674139) | |||
| 83332 | 83332 | 428 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 804X Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 2x2 | 6005618.5318457 | 2104291.1657751 | 37.7583004664994 | -122.423602431641 | (37.7583004664994, -122.423602431641) | |||
| 16930 | 16930 | 25410 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 153 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/22/1996 12:00:00 AM | 3 | 3X3 | 6005712.73498 | 2108443.02914 | 37.769705817804606 | -122.423571815294 | (37.7697058178046, -122.423571815294) | ||
| 145891 | 145891 | 10119 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 850 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/06/1992 12:00:00 AM | 18 | 3X3 | 6005631.880167 | 2104012.3184419 | 37.757535570368 | -122.423536442741 | (37.757535570368, -122.423536442741) | ||
| 20712 | 20712 | 10140 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 906 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/1991 12:00:00 AM | 8 | 2x2 | 6005653.96599 | 2103626.9979 | 37.7564788166491 | -122.423432668582 | (37.7564788166491, -122.423432668582) | ||
| 17320 | 17320 | 10141 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 906 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2x2 | 6005654.69613 | 2103615.0906 | 37.7564461631881 | -122.423429297021 | (37.7564461631881, -122.423429297021) | |||
| 17392 | 17392 | 10106 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 785 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6005679.329609999 | 2104414.6071 | 37.7586428391006 | -122.42340094141399 | (37.7586428391006, -122.423400941414) | |||
| 17273 | 17273 | 10114 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 827 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005696.25247 | 2104120.31934 | 37.7578357488369 | -122.423321494416 | (37.7578357488369, -122.423321494416) | |||
| 20450 | 20450 | 10113 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 827 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6005696.52511 | 2104103.91625 | 37.757790725171 | -122.423319385483 | (37.757790725171, -122.423319385483) | |||
| 19264 | 19264 | 10115 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 827 Guerrero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6005698.17392 | 2104144.57278 | 37.75790245155879 | -122.42331657330901 | (37.7579024515588, -122.423316573309) | |||
| 19926 | 19926 | 10117 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 845 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005699.222580001 | 2104067.01691 | 37.757689560440795 | -122.42330743349301 | (37.7576895604408, -122.423307433493) | |||
| 81532 | 81532 | 10118 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 845 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/01/1990 12:00:00 AM | 3 | 3X3 | 6005704.2510557 | 2104056.9285895 | 37.7576621440613 | -122.423289325813 | (37.7576621440613, -122.423289325813) | ||
| 117979 | 117979 | 476 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1110X Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 2x2 | 6005715.8108342 | 2102491.4524088 | 37.753364362762 | -122.42313807467801 | (37.753364362762, -122.423138074678) | |||
| 17636 | 17636 | 10167 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1021 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6005764.985230001 | 2102811.5808900003 | 37.7542461363638 | -122.422990770503 | (37.7542461363638, -122.422990770503) | |||
| 21423 | 21423 | 10225 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1399 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005877.37579 | 2100867.12021 | 37.748913436323704 | -122.422463939564 | (37.7489134363237, -122.422463939564) |
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");