trees
395 rows where qSpecies_id = 35
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | |||
| 86234 | 173745 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500X Grand View Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6000114 | 2102099 | 37.7519690677882 | -122.442482075417 | (37.7519690677882, -122.442482075417) | 2 | 4 | 5 | 28862 | 22 | ||||
| 86690 | 200559 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 35 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6016309.6626 | 2095501.1365 | 37.7347625331555 | -122.38601473032 | (37.7347625331555, -122.38601473032) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 87610 | 185118 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2850 35th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 0ft | 5985615.0479 | 2096000.8357 | 37.7343880441022 | -122.492171858431 | (37.7343880441022, -122.492171858431) | 1 | 8 | 3 | 29491 | 35 | |||
| 87630 | 243112 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 15 | Median : Yard | Tree | DPW 1 | 05/01/2017 12:00:00 AM | 3 | 6001806.81928 | 2098684.11193 | 37.7426889388393 | -122.436383692077 | (37.7426889388393, -122.436383692077) | 2 | 7 | 5 | 63 | 7 | |||
| 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 | |||
| 88636 | 186468 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1601 Sunset Blvd | 56 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984781.1405 | 2103769.7876 | 37.7556706898247 | -122.495627747424 | (37.7556706898247, -122.495627747424) | 1 | 8 | 3 | 56 | 35 | |||
| 88779 | 186421 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1601 Sunset Blvd | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984727.9626 | 2104153.7573 | 37.756721849906 | -122.495839973726 | (37.756721849906, -122.495839973726) | 1 | 8 | 3 | 56 | 35 | |||
| 89742 | 186435 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1601 Sunset Blvd | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984740.5243 | 2104016.8346 | 37.7563466338471 | -122.495786431621 | (37.7563466338471, -122.495786431621) | 1 | 8 | 3 | 56 | 35 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 92103 | 186040 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1900 Sunset Blvd | 35 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985014.7934 | 2102133.6877 | 37.7511920899125 | -122.49469909774 | (37.7511920899125, -122.49469909774) | 1 | 8 | 3 | 29491 | 35 | |||
| 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 | ||||
| 93290 | 181384 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Sunset Blvd | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984945.4334 | 2104486.2478 | 37.75764751046 | -122.49511240858 | (37.75764751046, -122.49511240858) | 1 | 8 | 3 | 56 | 35 | |||
| 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 | ||||
| 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 | ||||
| 94670 | 139359 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1350x GEARY BLVD | 9 | Median : Cutout | Tree | DPW 1 | 28 | Width 0ft | 6004685.2851 | 2114039.9918 | 37.7850156556233 | -122.427524533418 | (37.7850156556233, -122.427524533418) | 13 | 9 | 11 | 28858 | 41 | |||
| 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 | ||||
| 95893 | 184801 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1301 Sunset Blvd | 62 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984720.8276 | 2105758.3732 | 37.7611272600096 | -122.49598302149 | (37.7611272600096, -122.49598302149) | 1 | 8 | 3 | 56 | 35 | |||
| 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 | |||
| 96483 | 4970 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5200X Diamond Heights Blvd | 6 | Median : Cutout | Tree | DPW 1 | 01/09/2018 12:00:00 AM | 3 | 12 | 6000842.33366 | 2099520.2529 | 37.7449299333661 | -122.439778532074 | (37.7449299333661, -122.439778532074) | 2 | 7 | 5 | 63 | 7 | ||
| 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 | ||||
| 97315 | 186080 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1901 Sunset Blvd | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984851.2986 | 2101988.3321 | 37.7507834123081 | -122.495253753816 | (37.7507834123081, -122.495253753816) | 1 | 8 | 3 | 29491 | 35 | |||
| 97343 | 187133 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2600 Sunset Blvd | 69 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985163.4571 | 2097445.4987 | 37.7383282936023 | -122.493839558913 | (37.7383282936023, -122.493839558913) | 1 | 8 | 3 | 29491 | 35 | |||
| 97385 | 112912 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 480X BEACON ST | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | 30 | 6002571 | 2098077 | 37.7410653426557 | -122.433697996676 | (37.7410653426557, -122.433697996676) | 2 | 7 | 5 | 63 | 7 | ||||
| 97674 | 8394 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 36 | 8 | 6004234.0356 | 2113977.7901 | 37.784819331933 | -122.429081276927 | (37.784819331933, -122.429081276927) | 13 | 9 | 11 | 29490 | 41 | |||
| 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 | |
| 99999 | 181379 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Sunset Blvd | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984933.4588 | 2104463.134 | 37.7575833453331 | -122.495152116603 | (37.7575833453331, -122.495152116603) | 1 | 8 | 3 | 56 | 35 | |||
| 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 | |||
| 101060 | 185902 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2000 Sunset Blvd | 45 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985031.1855 | 2101301.2352 | 37.7489073626901 | -122.494581050501 | (37.7489073626901, -122.494581050501) | 1 | 8 | 3 | 29491 | 35 | |||
| 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 | ||||
| 101800 | 8581 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 24 | 6 | 6000715.1007 | 2113420.9091 | 37.7830904567466 | -122.441215640748 | (37.7830904567466, -122.441215640748) | 15 | 5 | 1 | 29490 | 41 | |||
| 102914 | 187129 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2600 Sunset Blvd | 65 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 0ft | 5985149.8207 | 2097410.2322 | 37.7382306634066 | -122.493884107972 | (37.7382306634066, -122.493884107972) | 1 | 8 | 3 | 29491 | 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 | ||||
| 103704 | 255364 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700X Brotherhood Way | 2 | Median : Cutout | Tree | DPW 1 | 6x10 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 104823 | 181540 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1300 Sunset Blvd | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984863.0454 | 2105869.1102 | 37.7614396414651 | -122.495499326148 | (37.7614396414651, -122.495499326148) | 1 | 8 | 3 | 56 | 35 | |||
| 104913 | 185906 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2000 Sunset Blvd | 49 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985026.2976 | 2101345.2263 | 37.7490278641469 | -122.49460119526 | (37.7490278641469, -122.49460119526) | 1 | 8 | 3 | 29491 | 35 | |||
| 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 | |||||
| 106659 | 111575 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1x SUNSET BLVD OFF RAMP | 7 | Median : Cutout | Tree | DPW 1 | 5 | 3x3 | 5984955 | 2095624 | 37.7333147463652 | -122.494426056577 | (37.7333147463652, -122.494426056577) | 1 | 8 | 4 | 64 | 35 | |||
| 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 | |||
| 107231 | 8560 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 1 | 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 | ||
| 107565 | 252925 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Sanchez St | 2 | Front Yard : Yard | Tree | DPW 1 | 6003672 | 2104202 | 37.757945572264 | -122.430328029181 | (37.757945572264, -122.430328029181) | 2 | 4 | 5 | 28862 | 3 | |||||
| 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 | ||||
| 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 | |||
| 110569 | 8474 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1900 Geary Blvd | 11 | Median : Cutout | Tree | DPW 1 | 6 | 8 | 6001879.2717 | 2113651.882 | 37.7837908949329 | -122.437204633286 | (37.7837908949329, -122.437204633286) | 13 | 5 | 11 | 29490 | 41 | |||
| 110654 | 139356 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1350x GEARY BLVD | 5 | Median : Cutout | Tree | DPW 1 | 24 | Width 0ft | 6005063.0942 | 2114090.4032 | 37.7851754347521 | -122.426221023287 | (37.7851754347521, -122.426221023287) | 13 | 9 | 11 | 28858 | 41 | |||
| 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 | |||
| 113218 | 114925 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 4400x OCEAN AVE | 3 | 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 | |
| 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 | |||
| 116936 | 100068 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 303 Serrano Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2012 12:00:00 AM | Permit Number 769006 | 5990392 | 2090762 | 37.720281613079 | -122.47527420247 | (37.720281613079, -122.47527420247) | 1 | 8 | 4 | 64 | 40 | |||
| 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 | ||||
| 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 | |||
| 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 | ||
| 125671 | 91502 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 1501@Clearfield Sloat Blvd | 12 | 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 | ||
| 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 | ||
| 126819 | 257966 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 35 | 98X Clearfield Dr | 1 | Side Yard : Yard | Tree | Private 2 | 3x3 | Permit Number 782748 | 5986022 | 2095487 | 37.7330009680725 | -122.490727117227 | (37.7330009680725, -122.490727117227) | 1 | 8 | 4 | 64 | 35 | |||
| 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 | |||
| 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 | |
| 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 | |||
| 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 | ||||
| 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 | |||
| 132634 | 94230 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 1501@Everglade Sloat Blvd | 9 | 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 | ||
| 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 |
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) );