trees
28 rows where qSpecies_id = 291
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5406 | 73480 | DPW Maintained 1 | Acacia cognata :: River Wattle 291 | 599x 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 3x3 | 6013522.76364 | 2111545.67763 | 37.7786627326451 | -122.396774518446 | (37.7786627326451, -122.396774518446) | 6 | 2 | 9 | 28856 | 34 | ||
| 8682 | 246618 | DPW Maintained 1 | Acacia cognata :: River Wattle 291 | 175 Ripley St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 5x5 | 6009121.84834 | 2099138.68885 | 37.7443500415332 | -122.411122430074 | (37.7443500415332, -122.411122430074) | 2 | 7 | 7 | 28859 | 2 | |||
| 11916 | 70903 | DPW Maintained 1 | Acacia cognata :: River Wattle 291 | 119 Freelon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6013345.23207 | 2111478.21047 | 37.7784676004338 | -122.39738394042 | (37.7784676004338, -122.39738394042) | 6 | 2 | 9 | 28856 | 34 | |||
| 12518 | 1069 | DPW Maintained 1 | Acacia cognata :: River Wattle 291 | 2100 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6000137.1099 | 2089955.07873 | 37.7186260252389 | -122.441530791828 | (37.7186260252389, -122.441530791828) | 9 | 7 | 6 | 28861 | 25 | |||
| 15722 | 74087 | DPW Maintained 1 | Acacia cognata :: River Wattle 291 | 599X 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 17 | 6013574.27676 | 2111494.44969 | 37.778524939401 | -122.396592721381 | (37.778524939401, -122.396592721381) | 6 | 2 | 9 | 28856 | 34 | |||
| 15983 | 73852 | DPW Maintained 1 | Acacia cognata :: River Wattle 291 | 599X 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6013559.70399 | 2111507.31632 | 37.7785594572038 | -122.396644036696 | (37.7785594572038, -122.396644036696) | 6 | 2 | 9 | 28856 | 34 | |||
| 18744 | 188533 | DPW Maintained 1 | Acacia cognata :: River Wattle 291 | 570 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6013447.06785 | 2111525.42945 | 37.7786029223367 | -122.397034961197 | (37.7786029223367, -122.397034961197) | 6 | 2 | 9 | 28856 | 34 | |||
| 33741 | 173634 | DPW Maintained 1 | Acacia cognata :: River Wattle 291 | 1155 Market St | 99 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008672 | 2111900 | 37.779364436223 | -122.4135803097 | (37.779364436223, -122.4135803097) | 8 | 2 | 9 | 28853 | 34 | ||||
| 50339 | 1053 | DPW Maintained 1 | Acacia cognata :: River Wattle 291 | 2040 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 3X3 | 6000460.13302 | 2090261.37856 | 37.7194854533786 | -122.440436190985 | (37.7194854533786, -122.440436190985) | 9 | 7 | 6 | 28861 | 25 | |||
| 50604 | 220099 | DPW Maintained 1 | Acacia cognata :: River Wattle 291 | 41 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002581.52039 | 2096379.46281 | 37.7364048945526 | -122.433540336143 | (37.7364048945526, -122.433540336143) | 2 | 7 | 5 | 63 | 7 | |||
| 75862 | 250087 | DPW Maintained 1 | Acacia cognata :: River Wattle 291 | 1608 Bush St | 2 | : | Tree | Private 2 | 1 | Width 1ft | 6005770.74957 | 2115225.46131 | 37.7883319959812 | -122.423853491051 | (37.7883319959812, -122.423853491051) | 13 | 9 | 1 | 28858 | 41 | |||
| 76523 | 188530 | DPW Maintained 1 | Acacia cognata :: River Wattle 291 | 117 Freelon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6013376.95355 | 2111505.4597 | 37.7785441866999 | -122.397276114423 | (37.7785441866999, -122.397276114423) | 6 | 2 | 9 | 28856 | 34 | |||
| 81303 | 220098 | DPW Maintained 1 | Acacia cognata :: River Wattle 291 | 3673 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005174.5332 | 2104852.16435 | 37.7598157646151 | -122.42517789294 | (37.7598157646151, -122.42517789294) | 2 | 4 | 5 | 28859 | 19 | |||
| 87725 | 67717 | DPW Maintained 1 | Acacia cognata :: River Wattle 291 | 570 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1992 12:00:00 AM | 9 | Permit Number 31331 | 6013438.4217 | 2111535.2518 | 37.7786294109678 | -122.397065560652 | (37.7786294109678, -122.397065560652) | 6 | 2 | 9 | 28856 | 34 | |
| 89064 | 257891 | DPW Maintained 1 | Acacia cognata :: River Wattle 291 | 5510 Diamond Heights Blvd | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | Width 3ft | 6001843.00505 | 2097624.68353 | 37.7397820520935 | -122.436182773641 | (37.7397820520935, -122.436182773641) | 2 | 7 | 5 | 63 | 7 | ||||
| 97060 | 188531 | DPW Maintained 1 | Acacia cognata :: River Wattle 291 | 117 Freelon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6013393.02277 | 2111518.97562 | 37.7785821929504 | -122.3972214725 | (37.7785821929504, -122.3972214725) | 6 | 2 | 9 | 28856 | 34 | |||
| 103113 | 188529 | DPW Maintained 1 | Acacia cognata :: River Wattle 291 | 117 Freelon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6013364.70784 | 2111493.54453 | 37.7785107885917 | -122.39731764151 | (37.7785107885917, -122.39731764151) | 6 | 2 | 9 | 28856 | 34 | |||
| 107638 | 248041 | DPW Maintained 1 | Acacia cognata :: River Wattle 291 | 43 Rutledge St | 1 | Front Yard : Yard | Tree | Private 2 | 8 | 6010519.48467 | 2099411.43107 | 37.7451772127626 | -122.406308887068 | (37.7451772127626, -122.406308887068) | 2 | 7 | 7 | 28859 | 2 | ||||
| 122189 | 124053 | DPW Maintained 1 | Acacia cognata :: River Wattle 291 | 650 Funston Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5991957.65744 | 2110987.76796 | 37.7759069776194 | -122.471335205069 | (37.7759069776194, -122.471335205069) | 11 | 6 | 2 | 54 | 11 | |||
| 124491 | 247754 | DPW Maintained 1 | Acacia cognata :: River Wattle 291 | 46 Alpine Ter | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6001610.55634 | 2108537.96548 | 37.7697340879911 | -122.437767899795 | (37.7697340879911, -122.437767899795) | 15 | 5 | 5 | 29492 | 9 | |||
| 126780 | 188528 | DPW Maintained 1 | Acacia cognata :: River Wattle 291 | 1634 Jerrold Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 5ft | 6015106.50902 | 2097221.36431 | 37.739419267374 | -122.390294627899 | (37.739419267374, -122.390294627899) | 10 | 3 | 8 | 58 | 1 | |||
| 135202 | 220100 | DPW Maintained 1 | Acacia cognata :: River Wattle 291 | 39 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002602.52341 | 2096353.87616 | 37.7363358311349 | -122.433465892038 | (37.7363358311349, -122.433465892038) | 2 | 7 | 5 | 63 | 7 | |||
| 148361 | 188532 | DPW Maintained 1 | Acacia cognata :: River Wattle 291 | 117 Freelon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6013410.21264 | 2111535.82372 | 37.7786294109687 | -122.39716318745 | (37.7786294109687, -122.39716318745) | 6 | 2 | 9 | 28856 | 34 | |||
| 157960 | 94328 | DPW Maintained 1 | Acacia cognata :: River Wattle 291 | 599X Wisconsin St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 07/15/2010 12:00:00 AM | 6 | 8x6 | Permit Number 53628 | 6012719.6074 | 2104814.62781 | 37.7601360473633 | -122.399080378359 | (37.7601360473633, -122.399080378359) | 10 | 3 | 8 | 28856 | 29 | |
| 160884 | 250086 | DPW Maintained 1 | Acacia cognata :: River Wattle 291 | 1608 Bush St | 1 | : | Tree | Private 2 | 1 | Width 1ft | 6005781.70757 | 2115226.50094 | 37.7883354691536 | -122.423815652065 | (37.7883354691536, -122.423815652065) | 13 | 9 | 1 | 28858 | 41 | |||
| 163549 | 220097 | DPW Maintained 1 | Acacia cognata :: River Wattle 291 | 99 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6005410.95518 | 2103173.20638 | 37.7552190921959 | -122.424240813775 | (37.7552190921959, -122.424240813775) | 2 | 4 | 5 | 28859 | 19 | |||
| 163839 | 35248 | DPW Maintained 1 | Acacia cognata :: River Wattle 291 | 1241 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2015 12:00:00 AM | 3 | Permit Number 38737 | 6007082.36267 | 2118759.24706 | 37.7981088505934 | -122.419566329333 | (37.7981088505934, -122.419566329333) | 5 | 1 | 10 | 28858 | 32 | ||
| 191912 | 49820 | DPW Maintained 1 | Acacia cognata :: River Wattle 291 | 1600X 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/2005 12:00:00 AM | 11 | 3x3 | Permit Number 48421 | 6012856.81968 | 2105678.96328 | 37.762516967395 | -122.398666479782 | (37.762516967395, -122.398666479782) | 14 | 3 | 8 | 28856 | 29 |
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) );