trees

84 rows where Zip Codes = 28856 and qSpecies_id = 53

✎ View and edit SQL

This data as json, CSV (advanced)

Zip Codes ✖

  • 28856 · 84 ✖
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)
3630 258965 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 398x Bryant St 5 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014405 2113268 37.7834409032593 -122.393843088876 (37.7834409032593, -122.393843088876) 6 2 9 28856 6
5064 258966 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 398x Bryant St 6 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014405 2113268 37.7834409032593 -122.393843088876 (37.7834409032593, -122.393843088876) 6 2 9 28856 6
6270 258961 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 398x Bryant St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014405 2113268 37.7834409032593 -122.393843088876 (37.7834409032593, -122.393843088876) 6 2 9 28856 6
9438 115058 Undocumented 4 Ficus nitida :: Laurel Fig 53 499X BRANNAN ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013762 2111312 37.7780344196247 -122.395930522096 (37.7780344196247, -122.395930522096) 6 2 9 28856 34
9626 258963 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 398x Bryant St 3 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014405 2113268 37.7834409032593 -122.393843088876 (37.7834409032593, -122.393843088876) 6 2 9 28856 6
9664 258964 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 398x Bryant St 4 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014405 2113268 37.7834409032593 -122.393843088876 (37.7834409032593, -122.393843088876) 6 2 9 28856 6
10154 258967 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 398x Bryant St 7 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014405 2113268 37.7834409032593 -122.393843088876 (37.7834409032593, -122.393843088876) 6 2 9 28856 6
11514 258968 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 398x Bryant St 8 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014405 2113268 37.7834409032593 -122.393843088876 (37.7834409032593, -122.393843088876) 6 2 9 28856 6
15941 85313 Significant Tree 6 Ficus nitida :: Laurel Fig 53 610 Brannan St 1 unknown : Cutout Tree Private 2         Permit Number 49594 6012704.2 2110820.8 37.7766267904106 -122.399555358584 (37.7766267904106, -122.399555358584) 14 2 9 28856 34
17682 258962 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 398x Bryant St 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014405 2113268 37.7834409032593 -122.393843088876 (37.7834409032593, -122.393843088876) 6 2 9 28856 6
18544 258969 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 398x Bryant St 9 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014405 2113268 37.7834409032593 -122.393843088876 (37.7834409032593, -122.393843088876) 6 2 9 28856 6
18675 101715 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 1 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
18772 115057 Undocumented 4 Ficus nitida :: Laurel Fig 53 499X BRANNAN ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013762 2111312 37.7780344196247 -122.395930522096 (37.7780344196247, -122.395930522096) 6 2 9 28856 34
20820 111597 Undocumented 4 Ficus nitida :: Laurel Fig 53 398X BRYANT ST 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 6
23663 85059 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2435 03rd St 4 Sidewalk: Curb side : Cutout Tree DPW 1     6 4x9   6015831.18626 2104262.21936 37.7587921580004 -122.388280257816 (37.7587921580004, -122.388280257816) 10 3 8 28856 29
30509 109858 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2455 03RD ST 4 Sidewalk: Curb side : Cutout Tree DPW 1     15 5x8   6015836.2 2104173 37.7585474584562 -122.388256691115 (37.7585474584562, -122.388256691115) 10 3 8 28856 29
34152 21980 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2575 03rd St 2 Sidewalk: Curb side : Cutout Tree DPW 1     16 3x3   6015881.32806 2103602.42313 37.7569832760363 -122.388060799634 (37.7569832760363, -122.388060799634) 10 3 8 28856 29
35952 120884 Undocumented 4 Ficus nitida :: Laurel Fig 53 2140x 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011295 2105636 37.7623118602886 -122.404065249735 (37.7623118602886, -122.404065249735) 8 3 8 28856 29
38859 115059 Undocumented 4 Ficus nitida :: Laurel Fig 53 499X BRANNAN ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013762 2111312 37.7780344196247 -122.395930522096 (37.7780344196247, -122.395930522096) 6 2 9 28856 34
43224 117205 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1401 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2           6013468.70293325 2105662.80878203 37.762506682391 -122.396549051509 (37.762506682391, -122.396549051509) 10 3 8 28856 29
43639 111595 Undocumented 4 Ficus nitida :: Laurel Fig 53 398X BRYANT ST 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 6
48959 112162 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1324 18th St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013680.97327942 2105726.70860795 37.7626939483281 -122.39581935837 (37.7626939483281, -122.39581935837) 14 3 8 28856 29
49286 21956 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2475 03rd St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x9   6015841.22266 2104083.69236 37.7583025169931 -122.388233087559 (37.7583025169931, -122.388233087559) 10 3 8 28856 29
50036 100262 Undocumented 4 Ficus nitida :: Laurel Fig 53 40 Federal St 2 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6014922 2113400.9 37.7838345339316 -122.392063753471 (37.7838345339316, -122.392063753471) 6 2 9 28856 6
50734 21952 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2455 03RD ST 1 Sidewalk: Curb side : Cutout Tree DPW 1     14 4x9   6015836.2 2104173 37.7585474584562 -122.388256691115 (37.7585474584562, -122.388256691115) 10 3 8 28856 29
53748 110363 Undocumented 4 Ficus nitida :: Laurel Fig 53 1899x MARIPOSA ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011823 2106021 37.7633984709679 -122.402266155018 (37.7633984709679, -122.402266155018) 8 3 8 28856 29
54784 101716 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 2 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
55811 115056 Undocumented 4 Ficus nitida :: Laurel Fig 53 499X BRANNAN ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013762 2111312 37.7780344196247 -122.395930522096 (37.7780344196247, -122.395930522096) 6 2 9 28856 34
63978 119667 Undocumented 4 Ficus nitida :: Laurel Fig 53 699x Missouri St 8 Sidewalk: Property side : Yard Tree Private 2           6013712 2104098 37.7582235960409 -122.395597929962 (37.7582235960409, -122.395597929962) 10 3 8 28856 29
65043 100265 Undocumented 4 Ficus nitida :: Laurel Fig 53 40 Federal St 5 Sidewalk: Property side : Cutout Tree Private 2     24 3x3   6014922 2113400.9 37.7838345339316 -122.392063753471 (37.7838345339316, -122.392063753471) 6 2 9 28856 6
77443 111583 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1501-1555 Mariposa St 7 Sidewalk: Curb side : Cutout Tree Private 2           6012875.34483574 2106095.24513094 37.7636610173266 -122.398631621456 (37.7636610173266, -122.398631621456) 14 3 8 28856 29
85621 21994 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2585 03rd St 13 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x6   6015909.89309 2103367.89889 37.7563409047326 -122.387945645479 (37.7563409047326, -122.387945645479) 10 3 8 28856 29
85979 120943 Undocumented 4 Ficus nitida :: Laurel Fig 53 485 Carolina St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012395 2105853 37.7629690927527 -122.400275979648 (37.7629690927527, -122.400275979648) 14 3 8 28856 29
87085 101725 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 11 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
90466 21986 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2585 03rd St 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x9   6015885.54141 2103557.92781 37.7568613347581 -122.388043123198 (37.7568613347581, -122.388043123198) 10 3 8 28856 29
94460 101975 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1230 19th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 769454 6013882 2105282.2 37.7614846061652 -122.395092936828 (37.7614846061652, -122.395092936828) 10 3 8 28856 29
97368 64484 Permitted Site 7 Ficus nitida :: Laurel Fig 53 436 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/19/1988 12:00:00 AM     Permit Number 778749 6014198.52964849 2112913.46772182 37.782455962378 -122.39453256733 (37.782455962378, -122.39453256733) 6 2 9 28856 6
99255 111592 Undocumented 4 Ficus nitida :: Laurel Fig 53 398X BRYANT ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 6
100042 40805 Permitted Site 7 Ficus nitida :: Laurel Fig 53 585 Connecticut St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 41753 6013296.02646982 2104345.28151099 37.758879430057 -122.397053895785 (37.758879430057, -122.397053895785) 10 3 8 28856 29
100521 111578 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1501-1555 Mariposa St 2 Sidewalk: Curb side : Cutout Tree Private 2           6012875.34483574 2106095.24513094 37.7636610173266 -122.398631621456 (37.7636610173266, -122.398631621456) 14 3 8 28856 29
100811 111598 Undocumented 4 Ficus nitida :: Laurel Fig 53 398X BRYANT ST 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 6
101430 111584 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1501-1555 Mariposa St 8 Sidewalk: Curb side : Cutout Tree Private 2           6012875.34483574 2106095.24513094 37.7636610173266 -122.398631621456 (37.7636610173266, -122.398631621456) 14 3 8 28856 29
104299 21960 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2525 03RD ST 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6015860.3 2103824.9 37.7575929852339 -122.388149048897 (37.7575929852339, -122.388149048897) 10 3 8 28856 29
104676 100260 Undocumented 4 Ficus nitida :: Laurel Fig 53 30X Federal St 2 Sidewalk: Curb side : Cutout Tree Private 2     24 4x3   6015074.6 2113439.2 37.7839481682667 -122.391538488525 (37.7839481682667, -122.391538488525) 6 2 9 28856 6
105748 21991 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2585 03rd St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 4x6   6015885.54141 2103557.92781 37.7568613347581 -122.388043123198 (37.7568613347581, -122.388043123198) 10 3 8 28856 29
105989 101717 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 3 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
107982 111590 Undocumented 4 Ficus nitida :: Laurel Fig 53 398X BRYANT ST 1 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 6
109074 115054 Undocumented 4 Ficus nitida :: Laurel Fig 53 499X BRANNAN ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013762 2111312 37.7780344196247 -122.395930522096 (37.7780344196247, -122.395930522096) 6 2 9 28856 34
109428 116772 Undocumented 4 Ficus nitida :: Laurel Fig 53 376 MISSOURI ST 1 Sidewalk: Curb side : Cutout Tree Private 2       7x9   6013450 2105342 37.7616247710574 -122.396591249035 (37.7616247710574, -122.396591249035) 10 3 8 28856 29
112959 21977 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2573 03rd St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6015880.48539 2103611.32219 37.7570076642803 -122.388064334928 (37.7570076642803, -122.388064334928) 10 3 8 28856 29
118179 21987 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2585 03rd St 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x9   6015885.54141 2103557.92781 37.7568613347581 -122.388043123198 (37.7568613347581, -122.388043123198) 10 3 8 28856 29
121552 117206 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1401 18th St 3 Sidewalk: Curb side : Cutout Tree Private 2           6013468.70293325 2105662.80878203 37.762506682391 -122.396549051509 (37.762506682391, -122.396549051509) 10 3 8 28856 29
123071 21969 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2565 03rd St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x6   6015991.1899 2103495.51019 37.7566958018452 -122.38767339342 (37.7566958018452, -122.38767339342) 10 3 8 28856 29
124317 91126 Permitted Site 7 Ficus nitida :: Laurel Fig 53 610 Brannan St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 49594 6012704.2 2110820.8 37.7766267904106 -122.399555358584 (37.7766267904106, -122.399555358584) 14 2 9 28856 34
127555 110364 Undocumented 4 Ficus nitida :: Laurel Fig 53 1899x MARIPOSA ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011823 2106021 37.7633984709679 -122.402266155018 (37.7633984709679, -122.402266155018) 8 3 8 28856 29
128956 21983 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2585 03rd St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x9   6015885.54141 2103557.92781 37.7568613347581 -122.388043123198 (37.7568613347581, -122.388043123198) 10 3 8 28856 29
129331 21948 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2435 03rd St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x9   6015831.18626 2104262.21936 37.7587921580004 -122.388280257816 (37.7587921580004, -122.388280257816) 10 3 8 28856 29
131840 100259 Undocumented 4 Ficus nitida :: Laurel Fig 53 30X Federal St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 4x3   6015074.6 2113439.2 37.7839481682667 -122.391538488525 (37.7839481682667, -122.391538488525) 6 2 9 28856 6
135125 45390 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1501-1555 Mariposa St 9 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2001 12:00:00 AM     Permit Number 44202 6012875.34483574 2106095.24513094 37.7636610173266 -122.398631621456 (37.7636610173266, -122.398631621456) 14 3 8 28856 29
135772 100261 Undocumented 4 Ficus nitida :: Laurel Fig 53 40 Federal St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6014922 2113400.9 37.7838345339316 -122.392063753471 (37.7838345339316, -122.392063753471) 6 2 9 28856 6
138070 101722 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 8 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
138111 111582 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1501-1555 Mariposa St 6 Sidewalk: Curb side : Cutout Tree Private 2           6012875.34483574 2106095.24513094 37.7636610173266 -122.398631621456 (37.7636610173266, -122.398631621456) 14 3 8 28856 29
138887 101721 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 7 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
143054 57622 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1401 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/15/1976 12:00:00 AM     Permit Number 16516 6013468.70293325 2105662.80878203 37.762506682391 -122.396549051509 (37.762506682391, -122.396549051509) 10 3 8 28856 29
143637 101724 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 10 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
144365 111593 Undocumented 4 Ficus nitida :: Laurel Fig 53 398X BRYANT ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 6
146992 21975 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2565 03rd St 7 Sidewalk: Curb side : Cutout Tree DPW 1     23 4x6   6015991.1899 2103495.51019 37.7566958018452 -122.38767339342 (37.7566958018452, -122.38767339342) 10 3 8 28856 29
147048 47565 Permitted Site 7 Ficus nitida :: Laurel Fig 53 920 Harrison St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/14/2002 12:00:00 AM     Permit Number 45425 6011901.71412119 2111593.71793264 37.7787042813354 -122.402385767126 (37.7787042813354, -122.402385767126) 14 2 9 28856 34
150162 111596 Undocumented 4 Ficus nitida :: Laurel Fig 53 398X BRYANT ST 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 6
151394 21984 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2585 03rd St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x9   6015885.54141 2103557.92781 37.7568613347581 -122.388043123198 (37.7568613347581, -122.388043123198) 10 3 8 28856 29
158317 111591 Undocumented 4 Ficus nitida :: Laurel Fig 53 398X BRYANT ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 6
158929 101720 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 6 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
161591 21959 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2525 03RD ST 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x6   6015860.3 2103824.9 37.7575929852339 -122.388149048897 (37.7575929852339, -122.388149048897) 10 3 8 28856 29
167657 100264 Undocumented 4 Ficus nitida :: Laurel Fig 53 40 Federal St 4 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6014922 2113400.9 37.7838345339316 -122.392063753471 (37.7838345339316, -122.392063753471) 6 2 9 28856 6
169319 101719 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 5 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
173264 111594 Undocumented 4 Ficus nitida :: Laurel Fig 53 398X BRYANT ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 6
174749 100263 Undocumented 4 Ficus nitida :: Laurel Fig 53 40 Federal St 3 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6014922 2113400.9 37.7838345339316 -122.392063753471 (37.7838345339316, -122.392063753471) 6 2 9 28856 6
176915 101718 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 4 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
179093 21930 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2347 03rd St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x5   6015939.39473 2104425.48438 37.7592464441674 -122.38791741203 (37.7592464441674, -122.38791741203) 10 3 8 28856 29
179159 101726 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 12 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
182806 112161 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1324 18th St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013680.97327942 2105726.70860795 37.7626939483281 -122.39581935837 (37.7626939483281, -122.39581935837) 14 3 8 28856 29
185458 91127 Permitted Site 7 Ficus nitida :: Laurel Fig 53 610 Brannan St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 49594 6012704.2 2110820.8 37.7766267904106 -122.399555358584 (37.7766267904106, -122.399555358584) 14 2 9 28856 34
188136 120939 Undocumented 4 Ficus nitida :: Laurel Fig 53 485 Carolina St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012395 2105853 37.7629690927527 -122.400275979648 (37.7629690927527, -122.400275979648) 14 3 8 28856 29
189256 91128 Permitted Site 7 Ficus nitida :: Laurel Fig 53 610 Brannan St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 49594 6012704.2 2110820.8 37.7766267904106 -122.399555358584 (37.7766267904106, -122.399555358584) 14 2 9 28856 34

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