trees
66 rows where Police Districts = 3 and qLegalStatus_id = 9
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 675 | 150019 | Private 9 | Tree(s) :: 17 | 777 Tennessee St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2019 12:00:00 AM | 0 | 9x5 | Permit Number 776949 | 6015489.62882 | 2105456.11878 | 37.7620514180509 | -122.389544911688 | (37.7620514180509, -122.389544911688) | 10 | 3 | 8 | 28856 | 29 | |
| 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 | |
| 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 | |||
| 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 | |
| 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 | |||
| 3212 | 150016 | Private 9 | Tree(s) :: 17 | 777 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2019 12:00:00 AM | 0 | 9x5 | Permit Number 776949 | 6015494.18586 | 2105386.64383 | 37.7618609074738 | -122.389524298311 | (37.7618609074738, -122.389524298311) | 10 | 3 | 8 | 28856 | 29 | |
| 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 | |
| 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 | |
| 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 | ||
| 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 | |||
| 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 |
| 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 | ||
| 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 | ||
| 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 |
| 8842 | 150020 | Private 9 | Tree(s) :: 17 | 777 Tennessee St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2019 12:00:00 AM | 0 | 9x5 | Permit Number 776949 | 6015489.50926 | 2105477.62507 | 37.7621104630605 | -122.389546827243 | (37.7621104630605, -122.389546827243) | 10 | 3 | 8 | 28856 | 29 | |
| 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 | |
| 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 | |||
| 10049 | 261052 | Private 9 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Hooper St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013012.2905 | 2108046.92839 | 37.769027533769 | -122.398294909078 | (37.769027533769, -122.398294909078) | 14 | 3 | 8 | 28856 | 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 | |||
| 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 |
| 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 | |||
| 11563 | 259753 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1229 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6013525 | 2101361 | 37.7506979810533 | -122.396052856578 | (37.7506979810533, -122.396052856578) | 10 | 3 | 8 | 28856 | 1 | ||||
| 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 |
| 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 | |||
| 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 | |||
| 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 | |||
| 14046 | 262297 | Private 9 | Sequoia sempervirens :: Coast Redwood 155 | 666 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009767 | 2091318 | 37.722912259595 | -122.408340109411 | (37.722912259595, -122.408340109411) | 9 | 3 | 7 | 309 | 28 | ||||
| 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 | |||
| 14649 | 150018 | Private 9 | Tree(s) :: 17 | 777 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2019 12:00:00 AM | 0 | 9x5 | Permit Number 776949 | 6015492.47093 | 2105432.35195 | 37.7619863170408 | -122.389533421936 | (37.7619863170408, -122.389533421936) | 10 | 3 | 8 | 28856 | 29 | |
| 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 |
| 15916 | 150017 | Private 9 | Tree(s) :: 17 | 777 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2019 12:00:00 AM | 0 | 9x5 | Permit Number 776949 | 6015494.08881 | 2105409.25245 | 37.7619229804945 | -122.389526212978 | (37.7619229804945, -122.389526212978) | 10 | 3 | 8 | 28856 | 29 | |
| 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 | |
| 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 |
| 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 | |||
| 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 | |||
| 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 | |
| 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 | |||
| 19354 | 262188 | Private 9 | Jacaranda mimosifolia :: Jacaranda 50 | 490 Vermont St | 1 | Front Yard : Cutout | Tree | DPW 1 | 05/19/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784452 | 6011166 | 2106075 | 37.7635100471883 | -122.404542318782 | (37.7635100471883, -122.404542318782) | 8 | 3 | 8 | 28856 | 29 | |
| 19392 | 191529 | Private 9 | Liquidambar styraciflua :: American Sweet Gum 37 | 201 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6016082.02245 | 2107209.57323 | 37.7668988547309 | -122.387618372283 | (37.7668988547309, -122.387618372283) | 14 | 3 | 9 | 310 | 20 | |||
| 23936 | 22386 | Private 9 | Pyrus spp :: Pear Tree 281 | 1769X Armstrong Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6014045.0718623 | 2092725.5085003 | 37.7270156330804 | -122.393650054041 | (37.7270156330804, -122.393650054041) | 10 | 3 | 8 | 58 | 1 | |||
| 51620 | 26198 | Private 9 | Lophostemon confertus :: Brisbane Box 11 | 3830 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x4 | 6015747.5106038 | 2098323.3315623 | 37.742480578689 | -122.388155190044 | (37.742480578689, -122.388155190044) | 10 | 3 | 8 | 58 | 1 | |||
| 60173 | 80520 | Private 9 | Pyrus spp :: Pear Tree 281 | 2499X Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/07/2002 12:00:00 AM | 2 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 91085 | 111308 | Private 9 | Pinus radiata :: Monterey Pine 15 | 780x JAMESTOWN AVE | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6x90 | 6015099 | 2088640 | 37.7158561393861 | -122.389721379672 | (37.7158561393861, -122.389721379672) | 10 | 3 | 8 | 58 | 1 | ||||
| 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 | |||
| 94173 | 22382 | Private 9 | Pyrus spp :: Pear Tree 281 | 2499X Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1997 12:00:00 AM | 3 | 3X3 | 6014045.0718623 | 2092725.5085003 | 37.7270156330804 | -122.393650054041 | (37.7270156330804, -122.393650054041) | 10 | 3 | 8 | 58 | 1 | ||
| 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 | |||
| 108336 | 80517 | Private 9 | Pyrus spp :: Pear Tree 281 | 1769X Armstrong Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/07/2002 12:00:00 AM | 3 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | 10 | 3 | 8 | 58 | 1 | |||
| 123246 | 22155 | Private 9 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1570X FAIRFAX AVE | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3X3 | 6015579 | 2098247 | 37.7422616499572 | -122.388732527256 | (37.7422616499572, -122.388732527256) | 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 | |||
| 137357 | 117353 | Private 9 | Pittosporum crassifolium :: Karo Tree 95 | 101X China Basin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 772935 | 6015309.46376 | 2108739.72137 | 37.7710574836343 | -122.390397474374 | (37.7710574836343, -122.390397474374) | 14 | 3 | 9 | 310 | 20 | |||
| 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 | ||
| 142770 | 150735 | Private 9 | Cordyline australis :: Dracena Palm 64 | 783 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2019 12:00:00 AM | 3 | 3x3 | Permit Number 778950 | 6012760.80751 | 2103885.27159 | 37.7575865350131 | -122.398872659244 | (37.7575865350131, -122.398872659244) | 10 | 3 | 8 | 28856 | 29 | |
| 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 | |||
| 154962 | 22381 | Private 9 | Alnus rhombifolia :: White Alder 327 | 1780 Bancroft Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3X3 | 6014045.0718623 | 2092725.5085003 | 37.7270156330804 | -122.393650054041 | (37.7270156330804, -122.393650054041) | 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 | |||
| 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 |
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) );