trees
395 rows where qSpecies_id = 35 sorted by PermitNotes
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 111520 | 178143 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 14 | : | Tree | Private 2 | 5 | Width 0ft | 5991964.10718 | 2087949.4813 | 37.7126501183836 | -122.4696353549 | (37.7126501183836, -122.4696353549) | 9 | 8 | 4 | 64 | 24 | |||
| 112575 | 8469 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1900 Geary Blvd | 6 | Median : Cutout | Tree | DPW 1 | 48 | 8 | 6002244.0904 | 2113695.2 | 37.7839305664786 | -122.435945599699 | (37.7839305664786, -122.435945599699) | 13 | 5 | 11 | 29490 | 41 | |||
| 112823 | 211025 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Junipero Serra Blvd | 95 | : | Tree | Private 2 | 6 | Width 0ft | 5991234.71561 | 2092082.53367 | 37.7239562818437 | -122.472457461651 | (37.7239562818437, -122.472457461651) | 9 | 8 | 4 | 64 | 40 | |||
| 113256 | 8561 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/1994 12:00:00 AM | 6 | 3X3 | 6001214.79121 | 2113518.75863 | 37.7833875775095 | -122.439493935571 | (37.7833875775095, -122.439493935571) | 15 | 5 | 11 | 29490 | 13 | ||
| 113773 | 111508 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 800x BOSWORTH ST | 3 | Front Yard : Yard | Tree | DPW 1 | 18 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | ||||
| 113834 | 243114 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 17 | Median : Yard | Tree | DPW 1 | 05/01/2017 12:00:00 AM | 3 | 6001830.21459 | 2098656.61242 | 37.7426147609522 | -122.436300830338 | (37.7426147609522, -122.436300830338) | 2 | 7 | 5 | 63 | 7 | |||
| 114736 | 185930 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2000 Sunset Blvd | 73 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985039.332 | 2101497.8374 | 37.7494476553955 | -122.494567371863 | (37.7494476553955, -122.494567371863) | 1 | 8 | 3 | 29491 | 35 | |||
| 115061 | 243111 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 13 | Median : Yard | Tree | DPW 1 | 05/01/2017 12:00:00 AM | 3 | 6001795.3662 | 2098698.75734 | 37.7427285009166 | -122.436424341429 | (37.7427285009166, -122.436424341429) | 2 | 7 | 5 | 63 | 7 | |||
| 116060 | 8575 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 2 | Median : Cutout | Tree | DPW 1 | 48 | 6 | 6001093.7947 | 2113474.2106 | 37.7832583731226 | -122.439909339764 | (37.7832583731226, -122.439909339764) | 15 | 5 | 11 | 29490 | 41 | |||
| 116100 | 185960 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2001 Sunset Blvd | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984855.8243 | 2101346.8117 | 37.7490222380818 | -122.495190801303 | (37.7490222380818, -122.495190801303) | 1 | 8 | 3 | 29491 | 35 | |||
| 117654 | 178148 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 19 | : | Tree | Private 2 | 5 | Width 0ft | 5991783.61367 | 2087988.33952 | 37.7127463800143 | -122.470262019583 | (37.7127463800143, -122.470262019583) | 9 | 8 | 4 | 64 | 24 | |||
| 118418 | 200613 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 54 | Median : Cutout | Tree | DPW 1 | 15 | Width 0ft | 6016431.4971 | 2095119.9571 | 37.7337226328106 | -122.385566946165 | (37.7337226328106, -122.385566946165) | 10 | 3 | 8 | 58 | 1 | |||
| 119256 | 181538 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1300 Sunset Blvd | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984897.5768 | 2105857.4141 | 37.761409549185 | -122.495379035532 | (37.761409549185, -122.495379035532) | 1 | 8 | 3 | 56 | 35 | |||
| 119669 | 185964 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2001 Sunset Blvd | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984823.122 | 2101326.4259 | 37.7489643495953 | -122.495302381208 | (37.7489643495953, -122.495302381208) | 1 | 8 | 3 | 29491 | 35 | |||
| 120441 | 234471 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1350 Noe St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6003196.85258 | 2100348.13678 | 37.7473368492221 | -122.431696139568 | (37.7473368492221, -122.431696139568) | 2 | 4 | 5 | 63 | 22 | ||||
| 121416 | 185539 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2201 Sunset Blvd | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984878.3804 | 2100042.8891 | 37.7454433428019 | -122.495016669314 | (37.7454433428019, -122.495016669314) | 1 | 8 | 3 | 29491 | 35 | |||
| 121908 | 178144 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 15 | : | Tree | Private 2 | 4 | Width 0ft | 5991934.88004 | 2087954.77106 | 37.7126629535013 | -122.469736757058 | (37.7126629535013, -122.469736757058) | 9 | 8 | 4 | 64 | 24 | |||
| 122237 | 178153 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 8 | : | Tree | Private 2 | 7 | Width 0ft | 5993495.89449 | 2087748.40295 | 37.7121864189299 | -122.464326467118 | (37.7121864189299, -122.464326467118) | 9 | 8 | 4 | 64 | 24 | |||
| 122378 | 101036 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1010X Portola Dr | 10 | Front Yard : Yard | Tree | DPW 1 | 04/11/2013 12:00:00 AM | 3 | 5995923.3 | 2098391.5 | 37.7415494342357 | -122.45670592621 | (37.7415494342357, -122.45670592621) | 1 | 7 | 4 | 59 | 40 | |||
| 122774 | 200572 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 42 | Median : Cutout | Tree | DPW 1 | 18 | Width 0ft | 6016330.8681 | 2095450.735 | 37.7346253143087 | -122.385937902813 | (37.7346253143087, -122.385937902813) | 10 | 3 | 8 | 58 | 1 | |||
| 122803 | 8535 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2100 Geary Blvd | 6 | Median : Cutout | Tree | DPW 1 | 18 | 6 | 6001300.5704 | 2113502.1304 | 37.7833468021346 | -122.439195981768 | (37.7833468021346, -122.439195981768) | 15 | 5 | 11 | 29490 | 41 | |||
| 122904 | 96844 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 417 Dewey Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5995136 | 2100316.9 | 37.7467908665237 | -122.459567540316 | (37.7467908665237, -122.459567540316) | 1 | 8 | 4 | 59 | 40 | |||||
| 123187 | 211017 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Junipero Serra Blvd | 49 | : | Tree | Private 2 | 5 | Width 0ft | 5991258.9422 | 2092457.39845 | 37.7249869696545 | -122.472401030094 | (37.7249869696545, -122.472401030094) | 9 | 8 | 4 | 64 | 40 | |||
| 123530 | 186167 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1700 Sunset Blvd | 52 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984926.5892 | 2103481.0156 | 37.7548863180592 | -122.495103454208 | (37.7548863180592, -122.495103454208) | 1 | 8 | 3 | 56 | 35 | |||
| 123901 | 211026 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Junipero Serra Blvd | 138 | : | Tree | Private 2 | 4 | Width 0ft | 5991196.61305 | 2091604.80622 | 37.7226423552448 | -122.472554361808 | (37.7226423552448, -122.472554361808) | 9 | 8 | 4 | 64 | 40 | |||
| 124888 | 2268 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 750X Brotherhood Way | 2 | Median : Cutout | Tree | DPW 1 | 6 | 14M | 5991074.0426161 | 2088106.2478104 | 37.7130290777882 | -122.47272309172 | (37.7130290777882, -122.47272309172) | 1 | 8 | 4 | 64 | 14 | |||
| 125264 | 8348 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1300 Geary Blvd | 14 | Median : Cutout | Tree | DPW 1 | 06/08/1994 12:00:00 AM | 6 | 6 | 6005496.3592183 | 2114176.6024527 | 37.7854365962768 | -122.424728193484 | (37.7854365962768, -122.424728193484) | 13 | 9 | 11 | 28858 | 13 | ||
| 126371 | 8532 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2100 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 06/10/1994 12:00:00 AM | 6 | 6 | 6001535.4351 | 2113580.6442 | 37.7835757427727 | -122.438389071264 | (37.7835757427727, -122.438389071264) | 15 | 5 | 11 | 29490 | 41 | ||
| 126959 | 211020 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Junipero Serra Blvd | 74 | : | Tree | Private 2 | 4 | Width 0ft | 5991248.48231 | 2092260.69315 | 37.7244462603628 | -122.472422854829 | (37.7244462603628, -122.472422854829) | 9 | 8 | 4 | 64 | 40 | |||
| 127126 | 8475 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1900 Geary Blvd | 12 | Median : Cutout | Tree | DPW 1 | 06/03/1994 12:00:00 AM | 6 | 8 | 6001831.8926 | 2113645.1136 | 37.7837696172579 | -122.437368062109 | (37.7837696172579, -122.437368062109) | 13 | 5 | 11 | 29490 | 41 | ||
| 127400 | 187193 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2301 Sunset Blvd | 55 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984945.2043 | 2099085.395 | 37.7428182353231 | -122.494715027467 | (37.7428182353231, -122.494715027467) | 1 | 8 | 3 | 29491 | 35 | |||
| 127523 | 243106 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 9 | Median : Yard | Tree | DPW 1 | 01/09/2018 12:00:00 AM | 3 | 6001667.33897 | 2098826.57882 | 37.7430721930381 | -122.436876170699 | (37.7430721930381, -122.436876170699) | 2 | 7 | 5 | 63 | 7 | |||
| 128412 | 105268 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 842X GONZALEZ DR | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988421 | 2089827 | 37.7175998975755 | -122.482018759302 | (37.7175998975755, -122.482018759302) | 1 | 8 | 4 | 64 | 14 | ||||
| 128912 | 184982 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2701 Sunset Blvd | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984985.373 | 2096691.786 | 37.7362483795762 | -122.494399733702 | (37.7362483795762, -122.494399733702) | 1 | 8 | 3 | 29491 | 35 | |||
| 129439 | 4367 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 973 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6001101.12966 | 2096102.69208 | 37.7355608412513 | -122.438638832041 | (37.7355608412513, -122.438638832041) | 2 | 7 | 5 | 63 | 7 | |||
| 129810 | 132163 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 150 Lombard St | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 5ft | 6011528.08163 | 2120803.57488 | 37.8039714887622 | -122.404326723704 | (37.8039714887622, -122.404326723704) | 3 | 1 | 10 | 28860 | 6 | |||
| 129835 | 194424 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 132 Kissling St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 5ft | 6007931.05098 | 2109095.29996 | 37.7716217631679 | -122.415944902456 | (37.7716217631679, -122.415944902456) | 8 | 2 | 9 | 28853 | 19 | |||
| 130337 | 186855 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2700 Sunset Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985186.2801 | 2096278.9071 | 37.7351264799029 | -122.49367471051 | (37.7351264799029, -122.49367471051) | 1 | 8 | 3 | 29491 | 35 | |||
| 130934 | 185700 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2101 Sunset Blvd | 32 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984899.9898 | 2100515.832 | 37.7467431803198 | -122.494976814737 | (37.7467431803198, -122.494976814737) | 1 | 8 | 3 | 29491 | 35 | |||
| 131403 | 200571 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 41 | Median : Cutout | Tree | DPW 1 | 17 | Width 0ft | 6016326.461 | 2095462.4873 | 37.7346573398722 | -122.385953958726 | (37.7346573398722, -122.385953958726) | 10 | 3 | 8 | 58 | 1 | |||
| 133124 | 178162 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 17 | : | Tree | Private 2 | 5 | Width 0ft | 5993072.48922 | 2087856.39417 | 37.7124585223038 | -122.465797709423 | (37.7124585223038, -122.465797709423) | 9 | 8 | 4 | 64 | 24 | |||
| 133229 | 194425 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 132 Kissling St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 5ft | 6007938.01013 | 2109107.31213 | 37.771655137004 | -122.415921681048 | (37.771655137004, -122.415921681048) | 8 | 2 | 9 | 28853 | 19 | |||
| 133423 | 186893 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2700 Sunset Blvd | 42 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985181.9251 | 2096557.8565 | 37.7358921458374 | -122.493710315825 | (37.7358921458374, -122.493710315825) | 1 | 8 | 3 | 29491 | 35 | |||
| 133693 | 211016 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Junipero Serra Blvd | 46 | : | Tree | Private 2 | 3 | Width 0ft | 5991242.43895 | 2092472.66575 | 37.7250279346749 | -122.472459191965 | (37.7250279346749, -122.472459191965) | 9 | 8 | 4 | 64 | 40 | |||
| 134318 | 178164 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 19 | : | Tree | Private 2 | 5 | Width 0ft | 5993000.50065 | 2087852.84302 | 37.71244461881 | -122.46604626403 | (37.71244461881, -122.46604626403) | 9 | 8 | 4 | 64 | 24 | |||
| 134727 | 186880 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2700 Sunset Blvd | 29 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 0ft | 5985201.1788 | 2096460.2128 | 37.7356251686507 | -122.49363655642 | (37.7356251686507, -122.49363655642) | 1 | 8 | 3 | 29491 | 35 | |||
| 135146 | 243113 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 16 | Median : Yard | Tree | DPW 1 | 05/01/2017 12:00:00 AM | 3 | 6001816.52967 | 2098672.65474 | 37.7426580318326 | -122.436349296602 | (37.7426580318326, -122.436349296602) | 2 | 7 | 5 | 63 | 7 | |||
| 136381 | 200558 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 34 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6016305.3951 | 2095506.8264 | 37.7347779203 | -122.386029881179 | (37.7347779203, -122.386029881179) | 10 | 3 | 8 | 58 | 1 | |||
| 136516 | 27297 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 7800X Geary Blvd | 4 | Median : Cutout | Tree | Fire Dept 16 | 06/10/1999 12:00:00 AM | 6 | 5X5 | 5982680.86392 | 2112396.64212 | 37.7792343387449 | -122.503529847504 | (37.7792343387449, -122.503529847504) | 11 | 6 | 2 | 55 | 26 | ||
| 137297 | 211019 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Junipero Serra Blvd | 71 | : | Tree | Private 2 | 3 | Width 0ft | 5991242.8983 | 2092280.74938 | 37.7245010065929 | -122.472443619273 | (37.7245010065929, -122.472443619273) | 9 | 8 | 4 | 64 | 40 | |||
| 137465 | 234473 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 99 Elsie St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 16 | 6007295.70063 | 2098744.01488 | 37.7431637754778 | -122.417408915989 | (37.7431637754778, -122.417408915989) | 2 | 7 | 7 | 28859 | 2 | ||||
| 137776 | 178172 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 0 Gonzalez Dr | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988133.68649 | 2089845.13121 | 37.7176329668754 | -122.483013187625 | (37.7176329668754, -122.483013187625) | 1 | 8 | 4 | 64 | 14 | ||||
| 138421 | 243116 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 19 | Median : Yard | Tree | DPW 1 | 05/01/2017 12:00:00 AM | 3 | 6001856.44522 | 2098624.22352 | 37.7425273189785 | -122.436207815256 | (37.7425273189785, -122.436207815256) | 2 | 7 | 5 | 63 | 7 | |||
| 141285 | 120542 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2450 California St | 1 | Front Yard : Yard | Tree | MTA 3 | DPW for City Agency | 6002644.10897 | 2115479.97736 | 37.7888538273233 | -122.434689351726 | (37.7888538273233, -122.434689351726) | 13 | 9 | 1 | 29490 | 27 | ||||
| 141624 | 8586 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 13 | Median : Cutout | Tree | DPW 1 | 24 | 6 | 6000400.7068 | 2113377.2527 | 37.7829526738098 | -122.442300177437 | (37.7829526738098, -122.442300177437) | 15 | 5 | 1 | 29490 | 41 | |||
| 141879 | 211032 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 297 Dorantes Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5993259.54182 | 2099680.27875 | 37.7449347888095 | -122.466009845078 | (37.7449347888095, -122.466009845078) | 1 | 8 | 4 | 29491 | 40 | |||
| 141899 | 254786 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 700 Brotherhood Way | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x9 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 142106 | 178147 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 18 | : | Tree | Private 2 | 4 | Width 0ft | 5991814.6494 | 2087985.34878 | 37.712739962461 | -122.47015453352 | (37.712739962461, -122.47015453352) | 9 | 8 | 4 | 64 | 24 | |||
| 142428 | 114137 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 1200X JUNIPERO SERRA BLVD | 33 | Sidewalk: Property side : Yard | Tree | Private 2 | 26 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
| 143757 | 185290 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2601 Sunset Blvd | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984983.8028 | 2097379.2257 | 37.738135813056 | -122.494455822202 | (37.738135813056, -122.494455822202) | 1 | 8 | 3 | 29491 | 35 | |||
| 144446 | 178170 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 0 Serrano Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5989035.58475 | 2090454.34239 | 37.7193581480518 | -122.479940326497 | (37.7193581480518, -122.479940326497) | 1 | 8 | 4 | 64 | 14 | ||||
| 144504 | 254787 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 700 Brotherhood Way | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x9 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 144700 | 118538 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 7900x Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 11 | Width 4ft | 5982472.23583 | 2112389.87128 | 37.7792034803758 | -122.504251064408 | (37.7792034803758, -122.504251064408) | 11 | 6 | 2 | 55 | 26 | |||
| 145411 | 254797 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 700 Brotherhood Way | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x9 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 145424 | 211006 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 600x Portola Dr | 1 | Median : Cutout | Tree | DPW 1 | 6 | Width 4ft | 5997174.86391 | 2099677.95775 | 37.7451535147355 | -122.452471281937 | (37.7451535147355, -122.452471281937) | 1 | 7 | 4 | 59 | 40 | |||
| 145727 | 178137 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 8 | : | Tree | Private 2 | 5 | Width 0ft | 5992316.61451 | 2087859.09194 | 37.7124222985339 | -122.468410417129 | (37.7124222985339, -122.468410417129) | 9 | 8 | 4 | 64 | 24 | |||
| 146907 | 243109 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 10 | Median : Yard | Tree | DPW 1 | 05/01/2017 12:00:00 AM | 3 | 6001750.32805 | 2098751.0187 | 37.7428694390712 | -122.436583810118 | (37.7428694390712, -122.436583810118) | 2 | 7 | 5 | 63 | 7 | |||
| 146921 | 186247 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1701 Sunset Blvd | 58 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984819.3113 | 2103171.6078 | 37.7540304886989 | -122.495451627268 | (37.7540304886989, -122.495451627268) | 1 | 8 | 3 | 56 | 35 | |||
| 147440 | 111557 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 900x BOSWORTH ST | 35 | Front Yard : Yard | Tree | DPW 1 | 12 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
| 147596 | 234475 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 378 Highland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6007368.44216 | 2096501.62636 | 37.7370107660349 | -122.416998547241 | (37.7370107660349, -122.416998547241) | 2 | 7 | 7 | 28859 | 2 | |||
| 148334 | 254794 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 700 Brotherhood Way | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x9 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 150152 | 120624 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 6004397 | 2113949 | 37.7847495050096 | -122.428515420401 | (37.7847495050096, -122.428515420401) | 13 | 9 | 11 | 29490 | 41 | |||||
| 150320 | 111555 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 900x BOSWORTH ST | 33 | Front Yard : Yard | Tree | DPW 1 | 24 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
| 150758 | 27296 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 7800X Geary Blvd | 3 | Median : Cutout | Tree | Fire Dept 16 | 06/10/1999 12:00:00 AM | 6 | 5X5 | 5982703.46074 | 2112397.79309 | 37.7792388274313 | -122.50345176232 | (37.7792388274313, -122.50345176232) | 11 | 6 | 2 | 55 | 26 | ||
| 150834 | 8342 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1300 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 24 | 6 | 6005496.3592183 | 2114176.6024527 | 37.7854365962768 | -122.424728193484 | (37.7854365962768, -122.424728193484) | 13 | 9 | 11 | 28858 | 13 | |||
| 151464 | 27298 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 7800X Geary Blvd | 5 | Median : Cutout | Tree | Fire Dept 16 | 06/10/1999 12:00:00 AM | 6 | 5X5 | 5982658.07107 | 2112395.9042 | 37.7792309725957 | -122.503608641413 | (37.7792309725957, -122.503608641413) | 11 | 6 | 2 | 55 | 26 | ||
| 152315 | 254800 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 700 Brotherhood Way | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x9 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 153020 | 186456 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1601 Sunset Blvd | 44 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984777.372 | 2103875.7247 | 37.7559613430639 | -122.495648593467 | (37.7559613430639, -122.495648593467) | 1 | 8 | 3 | 56 | 35 | |||
| 153030 | 200615 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 56 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6016438.8423 | 2095106.2461 | 37.7336853915549 | -122.385540596193 | (37.7336853915549, -122.385540596193) | 10 | 3 | 8 | 58 | 1 | |||
| 153599 | 185439 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2300 Sunset Blvd | 57 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985094.1378 | 2099479.3093 | 37.74390853381 | -122.494229093058 | (37.74390853381, -122.494229093058) | 1 | 8 | 3 | 29491 | 35 | |||
| 153819 | 186620 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1501 Sunset Blvd | 91 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984755.0749 | 2104355.2681 | 37.7572767304033 | -122.495761074715 | (37.7572767304033, -122.495761074715) | 1 | 8 | 3 | 56 | 35 | |||
| 153963 | 24789 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 7700 Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 6 | 4X4 | 5983110.07731 | 2112460.67779 | 37.7794353864392 | -122.502049785013 | (37.7794353864392, -122.502049785013) | 11 | 6 | 2 | 55 | 26 | |||
| 154769 | 255363 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700X Brotherhood Way | 1 | Median : Cutout | Tree | DPW 1 | 6x10 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 155300 | 178177 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 167 Vienna St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6004561.94872 | 2092421.12411 | 37.7256483463685 | -122.426411406667 | (37.7256483463685, -122.426411406667) | 9 | 7 | 6 | 28861 | 5 | ||||
| 156411 | 120627 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 6004397 | 2113949 | 37.7847495050096 | -122.428515420401 | (37.7847495050096, -122.428515420401) | 13 | 9 | 11 | 29490 | 41 | |||||
| 156752 | 186238 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1701 Sunset Blvd | 49 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984762.5292 | 2103340.0793 | 37.7544897398871 | -122.495660416165 | (37.7544897398871, -122.495660416165) | 1 | 8 | 3 | 56 | 35 | |||
| 157706 | 178159 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 14 | : | Tree | Private 2 | 5 | Width 0ft | 5993218.97583 | 2087844.63687 | 37.7124346884772 | -122.465290557432 | (37.7124346884772, -122.465290557432) | 9 | 8 | 4 | 64 | 24 | |||
| 158532 | 185308 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2601 Sunset Blvd | 33 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985001.1798 | 2097292.5499 | 37.7378988415191 | -122.494389354717 | (37.7378988415191, -122.494389354717) | 1 | 8 | 3 | 29491 | 35 | |||
| 158562 | 200567 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 39 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6016322.0539 | 2095480.6054 | 37.7347068446432 | -122.385970458247 | (37.7347068446432, -122.385970458247) | 10 | 3 | 8 | 58 | 1 | |||
| 159200 | 178136 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 7 | : | Tree | Private 2 | 5 | Width 0ft | 5992351.13254 | 2087854.27594 | 37.7124110686957 | -122.468290763208 | (37.7124110686957, -122.468290763208) | 9 | 8 | 4 | 64 | 24 | |||
| 160462 | 2028 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 600X Bosworth St | 5 | Median : Cutout | Tree | DPW 1 | 12 | 10 | 6002398.10054 | 2095366.8333155 | 37.7336140379052 | -122.434102128474 | (37.7336140379052, -122.434102128474) | 2 | 7 | 5 | 63 | 7 | |||
| 160689 | 211014 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500 Junipero Serra Blvd | 53 | : | Tree | Private 2 | 3 | Width 0ft | 5991322.30761 | 2093384.47859 | 37.7275361681597 | -122.4722495339 | (37.7275361681597, -122.4722495339) | 9 | 8 | 4 | 64 | 40 | |||
| 160793 | 178142 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 13 | : | Tree | Private 2 | 5 | Width 0ft | 5991993.89623 | 2087943.01111 | 37.7126340744777 | -122.469531924782 | (37.7126340744777, -122.469531924782) | 9 | 8 | 4 | 64 | 24 | |||
| 161266 | 114370 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 821 GONZALEZ DR | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988453 | 2089765 | 37.7174315222235 | -122.481903612061 | (37.7174315222235, -122.481903612061) | 1 | 8 | 4 | 64 | 14 | ||||
| 161286 | 8351 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1300 Geary Blvd | 17 | Median : Cutout | Tree | DPW 1 | 24 | 6 | 6005496.3592183 | 2114176.6024527 | 37.7854365962768 | -122.424728193484 | (37.7854365962768, -122.424728193484) | 13 | 9 | 11 | 28858 | 13 | |||
| 161640 | 27299 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 7800X Geary Blvd | 6 | Median : Cutout | Tree | Fire Dept 16 | 06/10/1999 12:00:00 AM | 6 | 5X5 | 5982630.17797 | 2112395.09735 | 37.7792271172593 | -122.503705073784 | (37.7792271172593, -122.503705073784) | 11 | 6 | 2 | 55 | 26 | ||
| 161693 | 3773 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1098 Carolina St | 6 | Median : Cutout | Tree | DPW 1 | 12 | 18 | 6012462.6103665 | 2102859.9036449 | 37.754754478768 | -122.399831953417 | (37.754754478768, -122.399831953417) | 10 | 3 | 8 | 28856 | 29 | |||
| 161876 | 211038 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 52 Burnside Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | 6001171.81546 | 2095754.02956 | 37.7346075158123 | -122.438369473392 | (37.7346075158123, -122.438369473392) | 2 | 7 | 5 | 63 | 7 | ||||
| 162497 | 211001 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Portola Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5996755.51144 | 2099350.67627 | 37.7442308453761 | -122.45389769125 | (37.7442308453761, -122.45389769125) | 1 | 7 | 4 | 59 | 40 | |||
| 162963 | 243101 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 1 | Median : Yard | Tree | DPW 1 | 01/09/2018 12:00:00 AM | 3 | 6001501.83115 | 2098971.73396 | 37.7434613467555 | -122.437458843264 | (37.7434613467555, -122.437458843264) | 2 | 7 | 5 | 63 | 7 |
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) );