trees
3,587 rows where qSpecies_id = 28 sorted by PlotSize
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
79 | 121399 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 349X Cargo Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | |||||||||||||||
100 | 255131 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 9 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
2050 | 50805 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1498 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/2004 12:00:00 AM | Permit Number 47329 | 6000596.76427703 | 2111027.41746177 | 37.7765117981927 | -122.441453229456 | (37.7765117981927, -122.441453229456) | 15 | 5 | 11 | 29492 | 41 | |||
2152 | 33675 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 469 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/03/1996 12:00:00 AM | 13 | Permit Number 37757 | 6005116.23557125 | 2111084.96150687 | 37.7769262359606 | -122.425823168919 | (37.7769262359606, -122.425823168919) | 7 | 9 | 11 | 28852 | 10 | |
2868 | 255125 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 3 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
3319 | 255128 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 6 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
3865 | 105892 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1100 Masonic Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999444.5 | 2109060.1 | 37.7710443339737 | -122.445297745357 | (37.7710443339737, -122.445297745357) | 15 | 5 | 11 | 29492 | 9 | |||||
4157 | 52083 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 770 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2005 12:00:00 AM | Permit Number 48281 | 6010080.56543171 | 2116389.03640526 | 37.7917692527785 | -122.409024297587 | (37.7917692527785, -122.409024297587) | 5 | 1 | 10 | 28857 | 21 | |||
4413 | 106528 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2100 Baker St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | 5999888.51189 | 2116174.57366 | 37.7906041834903 | -122.444273238422 | (37.7906041834903, -122.444273238422) | 13 | 6 | 1 | 29490 | 27 | ||||
5059 | 255129 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 7 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
5129 | 255126 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 4 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
5273 | 218292 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1 Woodacre Dr | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 39 | 5991223.38049 | 2095418.74528 | 37.7331160279643 | -122.472739784911 | (37.7331160279643, -122.472739784911) | 1 | 8 | 4 | 64 | 40 | ||||
5510 | 104813 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1601X Portola Dr | 5 | Front Yard : Yard | Tree | Private 2 | |||||||||||||||
5631 | 50066 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 406 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46794 | 6003569.14495563 | 2105912.6827965 | 37.7626368713078 | -122.430805824209 | (37.7626368713078, -122.430805824209) | 15 | 4 | 5 | 28862 | 3 | ||
5844 | 99991 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Clay Montgomery St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44594 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | ||||
6176 | 217849 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1 Woodacre Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 33 | 5991387.06493 | 2095679.62189 | 37.7338418033391 | -122.47219289908 | (37.7338418033391, -122.47219289908) | 1 | 8 | 4 | 64 | 40 | ||||
6425 | 102410 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 55X Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000310.8 | 2109142 | 37.7713186232103 | -122.442307075209 | (37.7713186232103, -122.442307075209) | 15 | 5 | 11 | 29492 | 9 | |||||
6473 | 48743 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
6987 | 249466 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 900x Van Ness Ave | 4 | Median : Yard | Tree | DPW 1 | 25 | 6006522.49711 | 2113836.87509 | 37.7845616899264 | -122.421153924138 | (37.7845616899264, -122.421153924138) | 7 | 9 | 11 | 28858 | 36 | ||||
7358 | 108758 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1449 PAGE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999638.3 | 2109087.9 | 37.7711317264146 | -122.444629385712 | (37.7711317264146, -122.444629385712) | 15 | 5 | 11 | 29492 | 9 | |||||
7374 | 48751 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
8604 | 48746 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
8612 | 255133 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 11 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
8634 | 176044 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Font Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | 5990534.22824 | 2089263.30634 | 37.7161748133009 | -122.474673246391 | (37.7161748133009, -122.474673246391) | 1 | 8 | 4 | 64 | 14 | ||||
8893 | 50823 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/2004 12:00:00 AM | Permit Number 47344 | ||||||||||||||
9073 | 205507 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1518 05th Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 24 | 5994641.65352 | 2105137.30281 | 37.7599980266194 | -122.46162636506 | (37.7599980266194, -122.46162636506) | 15 | 5 | 4 | 56 | 12 | ||||
9226 | 99970 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2270 Folsom St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007986.9 | 2105322.2 | 37.7612648499102 | -122.415484545241 | (37.7612648499102, -122.415484545241) | 2 | 4 | 7 | 28859 | 19 | |||||
9839 | 48748 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
9847 | 248795 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 5175 Diamond Heights Blvd | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6000777.48804 | 2099988.6184 | 37.7462122622804 | -122.440036333505 | (37.7462122622804, -122.440036333505) | 2 | 4 | 5 | 63 | 22 | ||||
10173 | 48744 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
10238 | 255130 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 8 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
10360 | 30354 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1956 12:00:00 AM | Permit Number 43 | ||||||||||||||
10613 | 56603 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 4199@43rd Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 5982724.27515302 | 2106932.91664164 | 37.7642350821119 | -122.502975078628 | (37.7642350821119, -122.502975078628) | 1 | 8 | 3 | 56 | 35 | ||||
10635 | 255127 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 5 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
10661 | 114250 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 131 FONT BLVD | 1 | Front Yard : Yard | Tree | Private 2 | 36 | 5990844 | 2088883 | 37.7151485301311 | -122.473574812248 | (37.7151485301311, -122.473574812248) | 1 | 8 | 4 | 64 | 14 | ||||
10872 | 33492 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 25 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1996 12:00:00 AM | Permit Number 37604 | 6007009.01726732 | 2099597.28801828 | 37.7454905378147 | -122.418460683772 | (37.7454905378147, -122.418460683772) | 2 | 7 | 7 | 28859 | 2 | ||
11184 | 56634 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1917 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | 6001626.77222134 | 2112852.27703888 | 37.7815810267112 | -122.438020890084 | (37.7815810267112, -122.438020890084) | 15 | 5 | 11 | 29490 | 41 | ||||
11935 | 50824 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/2004 12:00:00 AM | Permit Number 47344 | ||||||||||||||
12040 | 48742 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
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 | ||||
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 | ||||
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 | |||||
12785 | 48747 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
12883 | 255123 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
13608 | 70503 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 193 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6004252.47977 | 2092436.67804 | 37.7256735552654 | -122.427482323859 | (37.7256735552654, -122.427482323859) | 9 | 7 | 6 | 28861 | 5 | |||
15071 | 48749 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
15264 | 2135 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1100X Bosworth St | 24 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 24 | 6001043.628513 | 2095761.867481 | 37.7346217448773 | -122.438813219285 | (37.7346217448773, -122.438813219285) | 2 | 7 | 5 | 63 | 7 | ||||
15641 | 48745 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
15846 | 75161 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1500X Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 6005585.43876 | 2119632.07302 | 37.8004209769936 | -122.42480825631 | (37.8004209769936, -122.42480825631) | 13 | 9 | 1 | 57 | 17 | |||
15919 | 94903 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3701 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 5997033.01745 | 2115334.97967 | 37.7881355570475 | -122.454092366574 | (37.7881355570475, -122.454092366574) | 11 | 6 | 1 | 54 | 31 | ||||
16008 | 212124 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300x Miramar Ave | 6 | Median : Yard | Tree | DPW 1 | 5 | 5995365.62659 | 2092320.18392 | 37.7248470432517 | -122.45819484442 | (37.7248470432517, -122.45819484442) | 9 | 7 | 4 | 28861 | 40 | ||||
17595 | 255124 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
18302 | 33467 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 72 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1996 12:00:00 AM | Permit Number 37623 | 6006783.56593714 | 2099291.50343979 | 37.7446382277934 | -122.419218573599 | (37.7446382277934, -122.419218573599) | 2 | 7 | 7 | 28859 | 2 | ||
18469 | 61073 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2638 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/01/1983 12:00:00 AM | 20 | Permit Number 20909 | 5999566.78827199 | 2113662.02579548 | 37.78368702296 | -122.445205661056 | (37.78368702296, -122.445205661056) | 15 | 6 | 11 | 29490 | 31 | |
18540 | 48750 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
18822 | 65766 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1937 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1990 12:00:00 AM | 15 | Permit Number 28729 | 6003642.45675 | 2118972.66599 | 37.7985004828598 | -122.431484647806 | (37.7985004828598, -122.431484647806) | 13 | 9 | 1 | 57 | 17 | |
18977 | 97306 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 47 Kittredge Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5997949.8 | 2111441.7 | 37.7774981585608 | -122.450639669067 | (37.7774981585608, -122.450639669067) | 15 | 6 | 2 | 54 | 16 | |||||
19147 | 255132 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 10 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
20003 | 99987 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 535@Clay Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012018 | 2117734 | 37.7955705425922 | -122.402415352518 | (37.7955705425922, -122.402415352518) | 3 | 1 | 10 | 28860 | 4 | |||||
20704 | 2136 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1100X Bosworth St | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6001043.628513 | 2095761.867481 | 37.7346217448773 | -122.438813219285 | (37.7346217448773, -122.438813219285) | 2 | 7 | 5 | 63 | 7 | ||||
20880 | 99966 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2270 Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007986.9 | 2105322.2 | 37.7612648499102 | -122.415484545241 | (37.7612648499102, -122.415484545241) | 2 | 4 | 7 | 28859 | 19 | |||||
20912 | 24331 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 601X Golden Gate Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6006691.6523257 | 2112520.4868544 | 37.7809567435024 | -122.420475231256 | (37.7809567435024, -122.420475231256) | 7 | 9 | 9 | 28852 | 36 | ||||
21900 | 176048 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 5989010.93647 | 2089619.81285 | 37.7170653066825 | -122.479964486788 | (37.7170653066825, -122.479964486788) | 1 | 8 | 4 | 64 | 14 | ||||
22660 | 33533 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 185 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37643 | 6007275.34853053 | 2097937.54990535 | 37.7409482571652 | -122.417422147014 | (37.7409482571652, -122.417422147014) | 2 | 7 | 7 | 28859 | 2 | |||
23585 | 2101 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000X Bosworth St | 9 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 04/09/1990 12:00:00 AM | 14 | 6001184.3961353 | 2095706.3375319 | 37.7344772801388 | -122.438322562248 | (37.7344772801388, -122.438322562248) | 9 | 7 | 5 | 63 | 7 | |||
24024 | 54655 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 280 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1972 12:00:00 AM | 18 | Permit Number 10479 | 6012382.77536 | 2087271.8623 | 37.7119485104815 | -122.399014002112 | (37.7119485104815, -122.399014002112) | 10 | 3 | 8 | 309 | 1 | ||
24111 | 2116 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1100X Bosworth St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6001043.628513 | 2095761.867481 | 37.7346217448773 | -122.438813219285 | (37.7346217448773, -122.438813219285) | 2 | 7 | 5 | 63 | 7 | ||||
24372 | 212187 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 720 Bosworth St | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 16 | 6002096.28779 | 2095466.30888 | 37.733870041163 | -122.435152693763 | (37.733870041163, -122.435152693763) | 2 | 7 | 5 | 63 | 7 | ||||
24640 | 176024 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 26 Ervine St | 3 | Front Yard : Yard | Tree | Private 2 | 25 | 6009648.36238 | 2089313.42999 | 37.7174014822691 | -122.40860887622 | (37.7174014822691, -122.40860887622) | 9 | 7 | 8 | 309 | 18 | ||||
24682 | 50574 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2295 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/2003 12:00:00 AM | Permit Number 47188 | 6008194 | 2105070 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | 2 | 4 | 7 | 28859 | 19 | ||
24768 | 50314 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1055 Ellis St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | Permit Number 47021 | 6005825.34130744 | 2113438.50468071 | 37.7834285368624 | -122.42353751819 | (37.7834285368624, -122.42353751819) | 7 | 9 | 11 | 28858 | 41 | |||
24910 | 50685 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 915 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47258 | 5999168.89515798 | 2107036.01925898 | 37.7654709832109 | -122.446105453704 | (37.7654709832109, -122.446105453704) | 15 | 5 | 11 | 29492 | 9 | ||||
25023 | 176021 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 26 Ervine St | 8 | Front Yard : Yard | Tree | Private 2 | 5 | 6009620.69504 | 2089243.53702 | 37.7172080210075 | -122.408699581837 | (37.7172080210075, -122.408699581837) | 9 | 7 | 8 | 309 | 18 | ||||
25471 | 2132 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1100X Bosworth St | 21 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 0 | 6001043.628513 | 2095761.867481 | 37.7346217448773 | -122.438813219285 | (37.7346217448773, -122.438813219285) | 2 | 7 | 5 | 63 | 7 | ||||
25604 | 99496 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Plymouth Ave | 3 | Median : Cutout | Tree | Private 2 | 5995903 | 2093347.3 | 37.7276981218086 | -122.45641145576 | (37.7276981218086, -122.45641145576) | 9 | 7 | 4 | 28861 | 40 | |||||
25628 | 100017 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 6011791.69231 | 2117640.10072 | 37.7953000816886 | -122.403191812578 | (37.7953000816886, -122.403191812578) | 3 | 1 | 10 | 28860 | 4 | ||||
25886 | 126275 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2836 Larkin St | 7 | Side Yard : Yard | Tree | Private 2 | 26 | 6006511.2494 | 2120976.42855 | 37.8041644823576 | -122.421700114785 | (37.8041644823576, -122.421700114785) | 5 | 9 | 1 | 28858 | 32 | ||||
26412 | 34885 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1539 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38493 | 6002855.27225509 | 2121286.11305956 | 37.8048079563004 | -122.434374036967 | (37.8048079563004, -122.434374036967) | 13 | 9 | 1 | 57 | 17 | ||||
26452 | 249722 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2500 Broderick St | 6 | Front Yard : Yard | Tree | Private 2 | 14 | 6000190.26691 | 2117349.57001 | 37.7938476262185 | -122.443313617731 | (37.7938476262185, -122.443313617731) | 13 | 9 | 1 | 57 | 27 | ||||
26881 | 97635 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1254 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008163 | 2117572 | 37.7949097746331 | -122.415742887246 | (37.7949097746331, -122.415742887246) | 5 | 1 | 10 | 28858 | 21 | |||||
28699 | 40132 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 697 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/1999 12:00:00 AM | Permit Number 41337 | 6008515.22056385 | 2095655.65791493 | 37.7347523629036 | -122.412973810281 | (37.7347523629036, -122.412973810281) | 10 | 7 | 7 | 28859 | 2 | |||
28914 | 24330 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 601X Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6006691.6523257 | 2112520.4868544 | 37.7809567435024 | -122.420475231256 | (37.7809567435024, -122.420475231256) | 7 | 9 | 9 | 28852 | 36 | ||||
29045 | 54788 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 266 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1972 12:00:00 AM | 17 | Permit Number 10637 | 6012648.47164 | 2087248.62221 | 37.7118995001448 | -122.398094045129 | (37.7118995001448, -122.398094045129) | 10 | 3 | 8 | 309 | 1 | ||
29377 | 114412 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1345 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6008898.23064 | 2117525.75314 | 37.7948240957174 | -122.413195602999 | (37.7948240957174, -122.413195602999) | 5 | 1 | 10 | 28857 | 21 | ||||
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 | ||
29506 | 33680 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 419 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | 13 | Permit Number 37760 | 6005344.46198727 | 2111116.85391927 | 37.7770266994083 | -122.425035932953 | (37.7770266994083, -122.425035932953) | 7 | 9 | 11 | 28852 | 10 | ||
29605 | 217817 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1x Junipero Serra Blvd | 4 | Median : Yard | Tree | DPW 1 | 27 | 5991627.99201 | 2095776.79312 | 37.7341225510202 | -122.47136702736 | (37.7341225510202, -122.47136702736) | 1 | 8 | 4 | 59 | 40 | ||||
29844 | 53048 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 65@ APPLETON Gladys St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/2006 12:00:00 AM | Permit Number 49026 | 6005683.68607987 | 2097324.15915168 | 37.7391743410359 | -122.422881952522 | (37.7391743410359, -122.422881952522) | 2 | 7 | 7 | 28859 | 2 | |||
29882 | 100026 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
30818 | 2115 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1100X Bosworth St | 4 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 18 | 6001043.628513 | 2095761.867481 | 37.7346217448773 | -122.438813219285 | (37.7346217448773, -122.438813219285) | 2 | 7 | 5 | 63 | 7 | ||||
31243 | 212222 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1120 Bosworth St | 15 | Sidewalk: Property side : Yard | Tree | DPW 1 | 10/13/2014 11:02:00 AM | 16 | 6000900.61271 | 2095850.79313 | 37.7348577764545 | -122.439314043907 | (37.7348577764545, -122.439314043907) | 2 | 7 | 5 | 63 | 7 | |||
32152 | 56296 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 153 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1973 12:00:00 AM | 19 | Permit Number 12428 | 5993949.48549 | 2114460.3201 | 37.7855566873358 | -122.464697232751 | (37.7855566873358, -122.464697232751) | 11 | 6 | 2 | 54 | 11 | ||
32983 | 38841 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1817 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 40670 | 6005665.65244341 | 2115853.93139831 | 37.7900516844756 | -122.42426182602 | (37.7900516844756, -122.42426182602) | 13 | 9 | 1 | 28858 | 41 | ||||
33171 | 33502 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 155 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1996 12:00:00 AM | Permit Number 37596 | 6006575.63931047 | 2098797.68147059 | 37.7432705917121 | -122.419902509091 | (37.7432705917121, -122.419902509091) | 2 | 7 | 7 | 28859 | 2 | ||
33180 | 37143 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2155 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Permit Number 39724 | 6003778.52248 | 2115919.83113 | 37.7901258907459 | -122.430795841768 | (37.7901258907459, -122.430795841768) | 13 | 9 | 1 | 29490 | 27 | |||
33339 | 100023 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
33433 | 104433 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1601X PORTOLA DR | 2 | Front Yard : Yard | Tree | Private 2 | 16 | 5991823 | 2096240 | 37.7354056792703 | -122.47072655808 | (37.7354056792703, -122.47072655808) | 1 | 8 | 4 | 59 | 40 | ||||
33512 | 212209 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 920 Bosworth St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6001437.10561 | 2095636.37062 | 37.7342995375914 | -122.437443855175 | (37.7342995375914, -122.437443855175) | 9 | 7 | 5 | 63 | 7 | ||||
34008 | 32073 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3254 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Permit Number 35447 | 5999189.55674 | 2115674.61094 | 37.7891915158244 | -122.446655586587 | (37.7891915158244, -122.446655586587) | 13 | 6 | 1 | 29490 | 31 | |||
34555 | 33952 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1 Arbor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/1997 12:00:00 AM | Permit Number 37910 | 6002287.3237241 | 2097040.91143479 | 37.7382043832783 | -122.434604778209 | (37.7382043832783, -122.434604778209) | 2 | 7 | 5 | 63 | 7 |
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) );