trees
3,587 rows where qSpecies_id = 28 sorted by YCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
106813 | 29637 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1110X Junipero Serra Blvd | 10 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991107.8990451 | 2089843.5367701 | 37.717801208369 | -122.47273266668 | (37.717801208369, -122.47273266668) | 9 | 8 | 4 | 64 | 40 | ||
115965 | 29628 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1110X Junipero Serra Blvd | 1 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991107.8990451 | 2089843.5367701 | 37.717801208369 | -122.47273266668 | (37.717801208369, -122.47273266668) | 9 | 8 | 4 | 64 | 40 | ||
123602 | 29638 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1110X Junipero Serra Blvd | 11 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991107.8990451 | 2089843.5367701 | 37.717801208369 | -122.47273266668 | (37.717801208369, -122.47273266668) | 9 | 8 | 4 | 64 | 40 | ||
180304 | 29634 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1110X Junipero Serra Blvd | 7 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991107.8990451 | 2089843.5367701 | 37.717801208369 | -122.47273266668 | (37.717801208369, -122.47273266668) | 9 | 8 | 4 | 64 | 40 | ||
188989 | 29630 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1110X Junipero Serra Blvd | 3 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991107.8990451 | 2089843.5367701 | 37.717801208369 | -122.47273266668 | (37.717801208369, -122.47273266668) | 9 | 8 | 4 | 64 | 40 | ||
192410 | 29633 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1110X Junipero Serra Blvd | 6 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991107.8990451 | 2089843.5367701 | 37.717801208369 | -122.47273266668 | (37.717801208369, -122.47273266668) | 9 | 8 | 4 | 64 | 40 | ||
162570 | 212293 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 3 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 5991165.05081 | 2089858.71083 | 37.7178461808423 | -122.472536226064 | (37.7178461808423, -122.472536226064) | 9 | 8 | 4 | 64 | 24 | |||
136840 | 212294 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 4 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 5991166.95703 | 2089883.01903 | 37.7179130355286 | -122.472531408396 | (37.7179130355286, -122.472531408396) | 9 | 8 | 4 | 64 | 24 | |||
190136 | 212295 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 6 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 5991170.53267 | 2089939.68134 | 37.7180688232854 | -122.472523177809 | (37.7180688232854, -122.472523177809) | 9 | 8 | 4 | 64 | 24 | |||
185763 | 206307 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 10 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 5994456.80406 | 2089957.2483 | 37.7183067254442 | -122.461165314131 | (37.7183067254442, -122.461165314131) | 9 | 8 | 6 | 28861 | 24 | |||
76564 | 176016 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 700x Mansell St | 30 | Median : Cutout | Tree | DPW 1 | 31 | Width 0ft | 6009216.97292 | 2089964.58671 | 37.7191652533595 | -122.410145941702 | (37.7191652533595, -122.410145941702) | 9 | 3 | 8 | 309 | 18 | |||
151461 | 212296 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 10 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 5991176.06439 | 2090044.25898 | 37.7183562879852 | -122.472511677268 | (37.7183562879852, -122.472511677268) | 9 | 8 | 4 | 64 | 24 | |||
99599 | 212250 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1025 Junipero Serra Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5991227.31888 | 2090046.52791 | 37.7183654844581 | -122.472334679022 | (37.7183654844581, -122.472334679022) | 9 | 8 | 6 | 64 | 24 | |||
79244 | 212297 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 11 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 5991177.82743 | 2090064.76298 | 37.7184126889791 | -122.47250707726 | (37.7184126889791, -122.47250707726) | 9 | 8 | 4 | 64 | 24 | |||
26505 | 212298 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 12 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 5991179.12071 | 2090094.55389 | 37.7184945623549 | -122.472504777687 | (37.7184945623549, -122.472504777687) | 9 | 8 | 4 | 64 | 24 | |||
110440 | 176058 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Crespi Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | 5989854.78687 | 2090110.33741 | 37.7184611570226 | -122.477083556286 | (37.7184611570226, -122.477083556286) | 1 | 8 | 4 | 64 | 14 | ||||
82165 | 212251 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1025 Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 5991235.14412 | 2090150.01992 | 37.7186501009917 | -122.472315170917 | (37.7186501009917, -122.472315170917) | 9 | 8 | 6 | 64 | 24 | |||
126423 | 212299 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 14 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 5991184.2984 | 2090150.76712 | 37.7186492097602 | -122.472490976674 | (37.7186492097602, -122.472490976674) | 9 | 8 | 4 | 64 | 24 | |||
124755 | 17603 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 918 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 6003916.62917 | 2090182.06037 | 37.7194638711075 | -122.428482700528 | (37.7194638711075, -122.428482700528) | 9 | 7 | 6 | 28861 | 5 | |||
116391 | 212252 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1025 Junipero Serra Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5991236.45499 | 2090182.46315 | 37.7187392579978 | -122.472313003567 | (37.7187392579978, -122.472313003567) | 9 | 8 | 6 | 64 | 24 | |||
140919 | 175997 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 918 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 3ft | 6003927.76143 | 2090183.89548 | 37.719469539881 | -122.428444351129 | (37.719469539881, -122.428444351129) | 9 | 7 | 6 | 28861 | 5 | |||
158682 | 212300 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 16 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 5991186.31185 | 2090192.49351 | 37.7187638967107 | -122.472487057435 | (37.7187638967107, -122.472487057435) | 9 | 8 | 4 | 64 | 24 | |||
188138 | 212301 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 17 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 5991188.84719 | 2090215.08791 | 37.7188260821255 | -122.472479940192 | (37.7188260821255, -122.472479940192) | 9 | 8 | 4 | 64 | 24 | |||
102634 | 176015 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600x Mansell St | 1 | Median : Cutout | Tree | DPW 1 | 16 | Width 0ft | 6010073.53174 | 2090236.70222 | 37.7199604006417 | -122.407204302454 | (37.7199604006417, -122.407204302454) | 10 | 3 | 8 | 309 | 18 | |||
134716 | 212302 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 18 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 5991190.15994 | 2090239.43451 | 37.7188930078858 | -122.47247717658 | (37.7188930078858, -122.47247717658) | 9 | 8 | 4 | 64 | 24 | |||
97082 | 212253 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1025 Junipero Serra Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5991242.27652 | 2090250.40418 | 37.7189261442932 | -122.472297831092 | (37.7189261442932, -122.472297831092) | 9 | 8 | 6 | 64 | 24 | |||
12047 | 176041 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 420 Font Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 5989405 | 2090258 | 37.7188404967574 | -122.478649058693 | (37.7188404967574, -122.478649058693) | 1 | 8 | 4 | 64 | 14 | ||||
75104 | 212303 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 19 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 5991192.11842 | 2090269.21075 | 37.7189748794765 | -122.472472576576 | (37.7189748794765, -122.472472576576) | 9 | 8 | 4 | 64 | 24 | |||
113662 | 176042 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Font Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | 5989234.3289 | 2090278.89103 | 37.7188879474116 | -122.479240521736 | (37.7188879474116, -122.479240521736) | 1 | 8 | 4 | 64 | 14 | ||||
180254 | 212254 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1025 Junipero Serra Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5991244.17466 | 2090280.96155 | 37.7190101571753 | -122.472293496369 | (37.7190101571753, -122.472293496369) | 9 | 8 | 6 | 64 | 24 | |||
138333 | 212304 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 20 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 5991192.55124 | 2090289.74279 | 37.7190312804608 | -122.472472576553 | (37.7190312804608, -122.472472576553) | 9 | 8 | 4 | 64 | 24 | |||
63500 | 212305 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 21 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 5991194.3003 | 2090309.58448 | 37.7190858620976 | -122.472467976539 | (37.7190858620976, -122.472467976539) | 9 | 8 | 4 | 64 | 24 | |||
145666 | 212255 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1025 Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5991247.70808 | 2090329.59303 | 37.7191438917601 | -122.472284825992 | (37.7191438917601, -122.472284825992) | 9 | 8 | 6 | 64 | 24 | |||
40099 | 212306 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 22 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 5991196.13313 | 2090333.39999 | 37.7191513597144 | -122.472463376508 | (37.7191513597144, -122.472463376508) | 9 | 8 | 4 | 64 | 24 | |||
80166 | 212307 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 23 | Median : Cutout | Tree | DPW 1 | 12 | Width 0ft | 5991200.21272 | 2090369.09522 | 37.7192496061609 | -122.47245187595 | (37.7192496061609, -122.47245187595) | 9 | 8 | 4 | 64 | 24 | |||
85551 | 212308 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 24 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 5991201.47803 | 2090397.56088 | 37.7193278390954 | -122.472449576408 | (37.7193278390954, -122.472449576408) | 9 | 8 | 4 | 64 | 24 | |||
70865 | 176014 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500x Mansell St | 1 | Median : Cutout | Tree | DPW 1 | 45 | Width 0ft | 6010647.65151 | 2090407.87993 | 37.7204625334973 | -122.405231805915 | (37.7204625334973, -122.405231805915) | 10 | 3 | 8 | 309 | 28 | |||
163419 | 176043 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Font Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | 5989267.95492 | 2090414.23117 | 37.7192615104927 | -122.479134185915 | (37.7192615104927, -122.479134185915) | 1 | 8 | 4 | 64 | 14 | ||||
161552 | 212309 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 25 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 5991201.91083 | 2090418.09259 | 37.7193842391693 | -122.472449576413 | (37.7193842391693, -122.472449576413) | 9 | 8 | 4 | 64 | 24 | |||
33604 | 212310 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 26 | Median : Cutout | Tree | DPW 1 | 11 | Width 0ft | 5991202.25987 | 2090434.65049 | 37.7194297232904 | -122.472449576395 | (37.7194297232904, -122.472449576395) | 9 | 8 | 4 | 64 | 24 | |||
71343 | 30140 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 410X Mansell St | 2 | Median : Cutout | Tree | DPW 1 | 18 | M | 6010678.994322 | 2090457.626596 | 37.7206008798567 | -122.405126964413 | (37.7206008798567, -122.405126964413) | 10 | 3 | 7 | 309 | 28 | |||
73900 | 205076 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 27 | Median : Cutout | Tree | DPW 1 | 12 | Width 0ft | 5991204.86961 | 2090463.7504 | 37.7195097755318 | -122.472442675902 | (37.7195097755318, -122.472442675902) | 9 | 8 | 4 | 64 | 24 | |||
47173 | 176013 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300x Mansell St | 2 | Median : Cutout | Tree | DPW 1 | 32 | Width 0ft | 6010939.71676 | 2090487.4301 | 37.7206972862266 | -122.404227820771 | (37.7206972862266, -122.404227820771) | 10 | 7 | 7 | 309 | 28 | |||
47699 | 205077 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 28 | Median : Cutout | Tree | DPW 1 | 12 | Width 0ft | 5991206.77223 | 2090490.87743 | 37.7195843698014 | -122.472438075876 | (37.7195843698014, -122.472438075876) | 9 | 8 | 4 | 64 | 24 | |||
39739 | 176040 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Font Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | 5989182.35151 | 2090508.47222 | 37.7195153009692 | -122.479436972335 | (37.7195153009692, -122.479436972335) | 1 | 8 | 4 | 64 | 14 | ||||
134308 | 205078 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 29 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 5991207.21899 | 2090512.07145 | 37.7196425892212 | -122.472438075876 | (37.7196425892212, -122.472438075876) | 9 | 8 | 4 | 64 | 24 | |||
17286 | 24406 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 999X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/28/2000 12:00:00 AM | 6 | 3x3 | 5991260.9047733 | 2090529.2081036 | 37.7196927494004 | -122.472253753748 | (37.7196927494004, -122.472253753748) | 9 | 8 | 6 | 64 | 24 | ||
29397 | 24458 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 999X Junipero Serra Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 03/17/2001 12:00:00 AM | 6 | 3X3 | 5991260.9047733 | 2090529.2081036 | 37.7196927494004 | -122.472253753748 | (37.7196927494004, -122.472253753748) | 9 | 8 | 6 | 64 | 24 | ||
48230 | 11762 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 999X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 24 | 3X3 | 5991260.9047733 | 2090529.2081036 | 37.7196927494004 | -122.472253753748 | (37.7196927494004, -122.472253753748) | 9 | 8 | 6 | 64 | 24 | |||
99349 | 11760 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 999X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 24 | 3x3 | 5991260.9047733 | 2090529.2081036 | 37.7196927494004 | -122.472253753748 | (37.7196927494004, -122.472253753748) | 9 | 8 | 6 | 64 | 24 | |||
170020 | 24405 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 999X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/28/2000 12:00:00 AM | 12 | 3X3 | 5991260.9047733 | 2090529.2081036 | 37.7196927494004 | -122.472253753748 | (37.7196927494004, -122.472253753748) | 9 | 8 | 6 | 64 | 24 | ||
95983 | 205079 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 30 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 5991209.09369 | 2090537.87387 | 37.7197135448202 | -122.47243347583 | (37.7197135448202, -122.47243347583) | 9 | 8 | 4 | 64 | 24 | |||
78705 | 212256 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 951 Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 5991256.60801 | 2090543.58608 | 37.7197319791141 | -122.472269653524 | (37.7197319791141, -122.472269653524) | 9 | 8 | 6 | 64 | 24 | |||
144768 | 175995 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500 Geneva Ave | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 5ft | 5998981.8742 | 2090546.54145 | 37.7201841618528 | -122.44556646533 | (37.7201841618528, -122.44556646533) | 9 | 7 | 6 | 28861 | 25 | |||
63627 | 104944 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 532 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
66095 | 104946 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 532 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
74833 | 104951 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
86228 | 104945 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 532 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
125250 | 104950 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
149012 | 104952 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
193712 | 104914 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 614 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
161638 | 205080 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 31 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 5991211.60542 | 2090562.33735 | 37.7197808608892 | -122.47242657625 | (37.7197808608892, -122.47242657625) | 9 | 8 | 4 | 64 | 24 | |||
67772 | 175994 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500 Geneva Ave | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 5ft | 5998943.08892 | 2090567.95086 | 37.7202407328088 | -122.445702071408 | (37.7202407328088, -122.445702071408) | 9 | 7 | 6 | 28861 | 25 | |||
2519 | 175993 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500 Geneva Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 5ft | 5998911.6853 | 2090582.51768 | 37.7202789369116 | -122.445811669969 | (37.7202789369116, -122.445811669969) | 9 | 7 | 6 | 28861 | 25 | |||
29710 | 205081 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 32 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 5991210.7499 | 2090584.88401 | 37.7198427189488 | -122.472431176281 | (37.7198427189488, -122.472431176281) | 9 | 8 | 4 | 64 | 24 | |||
12565 | 104957 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 759 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | |||||
64576 | 104958 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 759 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | |||||
81822 | 104959 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 759 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | |||||
104508 | 104915 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 701 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | |||||
123860 | 104948 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 535 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | |||||
166348 | 104956 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 759 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | |||||
177371 | 104949 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 535 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | |||||
12920 | 175992 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500 Geneva Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 5ft | 5998869.40884 | 2090603.99979 | 37.7203355078481 | -122.445959349454 | (37.7203355078481, -122.445959349454) | 9 | 7 | 6 | 28861 | 25 | |||
5505 | 175991 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500 Geneva Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 5ft | 5998793.12652 | 2090644.11661 | 37.7204413031987 | -122.44622591569 | (37.7204413031987, -122.44622591569) | 9 | 7 | 6 | 28861 | 25 | |||
41526 | 175990 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500 Geneva Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 5ft | 5998767.87796 | 2090657.48521 | 37.7204765683114 | -122.446314152679 | (37.7204765683114, -122.446314152679) | 9 | 7 | 6 | 28861 | 25 | |||
85091 | 205082 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 34 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 5991216.27623 | 2090657.65451 | 37.7200428486756 | -122.472417376165 | (37.7200428486756, -122.472417376165) | 9 | 8 | 4 | 64 | 24 | |||
115829 | 175989 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500 Geneva Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 27 | Width 5ft | 5998751.66703 | 2090666.11711 | 37.7204993436547 | -122.446370809093 | (37.7204993436547, -122.446370809093) | 9 | 7 | 6 | 28861 | 25 | |||
159268 | 212257 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 951 Junipero Serra Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | Width 4ft | 5991265.70439 | 2090677.64642 | 37.7201006022469 | -122.472247978075 | (37.7201006022469, -122.472247978075) | 9 | 8 | 6 | 64 | 24 | |||
77599 | 205083 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 35 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 5991217.1837 | 2090700.70485 | 37.720161106826 | -122.472417376171 | (37.720161106826, -122.472417376171) | 9 | 8 | 4 | 64 | 24 | |||
93497 | 205084 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 36 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 5991220.51447 | 2090732.43963 | 37.7202484354919 | -122.472408175222 | (37.7202484354919, -122.472408175222) | 9 | 8 | 4 | 64 | 24 | |||
87400 | 212258 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 951 Junipero Serra Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5991271.42052 | 2090740.59287 | 37.720273768507 | -122.4722328056 | (37.720273768507, -122.4722328056) | 9 | 8 | 6 | 64 | 24 | |||
114571 | 29626 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 900X Junipero Serra Blvd | 35 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991174.60245 | 2090776.13532 | 37.7203657556648 | -122.472570060379 | (37.7203657556648, -122.472570060379) | 9 | 8 | 4 | 64 | 40 | ||
31250 | 212259 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 951 Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5991274.76967 | 2090780.48576 | 37.7203834983807 | -122.472224135259 | (37.7203834983807, -122.472224135259) | 9 | 8 | 6 | 64 | 24 | |||
142560 | 205085 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 38 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 5991225.77549 | 2090792.62573 | 37.720413996187 | -122.472394375116 | (37.720413996187, -122.472394375116) | 9 | 8 | 4 | 64 | 24 | |||
185411 | 205086 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 39 | Median : Cutout | Tree | DPW 1 | 12 | Width 0ft | 5991226.90116 | 2090814.46771 | 37.7204740340313 | -122.472392075543 | (37.7204740340313, -122.472392075543) | 9 | 8 | 4 | 64 | 24 | |||
80664 | 205087 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 40 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 5991229.32936 | 2090834.95737 | 37.7205304341251 | -122.472385175045 | (37.7205304341251, -122.472385175045) | 9 | 8 | 4 | 64 | 24 | |||
184304 | 212260 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 951 Junipero Serra Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5991277.37814 | 2090844.74627 | 37.7205600928662 | -122.472219800499 | (37.7205600928662, -122.472219800499) | 9 | 8 | 6 | 64 | 24 | |||
48819 | 205088 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 41 | Median : Cutout | Tree | DPW 1 | 11 | Width 0ft | 5991229.30633 | 2090865.43732 | 37.7206141232198 | -122.472387475503 | (37.7206141232198, -122.472387475503) | 9 | 8 | 4 | 64 | 24 | |||
118360 | 50633 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2900 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/2004 12:00:00 AM | 7 | Permit Number 47740 | 6014091.6306 | 2090874.9645 | 37.721936997211 | -122.393359654849 | (37.721936997211, -122.393359654849) | 10 | 3 | 8 | 58 | 1 | |
12051 | 106705 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 199X BRIGHTON AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 5996224 | 2090880 | 37.7209419254054 | -122.455123542447 | (37.7209419254054, -122.455123542447) | 9 | 8 | 6 | 28861 | 24 | ||||
158230 | 205089 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 42 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 5991231.16702 | 2090890.57712 | 37.7206832586037 | -122.472382875496 | (37.7206832586037, -122.472382875496) | 9 | 8 | 4 | 64 | 24 | |||
29446 | 50634 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2900 Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/2004 12:00:00 AM | Permit Number 47740 | 6014120.76360854 | 2090918.26429059 | 37.7220575083684 | -122.393261977074 | (37.7220575083684, -122.393261977074) | 10 | 3 | 8 | 58 | 1 | ||
102301 | 50635 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2900 Jennings St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/2004 12:00:00 AM | Permit Number 47740 | 6014120.76360854 | 2090918.26429059 | 37.7220575083684 | -122.393261977074 | (37.7220575083684, -122.393261977074) | 10 | 3 | 8 | 58 | 1 | ||
90111 | 205090 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 44 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 5991232.93514 | 2090942.88536 | 37.7208269864641 | -122.472380575028 | (37.7208269864641, -122.472380575028) | 9 | 8 | 4 | 64 | 24 | |||
152972 | 212261 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 951 Junipero Serra Blvd | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991287.20633 | 2090983.7854 | 37.7209424288218 | -122.472195957673 | (37.7209424288218, -122.472195957673) | 9 | 8 | 6 | 64 | 24 | |||
188250 | 212262 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 951 Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5991291.08137 | 2091048.64317 | 37.7211207365178 | -122.472187288206 | (37.7211207365178, -122.472187288206) | 9 | 8 | 6 | 64 | 24 | |||
51153 | 212263 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 951 Junipero Serra Blvd | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5991290.45934 | 2091078.6284 | 37.7212030325641 | -122.472191622967 | (37.7212030325641, -122.472191622967) | 9 | 8 | 6 | 64 | 24 | |||
51463 | 29599 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 900X Junipero Serra Blvd | 8 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991176.65606 | 2091094.6598 | 37.7212404641514 | -122.472586172621 | (37.7212404641514, -122.472586172621) | 9 | 8 | 4 | 64 | 40 | ||
35454 | 29603 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 910X Junipero Serra Blvd | 12 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991188.7321263 | 2091104.0152467 | 37.7212668508959 | -122.472545111236 | (37.7212668508959, -122.472545111236) | 9 | 8 | 4 | 64 | 40 | ||
59681 | 29605 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 910X Junipero Serra Blvd | 14 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991188.7321263 | 2091104.0152467 | 37.7212668508959 | -122.472545111236 | (37.7212668508959, -122.472545111236) | 9 | 8 | 4 | 64 | 40 |
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) );