68 rows where qCaretaker_id = 16 sorted by TreeID descending

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)
165985 6831 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 1450X Fairfax Ave 14 Sidewalk: Curb side : Cutout Tree Fire Dept 16   03/30/2006 12:00:00 AM 3 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.386179680893 (37.740834465841, -122.386179680893) 10 3 8 58 1
42767 6830 Permitted Site 7 Hymenosporum flavum :: Sweet Shade 125 1450X Fairfax Ave 12 Sidewalk: Curb side : Cutout Tree Fire Dept 16   12/19/2000 12:00:00 AM 6 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.386179680893 (37.740834465841, -122.386179680893) 10 3 8 58 1
158152 6829 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1450X Fairfax Ave 11 Sidewalk: Curb side : Cutout Tree Fire Dept 16     12 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.386179680893 (37.740834465841, -122.386179680893) 10 3 8 58 1
37080 6828 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1450X Fairfax Ave 10 Sidewalk: Curb side : Cutout Tree Fire Dept 16     12 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.386179680893 (37.740834465841, -122.386179680893) 10 3 8 58 1
23319 6827 Permitted Site 7 Hymenosporum flavum :: Sweet Shade 125 1450X Fairfax Ave 9 Sidewalk: Curb side : Cutout Tree Fire Dept 16   12/19/2000 12:00:00 AM 6 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.386179680893 (37.740834465841, -122.386179680893) 10 3 8 58 1
19639 6826 Permitted Site 7 Hymenosporum flavum :: Sweet Shade 125 1450X Fairfax Ave 8 Sidewalk: Curb side : Cutout Tree Fire Dept 16   12/19/2000 12:00:00 AM 6 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.386179680893 (37.740834465841, -122.386179680893) 10 3 8 58 1
27391 6825 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1450X Fairfax Ave 6 Sidewalk: Curb side : Cutout Tree Fire Dept 16     12 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.386179680893 (37.740834465841, -122.386179680893) 10 3 8 58 1
155772 6824 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1450X Fairfax Ave 4 Sidewalk: Curb side : Cutout Tree Fire Dept 16     18 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.386179680893 (37.740834465841, -122.386179680893) 10 3 8 58 1
115039 6823 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 1450X Fairfax Ave 5 Sidewalk: Curb side : Cutout Tree Fire Dept 16   03/30/2006 12:00:00 AM 3 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.386179680893 (37.740834465841, -122.386179680893) 10 3 8 58 1
131896 6822 Permitted Site 7 Hymenosporum flavum :: Sweet Shade 125 1450X Fairfax Ave 3 Sidewalk: Curb side : Cutout Tree Fire Dept 16   03/30/2006 12:00:00 AM 3 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.386179680893 (37.740834465841, -122.386179680893) 10 3 8 58 1
21328 6821 Permitted Site 7 Hymenosporum flavum :: Sweet Shade 125 1450X Fairfax Ave 2 Sidewalk: Curb side : Cutout Tree Fire Dept 16   12/19/2000 12:00:00 AM 3 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.386179680893 (37.740834465841, -122.386179680893) 10 3 8 58 1
20856 6820 Permitted Site 7 Hymenosporum flavum :: Sweet Shade 125 1450X Fairfax Ave 1 Sidewalk: Curb side : Cutout Tree Fire Dept 16   12/19/2000 12:00:00 AM 3 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.386179680893 (37.740834465841, -122.386179680893) 10 3 8 58 1
61635 6819 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1400X Fairfax Ave 11 Sidewalk: Curb side : Cutout Tree Fire Dept 16     12 3X3   6016343.96785 2097693.33127 37.7407837556653 -122.386048891651 (37.7407837556653, -122.386048891651) 10 3 8 58 1
188909 6818 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1400X Fairfax Ave 10 Sidewalk: Curb side : Cutout Tree Fire Dept 16     12 3X3   6016560.8212721 2097522.8211505 37.7403275687029 -122.385287208511 (37.7403275687029, -122.385287208511) 10 3 8 58 1
115268 6817 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1400X Fairfax Ave 9 Sidewalk: Curb side : Cutout Tree Fire Dept 16     12 3X3   6016560.8212721 2097522.8211505 37.7403275687029 -122.385287208511 (37.7403275687029, -122.385287208511) 10 3 8 58 1
46216 6816 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1400X Fairfax Ave 8 Sidewalk: Curb side : Cutout Tree Fire Dept 16     12 3X3   6016560.8212721 2097522.8211505 37.7403275687029 -122.385287208511 (37.7403275687029, -122.385287208511) 10 3 8 58 1
190734 6815 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1400X Fairfax Ave 7 Sidewalk: Curb side : Cutout Tree Fire Dept 16     12 3X3   6016560.8212721 2097522.8211505 37.7403275687029 -122.385287208511 (37.7403275687029, -122.385287208511) 10 3 8 58 1
117768 6814 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1400X Fairfax Ave 6 Sidewalk: Curb side : Cutout Tree Fire Dept 16     12 3X3   6016451.12132 2097615.70854 37.7405765491786 -122.385672983138 (37.7405765491786, -122.385672983138) 10 3 8 58 1
56556 6813 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1400X Fairfax Ave 5 Sidewalk: Curb side : Cutout Tree Fire Dept 16   12/15/1998 12:00:00 AM 6 3X3   6016463.58165 2097607.01609 37.7405533709401 -122.385629294058 (37.7405533709401, -122.385629294058) 10 3 8 58 1
10875 6812 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1400X Fairfax Ave 4 Sidewalk: Curb side : Cutout Tree Fire Dept 16   08/13/2020 01:09:00 PM 3 3X3   6016477.27072 2097595.73141 37.7405231429351 -122.385581175844 (37.7405231429351, -122.385581175844) 10 3 8 58 1
171047 6811 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1400X Fairfax Ave 3 Sidewalk: Curb side : Cutout Tree Fire Dept 16   03/30/2006 12:00:00 AM 3 3X3   6016498.59648 2097579.96622 37.7404810348687 -122.385506340556 (37.7404810348687, -122.385506340556) 10 3 8 58 1
25967 6810 DPW Maintained 1 :: 45 1400X Fairfax Ave 2 Sidewalk: Curb side : Cutout Tree Fire Dept 16   03/30/2006 12:00:00 AM 3 3X3   6016518.03729 2097563.61739 37.74043721991 -122.38543798217 (37.74043721991, -122.38543798217) 10 3 8 58 1
110361 6809 DPW Maintained 1 :: 45 1400X Fairfax Ave 1 Sidewalk: Curb side : Cutout Tree Fire Dept 16   12/19/2000 12:00:00 AM 6 3X3   6016539.97847 2097547.42551 37.7403939741954 -122.385360989424 (37.7403939741954, -122.385360989424) 10 3 8 58 1
63178 67338 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 2501 25th St 1 Sidewalk: Curb side : Cutout Tree Fire Dept 16 DPW for City Agency 07/22/1992 12:00:00 AM   3x3 Permit Number 30822 6011435.88896489 2101815.42613948 37.7518292809831 -122.403309184671 (37.7518292809831, -122.403309184671) 10 4 8 28859 19
41490 6632 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1415 Evans Ave 15 Sidewalk: Curb side : Cutout Tree Fire Dept 16     18 3x3   6016617.7688071 2097746.8662364 37.740945901362 -122.385105911093 (37.740945901362, -122.385105911093) 10 3 8 58 1
31471 6631 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1415 Evans Ave 14 Sidewalk: Curb side : Cutout Tree Fire Dept 16   02/15/2001 12:00:00 AM 18 3x3   6016617.7688071 2097746.8662364 37.740945901362 -122.385105911093 (37.740945901362, -122.385105911093) 10 3 8 58 1
3819 6627 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1415 Evans Ave 10 Sidewalk: Curb side : Cutout Tree Fire Dept 16   11/24/1998 12:00:00 AM 6 3x3   6016607.54293 2097762.50213 37.7409882686849 -122.385142357926 (37.7409882686849, -122.385142357926) 10 3 8 58 1
176485 6626 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1415 Evans Ave 9 Sidewalk: Curb side : Cutout Tree Fire Dept 16   11/24/1998 12:00:00 AM 6 3x3   6016580.82562 2097781.51455 37.7410389949512 -122.38523606192 (37.7410389949512, -122.38523606192) 10 3 8 58 1
146898 6625 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1415 Evans Ave 8 Sidewalk: Curb side : Cutout Tree Fire Dept 16   11/24/1998 12:00:00 AM 6 3x3   6016564.1874 2097795.2525 37.7410757961225 -122.385294548421 (37.7410757961225, -122.385294548421) 10 3 8 58 1
48351 6624 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1415 Evans Ave 7 Sidewalk: Curb side : Cutout Tree Fire Dept 16   02/04/2004 12:00:00 AM 3 3x3   6016547.14534 2097807.00624 37.7411071266849 -122.385354293091 (37.7411071266849, -122.385354293091) 10 3 8 58 1
168314 6623 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1415 Evans Ave 6 Sidewalk: Curb side : Cutout Tree Fire Dept 16     18 3x3   6016531.01979 2097819.10411 37.7411394528345 -122.385410892796 (37.7411394528345, -122.385410892796) 10 3 8 58 1
56232 6621 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1415 Evans Ave 4 Sidewalk: Curb side : Cutout Tree Fire Dept 16     18 3x3   6016617.7688071 2097746.8662364 37.740945901362 -122.385105911093 (37.740945901362, -122.385105911093) 10 3 8 58 1
86267 29509 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1850X Ingalls St 3 Sidewalk: Curb side : Cutout Tree Fire Dept 16   02/28/2006 12:00:00 AM 12 3x3   6016520.1701445 2092944.0657869 37.7277529727716 -122.385108820711 (37.7277529727716, -122.385108820711) 10 3 8 58 1
42315 29508 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1850X Ingalls St 2 Sidewalk: Curb side : Cutout Tree Fire Dept 16   02/28/2006 12:00:00 AM 3 3x3   6016520.1701445 2092944.0657869 37.7277529727716 -122.385108820711 (37.7277529727716, -122.385108820711) 10 3 8 58 1
150090 29507 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1850X Ingalls St 1 Sidewalk: Curb side : Cutout Tree Fire Dept 16   02/28/2006 12:00:00 AM 16 3x3   6016520.1701445 2092944.0657869 37.7277529727716 -122.385108820711 (37.7277529727716, -122.385108820711) 10 3 8 58 1
28370 29458 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1809X Ingalls St 4 Sidewalk: Curb side : Cutout Tree Fire Dept 16   02/28/2006 12:00:00 AM 12 3X3   6016520.1701445 2092944.0657869 37.7277529727716 -122.385108820711 (37.7277529727716, -122.385108820711) 10 3 8 58 1
64162 29457 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1809X Ingalls St 3 Sidewalk: Curb side : Cutout Tree Fire Dept 16   02/28/2006 12:00:00 AM 12 3x3   6016492.91829 2092912.51025 37.7276648199576 -122.38520083393 (37.7276648199576, -122.38520083393) 10 3 8 58 1
120363 29456 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1809X Ingalls St 2 Sidewalk: Curb side : Cutout Tree Fire Dept 16   02/27/2008 12:00:00 AM 3 3X3   6016520.1701445 2092944.0657869 37.7277529727716 -122.385108820711 (37.7277529727716, -122.385108820711) 10 3 8 58 1
67214 29455 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1809X Ingalls St 1 Sidewalk: Curb side : Cutout Tree Fire Dept 16   02/28/2006 12:00:00 AM 12 3X3   6016520.1701445 2092944.0657869 37.7277529727716 -122.385108820711 (37.7277529727716, -122.385108820711) 10 3 8 58 1
124059 29454 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1829X Ingalls St 4 Sidewalk: Curb side : Cutout Tree Fire Dept 16   02/28/2006 12:00:00 AM 8 3X3   6016488.0524002 2092900.9411781 37.7276327843847 -122.385216849755 (37.7276327843847, -122.385216849755) 10 3 8 58 1
94432 29453 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1829X Ingalls St 3 Sidewalk: Curb side : Cutout Tree Fire Dept 16   02/28/2006 12:00:00 AM 12 3X3   6016488.0524002 2092900.9411781 37.7276327843847 -122.385216849755 (37.7276327843847, -122.385216849755) 10 3 8 58 1
170395 29452 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1829X Ingalls St 2 Sidewalk: Curb side : Cutout Tree Fire Dept 16   02/28/2006 12:00:00 AM 12 3X3   6016488.0524002 2092900.9411781 37.7276327843847 -122.385216849755 (37.7276327843847, -122.385216849755) 10 3 8 58 1
64865 29451 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1829X Ingalls St 1 Sidewalk: Curb side : Cutout Tree Fire Dept 16   02/28/2006 12:00:00 AM 12 3X3   6016488.0524002 2092900.9411781 37.7276327843847 -122.385216849755 (37.7276327843847, -122.385216849755) 10 3 8 58 1
129171 27857 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1450X Fairfax Ave 7 Sidewalk: Curb side : Cutout Tree Fire Dept 16     12 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.386179680893 (37.740834465841, -122.386179680893) 10 3 8 58 1
161640 27299 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 7800X Geary Blvd 6 Median : Cutout Tree Fire Dept 16   06/10/1999 12:00:00 AM 6 5X5   5982630.17797 2112395.09735 37.7792271172593 -122.503705073784 (37.7792271172593, -122.503705073784) 11 6 2 55 26
151464 27298 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 7800X Geary Blvd 5 Median : Cutout Tree Fire Dept 16   06/10/1999 12:00:00 AM 6 5X5   5982658.07107 2112395.9042 37.7792309725957 -122.503608641413 (37.7792309725957, -122.503608641413) 11 6 2 55 26
136516 27297 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 7800X Geary Blvd 4 Median : Cutout Tree Fire Dept 16   06/10/1999 12:00:00 AM 6 5X5   5982680.86392 2112396.64212 37.7792343387449 -122.503529847504 (37.7792343387449, -122.503529847504) 11 6 2 55 26
150758 27296 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 7800X Geary Blvd 3 Median : Cutout Tree Fire Dept 16   06/10/1999 12:00:00 AM 6 5X5   5982703.46074 2112397.79309 37.7792388274313 -122.50345176232 (37.7792388274313, -122.50345176232) 11 6 2 55 26
82660 27295 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 7800X Geary Blvd 2 Median : Cutout Tree Fire Dept 16   06/10/1999 12:00:00 AM 6 5X5   5982729.47953 2112398.50568 37.7792423135673 -122.503361806845 (37.7792423135673, -122.503361806845) 11 6 2 55 26
175352 27294 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 7800X Geary Blvd 1 Median : Cutout Tree Fire Dept 16   02/12/2001 12:00:00 AM 6 5X5   5982752.16339 2112399.44122 37.7792462157513 -122.503283404585 (37.7792462157513, -122.503283404585) 11 6 2 55 26
154274 199930 DPW Maintained 1 Tristania conferta :: 61 1801 Ingalls St 4 Sidewalk: Curb side : Cutout Tree Fire Dept 16   02/28/2006 12:00:00 AM 6 Width 0ft   6016497.9258 2092921.8231 37.7276906682215 -122.385184171361 (37.7276906682215, -122.385184171361) 10 3 8 58 1
191358 199929 DPW Maintained 1 Tristania conferta :: 61 1801 Ingalls St 3 Sidewalk: Curb side : Cutout Tree Fire Dept 16   02/28/2006 12:00:00 AM 6 Width 0ft   6016487.4596 2092903.0942 37.727638663365 -122.385219049049 (37.727638663365, -122.385219049049) 10 3 8 58 1
45411 199928 DPW Maintained 1 Tristania conferta :: 61 1801 Ingalls St 2 Sidewalk: Curb side : Cutout Tree Fire Dept 16   02/27/2008 12:00:00 AM 4 Width 0ft   6016476.4427 2092884.9162 37.7275881406952 -122.385255868852 (37.7275881406952, -122.385255868852) 10 3 8 58 1
92591 199927 DPW Maintained 1 Tristania conferta :: 61 1801 Ingalls St 1 Sidewalk: Curb side : Cutout Tree Fire Dept 16   02/28/2006 12:00:00 AM 5 Width 0ft   6016464.324 2092869.4925 37.7275451198245 -122.385296689415 (37.7275451198245, -122.385296689415) 10 3 8 58 1
84909 14975 DPW Maintained 1 Ceratonia siliqua :: Carob 5 400X Mendell St 8 Sidewalk: Curb side : Cutout Tree Fire Dept 16     12 3x3   6016578.93942 2097580.627 37.7404872941606 -122.38522858943 (37.7404872941606, -122.38522858943) 10 3 8 58 1
139349 14974 DPW Maintained 1 Ceratonia siliqua :: Carob 5 400X Mendell St 7 Sidewalk: Curb side : Cutout Tree Fire Dept 16     12 3X3   6016589.22096 2097595.13367 37.7405276953073 -122.385194050084 (37.7405276953073, -122.385194050084) 10 3 8 58 1
164473 14973 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 400X Mendell St 6 Sidewalk: Curb side : Cutout Tree Fire Dept 16     12 3X3   6016605.91834 2097618.21478 37.740591995028 -122.385137924278 (37.740591995028, -122.385137924278) 10 3 8 58 1
160744 14972 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 400X Mendell St 5 Sidewalk: Curb side : Cutout Tree Fire Dept 16     12 3X3   6016621.68773 2097636.5481 37.7406432069202 -122.385084676324 (37.7406432069202, -122.385084676324) 10 3 8 58 1
161719 14971 DPW Maintained 1 Quercus suber :: Cork Oak 78 400X Mendell St 4 Sidewalk: Curb side : Cutout Tree Fire Dept 16   02/25/2008 12:00:00 AM 3 3X3   6016631.74011 2097650.02311 37.7406807626184 -122.385050857322 (37.7406807626184, -122.385050857322) 10 3 8 58 1
103939 14970 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 400X Mendell St 3 Sidewalk: Curb side : Cutout Tree Fire Dept 16     18 3x3   6016646.28629 2097669.62437 37.7407353883164 -122.385001926999 (37.7407353883164, -122.385001926999) 10 3 8 58 1
119100 14969 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 400X Mendell St 2 Sidewalk: Curb side : Cutout Tree Fire Dept 16     12 3x3   6016654.44168 2097681.89431 37.7407695301847 -122.384974583115 (37.7407695301847, -122.384974583115) 10 3 8 58 1
72256 14968 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 400X Mendell St 1 Sidewalk: Curb side : Cutout Tree Fire Dept 16     12 3X3   6016667.04052 2097697.80462 37.7408139135396 -122.384932128834 (37.7408139135396, -122.384932128834) 10 3 8 58 1
35237 116382 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 2501 25th St 3 Sidewalk: Curb side : Cutout Tree Fire Dept 16 DPW for City Agency     3x3   6011435.88896489 2101815.42613948 37.7518292809831 -122.403309184671 (37.7518292809831, -122.403309184671) 10 4 8 28859 19
42129 111073 Undocumented 4 Juniperus chinensis :: Juniper 113 1450 IRVING ST 2 Sidewalk: Property side : Cutout Tree Fire Dept 16       3x3   5991201 2106639 37.7639226370674 -122.473635352969 (37.7639226370674, -122.473635352969) 11 8 11 56 12
193863 111072 Undocumented 4 Juniperus chinensis :: Juniper 113 1450 IRVING ST 1 Sidewalk: Property side : Cutout Tree Fire Dept 16       3x3   5991277 2106586 37.7637815143869 -122.473368628437 (37.7637815143869, -122.473368628437) 11 8 11 56 12
177003 108358 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 250X Pixley St 3 Sidewalk: Curb side : Cutout Tree Fire Dept 16   11/02/2018 12:00:00 AM 3 2x4 Permit Number 773698 6002123.02459 2118966.98612 37.7983986535418 -122.436741939704 (37.7983986535418, -122.436741939704) 13 9 1 57 17
108505 108357 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 250X Pixley St 2 Sidewalk: Curb side : Cutout Tree Fire Dept 16   11/02/2018 12:00:00 AM 3 2x4 Permit Number 773698 6002140.21513 2118970.44706 37.7984091333207 -122.436682703142 (37.7984091333207, -122.436682703142) 13 9 1 57 17
145251 108356 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 250X Pixley St 1 Sidewalk: Curb side : Cutout Tree Fire Dept 16   11/02/2018 12:00:00 AM 3 2x4 Permit Number 773698 6002158.91155 2118972.60439 37.7984161192732 -122.436618162405 (37.7984161192732, -122.436618162405) 13 9 1 57 17

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