trees
548 rows where qCaretaker_id = 1 and qSpecies_id = 53 sorted by Longitude
This data as json, CSV (advanced)
These facets timed out: qCaretaker_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28345 | 6727 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Fairfax Ave | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
41806 | 6719 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Fairfax Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
72329 | 6726 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Fairfax Ave | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
78348 | 6705 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
122954 | 6709 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Fairfax Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
142509 | 6722 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Fairfax Ave | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
169622 | 6721 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Fairfax Ave | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
102193 | 6752 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1215 Fairfax Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x3 | 6017539.76894 | 2096719.16796 | 37.738175006759 | -122.381846478456 | (37.738175006759, -122.381846478456) | 10 | 3 | 8 | 58 | 1 | |||
14874 | 6756 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1215 Fairfax Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | Permit Number 769095 | 6017521.0990665 | 2096743.3718322 | 37.7382404347673 | -122.381912713319 | (37.7382404347673, -122.381912713319) | 10 | 3 | 8 | 58 | 1 | ||
74408 | 6773 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1355 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016787.8631263 | 2097291.0360599 | 37.7397036915046 | -122.384486040227 | (37.7397036915046, -122.384486040227) | 10 | 3 | 8 | 58 | 1 | |||
188021 | 6788 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1390 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6016787.1910829 | 2097353.9213772 | 37.7398763247169 | -122.384492742853 | (37.7398763247169, -122.384492742853) | 10 | 3 | 8 | 58 | 1 | |||
66362 | 6799 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1375 Fairfax Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x9 | 6016685.6205969 | 2097367.3215875 | 37.7399075017412 | -122.384844867735 | (37.7399075017412, -122.384844867735) | 10 | 3 | 8 | 58 | 1 | |||
149060 | 6808 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1395 Fairfax Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6016583.3780675 | 2097443.6071151 | 37.7401113108781 | -122.385203697211 | (37.7401113108781, -122.385203697211) | 10 | 3 | 8 | 58 | 1 | |||
39117 | 14994 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1459X Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016235.7427248 | 2097702.9858463 | 37.7408042749191 | -122.38642376985 | (37.7408042749191, -122.38642376985) | 10 | 3 | 8 | 58 | 1 | |||
14802 | 11429 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 810X Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6016007.44377 | 2096780.42114 | 37.7382584597776 | -122.387148815626 | (37.7382584597776, -122.387148815626) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
110376 | 25995 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1781 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6014085.16035 | 2096167.03762 | 37.7364675981514 | -122.39375225191 | (37.7364675981514, -122.39375225191) | 10 | 3 | 8 | 58 | 1 | |||
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 | ||||
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 | ||||
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 | ||||
150567 | 25558 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 50X Industrial St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/23/2001 12:00:00 AM | 8 | 4X4 | 6012204.29417 | 2097469.52586 | 37.7399392564551 | -122.400346698766 | (37.7399392564551, -122.400346698766) | 10 | 3 | 8 | 58 | 1 | ||
83228 | 28249 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3340 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X3 | 6011954.9354871 | 2090169.2153285 | 37.7198802090971 | -122.400696159958 | (37.7198802090971, -122.400696159958) | 10 | 7 | 8 | 309 | 28 | |||
103656 | 28250 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3340 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X3 | 6011954.9354871 | 2090169.2153285 | 37.7198802090971 | -122.400696159958 | (37.7198802090971, -122.400696159958) | 10 | 7 | 8 | 309 | 28 | |||
40269 | 25702 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 550 06th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6012081.78675 | 2110335.7627 | 37.7752602760543 | -122.401674380603 | (37.7752602760543, -122.401674380603) | 14 | 2 | 9 | 28853 | 34 | |||
42234 | 25701 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 550 06th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6012066.85402 | 2110350.08491 | 37.7752987682674 | -122.40172704355 | (37.7752987682674, -122.40172704355) | 14 | 2 | 9 | 28853 | 34 | |||
180877 | 10578 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1005X HARRISON ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x7 | 6011386 | 2111037 | 37.7771468605476 | -122.404130641378 | (37.7771468605476, -122.404130641378) | 14 | 2 | 9 | 28853 | 34 | |||
41708 | 251371 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 390 06th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 6011351 | 2111108 | 37.7773398544385 | -122.404256716486 | (37.7773398544385, -122.404256716486) | 14 | 2 | 9 | 28853 | 34 | |||
91800 | 19370 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 390X 06TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4X4 | 6011351 | 2111108 | 37.7773398544385 | -122.404256716486 | (37.7773398544385, -122.404256716486) | 14 | 2 | 9 | 28853 | 34 | |||
186181 | 251369 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 390 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 6011351 | 2111108 | 37.7773398544385 | -122.404256716486 | (37.7773398544385, -122.404256716486) | 14 | 2 | 9 | 28853 | 34 | |||
51739 | 19375 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 390X 06th St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6011348.29286 | 2111104.97037 | 37.7773313845055 | -122.404265868127 | (37.7773313845055, -122.404265868127) | 14 | 2 | 9 | 28853 | 34 | |||
148917 | 19373 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 390X 06th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 4X4 | 6011348.29286 | 2111104.97037 | 37.7773313845055 | -122.404265868127 | (37.7773313845055, -122.404265868127) | 14 | 2 | 9 | 28853 | 34 | |||
28163 | 10573 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1000X Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 65 | 4x4 | 6011301.87316 | 2111047.97507 | 37.7771722946398 | -122.404422436991 | (37.7771722946398, -122.404422436991) | 14 | 2 | 9 | 28853 | 34 | |||
44901 | 4596 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 170 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6011285.22621 | 2118219.63855 | 37.7968630551885 | -122.404985101368 | (37.7968630551885, -122.404985101368) | 3 | 1 | 10 | 308 | 4 | |||
47614 | 4599 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 170 Columbus Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6011285.22621 | 2118219.63855 | 37.7968630551885 | -122.404985101368 | (37.7968630551885, -122.404985101368) | 3 | 1 | 10 | 308 | 4 | |||
160977 | 4597 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 170 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6011285.22621 | 2118219.63855 | 37.7968630551885 | -122.404985101368 | (37.7968630551885, -122.404985101368) | 3 | 1 | 10 | 308 | 4 | |||
55005 | 112827 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 101X COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 6011274 | 2118052 | 37.7964021326886 | -122.405012137355 | (37.7964021326886, -122.405012137355) | 3 | 1 | 10 | 308 | 4 | |||
139551 | 112828 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 101X COLUMBUS AVE | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 6011274 | 2118052 | 37.7964021326886 | -122.405012137355 | (37.7964021326886, -122.405012137355) | 3 | 1 | 10 | 308 | 4 | |||
148636 | 112826 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 101X COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 6011274 | 2118052 | 37.7964021326886 | -122.405012137355 | (37.7964021326886, -122.405012137355) | 3 | 1 | 10 | 308 | 4 | |||
186524 | 112825 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 101X COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 6011274 | 2118052 | 37.7964021326886 | -122.405012137355 | (37.7964021326886, -122.405012137355) | 3 | 1 | 10 | 308 | 4 | |||
138724 | 19491 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 10X Saroyan Pl | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6010944.42859 | 2118456.69114 | 37.7974948878134 | -122.406181056735 | (37.7974948878134, -122.406181056735) | 3 | 1 | 10 | 308 | 4 | |||
162852 | 19490 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 10X Saroyan Pl | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6010944.42859 | 2118456.69114 | 37.7974948878134 | -122.406181056735 | (37.7974948878134, -122.406181056735) | 3 | 1 | 10 | 308 | 4 | |||
18087 | 4603 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 270 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6010933.33158 | 2118545.7793 | 37.7977388815556 | -122.406225735505 | (37.7977388815556, -122.406225735505) | 3 | 1 | 10 | 308 | 23 | |||
89072 | 18459 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1137 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6010601.42584 | 2102531.48836 | 37.7537487889396 | -122.406245333375 | (37.7537487889396, -122.406245333375) | 10 | 4 | 8 | 28859 | 19 | |||
31123 | 18463 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1185X Potrero Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3x3 | 6010590.6142382 | 2102338.4990144 | 37.7532182781408 | -122.406269126047 | (37.7532182781408, -122.406269126047) | 10 | 4 | 8 | 28859 | 19 | |||
59584 | 18467 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1185X Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6010590.6142382 | 2102338.4990144 | 37.7532182781408 | -122.406269126047 | (37.7532182781408, -122.406269126047) | 10 | 4 | 8 | 28859 | 19 | |||
23258 | 4604 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 270 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 3x3 | 6010907.72336 | 2118541.73775 | 37.7977263519913 | -122.406314062528 | (37.7977263519913, -122.406314062528) | 3 | 1 | 10 | 308 | 23 | |||
142133 | 18453 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1101 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3x3 | 6010571.1211098 | 2102712.3512407 | 37.7542437031283 | -122.406362877305 | (37.7542437031283, -122.406362877305) | 10 | 4 | 8 | 28859 | 19 | |||
151621 | 482 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1182X Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3x3 | 6010538.0981 | 2102333.37734 | 37.7532012773937 | -122.406450377502 | (37.7532012773937, -122.406450377502) | 10 | 4 | 7 | 28859 | 19 | |||
172812 | 18468 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4X4 | 6010533.61703 | 2102196.70237 | 37.7528257474783 | -122.406456244122 | (37.7528257474783, -122.406456244122) | 10 | 4 | 7 | 28859 | 19 | |||
24869 | 18469 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 4X4 | 6010532.643 | 2102160.24981 | 37.7527256023187 | -122.406457044136 | (37.7527256023187, -122.406457044136) | 10 | 4 | 7 | 28859 | 19 | |||
133106 | 18462 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1170 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6010530.25012 | 2102443.0228 | 37.7535019005095 | -122.406485243092 | (37.7535019005095, -122.406485243092) | 10 | 4 | 7 | 28859 | 19 | |||
91776 | 18465 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1176 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/05/2015 12:00:00 AM | 45 | 3X4 | 6010529.14326 | 2102401.59944 | 37.7533880992141 | -122.40648615219 | (37.7533880992141, -122.40648615219) | 10 | 4 | 7 | 28859 | 19 | ||
191197 | 18454 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1106 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3x3 | 6010521.1889393 | 2102709.7477141 | 37.7542337610764 | -122.406535372627 | (37.7542337610764, -122.406535372627) | 10 | 4 | 7 | 28859 | 19 | |||
141160 | 18451 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1082 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4x4 | 6010493.0142586 | 2102932.3469158 | 37.7548433927728 | -122.40664849396 | (37.7548433927728, -122.40664849396) | 10 | 4 | 7 | 28859 | 19 | |||
33912 | 484 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2704 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010466.15731 | 2102352.85565 | 37.7532507356841 | -122.406700537042 | (37.7532507356841, -122.406700537042) | 10 | 4 | 7 | 28859 | 19 | |||
139905 | 18447 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1036 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6010477.6303584 | 2103193.8225196 | 37.7555604859056 | -122.406720122129 | (37.7555604859056, -122.406720122129) | 10 | 4 | 7 | 28859 | 19 | |||
185861 | 18445 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1024 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 4x4 | 6010473.6370906 | 2103261.6949103 | 37.7557466249525 | -122.406738715199 | (37.7557466249525, -122.406738715199) | 10 | 4 | 7 | 28859 | 19 | |||
66172 | 18444 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1020 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4x4 | 6010472.2950908 | 2103284.5044843 | 37.7558091798762 | -122.406744963711 | (37.7558091798762, -122.406744963711) | 10 | 4 | 7 | 28859 | 19 | |||
129417 | 18412 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 799X Potrero Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4x4 | 6010481.3464666 | 2104567.7087473 | 37.7593330783471 | -122.406804093165 | (37.7593330783471, -122.406804093165) | 10 | 4 | 8 | 28859 | 19 | |||
97770 | 18392 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 886 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6010424.2598856 | 2104075.0244367 | 37.7579770833513 | -122.406966801395 | (37.7579770833513, -122.406966801395) | 10 | 4 | 7 | 28859 | 19 | |||
186502 | 18393 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 886 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6010424.2598856 | 2104075.0244367 | 37.7579770833513 | -122.406966801395 | (37.7579770833513, -122.406966801395) | 10 | 4 | 7 | 28859 | 19 | |||
158510 | 18390 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 866 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 6010418.2672605 | 2104189.3928818 | 37.7582907781506 | -122.406995587546 | (37.7582907781506, -122.406995587546) | 10 | 4 | 7 | 28859 | 19 | |||
163969 | 18370 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 635 Potrero Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 4x4 | 6010438.67568 | 2105328.38433 | 37.7614193346753 | -122.407005286068 | (37.7614193346753, -122.407005286068) | 10 | 4 | 8 | 28859 | 19 | |||
142871 | 18385 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 812 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 16x5 | 6010402.1602537 | 2104496.7929466 | 37.759133928444 | -122.407072960308 | (37.759133928444, -122.407072960308) | 10 | 4 | 7 | 28859 | 19 | |||
90532 | 490 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2734 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010357.12636 | 2102291.83707 | 37.7530770912847 | -122.407073289419 | (37.7530770912847, -122.407073289419) | 10 | 4 | 7 | 28859 | 19 | |||
20262 | 253597 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 269 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010453 | 2107072 | 37.7662077096315 | -122.407078650031 | (37.7662077096315, -122.407078650031) | 8 | 4 | 8 | 28853 | 19 | ||||
53550 | 18383 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 804 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 3x3 | 6010399.792436 | 2104541.9824298 | 37.7592578761131 | -122.407084334673 | (37.7592578761131, -122.407084334673) | 10 | 4 | 7 | 28859 | 19 | |||
73677 | 18366 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 601 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6010418.5901612 | 2105518.9759028 | 37.7619415321313 | -122.407088188566 | (37.7619415321313, -122.407088188566) | 8 | 4 | 8 | 28859 | 19 | |||
154248 | 18380 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 756 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6010387.2722525 | 2104782.2318449 | 37.7599168463595 | -122.407144570806 | (37.7599168463595, -122.407144570806) | 10 | 4 | 8 | 28859 | 19 | |||
72828 | 18316 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 199 POTRERO AVE | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6010430 | 2107503 | 37.7673898501442 | -122.407188587519 | (37.7673898501442, -122.407188587519) | 8 | 4 | 8 | 28853 | 19 | |||
101356 | 18317 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 199 POTRERO AVE | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6010430 | 2107503 | 37.7673898501442 | -122.407188587519 | (37.7673898501442, -122.407188587519) | 8 | 4 | 8 | 28853 | 19 | |||
90745 | 18351 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 469 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3x3 | 6010382.7073264 | 2106125.7302845 | 37.7636055342277 | -122.407255067708 | (37.7636055342277, -122.407255067708) | 8 | 4 | 8 | 28859 | 19 | |||
50489 | 18364 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 598 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 6010361.2141646 | 2105516.7578044 | 37.7619322307219 | -122.407286474232 | (37.7619322307219, -122.407286474232) | 8 | 4 | 8 | 28859 | 19 | |||
131086 | 18365 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 598 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 6010361.2141646 | 2105516.7578044 | 37.7619322307219 | -122.407286474232 | (37.7619322307219, -122.407286474232) | 8 | 4 | 8 | 28859 | 19 | |||
97139 | 15172 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 941 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6010497.86985 | 2112769.44604 | 37.7818540873698 | -122.40732513932 | (37.7818540873698, -122.40732513932) | 14 | 2 | 9 | 28853 | 34 | |||
71188 | 4619 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 358 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 32 | 3x3 | 6010602.31813 | 2118839.00805 | 37.7985254951528 | -122.407391821594 | (37.7985254951528, -122.407391821594) | 3 | 1 | 10 | 308 | 23 | |||
4699 | 23132 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 610X Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/29/1999 12:00:00 AM | 3 | 4x4 | 6010603.58879 | 2118945.35218 | 37.798817561298 | -122.407394925794 | (37.798817561298, -122.407394925794) | 3 | 1 | 10 | 308 | 23 |
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) );