trees
215 rows where qLegalStatus_id = 9 sorted by DBH descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
141800 | 80510 | Private 9 | Alnus rhombifolia :: White Alder 327 | 1740 Bancroft Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2007 12:00:00 AM | 9 | Permit Number 49651 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | 10 | 3 | 8 | 58 | 1 | ||
169586 | 80512 | Private 9 | Alnus rhombifolia :: White Alder 327 | 1740 Bancroft Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/07/2002 12:00:00 AM | 9 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | 10 | 3 | 8 | 58 | 1 | |||
190102 | 104109 | Private 9 | Maytenus boaria :: Mayten 58 | 342-346 MOULTRIE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x6 | 6007700 | 2097518 | 37.7398201496863 | -122.415924151926 | (37.7398201496863, -122.415924151926) | 2 | 7 | 7 | 28859 | 2 | |||
64184 | 80593 | Private 9 | Alnus rhombifolia :: White Alder 327 | 1780 Bancroft Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/07/2002 12:00:00 AM | 7 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | 10 | 3 | 8 | 58 | 1 | |||
109240 | 115128 | Private 9 | Geijera parviflora :: Australian Willow 25 | 499X MAIN ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 6015842 | 2114626 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | 6 | 2 | 9 | 28855 | 6 | ||||
188939 | 104962 | Private 9 | Jacaranda mimosifolia :: Jacaranda 50 | 1474X SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 74 Aztec St. | 6008023 | 2099506 | 37.7452969115591 | -122.414948020341 | (37.7452969115591, -122.414948020341) | 2 | 7 | 7 | 28859 | 2 | ||
88394 | 39627 | Private 9 | Platanus x hispanica :: Sycamore: London Plane 27 | 199X Carmel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | 6 | Permit Number 775173 | 5997915.23661319 | 2105333.02481713 | 37.7607233191374 | -122.450318782133 | (37.7607233191374, -122.450318782133) | 15 | 5 | 11 | 29492 | 12 | |
103402 | 3610 | Private 9 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 205 | 100X Cargo Way | 46 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6018056.23038 | 2098180.90993 | 37.7422171644003 | -122.380162344118 | (37.7422171644003, -122.380162344118) | 10 | 3 | 8 | 58 | 1 | |||
126097 | 39629 | Private 9 | Platanus x hispanica :: Sycamore: London Plane 27 | 199X Carmel St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | 6 | Permit Number 775173 | 5997915.23661319 | 2105333.02481713 | 37.7607233191374 | -122.450318782133 | (37.7607233191374, -122.450318782133) | 15 | 5 | 11 | 29492 | 12 | |
128761 | 115129 | Private 9 | Geijera parviflora :: Australian Willow 25 | 499X MAIN ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 6015842 | 2114626 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | 6 | 2 | 9 | 28855 | 6 | ||||
132854 | 25212 | Private 9 | Lophostemon confertus :: Brisbane Box 11 | 215X Fell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6006420.22763 | 2110742.05634 | 37.7760583047566 | -122.421287897592 | (37.7760583047566, -122.421287897592) | 7 | 9 | 11 | 28852 | 10 | |||
168048 | 122898 | Private 9 | Podocarpus gracilor :: Fern Pine 51 | 198X San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6006160 | 2102149 | 37.7524491239798 | -122.421577653162 | (37.7524491239798, -122.421577653162) | 2 | 4 | 5 | 28859 | 19 | |||
2898 | 191530 | Private 9 | Liquidambar styraciflua :: American Sweet Gum 37 | 201 16th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6016138.64503 | 2107209.62915 | 37.7669021444474 | -122.387422526024 | (37.7669021444474, -122.387422526024) | 14 | 3 | 9 | 310 | 20 | |||
3180 | 191527 | Private 9 | Liquidambar styraciflua :: American Sweet Gum 37 | 201 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6016025.61335 | 2107205.30438 | 37.7668840087222 | -122.387813186138 | (37.7668840087222, -122.387813186138) | 14 | 3 | 9 | 310 | 20 | |||
10235 | 191533 | Private 9 | Liquidambar styraciflua :: American Sweet Gum 37 | 201 16th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6016236.27796 | 2107216.03359 | 37.7669251365154 | -122.387085273085 | (37.7669251365154, -122.387085273085) | 14 | 3 | 9 | 310 | 20 | |||
10795 | 188785 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499 Illinois St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6015978.05896 | 2106829.43815 | 37.7658493270204 | -122.38795143981 | (37.7658493270204, -122.38795143981) | 14 | 3 | 9 | 310 | 20 | |||
11397 | 191531 | Private 9 | Liquidambar styraciflua :: American Sweet Gum 37 | 201 16th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6016181.25153 | 2107212.70143 | 37.7669129399083 | -122.387275369984 | (37.7669129399083, -122.387275369984) | 14 | 3 | 9 | 310 | 20 | |||
13982 | 189273 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 409 Illinois St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015966.51086 | 2107036.5181 | 37.7664172839651 | -122.388005834417 | (37.7664172839651, -122.388005834417) | 14 | 3 | 9 | 310 | 20 | |||
17659 | 188786 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499 Illinois St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6015977.25571 | 2106854.57611 | 37.7659183059205 | -122.387955972402 | (37.7659183059205, -122.387955972402) | 14 | 3 | 9 | 310 | 20 | |||
18111 | 191532 | Private 9 | Liquidambar styraciflua :: American Sweet Gum 37 | 201 16th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6016209.16515 | 2107214.5091 | 37.766919449199 | -122.38717894647 | (37.766919449199, -122.38717894647) | 14 | 3 | 9 | 310 | 20 | |||
143868 | 80518 | Private 9 | Pyrus spp :: Pear Tree 281 | 1769X Armstrong Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/07/2002 12:00:00 AM | 5 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | 10 | 3 | 8 | 58 | 1 | |||
166399 | 39628 | Private 9 | Platanus x hispanica :: Sycamore: London Plane 27 | 199X Carmel St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | 5 | Permit Number 775173 | 5997915.23661319 | 2105333.02481713 | 37.7607233191374 | -122.450318782133 | (37.7607233191374, -122.450318782133) | 15 | 5 | 11 | 29492 | 12 | |
141416 | 118356 | Private 9 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 RACCOON DR | 2 | Back Yard : Cutout | Tree | Private 2 | 48 | 5998776 | 2103987 | 37.7570766935068 | -122.447244922317 | (37.7570766935068, -122.447244922317) | 15 | 5 | 5 | 63 | 3 | ||||
69100 | 104567 | Private 9 | Tree(s) :: 17 | 8 JOY ST | 2 | Front Yard : Yard | Tree | Private 2 | 40 | 6010448 | 2098932 | 37.7438568002142 | -122.406522292508 | (37.7438568002142, -122.406522292508) | 2 | 7 | 7 | 28859 | 2 | ||||
70534 | 104510 | Private 9 | Sequoia sempervirens :: Coast Redwood 155 | 254 ALLISON ST | 1 | Back Yard : Yard | Tree | Private 2 | 40 | 6000052 | 2087408 | 37.7116274717654 | -122.441642291463 | (37.7116274717654, -122.441642291463) | 9 | 7 | 6 | 28861 | 5 | ||||
85850 | 114258 | Private 9 | Pinus radiata :: Monterey Pine 15 | 70x CHUMASERO DR | 1 | Front Yard : Yard | Tree | Private 2 | 40 | 5990913 | 2088468 | 37.714013037331 | -122.473306070941 | (37.714013037331, -122.473306070941) | 1 | 8 | 4 | 64 | 14 | ||||
2007 | 188784 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499 Illinois St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 6ft | 6015979.83831 | 2106803.95395 | 37.7657794514949 | -122.387943506912 | (37.7657794514949, -122.387943506912) | 14 | 3 | 9 | 310 | 20 | |||
5864 | 189275 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 409 Illinois St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015964.59668 | 2107087.77889 | 37.7665579289401 | -122.388016032733 | (37.7665579289401, -122.388016032733) | 14 | 3 | 9 | 310 | 20 | |||
9264 | 188788 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 409 Illinois St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015967.32751 | 2107012.0323 | 37.7663500965054 | -122.388001300914 | (37.7663500965054, -122.388001300914) | 14 | 3 | 9 | 310 | 20 | |||
9799 | 188783 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499 Illinois St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 6ft | 6015981.68348 | 2106781.73126 | 37.7657185350155 | -122.387935573977 | (37.7657185350155, -122.387935573977) | 14 | 3 | 9 | 310 | 20 | |||
13110 | 188782 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499 Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 6ft | 6015982.12636 | 2106754.96915 | 37.7656450765832 | -122.387932174526 | (37.7656450765832, -122.387932174526) | 14 | 3 | 9 | 310 | 20 | |||
14181 | 188787 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 409 Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015968.04519 | 2106982.6549 | 37.7662694722874 | -122.387996768362 | (37.7662694722874, -122.387996768362) | 14 | 3 | 9 | 310 | 20 | |||
18169 | 189274 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 409 Illinois St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015965.43281 | 2107064.27168 | 37.7664934295578 | -122.388011500129 | (37.7664934295578, -122.388011500129) | 14 | 3 | 9 | 310 | 20 | |||
18958 | 191526 | Private 9 | Liquidambar styraciflua :: American Sweet Gum 37 | 201 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015996.43331 | 2107204.26168 | 37.7668795291963 | -122.387914043316 | (37.7668795291963, -122.387914043316) | 14 | 3 | 9 | 310 | 20 | |||
83952 | 109126 | Private 9 | Schinus molle :: California Pepper 91 | 890x CASTRO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6002411 | 2103002 | 37.7545791519678 | -122.434603290485 | (37.7545791519678, -122.434603290485) | 2 | 4 | 5 | 28862 | 22 | |||
92274 | 80514 | Private 9 | Pyrus spp :: Pear Tree 281 | 1769X Armstrong Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/07/2002 12:00:00 AM | 4 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | 10 | 3 | 8 | 58 | 1 | |||
133648 | 80515 | Private 9 | Pyrus spp :: Pear Tree 281 | 1769X Armstrong Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/07/2002 12:00:00 AM | 4 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | 10 | 3 | 8 | 58 | 1 | |||
164704 | 80516 | Private 9 | Pyrus spp :: Pear Tree 281 | 1769X Armstrong Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/07/2002 12:00:00 AM | 4 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | 10 | 3 | 8 | 58 | 1 | |||
53506 | 108816 | Private 9 | Pinus radiata :: Monterey Pine 15 | 348 Gold Mine Dr | 1 | Back Yard : Yard | Tree | Private 2 | 30 | 6001084 | 2097744 | 37.740066514789 | -122.438815634293 | (37.740066514789, -122.438815634293) | 2 | 7 | 5 | 63 | 7 | ||||
112528 | 104689 | Private 9 | Pinus radiata :: Monterey Pine 15 | 657 PALMETTO AVE | 1 | Back Yard : Yard | Tree | Private 2 | 30 | 5991786 | 2087190.1 | 37.7105547448876 | -122.470195680575 | (37.7105547448876, -122.470195680575) | 9 | 8 | 4 | 64 | 24 | ||||
60 | 264971 | Private 9 | Ulmus parvifolia :: Chinese Elm 31 | 150 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/2020 12:00:00 AM | 3 | 5990555.23468 | 2114396.47455 | 37.7851851170506 | -122.476435559205 | (37.7851851170506, -122.476435559205) | 11 | 6 | 2 | 54 | 26 | |||
585 | 75271 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499 Illinois St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6015975.8041 | 2106880.05369 | 37.7659881814233 | -122.387962771269 | (37.7659881814233, -122.387962771269) | 14 | 3 | 9 | 310 | 20 | ||
893 | 226590 | Private 9 | Eriobotrya deflexa :: Bronze Loquat 8 | 837 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Port | 08/14/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784594 | 6001099.54842 | 2099653.23365 | 37.7453097044788 | -122.438898660558 | (37.7453097044788, -122.438898660558) | 2 | 4 | 5 | 63 | 22 |
1077 | 149677 | Private 9 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 2100x Mariposa St | 1 | Front Yard : Cutout | Tree | DPW 1 | 05/19/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 784452 | 6011154.9566 | 2106050.92707 | 37.7634433311543 | -122.404578819881 | (37.7634433311543, -122.404578819881) | 8 | 3 | 8 | 28856 | 29 | |
2295 | 193115 | Private 9 | Tree(s) :: 17 | 1791 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 4x3 | Permit Number 782693 | 6014511.3912 | 2096886.32335 | 37.7384662854853 | -122.392328872775 | (37.7384662854853, -122.392328872775) | 10 | 3 | 8 | 58 | 1 | |
2685 | 264708 | Private 9 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4345 Clement St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/17/2020 12:00:00 AM | 3 | 5982064.28374 | 2113052.50483 | 37.7809988756405 | -122.505711450059 | (37.7809988756405, -122.505711450059) | 11 | 6 | 2 | 55 | 26 | |||
3361 | 261454 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
3416 | 262187 | Private 9 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 2100x Mariposa St | 4 | Front Yard : Cutout | Tree | DPW 1 | 05/19/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 784452 | 6011170 | 2106024 | 37.76337023621 | -122.404524893747 | (37.76337023621, -122.404524893747) | 8 | 3 | 8 | 28856 | 29 | |
3984 | 243570 | Private 9 | Eriobotrya deflexa :: Bronze Loquat 8 | 837 Duncan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Port | 3 | 3x3 | Permit Number 784594 | 6001117.2647 | 2099653.19311 | 37.7453106011164 | -122.438837397829 | (37.7453106011164, -122.438837397829) | 2 | 4 | 5 | 63 | 22 | |
4077 | 102546 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 409 Illinois St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6015961.34604 | 2107137.76144 | 37.7666949900978 | -122.388030764508 | (37.7666949900978, -122.388030764508) | 14 | 3 | 9 | 310 | 20 | ||
4192 | 264915 | Private 9 | Pistacia chinensis :: Chinese Pistache 32 | 1461 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/09/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784397 | 6015819.34366 | 2093828.22518 | 37.7301419060949 | -122.387593270969 | (37.7301419060949, -122.387593270969) | 10 | 3 | 8 | 58 | 1 | |
4221 | 160246 | Private 9 | Potential Site :: Potential Site 48 | 962 Edinburgh St | 1 | Front Yard : Cutout | Tree | Private 2 | DPW | 02/20/2020 12:00:00 AM | 3 | 3x3 | Permit Number 779047 | 6001480.24176 | 2088600.7563 | 37.7149837880375 | -122.436791243222 | (37.7149837880375, -122.436791243222) | 9 | 7 | 6 | 28861 | 5 |
4850 | 262150 | Private 9 | Lagunaria patersonii :: Primrose Tree 6 | 1295 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2020 12:00:00 AM | 3 | 3x3 | 5981486.26206 | 2106277.60943 | 37.7623629555319 | -122.50720831894 | (37.7623629555319, -122.50720831894) | 1 | 8 | 3 | 56 | 35 | ||
4984 | 154060 | Private 9 | Tree(s) :: 17 | 1796 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 4x3 | Permit Number 782693 | 6014554.77098 | 2096926.88452 | 37.7385800668269 | -122.392181721216 | (37.7385800668269, -122.392181721216) | 10 | 3 | 8 | 58 | 1 | |
5551 | 74240 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499 Illinois St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6015971.85212 | 2106927.76687 | 37.7661189725478 | -122.387979770277 | (37.7661189725478, -122.387979770277) | 14 | 3 | 9 | 310 | 20 | ||
5653 | 215048 | Private 9 | Olea europaea :: Olive Tree 9 | 1719 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782897 | 5990885.18116 | 2103671.34742 | 37.7557559568771 | -122.474511074324 | (37.7557559568771, -122.474511074324) | 1 | 8 | 4 | 56 | 12 | |
6336 | 261055 | Private 9 | Afrocarpus gracilior :: Fern Pine 89 | 1948 Quesada Ave | 1 | Front Yard : Cutout | Tree | Private 2 | DPW | 11/20/2019 12:00:00 AM | 3 | 3x3 | Permit Number 780729 | 6013389.35902 | 2096036.97619 | 37.7360717858924 | -122.396148836191 | (37.7360717858924, -122.396148836191) | 10 | 3 | 8 | 58 | 1 |
6683 | 262152 | Private 9 | Lagunaria patersonii :: Primrose Tree 6 | 1295 47th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2020 12:00:00 AM | 3 | 3x3 | 5981486.26206 | 2106277.60943 | 37.7623629555319 | -122.50720831894 | (37.7623629555319, -122.50720831894) | 1 | 8 | 3 | 56 | 35 | ||
6900 | 102545 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 409 Illinois St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6015962.79104 | 2107111.95809 | 37.7666242197475 | -122.38802396564 | (37.7666242197475, -122.38802396564) | 14 | 3 | 9 | 310 | 20 | ||
7177 | 74026 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499 Illinois St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6015970.5058 | 2106958.46215 | 37.7662031805546 | -122.387986569137 | (37.7662031805546, -122.387986569137) | 14 | 3 | 9 | 310 | 20 | ||
8142 | 262151 | Private 9 | Lagunaria patersonii :: Primrose Tree 6 | 1295 47th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2020 12:00:00 AM | 3 | 3x3 | 5981486.26206 | 2106277.60943 | 37.7623629555319 | -122.50720831894 | (37.7623629555319, -122.50720831894) | 1 | 8 | 3 | 56 | 35 | ||
8224 | 254835 | Private 9 | Ulmus parvifolia :: Chinese Elm 31 | 250 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2019 12:00:00 AM | 3 | 4x3 | Permit Number 784635 | 5989365 | 2113673 | 37.7831295589045 | -122.480500378386 | (37.7831295589045, -122.480500378386) | 11 | 6 | 2 | 55 | 26 |
8242 | 264706 | Private 9 | Lagunaria patersonii :: Primrose Tree 6 | 4345 Clement St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2020 12:00:00 AM | 3 | 5982064.28374 | 2113052.50483 | 37.7809988756405 | -122.505711450059 | (37.7809988756405, -122.505711450059) | 11 | 6 | 2 | 55 | 26 | |||
8331 | 191528 | Private 9 | Liquidambar styraciflua :: American Sweet Gum 37 | 201 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2017 12:00:00 AM | 3 | Width 5ft | 6016052.47786 | 2107208.19392 | 37.76689343092 | -122.387720466935 | (37.76689343092, -122.387720466935) | 14 | 3 | 9 | 310 | 20 | ||
8424 | 261322 | Private 9 | :: 45 | 811 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/02/2020 12:00:00 AM | 3 | 3x3 | ||||||||||||
8479 | 204048 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
8824 | 261056 | Private 9 | Afrocarpus gracilior :: Fern Pine 89 | 1952 Quesada Ave | 1 | Front Yard : Cutout | Tree | Private 2 | DPW | 11/20/2019 12:00:00 AM | 3 | 3x3 | Permit Number 780727 | 6013369.93114 | 2096051.4395 | 37.7361104181421 | -122.396217020065 | (37.7361104181421, -122.396217020065) | 10 | 3 | 8 | 58 | 1 |
8858 | 261455 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
8898 | 149678 | Private 9 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 2100x Mariposa St | 2 | Front Yard : Cutout | Tree | DPW 1 | 05/19/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 784452 | 6011170 | 2106024 | 37.76337023621 | -122.404524893747 | (37.76337023621, -122.404524893747) | 8 | 3 | 8 | 28856 | 29 | |
9465 | 260400 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 190 Parker Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2019 12:00:00 AM | 3 | 5996965.93026 | 2113053.17261 | 37.7818664738231 | -122.454159603161 | (37.7818664738231, -122.454159603161) | 11 | 6 | 1 | 54 | 31 | |||
10003 | 264730 | Private 9 | Magnolia grandiflora :: Southern Magnolia 19 | 748 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/23/2020 12:00:00 AM | 3 | 6002983.4557 | 2109619.25261 | 37.7727810060219 | -122.433096352422 | (37.7727810060219, -122.433096352422) | 15 | 5 | 11 | 29492 | 9 | |||
10283 | 264747 | Private 9 | Pittosporum undulatum :: Victorian Box 36 | 2002 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2020 12:00:00 AM | 3 | 3x3 | 6001953.79528 | 2115381.82831 | 37.7885451212547 | -122.437070707369 | (37.7885451212547, -122.437070707369) | 13 | 6 | 1 | 29490 | 27 | ||
10378 | 163649 | Private 9 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 226 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 07/01/2020 12:00:00 AM | 3 | 3x4 | Permit Number 784460 | 5994737.04022 | 2087470.63166 | 37.71149518743 | -122.460016622663 | (37.71149518743, -122.460016622663) | 9 | 8 | 6 | 28861 | 24 |
10549 | 38556 | Private 9 | Tree(s) :: 17 | 1791 La Salle Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 3 | 4x3 | Permit Number 782693 | 6014562.13286 | 2096849.44481 | 37.7383678420956 | -122.39215085288 | (37.7383678420956, -122.39215085288) | 10 | 3 | 8 | 58 | 1 |
10609 | 262014 | Private 9 | Magnolia grandiflora :: Southern Magnolia 19 | 1591 Page St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2020 12:00:00 AM | 3 | 3x3 | 5998968.26858 | 2109018.36861 | 37.7709025542262 | -122.446942035054 | (37.7709025542262, -122.446942035054) | 15 | 5 | 11 | 29492 | 9 | ||
10772 | 264676 | Private 9 | Cassia leptophylla :: Gold Medallion Tree 152 | 668 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2020 12:00:00 AM | 3 | 3x3 | 6003797.75621 | 2110080.31484 | 37.7740931268852 | -122.430312496695 | (37.7740931268852, -122.430312496695) | 7 | 9 | 11 | 29492 | 10 | ||
11157 | 261456 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
11239 | 260905 | Private 9 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2211 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2019 12:00:00 AM | 3 | 2X3 | 6007589.07412 | 2119959.01259 | 37.8014316343257 | -122.417898047397 | (37.8014316343257, -122.417898047397) | 5 | 1 | 1 | 28858 | 32 | ||
11394 | 260246 | Private 9 | Magnolia spp :: Magnolia 224 | 568 Huron Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/14/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784595 | 5998297.39121 | 2088148.96817 | 37.7135618752392 | -122.447759972312 | (37.7135618752392, -122.447759972312) | 9 | 7 | 6 | 28861 | 25 | |
12190 | 260906 | Private 9 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2215 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2019 12:00:00 AM | 3 | 2X3 | 6007586.25473 | 2119982.21322 | 37.8014951787433 | -122.417909449339 | (37.8014951787433, -122.417909449339) | 5 | 1 | 1 | 28858 | 32 | ||
12542 | 262149 | Private 9 | Lagunaria patersonii :: Primrose Tree 6 | 4600 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2020 12:00:00 AM | 3 | |||||||||||||
12761 | 261857 | Private 9 | Pistacia chinensis :: Chinese Pistache 32 | 176 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2020 12:00:00 AM | 3 | 5992988.80812 | 2088380.73889 | 37.7138934199028 | -122.466125014283 | (37.7138934199028, -122.466125014283) | 9 | 8 | 6 | 64 | 24 | |||
12794 | 262012 | Private 9 | Magnolia grandiflora :: Southern Magnolia 19 | 1591 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2020 12:00:00 AM | 3 | 3x3 | 5998968.26858 | 2109018.36861 | 37.7709025542262 | -122.446942035054 | (37.7709025542262, -122.446942035054) | 15 | 5 | 11 | 29492 | 9 | ||
12863 | 154063 | Private 9 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1781 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 4x3 | Permit Number 782693 | 6014599.10763 | 2096821.84485 | 37.7382941111836 | -122.392021081628 | (37.7382941111836, -122.392021081628) | 10 | 3 | 8 | 58 | 1 |
12902 | 262013 | Private 9 | Magnolia grandiflora :: Southern Magnolia 19 | 1591 Page St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2020 12:00:00 AM | 3 | 3x3 | 5998968.26858 | 2109018.36861 | 37.7709025542262 | -122.446942035054 | (37.7709025542262, -122.446942035054) | 15 | 5 | 11 | 29492 | 9 | ||
13028 | 264748 | Private 9 | Pittosporum undulatum :: Victorian Box 36 | 2002 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2020 12:00:00 AM | 3 | 3x3 | 6001953.79528 | 2115381.82831 | 37.7885451212547 | -122.437070707369 | (37.7885451212547, -122.437070707369) | 13 | 6 | 1 | 29490 | 27 | ||
13426 | 260872 | Private 9 | Tree(s) :: 17 | 1736 Fitzgerald Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3 | 3x3 | 6011805.50809 | 2092676.7551 | 37.7267570649137 | -122.401388810186 | (37.7267570649137, -122.401388810186) | 10 | 3 | 8 | 58 | 1 | |||
14848 | 260375 | Private 9 | Tree(s) :: 17 | 67 Allison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784562 | 5999904.1409 | 2088281.96487 | 37.714018757491 | -122.442216028541 | (37.714018757491, -122.442216028541) | 9 | 7 | 6 | 28861 | 5 |
15121 | 261452 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
15228 | 261687 | Private 9 | Tree(s) :: 17 | 2067 Bancroft Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 02/20/2020 12:00:00 AM | 3 | 4x4 | Permit Number 782291 | 6011786.16554 | 2094038.32843 | 37.730494584078 | -122.401551330673 | (37.730494584078, -122.401551330673) | 10 | 3 | 8 | 58 | 1 |
15415 | 261457 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
15771 | 259520 | Private 9 | :: 45 | 190 Parker Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2019 12:00:00 AM | 3 | 5996965.93026 | 2113053.17261 | 37.7818664738231 | -122.454159603161 | (37.7818664738231, -122.454159603161) | 11 | 6 | 1 | 54 | 31 | |||
16385 | 154062 | Private 9 | Tree(s) :: 17 | 1791 La Salle Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 4x3 | Permit Number 782693 | 6014575.41577 | 2096839.56035 | 37.7383414389075 | -122.392104235638 | (37.7383414389075, -122.392104235638) | 10 | 3 | 8 | 58 | 1 | |
16566 | 261453 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
17012 | 262011 | Private 9 | Magnolia grandiflora :: Southern Magnolia 19 | 1591 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2020 12:00:00 AM | 3 | 3x3 | 5998968.26858 | 2109018.36861 | 37.7709025542262 | -122.446942035054 | (37.7709025542262, -122.446942035054) | 15 | 5 | 11 | 29492 | 9 | ||
17556 | 75105 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499 Illinois St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6015973.99843 | 2106904.23323 | 37.7660544731729 | -122.387970704195 | (37.7660544731729, -122.387970704195) | 14 | 3 | 9 | 310 | 20 | ||
17564 | 38555 | Private 9 | Tree(s) :: 17 | 1791 La Salle Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 3 | 4x3 | Permit Number 782693 | 6014548.4967 | 2096859.88077 | 37.7383957399564 | -122.392198730091 | (37.7383957399564, -122.392198730091) | 10 | 3 | 8 | 58 | 1 |
17698 | 264705 | Private 9 | Lagunaria patersonii :: Primrose Tree 6 | 4345 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2020 12:00:00 AM | 3 | 5982064.28374 | 2113052.50483 | 37.7809988756405 | -122.505711450059 | (37.7809988756405, -122.505711450059) | 11 | 6 | 2 | 55 | 26 | |||
17787 | 264681 | Private 9 | Magnolia grandiflora :: Southern Magnolia 19 | 840 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2020 12:00:00 AM | 3 | Permit Number 785486 | 5982954.56765 | 2110060.16253 | 37.7728351334222 | -122.502410039067 | (37.7728351334222, -122.502410039067) | 11 | 6 | 2 | 55 | 26 | ||
18413 | 149679 | Private 9 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 2100x Mariposa St | 3 | Front Yard : Cutout | Tree | DPW 1 | 05/19/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 784452 | 6011170 | 2106024 | 37.76337023621 | -122.404524893747 | (37.76337023621, -122.404524893747) | 8 | 3 | 8 | 28856 | 29 |
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) );