Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5515 | 5515 | 48743 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
6135 | 6135 | 48746 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
6948 | 6948 | 20002 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 STAIRWAY46 | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2 | ||||||||
6959 | 6959 | 48747 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
7180 | 7180 | 48749 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
7696 | 7696 | 19998 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 STAIRWAY46 | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 40 | ||||||||
8095 | 8095 | 50823 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2004 12:00:00 AM | Permit Number 47344 | |||||||||
8773 | 8773 | 48750 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
8939 | 8939 | 48748 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
9025 | 9025 | 48744 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
10338 | 10338 | 30354 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1956 12:00:00 AM | Permit Number 43 | |||||||||
10647 | 10647 | 19755 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 STAIRWAY15 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | ||||||||
13566 | 13566 | 48742 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
14417 | 14417 | 48751 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
15637 | 15637 | 48745 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
16139 | 16139 | 19754 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 STAIRWAY15 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | ||||||||
16857 | 16857 | 50824 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2004 12:00:00 AM | Permit Number 47344 | |||||||||
189144 | 189144 | 121399 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 349X Cargo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | ||||||||||
44946 | 44946 | 184527 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1961 48th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5981338.0835 | 2101535.3662 | 37.7493333765729 | -122.50736894655701 | (37.7493333765729, -122.507368946557) | |||
96965 | 96965 | 112126 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 8245 Geary Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 55 | 3x3 | 5981385.27932 | 2112314.25515 | 37.7789318748139 | -122.508005614464 | (37.7789318748139, -122.508005614464) | ||||
75336 | 75336 | 119014 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 865 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 1ft | 5982296.59784 | 2109865.7372 | 37.772262614999 | -122.50467158554599 | (37.772262614999, -122.504671585546) | |||
167257 | 167257 | 100577 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1201 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 5982377.2 | 2106858.6 | 37.764010624537896 | -122.504169987001 | (37.7640106245379, -122.504169987001) | |||
43129 | 43129 | 54833 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 601 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/1972 12:00:00 AM | 18 | Permit Number 10687 | 5982543.3158 | 2111642.14145 | 37.777154613505395 | -122.50394977664 | (37.7771546135054, -122.50394977664) | ||
68714 | 68714 | 119004 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 601 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5982545.54155 | 2111623.4074 | 37.7771033061655 | -122.503940689292 | (37.7771033061655, -122.503940689292) | |||
169075 | 169075 | 56603 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 4199@43rd Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | 5982724.27515302 | 2106932.91664164 | 37.764235082111895 | -122.50297507862801 | (37.7642350821119, -122.502975078628) | ||||
77188 | 77188 | 183328 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1216 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 0ft | 5982751.4929 | 2106821.2818 | 37.7639301643939 | -122.502872677188 | (37.7639301643939, -122.502872677188) | |||
10109 | 10109 | 114554 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1200x 43RD AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5982778.0 | 2106905.0 | 37.764161588502795 | -122.50278719613199 | (37.7641615885028, -122.502787196132) | ||||
135343 | 135343 | 183274 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1243 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 5983025.1929 | 2106638.7454 | 37.7634450534429 | -122.50191253924 | (37.7634450534429, -122.50191253924) | |||
184826 | 184826 | 117915 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 831 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 5983218.794509999 | 2110128.25948 | 37.7730376298846 | -122.501501101241 | (37.7730376298846, -122.501501101241) | |||
27827 | 27827 | 117873 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 884 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5983275.9121900005 | 2109791.81143 | 37.772117195094 | -122.50127863614401 | (37.772117195094, -122.501278636144) | |||
156959 | 156959 | 184193 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1426 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 5983421.5653 | 2105406.7614 | 37.7600856503507 | -122.500450541411 | (37.7600856503507, -122.500450541411) | |||
34129 | 34129 | 63191 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 480 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | 14 | 4x9 | Permit Number 23731 | 5984103.006630001 | 2112603.98729 | 37.7798871547077 | -122.49862546555599 | (37.7798871547077, -122.498625465556) |
188559 | 188559 | 183674 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1271 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 0ft | 5984268.7246 | 2106531.5004 | 37.7632235599314 | -122.49760371081301 | (37.7632235599314, -122.497603710813) | |||
160351 | 160351 | 63201 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 434 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | 17 | Permit Number 23742 | 5984713.13689 | 2112937.02697 | 37.7808373486479 | -122.496539369055 | (37.7808373486479, -122.496539369055) | |
103615 | 103615 | 21143 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2292X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984947.8628076 | 2099601.6268993 | 37.7442358239277 | -122.49474388696001 | (37.7442358239277, -122.49474388696) | |||
60974 | 60974 | 118186 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 646 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 5985387.96232 | 2111474.08319 | 37.776860037302704 | -122.494096998013 | (37.7768600373027, -122.494096998013) | |||
117813 | 117813 | 32306 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 840 El Camino Del Mar | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1996 12:00:00 AM | Permit Number 36881 | 5985844.77778671 | 2115067.5891122 | 37.7867534900239 | -122.49278149751001 | (37.7867534900239, -122.49278149751) | |||
143520 | 143520 | 32305 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 840 El Camino Del Mar | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1996 12:00:00 AM | Permit Number 36881 | 5985844.77778671 | 2115067.5891122 | 37.7867534900239 | -122.49278149751001 | (37.7867534900239, -122.49278149751) | |||
144054 | 144054 | 32304 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 840 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1996 12:00:00 AM | Permit Number 36881 | 5985844.77778671 | 2115067.5891122 | 37.7867534900239 | -122.49278149751001 | (37.7867534900239, -122.49278149751) | |||
69852 | 69852 | 119415 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 463 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5985915.10497 | 2112796.56014 | 37.7805220119226 | -122.49237088698601 | (37.7805220119226, -122.492370886986) | |||
144522 | 144522 | 95498 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X 32nd Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 18 | 3x3 | 5985976.055430001 | 2112422.37376 | 37.779498166536605 | -122.492132474117 | (37.7794981665366, -122.492132474117) | |||
87843 | 87843 | 95499 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X 32nd Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 18 | 3x3 | 5985977.73249 | 2112402.27637 | 37.7794430828921 | -122.49212519236 | (37.7794430828921, -122.49212519236) | |||
110535 | 110535 | 95495 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X 32nd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | 3x3 | 5986000.954969999 | 2111699.3103 | 37.7775142963957 | -122.49199308703699 | (37.7775142963957, -122.491993087037) | |||
124247 | 124247 | 88364 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2559 33rd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51343 | 5986101.6 | 2097823.5 | 37.739421027827 | -122.490623769288 | (37.739421027827, -122.490623769288) | |||
122879 | 122879 | 100167 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 710 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5986405.6 | 2114870.0 | 37.7862437457696 | -122.49082666767099 | (37.7862437457696, -122.490826667671) | |||||
96107 | 96107 | 113492 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2850 LAKE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5986565.0 | 2114493.0 | 37.7852179229774 | -122.49024745024299 | (37.7852179229774, -122.490247450243) | ||||
126491 | 126491 | 113493 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2850 LAKE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5986565.0 | 2114493.0 | 37.7852179229774 | -122.49024745024299 | (37.7852179229774, -122.490247450243) | ||||
139366 | 139366 | 113494 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2850 LAKE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5986565.0 | 2114493.0 | 37.7852179229774 | -122.49024745024299 | (37.7852179229774, -122.490247450243) | ||||
172328 | 172328 | 119945 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 30th Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 6ft | 5986569.07074 | 2113183.43269 | 37.7816224647501 | -122.490137005951 | (37.7816224647501, -122.490137005951) | |||
124223 | 124223 | 99344 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 30th Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 8 | 3x3 | 5986571.83486 | 2113111.88593 | 37.781426179231204 | -122.49012217925899 | (37.7814261792312, -122.490122179259) | ||
85197 | 85197 | 99341 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 30th Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 24 | 4x5 | 5986573.71046 | 2113038.86406 | 37.7812257915862 | -122.49011031791001 | (37.7812257915862, -122.49011031791) | ||
107292 | 107292 | 99342 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 30th Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 8 | 3x3 | 5986574.23671 | 2113063.60704 | 37.7812937594666 | -122.49011031789301 | (37.7812937594666, -122.490110317893) | ||
95801 | 95801 | 99340 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 30th Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 30 | 6x8 | 5986575.04866 | 2113011.09375 | 37.7811496204005 | -122.49010364520299 | (37.7811496204005, -122.490103645203) | ||
91017 | 91017 | 99338 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 30th Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4 | 3X3 | 5986576.26956 | 2112967.74794 | 37.7810306764919 | -122.490096232309 | (37.7810306764919, -122.490096232309) | ||
86659 | 86659 | 99336 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 30th Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 5986577.60051 | 2112919.49158 | 37.7808982560395 | -122.490088077428 | (37.7808982560395, -122.490088077428) | ||
109890 | 109890 | 99334 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 30th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4 | 3x3 | 5986579.77919 | 2112870.79018 | 37.780764663134896 | -122.49007695716298 | (37.7807646631349, -122.490076957163) | ||
82909 | 82909 | 95459 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 657X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 18 | 3x3 | 5986588.2 | 2111449.2 | 37.776861872872 | -122.48994323847201 | (37.776861872872, -122.489943238472) | ||
74498 | 74498 | 182755 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1778 31st Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 5986605.2662 | 2103150.8832 | 37.7540779977586 | -122.489273926281 | (37.7540779977586, -122.489273926281) | |||
62011 | 62011 | 182756 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1770 31st Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5986605.7278 | 2103174.4256 | 37.7541426657227 | -122.489274060805 | (37.7541426657227, -122.489274060805) | |||
127052 | 127052 | 115699 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2840 LAKE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 5986626.0 | 2114487.0 | 37.785205010982 | -122.49003597043699 | (37.785205010982, -122.490035970437) | ||||
127375 | 127375 | 115701 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2840 LAKE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 5986626.0 | 2114487.0 | 37.785205010982 | -122.49003597043699 | (37.785205010982, -122.490035970437) | ||||
139495 | 139495 | 115700 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2840 LAKE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 5986626.0 | 2114487.0 | 37.785205010982 | -122.49003597043699 | (37.785205010982, -122.490035970437) | ||||
77642 | 77642 | 120125 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 620 El Camino Del Mar | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5986678.0 | 2115081.0 | 37.786839000237705 | -122.489899771602 | (37.7868390002377, -122.489899771602) | ||||
88791 | 88791 | 120126 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 620 El Camino Del Mar | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5986678.0 | 2115081.0 | 37.786839000237705 | -122.489899771602 | (37.7868390002377, -122.489899771602) | ||||
104796 | 104796 | 120124 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 620 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5986678.0 | 2115081.0 | 37.786839000237705 | -122.489899771602 | (37.7868390002377, -122.489899771602) | ||||
109515 | 109515 | 120127 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 620 El Camino Del Mar | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5986678.0 | 2115081.0 | 37.786839000237705 | -122.489899771602 | (37.7868390002377, -122.489899771602) | ||||
80498 | 80498 | 115704 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2820 LAKE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 5986689.0 | 2114483.0 | 37.7851977068092 | -122.489817718558 | (37.7851977068092, -122.489817718558) | ||||
118123 | 118123 | 107815 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 311 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 5986808.71714 | 2113837.73031 | 37.7834329707826 | -122.489356078034 | (37.7834329707826, -122.489356078034) | |||
46760 | 46760 | 120018 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 333 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 5986813.0635400005 | 2113669.74125 | 37.782971974652604 | -122.48932868568701 | (37.7829719746526, -122.489328685687) | |||
64736 | 64736 | 120017 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 343 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5986815.03872 | 2113631.20342 | 37.7828662761015 | -122.48931901802 | (37.7828662761015, -122.48931901802) | |||
184572 | 184572 | 119961 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 4ft | 5987197.92043 | 2112907.45085 | 37.780901400579296 | -122.48794122965299 | (37.7809014005793, -122.487941229653) | |||
96580 | 96580 | 43346 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 5200 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2000 12:00:00 AM | Permit Number 43101 | 5987278.98724374 | 2109843.31804433 | 37.772492884784896 | -122.487435636536 | (37.7724928847849, -122.487435636536) | |||
106000 | 106000 | 43348 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 5200 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2000 12:00:00 AM | Permit Number 43101 | 5987278.98724374 | 2109843.31804433 | 37.772492884784896 | -122.487435636536 | (37.7724928847849, -122.487435636536) | |||
142204 | 142204 | 43347 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 5200 Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2000 12:00:00 AM | Permit Number 43101 | 5987278.98724374 | 2109843.31804433 | 37.772492884784896 | -122.487435636536 | (37.7724928847849, -122.487435636536) | |||
173634 | 173634 | 68443 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1274 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1993 12:00:00 AM | 26 | 7.5x7.5 | Permit Number 32300 | 5987418.73686806 | 2106612.65804585 | 37.7636305377833 | -122.486714964872 | (37.7636305377833, -122.486714964872) | |
124518 | 124518 | 65689 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 3601 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/1990 12:00:00 AM | 15 | 4x3 | Permit Number 28615 | 5987420.04323 | 2111837.39532 | 37.7779762857803 | -122.487094195586 | (37.7779762857803, -122.487094195586) | |
169338 | 169338 | 120058 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 132 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 37 | Width 4ft | 5987428.81431 | 2115064.18199 | 37.7868366349011 | -122.48730092667401 | (37.7868366349011, -122.487300926674) | |||
50964 | 50964 | 120056 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 142 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5987429.57525 | 2114999.01583 | 37.786657751693504 | -122.487293505702 | (37.7866577516935, -122.487293505702) | |||
172929 | 172929 | 120057 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 142 27th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 31 | Width 4ft | 5987429.900230001 | 2115014.31734 | 37.786699784202106 | -122.48729350569799 | (37.7866997842021, -122.487293505698) | |||
182229 | 182229 | 106951 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 156 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2014 12:00:00 AM | 22 | 3x3 | Permit Number 773389 | 5987431.57269 | 2114958.38797 | 37.7865463157209 | -122.487283609867 | (37.7865463157209, -122.487283609867) | |
180044 | 180044 | 120055 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 146 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 5ft | 5987431.73679 | 2114982.94917 | 37.786613763301794 | -122.48728484684099 | (37.7866137633018, -122.487284846841) | |||
54007 | 54007 | 120053 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 158 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 4ft | 5987432.117819999 | 2114926.05688 | 37.786457575606896 | -122.487279348253 | (37.7864575756069, -122.487279348253) | |||
52932 | 52932 | 120054 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 158 27th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5987432.2307 | 2114943.781 | 37.786506247541 | -122.48728026005301 | (37.786506247541, -122.487280260053) | |||
173894 | 173894 | 119976 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 790 27th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 6ft | 5987592.781909999 | 2110583.46178 | 37.774543407501895 | -122.48640455355302 | (37.7745434075019, -122.486404553553) | |||
104120 | 104120 | 121412 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2548 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 5987616.0 | 2110573.0 | 37.774516035705204 | -122.486323470467 | (37.7745160357052, -122.486323470467) | |||
47380 | 47380 | 119985 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2512 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | Width 5ft | 5987666.80033 | 2110540.3031900004 | 37.7744292202448 | -122.48614534379699 | (37.7744292202448, -122.486145343797) | |||
62014 | 62014 | 120074 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 135 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 29 | Width 4ft | 5987695.47672 | 2115079.1685 | 37.786893330275795 | -122.486379449256 | (37.7868933302758, -122.486379449256) | |||
29848 | 29848 | 120075 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 135 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5987696.4529800005 | 2115057.7870099996 | 37.7868346797306 | -122.486374501304 | (37.7868346797306, -122.486374501304) | |||
40131 | 40131 | 102733 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 227 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 6x12 | 5987865.555930001 | 2115301.49013 | 37.78751367389071 | -122.48580734547899 | (37.7875136738907, -122.485807345479) | |||
181706 | 181706 | 120384 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 221 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5987878.79334 | 2115302.0322 | 37.7875159336053 | -122.48576158708201 | (37.7875159336053, -122.485761587082) | |||
130111 | 130111 | 120382 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 209 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5987947.25387 | 2115304.7445400003 | 37.787527369834706 | -122.48552492951599 | (37.7875273698347, -122.485524929516) | |||
129919 | 129919 | 120222 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 250 25th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 3ft | 5988081.00935 | 2114311.02027 | 37.7848066783881 | -122.48498923446199 | (37.7848066783881, -122.484989234462) | |||
34270 | 34270 | 120223 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 250 25th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5988081.34041 | 2114326.62635 | 37.7848495475274 | -122.48498923447201 | (37.7848495475274, -122.484989234472) | |||
180393 | 180393 | 120221 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 250 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 5988083.13088 | 2114289.3007900002 | 37.7847471664462 | -122.48498030073401 | (37.7847471664462, -122.484980300734) | |||
30465 | 30465 | 182811 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1808 26th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 0ft | 5988164.7245 | 2103004.1689 | 37.753766066392394 | -122.483870250853 | (37.7537660663924, -122.483870250853) | |||
62441 | 62441 | 182809 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1812 26th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5988165.2943 | 2102980.2378 | 37.7537003911945 | -122.48386652576401 | (37.7537003911945, -122.483866525764) | |||
43353 | 43353 | 182810 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1810 26th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 5988165.8641 | 2102992.2034 | 37.7537332786865 | -122.483865432602 | (37.7537332786865, -122.483865432602) | |||
175176 | 175176 | 182808 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1814 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5988165.8641 | 2102960.2953 | 37.7536456676195 | -122.48386309312201 | (37.7536456676195, -122.483863093122) | |||
144019 | 144019 | 30320 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 867 25th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/13/1955 12:00:00 AM | Permit Number 14 | 5988182.28713273 | 2110079.61323567 | 37.773194323540004 | -122.484328404455 | (37.77319432354, -122.484328404455) | |||
37593 | 37593 | 182806 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1851 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5988216.5752 | 2103026.3907 | 37.7538300998005 | -122.48369257066601 | (37.7538300998005, -122.483692570666) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");