trees
395 rows where qSpecies_id = 35 sorted by Fire Prevention Districts descending
This data as json, CSV (advanced)
PermitNotes ✖
- - 358
- Permit Number 53611 6
- Permit Number 52122 4
- Permit Number 49947 3
- Permit Number 781999 3
- Permit Number 49948 2
- Permit Number 50721 2
- Permit Number 768594 2
- Permit Number 772542 2
- Permit Number 777127 2
- Permit Number 21519 1
- Permit Number 49946 1
- Permit Number 49949 1
- Permit Number 768589 1
- Permit Number 769006 1
- Permit Number 772491 1
- Permit Number 774449 1
- Permit Number 777492 1
- Permit Number 777818 1
- Permit Number 781846 1
- Permit Number 782748 1
| 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 450 | 178165 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 20 | Median : Cutout | Tree | Private 2 | 5 | Width 0ft | 5992928.58802 | 2087852.90738 | 37.7124406464989 | -122.466294818667 | (37.7124406464989, -122.466294818667) | 9 | 8 | 4 | 64 | 24 | |||
| 9866 | 178155 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 10 | : | Tree | Private 2 | 6 | Width 0ft | 5993366.44396 | 2087810.43567 | 37.7123492834548 | -122.464778384525 | (37.7123492834548, -122.464778384525) | 9 | 8 | 4 | 64 | 24 | |||
| 10548 | 211015 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500 Junipero Serra Blvd | 78 | : | Tree | Private 2 | 3 | Width 0ft | 5991307.93934 | 2093199.2311 | 37.7270266932138 | -122.472285706431 | (37.7270266932138, -122.472285706431) | 9 | 8 | 4 | 64 | 40 | |||
| 14478 | 211030 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Junipero Serra Blvd | 165 | : | Tree | Private 2 | 4 | Width 0ft | 5991183.72988 | 2091349.85826 | 37.7219415855123 | -122.472580317121 | (37.7219415855123, -122.472580317121) | 9 | 8 | 4 | 64 | 40 | |||
| 20168 | 211040 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 52 Burnside Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 6001161.45161 | 2095717.92279 | 37.7345077855016 | -122.438402718629 | (37.7345077855016, -122.438402718629) | 9 | 7 | 5 | 63 | 7 | ||||
| 20336 | 211013 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500 Junipero Serra Blvd | 44 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5991332.59313 | 2093509.69784 | 37.727880584217 | -122.472223101034 | (37.727880584217, -122.472223101034) | 9 | 8 | 4 | 64 | 40 | |||
| 23532 | 211021 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Junipero Serra Blvd | 78 | : | Tree | Private 2 | 6 | Width 0ft | 5991241.40021 | 2092233.42701 | 37.7243709844069 | -122.472445349599 | (37.7243709844069, -122.472445349599) | 9 | 8 | 4 | 64 | 40 | |||
| 25077 | 178166 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 21 | : | Tree | Private 2 | 5 | Width 0ft | 5992891.51235 | 2087851.51661 | 37.7124346884767 | -122.466422861421 | (37.7124346884767, -122.466422861421) | 9 | 8 | 4 | 64 | 24 | |||
| 27670 | 178138 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 9 | : | Tree | Private 2 | 7 | Width 0ft | 5992224.93754 | 2087880.30275 | 37.7124752425212 | -122.468728820297 | (37.7124752425212, -122.468728820297) | 9 | 8 | 4 | 64 | 24 | |||
| 27896 | 211024 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Junipero Serra Blvd | 94 | : | Tree | Private 2 | 6 | Width 0ft | 5991236.61569 | 2092101.43513 | 37.7240082905392 | -122.472452270761 | (37.7240082905392, -122.472452270761) | 9 | 8 | 4 | 64 | 40 | |||
| 30677 | 178169 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 24 | : | Tree | Private 2 | 6 | Width 0ft | 5992786.91057 | 2087851.54482 | 37.7124287295635 | -122.466784396099 | (37.7124287295635, -122.466784396099) | 9 | 8 | 4 | 64 | 24 | |||
| 32345 | 211008 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700x Bosworth St | 2 | Median : Yard | Tree | DPW 1 | 33 | Width 10ft | 6002060.33003 | 2095430.49234 | 37.7337696552405 | -122.435274449372 | (37.7337696552405, -122.435274449372) | 9 | 7 | 5 | 63 | 40 | |||
| 34002 | 211012 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500 Junipero Serra Blvd | 35 | : | Tree | Private 2 | 3 | Width 0ft | 5991334.38006 | 2093575.3838 | 37.7280610448729 | -122.472221709761 | (37.7280610448729, -122.472221709761) | 9 | 8 | 4 | 64 | 40 | |||
| 36557 | 211039 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 52 Burnside Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | 6001157.31367 | 2095726.26325 | 37.7345304511011 | -122.438417622186 | (37.7345304511011, -122.438417622186) | 9 | 7 | 5 | 63 | 7 | ||||
| 37212 | 111553 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 900x BOSWORTH ST | 31 | Front Yard : Yard | Tree | DPW 1 | 12 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
| 37951 | 178151 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 4 | : | Tree | Private 2 | 3 | Width 0ft | 5993597.52442 | 2087641.38278 | 37.7118984245322 | -122.463967443352 | (37.7118984245322, -122.463967443352) | 9 | 8 | 4 | 64 | 24 | |||
| 39660 | 111514 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 800x BOSWORTH ST | 9 | Front Yard : Yard | Tree | DPW 1 | 12 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | ||||
| 43976 | 178156 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 11 | : | Tree | Private 2 | 5 | Width 0ft | 5993327.47852 | 2087822.82752 | 37.712381061909 | -122.464913959129 | (37.712381061909, -122.464913959129) | 9 | 8 | 4 | 64 | 24 | |||
| 49277 | 211023 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Junipero Serra Blvd | 83 | : | Tree | Private 2 | 5 | Width 0ft | 5991239.95465 | 2092188.59606 | 37.7242478060794 | -122.472447079879 | (37.7242478060794, -122.472447079879) | 9 | 8 | 4 | 64 | 40 | |||
| 49587 | 178167 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 22 | : | Tree | Private 2 | 5 | Width 0ft | 5992858.09731 | 2087851.49534 | 37.7124327018762 | -122.466538351485 | (37.7124327018762, -122.466538351485) | 9 | 8 | 4 | 64 | 24 | |||
| 49956 | 211007 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 600x Bosworth St | 8 | Median : Yard | Tree | DPW 1 | 26 | Width 10ft | 6002197.80666 | 2095393.39137 | 37.7336755906519 | -122.43479650017 | (37.7336755906519, -122.43479650017) | 9 | 7 | 5 | 63 | 40 | |||
| 51083 | 178139 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 10 | : | Tree | Private 2 | 6 | Width 0ft | 5992188.74587 | 2087889.24466 | 37.7124977039766 | -122.468854559004 | (37.7124977039766, -122.468854559004) | 9 | 8 | 4 | 64 | 24 | |||
| 51793 | 211027 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Junipero Serra Blvd | 157 | : | Tree | Private 2 | 4 | Width 0ft | 5991179.7136 | 2091396.79999 | 37.7220702434165 | -122.47259762098 | (37.7220702434165, -122.47259762098) | 9 | 8 | 4 | 64 | 40 | |||
| 52379 | 178161 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 16 | : | Tree | Private 2 | 6 | Width 0ft | 5993106.56964 | 2087853.50799 | 37.7124525633948 | -122.465679708459 | (37.7124525633948, -122.465679708459) | 9 | 8 | 4 | 64 | 24 | |||
| 66301 | 178130 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 1 | : | Tree | Private 2 | 7 | Width 0ft | 5992655.54446 | 2087848.4586 | 37.7124126730818 | -122.4672382093 | (37.7124126730818, -122.4672382093) | 9 | 8 | 4 | 64 | 24 | |||
| 66990 | 98838 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1101X Portola Dr | 7 | Sidewalk: Property side : Yard | Tree | DPW 1 | 04/11/2013 12:00:00 AM | 3 | 5994967.95791 | 2097979.30417 | 37.740362747151 | -122.459979297607 | (37.740362747151, -122.459979297607) | 9 | 8 | 4 | 59 | 40 | |||
| 67535 | 211010 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500 Junipero Serra Blvd | 27 | : | Tree | Private 2 | 3 | Width 0ft | 5991339.10103 | 2093646.61822 | 37.7282569100089 | -122.472210579766 | (37.7282569100089, -122.472210579766) | 9 | 8 | 4 | 64 | 40 | |||
| 68619 | 178132 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 3 | : | Tree | Private 2 | 6 | Width 0ft | 5992585.12632 | 2087848.18621 | 37.7124078599039 | -122.467481573927 | (37.7124078599039, -122.467481573927) | 9 | 8 | 4 | 64 | 24 | |||
| 69254 | 111516 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 800x BOSWORTH ST | 11 | Front Yard : Yard | Tree | DPW 1 | 14 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | ||||
| 69447 | 111507 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 800x BOSWORTH ST | 2 | Front Yard : Yard | Tree | DPW 1 | 18 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | ||||
| 71095 | 178152 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 7 | : | Tree | Private 2 | 5 | Width 0ft | 5993523.09133 | 2087729.02455 | 37.7121347780763 | -122.464231061624 | (37.7121347780763, -122.464231061624) | 9 | 8 | 4 | 64 | 24 | |||
| 75099 | 178157 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 12 | : | Tree | Private 2 | 7 | Width 0ft | 5993292.82373 | 2087832.959 | 37.712406882332 | -122.465034470985 | (37.712406882332, -122.465034470985) | 9 | 8 | 4 | 64 | 24 | |||
| 82846 | 178140 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 11 | : | Tree | Private 2 | 6 | Width 0ft | 5992153.76433 | 2087899.91411 | 37.712524978625 | -122.468976240883 | (37.712524978625, -122.468976240883) | 9 | 8 | 4 | 64 | 24 | |||
| 84561 | 178158 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 13 | : | Tree | Private 2 | 5 | Width 0ft | 5993255.20411 | 2087840.25906 | 37.7124247572585 | -122.465165024673 | (37.7124247572585, -122.465165024673) | 9 | 8 | 4 | 64 | 24 | |||
| 87580 | 178149 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 20 | : | Tree | Private 2 | 4 | Width 0ft | 5991654.66793 | 2087995.14516 | 37.712757610756 | -122.470708188538 | (37.712757610756, -122.470708188538) | 9 | 8 | 4 | 64 | 24 | |||
| 88271 | 178133 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 4 | : | Tree | Private 2 | 6 | Width 0ft | 5992553.46677 | 2087849.43624 | 37.7124094643071 | -122.467591088862 | (37.7124094643071, -122.467591088862) | 9 | 8 | 4 | 64 | 24 | |||
| 88362 | 178135 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 6 | : | Tree | Private 2 | 5 | Width 0ft | 5992385.69997 | 2087851.79588 | 37.7124062555186 | -122.468171108404 | (37.7124062555186, -122.468171108404) | 9 | 8 | 4 | 64 | 24 | |||
| 90257 | 178131 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 2 | : | Tree | Private 2 | 5 | Width 0ft | 5992618.59421 | 2087849.23546 | 37.7124126730667 | -122.467365975965 | (37.7124126730667, -122.467365975965) | 9 | 8 | 4 | 64 | 24 | |||
| 90962 | 178141 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 12 | Median : Yard | Tree | Private 2 | DPW | 5 | Width 0ft | 5992021.87667 | 2087934.24208 | 37.7126116138994 | -122.469434578544 | (37.7126116138994, -122.469434578544) | 9 | 8 | 4 | 64 | 24 | ||
| 101189 | 111558 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 900x BOSWORTH ST | 36 | Front Yard : Yard | Tree | DPW 1 | 15 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
| 106955 | 211009 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500 Junipero Serra Blvd | 25 | : | Tree | Private 2 | 4 | Width 0ft | 5991341.55983 | 2093667.80622 | 37.728315229259 | -122.472203623507 | (37.728315229259, -122.472203623507) | 9 | 8 | 4 | 64 | 40 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 167203 | 178168 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 23 | : | Tree | Private 2 | 5 | Width 0ft | 5992821.74753 | 2087850.08942 | 37.712426743882 | -122.466663884229 | (37.712426743882, -122.466663884229) | 9 | 8 | 4 | 64 | 24 | |||
| 167758 | 211029 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Junipero Serra Blvd | 162 | : | Tree | Private 2 | 5 | Width 0ft | 5991185.525 | 2091363.77787 | 37.7219799092267 | -122.472575126241 | (37.7219799092267, -122.472575126241) | 9 | 8 | 4 | 64 | 40 | |||
| 170410 | 178146 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 17 | : | Tree | Private 2 | 4 | Width 0ft | 5991839.8077 | 2087981.8975 | 37.7127319405071 | -122.47006732805 | (37.7127319405071, -122.47006732805) | 9 | 8 | 4 | 64 | 24 | |||
| 171251 | 111554 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 900x BOSWORTH ST | 32 | Front Yard : Yard | Tree | DPW 1 | 26 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
| 174956 | 178160 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 15 | : | Tree | Private 2 | 6 | Width 0ft | 5993144.35627 | 2087854.16093 | 37.7124565357104 | -122.465549154771 | (37.7124565357104, -122.465549154771) | 9 | 8 | 4 | 64 | 24 | |||
| 178432 | 178154 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 9 | : | Tree | Private 2 | 7 | Width 0ft | 5993415.34716 | 2087786.98511 | 37.7122877131728 | -122.464607659932 | (37.7122877131728, -122.464607659932) | 9 | 8 | 4 | 64 | 24 | |||
| 180575 | 211022 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Junipero Serra Blvd | 80 | : | Tree | Private 2 | 3 | Width 0ft | 5991230.5084 | 2092239.13983 | 37.7243860399747 | -122.472483416991 | (37.7243860399747, -122.472483416991) | 9 | 8 | 4 | 64 | 40 | |||
| 182077 | 211028 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Junipero Serra Blvd | 160 | : | Tree | Private 2 | 4 | Width 0ft | 5991184.3391 | 2091378.75733 | 37.7220209704755 | -122.472580317131 | (37.7220209704755, -122.472580317131) | 9 | 8 | 4 | 64 | 40 | |||
| 182192 | 178134 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 5 | Side Yard : Yard | Tree | DPW 1 | 5 | Width 0ft | 5992424.40969 | 2087850.98169 | 37.7124062555176 | -122.468037257827 | (37.7124062555176, -122.468037257827) | 9 | 8 | 4 | 64 | 24 | |||
| 182755 | 178163 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 18 | : | Tree | Private 2 | 5 | Width 0ft | 5993033.97644 | 2087855.75659 | 37.7124545499972 | -122.465930773993 | (37.7124545499972, -122.465930773993) | 9 | 8 | 4 | 64 | 24 | |||
| 184676 | 178150 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 21 | : | Tree | Private 2 | 4 | Width 0ft | 5991622.99627 | 2087995.81221 | 37.7127576107372 | -122.470817703474 | (37.7127576107372, -122.470817703474) | 9 | 8 | 4 | 64 | 24 | |||
| 184903 | 178145 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 16 | : | Tree | Private 2 | 4 | Width 0ft | 5991905.80045 | 2087967.06921 | 37.7126950404068 | -122.469838159212 | (37.7126950404068, -122.469838159212) | 9 | 8 | 4 | 64 | 24 | |||
| 191418 | 211011 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500 Junipero Serra Blvd | 34 | : | Tree | Private 2 | 3 | Width 0ft | 5991335.35345 | 2093583.37833 | 37.7280830521881 | -122.472218927265 | (37.7280830521881, -122.472218927265) | 9 | 8 | 4 | 64 | 40 | |||
| 191519 | 211018 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Junipero Serra Blvd | 55 | : | Tree | Private 2 | 3 | Width 0ft | 5991237.26366 | 2092440.87353 | 37.7249403415953 | -122.472474765495 | (37.7249403415953, -122.472474765495) | 9 | 8 | 4 | 64 | 40 | |||
| 194461 | 265095 | Property Tree 8 | Pinus canariensis :: Canary Island Pine 35 | 1100 Junipero Serra Blvd | 1 | Side Yard : Cutout | Tree | Private 2 | 10x10 | 5991104 | 2090006 | 37.7182470667789 | -122.472757983106 | (37.7182470667789, -122.472757983106) | 9 | 8 | 4 | 64 | 40 | ||||
| 3739 | 261012 | Property Tree 8 | Pinus canariensis :: Canary Island Pine 35 | 170 Otis St | 2 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6006561 | 2108839 | 37.7708409033816 | -122.420665800575 | (37.7708409033816, -122.420665800575) | 8 | 2 | 9 | 28853 | 19 | ||||
| 18405 | 261011 | Property Tree 8 | Pinus canariensis :: Canary Island Pine 35 | 170 Otis St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6006561 | 2108839 | 37.7708409033816 | -122.420665800575 | (37.7708409033816, -122.420665800575) | 8 | 2 | 9 | 28853 | 19 | ||||
| 25362 | 194422 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 199X Kissling St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 52 | Width 5ft | 6007901.53326 | 2109054.57818 | 37.771508291196 | -122.416044121944 | (37.771508291196, -122.416044121944) | 8 | 2 | 9 | 28853 | 19 | |||
| 82054 | 194426 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 132 Kissling St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 5ft | 6007946.83693 | 2109121.10943 | 37.7716935173803 | -122.415892125715 | (37.7716935173803, -122.415892125715) | 8 | 2 | 9 | 28853 | 19 | |||
| 90902 | 194427 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 905 Minna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6008110 | 2110227 | 37.7747392032863 | -122.415406037323 | (37.7747392032863, -122.415406037323) | 8 | 2 | 9 | 28853 | 34 | |||
| 100596 | 194423 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 132 Kissling St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 5ft | 6007917.867 | 2109077.33792 | 37.771571702413 | -122.41598923453 | (37.771571702413, -122.41598923453) | 8 | 2 | 9 | 28853 | 19 | |||
| 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 | |||
| 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 | |||
| 192931 | 173637 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1155 Market St | 99 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008672 | 2111900 | 37.779364436223 | -122.4135803097 | (37.779364436223, -122.4135803097) | 8 | 2 | 9 | 28853 | 34 | ||||
| 63272 | 4532 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 45 Cleary Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2018 12:00:00 AM | 3 | 3X3 | Permit Number 781999 | 6005027.0371 | 2113673.2533 | 37.784028006638 | -122.42631605912 | (37.784028006638, -122.42631605912) | 7 | 9 | 11 | 28858 | 41 | |
| 127704 | 4530 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 45 Cleary Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2018 12:00:00 AM | 3 | 3X3 | Permit Number 781999 | 6004963.1338 | 2113665.364 | 37.7840027322121 | -122.426536579485 | (37.7840027322121, -122.426536579485) | 7 | 9 | 11 | 28858 | 41 | |
| 137065 | 4531 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 45 Cleary Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2018 12:00:00 AM | 3 | 3X3 | Permit Number 781999 | 6004996.2689 | 2113667.7308 | 37.7840111039908 | -122.426422112629 | (37.7840111039908, -122.426422112629) | 7 | 9 | 11 | 28858 | 41 | |
| 94007 | 132160 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1141 Chestnut St | 5 | Front Yard : Yard | Tree | Private 2 | 20 | 6006382.37262 | 2120397.93248 | 37.8025688116636 | -122.422104980572 | (37.8025688116636, -122.422104980572) | 5 | 9 | 1 | 28858 | 32 | ||||
| 172237 | 108298 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 10X Greenwich St | 1 | Front Yard : Yard | Tree | Private 2 | 12/15/2014 12:00:00 AM | 3 | Permit Number 774449 | 6012830 | 2116175 | 37.7913351933509 | -122.399496166675 | (37.7913351933509, -122.399496166675) | 4 | 1 | 10 | 28854 | 6 | ||
| 57367 | 132164 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 150 Lombard St | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 5ft | 6011515.19186 | 2120799.84951 | 37.8039605395195 | -122.404371067467 | (37.8039605395195, -122.404371067467) | 3 | 1 | 10 | 28860 | 6 | |||
| 58106 | 132162 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 165 Francisco St | 11 | Front Yard : Yard | Tree | Private 2 | 13 | 6010559.73859 | 2121313.26508 | 37.8053168133783 | -122.407713714409 | (37.8053168133783, -122.407713714409) | 3 | 1 | 10 | 308 | 23 | ||||
| 129267 | 98161 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 35 | 600 Front St | Front Yard : Yard | Tree | Private 2 | 12/21/2011 12:00:00 AM | Permit Number 768589 | 6012888.4 | 2118392.6 | 37.7974274520849 | -122.399449857041 | (37.7974274520849, -122.399449857041) | 3 | 1 | 10 | 28860 | 6 | ||||
| 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 | |||
| 182602 | 132161 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 165 Francisco St | 10 | Front Yard : Yard | Tree | Private 2 | 15 | 6010552.8238 | 2121311.79296 | 37.8053123842132 | -122.407737540175 | (37.8053123842132, -122.407737540175) | 3 | 1 | 10 | 308 | 23 | ||||
| 1190 | 107158 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 101x Elsie St | 1 | Unaccepted Street : Yard | Tree | Private 2 | 20 | 6007300 | 2098759 | 37.7432051631731 | -122.417395111614 | (37.7432051631731, -122.417395111614) | 2 | 7 | 7 | 28859 | 2 | ||||
| 2117 | 111271 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700X BOSWORTH ST | 9 | Front Yard : Yard | Tree | DPW 1 | 42 | 6002150 | 2095428 | 37.7337679036822 | -122.434964255854 | (37.7337679036822, -122.434964255854) | 2 | 7 | 5 | 63 | 7 | ||||
| 39027 | 211036 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 61 Burnside Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6001192.69302 | 2095737.41742 | 37.7345630902121 | -122.438296103083 | (37.7345630902121, -122.438296103083) | 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) );