trees
84 rows where Zip Codes = 28856 and qSpecies_id = 53
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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
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) );