trees
35 rows where qSpecies_id = 339
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10697 | 261213 | DPW Maintained 1 | Ficus rubiginosa :: Port Jackson Fig 339 | 1805 Fillmore St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4X4 | 6002990.933 | 2114560.8146 | 37.7863497234839 | -122.433423679579 | (37.7863497234839, -122.433423679579) | 13 | 9 | 11 | 29490 | 27 | ||||
| 11420 | 261214 | DPW Maintained 1 | Ficus rubiginosa :: Port Jackson Fig 339 | 1805 Fillmore St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4X4 | 6002990.933 | 2114560.8146 | 37.7863497234839 | -122.433423679579 | (37.7863497234839, -122.433423679579) | 13 | 9 | 11 | 29490 | 27 | ||||
| 15905 | 261212 | DPW Maintained 1 | Ficus rubiginosa :: Port Jackson Fig 339 | 1805 Fillmore St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4X4 | 6002990.933 | 2114560.8146 | 37.7863497234839 | -122.433423679579 | (37.7863497234839, -122.433423679579) | 13 | 9 | 11 | 29490 | 27 | ||||
| 18506 | 192171 | DPW Maintained 1 | Ficus rubiginosa :: Port Jackson Fig 339 | 1601 Kansas St | 9 | : | Tree | Private 2 | 51 | Width 7ft | 6011813.79085 | 2100866.04301 | 37.7492435801412 | -122.40193560806 | (37.7492435801412, -122.40193560806) | 10 | 3 | 8 | 58 | 1 | |||
| 22921 | 463 | DPW Maintained 1 | Ficus rubiginosa :: Port Jackson Fig 339 | 760x 23rd Ave | 19 | Median : Cutout | Tree | DPW 1 | 12 | 8-HOA | 5988827.93614 | 2110070.28551 | 37.7732062855999 | -122.482094362253 | (37.7732062855999, -122.482094362253) | 11 | 6 | 2 | 55 | 26 | |||
| 31074 | 128797 | DPW Maintained 1 | Ficus rubiginosa :: Port Jackson Fig 339 | 1601 North Point St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6003054.0198 | 2120974.69416 | 37.8039641610666 | -122.433663980313 | (37.8039641610666, -122.433663980313) | 13 | 9 | 1 | 57 | 17 | |||
| 34967 | 128789 | DPW Maintained 1 | Ficus rubiginosa :: Port Jackson Fig 339 | 2616 Union St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 2ft | 6000435.24012 | 2118232.42844 | 37.796285689198 | -122.442529406231 | (37.796285689198, -122.442529406231) | 13 | 9 | 1 | 57 | 17 | |||
| 35566 | 192169 | DPW Maintained 1 | Ficus rubiginosa :: Port Jackson Fig 339 | 1501 22nd St | 8 | Front Yard : Yard | Tree | Private 2 | 4 | 6013427.99446 | 2103808.10107 | 37.7574117949334 | -122.396559830485 | (37.7574117949334, -122.396559830485) | 10 | 3 | 8 | 28856 | 29 | ||||
| 41404 | 458 | DPW Maintained 1 | Ficus rubiginosa :: Port Jackson Fig 339 | 760x 23rd Ave | 24 | Median : Cutout | Tree | DPW 1 | 12 | 5988831.51293 | 2110000.66067 | 37.7730153231025 | -122.482076888223 | (37.7730153231025, -122.482076888223) | 11 | 6 | 2 | 55 | 26 | ||||
| 41873 | 128795 | DPW Maintained 1 | Ficus rubiginosa :: Port Jackson Fig 339 | 3661 Buchanan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6003083.04444 | 2120936.95073 | 37.8038621743528 | -122.433560839757 | (37.8038621743528, -122.433560839757) | 13 | 9 | 1 | 57 | 17 | |||
| 48526 | 128786 | DPW Maintained 1 | Ficus rubiginosa :: Port Jackson Fig 339 | 2616 Union St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 2ft | 6000449.78816 | 2118234.95075 | 37.7962934440368 | -122.442479248321 | (37.7962934440368, -122.442479248321) | 13 | 9 | 1 | 57 | 17 | |||
| 50107 | 192170 | DPW Maintained 1 | Ficus rubiginosa :: Port Jackson Fig 339 | 1601 Kansas St | 9 | : | Tree | Private 2 | 51 | Width 7ft | 6011813.79085 | 2100866.04301 | 37.7492435801412 | -122.40193560806 | (37.7492435801412, -122.40193560806) | 10 | 3 | 8 | 58 | 1 | |||
| 51507 | 128787 | DPW Maintained 1 | Ficus rubiginosa :: Port Jackson Fig 339 | 2616 Union St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 2ft | 6000444.41051 | 2118233.96384 | 37.7962904277177 | -122.442497785162 | (37.7962904277177, -122.442497785162) | 13 | 9 | 1 | 57 | 17 | |||
| 52875 | 100826 | DPW Maintained 1 | Ficus rubiginosa :: Port Jackson Fig 339 | 3661 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003080.13774 | 2120956.29501 | 37.8039151237481 | -122.433572281852 | (37.8039151237481, -122.433572281852) | 13 | 9 | 1 | 57 | 17 | |||
| 53778 | 225377 | DPW Maintained 1 | Ficus rubiginosa :: Port Jackson Fig 339 | 1353 Stevenson St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6006283.07566 | 2108788.03737 | 37.7706853045028 | -122.421623528518 | (37.7706853045028, -122.421623528518) | 8 | 2 | 9 | 28853 | 19 | |||
| 54347 | 192173 | DPW Maintained 1 | Ficus rubiginosa :: Port Jackson Fig 339 | 1601 Kansas St | 9 | : | Tree | Private 2 | 51 | Width 7ft | 6011813.79085 | 2100866.04301 | 37.7492435801412 | -122.40193560806 | (37.7492435801412, -122.40193560806) | 10 | 3 | 8 | 58 | 1 | |||
| 55208 | 7285 | DPW Maintained 1 | Ficus rubiginosa :: Port Jackson Fig 339 | 1843 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6002980.0307 | 2114661.9087 | 37.786626683704 | -122.433468625779 | (37.786626683704, -122.433468625779) | 13 | 9 | 11 | 29490 | 27 | |||
| 57550 | 128788 | DPW Maintained 1 | Ficus rubiginosa :: Port Jackson Fig 339 | 2616 Union St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 2ft | 6000439.82382 | 2118233.11772 | 37.7962878430531 | -122.442513595237 | (37.7962878430531, -122.442513595237) | 13 | 9 | 1 | 57 | 17 | |||
| 79968 | 138305 | DPW Maintained 1 | Ficus rubiginosa :: Port Jackson Fig 339 | 1899 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6002976.5618 | 2114681.7311 | 37.7866809141753 | -122.433482044409 | (37.7866809141753, -122.433482044409) | 13 | 9 | 11 | 29490 | 27 | |||
| 89045 | 128790 | DPW Maintained 1 | Ficus rubiginosa :: Port Jackson Fig 339 | 2616 Union St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 2ft | 6000429.22949 | 2118231.29811 | 37.7962822429968 | -122.442550123001 | (37.7962822429968, -122.442550123001) | 13 | 9 | 1 | 57 | 17 | |||
| 90493 | 108096 | Significant Tree 6 | Ficus rubiginosa :: Port Jackson Fig 339 | 3370 Washington St | 1 | Front Yard : Cutout | Tree | Private 2 | 17 | Permit Number 773610 | 5998674.83986 | 2115933.37372 | 37.7898725948813 | -122.448455078738 | (37.7898725948813, -122.448455078738) | 13 | 6 | 1 | 54 | 31 | |||
| 94757 | 128791 | DPW Maintained 1 | Ficus rubiginosa :: Port Jackson Fig 339 | 3250 Pacific Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | Width 4ft | 5998512.05475 | 2116571.70043 | 37.7916159621469 | -122.4490643011 | (37.7916159621469, -122.4490643011) | 11 | 6 | 1 | 54 | 30 | |||
| 99682 | 128796 | DPW Maintained 1 | Ficus rubiginosa :: Port Jackson Fig 339 | 1601 North Point St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6003043.93821 | 2120973.56715 | 37.8039604945507 | -122.433698787683 | (37.8039604945507, -122.433698787683) | 13 | 9 | 1 | 57 | 17 | |||
| 100495 | 100827 | DPW Maintained 1 | Ficus rubiginosa :: Port Jackson Fig 339 | 3661 Buchanan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003081.8479 | 2120946.98391 | 37.8038896549426 | -122.433565697914 | (37.8038896549426, -122.433565697914) | 13 | 9 | 1 | 57 | 17 | |||
| 102853 | 128793 | DPW Maintained 1 | Ficus rubiginosa :: Port Jackson Fig 339 | 215 Marina Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6002431.76066 | 2121815.30127 | 37.8062369187503 | -122.435877528418 | (37.8062369187503, -122.435877528418) | 13 | 9 | 1 | 57 | 17 | |||
| 110555 | 100830 | DPW Maintained 1 | Ficus rubiginosa :: Port Jackson Fig 339 | 1601X North Point St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003038.84698 | 2120959.76069 | 37.8039222967503 | -122.433715418836 | (37.8039222967503, -122.433715418836) | 13 | 9 | 1 | 57 | 17 | |||
| 113360 | 100828 | DPW Maintained 1 | Ficus rubiginosa :: Port Jackson Fig 339 | 1601X North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003033.04227 | 2120970.89856 | 37.8039525490422 | -122.433736302911 | (37.8039525490422, -122.433736302911) | 13 | 9 | 1 | 57 | 17 | |||
| 113994 | 128792 | DPW Maintained 1 | Ficus rubiginosa :: Port Jackson Fig 339 | 3641 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 5996821.02096 | 2115954.80185 | 37.7898252644679 | -122.454870635381 | (37.7898252644679, -122.454870635381) | 11 | 6 | 1 | 54 | 31 | |||
| 131149 | 192172 | DPW Maintained 1 | Ficus rubiginosa :: Port Jackson Fig 339 | 1601 Kansas St | 9 | : | Tree | Private 2 | 51 | Width 7ft | 6011813.79085 | 2100866.04301 | 37.7492435801412 | -122.40193560806 | (37.7492435801412, -122.40193560806) | 10 | 3 | 8 | 58 | 1 | |||
| 136086 | 101014 | DPW Maintained 1 | Ficus rubiginosa :: Port Jackson Fig 339 | 122 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/2012 12:00:00 AM | 12 | 3x3 | Permit Number 769370 | 5998315.7 | 2110195.2 | 37.7740965282123 | -122.449284076508 | (37.7740965282123, -122.449284076508) | 15 | 5 | 11 | 29492 | 16 | |
| 138548 | 40486 | DPW Maintained 1 | Ficus rubiginosa :: Port Jackson Fig 339 | 3659 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/1980 12:00:00 AM | 12 | 3x3 | Permit Number 41565 | 6003084.56298 | 2120922.56682 | 37.8038227660694 | -122.433554556191 | (37.8038227660694, -122.433554556191) | 13 | 9 | 1 | 57 | 17 | |
| 143093 | 128794 | DPW Maintained 1 | Ficus rubiginosa :: Port Jackson Fig 339 | 215 Marina Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6002443.63505 | 2121804.63249 | 37.806208299634 | -122.435835671285 | (37.806208299634, -122.435835671285) | 13 | 9 | 1 | 57 | 17 | |||
| 156821 | 7283 | DPW Maintained 1 | Ficus rubiginosa :: Port Jackson Fig 339 | 1833 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6002987.4641 | 2114608.3883 | 37.7864801519947 | -122.433439081994 | (37.7864801519947, -122.433439081994) | 13 | 9 | 11 | 29490 | 27 | |||
| 171195 | 138304 | DPW Maintained 1 | Ficus rubiginosa :: Port Jackson Fig 339 | 1899 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6002975.0751 | 2114699.5712 | 37.7867298142136 | -122.43348846341 | (37.7867298142136, -122.43348846341) | 13 | 9 | 11 | 29490 | 27 | |||
| 181300 | 7282 | DPW Maintained 1 | Ficus rubiginosa :: Port Jackson Fig 339 | 1833 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6002982.0129 | 2114634.653 | 37.7865519589269 | -122.433459819388 | (37.7865519589269, -122.433459819388) | 13 | 9 | 11 | 29490 | 27 |
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) );