trees

125 rows where Supervisor Districts = 8 and qSpecies_id = 53 sorted by TreeID

✎ View and edit SQL

This data as json, CSV (advanced)

Supervisor Districts ✖

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)
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
89256 111871 Undocumented 4 Ficus nitida :: Laurel Fig 53 300X POTRERO AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010207 2106863 37.7656200738156 -122.407914780785 (37.7656200738156, -122.407914780785) 8 4 8 28853 19
86959 111872 Undocumented 4 Ficus nitida :: Laurel Fig 53 300X POTRERO AVE 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010207 2106863 37.7656200738156 -122.407914780785 (37.7656200738156, -122.407914780785) 8 4 8 28853 19
86618 111873 Undocumented 4 Ficus nitida :: Laurel Fig 53 300X POTRERO AVE 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010207 2106863 37.7656200738156 -122.407914780785 (37.7656200738156, -122.407914780785) 8 4 8 28853 19
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
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
145639 112403 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
43596 112404 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
153176 112405 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
130193 112406 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
166186 112407 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
55250 112408 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
168880 112409 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
120051 112410 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
37186 112411 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
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
52462 116125 Undocumented 4 Ficus nitida :: Laurel Fig 53 2500X Keith St 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6014198.52795 2092093.45262 37.7252886606488 -122.393075349238 (37.7252886606488, -122.393075349238) 10 3 8 58 1
163580 116126 Undocumented 4 Ficus nitida :: Laurel Fig 53 2500X Keith St 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6014198.52795 2092093.45262 37.7252886606488 -122.393075349238 (37.7252886606488, -122.393075349238) 10 3 8 58 1
174144 116127 Undocumented 4 Ficus nitida :: Laurel Fig 53 2500X Keith St 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6014198.52795 2092093.45262 37.7252886606488 -122.393075349238 (37.7252886606488, -122.393075349238) 10 3 8 58 1
89965 116128 Undocumented 4 Ficus nitida :: Laurel Fig 53 2500X Keith St 4 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6014198.52795 2092093.45262 37.7252886606488 -122.393075349238 (37.7252886606488, -122.393075349238) 10 3 8 58 1
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
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
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
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
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
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
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
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
178024 173876 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 250 Raymond Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009764 2087931 37.7136120890563 -122.408111727364 (37.7136120890563, -122.408111727364) 9 7 8 309 39
170902 18297 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 35X Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     35 3X3   6010274.737783 2108072.9305947 37.7689460585554 -122.407765812226 (37.7689460585554, -122.407765812226) 8 4 8 28853 19
98753 18298 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 35X Potrero Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     35 3X3   6010274.737783 2108072.9305947 37.7689460585554 -122.407765812226 (37.7689460585554, -122.407765812226) 8 4 8 28853 19
47161 18304 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 100 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6010232.4387225 2107842.1672579 37.7683100673499 -122.407895847634 (37.7683100673499, -122.407895847634) 8 4 8 28853 19
75232 18306 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 100 Potrero Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6010232.4387225 2107842.1672579 37.7683100673499 -122.407895847634 (37.7683100673499, -122.407895847634) 8 4 8 28853 19
141499 18310 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 140 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 4X4   6010243.055587 2107664.3185897 37.7678223300533 -122.407846582122 (37.7678223300533, -122.407846582122) 8 4 8 28853 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
28577 18320 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 206 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     40 4X4   6010262.2750436 2107350.6845554 37.7669622387245 -122.40775798639 (37.7669622387245, -122.40775798639) 8 4 8 28853 19
33185 18322 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 226 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     40 4X4   6010268.7839855 2107259.8540962 37.7667132034185 -122.407729067657 (37.7667132034185, -122.407729067657) 8 4 8 28853 19
152094 18326 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 259 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     40 3X3   6010329.0895487 2107117.8320658 37.7663266190773 -122.407510465965 (37.7663266190773, -122.407510465965) 8 4 8 28853 19
148347 18327 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 259 Potrero Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     40 3X2   6010329.0895487 2107117.8320658 37.7663266190773 -122.407510465965 (37.7663266190773, -122.407510465965) 8 4 8 28853 19
183113 18328 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 269 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     40 3X3   6010332.3440196 2107072.4168362 37.7662021013824 -122.407496007113 (37.7662021013824, -122.407496007113) 8 4 8 28853 19
139216 18329 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 269 Potrero Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     40 3X3   6010332.3440196 2107072.4168362 37.7662021013824 -122.407496007113 (37.7662021013824, -122.407496007113) 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
52126 22281 Permitted Site 7 Ficus nitida :: Laurel Fig 53 4755X 03rd St 5 Sidewalk: Curb side : Cutout Tree Arts Commission 19     18 3X3   6015037.5047362 2095657.5026115 37.7351213950345 -122.390423975921 (37.7351213950345, -122.390423975921) 10 3 8 58 1
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
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
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
29445 26153 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1500 Oakdale Ave 24 Sidewalk: Curb side : Cutout Tree Rec/Park 5     12 3X3   6015586.3934773 2095100.209325 37.7336216133372 -122.388487366626 (37.7336216133372, -122.388487366626) 10 3 8 58 1
129171 27857 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1450X Fairfax Ave 7 Sidewalk: Curb side : Cutout Tree Fire Dept 16     12 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.386179680893 (37.740834465841, -122.386179680893) 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
101295 29407 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2801X Ingalls St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3X3   6014804.18454 2090650.03815 37.7213589569903 -122.390880803843 (37.7213589569903, -122.390880803843) 10 3 8 58 1
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
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
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
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

Next page

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