65 rows where DBH = 5 and qCaretaker_id = 4 sorted by qCareAssistant

View and edit SQL

DBH

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)
23043 95519 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 600X 32nd Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4     5 3x3   5985993.74648 2111883.31804 37.7780191077803 -122.49203157445 (37.7780191077803, -122.49203157445) 11 6 2 55 26
166185 95516 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 600X 32nd Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4     5 3x3   5985994.45155 2111944.68724 37.7781876512929 -122.492033654948 (37.7781876512929, -122.492033654948) 11 6 2 55 26
185821 95518 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 600X 32nd Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4     5 3x3   5985992.05689 2111902.81718 37.7780725480885 -122.492038855286 (37.7780725480885, -122.492038855286) 11 6 2 55 26
185924 95496 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 600X 32nd Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4     5 3x3   5986002.12653 2111683.71465 37.7774715436696 -122.491987885766 (37.7774715436696, -122.491987885766) 11 6 2 55 26
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
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
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
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
6227 77210 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 499X Hearst Ave 17 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/15/1999 12:00:00 AM 5 3x3   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
8399 95483 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 601X 30th Ave 17 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3   5986569.82886 2111856.71768 37.7779797279503 -122.490036770148 (37.7779797279503, -122.490036770148) 11 6 2 55 26
8555 77658 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 299X Cambridge St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3   6006705.39704 2093310.53877 37.7282114196192 -122.419064719886 (37.7282114196192, -122.419064719886) 9 3 7 309 5
9740 75309 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 125 Excelsior Ave 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3   6002784.56496 2092514.51527 37.7258041440316 -122.432562342276 (37.7258041440316, -122.432562342276) 9 7 6 28861 5
17218 77646 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1300X Silliman St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3   6006863.07514 2093156.65739 37.7277977728371 -122.418508712231 (37.7277977728371, -122.418508712231) 9 3 7 309 5
23669 42343 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 380X Flood Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
37719 81999 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1150 Francisco St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/04/2008 12:00:00 AM 5 3x3 Permit Number 50638 6005960.45556 2120727.09731 37.8034488081703 -122.423588442877 (37.8034488081703, -122.423588442877) 5 9 1 28858 32
39001 99032 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
46093 95466 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 529X 30th Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3   5986555.1 2112324.8 37.7792640886788 -122.490122160768 (37.7792640886788, -122.490122160768) 11 6 2 55 26
62685 98637 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 3500X Fillmore St 16 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3   6002243.51572 2120296.51697 37.8020560434066 -122.436420210829 (37.8020560434066, -122.436420210829) 13 9 1 57 17
63052 98617 DPW Maintained 1 Vitex lucens :: Puriri tree 492 2501X Franklin St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3   6005326.63971 2118722.15466 37.7979079528477 -122.425639007743 (37.7979079528477, -122.425639007743) 13 9 1 57 17
63621 46967 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3899X Kirkham St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 5 3x20 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
63809 99258 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 151X Palm Ave 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3   5995889.58772 2113188.82138 37.7821771504315 -122.45789304424 (37.7821771504315, -122.45789304424) 11 6 1 54 31
66536 98615 DPW Maintained 1 Vitex lucens :: Puriri tree 492 2501X Franklin St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3   6005320.03726 2118764.37328 37.7980235013495 -122.42566486054 (37.7980235013495, -122.42566486054) 13 9 1 57 17
68245 34754 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 825 Shotwell St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 04/07/2010 12:00:00 AM 5 3x3 Permit Number 53353 6007982.56974873 2103121.8781615 37.7552230267666 -122.415343751113 (37.7552230267666, -122.415343751113) 2 4 7 28859 19
72021 42345 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 380X Flood Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
72982 42350 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 380X Flood Ave 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
81932 42360 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 380X Flood Ave 19 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
82359 42366 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 250 Foerster St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
82711 42354 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 380X Flood Ave 13 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
83270 98613 DPW Maintained 1 Vitex lucens :: Puriri tree 492 2501X Franklin St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3   6005313.74464 2118810.30564 37.7981492643346 -122.425689905776 (37.7981492643346, -122.425689905776) 13 9 1 57 17
87796 76222 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3899X Kirkham St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/14/1994 12:00:00 AM 5 3x20   5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
90658 98640 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 3500X Fillmore St 19 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3   6002237.13778 2120351.54005 37.8022067598879 -122.43644622191 (37.8022067598879, -122.43644622191) 13 9 1 57 17
105467 98620 DPW Maintained 1 Vitex lucens :: Puriri tree 492 2501X Franklin St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3   6005340.01128 2118634.45898 37.79766791839 -122.42558649364 (37.79766791839, -122.42558649364) 13 9 1 57 17
106047 40253 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3351X 23rd St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/13/1999 12:00:00 AM 5 3x3 Permit Number 41415 6006702.84210434 2102592.14346256 37.7536964884672 -122.419731851285 (37.7536964884672, -122.419731851285) 2 4 7 28859 19
108541 42349 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 380X Flood Ave 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
110109 116049 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 650x Kansas St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 4x4   6011498.3385 2105356.0244 37.7615544688802 -122.403342277248 (37.7615544688802, -122.403342277248) 10 3 8 28856 29
110693 98618 DPW Maintained 1 Vitex lucens :: Puriri tree 492 2501X Franklin St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3   6005334.04674 2118673.64199 37.797775167941 -122.425609922762 (37.797775167941, -122.425609922762) 13 9 1 57 17
111842 98941 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1400X San Bruno Ave 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3   6011147.5 2101806.3 37.7517881116631 -122.404305836485 (37.7517881116631, -122.404305836485) 10 4 8 28859 19
114136 98612 DPW Maintained 1 Vitex lucens :: Puriri tree 492 2501X Franklin St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3   6005312.4459 2118826.60748 37.7981939516456 -122.425695560696 (37.7981939516456, -122.425695560696) 13 9 1 57 17
115123 77207 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 499X Hearst Ave 14 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/15/1999 12:00:00 AM 5 3x3   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
118983 77668 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 299X Cambridge St 19 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/26/1984 12:00:00 AM 5 3x3   6006665.25419982 2093600.88939651 37.7290063985797 -122.419224083243 (37.7290063985797, -122.419224083243) 9 3 7 309 5
125279 98621 DPW Maintained 1 Vitex lucens :: Puriri tree 492 2501X Franklin St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3   6005341.92436 2118613.95929 37.797611739554 -122.425578414124 (37.797611739554, -122.425578414124) 13 9 1 57 17
128028 98619 DPW Maintained 1 Vitex lucens :: Puriri tree 492 2501X Franklin St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3   6005336.89801 2118653.35554 37.7977196276222 -122.425598612003 (37.7977196276222, -122.425598612003) 13 9 1 57 17
130186 42352 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 380X Flood Ave 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
131032 97060 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1599X Newcomb Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3   6015231.1 2095663.5 37.7351486000155 -122.389755060411 (37.7351486000155, -122.389755060411) 10 3 8 58 1
143067 122749 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 693 Vermont St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5     6011285.50671 2105214.92948 37.7611551645106 -122.404068449214 (37.7611551645106, -122.404068449214) 10 3 8 28856 29
144395 42361 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 250 Foerster St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
147715 81997 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1150 Francisco St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/04/2008 12:00:00 AM 5 3x3 Permit Number 50638 6005918.11487 2120722.35908 37.8034334081868 -122.42373462766 (37.8034334081868, -122.42373462766) 5 9 1 28858 32
147728 42365 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 250 Foerster St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
154352 42367 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 250 Foerster St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
156701 97732 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1150 Francisco St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3 Permit Number 50638 6005757.30775 2120698.05289 37.8033575908394 -122.424289378073 (37.8033575908394, -122.424289378073) 5 9 1 28858 32
161881 42369 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 250 Foerster St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
162635 46949 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1530 43rd Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 5 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
162866 42347 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 380X Flood Ave 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
173471 99329 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 450 30th Ave 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3   5986584.84396 2112715.96758 37.7803398602424 -122.490048044897 (37.7803398602424, -122.490048044897) 11 6 2 55 26
175602 97728 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1150 Francisco St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3 Permit Number 50638 6005878.13407 2120716.4935 37.8034150458325 -122.423872565669 (37.8034150458325, -122.423872565669) 5 9 1 28858 32
177702 76170 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2999X Polk St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/16/1996 12:00:00 AM 5 3x3   6005804.42794414 2120704.37010887 37.8033775968655 -122.42412676624 (37.8033775968655, -122.42412676624) 5 9 1 28858 32
179937 98614 DPW Maintained 1 Vitex lucens :: Puriri tree 492 2501X Franklin St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3   6005316.85787 2118791.40908 37.7980975551137 -122.425677787418 (37.7980975551137, -122.425677787418) 13 9 1 57 17
180518 42642 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1600X GREEN ST 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/26/2000 12:00:00 AM 5 3x3   6005364 2118556 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433) 13 9 1 57 17
180710 42358 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 380X Flood Ave 17 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 4x4 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
182513 42356 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 380X Flood Ave 15 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
183108 99680 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 165 Grattan St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3   5997880.8 2106478.8 37.7638673579207 -122.450520485859 (37.7638673579207, -122.450520485859) 15 5 11 29492 9
184931 97734 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1150 Francisco St 13 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3 Permit Number 50638 6005715.83773 2120693.51258 37.8033427825912 -122.424432563629 (37.8033427825912, -122.424432563629) 5 9 1 28858 32
185294 98616 DPW Maintained 1 Vitex lucens :: Puriri tree 492 2501X Franklin St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3   6005322.90286 2118744.78417 37.7979698765663 -122.425653549774 (37.7979698765663, -122.425653549774) 13 9 1 57 17
186220 77209 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 499X Hearst Ave 16 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/15/1999 12:00:00 AM 5 3x3   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
189611 76325 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3899X Kirkham St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/14/1994 12:00:00 AM 5 3x20   5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35

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