trees
31 rows where qSpecies_id = 200
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1641 | 178128 | DPW Maintained 1 | Picea Spp :: Spruce Spp 200 | 246 Foote Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 5998401.02209 | 2088623.35436 | 37.7148703538566 | -122.447435913053 | (37.7148703538566, -122.447435913053) | 9 | 7 | 6 | 28861 | 25 | |||
| 3485 | 54792 | DPW Maintained 1 | Picea Spp :: Spruce Spp 200 | 281 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1972 12:00:00 AM | 9 | Permit Number 10641 | 6012667.62167 | 2087150.64407 | 37.7116315381316 | -122.398020987786 | (37.7116315381316, -122.398020987786) | 10 | 3 | 8 | 309 | 1 | ||
| 20657 | 194421 | DPW Maintained 1 | Picea Spp :: Spruce Spp 200 | 1501 22nd St | 4 | Front Yard : Yard | Tree | Private 2 | 1 | 6013491.55718 | 2103794.28225 | 37.7573773886825 | -122.396339035235 | (37.7573773886825, -122.396339035235) | 10 | 3 | 8 | 28856 | 29 | ||||
| 22626 | 210987 | DPW Maintained 1 | Picea Spp :: Spruce Spp 200 | 2000 16th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 5991305.02511 | 2101744.43769 | 37.750489483824 | -122.472918629501 | (37.750489483824, -122.472918629501) | 1 | 8 | 4 | 29491 | 12 | |||
| 26957 | 234468 | DPW Maintained 1 | Picea Spp :: Spruce Spp 200 | 1 Newburg St | 8 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 4ft | 6002588.30489 | 2099995.27539 | 37.7463334612324 | -122.433775235453 | (37.7463334612324, -122.433775235453) | 2 | 7 | 5 | 63 | 22 | |||
| 54130 | 210995 | DPW Maintained 1 | Picea Spp :: Spruce Spp 200 | 1151 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5991353.53003 | 2101776.30529 | 37.750579791933 | -122.472753220802 | (37.750579791933, -122.472753220802) | 1 | 8 | 4 | 29491 | 12 | |||
| 60332 | 112420 | Significant Tree 6 | Picea Spp :: Spruce Spp 200 | 268 Lily St | 2 | Back Yard : Yard | Tree | Private 2 | 07/29/2015 12:00:00 AM | 3 | 6005334.87738 | 2110100.0463 | 37.7742342515583 | -122.424996726643 | (37.7742342515583, -122.424996726643) | 7 | 9 | 11 | 28852 | 10 | |||
| 64917 | 210997 | DPW Maintained 1 | Picea Spp :: Spruce Spp 200 | 200 Wawona St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992553.46323 | 2097828.50731 | 37.7398095353704 | -122.468316623235 | (37.7398095353704, -122.468316623235) | 1 | 8 | 4 | 59 | 40 | |||
| 84139 | 210991 | DPW Maintained 1 | Picea Spp :: Spruce Spp 200 | 700 Junipero Serra Blvd | 85 | : | Tree | Private 2 | 2 | Width 0ft | 5991237.60676 | 2092172.19623 | 37.7242026403221 | -122.472454001079 | (37.7242026403221, -122.472454001079) | 9 | 8 | 4 | 64 | 40 | |||
| 84354 | 249653 | DPW Maintained 1 | Picea Spp :: Spruce Spp 200 | 2401 Lyon St | 5 | Front Yard : Yard | Tree | Private 2 | 5 | 5999239.65078 | 2117256.25173 | 37.7935371451746 | -122.44659610905 | (37.7935371451746, -122.44659610905) | 11 | 1 | 57 | 30 | |||||
| 93961 | 210996 | DPW Maintained 1 | Picea Spp :: Spruce Spp 200 | 1151 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5991338.45312 | 2101773.77329 | 37.750571966934 | -122.472805172843 | (37.750571966934, -122.472805172843) | 1 | 8 | 4 | 29491 | 12 | |||
| 101067 | 211000 | DPW Maintained 1 | Picea Spp :: Spruce Spp 200 | 1151 Pacheco St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5991404.67403 | 2101775.93946 | 37.7505817479591 | -122.472576335839 | (37.7505817479591, -122.472576335839) | 1 | 8 | 4 | 29491 | 12 | |||
| 123140 | 249645 | DPW Maintained 1 | Picea Spp :: Spruce Spp 200 | 2460 Lyon St | 5 | Front Yard : Yard | Tree | Private 2 | 5 | 5999269.2313 | 2117259.20748 | 37.7935469504844 | -122.446493971237 | (37.7935469504844, -122.446493971237) | 13 | 9 | 1 | 57 | 27 | ||||
| 123181 | 109526 | Undocumented 4 | Picea Spp :: Spruce Spp 200 | 2000 16TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x20 | 5991329.8 | 2101751 | 37.7505089364806 | -122.472833435354 | (37.7505089364806, -122.472833435354) | 1 | 8 | 4 | 29491 | 12 | ||||
| 128609 | 178127 | DPW Maintained 1 | Picea Spp :: Spruce Spp 200 | 250 Hester Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6012367.22926 | 2087744.64949 | 37.7132458239034 | -122.399100899089 | (37.7132458239034, -122.399100899089) | 10 | 3 | 8 | 309 | 1 | |||
| 131825 | 210994 | DPW Maintained 1 | Picea Spp :: Spruce Spp 200 | 1151 Pacheco St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5991361.38114 | 2101775.42738 | 37.750577835904 | -122.472726007301 | (37.750577835904, -122.472726007301) | 1 | 8 | 4 | 29491 | 12 | |||
| 131940 | 249652 | DPW Maintained 1 | Picea Spp :: Spruce Spp 200 | 2401 Lyon St | 4 | Front Yard : Yard | Tree | Private 2 | 5 | 5999238.28771 | 2117270.29069 | 37.793575614577 | -122.4466018359 | (37.793575614577, -122.4466018359) | 11 | 1 | 57 | 30 | |||||
| 139478 | 234467 | DPW Maintained 1 | Picea Spp :: Spruce Spp 200 | 252 Alma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5997465.52606 | 2106144.51414 | 37.7629257164781 | -122.451932667177 | (37.7629257164781, -122.451932667177) | 15 | 5 | 11 | 29492 | 9 | |||
| 145693 | 210993 | DPW Maintained 1 | Picea Spp :: Spruce Spp 200 | 1151 Pacheco St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5991379.26573 | 2101775.40636 | 37.7505788134643 | -122.47266416004 | (37.7505788134643, -122.47266416004) | 1 | 8 | 4 | 29491 | 12 | |||
| 153591 | 210998 | DPW Maintained 1 | Picea Spp :: Spruce Spp 200 | 1400 Plymouth Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5995887.63896 | 2093343.72809 | 37.7276874323278 | -122.456464300596 | (37.7276874323278, -122.456464300596) | 9 | 7 | 4 | 28861 | 40 | |||
| 155922 | 109528 | Undocumented 4 | Picea Spp :: Spruce Spp 200 | 2000 16TH AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x20 | 5991329.8 | 2101751 | 37.7505089364806 | -122.472833435354 | (37.7505089364806, -122.472833435354) | 1 | 8 | 4 | 29491 | 12 | ||||
| 156573 | 210990 | DPW Maintained 1 | Picea Spp :: Spruce Spp 200 | 488 Ralston St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5992249.59016 | 2091155.32952 | 37.721469095218 | -122.468881791378 | (37.721469095218, -122.468881791378) | 9 | 8 | 6 | 64 | 24 | |||
| 160381 | 256862 | Private 9 | Picea Spp :: Spruce Spp 200 | 133 Majestic Ave | 1 | Back Yard : Yard | Tree | Private 2 | 5997017.00624 | 2089223.65081 | 37.7164394409514 | -122.452262915882 | (37.7164394409514, -122.452262915882) | 9 | 8 | 6 | 28861 | 24 | |||||
| 163163 | 210999 | DPW Maintained 1 | Picea Spp :: Spruce Spp 200 | 445 Dewey Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5994973.63206 | 2100193.03469 | 37.7464414257323 | -122.460120016828 | (37.7464414257323, -122.460120016828) | 1 | 8 | 4 | 59 | 40 | |||
| 166073 | 112419 | Significant Tree 6 | Picea Spp :: Spruce Spp 200 | 268 Lily St | 1 | Back Yard : Yard | Tree | Private 2 | 07/29/2015 12:00:00 AM | 3 | 6005334.87738 | 2110100.0463 | 37.7742342515583 | -122.424996726643 | (37.7742342515583, -122.424996726643) | 7 | 9 | 11 | 28852 | 10 | |||
| 166775 | 234469 | DPW Maintained 1 | Picea Spp :: Spruce Spp 200 | 300 Virginia Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 6006922.40342 | 2098338.34388 | 37.7420288832343 | -122.41867091933 | (37.7420288832343, -122.41867091933) | 2 | 7 | 7 | 28859 | 2 | |||
| 172685 | 210992 | DPW Maintained 1 | Picea Spp :: Spruce Spp 200 | 1151 Pacheco St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5991431.17714 | 2101777.51792 | 37.750587616043 | -122.47248480193 | (37.750587616043, -122.47248480193) | 1 | 8 | 4 | 29491 | 12 | |||
| 173814 | 109527 | Undocumented 4 | Picea Spp :: Spruce Spp 200 | 2000 16TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x20 | 5991329.8 | 2101751 | 37.7505089364806 | -122.472833435354 | (37.7505089364806, -122.472833435354) | 1 | 8 | 4 | 29491 | 12 | ||||
| 185063 | 210988 | DPW Maintained 1 | Picea Spp :: Spruce Spp 200 | 2000 16th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5991307.5277 | 2101754.98227 | 37.7505185813763 | -122.472910744261 | (37.7505185813763, -122.472910744261) | 1 | 8 | 4 | 29491 | 12 | |||
| 187502 | 249646 | DPW Maintained 1 | Picea Spp :: Spruce Spp 200 | 2460 Lyon St | 6 | Front Yard : Yard | Tree | Private 2 | 5 | 5999270.07991 | 2117273.47556 | 37.7935861753198 | -122.446492061962 | (37.7935861753198, -122.446492061962) | 13 | 9 | 1 | 57 | 27 | ||||
| 188213 | 210989 | DPW Maintained 1 | Picea Spp :: Spruce Spp 200 | 2000 16th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5991306.24732 | 2101766.36355 | 37.7505497572816 | -122.472916001697 | (37.7505497572816, -122.472916001697) | 1 | 8 | 4 | 29491 | 12 |
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) );