trees
2,306 rows where qSpecies_id = 15 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
42183 | 110954 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 126X Mendell St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/12/2015 12:00:00 AM | 3 | 6017060.74507 | 2098543.22184 | 37.7431570265693 | -122.383629676533 | (37.7431570265693, -122.383629676533) | 10 | 3 | 8 | 58 | 1 | |||
133009 | 110951 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 220 Newhall St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/12/2015 12:00:00 AM | 3 | 6016803.8 | 2098347.9 | 37.7426065069695 | -122.384504531053 | (37.7426065069695, -122.384504531053) | 10 | 3 | 8 | 58 | 1 | |||
141742 | 110952 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 220 Newhall St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/12/2015 12:00:00 AM | 3 | 6016803.8 | 2098347.9 | 37.7426065069695 | -122.384504531053 | (37.7426065069695, -122.384504531053) | 10 | 3 | 8 | 58 | 1 | |||
146688 | 110953 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 220 Newhall St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/12/2015 12:00:00 AM | 3 | 6016803.8 | 2098347.9 | 37.7426065069695 | -122.384504531053 | (37.7426065069695, -122.384504531053) | 10 | 3 | 8 | 58 | 1 | |||
179939 | 194502 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 299 Cashmere St | 17 | : | Tree | Private 2 | 14 | 6016706.5669 | 2095967.54314 | 37.7360651504892 | -122.384674961403 | (37.7360651504892, -122.384674961403) | 10 | 3 | 8 | 58 | 1 | ||||
82515 | 194503 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 299x Cashmere St | 19 | Median : Yard | Tree | DPW 1 | 22 | 6016679.95616 | 2095990.15736 | 37.7361257728833 | -122.384768541244 | (37.7361257728833, -122.384768541244) | 10 | 3 | 8 | 58 | 1 | ||||
90913 | 194504 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 299x Cashmere St | 21 | Median : Yard | Tree | DPW 1 | 24 | 6016665.2898 | 2096001.51106 | 37.7361561367049 | -122.38482004001 | (37.7361561367049, -122.38482004001) | 10 | 3 | 8 | 58 | 1 | ||||
170147 | 194505 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 299x Cashmere St | 25 | Median : Yard | Tree | DPW 1 | 14 | 6016625.92106 | 2096014.83656 | 37.7361905483545 | -122.384957083216 | (37.7361905483545, -122.384957083216) | 10 | 3 | 8 | 58 | 1 | ||||
161 | 194506 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 299x Cashmere St | 26 | Median : Yard | Tree | DPW 1 | 18 | 6016624.93937 | 2096021.78221 | 37.7362095654157 | -122.384960961105 | (37.7362095654157, -122.384960961105) | 10 | 3 | 8 | 58 | 1 | ||||
45780 | 194507 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 299x Cashmere St | 27 | Median : Yard | Tree | DPW 1 | 21 | 6016618.68245 | 2096023.02512 | 37.7362126321093 | -122.384982680622 | (37.7362126321093, -122.384982680622) | 10 | 3 | 8 | 58 | 1 | ||||
2907 | 194508 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 299x Cashmere St | 28 | Median : Yard | Tree | DPW 1 | 23 | 6016611.71691 | 2096022.49532 | 37.7362107920965 | -122.385006726687 | (37.7362107920965, -122.385006726687) | 10 | 3 | 8 | 58 | 1 | ||||
90651 | 200633 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1300x Newcomb Ave | 1 | Median : Cutout | Tree | DPW 1 | 27 | Width 0ft | 6016537.4545 | 2094850.7585 | 37.7329893292565 | -122.385181865916 | (37.7329893292565, -122.385181865916) | 10 | 3 | 8 | 58 | 1 | |||
131534 | 200634 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1300x Newcomb Ave | 8 | Median : Cutout | Tree | DPW 1 | 23 | Width 0ft | 6016413.6949 | 2094834.3971 | 37.7329375570822 | -122.385608599309 | (37.7329375570822, -122.385608599309) | 10 | 3 | 8 | 58 | 1 | |||
15996 | 258691 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 100x Whitney Young Cir | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6016360 | 2096059 | 37.7362970999571 | -122.385879567348 | (37.7362970999571, -122.385879567348) | 10 | 3 | 8 | 58 | 1 | ||||
193595 | 194497 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1800 Illinois St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | Width 7ft | 6016247.03322 | 2100654.64673 | 37.7489095539354 | -122.386590499369 | (37.7489095539354, -122.386590499369) | 10 | 3 | 8 | 58 | 1 | |||
72343 | 194496 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2 Tulare St | 10 | Front Yard : Yard | Tree | Private 2 | 9 | 6016213.72406 | 2100305.90107 | 37.7479501266034 | -122.386681367746 | (37.7479501266034, -122.386681367746) | 3 | 8 | 58 | 1 | |||||
25771 | 194495 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2 Tulare St | 13 | Front Yard : Yard | Tree | Private 2 | 6 | 6016190.05979 | 2100302.20421 | 37.7479386656413 | -122.38676294076 | (37.7479386656413, -122.38676294076) | 3 | 8 | 58 | 1 | |||||
175844 | 116451 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 250X CASHMERE ST | 5 | Median : Yard | Tree | DPW 1 | 6016081 | 2096072 | 37.7363173516773 | -122.386845101275 | (37.7363173516773, -122.386845101275) | 10 | 3 | 8 | 58 | 1 | |||||
132534 | 194509 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 301x Cashmere St | 19 | Median : Yard | Tree | DPW 1 | 17 | 6016049.52573 | 2096064.56744 | 37.7362952006575 | -122.386953403697 | (37.7362952006575, -122.386953403697) | 10 | 3 | 8 | 58 | 1 | ||||
112524 | 194510 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 301x Cashmere St | 20 | Median : Yard | Tree | DPW 1 | 21 | 6016046.84857 | 2096053.13474 | 37.7362636605344 | -122.386961862722 | (37.7362636605344, -122.386961862722) | 10 | 3 | 8 | 58 | 1 | ||||
66472 | 194511 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 301x Cashmere St | 21 | Median : Yard | Tree | DPW 1 | 29 | 6016041.40389 | 2096043.15017 | 37.7362359434412 | -122.386979991251 | (37.7362359434412, -122.386979991251) | 10 | 3 | 8 | 58 | 1 | ||||
72101 | 194513 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 301x Cashmere St | 25 | Median : Yard | Tree | DPW 1 | 21 | 6016035.53821 | 2096012.28902 | 37.7361508801593 | -122.386998119763 | (37.7361508801593, -122.386998119763) | 10 | 3 | 8 | 58 | 1 | ||||
94510 | 194512 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 301x Cashmere St | 23 | Median : Yard | Tree | DPW 1 | 28 | 6016031.37506 | 2096031.1694 | 37.736202491347 | -122.387013830018 | (37.736202491347, -122.387013830018) | 10 | 3 | 8 | 58 | 1 | ||||
51342 | 194514 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 301x Cashmere St | 26 | Median : Yard | Tree | DPW 1 | 22 | 6016024.76116 | 2095911.21448 | 37.7358727531167 | -122.387028333393 | (37.7358727531167, -122.387028333393) | 10 | 3 | 8 | 58 | 1 | ||||
161616 | 194515 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 301x Cashmere St | 27 | Median : Yard | Tree | DPW 1 | 19 | 6016017.13606 | 2095897.09694 | 37.7358335669715 | -122.387053712269 | (37.7358335669715, -122.387053712269) | 10 | 3 | 8 | 58 | 1 | ||||
43756 | 194494 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 3305 03rd St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 10ft | 6016095.96516 | 2099918.62991 | 37.7468802400244 | -122.387061569634 | (37.7468802400244, -122.387061569634) | 3 | 8 | 58 | 1 | ||||
104078 | 194516 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 301x Cashmere St | 28 | Median : Yard | Tree | DPW 1 | 23 | 6016014.59895 | 2095892.62299 | 37.7358211419175 | -122.387062172188 | (37.7358211419175, -122.387062172188) | 10 | 3 | 8 | 58 | 1 | ||||
5905 | 261162 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 595 Newhall St | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 6016024 | 2097656 | 37.7406635379999 | -122.387152626875 | (37.7406635379999, -122.387152626875) | 10 | 3 | 8 | 58 | 1 | |||
115926 | 107644 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1400x KIRKWOOD AVE | 1 | Median : Yard | Tree | Private 2 | 6015822.8 | 2096363.1 | 37.7371023539668 | -122.38775811874 | (37.7371023539668, -122.38775811874) | 10 | 3 | 8 | 58 | 1 | |||||
75570 | 194474 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 601 Illinois St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6016019.39456 | 2106196.24921 | 37.7641130167339 | -122.387764283717 | (37.7641130167339, -122.387764283717) | 14 | 3 | 8 | 310 | 29 | ||||
91085 | 111308 | Private 9 | Pinus radiata :: Monterey Pine 15 | 780x JAMESTOWN AVE | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6x90 | 6015099 | 2088640 | 37.7158561393861 | -122.389721379672 | (37.7158561393861, -122.389721379672) | 10 | 3 | 8 | 58 | 1 | ||||
1428 | 194473 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 851 Indiana St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 32 | Width 8ft | 6014996.92919 | 2104399.34696 | 37.7591224196901 | -122.391175112734 | (37.7591224196901, -122.391175112734) | 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 | |||||
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 | |||||
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 | |||||
85862 | 198801 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 150 Executive Park Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 0 | Width 4ft | 6013745.097 | 2086994.39666 | 37.7112624653484 | -122.394285983735 | (37.7112624653484, -122.394285983735) | 10 | 3 | 8 | 58 | 1 | |||
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 | ||||
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 | ||||
36819 | 201729 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1411 Phelps St | 4 | Side Yard : Yard | Tree | Private 2 | 3 | 6013763.5505 | 2095932.04649 | 37.735804483793 | -122.394847748824 | (37.735804483793, -122.394847748824) | 10 | 3 | 8 | 58 | 1 | ||||
40173 | 201730 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1411 Phelps St | 5 | Side Yard : Yard | Tree | Private 2 | 20 | 6013762.45417 | 2095926.0507 | 37.7357879596321 | -122.39485111951 | (37.7357879596321, -122.39485111951) | 10 | 3 | 8 | 58 | 1 | ||||
124730 | 201731 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1411 Phelps St | 6 | Side Yard : Yard | Tree | Private 2 | 19 | 6013749.92034 | 2095926.84789 | 37.7357894516288 | -122.394894510001 | (37.7357894516288, -122.394894510001) | 10 | 3 | 8 | 58 | 1 | ||||
123320 | 201728 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1411 Phelps St | 3 | Side Yard : Yard | Tree | Private 2 | 18 | 6013736.51011 | 2095944.00479 | 37.7358358152635 | -122.394942076023 | (37.7358358152635, -122.394942076023) | 10 | 3 | 8 | 58 | 1 | ||||
70322 | 194501 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1121 Jamestown Ave | 19 | Sidewalk: Curb side : Yard | Tree | Private 2 | 56 | 6013422.70006 | 2090021.7257 | 37.7195569863524 | -122.395612244507 | (37.7195569863524, -122.395612244507) | 10 | 3 | 8 | 58 | 1 | ||||
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 | ||||
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 | |||||
176 | 194490 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501 22nd St | 19 | Front Yard : Yard | Tree | Private 2 | 29 | 6013346.63868 | 2103825.44695 | 37.7574548949481 | -122.396842409144 | (37.7574548949481, -122.396842409144) | 10 | 3 | 8 | 28856 | 29 | ||||
19052 | 260948 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 370 Drumm St | 1 | Side Yard : Yard | Tree | Private 2 | 6013616 | 2118213 | 37.7969748404412 | -122.396919555024 | (37.7969748404412, -122.396919555024) | 3 | 1 | 10 | 28860 | 6 | |||||
33806 | 194491 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501 22nd St | 21 | Front Yard : Yard | Tree | Private 2 | 24 | 6013319.82421 | 2103789.39675 | 37.7573544163899 | -122.396932617442 | (37.7573544163899, -122.396932617442) | 10 | 3 | 8 | 28856 | 29 | ||||
11046 | 262155 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1800 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013141 | 2101984 | 37.752387232625 | -122.397424456513 | (37.752387232625, -122.397424456513) | 10 | 3 | 8 | 28856 | 29 | ||||
3197 | 261564 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1801 25th St | 9 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 6013134 | 2101730 | 37.751689413587 | -122.397430852298 | (37.751689413587, -122.397430852298) | 10 | 3 | 8 | 28856 | 29 | ||||
5888 | 261561 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1801 25th St | 6 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 6013134 | 2101730 | 37.751689413587 | -122.397430852298 | (37.751689413587, -122.397430852298) | 10 | 3 | 8 | 28856 | 29 | ||||
122038 | 194493 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2098 Jerrold Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 8ft | 6012789.47061 | 2098973.39069 | 37.74410116583 | -122.398428883383 | (37.74410116583, -122.398428883383) | 10 | 3 | 8 | 58 | 1 | |||
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 | ||||
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 | ||||
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 | |||
19174 | 261294 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 801 Wisconsin St | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 6012760.41981 | 2103766.81895 | 37.7572612683759 | -122.398865686828 | (37.7572612683759, -122.398865686828) | 10 | 3 | 8 | 28856 | 29 | |||||
16781 | 260951 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 190 Jackson St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | 6013038 | 2118237 | 37.7970085486816 | -122.398921272101 | (37.7970085486816, -122.398921272101) | 3 | 1 | 10 | 28860 | 6 | ||||
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 | |||||
2030 | 112443 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2199x 25TH ST | 3 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 6012503 | 2101856 | 37.7520002291367 | -122.399621792735 | (37.7520002291367, -122.399621792735) | 10 | 3 | 8 | 28856 | 29 | ||||
8513 | 112444 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2199x 25TH ST | 4 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 6012503 | 2101856 | 37.7520002291367 | -122.399621792735 | (37.7520002291367, -122.399621792735) | 10 | 3 | 8 | 28856 | 29 | ||||
22742 | 112442 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2199x 25TH ST | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | 36 | 6012503 | 2101856 | 37.7520002291367 | -122.399621792735 | (37.7520002291367, -122.399621792735) | 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 | |||
175190 | 173907 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2200 Jerrold Ave | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 6012443 | 2099218 | 37.7447535037256 | -122.399644080592 | (37.7447535037256, -122.399644080592) | 10 | 3 | 8 | 58 | 1 | |||||
142499 | 178250 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 287 Hester Ave | 1 | Side Yard : Yard | Tree | Private 2 | 23 | 6012202.69887 | 2087794.30309 | 37.7133729925439 | -122.399673060362 | (37.7133729925439, -122.399673060362) | 10 | 3 | 8 | 309 | 1 | ||||
28407 | 194476 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 900x Carolina St | 43 | Median : Yard | Tree | DPW 1 | 22 | 6012491.75598 | 2103075.93483 | 37.755349278054 | -122.399746327228 | (37.755349278054, -122.399746327228) | 10 | 3 | 8 | 28856 | 29 | ||||
23171 | 109911 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1062X Carolina St | Median : Cutout | Tree | DPW 1 | 3x3 | 6012455.3 | 2103027.1 | 37.7552131559276 | -122.39986897476 | (37.7552131559276, -122.39986897476) | 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 | ||||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
101480 | 194500 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2147 Revere Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 6012121.08502 | 2096564.86957 | 37.7374506208484 | -122.400570870653 | (37.7374506208484, -122.400570870653) | 10 | 3 | 8 | 58 | 1 | ||||
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 | |||
12343 | 194488 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1401 Rhode Island St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | 6012030.15727 | 2101805.35505 | 37.751834800344 | -122.401253403036 | (37.751834800344, -122.401253403036) | 10 | 3 | 8 | 28856 | 29 | ||||
47218 | 99951 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1160 Battery St | 1 | Front Yard : Yard | Tree | Private 2 | 06/19/2012 12:00:00 AM | Permit Number 768993 | 6012314.3 | 2120017.7 | 37.8018575696458 | -122.401550680127 | (37.8018575696458, -122.401550680127) | 3 | 1 | 10 | 28860 | 6 | |||
104357 | 132204 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 12 Greenwich St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 31 | 6012294.06984 | 2120559.14097 | 37.8033431063468 | -122.401658764365 | (37.8033431063468, -122.401658764365) | 3 | 1 | 10 | 28860 | 6 | ||||
18614 | 132205 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 12 Greenwich St | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 27 | 6012257.5514 | 2120548.1369 | 37.8033108539845 | -122.401784364564 | (37.8033108539845, -122.401784364564) | 3 | 1 | 10 | 28860 | 6 | ||||
84386 | 99192 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1155@Sansome Battery St | 3 | Front Yard : Yard | Tree | Private 2 | Plaza | Permit Number 768022 | 6012245 | 2120028 | 37.8018819838627 | -122.401791216362 | (37.8018819838627, -122.401791216362) | 3 | 1 | 10 | 28860 | 6 | |||
22008 | 132208 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 199 Union St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | 6012099.30323 | 2119801.66278 | 37.8012523849575 | -122.402279475534 | (37.8012523849575, -122.402279475534) | 3 | 1 | 10 | 28860 | 6 | ||||
120974 | 178251 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100x Mansell St | 3 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6011493.79613 | 2090653.71469 | 37.721184815004 | -122.402324215017 | (37.721184815004, -122.402324215017) | 10 | 7 | 8 | 309 | 28 | |||
27030 | 106971 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 3479X San Bruno Ave | 1 | Front Yard : Yard | Tree | Private 2 | 30 | 6011510.60551 | 2091910.03431 | 37.7246353494236 | -122.402354399294 | (37.7246353494236, -122.402354399294) | 10 | 3 | 7 | 309 | 28 | ||||
128716 | 108973 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 3485X SAN BRUNO AVE | 1 | Median : Yard | Tree | DPW for City Agency 14 | 6011510 | 2091910 | 37.724635221414 | -122.402356490066 | (37.724635221414, -122.402356490066) | 10 | 3 | 7 | 309 | 28 | |||||
169770 | 110740 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 3521x SAN BRUNO AVE | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6011510 | 2091910 | 37.724635221414 | -122.402356490066 | (37.724635221414, -122.402356490066) | 10 | 3 | 7 | 309 | 28 | |||||
32649 | 132207 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 199 Union St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6012049.27862 | 2119798.13006 | 37.8012398924644 | -122.40245233511 | (37.8012398924644, -122.40245233511) | 3 | 1 | 10 | 28860 | 6 | ||||
180056 | 132206 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 199 Union St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6012038.33041 | 2119798.95957 | 37.8012415589072 | -122.4024902793 | (37.8012415589072, -122.4024902793) | 3 | 1 | 10 | 28860 | 6 | ||||
149884 | 187543 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1400 Somerset St | 3 | Side Yard : Yard | Tree | Private 2 | 35 | 6011384.82868 | 2088240.10876 | 37.7145514596464 | -122.402531250636 | (37.7145514596464, -122.402531250636) | 9 | 7 | 8 | 309 | 39 | ||||
189389 | 178252 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100x Mansell St | 11 | Median : Cutout | Tree | DPW 1 | 28 | Width 0ft | 6011405.60208 | 2090646.90467 | 37.7211611925117 | -122.402628599549 | (37.7211611925117, -122.402628599549) | 10 | 3 | 8 | 309 | 28 | |||
9862 | 114526 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1 TIOGA AVE | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6011351 | 2088602 | 37.7155432513192 | -122.402673611341 | (37.7155432513192, -122.402673611341) | 9 | 7 | 8 | 309 | 39 | |||||
59395 | 114525 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1 TIOGA AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6011351 | 2088602 | 37.7155432513192 | -122.402673611341 | (37.7155432513192, -122.402673611341) | 9 | 7 | 8 | 309 | 39 | |||||
5017 | 262484 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 10X Alpha St | 2 | Median : Yard | Tree | Private 2 | 3x3 | 6011300 | 2088596 | 37.7155239289484 | -122.402849469545 | (37.7155239289484, -122.402849469545) | 9 | 7 | 8 | 309 | 39 | ||||
16522 | 262483 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 10X Alpha St | 1 | Median : Yard | Tree | Private 2 | 3x3 | 6011300 | 2088596 | 37.7155239289484 | -122.402849469545 | (37.7155239289484, -122.402849469545) | 9 | 7 | 8 | 309 | 39 | ||||
16931 | 194485 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 998 Kansas St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 40 | Width 10ft | 6011603.18064 | 2103745.73679 | 37.7571388318007 | -122.402866411773 | (37.7571388318007, -122.402866411773) | 10 | 3 | 8 | 28856 | 29 | |||
3166 | 194483 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 930 Kansas St | 2 | Front Yard : Yard | Tree | Private 2 | 31 | 6011593.09908 | 2103991.17748 | 37.7578121947052 | -122.402918540071 | (37.7578121947052, -122.402918540071) | 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 | |||||
75494 | 122677 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 300x Ward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6011198.01208 | 2089669.48894 | 37.7184658164103 | -122.403277459492 | (37.7184658164103, -122.403277459492) | 10 | 7 | 8 | 309 | 28 | |||
176210 | 250207 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 212 Union St | 3 | Front Yard : Yard | Tree | Private 2 | 15 | Width 0ft | 6011784.78005 | 2119790.75424 | 37.8012048710537 | -122.403367102114 | (37.8012048710537, -122.403367102114) | 3 | 1 | 10 | 308 | 23 | |||
18878 | 250202 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 203 Union St | 3 | Side Yard : Yard | Tree | Private 2 | 12 | Width 0ft | 6011755.5651 | 2119757.15751 | 37.8011109908426 | -122.403465834184 | (37.8011109908426, -122.403465834184) | 3 | 1 | 10 | 308 | 23 |
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) );