71 rows where qCareAssistant = "DPW" and qCaretaker_id = 4 sorted by qCareAssistant

View and edit SQL

qCareAssistant

  • DPW · 71
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)
2158 95238 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1220 Noe St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW     3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514) 2 4 5 28862 22
3324 100985 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2190 Powell St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW 03/23/2016 02:34:00 PM 3 3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257169 (37.8045319114054, -122.41088257169) 3 1 10 308 23
11226 33101 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 450X Chestnut St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW 11/05/1996 12:00:00 AM 14   Permit Number 37341 6009682.3141 2120901.0273 37.804135754367 -122.410721035819 (37.804135754367, -122.410721035819) 3 1 10 308 23
14472 100972 DPW Maintained 1 Potential Site :: Potential Site 48 450X Chestnut St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW 03/24/2016 07:43:00 AM 3   Permit Number 37341 6009614 2121059.9 37.8045681487804 -122.410968670823 (37.8045681487804, -122.410968670823) 3 1 10 308 23
17603 75990 DPW Maintained 1 Acer saccharinum :: Silver Maple 271 350 Broadway 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   3 3x3   6011912.57037 2118781.03793 37.7984395708796 -122.402853834756 (37.7984395708796, -122.402853834756) 3 1 10 308 23
18687 104158 DPW Maintained 1 :: 45 525X Church St 6 Sidewalk: Curb side : Cutout Landscaping SFUSD 4 DPW     5x20   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895) 8 4 5 28862 3
27818 98647 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2110 Greenwich St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   12 5x5   6002751.94545 2119240.19821 37.7991845449763 -122.434585229619 (37.7991845449763, -122.434585229619) 13 9 1 57 17
31577 104151 DPW Maintained 1 :: 45 525X Church St 1 Sidewalk: Property side : Cutout Landscaping SFUSD 4 DPW     2x58   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895) 8 4 5 28862 3
36405 98645 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2110 Greenwich St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   9 5x5   6002788.88101 2119245.38589 37.7992008856766 -122.434457791187 (37.7992008856766, -122.434457791187) 13 9 1 57 17
38172 34688 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 3101X Webster St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW 07/28/1997 12:00:00 AM 7 3x3 Permit Number 38352 6002815.38185 2119347.35443 37.7994823689702 -122.434373383533 (37.7994823689702, -122.434373383533) 13 9 1 57 17
39667 95239 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1220 Noe St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   12     6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514) 2 4 5 28862 22
43511 98646 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2110 Greenwich St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   8 5x5   6002771.23879 2119243.65965 37.7991951444108 -122.434518715761 (37.7991951444108, -122.434518715761) 13 9 1 57 17
45053 98657 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2110 Greenwich St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   11 5x5   6002607.56666 2119218.59599 37.7991170337862 -122.435083283187 (37.7991170337862, -122.435083283187) 13 9 1 57 17
48885 98651 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2110 Greenwich St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   23 5x5   6002674.17203 2119228.66956 37.7991484749737 -122.434853527066 (37.7991484749737, -122.434853527066) 13 9 1 57 17
49150 100970 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 450X Chestnut St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   9   Permit Number 37341 6009657.9659 2120896.9693 37.8041232469329 -122.410805008122 (37.8041232469329, -122.410805008122) 3 1 10 308 23
49823 98650 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2110 Greenwich St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   11 5x5   6002693.158 2119231.97091 37.7991586175436 -122.434788065428 (37.7991586175436, -122.434788065428) 13 9 1 57 17
50209 97899 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 375X Precita Ave 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   6 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
51293 100971 DPW Maintained 1 Maytenus boaria :: Mayten 58 450X Chestnut St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   4   Permit Number 37341 6009642.5454 2120895.3461 37.8041179253888 -122.410858257388 (37.8041179253888, -122.410858257388) 3 1 10 308 23
56368 34692 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 3101X Webster St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW 07/28/1997 12:00:00 AM 9 3x3 Permit Number 38352 6002825.2019 2119271.55666 37.7992748054477 -122.434333980647 (37.7992748054477, -122.434333980647) 13 9 1 57 17
58468 100975 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 450X Chestnut St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   11   Permit Number 37341 6009580.8633 2120886.4184 37.8040899533369 -122.411071082632 (37.8040899533369, -122.411071082632) 3 1 10 308 23
58686 98656 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2110 Greenwich St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   8 5x5   6002629.88193 2119221.45898 37.7991261619004 -122.435006269744 (37.7991261619004, -122.435006269744) 13 9 1 57 17
65532 100981 DPW Maintained 1 Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 2190 Powell St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW 05/03/2013 12:00:00 AM   3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257169 (37.8045319114054, -122.41088257169) 3 1 10 308 23
65536 100982 DPW Maintained 1 Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 2190 Powell St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW 05/03/2013 12:00:00 AM   3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257169 (37.8045319114054, -122.41088257169) 3 1 10 308 23
66219 100977 DPW Maintained 1 Maytenus boaria :: Mayten 58 450X Chestnut St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   3   Permit Number 37341 6009542.7178 2120879.1139 37.8040677578058 -122.411202572075 (37.8040677578058, -122.411202572075) 3 1 10 308 23
66578 100978 DPW Maintained 1 Maytenus boaria :: Mayten 58 450X Chestnut St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   5   Permit Number 37341 6009524.0508 2120877.4907 37.8040622540071 -122.411267056058 (37.8040622540071, -122.411267056058) 3 1 10 308 23
72589 47255 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1035 Gilman Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW 05/09/2002 12:00:00 AM 6 3x3 Permit Number 45198 6015368.10493708 2089617.80548286 37.7185559218928 -122.388859444456 (37.7185559218928, -122.388859444456) 10 3 8 58 1
77923 256355 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1000 Bay St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW     3x3   6005985 2121074 37.804402699388 -122.423528183462 (37.804402699388, -122.423528183462) 5 1 1 28858 32
79291 104154 DPW Maintained 1 :: 45 525X Church St 2 Sidewalk: Curb side : Cutout Landscaping SFUSD 4 DPW     5x17   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895) 8 4 5 28862 3
81015 97898 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 375X Precita Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   6 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
84800 97902 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 375X Precita Ave 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   6 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
85492 95237 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1220 Noe St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   9 3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514) 2 4 5 28862 22
87067 98675 Permitted Site 7 Tree(s) :: 17 199X Park St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW         6006189.1 2096374.1 37.7365941955595 -122.421067016387 (37.7365941955595, -122.421067016387) 2 7 7 28859 2
87595 97901 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 375X Precita Ave 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   6 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
90475 234072 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1400 San Bruno Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   4 Width 3ft   6011140.67766 2101759.73109 37.7516598624171 -122.404326151746 (37.7516598624171, -122.404326151746) 10 4 8 28859 19
90901 100974 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 450X Chestnut St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   15   Permit Number 37341 6009596.2838 2120888.8532 37.8040975034287 -122.411017890761 (37.8040975034287, -122.411017890761) 3 1 10 308 23
92277 100973 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 450X Chestnut St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   0   Permit Number 37341 6009614 2121059.9 37.8045681487804 -122.410968670823 (37.8045681487804, -122.410968670823) 3 1 10 308 23
93651 98648 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2110 Greenwich St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   9 5x5   6002730.0885 2119237.75472 37.7991765949935 -122.434660687245 (37.7991765949935, -122.434660687245) 13 9 1 57 17
94668 104156 DPW Maintained 1 :: 45 525X Church St 4 Sidewalk: Curb side : Cutout Landscaping SFUSD 4 DPW     5x20   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895) 8 4 5 28862 3
101825 97903 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 375X Precita Ave 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   3 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
106695 100983 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2190 Powell St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW     3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257169 (37.8045319114054, -122.41088257169) 3 1 10 308 23
108543 67860 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2110 Greenwich St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW 01/20/1993 12:00:00 AM 5 5x5 Permit Number 31536 6002806.21719 2119247.92289 37.7992088356751 -122.434397983605 (37.7992088356751, -122.434397983605) 13 9 1 57 17
109710 97896 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 375X Precita Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   3 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
111419 104155 DPW Maintained 1 :: 45 525X Church St 3 Sidewalk: Curb side : Cutout Landscaping SFUSD 4 DPW     5x17   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895) 8 4 5 28862 3
115599 96503 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2360X Harrison St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW     3x3   6008639.8 2104954 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323) 2 4 7 28859 19
121961 100979 DPW Maintained 1 Maytenus boaria :: Mayten 58 450X Chestnut St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   6   Permit Number 37341 6009507.0071 2120874.2443 37.8040523843138 -122.411325807727 (37.8040523843138, -122.411325807727) 3 1 10 308 23
123087 34690 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 3101X Webster St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW 07/28/1997 12:00:00 AM 8 3x3 Permit Number 38352 6002819.05677 2119313.26082 37.7993889653989 -122.434358228162 (37.7993889653989, -122.434358228162) 13 9 1 57 17
123904 98659 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2110 Greenwich St 13 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   20 7x7   6002683.8 2119245.6 37.7991955081761 -122.434821422435 (37.7991955081761, -122.434821422435) 13 9 1 57 17
126964 97897 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 375X Precita Ave 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   3 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
129312 77648 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1300X Silliman St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW 01/01/2011 12:00:00 AM 3 3x3   6006817.14742 2093142.98247 37.7277576387802 -122.418666516263 (37.7277576387802, -122.418666516263) 9 3 7 309 5
132915 100984 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2190 Powell St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW     3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257169 (37.8045319114054, -122.41088257169) 3 1 10 308 23
133386 98658 DPW Maintained 1 Tree(s) :: 17 2110 Greenwich St 12 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW 06/20/2014 12:00:00 AM   6x6 Permit Number 772915 6002683.8 2119245.6 37.7991955081761 -122.434821422435 (37.7991955081761, -122.434821422435) 13 9 1 57 17
135797 97066 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1599X Newcomb Ave 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   10 3x3   6015231.1 2095663.5 37.7351486000155 -122.389755060411 (37.7351486000155, -122.389755060411) 10 3 8 58 1
137518 98655 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2110 Greenwich St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   6 5x5   6002650.75991 2119226.56813 37.7991413757273 -122.434934390513 (37.7991413757273, -122.434934390513) 13 9 1 57 17
142139 34693 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 3101X Webster St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW 07/28/1997 12:00:00 AM 9 3x3 Permit Number 38352 6002813.73545 2119366.57801 37.799535058456 -122.434380455813 (37.799535058456, -122.434380455813) 13 9 1 57 17
152683 98649 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2110 Greenwich St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   16 5x5   6002707.76445 2119233.0203 37.7991623281478 -122.434737597267 (37.7991623281478, -122.434737597267) 13 9 1 57 17
153628 104153 DPW Maintained 1 :: 45 525X Church St 1 Sidewalk: Curb side : Cutout Landscaping SFUSD 4 DPW     5x17   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895) 8 4 5 28862 3
154088 95241 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1220 Noe St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   3 3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514) 2 4 5 28862 22
155740 95235 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1220 Noe St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   3 3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514) 2 4 5 28862 22
156692 104157 DPW Maintained 1 :: 45 525X Church St 5 Sidewalk: Curb side : Cutout Landscaping SFUSD 4 DPW     5x20   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895) 8 4 5 28862 3
162318 34689 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 3101X Webster St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW 07/28/1997 12:00:00 AM 5 3x3 Permit Number 38352 6002816.77257 2119329.88091 37.7994344701793 -122.434367321195 (37.7994344701793, -122.434367321195) 13 9 1 57 17
164652 104152 DPW Maintained 1 :: 45 525X Church St 2 Sidewalk: Property side : Cutout Landscaping SFUSD 4 DPW     2x68   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895) 8 4 5 28862 3
168139 34691 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 3101X Webster St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW 07/28/1997 12:00:00 AM 10 3x3 Permit Number 38352 6002820.98316 2119293.45008 37.7993346796145 -122.434350145047 (37.7993346796145, -122.434350145047) 13 9 1 57 17
169010 102195 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 3999X Folsom St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   3 3x3   6008408 2096514 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
170711 95240 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1220 Noe St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   12 3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514) 2 4 5 28862 22
175564 95236 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1220 Noe St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   12 3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514) 2 4 5 28862 22
182487 256357 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1000 Bay St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW     3x3   6005985 2121074 37.804402699388 -122.423528183462 (37.804402699388, -122.423528183462) 5 1 1 28858 32
182607 100976 DPW Maintained 1 Maytenus boaria :: Mayten 58 450X Chestnut St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   5   Permit Number 37341 6009558.1383 2120880.7372 37.8040730797801 -122.411149322876 (37.8040730797801, -122.411149322876) 3 1 10 308 23
188027 100980 DPW Maintained 1 Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 2190 Powell St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW 05/03/2013 12:00:00 AM 3 3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257169 (37.8045319114054, -122.41088257169) 3 1 10 308 23
189482 97895 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 375X Precita Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   3 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
191936 100987 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2190 Powell St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW     3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257169 (37.8045319114054, -122.41088257169) 3 1 10 308 23
192030 256356 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1000 Bay St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW     3x3   6005985 2121074 37.804402699388 -122.423528183462 (37.804402699388, -122.423528183462) 5 1 1 28858 32

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