trees
29 rows where qSpecies_id = 285
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5096 | 179175 | DPW Maintained 1 | Pseudotsuga menziesii :: Douglas Fir 285 | 7 Still St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | 6003197.84966 | 2094653.86359 | 37.7317017415451 | -122.431286289755 | (37.7317017415451, -122.431286289755) | 9 | 7 | 5 | 28861 | 25 | ||||
7437 | 19974 | DPW Maintained 1 | Pseudotsuga menziesii :: Douglas Fir 285 | 100 STAIRWAY45 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30ST | |||||||||||||
24927 | 107413 | Significant Tree 6 | Pseudotsuga menziesii :: Douglas Fir 285 | 276 Yerba Buena Ave | 1 | Front Yard : Yard | Tree | Private 2 | 28 | 5995080.66446 | 2095640.15746 | 37.7339465073544 | -122.459420244296 | (37.7339465073544, -122.459420244296) | 9 | 8 | 4 | 59 | 40 | ||||
55103 | 91118 | DPW Maintained 1 | Pseudotsuga menziesii :: Douglas Fir 285 | 215 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2009 12:00:00 AM | 53 | 3x3 | Permit Number 52008 | 6005659.93455 | 2092656.02169 | 37.726355330411 | -122.422632437432 | (37.726355330411, -122.422632437432) | 9 | 7 | 7 | 309 | 5 | |
67417 | 213739 | DPW Maintained 1 | Pseudotsuga menziesii :: Douglas Fir 285 | 2 Cranleigh Dr | 13 | Front Yard : Yard | Tree | Private 2 | 15 | Width 0ft | 5991374.70721 | 2095782.57597 | 37.7341237740781 | -122.472243125326 | (37.7341237740781, -122.472243125326) | 1 | 8 | 4 | 64 | 40 | |||
70810 | 107117 | DPW Maintained 1 | Pseudotsuga menziesii :: Douglas Fir 285 | 300X LIBERTY ST | 17 | Median : Cutout | Tree | DPW 1 | 18 | 6004270.1 | 2103982.4 | 37.7573764628527 | -122.428243896062 | (37.7573764628527, -122.428243896062) | 2 | 4 | 5 | 28862 | 3 | ||||
72551 | 185792 | DPW Maintained 1 | Pseudotsuga menziesii :: Douglas Fir 285 | 1975 32nd Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5986293.4379 | 2101811.9436 | 37.7503834266815 | -122.490253802528 | (37.7503834266815, -122.490253802528) | 1 | 8 | 3 | 29491 | 35 | |||
74311 | 179176 | DPW Maintained 1 | Pseudotsuga menziesii :: Douglas Fir 285 | 166 Otsego Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 3ft | 6000550.04717 | 2092274.06845 | 37.7250169611399 | -122.440269651834 | (37.7250169611399, -122.440269651834) | 9 | 7 | 6 | 28861 | 25 | |||
77248 | 187376 | DPW Maintained 1 | Pseudotsuga menziesii :: Douglas Fir 285 | 2200 Sunset Blvd | 62 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5985079.354 | 2100006.8087 | 37.7453560390483 | -122.494319085826 | (37.7453560390483, -122.494319085826) | 1 | 8 | 3 | 29491 | 35 | |||
105239 | 110843 | Property Tree 8 | Pseudotsuga menziesii :: Douglas Fir 285 | 2037 TURK BLVD | Front Yard : Yard | Tree | Private 2 | 15 | 6000252 | 2111948 | 37.7790198360362 | -122.442711981138 | (37.7790198360362, -122.442711981138) | 15 | 5 | 11 | 29490 | 16 | |||||
105777 | 91119 | DPW Maintained 1 | Pseudotsuga menziesii :: Douglas Fir 285 | 215 Madison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2009 12:00:00 AM | 21 | 3x3 | Permit Number 52008 | 6005656.43695 | 2092668.82689 | 37.7263902933611 | -122.422645438051 | (37.7263902933611, -122.422645438051) | 9 | 7 | 7 | 309 | 5 | |
108924 | 213742 | DPW Maintained 1 | Pseudotsuga menziesii :: Douglas Fir 285 | 27 Gennessee St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 4ft | Permit Number 782160 | 5997408.73172 | 2093713.88597 | 37.728791007485 | -122.451232571021 | (37.728791007485, -122.451232571021) | 9 | 7 | 4 | 28861 | 40 | ||
110172 | 213735 | DPW Maintained 1 | Pseudotsuga menziesii :: Douglas Fir 285 | 796 Faxon Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 10ft | 5994920.08214 | 2093287.42583 | 37.7274772445594 | -122.459805058973 | (37.7274772445594, -122.459805058973) | 9 | 7 | 4 | 28861 | 40 | |||
113098 | 213740 | DPW Maintained 1 | Pseudotsuga menziesii :: Douglas Fir 285 | 517 Mangels Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 10ft | 5998026.25225 | 2095230.63172 | 37.7329909700415 | -122.449206999211 | (37.7329909700415, -122.449206999211) | 9 | 7 | 4 | 59 | 40 | |||
117341 | 104397 | Property Tree 8 | Pseudotsuga menziesii :: Douglas Fir 285 | 350 Collingwood St | 1 | Front Yard : Yard | Tree | Private 2 | 6002086 | 2103822 | 37.7568122198273 | -122.435785890783 | (37.7568122198273, -122.435785890783) | 2 | 4 | 5 | 28862 | 3 | |||||
120576 | 179178 | DPW Maintained 1 | Pseudotsuga menziesii :: Douglas Fir 285 | 976 Avalon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6005358.47139 | 2092159.79281 | 37.7249757820858 | -122.423639316619 | (37.7249757820858, -122.423639316619) | 9 | 7 | 6 | 309 | 5 | |||
125048 | 256716 | DPW Maintained 1 | Pseudotsuga menziesii :: Douglas Fir 285 | 499X Roosevelt Way | 1 | Median : Yard | Tree | Private 2 | 30x100 | 6000118 | 2106321 | 37.7635618721538 | -122.442771378868 | (37.7635618721538, -122.442771378868) | 15 | 5 | 5 | 28862 | 3 | ||||
129520 | 213741 | DPW Maintained 1 | Pseudotsuga menziesii :: Douglas Fir 285 | 517 Mangels Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | Width 10ft | 5998035.51426 | 2095230.80366 | 37.7329919719074 | -122.449174990551 | (37.7329919719074, -122.449174990551) | 9 | 7 | 4 | 59 | 40 | |||
137335 | 179179 | DPW Maintained 1 | Pseudotsuga menziesii :: Douglas Fir 285 | 976 Avalon Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 6005365.19598 | 2092163.67204 | 37.7249868131864 | -122.423616346115 | (37.7249868131864, -122.423616346115) | 9 | 7 | 6 | 309 | 5 | |||
142624 | 136058 | DPW Maintained 1 | Pseudotsuga menziesii :: Douglas Fir 285 | 21 Golden Ct | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6008208.51543 | 2116527.95866 | 37.7920456528403 | -122.415511444514 | (37.7920456528403, -122.415511444514) | 5 | 1 | 10 | 28858 | 21 | |||
150745 | 213738 | DPW Maintained 1 | Pseudotsuga menziesii :: Douglas Fir 285 | 369 Kensington Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 5ft | 5994050.28786 | 2099129.13408 | 37.7434670709392 | -122.46323562633 | (37.7434670709392, -122.46323562633) | 1 | 8 | 4 | 59 | 40 | |||
156060 | 253715 | Significant Tree 6 | Pseudotsuga menziesii :: Douglas Fir 285 | 2959 21st Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5x15 | Permit Number 780322 | 5989962 | 2095532 | 37.7333538971055 | -122.477108940264 | (37.7333538971055, -122.477108940264) | 1 | 8 | 4 | 64 | 35 | |||
162210 | 239031 | DPW Maintained 1 | Pseudotsuga menziesii :: Douglas Fir 285 | 216 Bemis St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 39 | 6003136.63858 | 2096397.34242 | 37.7364854684375 | -122.431622336718 | (37.7364854684375, -122.431622336718) | 2 | 7 | 5 | 63 | 7 | ||||
163334 | 239032 | DPW Maintained 1 | Pseudotsuga menziesii :: Douglas Fir 285 | 216 Bemis St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | 6003139.46623 | 2096400.72966 | 37.7364949292989 | -122.431612802094 | (37.7364949292989, -122.431612802094) | 2 | 7 | 5 | 63 | 7 | ||||
164941 | 213736 | DPW Maintained 1 | Pseudotsuga menziesii :: Douglas Fir 285 | 796 Faxon Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 10ft | 5994920.91292 | 2093300.27518 | 37.7275125735434 | -122.459803117335 | (37.7275125735434, -122.459803117335) | 9 | 7 | 4 | 28861 | 40 | |||
169162 | 179174 | DPW Maintained 1 | Pseudotsuga menziesii :: Douglas Fir 285 | 12x Canyon Dr | 5 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6003147.35342 | 2086364.11434 | 37.7089370622714 | -122.430869475549 | (37.7089370622714, -122.430869475549) | 9 | 7 | 6 | 28861 | 5 | |||
170120 | 179177 | DPW Maintained 1 | Pseudotsuga menziesii :: Douglas Fir 285 | 339 Rome St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 5998184.66474 | 2089122.35364 | 37.7162281250991 | -122.448219641639 | (37.7162281250991, -122.448219641639) | 9 | 7 | 6 | 28861 | 25 | |||
183691 | 213737 | DPW Maintained 1 | Pseudotsuga menziesii :: Douglas Fir 285 | 369 Kensington Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 5ft | 5994037.02485 | 2099136.46348 | 37.7434864315522 | -122.463282017871 | (37.7434864315522, -122.463282017871) | 1 | 8 | 4 | 59 | 40 | |||
189534 | 54014 | DPW Maintained 1 | Pseudotsuga menziesii :: Douglas Fir 285 | 827 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/1972 12:00:00 AM | 5 | Permit Number 9733 | 5985075.0699 | 2110207.59904 | 37.7733643204852 | -122.495085959599 | (37.7733643204852, -122.495085959599) | 11 | 6 | 2 | 55 | 26 |
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) );