trees
244 rows where qCaretaker_id = 2 and qSpecies_id = 35 sorted by Supervisor Districts descending
This data as json, CSV (advanced)
These facets timed out: qCaretaker_id
| 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||
| 21134 | 87016 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 35 Whitfield Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49947 | 6017543.1 | 2094109.3 | 37.7310090102049 | -122.381653502791 | (37.7310090102049, -122.381653502791) | 10 | 3 | 8 | 58 | 1 | |||
| 33716 | 178129 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 345 Tocoloma Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6012554.38724 | 2086809.43241 | 37.7106883309719 | -122.398388432799 | (37.7106883309719, -122.398388432799) | 10 | 3 | 8 | 309 | 1 | |||
| 42016 | 87018 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 1200 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49948 | 6017188.8 | 2093995.7 | 37.7306775177665 | -122.382870487304 | (37.7306775177665, -122.382870487304) | 10 | 3 | 8 | 58 | 1 | |||
| 54367 | 253555 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 27 Ceres St | 1 | Front Yard : Yard | Tree | Private 2 | FUF | 6013919.66127 | 2093997.42296 | 37.7305010827376 | -122.394172607985 | (37.7305010827376, -122.394172607985) | 10 | 3 | 8 | 58 | 1 | ||||
| 80290 | 200146 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 6101 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 0ft | 6013586.8559 | 2091305.2042 | 37.7230902914135 | -122.395134667477 | (37.7230902914135, -122.395134667477) | 10 | 3 | 8 | 58 | 1 | |||
| 85596 | 87013 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 1184 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49946 | 6017813.5 | 2093492.6 | 37.7293305991048 | -122.380675823117 | (37.7293305991048, -122.380675823117) | 10 | 3 | 8 | 58 | 1 | |||
| 109718 | 87015 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 35 Whitfield Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49947 | 6017543.1 | 2094109.3 | 37.7310090102049 | -122.381653502791 | (37.7310090102049, -122.381653502791) | 10 | 3 | 8 | 58 | 1 | |||
| 120683 | 255712 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 618x Mendell St | 6 | Front Yard : Yard | Tree | Private 2 | 3x3 | Permit Number 781846 | 6016234 | 2097322 | 37.7397580688138 | -122.386403238688 | (37.7397580688138, -122.386403238688) | 10 | 3 | 8 | 58 | 1 | |||
| 160963 | 87014 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 35 Whitfield Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49947 | 6017543.1 | 2094109.3 | 37.7310090102049 | -122.381653502791 | (37.7310090102049, -122.381653502791) | 10 | 3 | 8 | 58 | 1 | |||
| 165176 | 87017 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 1200 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49948 | 6017188.8 | 2093995.7 | 37.7306775177665 | -122.382870487304 | (37.7306775177665, -122.382870487304) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | ||||
| 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 | ||||
| 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 | |||
| 170250 | 234474 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 72 Santa Marina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006078.82979 | 2097595.56477 | 37.7399418481504 | -122.421534992063 | (37.7399418481504, -122.421534992063) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 69893 | 211037 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 61 Burnside Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6001183.29295 | 2095747.84811 | 37.7345911958118 | -122.438329349227 | (37.7345911958118, -122.438329349227) | 2 | 7 | 5 | 63 | 7 | ||||
| 71549 | 234477 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500 Grand View Ave | 4 | Front Yard : Yard | Tree | Private 2 | 3 | 5999979.48342 | 2101750.0189 | 37.7510031819599 | -122.442922193204 | (37.7510031819599, -122.442922193204) | 2 | 4 | 5 | 28862 | 22 | ||||
| 83823 | 211035 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 61 Burnside Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | 6001198.5187 | 2095714.51341 | 37.7345005324595 | -122.438274321504 | (37.7345005324595, -122.438274321504) | 2 | 7 | 5 | 63 | 7 | ||||
| 96104 | 234476 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 784 Duncan St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 6ft | 6001432.63511 | 2099723.41327 | 37.7455213464352 | -122.437751929628 | (37.7455213464352, -122.437751929628) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | ||||
| 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 | ||||
| 186953 | 173744 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500X Grand View Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000114 | 2102099 | 37.7519690677882 | -122.442482075417 | (37.7519690677882, -122.442482075417) | 2 | 4 | 5 | 28862 | 22 | ||||
| 189697 | 234478 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 398 Surrey St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | Width 5ft | 6001098.40077 | 2096167.19905 | 37.7357378071451 | -122.43865288754 | (37.7357378071451, -122.43865288754) | 2 | 7 | 5 | 63 | 7 | |||
| 267 | 178174 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988358.3694 | 2089791.63303 | 37.717499145949 | -122.482232652541 | (37.717499145949, -122.482232652541) | 1 | 8 | 4 | 64 | 14 | ||||
| 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 | |||
| 1053 | 211003 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Portola Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5996800.72253 | 2099394.55039 | 37.7443539050009 | -122.453744529511 | (37.7443539050009, -122.453744529511) | 1 | 7 | 4 | 59 | 40 | |||
| 6387 | 114260 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 800x BROTHERHOOD WAY | 1 | Front Yard : Cutout | Tree | Private 2 | 7 | 5990271 | 2088582 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | 1 | 8 | 4 | 64 | 14 | ||||
| 6708 | 256455 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 2901 Sunset Blvd | 4 | Median : Yard | Tree | Private 2 | 3x3 | 5984945 | 2095183 | 37.7321032922905 | -122.494428131787 | (37.7321032922905, -122.494428131787) | 1 | 8 | 4 | 64 | 35 | ||||
| 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 | |||
| 11838 | 94234 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 1501@Clearfield Sloat Blvd | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/28/2010 12:00:00 AM | 14 | Permit Number 53611 | 5986536.9 | 2095861.8 | 37.7340601352242 | -122.488974540344 | (37.7340601352242, -122.488974540344) | 1 | 8 | 4 | 64 | 35 | ||
| 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 | |||
| 18682 | 91505 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 1501@Clearfield Sloat Blvd | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2009 12:00:00 AM | 3x3 | Permit Number 52122 | 5986316.3 | 2095724.7 | 37.7336708170949 | -122.489727133621 | (37.7336708170949, -122.489727133621) | 1 | 8 | 4 | 64 | 35 | ||
| 19643 | 105261 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 619 GONZALEZ DR | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5988914.8 | 2089258.8 | 37.7160684695332 | -122.48027037241 | (37.7160684695332, -122.48027037241) | 1 | 8 | 4 | 64 | 14 | |||||
| 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 | |||
| 22467 | 211031 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2375 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 5992617.61467 | 2099318.2887 | 37.7439038024205 | -122.468203163863 | (37.7439038024205, -122.468203163863) | 1 | 8 | 4 | 29491 | 40 | |||
| 23338 | 114378 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 842X GONZALEZ DR | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988421 | 2089827 | 37.7175998975755 | -122.482018759302 | (37.7175998975755, -122.482018759302) | 1 | 8 | 4 | 64 | 14 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 41763 | 114139 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 1200X JUNIPERO SERRA BLVD | 34 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
| 42301 | 87834 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 1501@Ocean Sloat Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2008 12:00:00 AM | 3x3 | Permit Number 50721 | 5986536.9 | 2095861.8 | 37.7340601352242 | -122.488974540344 | (37.7340601352242, -122.488974540344) | 1 | 8 | 4 | 64 | 35 | ||
| 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 | |||
| 44422 | 94231 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 1501@Ocean Sloat Blvd | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/28/2010 12:00:00 AM | 24 | Permit Number 53611 | 5986536.9 | 2095861.8 | 37.7340601352242 | -122.488974540344 | (37.7340601352242, -122.488974540344) | 1 | 8 | 4 | 64 | 35 | ||
| 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 | |||
| 49925 | 211004 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Portola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5996822.63607 | 2099410.87592 | 37.7443999871842 | -122.453669936126 | (37.7443999871842, -122.453669936126) | 1 | 7 | 4 | 59 | 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 | |||
| 52814 | 211034 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 417 Dewey Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 3ft | 5995115.07777 | 2100328.51022 | 37.7468215422 | -122.45964072765 | (37.7468215422, -122.45964072765) | 1 | 8 | 4 | 59 | 40 | |||
| 53868 | 91504 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 1501@Clearfield Sloat Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2009 12:00:00 AM | 3x3 | Permit Number 52122 | 5986536.9 | 2095861.8 | 37.7340601352242 | -122.488974540344 | (37.7340601352242, -122.488974540344) | 1 | 8 | 4 | 64 | 35 | ||
| 53879 | 114377 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 842X GONZALEZ DR | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988421 | 2089827 | 37.7175998975755 | -122.482018759302 | (37.7175998975755, -122.482018759302) | 1 | 8 | 4 | 64 | 14 | ||||
| 61085 | 114124 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 1200X JUNIPERO SERRA BLVD | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
| 62197 | 94233 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 1501@Ocean Sloat Blvd | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/28/2010 12:00:00 AM | 12 | Permit Number 53611 | 5986316.3 | 2095724.7 | 37.7336708170949 | -122.489727133621 | (37.7336708170949, -122.489727133621) | 1 | 8 | 4 | 64 | 35 | ||
| 63516 | 178176 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5989163.89955 | 2089384.56057 | 37.7164282485354 | -122.479418571325 | (37.7164282485354, -122.479418571325) | 1 | 8 | 4 | 64 | 14 | ||||
| 65012 | 254798 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 700 Brotherhood Way | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x9 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 72849 | 91503 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 1501@Clearfield Sloat Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2009 12:00:00 AM | 3x3 | Permit Number 52122 | 5986536.9 | 2095861.8 | 37.7340601352242 | -122.488974540344 | (37.7340601352242, -122.488974540344) | 1 | 8 | 4 | 64 | 35 | ||
| 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 | |||
| 75828 | 114138 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 1200X JUNIPERO SERRA BLVD | 32 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/16/2016 12:00:00 AM | 3 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | |||
| 77378 | 211002 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Portola Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5996779.38475 | 2099373.51377 | 37.744294920285 | -122.453816791818 | (37.744294920285, -122.453816791818) | 1 | 7 | 4 | 59 | 40 | |||
| 78181 | 98278 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 900 Brotherhood Way | 500 | Sidewalk: Curb side : Yard | Tree | Private 2 | 02/07/2012 12:00:00 AM | Permit Number 768594 | 5988860.9 | 2088745.5 | 37.7146559434524 | -122.480419123791 | (37.7146559434524, -122.480419123791) | 1 | 8 | 4 | 64 | 14 | |||
| 81883 | 106311 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 35 | 99X Clearfield Dr | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 04/15/2014 12:00:00 AM | Permit Number 772542 | 5985798.26078 | 2095453.46484 | 37.7328958169551 | -122.491498163849 | (37.7328958169551, -122.491498163849) | 1 | 8 | 4 | 64 | 35 | |||
| 82197 | 114371 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 821 GONZALEZ DR | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988453 | 2089765 | 37.7174315222235 | -122.481903612061 | (37.7174315222235, -122.481903612061) | 1 | 8 | 4 | 64 | 14 | ||||
| 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 | ||
| 92672 | 254785 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 700 Brotherhood Way | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x9 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 93553 | 178171 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 0 Gonzalez Dr | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988123.04078 | 2089845.83927 | 37.7176342915553 | -122.483050036443 | (37.7176342915553, -122.483050036443) | 1 | 8 | 4 | 64 | 14 | ||||
| 95623 | 178173 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988347.73388 | 2089792.82325 | 37.717501795356 | -122.482269501364 | (37.717501795356, -122.482269501364) | 1 | 8 | 4 | 64 | 14 | ||||
| 96966 | 254788 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 700 Brotherhood Way | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x9 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 99863 | 114934 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 4400x OCEAN AVE | 10 | Front Yard : Cutout | Tree | Private 2 | 02/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777127 | 5985931 | 2095134 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | 1 | 8 | 4 | 64 | 35 | |
| 103504 | 254796 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 700 Brotherhood Way | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x9 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 105094 | 96843 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 417 Dewey Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5995136 | 2100316.9 | 37.7467908665237 | -122.459567540316 | (37.7467908665237, -122.459567540316) | 1 | 8 | 4 | 59 | 40 | |||||
| 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 | |||
| 108114 | 114123 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 1200X JUNIPERO SERRA BLVD | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 |
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) );