trees
2,306 rows where qSpecies_id = 15 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
39580 | 255145 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1601x 19th St | 1 | Side Yard : Yard | Tree | Private 2 | 3x3 | 6012900 | 2105148 | 37.7610614650441 | -122.398479874828 | (37.7610614650441, -122.398479874828) | 10 | 3 | 8 | 28856 | 29 | ||||
53862 | 173726 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1101 Connecticut St | 1 | Front Yard : Yard | Tree | Private 2 | 6013424 | 2101939 | 37.7522794251173 | -122.396442635345 | (37.7522794251173, -122.396442635345) | 10 | 3 | 8 | 28856 | 1 | |||||
66713 | 107149 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 612 WISCONSIN ST | 1 | Back Yard : Yard | Tree | Private 2 | 6012651.9 | 2104553.6 | 37.7594155491308 | -122.399296223309 | (37.7594155491308, -122.399296223309) | 10 | 3 | 8 | 28856 | 29 | |||||
67245 | 117626 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 890x VERMONT ST | 3 | Unaccepted Street : Yard | Tree | Private 2 | 6011292 | 2104239 | 37.7584758425658 | -122.403977311201 | (37.7584758425658, -122.403977311201) | 10 | 3 | 8 | 28856 | 29 | |||||
71480 | 112615 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1798x 22ND ST | 2 | Unaccepted Street : Yard | Tree | Private 2 | 05/02/2016 12:00:00 AM | 3 | 6012787 | 2103832 | 37.7574417223043 | -122.398778335858 | (37.7574417223043, -122.398778335858) | 10 | 3 | 8 | 28856 | 29 | |||
75639 | 194492 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 651 Missouri St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 6013622.03607 | 2103861.64748 | 37.7575696187662 | -122.39589250475 | (37.7575696187662, -122.39589250475) | 10 | 3 | 8 | 28856 | 29 | ||||
80477 | 3755 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1050 Carolina St | 1 | Median : Cutout | Tree | DPW 1 | 12 | 18 | 6012450.5971046 | 2103074.0676918 | 37.7553418567665 | -122.399888536822 | (37.7553418567665, -122.399888536822) | 10 | 3 | 8 | 28856 | 29 | |||
87289 | 194489 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1750 22nd St | 12 | Side Yard : Yard | Tree | Private 2 | 23 | 6012793.88135 | 2103795.98527 | 37.7573432171426 | -122.398752009817 | (37.7573432171426, -122.398752009817) | 10 | 3 | 8 | 28856 | 29 | ||||
87763 | 120665 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 2202 22nd St | 1 | Front Yard : Yard | Tree | Private 2 | 6011556 | 2103784 | 37.7572412595444 | -122.403032272766 | (37.7572412595444, -122.403032272766) | 10 | 3 | 8 | 28856 | 29 | |||||
104625 | 194475 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 900x Carolina St | 11 | Median : Yard | Tree | DPW 1 | 18 | 6012465.76971 | 2103588.87642 | 37.7567562548021 | -122.399872213439 | (37.7567562548021, -122.399872213439) | 10 | 3 | 8 | 28856 | 29 | ||||
119966 | 121491 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 400x Vermont St | 2 | Front Yard : Yard | Tree | DPW 1 | 27 | 6011163.8402 | 2106255.16261 | 37.764004612442 | -122.404562472003 | (37.764004612442, -122.404562472003) | 8 | 3 | 8 | 28856 | 29 | ||||
123696 | 194478 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1000 Texas St | 2 | Front Yard : Yard | Tree | Private 2 | 36 | 6013925.61111 | 2102123.62006 | 37.7528142537945 | -122.394720899468 | (37.7528142537945, -122.394720899468) | 10 | 3 | 8 | 28856 | 29 | ||||
128502 | 194480 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1300x De Haro St | 22 | Median : Yard | Tree | DPW 1 | 17 | 6012271.44658 | 2102135.50365 | 37.7527547753262 | -122.400442174093 | (37.7527547753262, -122.400442174093) | 10 | 3 | 8 | 28856 | 29 | ||||
133672 | 194482 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1300x De Haro St | 4 | Median : Yard | Tree | DPW 1 | 18 | 6012279.12158 | 2102212.21544 | 37.752965837218 | -122.40042102024 | (37.752965837218, -122.40042102024) | 10 | 3 | 8 | 28856 | 29 | ||||
141963 | 194484 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2208 25th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 9ft | 6012170.67977 | 2101904.59247 | 37.7521151235314 | -122.400774425017 | (37.7521151235314, -122.400774425017) | 10 | 3 | 8 | 28856 | 29 | |||
155460 | 194481 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1300x De Haro St | 17 | Median : Yard | Tree | DPW 1 | 12 | 6012253.2004 | 2102155.0186 | 37.7528073415893 | -122.400506643765 | (37.7528073415893, -122.400506643765) | 10 | 3 | 8 | 28856 | 29 | ||||
162115 | 110876 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 800 INDIANA ST | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
165623 | 194479 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1300x De Haro St | 26 | Median : Yard | Tree | DPW 1 | 5 | 6012266.00718 | 2102082.8221 | 37.7526098199098 | -122.400457284481 | (37.7526098199098, -122.400457284481) | 10 | 3 | 8 | 28856 | 29 | ||||
170479 | 112441 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2199x 25TH ST | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 30 | 3x3 | 6012503 | 2101856 | 37.7520002291367 | -122.399621792735 | (37.7520002291367, -122.399621792735) | 10 | 3 | 8 | 28856 | 29 | |||
171140 | 110890 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 800 INDIANA ST | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
177252 | 194486 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 889 Vermont St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | 6011300.17955 | 2104194.67138 | 37.7583545830184 | -122.403945903074 | (37.7583545830184, -122.403945903074) | 10 | 3 | 8 | 28856 | 29 | ||||
177655 | 194477 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1000 Texas St | 1 | Front Yard : Yard | Tree | Private 2 | 37 | 6013908.27444 | 2102233.75002 | 37.7531156831575 | -122.394788565357 | (37.7531156831575, -122.394788565357) | 10 | 3 | 8 | 28856 | 29 | ||||
186160 | 194487 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 889 Vermont St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 39 | 6011310.90217 | 2104196.73215 | 37.7583608404945 | -122.403908964334 | (37.7583608404945, -122.403908964334) | 10 | 3 | 8 | 28856 | 29 | ||||
191992 | 94463 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 744 Carolina St | 1 | : | Tree | Private 2 | 06/10/2010 12:00:00 AM | Permit Number 53681 | 6012327.5 | 2104524.9 | 37.7593186601765 | -122.400416148756 | (37.7593186601765, -122.400416148756) | 10 | 3 | 8 | 28856 | 29 | |||
192018 | 110881 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 800 INDIANA ST | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
193251 | 173722 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 928 Carolina St | 1 | Median : Cutout | Tree | DPW 1 | 17 | 3x3 | 6012423 | 2103596 | 37.7567734300957 | -122.400020627969 | (37.7567734300957, -122.400020627969) | 10 | 3 | 8 | 28856 | 29 | |||
44600 | 107186 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 945 Sacramento St | 2 | Front Yard : Yard | Tree | Private 2 | Permit Number 773422 | 6010352.63458 | 2116759.0624 | 37.7928004918921 | -122.408109042355 | (37.7928004918921, -122.408109042355) | 3 | 1 | 10 | 28857 | 4 | ||||
150077 | 107187 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 945 Sacramento St | 3 | Front Yard : Yard | Tree | Private 2 | Permit Number 773422 | 6010352.63458 | 2116759.0624 | 37.7928004918921 | -122.408109042355 | (37.7928004918921, -122.408109042355) | 3 | 1 | 10 | 28857 | 4 | ||||
22 | 262394 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 66 Cleary Ct | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 11/13/2020 12:00:00 AM | 3 | 3x3 | 6004824 | 2113713 | 37.7841256623529 | -122.427021325889 | (37.7841256623529, -122.427021325889) | 13 | 9 | 11 | 28858 | 41 | ||
9602 | 98360 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 807 Francisco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | Permit Number 768654 | 6007370.5 | 2120864.5 | 37.8039055703948 | -122.418718664572 | (37.8039055703948, -122.418718664572) | 5 | 1 | 1 | 28858 | 32 | ||||
14690 | 132193 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 24 Priest St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 10ft | 6008345.5033 | 2117049.6207 | 37.7934857075452 | -122.415074404558 | (37.7934857075452, -122.415074404558) | 5 | 1 | 10 | 28858 | 21 | |||
81078 | 114978 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1 PETER YORKE WAY | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6005775 | 2114336 | 37.7858899958642 | -122.423775516058 | (37.7858899958642, -122.423775516058) | 13 | 9 | 1 | 28858 | 41 | ||||
82842 | 85282 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 1283 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49571 | 6006751 | 2119761 | 37.8008407409326 | -122.42078409851 | (37.8008407409326, -122.42078409851) | 5 | 1 | 1 | 28858 | 32 | ||||
94458 | 85283 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 1283 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49571 | 6006751 | 2119761 | 37.8008407409326 | -122.42078409851 | (37.8008407409326, -122.42078409851) | 5 | 1 | 1 | 28858 | 32 | ||||
103238 | 121134 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1050 North Point St | 2 | Front Yard : Yard | Tree | Private 2 | 3x10 | 6005628 | 2121390 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | 5 | 1 | 1 | 28858 | 32 | ||||
103446 | 50960 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 65 Montclair Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47453 | 6007264.23528351 | 2120370.2610527 | 37.8025425319574 | -122.41905132385 | (37.8025425319574, -122.41905132385) | 5 | 1 | 1 | 28858 | 32 | ||||
116546 | 95242 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 2620 Larkin St | Front Yard : Yard | Tree | Private 2 | 37 | Permit Number 56959 | 6006630 | 2120172 | 37.801962421987 | -122.421232011572 | (37.801962421987, -122.421232011572) | 5 | 9 | 1 | 28858 | 32 | ||||
120537 | 250021 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1 Peter Yorke Way | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | 6005906.53716 | 2114478.71267 | 37.7862892740647 | -122.423330582061 | (37.7862892740647, -122.423330582061) | 13 | 9 | 1 | 28858 | 41 | ||||
141789 | 23558 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2900X Van Ness Ave | 7 | Median : Cutout | Tree | DPW 1 | 30 | 9x200 | 6005648.5023441 | 2120304.1415398 | 37.8022698669467 | -122.424637865654 | (37.8022698669467, -122.424637865654) | 5 | 9 | 1 | 28858 | 32 | |||
149198 | 132194 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 24 Priest St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | Width 10ft | 6008339.23292 | 2117055.47626 | 37.7935014331032 | -122.415096515291 | (37.7935014331032, -122.415096515291) | 5 | 1 | 10 | 28858 | 21 | |||
151937 | 251657 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1050 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6005628 | 2121390 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | 5 | 1 | 1 | 28858 | 32 | ||||
157788 | 251660 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1050 North Point St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6005628 | 2121390 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | 5 | 1 | 1 | 28858 | 32 | ||||
163986 | 121133 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1050 North Point St | 1 | Front Yard : Yard | Tree | Private 2 | 20 | 3x10 | 6005628 | 2121390 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | 5 | 1 | 1 | 28858 | 32 | |||
165293 | 132200 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1151 Lombard St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 35 | 6006710.22294 | 2120090.22803 | 37.801742419238 | -122.420948592699 | (37.801742419238, -122.420948592699) | 5 | 1 | 1 | 28858 | 32 | ||||
165494 | 132199 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2836 Larkin St | 14 | Side Yard : Yard | Tree | Private 2 | 17 | 6006498.02761 | 2121046.57665 | 37.8043563455331 | -122.42175085544 | (37.8043563455331, -122.42175085544) | 5 | 9 | 1 | 28858 | 32 | ||||
166062 | 115436 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1 PETER YORKE WAY | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6005775 | 2114336 | 37.7858899958642 | -122.423775516058 | (37.7858899958642, -122.423775516058) | 13 | 9 | 1 | 28858 | 41 | ||||
167645 | 132197 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 24 Priest St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 10ft | 6008332.13215 | 2117158.10141 | 37.7937828174649 | -122.415128352216 | (37.7937828174649, -122.415128352216) | 5 | 1 | 10 | 28858 | 21 | |||
172756 | 132198 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2836 Larkin St | 13 | Side Yard : Yard | Tree | Private 2 | 24 | 6006512.51972 | 2121038.28328 | 37.8043343912759 | -122.421700114783 | (37.8043343912759, -122.421700114783) | 5 | 9 | 1 | 28858 | 32 | ||||
174269 | 132196 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 24 Priest St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 10ft | 6008335.46638 | 2117136.84644 | 37.7937246439237 | -122.415115310227 | (37.7937246439237, -122.415115310227) | 5 | 1 | 10 | 28858 | 21 | |||
182174 | 115437 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1 PETER YORKE WAY | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6005775 | 2114336 | 37.7858899958642 | -122.423775516058 | (37.7858899958642, -122.423775516058) | 13 | 9 | 1 | 28858 | 41 | ||||
185680 | 132195 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 24 Priest St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 10ft | 6008338.31576 | 2117104.3343 | 37.7936355337159 | -122.415103148693 | (37.7936355337159, -122.415103148693) | 5 | 1 | 10 | 28858 | 21 | |||
342 | 115652 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 18 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
3176 | 233293 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 200 Eugenia Ave | 32 | Front Yard : Yard | Tree | Private 2 | 24 | Width 10ft | 6006620.44914 | 2098098.60188 | 37.7413536002823 | -122.419697976596 | (37.7413536002823, -122.419697976596) | 2 | 7 | 7 | 28859 | 2 | |||
4672 | 246634 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 3320 Harrison St | 5 | Front Yard : Yard | Tree | Private 2 | 3 | 6009032.675 | 2099260.65572 | 37.7446799344495 | -122.411439388921 | (37.7446799344495, -122.411439388921) | 2 | 7 | 7 | 28859 | 2 | ||||
6334 | 104866 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 411 Holladay Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6010309.7 | 2098610.5 | 37.7429662928376 | -122.406977848202 | (37.7429662928376, -122.406977848202) | 10 | 7 | 7 | 28859 | 2 | |||||
8163 | 82435 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 51 Peralta Ave | 1 | Front Yard : Yard | Tree | Private 2 | 04/02/2005 12:00:00 AM | 20 | 6010636.52703341 | 2100363.58782589 | 37.7477981742678 | -122.405971235802 | (37.7477981742678, -122.405971235802) | 2 | 7 | 7 | 28859 | 2 | |||
9066 | 260960 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1001 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
15458 | 233324 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 25 Stoneman St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | Width 3ft | 6008213.5814 | 2099395.52315 | 37.745004274037 | -122.414281204321 | (37.745004274037, -122.414281204321) | 2 | 7 | 7 | 28859 | 2 | |||
16107 | 262406 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2827 Cesar Chavez St | 1 | Back Yard : Yard | Tree | DPW 1 | 3x3 | 6010428 | 2100696 | 37.7486992403688 | -122.406715738075 | (37.7486992403688, -122.406715738075) | 2 | 4 | 7 | 28859 | 2 | ||||
18320 | 261763 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 315 Montcalm St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6009577 | 2099558 | 37.7455268923792 | -122.409578193595 | (37.7455268923792, -122.409578193595) | 2 | 7 | 7 | 28859 | 2 | ||||
19314 | 114270 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 27x ESMERALDA AVE | 2 | Unaccepted Street : Yard | Tree | Private 2 | 3x3 | 6006799 | 2098981 | 37.743786524331 | -122.41914318493 | (37.743786524331, -122.41914318493) | 2 | 7 | 7 | 28859 | 2 | ||||
22171 | 251481 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 32 Peralta Ave | 1 | Back Yard : Yard | Tree | DPW 1 | 3x3 | 6010779 | 2100499 | 37.7481779538542 | -122.405488104269 | (37.7481779538542, -122.405488104269) | 2 | 7 | 7 | 28859 | 2 | ||||
22273 | 106336 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 112 EUGENIA AVE | 1 | Front Yard : Yard | Tree | Private 2 | 18 | 6006345.6 | 2098165.7 | 37.7415223501304 | -122.420653072553 | (37.7415223501304, -122.420653072553) | 2 | 7 | 7 | 28859 | 2 | ||||
22835 | 247950 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 7 Joy St | 3 | Side Yard : Yard | Tree | Private 2 | 21 | 6010415.94161 | 2098863.8955 | 37.7436680064781 | -122.406628345115 | (37.7436680064781, -122.406628345115) | 2 | 7 | 7 | 28859 | 2 | ||||
23374 | 122536 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 199x Coso Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | 3x3 | 6007478 | 2099565 | 37.7454282725128 | -122.416836723884 | (37.7454282725128, -122.416836723884) | 2 | 7 | 7 | 28859 | 2 | |||
23834 | 107210 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 603 PERALTA AVE | 1 | unknown : Yard | Tree | Private 2 | 30 | 6009839.9 | 2098688.7 | 37.7431547125392 | -122.408607810015 | (37.7431547125392, -122.408607810015) | 10 | 7 | 7 | 28859 | 2 | ||||
24524 | 107157 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 301X Esmeralda Ave | 1 | Unaccepted Street : Yard | Tree | Private 2 | 28 | 6007313 | 2098782 | 37.7432690474632 | -122.417351790512 | (37.7432690474632, -122.417351790512) | 2 | 7 | 7 | 28859 | 2 | ||||
24981 | 115647 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 13 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
27745 | 115653 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 19 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
28400 | 99274 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 16 Joy St | 1 | Unaccepted Street : Yard | Tree | Private 2 | 3x3 | Permit Number 768828 | 6010347.9 | 2098933.4 | 37.7438550437031 | -122.406868515265 | (37.7438550437031, -122.406868515265) | 2 | 7 | 7 | 28859 | 2 | |||
29224 | 116662 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 199x Esmeralda Ave | 15 | Unaccepted Street : Yard | Tree | DPW 1 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 2 | 7 | 7 | 28859 | 2 | |||||
30323 | 122488 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 69x Bonview St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007716 | 2099172 | 37.7443625662885 | -122.415985930063 | (37.7443625662885, -122.415985930063) | 2 | 7 | 7 | 28859 | 2 | ||||
30517 | 246697 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1 Bonview St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | 6007653.37008 | 2099025.40867 | 37.7439565377568 | -122.416192111692 | (37.7439565377568, -122.416192111692) | 2 | 7 | 7 | 28859 | 2 | ||||
34757 | 233287 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1101 San Jose Ave | 19 | Front Yard : Yard | Tree | Private 2 | 30 | 6004859.80634 | 2096436.65002 | 37.7366909194596 | -122.425667408317 | (37.7366909194596, -122.425667408317) | 2 | 7 | 5 | 28859 | 2 | ||||
34903 | 246701 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1 Bonview St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 6007685.33931 | 2099084.9994 | 37.744121958161 | -122.416085788444 | (37.744121958161, -122.416085788444) | 2 | 7 | 7 | 28859 | 2 | ||||
35487 | 233299 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 130 Ripley St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 5ft | 6008878.43402 | 2099079.16382 | 37.7441729452414 | -122.411959903051 | (37.7441729452414, -122.411959903051) | 2 | 7 | 7 | 28859 | 2 | |||
36364 | 115642 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 8 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
36919 | 248060 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 18 Rutledge St | 2 | Side Yard : Yard | Tree | Private 2 | 25 | 6010688.17391 | 2099371.02846 | 37.7450757107928 | -122.405722740422 | (37.7450757107928, -122.405722740422) | 2 | 7 | 7 | 28859 | 2 | ||||
36955 | 246780 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 400 Franconia St | 1 | Front Yard : Yard | Tree | Private 2 | 6 | Width 8ft | 6009966.07903 | 2098719.00081 | 37.7432449779722 | -122.4081736511 | (37.7432449779722, -122.4081736511) | 10 | 7 | 7 | 28859 | 2 | |||
39842 | 108688 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1x MONTEZUMA ST | 1 | Median : Yard | Tree | DPW 1 | 20 | 6007361 | 2099793 | 37.7460477277002 | -122.417257445993 | (37.7460477277002, -122.417257445993) | 2 | 7 | 7 | 28859 | 2 | ||||
41989 | 69895 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 51x PRENTISS ST | 2 | Back Yard : Yard | Tree | DPW 1 | 03/29/2003 12:00:00 AM | 12 | 6008906.8 | 2098323.8 | 37.7421004736884 | -122.411808454692 | (37.7421004736884, -122.411808454692) | 10 | 7 | 7 | 28859 | 2 | |||
44435 | 247995 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 344 Peralta Ave | 1 | Side Yard : Yard | Tree | Private 2 | 26 | 6009760.7197 | 2099297.4948 | 37.7448218951314 | -122.408924540052 | (37.7448218951314, -122.408924540052) | 2 | 7 | 7 | 28859 | 2 | ||||
48966 | 233291 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 200 Eugenia Ave | 26 | Front Yard : Yard | Tree | Private 2 | 19 | 6006658.33782 | 2098054.03623 | 37.7412333672335 | -122.419563809422 | (37.7412333672335, -122.419563809422) | 2 | 7 | 7 | 28859 | 2 | ||||
50881 | 255163 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1599X Shotwell St | 1 | Unaccepted Street : Yard | Tree | DPW 1 | 3x3 | 6008036 | 2099273 | 37.744657875903 | -122.414886580728 | (37.744657875903, -122.414886580728) | 2 | 7 | 7 | 28859 | 2 | ||||
51208 | 255164 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1599X Shotwell St | 2 | Unaccepted Street : Yard | Tree | DPW 1 | 3x3 | 6008036 | 2099273 | 37.744657875903 | -122.414886580728 | (37.744657875903, -122.414886580728) | 2 | 7 | 7 | 28859 | 2 | ||||
55232 | 248191 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 216 Esmeralda Ave | 10 | Side Yard : Yard | Tree | Private 2 | 33 | 6007363.38842 | 2098751.31764 | 37.7431876354122 | -122.417175386353 | (37.7431876354122, -122.417175386353) | 2 | 7 | 7 | 28859 | 2 | ||||
61216 | 116672 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 Esmeralda Ave | 9 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
61637 | 115638 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 4 | Back Yard : Cutout | Tree | DPW 1 | 7 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | |||
65231 | 246636 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 3320 Harrison St | 7 | Front Yard : Yard | Tree | Private 2 | 3 | 6009041.33777 | 2099257.70983 | 37.7446723315695 | -122.41140922656 | (37.7446723315695, -122.41140922656) | 2 | 7 | 7 | 28859 | 2 | ||||
65302 | 233285 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 160 Coso Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | 6007499.54933 | 2099576.48274 | 37.7454610136217 | -122.4167630229 | (37.7454610136217, -122.4167630229) | 2 | 7 | 7 | 28859 | 2 | ||||
65769 | 248188 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 216 Esmeralda Ave | 7 | Side Yard : Yard | Tree | Private 2 | 33 | 6007407.05518 | 2098723.69858 | 37.7431142561228 | -122.417022441339 | (37.7431142561228, -122.417022441339) | 2 | 7 | 7 | 28859 | 2 | ||||
67492 | 248226 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 71 Fair Ave | 3 | Side Yard : Yard | Tree | Private 2 | 22 | 6007119.30754 | 2099366.98982 | 37.7448643988822 | -122.418062992935 | (37.7448643988822, -122.418062992935) | 2 | 7 | 7 | 28859 | 2 | ||||
67651 | 115641 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 7 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
69931 | 115646 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 12 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
75594 | 247633 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1021 Jarboe Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6009448.12486 | 2096877.0279 | 37.7381583054592 | -122.409834613477 | (37.7381583054592, -122.409834613477) | 10 | 7 | 7 | 28859 | 2 | ||||
78837 | 107619 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 51X Prentiss St | 3 | Back Yard : Yard | Tree | DPW 1 | 12 | 6008906.75623 | 2098323.8391 | 37.7421005785929 | -122.411808608798 | (37.7421005785929, -122.411808608798) | 10 | 7 | 7 | 28859 | 2 | ||||
81067 | 247834 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 88 Nevada St | 3 | Front Yard : Yard | Tree | Private 2 | 3 | 6009033.70891 | 2098154.01776 | 37.7416414076319 | -122.41135765044 | (37.7416414076319, -122.41135765044) | 10 | 7 | 7 | 28859 | 2 | ||||
81979 | 122487 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 69x Bonview St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007716 | 2099172 | 37.7443625662885 | -122.415985930063 | (37.7443625662885, -122.415985930063) | 2 | 7 | 7 | 28859 | 2 | ||||
82655 | 115645 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 11 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
85873 | 97535 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 300 Winfield St | 1 | Unaccepted Street : Yard | Tree | Private 2 | 6006649.9 | 2098038.3 | 37.7411896837785 | -122.419591868256 | (37.7411896837785, -122.419591868256) | 2 | 7 | 7 | 28859 | 2 |
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) );