trees
46 rows where Supervisor Districts = 8 and qSpecies_id = 69
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2089 | 190900 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 2 George Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/2020 12:00:00 AM | 3 | Width 3ft | 6017068 | 2094316 | 37.7315503232499 | -122.383310402707 | (37.7315503232499, -122.383310402707) | 10 | 3 | 8 | 58 | 1 | ||
| 5207 | 189580 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 1 Whitfield Ct | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 4ft | 6017495.38223 | 2094096.81457 | 37.7309720927908 | -122.381817604795 | (37.7309720927908, -122.381817604795) | 10 | 3 | 8 | 58 | 1 | |||
| 8557 | 190901 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 12 George Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 6017068 | 2094316 | 37.7315503232499 | -122.383310402707 | (37.7315503232499, -122.383310402707) | 10 | 3 | 8 | 58 | 1 | |||
| 10326 | 189567 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 1446 Osceola Ln | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6017153.83983 | 2094312.85865 | 37.7315464412118 | -122.38301341624 | (37.7315464412118, -122.38301341624) | 10 | 3 | 8 | 58 | 1 | |||
| 13329 | 189555 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 20 Osceola Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/2020 12:00:00 AM | 3 | Width 3ft | 6017285.51097 | 2094310.10807 | 37.7315461633241 | -122.382558007669 | (37.7315461633241, -122.382558007669) | 10 | 3 | 8 | 58 | 1 | ||
| 14881 | 189560 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 60 Osceola Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6017083.25232 | 2094424.68697 | 37.7318495990818 | -122.383265234517 | (37.7318495990818, -122.383265234517) | 10 | 3 | 8 | 58 | 1 | |||
| 15063 | 189530 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 1151 Carolina St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 8ft | 6012567.91248 | 2102567.63857 | 37.7539578523818 | -122.399447270278 | (37.7539578523818, -122.399447270278) | 10 | 3 | 8 | 28856 | 29 | |||
| 15332 | 189568 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 1446 Osceola Ln | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6017158.26847 | 2094319.33282 | 37.7315644627097 | -122.382998555836 | (37.7315644627097, -122.382998555836) | 10 | 3 | 8 | 58 | 1 | |||
| 16557 | 189576 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 1 Whitfield Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6017417.04317 | 2094105.80959 | 37.7309924651275 | -122.382089064271 | (37.7309924651275, -122.382089064271) | 10 | 3 | 8 | 58 | 1 | |||
| 25209 | 9281 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 2X George Ct | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6017254.34484 | 2094072.23029 | 37.7308912760903 | -122.382649209712 | (37.7308912760903, -122.382649209712) | 10 | 3 | 8 | 58 | 1 | |||
| 29240 | 189559 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 1445 Osceola Ln | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6017114.67666 | 2094402.41422 | 37.7317901790589 | -122.383155043276 | (37.7317901790589, -122.383155043276) | 10 | 3 | 8 | 58 | 1 | |||
| 40503 | 190902 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 2 George Ct | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6017218.74328 | 2094051.55163 | 37.7308325297006 | -122.382770852905 | (37.7308325297006, -122.382770852905) | 10 | 3 | 8 | 58 | 1 | |||
| 51037 | 189581 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 1 Whitfield Ct | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 6017516.56357 | 2094124.06913 | 37.7310480980763 | -122.38174627147 | (37.7310480980763, -122.38174627147) | 10 | 3 | 8 | 58 | 1 | |||
| 54490 | 189561 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 1445 Osceola Ln | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6016975.64567 | 2094505.62262 | 37.7320658851215 | -122.383642889503 | (37.7320658851215, -122.383642889503) | 10 | 3 | 8 | 58 | 1 | |||
| 57372 | 189571 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 1446 Osceola Ln | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6017247.28472 | 2094271.31266 | 37.7314375270091 | -122.382687465955 | (37.7314375270091, -122.382687465955) | 10 | 3 | 8 | 58 | 1 | |||
| 70782 | 189562 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 1446 Osceola Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 3ft | 6016953.82391 | 2094486.73 | 37.7320128035318 | -122.383717017933 | (37.7320128035318, -122.383717017933) | 10 | 3 | 8 | 58 | 1 | |||
| 77596 | 189578 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 1 Whitfield Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6017480.95894 | 2094099.62822 | 37.7309790220515 | -122.381867664661 | (37.7309790220515, -122.381867664661) | 10 | 3 | 8 | 58 | 1 | |||
| 78738 | 189558 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 1445 Osceola Ln | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 3ft | 6017184.67928 | 2094353.39729 | 37.731659456313 | -122.382909617407 | (37.731659456313, -122.382909617407) | 10 | 3 | 8 | 58 | 1 | |||
| 82022 | 190898 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 5 Garlington Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 31 | Width 2ft | 6016730.33018 | 2094437.34712 | 37.7318648515624 | -122.38448625305 | (37.7318648515624, -122.38448625305) | 10 | 3 | 8 | 58 | 1 | |||
| 82147 | 189577 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 1 Whitfield Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 3ft | 6017435.92036 | 2094104.0032 | 37.7309885476725 | -122.382023676378 | (37.7309885476725, -122.382023676378) | 10 | 3 | 8 | 58 | 1 | |||
| 85191 | 189570 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 1446 Osceola Ln | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6017210.39015 | 2094289.17709 | 37.731484540869 | -122.38281626146 | (37.731484540869, -122.38281626146) | 10 | 3 | 8 | 58 | 1 | |||
| 87524 | 189531 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 110 Mendell St | 4 | : | Tree | Private 2 | 23 | Width 4ft | 6016991.36665 | 2098416.96478 | 37.7428065153073 | -122.383860781748 | (37.7428065153073, -122.383860781748) | 10 | 3 | 8 | 58 | 1 | |||
| 90752 | 189569 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 1446 Osceola Ln | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6017191.89147 | 2094295.54174 | 37.7315009948796 | -122.38288065834 | (37.7315009948796, -122.38288065834) | 10 | 3 | 8 | 58 | 1 | |||
| 92886 | 9278 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 2X George Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6017336.34863 | 2094035.36657 | 37.7307945855032 | -122.382363142567 | (37.7307945855032, -122.382363142567) | 10 | 3 | 8 | 58 | 1 | |||
| 93699 | 190905 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 2 George Ct | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6017266.07148 | 2094036.0261 | 37.7307925143403 | -122.382606150167 | (37.7307925143403, -122.382606150167) | 10 | 3 | 8 | 58 | 1 | |||
| 104182 | 189575 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 1446 Osceola Ln | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6017319.81407 | 2094258.43885 | 37.7314061847416 | -122.382435820381 | (37.7314061847416, -122.382435820381) | 10 | 3 | 8 | 58 | 1 | |||
| 104578 | 189574 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 1446 Osceola Ln | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 3ft | 6017299.64187 | 2094252.85192 | 37.731389729831 | -122.382505171573 | (37.731389729831, -122.382505171573) | 10 | 3 | 8 | 58 | 1 | |||
| 108071 | 9280 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 2X George Ct | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6017284.68547 | 2094063.55781 | 37.7308691392805 | -122.382543712932 | (37.7308691392805, -122.382543712932) | 10 | 3 | 8 | 58 | 1 | |||
| 116269 | 189579 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 1 Whitfield Ct | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6017480.3384 | 2094118.23435 | 37.7310300765608 | -122.381871103661 | (37.7310300765608, -122.381871103661) | 10 | 3 | 8 | 58 | 1 | |||
| 121605 | 189572 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 1446 Osceola Ln | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6017266.9236 | 2094264.63951 | 37.7314202888017 | -122.382619105789 | (37.7314202888017, -122.382619105789) | 10 | 3 | 8 | 58 | 1 | |||
| 129514 | 190903 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 2 George Ct | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6017234.51726 | 2094046.2732 | 37.7308189076442 | -122.382715952004 | (37.7308189076442, -122.382715952004) | 10 | 3 | 8 | 58 | 1 | |||
| 134956 | 190896 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 5 Garlington Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 2ft | 6016688.00445 | 2094538.60602 | 37.732140547747 | -122.384639634226 | (37.732140547747, -122.384639634226) | 10 | 3 | 8 | 58 | 1 | |||
| 148077 | 189564 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 1446 Osceola Ln | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 31 | Width 3ft | 6017029.35729 | 2094424.61752 | 37.7318464298488 | -122.383451557857 | (37.7318464298488, -122.383451557857) | 10 | 3 | 8 | 58 | 1 | |||
| 154836 | 189582 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 1 Whitfield Ct | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 34 | Width 3ft | 6017517.02195 | 2094132.62112 | 37.7310716054715 | -122.381745281329 | (37.7310716054715, -122.381745281329) | 10 | 3 | 8 | 58 | 1 | |||
| 162647 | 189573 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 1446 Osceola Ln | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6017285.70911 | 2094258.26882 | 37.7314038339084 | -122.382553716981 | (37.7314038339084, -122.382553716981) | 10 | 3 | 8 | 58 | 1 | |||
| 163754 | 190897 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 5 Garlington Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 29 | Width 2ft | 6016692.53268 | 2094508.57531 | 37.7320583398066 | -122.384621887887 | (37.7320583398066, -122.384621887887) | 10 | 3 | 8 | 58 | 1 | |||
| 165839 | 190906 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 2 George Ct | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6017303.14119 | 2094021.32705 | 37.7307542014307 | -122.382476970658 | (37.7307542014307, -122.382476970658) | 10 | 3 | 8 | 58 | 1 | |||
| 166879 | 189563 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 1446 Osceola Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6016967.52879 | 2094476.64405 | 37.7319858670524 | -122.383668934795 | (37.7319858670524, -122.383668934795) | 10 | 3 | 8 | 58 | 1 | |||
| 167700 | 189566 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 1446 Osceola Ln | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 3ft | 6017137.64973 | 2094320.03335 | 37.7315652469174 | -122.383069888286 | (37.7315652469174, -122.383069888286) | 10 | 3 | 8 | 58 | 1 | |||
| 169564 | 189565 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 1446 Osceola Ln | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 6017060.82222 | 2094404.36375 | 37.7317925559632 | -122.383341366632 | (37.7317925559632, -122.383341366632) | 10 | 3 | 8 | 58 | 1 | |||
| 173389 | 9279 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 2X George Ct | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6017318.48067 | 2094048.61482 | 37.7308299756143 | -122.382425836978 | (37.7308299756143, -122.382425836978) | 10 | 3 | 8 | 58 | 1 | |||
| 174531 | 190899 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 5 Cashmere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Width 4ft | 6017129.1196 | 2095829.20584 | 37.7357086637101 | -122.383204385489 | (37.7357086637101, -122.383204385489) | 10 | 3 | 8 | 58 | 1 | |||
| 180589 | 189556 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 1445 Osceola Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6017232.60128 | 2094330.21594 | 37.7315984525868 | -122.382742327304 | (37.7315984525868, -122.382742327304) | 10 | 3 | 8 | 58 | 1 | |||
| 180957 | 190904 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 5 George Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 6017188 | 2093995 | 37.7306755515034 | -122.382873204359 | (37.7306755515034, -122.382873204359) | 10 | 3 | 8 | 58 | 1 | |||
| 185067 | 1686 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 4X Baldwin Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/19/2015 01:24:00 PM | 3 | 3X3 | 6017606.12986 | 2093597.15559 | 37.7296062420266 | -122.381399995617 | (37.7296062420266, -122.381399995617) | 10 | 3 | 8 | 58 | 1 | ||
| 193957 | 189557 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 1445 Osceola Ln | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6017204.6343 | 2094337.12646 | 37.7316158823669 | -122.382839496348 | (37.7316158823669, -122.382839496348) | 10 | 3 | 8 | 58 | 1 |
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) );