261 rows where qCaretaker_id = 8 sorted by Fire Prevention Districts

View and edit SQL

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)
99292 11656 Permitted Site 7 Ulmus pumila :: Siberian Elm 99 699X Junipero Serra Blvd 16 Sidewalk: Curb side : Cutout Tree PUC 8     18 3   5991405.9818619 2093130.1790735 37.7268427672434 -122.471941747662 (37.7268427672434, -122.471941747662) 9 8 4 59 40
99349 11760 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 999X Junipero Serra Blvd 1 Sidewalk: Curb side : Cutout Tree PUC 8     24 3x3   5991260.9047733 2090529.2081036 37.7196927494004 -122.472253753748 (37.7196927494004, -122.472253753748) 9 8 6 64 24
100294 11789 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1199X Junipero Serra Blvd 10 Sidewalk: Curb side : Cutout Tree PUC 8     24 3x4   5991174.5545657 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828) 9 8 6 64 24
100357 11657 Permitted Site 7 Fraxinus spp :: Ash Spp 121 699X Junipero Serra Blvd 18 Sidewalk: Curb side : Cutout Tree PUC 8     12 3   5991405.9818619 2093130.1790735 37.7268427672434 -122.471941747662 (37.7268427672434, -122.471941747662) 9 8 4 59 40
100522 11761 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 999X Junipero Serra Blvd 3 Sidewalk: Curb side : Cutout Tree PUC 8   01/18/2008 12:00:00 AM 3 3x3   5991260.9047733 2090529.2081036 37.7196927494004 -122.472253753748 (37.7196927494004, -122.472253753748) 9 8 6 64 24
101704 87697 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 699X Junipero Serra Blvd 12 Sidewalk: Curb side : Cutout Tree PUC 8   01/18/2008 12:00:00 AM 3 3x3   5991401.754734 2093132.84952 37.7268498550224 -122.471956555148 (37.7268498550224, -122.471956555148) 9 8 4 59 40
106861 27800 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 799X Junipero Serra Blvd 3 Sidewalk: Curb side : Cutout Tree PUC 8   03/17/2001 12:00:00 AM 12 3   5991356.324435 2092039.0089713 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425) 9 8 4 59 40
108007 11876 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1501X Junipero Serra Blvd 2 Sidewalk: Curb side : Cutout Tree PUC 8     12 3X3   5991566.1252788 2087212.7603742 37.7106042506249 -122.470957258061 (37.7106042506249, -122.470957258061) 9 8 4 64 24
110339 87629 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 900X Junipero Serra Blvd 1 Sidewalk: Curb side : Cutout Tree PUC 8   01/18/2008 12:00:00 AM 3 3x3   5991221.225523 2091214.465808 37.7215720016004 -122.472440839907 (37.7215720016004, -122.472440839907) 9 8 4 64 40
114230 11633 Permitted Site 7 Ulmus pumila :: Siberian Elm 99 499X Junipero Serra Blvd 1 Sidewalk: Curb side : Cutout Tree PUC 8     30 3   5991474.53212 2093889.5616418 37.7289318087747 -122.471760091134 (37.7289318087747, -122.471760091134) 9 8 4 59 40
116132 11816 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 1201X Junipero Serra Blvd 2 Sidewalk: Curb side : Cutout Tree PUC 8     6 3X3   5991184.5559808 2089595.7938425 37.7171254042551 -122.472449649239 (37.7171254042551, -122.472449649239) 9 8 6 64 24
117481 11872 Permitted Site 7 Juglans hindsii :: Walnut: Black (n.calif) 457 1499X Junipero Serra Blvd 2 Sidewalk: Curb side : Cutout Tree PUC 8     30 3   5991566.5284818 2087248.8358641 37.7107033285334 -122.470958490818 (37.7107033285334, -122.470958490818) 9 8 4 64 24
117872 11693 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 799X Junipero Serra Blvd 10 Sidewalk: Curb side : Cutout Tree PUC 8     30 3   5991356.324435 2092039.0089713 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425) 9 8 4 59 40
118544 11877 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1501X Junipero Serra Blvd 3 Sidewalk: Curb side : Cutout Tree PUC 8     18 3X3   5991566.1252788 2087212.7603742 37.7106042506249 -122.470957258061 (37.7106042506249, -122.470957258061) 9 8 4 64 24
119183 11700 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 799X Junipero Serra Blvd 32 Sidewalk: Curb side : Cutout Tree PUC 8     18 3   5991356.324435 2092039.0089713 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425) 9 8 4 59 40
119413 11722 Permitted Site 7 Ulmus pumila :: Siberian Elm 99 899X Junipero Serra Blvd 13 Sidewalk: Curb side : Cutout Tree PUC 8     18 3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960662 (37.7216528879997, -122.47220960662) 9 8 4 64 40
119872 11873 Permitted Site 7 Ulmus pumila :: Siberian Elm 99 1499X Junipero Serra Blvd 3 Sidewalk: Curb side : Cutout Tree PUC 8     30 3   5991566.5284818 2087248.8358641 37.7107033285334 -122.470958490818 (37.7107033285334, -122.470958490818) 9 8 4 64 24
123948 75029 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 141X Arleta Ave 1 Sidewalk: Curb side : Cutout Tree PUC 8 FUF 02/24/2016 12:00:00 AM 3   This record is for lthe ot between 141-143 Arleta Ave. 6010470.01061258 2087860.00753073 37.7134566637798 -122.405666490875 (37.7134566637798, -122.405666490875) 9 7 8 309 39
126039 24400 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 799X Junipero Serra Blvd 22 Sidewalk: Curb side : Cutout Tree PUC 8   06/15/1995 12:00:00 AM 6 3x3   5991356.324435 2092039.0089713 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425) 9 8 4 59 40
126974 11648 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 699X Junipero Serra Blvd 3 Sidewalk: Curb side : Cutout Tree PUC 8   01/28/2000 12:00:00 AM 3 3   5991405.9818619 2093130.1790735 37.7268427672434 -122.471941747662 (37.7268427672434, -122.471941747662) 9 8 4 59 40
131171 24456 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 799X Junipero Serra Blvd 31 Sidewalk: Curb side : Cutout Tree PUC 8   06/22/1995 12:00:00 AM 12 3   5991356.324435 2092039.0089713 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425) 9 8 4 59 40
131664 87713 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1199X Junipero Serra Blvd 11 Sidewalk: Curb side : Cutout Tree PUC 8   01/18/2008 12:00:00 AM 3 3x3   5991170.406953 2089609.549246 37.7171623542714 -122.472499557475 (37.7171623542714, -122.472499557475) 9 8 6 64 24
132022 87700 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 799X Junipero Serra Blvd 25 Sidewalk: Curb side : Cutout Tree PUC 8   01/18/2008 12:00:00 AM 3 3x3   5991351.334229 2092039.32129 37.7238443805247 -122.472051185335 (37.7238443805247, -122.472051185335) 9 8 4 59 40
132074 11715 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 899X Junipero Serra Blvd 2 Sidewalk: Curb side : Cutout Tree PUC 8   06/15/1995 12:00:00 AM 12 3X3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960662 (37.7216528879997, -122.47220960662) 9 8 4 64 40
132603 74892 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 141X Arleta Ave 2 Sidewalk: Curb side : Cutout Tree PUC 8 FUF 02/24/2016 12:00:00 AM 3   This is for the trees adjacent to the lot between 141-143 Arleta 6010470.01061258 2087860.00753073 37.7134566637798 -122.405666490875 (37.7134566637798, -122.405666490875) 9 7 8 309 39
134137 24414 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1199X Junipero Serra Blvd 17 Sidewalk: Curb side : Cutout Tree PUC 8   06/23/1995 12:00:00 AM 12 3x3   5991174.5545657 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828) 9 8 6 64 24
134245 11817 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1201X Junipero Serra Blvd 3 Sidewalk: Curb side : Cutout Tree PUC 8     12 3X3   5991184.5559808 2089595.7938425 37.7171254042551 -122.472449649239 (37.7171254042551, -122.472449649239) 9 8 6 64 24
134263 11686 Permitted Site 7 Ulmus pumila :: Siberian Elm 99 799X Junipero Serra Blvd 8 Sidewalk: Curb side : Cutout Tree PUC 8     30 3x3   5991356.324435 2092039.0089713 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425) 9 8 4 59 40
137783 26171 Permitted Site 7 Ulmus pumila :: Siberian Elm 99 799X Junipero Serra Blvd 16 Sidewalk: Curb side : Cutout Tree PUC 8   03/01/2000 12:00:00 AM 30 3x3   5991356.324435 2092039.0089713 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425) 9 8 4 59 40
141108 11786 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1199X Junipero Serra Blvd 2 Sidewalk: Curb side : Cutout Tree PUC 8   03/17/2001 12:00:00 AM 6 3x4   5991174.5545657 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828) 9 8 6 64 24
141266 11695 Permitted Site 7 Ulmus pumila :: Siberian Elm 99 799X Junipero Serra Blvd 12 Sidewalk: Curb side : Cutout Tree PUC 8     18 3   5991356.324435 2092039.0089713 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425) 9 8 4 59 40
144238 11689 Permitted Site 7 Ulmus pumila :: Siberian Elm 99 799X Junipero Serra Blvd 2 Sidewalk: Curb side : Cutout Tree PUC 8     30 3   5991356.324435 2092039.0089713 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425) 9 8 4 59 40
145746 11787 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1199X Junipero Serra Blvd 6 Sidewalk: Curb side : Cutout Tree PUC 8     12 3x4   5991174.5545657 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828) 9 8 6 64 24
148376 11822 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 1299X Junipero Serra Blvd 16 Sidewalk: Curb side : Yard Tree PUC 8     10 3   5991432.1718154 2088660.0347764 37.7145703669544 -122.471525618465 (37.7145703669544, -122.471525618465) 9 8 6 64 24
150522 24395 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 699X Junipero Serra Blvd 21 Sidewalk: Curb side : Cutout Tree PUC 8   06/22/1995 12:00:00 AM 6 3   5991405.9818619 2093130.1790735 37.7268427672434 -122.471941747662 (37.7268427672434, -122.471941747662) 9 8 4 59 40
152891 11815 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1201X Junipero Serra Blvd 1 Sidewalk: Curb side : Cutout Tree PUC 8     6 3X3   5991184.5559808 2089595.7938425 37.7171254042551 -122.472449649239 (37.7171254042551, -122.472449649239) 9 8 6 64 24
152984 11820 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1299X Junipero Serra Blvd 7 Sidewalk: Curb side : Cutout Tree PUC 8     12 3   5991432.1718154 2088660.0347764 37.7145703669544 -122.471525618465 (37.7145703669544, -122.471525618465) 9 8 6 64 24
153368 11649 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 699X Junipero Serra Blvd 4 Sidewalk: Curb side : Cutout Tree PUC 8     12 3   5991405.9818619 2093130.1790735 37.7268427672434 -122.471941747662 (37.7268427672434, -122.471941747662) 9 8 4 59 40
157419 85427 Permitted Site 7 Ulmus pumila :: Siberian Elm 99 799X Junipero Serra Blvd 18 Sidewalk: Curb side : Cutout Tree PUC 8     18 3x3   5991351.334229 2092039.32129 37.7238443805247 -122.472051185335 (37.7238443805247, -122.472051185335) 9 8 4 59 40
159354 87632 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 900X Junipero Serra Blvd 8 Sidewalk: Curb side : Cutout Tree PUC 8   01/18/2008 12:00:00 AM 3 3x3   5991221.225523 2091214.465808 37.7215720016004 -122.472440839907 (37.7215720016004, -122.472440839907) 9 8 4 64 40
164371 11691 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 799X Junipero Serra Blvd 7 Sidewalk: Curb side : Cutout Tree PUC 8   03/17/2001 12:00:00 AM 9 3x3   5991356.324435 2092039.0089713 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425) 9 8 4 59 40
166318 11721 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 899X Junipero Serra Blvd 12 Sidewalk: Curb side : Cutout Tree PUC 8     12 3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960662 (37.7216528879997, -122.47220960662) 9 8 4 64 40
166529 11718 Permitted Site 7 Ulmus pumila :: Siberian Elm 99 899X Junipero Serra Blvd 7 Sidewalk: Curb side : Cutout Tree PUC 8     36 3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960662 (37.7216528879997, -122.47220960662) 9 8 4 64 40
167696 11773 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1199X Junipero Serra Blvd 18 Sidewalk: Curb side : Cutout Tree PUC 8     18 3x4   5991174.5545657 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828) 9 8 6 64 24
170020 24405 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 999X Junipero Serra Blvd 10 Sidewalk: Curb side : Cutout Tree PUC 8   01/28/2000 12:00:00 AM 12 3X3   5991260.9047733 2090529.2081036 37.7196927494004 -122.472253753748 (37.7196927494004, -122.472253753748) 9 8 6 64 24
170407 87709 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 999X Junipero Serra Blvd 8 Sidewalk: Curb side : Cutout Tree PUC 8   01/18/2008 12:00:00 AM 3 3x3   5991255.914982 2090529.52698 37.719693336177 -122.47227102474 (37.719693336177, -122.47227102474) 9 8 6 64 24
170648 27826 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 799X Junipero Serra Blvd 26 Sidewalk: Curb side : Cutout Tree PUC 8   03/08/2005 12:00:00 AM 3 3   5991356.324435 2092039.0089713 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425) 9 8 4 59 40
174279 11650 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 699X Junipero Serra Blvd 5 Sidewalk: Curb side : Cutout Tree PUC 8     12 3   5991405.9818619 2093130.1790735 37.7268427672434 -122.471941747662 (37.7268427672434, -122.471941747662) 9 8 4 59 40
176383 11790 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1199X Junipero Serra Blvd 12 Sidewalk: Curb side : Cutout Tree PUC 8     24 3x4   5991174.5545657 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828) 9 8 6 64 24
176701 11878 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1501X Junipero Serra Blvd 4 Sidewalk: Curb side : Cutout Tree PUC 8     18 3X3   5991566.1252788 2087212.7603742 37.7106042506249 -122.470957258061 (37.7106042506249, -122.470957258061) 9 8 4 64 24
179933 11874 Permitted Site 7 Ulmus pumila :: Siberian Elm 99 1499X Junipero Serra Blvd 4 Sidewalk: Curb side : Cutout Tree PUC 8     30 3   5991566.5284818 2087248.8358641 37.7107033285334 -122.470958490818 (37.7107033285334, -122.470958490818) 9 8 4 64 24
180766 11725 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 899X Junipero Serra Blvd 20 Sidewalk: Curb side : Cutout Tree PUC 8   01/18/2008 12:00:00 AM 3 3x3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960662 (37.7216528879997, -122.47220960662) 9 8 4 64 40
181483 11653 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 699X Junipero Serra Blvd 10 Sidewalk: Curb side : Cutout Tree PUC 8     18 3   5991405.9818619 2093130.1790735 37.7268427672434 -122.471941747662 (37.7268427672434, -122.471941747662) 9 8 4 59 40
182237 11819 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 1201X Junipero Serra Blvd 5 Sidewalk: Curb side : Cutout Tree PUC 8     6 3X3   5991184.5559808 2089595.7938425 37.7171254042551 -122.472449649239 (37.7171254042551, -122.472449649239) 9 8 6 64 24
183178 11637 Permitted Site 7 Eucalyptus Spp :: Eucalyptus 52 499X Junipero Serra Blvd 5 Sidewalk: Curb side : Cutout Tree PUC 8     18 3   5991474.53212 2093889.5616418 37.7289318087747 -122.471760091134 (37.7289318087747, -122.471760091134) 9 8 4 59 40
183477 11717 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 899X Junipero Serra Blvd 5 Sidewalk: Curb side : Cutout Tree PUC 8   03/08/2005 12:00:00 AM 3 3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960662 (37.7216528879997, -122.47220960662) 9 8 4 64 40
184861 11724 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 899X Junipero Serra Blvd 18 Sidewalk: Curb side : Cutout Tree PUC 8   03/17/2001 12:00:00 AM 12 3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960662 (37.7216528879997, -122.47220960662) 9 8 4 64 40
185799 11726 Permitted Site 7 Ulmus americana :: American Elm 74 899X Junipero Serra Blvd 21 Sidewalk: Curb side : Cutout Tree PUC 8   06/15/1995 12:00:00 AM 18 3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960662 (37.7216528879997, -122.47220960662) 9 8 4 64 40
186993 11824 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1299X Junipero Serra Blvd 14 Sidewalk: Curb side : Yard Tree PUC 8   03/13/2013 12:00:00 AM 2 3   5991432.1718154 2088660.0347764 37.7145703669544 -122.471525618465 (37.7145703669544, -122.471525618465) 9 8 6 64 24
193865 26172 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 799X Junipero Serra Blvd 17 Sidewalk: Curb side : Cutout Tree PUC 8     12 3x3   5991356.324435 2092039.0089713 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425) 9 8 4 59 40
193977 24413 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1199X Junipero Serra Blvd 13 Sidewalk: Curb side : Cutout Tree PUC 8   06/22/1995 12:00:00 AM 6 3x3   5991174.5545657 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828) 9 8 6 64 24

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);