trees
6,714 rows where qSpecies_id = 7 sorted by qCaretaker_id
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 604 | 20034 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
| 1364 | 253839 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 94 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/12/2011 12:00:00 AM | 3x3 | 6006239 | 2097690 | 37.7402101761268 | -122.42098789234 | (37.7402101761268, -122.42098789234) | 2 | 7 | 7 | 28859 | 2 | |||
| 1813 | 25410 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 153 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/22/1996 12:00:00 AM | 3 | 3X3 | 6005712.73498 | 2108443.02914 | 37.7697058178046 | -122.423571815294 | (37.7697058178046, -122.423571815294) | 8 | 4 | 5 | 28853 | 19 | ||
| 3055 | 20039 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
| 4991 | 20043 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
| 5448 | 140339 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1300x WEBSTER ST | 7 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6003689.95 | 2113371.7397 | 37.7831244557567 | -122.430920367043 | (37.7831244557567, -122.430920367043) | 15 | 9 | 11 | 29490 | 41 | |||
| 6867 | 260482 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 3333 California St | 4 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3X3 | 5998571 | 2114839 | 37.7868617958727 | -122.448735497123 | (37.7868617958727, -122.448735497123) | 15 | 6 | 1 | 54 | 31 | ||||
| 7114 | 20035 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
| 7976 | 20040 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | ST | |||||||||||||
| 9007 | 23899 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1600X Webster St | 1 | Median : Cutout | Tree | DPW 1 | 12 | 6 | 6003605.1476962 | 2114190.7261663 | 37.785368381567 | -122.431272227533 | (37.785368381567, -122.431272227533) | 13 | 9 | 11 | 29490 | 13 | |||
| 9610 | 196158 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 390x Hampshire St | 4 | Median : Cutout | Tree | DPW 1 | 8 | Width 5ft | 6010042.15672 | 2106501.92637 | 37.7646194177702 | -122.408459468244 | (37.7646194177702, -122.408459468244) | 8 | 4 | 8 | 28853 | 19 | |||
| 10306 | 445 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 700X 23rd Ave | 6 | Median : Cutout | Tree | DPW 1 | 3 | 8-HOA | 5988818.92542 | 2110381.03816 | 37.7740590021472 | -122.482148301598 | (37.7740590021472, -122.482148301598) | 11 | 6 | 2 | 55 | 26 | |||
| 12545 | 260484 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 3333 California St | 6 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3X3 | 5998571 | 2114839 | 37.7868617958727 | -122.448735497123 | (37.7868617958727, -122.448735497123) | 15 | 6 | 1 | 54 | 31 | ||||
| 14721 | 20044 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
| 14823 | 260479 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 3333 California St | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3X3 | 5998571 | 2114839 | 37.7868617958727 | -122.448735497123 | (37.7868617958727, -122.448735497123) | 15 | 6 | 1 | 54 | 31 | ||||
| 15393 | 260480 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 3333 California St | 2 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3X3 | 5998571 | 2114839 | 37.7868617958727 | -122.448735497123 | (37.7868617958727, -122.448735497123) | 15 | 6 | 1 | 54 | 31 | ||||
| 16021 | 260481 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 3333 California St | 3 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3X3 | 5998571 | 2114839 | 37.7868617958727 | -122.448735497123 | (37.7868617958727, -122.448735497123) | 15 | 6 | 1 | 54 | 31 | ||||
| 17001 | 25978 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2027 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/19/1997 12:00:00 AM | 8 | 6x9 | 6012757.29387 | 2097148.77262 | 37.7390893573798 | -122.398412142527 | (37.7390893573798, -122.398412142527) | 10 | 3 | 8 | 58 | 1 | ||
| 17369 | 260483 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 3333 California St | 5 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3X3 | 5998571 | 2114839 | 37.7868617958727 | -122.448735497123 | (37.7868617958727, -122.448735497123) | 15 | 6 | 1 | 54 | 31 | ||||
| 18800 | 20042 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
| 19768 | 23901 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1600X Webster St | 4 | Median : Cutout | Tree | DPW 1 | 12 | 20 | 6003605.1476962 | 2114190.7261663 | 37.785368381567 | -122.431272227533 | (37.785368381567, -122.431272227533) | 13 | 9 | 11 | 29490 | 13 | |||
| 19870 | 196269 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 50x Dedman Ct | 2 | Median : Yard | Tree | DPW 1 | 12 | 6016851.53049 | 2096187.80946 | 37.7366779736991 | -122.384189093646 | (37.7366779736991, -122.384189093646) | 10 | 3 | 8 | 58 | 1 | ||||
| 26201 | 10106 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 785 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6005679.32961 | 2104414.6071 | 37.7586428391006 | -122.423400941414 | (37.7586428391006, -122.423400941414) | 2 | 4 | 5 | 28859 | 19 | |||
| 28228 | 5818 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 959 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6000256.5254907 | 2099603.3351939 | 37.7451246954454 | -122.441810105191 | (37.7451246954454, -122.441810105191) | 2 | 7 | 5 | 63 | 22 | |||
| 31063 | 28642 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1300 Webster St | 4 | Median : Cutout | Tree | DPW 1 | 10 | 20 | 6003705.0759 | 2113297.4854 | 37.7829214290684 | -122.430862736641 | (37.7829214290684, -122.430862736641) | 15 | 9 | 11 | 29490 | 41 | |||
| 31793 | 28645 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1600X Webster St | 2 | Median : Cutout | Tree | DPW 1 | 12 | 6 | 6003605.1476962 | 2114190.7261663 | 37.785368381567 | -122.431272227533 | (37.785368381567, -122.431272227533) | 13 | 9 | 11 | 29490 | 13 | |||
| 33749 | 12766 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1816 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 5989782.53842 | 2114745.39141 | 37.7860983011374 | -122.479134351427 | (37.7860983011374, -122.479134351427) | 11 | 6 | 1 | 55 | 33 | |||
| 34075 | 10141 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 906 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2x2 | 6005654.69613 | 2103615.0906 | 37.7564461631881 | -122.423429297021 | (37.7564461631881, -122.423429297021) | 2 | 4 | 5 | 28859 | 19 | |||
| 37325 | 89073 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 574 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990364.51379 | 2111466.25843 | 37.7771284944208 | -122.476881211389 | (37.7771284944208, -122.476881211389) | 11 | 6 | 2 | 55 | 26 | ||
| 37532 | 10114 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 827 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6005696.25247 | 2104120.31934 | 37.7578357488369 | -122.423321494416 | (37.7578357488369, -122.423321494416) | 2 | 4 | 5 | 28859 | 19 | |||
| 38594 | 9991 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 43 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 6005443.37728 | 2108628.68203 | 37.7702003684767 | -122.424516723968 | (37.7702003684767, -122.424516723968) | 8 | 2 | 5 | 28853 | 19 | |||
| 47477 | 20854 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1892X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | 5984852.8466778 | 2102317.5089788 | 37.7516873322231 | -122.49527267334 | (37.7516873322231, -122.49527267334) | 1 | 8 | 3 | 56 | 35 | |||
| 48849 | 10167 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1021 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6005764.98523 | 2102811.58089 | 37.7542461363638 | -122.422990770503 | (37.7542461363638, -122.422990770503) | 2 | 4 | 5 | 28859 | 19 | |||
| 51448 | 428 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 804X Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 2x2 | 6005618.5318457 | 2104291.1657751 | 37.7583004664994 | -122.423602431641 | (37.7583004664994, -122.423602431641) | 2 | 4 | 5 | 28859 | 19 | |||
| 52411 | 21725 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1938X Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6003302.0683313 | 2114526.316247 | 37.7862726467398 | -122.432344766725 | (37.7862726467398, -122.432344766725) | 13 | 9 | 11 | 29490 | 27 | |||
| 52481 | 89062 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 718 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990389.96787 | 2110449.49481 | 37.7743382175558 | -122.476718855278 | (37.7743382175558, -122.476718855278) | 11 | 6 | 2 | 55 | 26 | ||
| 53719 | 10118 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 845 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/01/1990 12:00:00 AM | 3 | 3X3 | 6005704.2510557 | 2104056.9285895 | 37.7576621440613 | -122.423289325813 | (37.7576621440613, -122.423289325813) | 2 | 4 | 5 | 28859 | 19 | ||
| 55214 | 196270 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 50x Dedman Ct | 3 | Median : Yard | Tree | DPW 1 | 11 | 6016861.7614 | 2096200.30133 | 37.7367128395304 | -122.384154590289 | (37.7367128395304, -122.384154590289) | 10 | 3 | 8 | 58 | 1 | ||||
| 55794 | 212540 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 200x Terrace Dr | 40 | Median : Yard | Tree | DPW 1 | 4 | 5993897.21452 | 2096501.63961 | 37.7362438080119 | -122.46357426156 | (37.7362438080119, -122.46357426156) | 1 | 8 | 4 | 59 | 40 | ||||
| 56575 | 14741 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 900 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002478.8616 | 2111661.3163 | 37.7783593683998 | -122.434987870066 | (37.7783593683998, -122.434987870066) | 15 | 5 | 11 | 29490 | 41 | |||
| 57284 | 254326 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 550 Jessie St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6009683 | 2112475 | 37.7809999678285 | -122.410123427963 | (37.7809999678285, -122.410123427963) | 14 | 2 | 9 | 28853 | 34 | |||||
| 57698 | 212375 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 350x Kensington Way | 1 | Median : Cutout | Tree | DPW 1 | 13 | Width 6ft | 5994268.67075 | 2099029.19032 | 37.7432052288332 | -122.462473271051 | (37.7432052288332, -122.462473271051) | 1 | 8 | 4 | 59 | 40 | |||
| 58689 | 18424 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 974 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6010455.61637 | 2103584.49121 | 37.7566319433297 | -122.406823785791 | (37.7566319433297, -122.406823785791) | 10 | 4 | 7 | 28859 | 19 | |||
| 59126 | 21221 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2392X Sunset Blvd | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984971.1169577 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | 1 | 8 | 3 | 29491 | 35 | |||
| 59235 | 117841 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 600x 39th Ave | 1 | Median : Cutout | Tree | DPW 1 | 2 | Width 6ft | 5983809.68656 | 2111621.06726 | 37.7771711351486 | -122.499567510814 | (37.7771711351486, -122.499567510814) | 11 | 6 | 2 | 55 | 26 | |||
| 59934 | 1354 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 290 Amber Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | 3X3 | 5999954.53574 | 2099301.98481 | 37.7442800472965 | -122.442832694476 | (37.7442800472965, -122.442832694476) | 2 | 7 | 5 | 63 | 22 | |||
| 61038 | 120963 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 899X South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6007672 | 2104462 | 37.7588852341986 | -122.41651271944 | (37.7588852341986, -122.41651271944) | 2 | 4 | 7 | 28859 | 19 | |||
| 63314 | 214207 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 400x Marietta Dr | 9 | Median : Cutout | Tree | DPW 1 | 8 | Width 3ft | 5999489.79352 | 2097033.53781 | 37.7380249270166 | -122.444276686425 | (37.7380249270166, -122.444276686425) | 9 | 7 | 4 | 59 | 40 | |||
| 63625 | 117842 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 620x 39th Ave | 5 | Median : Cutout | Tree | DPW 1 | 2 | Width 6ft | 5983810.65643 | 2111554.107 | 37.7769873385843 | -122.499559205901 | (37.7769873385843, -122.499559205901) | 11 | 6 | 2 | 55 | 26 | |||
| 71149 | 255637 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 260 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/31/2018 12:00:00 AM | 3 | 6008654.91085 | 2109676.79705 | 37.7732590874052 | -122.413482152541 | (37.7732590874052, -122.413482152541) | 8 | 2 | 9 | 28853 | 34 | |||
| 72838 | 212539 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 200x Terrace Dr | 39 | Median : Yard | Tree | DPW 1 | 7 | 5993900.48922 | 2096491.80191 | 37.7362169848131 | -122.463562225914 | (37.7362169848131, -122.463562225914) | 1 | 8 | 4 | 59 | 40 | ||||
| 75410 | 10041 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 360 Guerrero St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/02/1991 12:00:00 AM | 20 | 3X3 | 6005475.31081 | 2106892.46038 | 37.7654349221143 | -122.424282762643 | (37.7654349221143, -122.424282762643) | 8 | 4 | 5 | 28853 | 19 | ||
| 77245 | 6391 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 16 Espanola St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2007 12:00:00 AM | 6 | 3X3 | 6018056.47068 | 2094273.68663 | 37.7314887164161 | -122.379890092347 | (37.7314887164161, -122.379890092347) | 10 | 3 | 8 | 58 | 1 | ||
| 77546 | 26618 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1295 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6011596.48977 | 2093221.84886 | 37.7282421152608 | -122.402149690774 | (37.7282421152608, -122.402149690774) | 10 | 3 | 8 | 58 | 1 | |||
| 77831 | 9994 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 102 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6005389.27087 | 2108406.08421 | 37.7695861126487 | -122.424688040346 | (37.7695861126487, -122.424688040346) | 8 | 4 | 5 | 28853 | 19 | |||
| 79132 | 5095 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2611 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/04/2004 12:00:00 AM | 6 | 3X3 | 6002301.7516 | 2096545.88638 | 37.7368459778655 | -122.434519508961 | (37.7368459778655, -122.434519508961) | 2 | 7 | 5 | 63 | 7 | ||
| 81026 | 10115 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 827 Guerrero St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6005698.17392 | 2104144.57278 | 37.7579024515588 | -122.423316573309 | (37.7579024515588, -122.423316573309) | 2 | 4 | 5 | 28859 | 19 | |||
| 87204 | 11948 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 298 Kensington Way | 1 | Median : Cutout | Tree | DPW 1 | 6 | 8 | 5994171.1384101 | 2099119.7549802 | 37.743448279624 | -122.462817078393 | (37.743448279624, -122.462817078393) | 1 | 8 | 4 | 59 | 40 | |||
| 90869 | 8779 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3520 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5996174.45541 | 2112935.09179 | 37.7814968384412 | -122.456889178798 | (37.7814968384412, -122.456889178798) | 11 | 6 | 1 | 54 | 31 | |||
| 95753 | 446 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 700x 23rd Ave | 4 | Median : Cutout | Tree | DPW 1 | 3 | 5988817.30903 | 2110408.41055 | 37.7741340651206 | -122.482155898649 | (37.7741340651206, -122.482155898649) | 11 | 6 | 2 | 55 | 26 | ||||
| 96631 | 72943 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 4082 CESAR CHAVEZ ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/19/1999 12:00:00 AM | 6 | 6003377 | 2100406 | 37.747505937876 | -122.431077332232 | (37.747505937876, -122.431077332232) | 2 | 4 | 5 | 63 | 22 | |||
| 100161 | 17054 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1267 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000942.0344 | 2109636.8826 | 37.7727134035987 | -122.440159106163 | (37.7727134035987, -122.440159106163) | 15 | 5 | 11 | 29492 | 9 | |||
| 102165 | 22857 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 140 Turquoise Way | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 5999962.5857 | 2099158.01646 | 37.7438852035454 | -122.442794523662 | (37.7438852035454, -122.442794523662) | 2 | 7 | 5 | 63 | 7 | ||||
| 103207 | 254327 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 550 Jessie St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6009783.66194 | 2112493.30465 | 37.7810558696866 | -122.409776479401 | (37.7810558696866, -122.409776479401) | 14 | 2 | 9 | 28853 | 34 | |||||
| 105528 | 2463 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1826 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/23/1997 12:00:00 AM | 3 | 4X4 | 6003987.7732 | 2114755.2881 | 37.7869402029829 | -122.429988745219 | (37.7869402029829, -122.429988745219) | 13 | 9 | 11 | 29490 | 27 | ||
| 106701 | 10117 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 845 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005699.22258 | 2104067.01691 | 37.7576895604408 | -122.423307433493 | (37.7576895604408, -122.423307433493) | 2 | 4 | 5 | 28859 | 19 | |||
| 108778 | 10097 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 744 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 2X2 | 6005593.39843 | 2104652.72108 | 37.7592917939369 | -122.423715061076 | (37.7592917939369, -122.423715061076) | 2 | 4 | 5 | 28859 | 19 | |||
| 108849 | 90973 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3201 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/13/2008 12:00:00 AM | 3 | 3x3 | 5985628.51648 | 2111090.85012 | 37.775821861569 | -122.493236620395 | (37.775821861569, -122.493236620395) | 11 | 6 | 2 | 55 | 26 | ||
| 108881 | 8290 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 50 Garcia Ave | 2 | Median : Cutout | Tree | DPW 1 | 30 | 8 | 5995181.45452 | 2099378.22912 | 37.7442161243666 | -122.459342398249 | (37.7442161243666, -122.459342398249) | 1 | 8 | 4 | 59 | 40 | |||
| 110173 | 10042 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 360 Guerrero St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6005475.5325 | 2106875.27322 | 37.7653877427782 | -122.424280773365 | (37.7653877427782, -122.424280773365) | 8 | 4 | 5 | 28853 | 19 | |||
| 111857 | 11949 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 298 Kensington Way | 2 | Median : Cutout | Tree | DPW 1 | 6 | 8 | 5994171.1384101 | 2099119.7549802 | 37.743448279624 | -122.462817078393 | (37.743448279624, -122.462817078393) | 1 | 8 | 4 | 59 | 40 | |||
| 113474 | 89562 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 5027 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5983024.08969 | 2111679.84197 | 37.7772863874511 | -122.502289445661 | (37.7772863874511, -122.502289445661) | 11 | 6 | 2 | 55 | 26 | ||
| 117202 | 21218 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2392X Sunset Blvd | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984971.1169577 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | 1 | 8 | 3 | 29491 | 35 | |||
| 118072 | 26635 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 359 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/24/1998 12:00:00 AM | 3 | 3X3 | 6005539.477 | 2106921.88393 | 37.7655193351826 | -122.42406291888 | (37.7655193351826, -122.42406291888) | 8 | 4 | 5 | 28853 | 19 | ||
| 119191 | 12610 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 724 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 5993191.38912 | 2114869.36762 | 37.7866360851499 | -122.467349756561 | (37.7866360851499, -122.467349756561) | 11 | 6 | 1 | 54 | 11 | |||
| 119558 | 139119 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1501 LAGUNA ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/30/2005 12:00:00 AM | 4 | Width 0ft | 6004503.5822 | 2114180.7007 | 37.7853917281698 | -122.428163199192 | (37.7853917281698, -122.428163199192) | 13 | 9 | 11 | 29490 | 13 | ||
| 121864 | 87402 | - 12 | Prunus cerasifera :: Cherry Plum 7 | 1300 Webster St | 7 | Median : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 6003725.160049 | 2113179.069411 | 37.7825974263114 | -122.430784800607 | (37.7825974263114, -122.430784800607) | 15 | 9 | 11 | 29490 | 41 | ||
| 122058 | 4439 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1302 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004459.83721 | 2101280.4453 | 37.7499682619371 | -122.427395232627 | (37.7499682619371, -122.427395232627) | 2 | 4 | 5 | 28862 | 22 | |||
| 122516 | 2462 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1826 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/17/1998 12:00:00 AM | 3 | 4X4 | 6003992.7724 | 2114732.7916 | 37.7868787163762 | -122.429969843785 | (37.7868787163762, -122.429969843785) | 13 | 9 | 11 | 29490 | 27 | ||
| 123731 | 10113 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 827 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6005696.52511 | 2104103.91625 | 37.757790725171 | -122.423319385483 | (37.757790725171, -122.423319385483) | 2 | 4 | 5 | 28859 | 19 | |||
| 124127 | 4189 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3854 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/17/1998 12:00:00 AM | 6 | 3X3 | Permit Number 781750 | 6004813.31142 | 2100488.37375 | 37.747813401782 | -122.426116518959 | (37.747813401782, -122.426116518959) | 2 | 4 | 5 | 63 | 22 | |
| 125007 | 10100 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 750 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/22/1995 12:00:00 AM | 40 | 2x2 | 6005607.26399 | 2104540.55602 | 37.7589845976709 | -122.423659132264 | (37.7589845976709, -122.423659132264) | 2 | 4 | 5 | 28859 | 19 | ||
| 125692 | 8289 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 50 Garcia Ave | 1 | Median : Cutout | Tree | DPW 1 | 3 | 8 | 5995199.8326 | 2099398.11528 | 37.7442717834334 | -122.459280291049 | (37.7442717834334, -122.459280291049) | 1 | 8 | 4 | 59 | 40 | |||
| 129035 | 5100 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2621 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6002314.2781061 | 2096520.2165864 | 37.7367762056107 | -122.43447436454 | (37.7367762056107, -122.43447436454) | 2 | 7 | 5 | 63 | 7 | |||
| 132234 | 212576 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100x Idora Ave | 7 | Median : Yard | Tree | DPW 1 | 2 | Width 9ft | 5995353.74805 | 2099410.49817 | 37.7443146316188 | -122.458748984199 | (37.7443146316188, -122.458748984199) | 1 | 8 | 4 | 59 | 40 | |||
| 137071 | 22843 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 120 Turquoise Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 3X3 | 5999765.52429 | 2099012.7663 | 37.7434751450586 | -122.443465482663 | (37.7434751450586, -122.443465482663) | 2 | 7 | 5 | 63 | 7 | |||
| 140093 | 10039 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 360 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/25/1991 12:00:00 AM | 20 | 3X3 | 6005477.19258 | 2106955.99773 | 37.76560948682 | -122.424280773358 | (37.76560948682, -122.424280773358) | 8 | 4 | 5 | 28853 | 19 | ||
| 140251 | 11414 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1486 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6016137.01095 | 2096800.60407 | 37.738321052161 | -122.386702239228 | (37.738321052161, -122.386702239228) | 10 | 3 | 8 | 58 | 1 | |||
| 140752 | 19027 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3170 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2x2 | 5999630.40201 | 2115407.06556 | 37.7884820784247 | -122.44511107923 | (37.7884820784247, -122.44511107923) | 13 | 6 | 1 | 29490 | 27 | |||
| 141017 | 10140 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 906 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/19/1991 12:00:00 AM | 8 | 2x2 | 6005653.96599 | 2103626.9979 | 37.7564788166491 | -122.423432668582 | (37.7564788166491, -122.423432668582) | 2 | 4 | 5 | 28859 | 19 | ||
| 142335 | 4464 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1467 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/1992 12:00:00 AM | 6 | 3X3 | 6004576.21057 | 2100336.17551 | 37.7473820968062 | -122.426925564388 | (37.7473820968062, -122.426925564388) | 2 | 7 | 5 | 63 | 22 | ||
| 143881 | 139120 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1501 LAGUNA ST | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6004505.7981 | 2114155.218 | 37.7853218844175 | -122.428153716152 | (37.7853218844175, -122.428153716152) | 13 | 9 | 11 | 29490 | 13 | |||
| 151111 | 212376 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 350x Kensington Way | 3 | Median : Cutout | Tree | DPW 1 | 9 | Width 6ft | 5994225.30573 | 2099058.0744 | 37.7432820399328 | -122.462625309526 | (37.7432820399328, -122.462625309526) | 1 | 8 | 4 | 59 | 40 | |||
| 152550 | 27417 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1368 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6004484.17444 | 2100908.10154 | 37.7489472688119 | -122.427284553046 | (37.7489472688119, -122.427284553046) | 2 | 4 | 5 | 28862 | 22 | |||
| 155689 | 212538 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 200x Terrace Dr | 38 | Median : Yard | Tree | DPW 1 | 6 | 5993893.90506 | 2096479.65009 | 37.736183239558 | -122.463584108238 | (37.736183239558, -122.463584108238) | 1 | 8 | 4 | 59 | 40 | ||||
| 162044 | 247938 | Planning Code 138.1 required 2 | Prunus cerasifera :: Cherry Plum 7 | 29 Joy St | 1 | Unaccepted Street : Yard | Tree | DPW 1 | 9 | Permit Number 775404 | 6010254.90659 | 2098918.71089 | 37.7438095066969 | -122.407189031056 | (37.7438095066969, -122.407189031056) | 2 | 7 | 7 | 28859 | 2 | |||
| 166426 | 28146 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 429 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006920.737469 | 2097958.7102788 | 37.7409864003091 | -122.418649764286 | (37.7409864003091, -122.418649764286) | 2 | 7 | 7 | 28859 | 2 | |||
| 166747 | 4275 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 4215 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002481.0949 | 2100316.71794 | 37.7472099827631 | -122.434168929879 | (37.7472099827631, -122.434168929879) | 2 | 4 | 5 | 63 | 22 | |||
| 166897 | 117840 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 600x 39th Ave | 2 | Median : Cutout | Tree | DPW 1 | 2 | Width 6ft | 5983808.59909 | 2111637.58628 | 37.7772164277829 | -122.499572493795 | (37.7772164277829, -122.499572493795) | 11 | 6 | 2 | 55 | 26 | |||
| 167120 | 476 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1110X Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 2x2 | 6005715.8108342 | 2102491.4524088 | 37.753364362762 | -122.423138074678 | (37.753364362762, -122.423138074678) | 2 | 4 | 5 | 28859 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );