trees

72 rows where qSpecies_id = 231

✎ View and edit SQL

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)
2462 76446 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 300 Spear St 8 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6015352.78819 2115567.57255 37.7898076305561 -122.390724837491 (37.7898076305561, -122.390724837491) 6 2 9 28855 6
5264 200287 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 450 Texas St 5 : Tree Private 2     1 Width 5ft   6013763.35516 2104980.70366 37.7606501645924 -122.395482160282 (37.7606501645924, -122.395482160282) 10 3 8 28856 29
5965 76482 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 300 Spear St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6015342.31181 2115581.65186 37.7898457078606 -122.390762069407 (37.7898457078606, -122.390762069407) 6 2 9 28855 6
6053 76553 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 300 Spear St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6015315.92328 2115607.08392 37.7899140743245 -122.390855150162 (37.7899140743245, -122.390855150162) 6 2 9 28855 6
6274 76497 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 300 Spear St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     6015333.29441 2115573.95501 37.7898240737695 -122.390792730921 (37.7898240737695, -122.390792730921) 6 2 9 28855 6
8090 76562 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 300 Spear St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     6015307.5524 2115600.21413 37.7898947469988 -122.390883632583 (37.7898947469988, -122.390883632583) 6 2 9 28855 6
9257 76516 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 300 Spear St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6015329.60164 2115594.83073 37.7898811888135 -122.390806967184 (37.7898811888135, -122.390806967184) 6 2 9 28855 6
13249 76531 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 300 Spear St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6015319.32504 2115587.47441 37.7898604198619 -122.39084200926 (37.7898604198619, -122.39084200926) 6 2 9 28855 6
13678 76463 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 300 Spear St 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6015345.6372 2115558.26191 37.7897816689298 -122.39074892852 (37.7897816689298, -122.39074892852) 6 2 9 28855 6
15313 76414 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 300 Spear St 10 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     6015366.40931 2115552.48446 37.7897669578311 -122.390676654499 (37.7897669578311, -122.390676654499) 6 2 9 28855 6
28296 38960 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 3190 Clay St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/13/1998 12:00:00 AM 13   Permit Number 40754 5999502.21534 2115719.53563 37.7893327219871 -122.445577062027 (37.7893327219871, -122.445577062027) 13 6 1 29490 27
29535 200286 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 1922 23rd St 2 Front Yard : Yard Tree Private 2     3 Width 4ft   6012576.56796 2102863.47857 37.754770647056 -122.399438105288 (37.754770647056, -122.399438105288) 10 3 8 28856 29
30627 200324 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 300 Spear St 20 Sidewalk: Curb side : Yard Tree Private 2     5     6015668.05261 2115242.24608 37.7889318446789 -122.389611312224 (37.7889318446789, -122.389611312224) 6 2 9 28855 6
31395 200309 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 300 Spear St 7 Sidewalk: Curb side : Yard Tree Private 2     5     6015536.76088 2115360.50758 37.7892492828883 -122.390073832651 (37.7892492828883, -122.390073832651) 6 2 9 28855 6
32902 200300 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 300 Spear St 16 Sidewalk: Curb side : Yard Tree Private 2     4     6015413.39185 2115512.45367 37.7896596489335 -122.390511299761 (37.7896596489335, -122.390511299761) 6 2 9 28855 6
33642 227933 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 221 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6001118.22529 2105018.65205 37.7600429144641 -122.439218572788 (37.7600429144641, -122.439218572788) 2 4 5 28862 3
33688 200321 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 300 Spear St 19 Sidewalk: Curb side : Yard Tree Private 2     5     6015643.39927 2115248.8622 37.7889486440117 -122.389697072471 (37.7889486440117, -122.389697072471) 6 2 9 28855 6
34941 200313 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 300 Spear St 11 Sidewalk: Curb side : Yard Tree Private 2     5     6015568.89503 2115325.68208 37.7891554422096 -122.389960217704 (37.7891554422096, -122.389960217704) 6 2 9 28855 6
36526 200293 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 450 Texas St 12 : Tree Private 2     3 Width 5ft   6013771.6868 2104857.5538 37.7603124853576 -122.395444716997 (37.7603124853576, -122.395444716997) 10 3 8 28856 29
38130 200317 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 300 Spear St 15 Sidewalk: Curb side : Yard Tree Private 2   02/20/2018 12:00:00 AM 3     6015614.34807 2115278.98424 37.7890297412845 -122.389799691409 (37.7890297412845, -122.389799691409) 6 2 9 28855 6
39741 200290 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 450 Texas St 9 : Tree Private 2     3 Width 5ft   6013767.60805 2104913.53703 37.7604659762337 -122.395462745711 (37.7604659762337, -122.395462745711) 10 3 8 28856 29
40823 200288 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 450 Texas St 6 : Tree Private 2     2 Width 5ft   6013765.39611 2104962.6941 37.7606008277911 -122.395473839765 (37.7606008277911, -122.395473839765) 10 3 8 28856 29
42518 208166 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 15 Santa Rita Ave 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   5993909.69845 2100938.88006 37.7484280758139 -122.463853078355 (37.7484280758139, -122.463853078355) 1 8 4 29491 40
42601 200331 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 301 Main St 7 Sidewalk: Curb side : Pot Tree Private 2     4 Width 6ft   6015095.90294 2115388.62146 37.7893020164091 -122.391601126991 (37.7893020164091, -122.391601126991) 6 2 9 28855 6
43531 200295 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 300 Spear St 11 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6015373.89858 2115531.53171 37.7897098418898 -122.390649277348 (37.7897098418898, -122.390649277348) 6 2 9 28855 6
45609 200301 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 300 Spear St 17 Sidewalk: Curb side : Yard Tree Private 2     5     6015414.78725 2115487.52698 37.7895912833718 -122.390504729321 (37.7895912833718, -122.390504729321) 6 2 9 28855 6
47022 200299 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 300 Spear St 15 Sidewalk: Curb side : Yard Tree Private 2     4     6015401.13425 2115501.03994 37.7896276294543 -122.390552912297 (37.7896276294543, -122.390552912297) 6 2 9 28855 6
48464 200304 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 300 Spear St 2 Sidewalk: Curb side : Yard Tree Private 2     5     6015501.05504 2115417.76769 37.7894045256485 -122.390201373616 (37.7894045256485, -122.390201373616) 6 2 9 28855 6
52090 227932 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 3471 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6005233.95804 2103685.11965 37.7566146907287 -122.424889340971 (37.7566146907287, -122.424889340971) 2 4 5 28859 19
57162 200297 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 300 Spear St 13 Sidewalk: Curb side : Yard Tree Private 2     4     6015387.81046 2115515.17676 37.789665706757 -122.39059999989 (37.789665706757, -122.39059999989) 6 2 9 28855 6
60069 250028 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 1398 Gough St 1 : Tree Private 2     3 Width 4ft   6005502.19893 2114387.15461 37.7860150501066 -122.424722973592 (37.7860150501066, -122.424722973592) 13 9 1 28858 41
67894 200323 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 300 Spear St 20 Sidewalk: Curb side : Yard Tree Private 2     5     6015655.42204 2115235.75043 37.7889133087555 -122.389654558808 (37.7889133087555, -122.389654558808) 6 2 9 28855 6
70384 200311 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 300 Spear St 9 Sidewalk: Curb side : Yard Tree Private 2     5     6015556.04211 2115339.65438 37.7891930941324 -122.39000566403 (37.7891930941324, -122.39000566403) 6 2 9 28855 6
74054 200322 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 300 Spear St 19 Sidewalk: Curb side : Yard Tree Private 2     5     6015652.04458 2115257.33734 37.7889723941954 -122.389667752774 (37.7889723941954, -122.389667752774) 6 2 9 28855 6
75505 200330 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 301 Main St 6 Sidewalk: Curb side : Pot Tree Private 2     4 Width 6ft   6015108.79029 2115375.25876 37.7892660408344 -122.391555603302 (37.7892660408344, -122.391555603302) 6 2 9 28855 6
77027 200328 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 301 Main St 4 Sidewalk: Curb side : Pot Tree Private 2     4 Width 6ft   6015179.92906 2115301.4953 37.7890674516516 -122.391304311165 (37.7890674516516, -122.391304311165) 6 2 9 28855 6
77569 200292 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 450 Texas St 11 : Tree Private 2     4 Width 5ft   6013770.81588 2104873.9423 37.7603574361634 -122.395448877276 (37.7603574361634, -122.395448877276) 10 3 8 28856 29
77898 200308 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 300 Spear St 6 Sidewalk: Curb side : Yard Tree Private 2     5     6015536.17066 2115383.72564 37.7893130016286 -122.3900774974 (37.7893130016286, -122.3900774974) 6 2 9 28855 6
83807 200305 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 300 Spear St 3 Sidewalk: Curb side : Yard Tree Private 2     5     6015511.61848 2115384.8547 37.7893147400224 -122.390162524696 (37.7893147400224, -122.390162524696) 6 2 9 28855 6
86905 129747 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 3190 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   5999510.61526 2115720.7507 37.7893365378021 -122.445548086796 (37.7893365378021, -122.445548086796) 13 6 1 29490 27
87842 39930 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 172 Arleta Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/14/2009 12:00:00 AM 5 3x3 Permit Number 52990 6010326.18415 2087986.64159 37.7137963313139 -122.406172524668 (37.7137963313139, -122.406172524668) 9 7 8 309 39
89784 200326 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 301 Main St 2 Sidewalk: Curb side : Pot Tree Private 2     4 Width 6ft   6015205.46217 2115275.82264 37.7889983774274 -122.391214173898 (37.7889983774274, -122.391214173898) 6 2 9 28855 6
90451 200312 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 300 Spear St 10 Sidewalk: Curb side : Yard Tree Private 2     4     6015567.69908 2115350.38922 37.7892232160342 -122.389966082183 (37.7892232160342, -122.389966082183) 6 2 9 28855 6
90977 227931 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 980 York St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6009937.67867 2103531.56117 37.7564576151304 -122.408611275604 (37.7564576151304, -122.408611275604) 2 4 7 28859 19
100023 200315 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 300 Spear St 13 Sidewalk: Curb side : Yard Tree Private 2     4     6015579.66398 2115313.43932 37.7891224236184 -122.389922102621 (37.7891224236184, -122.389922102621) 6 2 9 28855 6
102093 208162 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 1665 08th Ave 3 Sidewalk: Curb side : Yard Tree Private 2     1 Width 6ft   5993685.9274 2104152.49812 37.7572389488356 -122.464860214753 (37.7572389488356, -122.464860214753) 1 8 4 56 12
103617 200303 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 300 Spear St 1 Sidewalk: Curb side : Yard Tree Private 2     4     6015490.91442 2115408.69001 37.7893790379573 -122.390235824847 (37.7893790379573, -122.390235824847) 6 2 9 28855 6
111991 200298 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 300 Spear St 14 Sidewalk: Curb side : Yard Tree Private 2     4     6015397.85362 2115526.63522 37.7896977262219 -122.390566052287 (37.7896977262219, -122.390566052287) 6 2 9 28855 6
112396 200332 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 17 Boardman Pl 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6011624.72103 2110217.8194 37.7749109148507 -122.403247185618 (37.7749109148507, -122.403247185618) 14 2 9 28853 34
116241 208164 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 2 Pacheco St 5 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5994775.46403 2099779.39502 37.7452942748227 -122.460775282677 (37.7452942748227, -122.460775282677) 1 8 4 59 40
121617 200306 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 300 Spear St 4 Sidewalk: Curb side : Yard Tree Private 2     5     6015519.43807 2115394.40113 37.7893413860396 -122.390136136794 (37.7893413860396, -122.390136136794) 6 2 9 28855 6
121774 200325 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 301 Main St 1 Sidewalk: Curb side : Pot Tree Private 2     5 Width 6ft   6015214.59398 2115265.69066 37.7889710641058 -122.391181870273 (37.7889710641058, -122.391181870273) 6 2 9 28855 6
123441 200289 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 450 Texas St 8 : Tree Private 2     3 Width 5ft   6013767.4983 2104927.9135 37.760505444779 -122.39546413249 (37.760505444779, -122.39546413249) 10 3 8 28856 29
133541 82940 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 1538 Howard St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/07/2009 12:00:00 AM 4 3x3 Permit Number 52443 6007864.18963 2109484.13073 37.7726856413711 -122.416203723728 (37.7726856413711, -122.416203723728) 8 2 9 28853 19
133690 200320 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 300 Spear St 18 Sidewalk: Curb side : Yard Tree Private 2     5     6015639.26424 2115274.89459 37.7890198937097 -122.389713198212 (37.7890198937097, -122.389713198212) 6 2 9 28855 6
148318 200314 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 300 Spear St 12 Sidewalk: Curb side : Yard Tree Private 2     4     6015580.5733 2115337.47114 37.7891884599245 -122.389920635833 (37.7891884599245, -122.389920635833) 6 2 9 28855 6
149473 200327 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 301 Main St 3 Sidewalk: Curb side : Pot Tree Private 2     4 Width 6ft   6015192.28002 2115287.61911 37.7890300362672 -122.391260607709 (37.7890300362672, -122.391260607709) 6 2 9 28855 6
154496 208165 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 15 Santa Rita Ave 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 3ft   5993900.31439 2100928.13283 37.748398025869 -122.463884747999 (37.748398025869, -122.463884747999) 1 8 4 29491 40
156712 200329 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 301 Main St 5 Sidewalk: Curb side : Pot Tree Private 2     4 Width 6ft   6015119.86302 2115363.24254 37.7892336616474 -122.391516452246 (37.7892336616474, -122.391516452246) 6 2 9 28855 6
157698 200318 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 300 Spear St 16 Sidewalk: Curb side : Yard Tree Private 2     5     6015625.97497 2115288.24287 37.7890558081156 -122.389760110454 (37.7890558081156, -122.389760110454) 6 2 9 28855 6
158310 208161 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 1665 08th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     1 Width 6ft   5993688.24788 2104180.09485 37.7573148561081 -122.464854193776 (37.7573148561081, -122.464854193776) 1 8 4 56 12
164391 200302 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 300 Spear St 18 Sidewalk: Curb side : Yard Tree Private 2     3     6015426.07027 2115497.69973 37.7896198413245 -122.390466402012 (37.7896198413245, -122.390466402012) 6 2 9 28855 6
164686 200310 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 300 Spear St 8 Sidewalk: Curb side : Yard Tree Private 2     4     6015548.61683 2115370.6056 37.7892776672864 -122.390033517844 (37.7892776672864, -122.390033517844) 6 2 9 28855 6
165361 200319 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 300 Spear St 17 Sidewalk: Curb side : Yard Tree Private 2     4     6015626.37081 2115265.87245 37.7889944060092 -122.389757177753 (37.7889944060092, -122.389757177753) 6 2 9 28855 6
165734 200307 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 300 Spear St 5 Sidewalk: Curb side : Yard Tree Private 2     5     6015523.86991 2115372.58197 37.7892817214302 -122.390119278099 (37.7892817214302, -122.390119278099) 6 2 9 28855 6
166531 227707 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 4969 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5997582.13429 2105601.24546 37.761440716331 -122.451490174633 (37.761440716331, -122.451490174633) 15 5 11 29492 12
169521 60211 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 666 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/23/1982 12:00:00 AM 5   Permit Number 19759 6011785.78487 2105270.27337 37.7613350657931 -122.402342082738 (37.7613350657931, -122.402342082738) 10 3 8 28856 29
170658 200316 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 300 Spear St 14 Sidewalk: Curb side : Yard Tree Private 2     4     6015592.61729 2115325.41388 37.7891560213702 -122.389878122196 (37.7891560213702, -122.389878122196) 6 2 9 28855 6
172776 200296 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 300 Spear St 12 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6015383.95421 2115543.62008 37.7897435916486 -122.390615330635 (37.7897435916486, -122.390615330635) 6 2 9 28855 6
174217 200294 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 450 Texas St 13 : Tree Private 2     2 Width 5ft   6013773.03128 2104844.74935 37.7602774019102 -122.395439169982 (37.7602774019102, -122.395439169982) 10 3 8 28856 29
181608 200291 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 450 Texas St 10 : Tree Private 2     4 Width 5ft   6013769.15954 2104891.14556 37.7604045804367 -122.395455811064 (37.7604045804367, -122.395455811064) 10 3 8 28856 29
183588 208163 DPW Maintained 1 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 1518 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5993392.49567 2105122.66372 37.7598858487692 -122.465945500402 (37.7598858487692, -122.465945500402) 1 8 4 56 12

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