trees
438 rows where qSpecies_id = 63 sorted by Neighborhoods (old)
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) ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8023 | 121696 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 1300x De Haro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012218 | 2102254 | 37.7530771598286 | -122.400635326689 | (37.7530771598286, -122.400635326689) | 10 | 3 | 8 | 28856 | 29 | ||||
| 10043 | 264733 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1367 De Haro St | Median : Cutout | Tree | DPW 1 | 3x3 | 6012260 | 2102130 | 37.7527390251575 | -122.400481372119 | (37.7527390251575, -122.400481372119) | 10 | 3 | 8 | 28856 | 29 | |||||
| 17195 | 194439 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 900x Carolina St | 32 | Median : Yard | Tree | DPW 1 | 12 | 6012481.17054 | 2103301.60211 | 37.7559683209947 | -122.3997987802 | (37.7559683209947, -122.3997987802) | 10 | 3 | 8 | 28856 | 29 | ||||
| 29047 | 194457 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2001 25th St | 32 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | 6012708.71911 | 2101842.22219 | 37.7519738634013 | -122.398909414543 | (37.7519738634013, -122.398909414543) | 10 | 3 | 8 | 28856 | 29 | ||||
| 34697 | 194442 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 900x Carolina St | 51 | Median : Yard | Tree | DPW 1 | 24 | 6012500.2858 | 2102979.92319 | 37.7550861265451 | -122.399710087265 | (37.7550861265451, -122.399710087265) | 10 | 3 | 8 | 28856 | 29 | ||||
| 37115 | 194449 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1300x De Haro St | 23 | Median : Yard | Tree | DPW 1 | 23 | 6012259.688 | 2102130.23115 | 37.7527396424455 | -122.400482467314 | (37.7527396424455, -122.400482467314) | 10 | 3 | 8 | 28856 | 29 | ||||
| 37367 | 194451 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 930 Kansas St | 1 | Front Yard : Yard | Tree | Private 2 | 29 | 6011573.12502 | 2104017.28324 | 37.7578827599862 | -122.402989455212 | (37.7578827599862, -122.402989455212) | 10 | 3 | 8 | 28856 | 29 | ||||
| 40232 | 194448 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1300x De Haro St | 32 | Median : Yard | Tree | DPW 1 | 27 | 6012284.461 | 2102001.80848 | 37.7523884032163 | -122.400387777686 | (37.7523884032163, -122.400387777686) | 10 | 3 | 8 | 28856 | 29 | ||||
| 43289 | 194453 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2250 26th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 6011877.75436 | 2101392.1938 | 37.750691845665 | -122.401751398122 | (37.750691845665, -122.401751398122) | 10 | 3 | 8 | 28856 | 29 | ||||
| 65583 | 194443 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1900 23rd St | 2 | Front Yard : Yard | Tree | Private 2 | 28 | 6012732.21441 | 2102858.09004 | 37.7547645253758 | -122.398899455441 | (37.7547645253758, -122.398899455441) | 10 | 3 | 8 | 28856 | 29 | ||||
| 66190 | 194458 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2001 25th St | 33 | Sidewalk: Property side : Yard | Tree | Private 2 | 26 | 6012757.94703 | 2101850.0059 | 37.7519979787223 | -122.398739722368 | (37.7519979787223, -122.398739722368) | 10 | 3 | 8 | 28856 | 29 | ||||
| 78908 | 194452 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2001 20th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 6011998.43391 | 2104639.55141 | 37.7596151114626 | -122.401562284167 | (37.7596151114626, -122.401562284167) | 10 | 3 | 8 | 28856 | 29 | |||
| 79719 | 194464 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2000 25th St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | 6012478.49596 | 2101876.43729 | 37.7520549795584 | -122.399707966672 | (37.7520549795584, -122.399707966672) | 10 | 3 | 8 | 28856 | 29 | ||||
| 81035 | 194456 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1501 22nd St | 12 | Front Yard : Yard | Tree | Private 2 | 2 | 6013384.43791 | 2103815.09856 | 37.7574285843868 | -122.396710957944 | (37.7574285843868, -122.396710957944) | 10 | 3 | 8 | 28856 | 29 | ||||
| 95523 | 194440 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 900x Carolina St | 33 | Median : Yard | Tree | DPW 1 | 6 | 6012485.2688 | 2103286.14111 | 37.7559260969364 | -122.399783521388 | (37.7559260969364, -122.399783521388) | 10 | 3 | 8 | 28856 | 29 | ||||
| 100087 | 194438 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1051 18th St | 1 | Side Yard : Yard | Tree | Private 2 | 11 | 6014405.25344 | 2105708.40792 | 37.7626839643245 | -122.39331303148 | (37.7626839643245, -122.39331303148) | 10 | 3 | 8 | 28856 | 29 | ||||
| 105080 | 173727 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 958 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3x3 | 6012430 | 2103470 | 37.7564278519739 | -122.399987571177 | (37.7564278519739, -122.399987571177) | 10 | 3 | 8 | 28856 | 29 | |||
| 109147 | 194450 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1300x De Haro St | 21 | Median : Yard | Tree | DPW 1 | 27 | 6012266.91736 | 2102141.9772 | 37.7527722977062 | -122.40045829173 | (37.7527722977062, -122.40045829173) | 10 | 3 | 8 | 28856 | 29 | ||||
| 120848 | 194447 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 680 De Haro St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6012074.20817 | 2105270.47212 | 37.761351707727 | -122.401344555627 | (37.761351707727, -122.401344555627) | 10 | 3 | 8 | 28856 | 29 | ||||
| 128353 | 194455 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1501 22nd St | 11 | Front Yard : Yard | Tree | Private 2 | 8 | 6013406.26386 | 2103790.51305 | 37.757362292666 | -122.396633751156 | (37.757362292666, -122.396633751156) | 10 | 3 | 8 | 28856 | 29 | ||||
| 131381 | 194466 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2000 25th St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | 6012435.9357 | 2101881.1338 | 37.7520655025415 | -122.399855477046 | (37.7520655025415, -122.399855477046) | 10 | 3 | 8 | 28856 | 29 | ||||
| 132354 | 194460 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2000 25th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | 6012680.82829 | 2101890.2153 | 37.7521040879384 | -122.399009233909 | (37.7521040879384, -122.399009233909) | 10 | 3 | 8 | 28856 | 29 | ||||
| 133127 | 194437 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1021 Minnesota St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6015301.57899 | 2103740.56291 | 37.7573304413508 | -122.390075457711 | (37.7573304413508, -122.390075457711) | 10 | 3 | 8 | 28856 | 29 | |||
| 133881 | 194454 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1301 Rhode Island St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6012013.85217 | 2102295.56099 | 37.753179889343 | -122.40134423455 | (37.753179889343, -122.40134423455) | 10 | 3 | 8 | 28856 | 29 | |||
| 140522 | 121695 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 1300x De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012218 | 2102254 | 37.7530771598286 | -122.400635326689 | (37.7530771598286, -122.400635326689) | 10 | 3 | 8 | 28856 | 29 | ||||
| 148743 | 194465 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2000 25th St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | 6012451.33342 | 2101881.30035 | 37.7520668182527 | -122.399802240798 | (37.7520668182527, -122.399802240798) | 10 | 3 | 8 | 28856 | 29 | ||||
| 161957 | 194462 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2000 25th St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | 6012536.20636 | 2101883.40971 | 37.7520773412124 | -122.399508883748 | (37.7520773412124, -122.399508883748) | 10 | 3 | 8 | 28856 | 29 | ||||
| 163675 | 194461 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2000 25th St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 27 | 6012563.25713 | 2101880.94422 | 37.7520720792617 | -122.399415164477 | (37.7520720792617, -122.399415164477) | 10 | 3 | 8 | 28856 | 29 | ||||
| 166032 | 194459 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2001 25th St | 34 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 6012781.55557 | 2101851.76257 | 37.7520041175184 | -122.398658203327 | (37.7520041175184, -122.398658203327) | 10 | 3 | 8 | 28856 | 29 | ||||
| 170052 | 194441 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 900x Carolina St | 39 | Median : Yard | Tree | DPW 1 | 18 | 6012501.46554 | 2103105.94469 | 37.7554322198433 | -122.399714855461 | (37.7554322198433, -122.399714855461) | 10 | 3 | 8 | 28856 | 29 | ||||
| 170429 | 253558 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1240 Wisconsin St | 1 | Front Yard : Yard | Tree | Private 2 | 6012830 | 2101639 | 37.7514226163546 | -122.398475746389 | (37.7514226163546, -122.398475746389) | 10 | 3 | 8 | 28856 | 29 | |||||
| 172636 | 194463 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2000 25th St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 6012509.33056 | 2101878.68569 | 37.7520628720051 | -122.399601493222 | (37.7520628720051, -122.399601493222) | 10 | 3 | 8 | 28856 | 29 | ||||
| 179258 | 121697 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 1300x De Haro St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012218 | 2102254 | 37.7530771598286 | -122.400635326689 | (37.7530771598286, -122.400635326689) | 10 | 3 | 8 | 28856 | 29 | ||||
| 120346 | 98601 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 301 Twin Peaks Blvd | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 24 | 3x3 | 5998661.2 | 2104103.7 | 37.757390562446 | -122.447650343479 | (37.757390562446, -122.447650343479) | 15 | 5 | 5 | 63 | 3 | |||
| 164309 | 233330 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 4053 20th St | 9 | Front Yard : Yard | Tree | Private 2 | 16 | Width 3ft | 6003355.15759 | 2104159.05112 | 37.7578096927712 | -122.431420737491 | (37.7578096927712, -122.431420737491) | 2 | 4 | 5 | 28862 | 3 | |||
| 165845 | 234524 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 671 Church St | 22 | Front Yard : Yard | Tree | Private 2 | 11 | Width 3ft | 6004318.84944 | 2105025.54229 | 37.7602434426069 | -122.4281496397 | (37.7602434426069, -122.4281496397) | 2 | 4 | 5 | 28862 | 3 | |||
| 95203 | 141265 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 52 JORDAN AVE | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 0ft | 5996227.2891 | 2114192.1724 | 37.7849514808139 | -122.456797345759 | (37.7849514808139, -122.456797345759) | 11 | 6 | 1 | 54 | 31 | |||
| 163885 | 115556 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 3897 CLAY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996199 | 2115222 | 37.7877774871206 | -122.456969730492 | (37.7877774871206, -122.456969730492) | 11 | 6 | 1 | 54 | 31 | ||||
| 192071 | 132173 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 91 Mayfair Dr | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 6ft | 5997717.35609 | 2114490.42899 | 37.7858558611085 | -122.45166373929 | (37.7858558611085, -122.45166373929) | 15 | 6 | 1 | 54 | 31 | |||
| 17203 | 107449 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 1130x CHESTNUT ST | 1 | Unaccepted Street : Yard | Tree | Private 2 | 60 | 6006351.9 | 2120450.9 | 37.8027125282147 | -122.422214196597 | (37.8027125282147, -122.422214196597) | 5 | 9 | 1 | 28858 | 32 | ||||
| 17691 | 107448 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1111x Chestnut St | 8 | Unaccepted Street : Yard | Tree | Private 2 | 50 | 6006408.68895 | 2120404.86262 | 37.8025893243113 | -122.422014405358 | (37.8025893243113, -122.422014405358) | 5 | 9 | 1 | 28858 | 32 | ||||
| 22744 | 132175 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1100 Chestnut St | 3 | Front Yard : Yard | Tree | Private 2 | 49 | 6006452.3729 | 2120433.08861 | 37.8026692893229 | -122.421865242911 | (37.8026692893229, -122.421865242911) | 5 | 9 | 1 | 28858 | 32 | ||||
| 71037 | 132174 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1111 Chestnut St | 1 | Front Yard : Yard | Tree | Private 2 | 52 | 6006441.86345 | 2120416.15353 | 37.8026221972261 | -122.42190040729 | (37.8026221972261, -122.42190040729) | 5 | 9 | 1 | 28858 | 32 | ||||
| 103192 | 132176 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2745 Larkin St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6006527.83964 | 2120663.1294 | 37.8033051783476 | -122.421620437537 | (37.8033051783476, -122.421620437537) | 5 | 9 | 1 | 28858 | 32 | ||||
| 103781 | 108605 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 1140x CHESTNUT ST | 2 | Unaccepted Street : Yard | Tree | Private 2 | 6006369.1 | 2120452.7 | 37.8027184407042 | -122.422154803739 | (37.8027184407042, -122.422154803739) | 5 | 9 | 1 | 28858 | 32 | |||||
| 108098 | 132177 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1048 Union St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6007888.26555 | 2119276.18895 | 37.7995736051877 | -122.416814304957 | (37.7995736051877, -122.416814304957) | 5 | 1 | 1 | 308 | 32 | |||
| 115540 | 23580 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 3100X Van Ness Ave | 3 | Median : Cutout | Tree | DPW 1 | 24 | 9 | 6005507.77084 | 2121129.71298 | 37.8045287248816 | -122.425183644115 | (37.8045287248816, -122.425183644115) | 5 | 1 | 1 | 28858 | 32 | |||
| 117514 | 132181 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1302 Columbus Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | 6007227.55341 | 2121889.28804 | 37.8067113282286 | -122.419286081687 | (37.8067113282286, -122.419286081687) | 5 | 1 | 1 | 28858 | 32 | ||||
| 142225 | 23579 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 3100X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 42 | 3x3 | 6005511.92719 | 2121098.11811 | 37.8044422083102 | -122.425167011149 | (37.8044422083102, -122.425167011149) | 5 | 1 | 1 | 28858 | 32 | |||
| 146172 | 132180 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1302 Columbus Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 26 | 6007242.78631 | 2121872.67886 | 37.8066665815484 | -122.419232186229 | (37.8066665815484, -122.419232186229) | 5 | 1 | 1 | 28858 | 32 | ||||
| 185949 | 107450 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1140x Chestnut St | 1 | Unaccepted Street : Yard | Tree | Private 2 | 60 | 6006380.05181 | 2120425.48408 | 37.8026443304364 | -122.422114970234 | (37.8026443304364, -122.422114970234) | 5 | 9 | 1 | 28858 | 32 | ||||
| 187217 | 132182 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 601 Beach St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 5ft | 6007241.65576 | 2121894.78138 | 37.8067272057567 | -122.419237667598 | (37.8067272057567, -122.419237667598) | 5 | 1 | 1 | 28858 | 32 | |||
| 193997 | 132179 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1302 Columbus Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 33 | 6007259.69894 | 2121860.76679 | 37.8066348265036 | -122.419172811197 | (37.8066348265036, -122.419172811197) | 5 | 1 | 1 | 28858 | 32 | ||||
| 60584 | 115235 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 58 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/2016 12:00:00 AM | 3 | 4x6 | Permit Number 777338 | 5989295.30249 | 2114868.10873 | 37.7864069399285 | -122.480829025898 | (37.7864069399285, -122.480829025898) | 11 | 6 | 1 | 55 | 33 | |
| 1588 | 260075 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 171X Gellert Dr | 1 | Median : Yard | Tree | Private 2 | 3x3 | 5985371 | 2094678 | 37.7307416178434 | -122.492918192866 | (37.7307416178434, -122.492918192866) | 1 | 8 | 4 | 64 | 35 | ||||
| 1901 | 262254 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 4210 Ocean Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 785453 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | |||
| 2394 | 184349 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1251 Sunset Blvd | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | Width 0ft | 5984659.3559 | 2106454.1603 | 37.7630340956965 | -122.496246960605 | (37.7630340956965, -122.496246960605) | 1 | 8 | 3 | 56 | 35 | |||
| 11326 | 186595 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1501 Sunset Blvd | 66 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984740.8383 | 2104479.6291 | 37.7576173573885 | -122.49581948315 | (37.7576173573885, -122.49581948315) | 1 | 8 | 3 | 56 | 35 | |||
| 16186 | 186101 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1901 Sunset Blvd | 47 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984808.9821 | 2101715.6546 | 37.7500322370685 | -122.495379978089 | (37.7500322370685, -122.495379978089) | 1 | 8 | 3 | 29491 | 35 | |||
| 16552 | 261549 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 3101 Sunset Blvd | 1 | Median : Cutout | Tree | Private 2 | 3x3 | 5984952 | 2094961 | 37.7314941488449 | -122.494387573147 | (37.7314941488449, -122.494387573147) | 1 | 8 | 4 | 64 | 35 | ||||
| 20177 | 187394 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2100 Sunset Blvd | 47 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 0ft | 5985039.81 | 2100667.7899 | 37.7471685994587 | -122.494504537591 | (37.7471685994587, -122.494504537591) | 1 | 8 | 3 | 29491 | 35 | |||
| 21400 | 186097 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1901 Sunset Blvd | 43 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 0ft | 5984866.2826 | 2101735.8043 | 37.7500909175156 | -122.495183318527 | (37.7500909175156, -122.495183318527) | 1 | 8 | 3 | 29491 | 35 | |||
| 33872 | 186702 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1401 Sunset Blvd | 59 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 0ft | 5984718.4366 | 2105146.0279 | 37.7594457908807 | -122.495946116181 | (37.7594457908807, -122.495946116181) | 1 | 8 | 3 | 56 | 35 | |||
| 34962 | 184744 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1301 Sunset Blvd | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 0ft | 5984688.1718 | 2106200.1767 | 37.7623384159342 | -122.496128558374 | (37.7623384159342, -122.496128558374) | 1 | 8 | 3 | 56 | 35 | |||
| 36915 | 117645 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 2901 21ST AVE | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5989904 | 2095901 | 37.734363711699 | -122.477336418651 | (37.734363711699, -122.477336418651) | 1 | 8 | 4 | 64 | 35 | ||||
| 38282 | 21135 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2292X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5984947.8628076 | 2099601.6268993 | 37.7442358239277 | -122.49474388696 | (37.7442358239277, -122.49474388696) | 1 | 8 | 3 | 29491 | 35 | ||||
| 39844 | 185075 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2801 Sunset Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985040.8539 | 2096108.9226 | 37.7346512389504 | -122.494164969235 | (37.7346512389504, -122.494164969235) | 1 | 8 | 3 | 29491 | 35 | |||
| 41307 | 184977 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2701 Sunset Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5984998.3534 | 2096742.4516 | 37.7363882534207 | -122.494358589298 | (37.7363882534207, -122.494358589298) | 1 | 8 | 3 | 29491 | 35 | |||
| 41594 | 20767 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1692X Sunset Blvd | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 60 | 5984807.4869191 | 2103677.7923597 | 37.7554196391607 | -122.495529849669 | (37.7554196391607, -122.495529849669) | 1 | 8 | 3 | 56 | 35 | |||
| 42716 | 187095 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2600 Sunset Blvd | 31 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5985178.0339 | 2097175.5923 | 37.7375880557056 | -122.493769276198 | (37.7375880557056, -122.493769276198) | 1 | 8 | 3 | 29491 | 35 | |||
| 42969 | 186098 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1901 Sunset Blvd | 44 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 0ft | 5984859.9858 | 2101721.9514 | 37.7500525125937 | -122.495204071455 | (37.7500525125937, -122.495204071455) | 1 | 8 | 3 | 29491 | 35 | |||
| 43488 | 185314 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2601 Sunset Blvd | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5985007.4607 | 2097237.2784 | 37.7377474483668 | -122.494363565845 | (37.7377474483668, -122.494363565845) | 1 | 8 | 3 | 29491 | 35 | |||
| 45383 | 186433 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1601 Sunset Blvd | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 0ft | 5984738.4307 | 2104031.9087 | 37.7563879005336 | -122.495794783817 | (37.7563879005336, -122.495794783817) | 1 | 8 | 3 | 56 | 35 | |||
| 45510 | 185230 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2509 44th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 35 | Width 0ft | 5982693.8052 | 2098008.2989 | 37.7397287878455 | -122.50241990404 | (37.7397287878455, -122.50241990404) | 1 | 8 | 3 | 29491 | 35 | |||
| 49420 | 187123 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2600 Sunset Blvd | 59 | Sidewalk: Property side : Yard | Tree | Private 2 | 37 | Width 0ft | 5985149.3505 | 2097343.9312 | 37.7380485911062 | -122.493880849001 | (37.7380485911062, -122.493880849001) | 1 | 8 | 3 | 29491 | 35 | |||
| 52616 | 184782 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1301 Sunset Blvd | 43 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984677.5396 | 2105882.9212 | 37.7614666984861 | -122.496141923024 | (37.7614666984861, -122.496141923024) | 1 | 8 | 3 | 56 | 35 | |||
| 54785 | 186417 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1601 Sunset Blvd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984727.1251 | 2104191.8612 | 37.7568264235859 | -122.495845680799 | (37.7568264235859, -122.495845680799) | 1 | 8 | 3 | 56 | 35 | |||
| 56295 | 185638 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2100 Sunset Blvd | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 0ft | 5985050.0993 | 2100407.4104 | 37.7464542704067 | -122.494449767525 | (37.7464542704067, -122.494449767525) | 1 | 8 | 3 | 29491 | 35 | |||
| 61393 | 186897 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2700 Sunset Blvd | 46 | Sidewalk: Property side : Yard | Tree | Private 2 | 33 | Width 0ft | 5985183.7588 | 2096592.6965 | 37.7359879144627 | -122.493706542591 | (37.7359879144627, -122.493706542591) | 1 | 8 | 3 | 29491 | 35 | |||
| 63026 | 186711 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1300 Sunset Blvd | 45 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984852.6024 | 2106104.2938 | 37.762084778312 | -122.495552790494 | (37.762084778312, -122.495552790494) | 1 | 8 | 3 | 56 | 35 | |||
| 63898 | 185202 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2500 Sunset Blvd | 55 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 0ft | 5985155.2712 | 2097966.8909 | 37.7397594177965 | -122.493906274966 | (37.7397594177965, -122.493906274966) | 1 | 8 | 3 | 29491 | 35 | |||
| 66936 | 187102 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2600 Sunset Blvd | 38 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 0ft | 5985165.8082 | 2097224.4952 | 37.7377216147142 | -122.493815148362 | (37.7377216147142, -122.493815148362) | 1 | 8 | 3 | 29491 | 35 | |||
| 68325 | 184784 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1301 Sunset Blvd | 45 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984713.613 | 2105863.1758 | 37.7614145960538 | -122.496015705201 | (37.7614145960538, -122.496015705201) | 1 | 8 | 3 | 56 | 35 | |||
| 69152 | 184781 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1301 Sunset Blvd | 42 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984718.1696 | 2105899.6288 | 37.7615149526664 | -122.496002635394 | (37.7615149526664, -122.496002635394) | 1 | 8 | 3 | 56 | 35 | |||
| 72242 | 187396 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2100 Sunset Blvd | 49 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 0ft | 5985054.0302 | 2100695.3416 | 37.74724508117 | -122.494457396667 | (37.74724508117, -122.494457396667) | 1 | 8 | 3 | 29491 | 35 | |||
| 74662 | 21131 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2292X Sunset Blvd | 4 | Median : Cutout | Tree | DPW 1 | 0 | 60 | 5984947.8628076 | 2099601.6268993 | 37.7442358239277 | -122.49474388696 | (37.7442358239277, -122.49474388696) | 1 | 8 | 3 | 29491 | 35 | |||
| 75335 | 185550 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2201 Sunset Blvd | 34 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 0ft | 5984877.5845 | 2099886.0836 | 37.7450127509214 | -122.495007861214 | (37.7450127509214, -122.495007861214) | 1 | 8 | 3 | 29491 | 35 | |||
| 78578 | 185360 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2601 Sunset Blvd | 85 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985022.2207 | 2096895.7045 | 37.7368104416486 | -122.494287364038 | (37.7368104416486, -122.494287364038) | 1 | 8 | 3 | 29491 | 35 | |||
| 79197 | 187345 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2200 Sunset Blvd | 30 | Sidewalk: Property side : Yard | Tree | Private 2 | 29 | Width 0ft | 5985074.9529 | 2099709.2267 | 37.7445387020266 | -122.494312372955 | (37.7445387020266, -122.494312372955) | 1 | 8 | 3 | 29491 | 35 | |||
| 85285 | 20978 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2002X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40 | 5984887.6165706 | 2101567.3225095 | 37.7496295616808 | -122.495097123245 | (37.7496295616808, -122.495097123245) | 1 | 8 | 3 | 29491 | 35 | |||
| 85521 | 187012 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2501 Sunset Blvd | 31 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 0ft | 5984974.837 | 2098002.6963 | 37.7398471711362 | -122.494532769595 | (37.7398471711362, -122.494532769595) | 1 | 8 | 3 | 29491 | 35 | |||
| 86298 | 186102 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1901 Sunset Blvd | 48 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984817.1679 | 2101703.0611 | 37.7499981380626 | -122.495350742926 | (37.7499981380626, -122.495350742926) | 1 | 8 | 3 | 29491 | 35 | |||
| 93032 | 186593 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1501 Sunset Blvd | 64 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984773.0801 | 2104494.2844 | 37.7576594849516 | -122.495709060541 | (37.7576594849516, -122.495709060541) | 1 | 8 | 3 | 56 | 35 | |||
| 95767 | 185659 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2100 Sunset Blvd | 40 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 0ft | 5985060.0587 | 2100566.7616 | 37.7468923883135 | -122.494427074117 | (37.7468923883135, -122.494427074117) | 1 | 8 | 3 | 29491 | 35 | |||
| 101713 | 185705 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2101 Sunset Blvd | 38 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984891.1634 | 2100474.9689 | 37.7466304646766 | -122.495004322509 | (37.7466304646766, -122.495004322509) | 1 | 8 | 3 | 29491 | 35 | |||
| 102199 | 186902 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2700 Sunset Blvd | 51 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 0ft | 5985182.8419 | 2096662.3766 | 37.7361791837873 | -122.493714845671 | (37.7361791837873, -122.493714845671) | 1 | 8 | 3 | 29491 | 35 | |||
| 103634 | 186594 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1501 Sunset Blvd | 65 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 0ft | 5984719.4834 | 2104488.841 | 37.7576414000341 | -122.495894015518 | (37.7576414000341, -122.495894015518) | 1 | 8 | 3 | 56 | 35 | |||
| 106470 | 186343 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1801 Sunset Blvd | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 0ft | 5984811.8118 | 2102790.6052 | 37.7529839215525 | -122.495449463877 | (37.7529839215525, -122.495449463877) | 1 | 8 | 3 | 56 | 35 | |||
| 106870 | 117252 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 2500x 34TH AVE | 2 | Side Yard : Yard | Tree | SFUSD 4 | 3x3 | 5985829 | 2097874 | 37.7395437603018 | -122.491570003273 | (37.7395437603018, -122.491570003273) | 1 | 8 | 3 | 29491 | 35 | ||||
| 109871 | 185295 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2601 Sunset Blvd | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984962.8666 | 2097355.3585 | 37.7380690548117 | -122.494526449097 | (37.7380690548117, -122.494526449097) | 1 | 8 | 3 | 29491 | 35 |
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) );