trees
42 rows where SiteOrder = 3 and qSpecies_id = 116
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1462 | 225196 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 3160 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 778605 | 6007182.851 | 2103832.80652 | 37.7571300930895 | -122.418159821127 | (37.7571300930895, -122.418159821127) | 2 | 4 | 7 | 28859 | 19 | ||
| 3713 | 225189 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | ||
| 4227 | 109316 | Undocumented 4 | Trachycarpus fortunei :: Windmill Palm 116 | 1516 BROADWAY | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006331.3 | 2118082.2 | 37.7962075161748 | -122.422117105361 | (37.7962075161748, -122.422117105361) | 13 | 9 | 10 | 28858 | 32 | ||||
| 13617 | 82366 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 116 | 51 Princeton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6007564.92616 | 2093725.05049 | 37.7293979446509 | -122.416122630059 | (37.7293979446509, -122.416122630059) | 9 | 3 | 7 | 309 | 28 | |||
| 13922 | 34080 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 240 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | 6 | 3x3 | Permit Number 37968 | 6007780.97837226 | 2105869.55428135 | 37.7627561815899 | -122.41623551069 | (37.7627561815899, -122.41623551069) | 8 | 4 | 7 | 28859 | 19 |
| 17192 | 72214 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1799 Revere Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6014033.56934 | 2095149.8862 | 37.7336718422767 | -122.393859447849 | (37.7336718422767, -122.393859447849) | 10 | 3 | 8 | 58 | 1 | |||
| 20099 | 241180 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 300 Duboce Ave | 3 | Front Yard : Yard | Tree | Private 2 | 02/20/2001 12:00:00 AM | 7 | Width 3ft | Permit Number 43693 | 6004770.13014 | 2108408.30025 | 37.7695572102182 | -122.426829784767 | (37.7695572102182, -122.426829784767) | 7 | 9 | 5 | 28862 | 10 | |
| 24606 | 241219 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 4130 Cesar Chavez St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 6003095.93223 | 2100399.37123 | 37.7474718059861 | -122.432048772745 | (37.7474718059861, -122.432048772745) | 2 | 4 | 5 | 63 | 22 | |||
| 29995 | 117607 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 420 Castro St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6002292.2454566 | 2105806.2278627 | 37.7622721434766 | -122.435214539817 | (37.7622721434766, -122.435214539817) | 15 | 4 | 5 | 28862 | 3 | |||
| 31308 | 44007 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 2701X 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2015 12:00:00 AM | 3 | Permit Number 43559. Tree 3 on 17th St | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
| 32219 | 215432 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 20 Lakewood Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993607.07382 | 2092934.57084 | 37.7264327944236 | -122.464318491921 | (37.7264327944236, -122.464318491921) | 9 | 8 | 4 | 59 | 40 | |||
| 32296 | 179959 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 162 Tunnel Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6011901.82986 | 2087473.45511 | 37.7124752317148 | -122.400690449024 | (37.7124752317148, -122.400690449024) | 10 | 3 | 8 | 309 | 1 | |||
| 45490 | 34052 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 375 Alabama St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37958 | 6008950.19472335 | 2106493.86234805 | 37.7645360636147 | -122.41223571698 | (37.7645360636147, -122.41223571698) | 8 | 4 | 7 | 28859 | 19 | ||
| 47804 | 136746 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2908 Broderick St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6000043.09421 | 2118605.60705 | 37.7972879782152 | -122.443913133705 | (37.7972879782152, -122.443913133705) | 13 | 9 | 1 | 57 | 17 | |||
| 50722 | 253485 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1x Gordon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763 | 2109812 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | 8 | 2 | 9 | 28853 | 34 | |
| 53968 | 52306 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 715 Buena Vista Ave West | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2016 12:00:00 AM | 3 | Permit Number 48465 | 5999876.8 | 2107852.1 | 37.7677521370965 | -122.443715612896 | (37.7677521370965, -122.443715612896) | 15 | 5 | 5 | 29492 | 9 | ||
| 57490 | 16286 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 700X Monterey Blvd | 3 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 5 | 5997448.036427 | 2094744.2173306 | 37.7316223027997 | -122.45117096627 | (37.7316223027997, -122.45117096627) | 9 | 7 | 4 | 59 | 40 | ||
| 59259 | 215414 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 423 Flood Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 6ft | 5997954.5929 | 2094069.33464 | 37.7297982247933 | -122.449371101191 | (37.7297982247933, -122.449371101191) | 9 | 7 | 4 | 28861 | 40 | |||
| 82601 | 63573 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1500@Polk Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 6 | Permit Number 49344 | 6006306.38676 | 2118003.57118 | 37.7959902160323 | -122.422197721351 | (37.7959902160323, -122.422197721351) | 13 | 9 | 10 | 28858 | 32 | |
| 89456 | 42310 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 249 Edna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2000 12:00:00 AM | Permit Number 42531 | 5998732.34943109 | 2093642.59637242 | 37.7286709604577 | -122.446651628377 | (37.7286709604577, -122.446651628377) | 9 | 7 | 4 | 28861 | 40 | |||
| 91808 | 88373 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 45 Sheridan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/2005 12:00:00 AM | 2x3 | Permit Number 48123 | 6009306 | 2109414 | 37.7725740445577 | -122.411211370961 | (37.7725740445577, -122.411211370961) | 8 | 2 | 9 | 28853 | 34 | ||
| 96141 | 197984 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1177 De Haro St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6012264.79545 | 2102939.83963 | 37.7549629356143 | -122.40052167054 | (37.7549629356143, -122.40052167054) | 10 | 3 | 8 | 28856 | 29 | |||
| 96325 | 241195 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 699 Hampshire St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010149.31923 | 2105113.84294 | 37.7608140561404 | -122.407990924146 | (37.7608140561404, -122.407990924146) | 10 | 4 | 8 | 28859 | 19 | |||
| 103790 | 179968 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 675 Silver Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 32 | Width 2ft | 6005852.39602 | 2093589.23287 | 37.7289285803821 | -122.422033372066 | (37.7289285803821, -122.422033372066) | 9 | 7 | 6 | 28861 | 5 | |||
| 106828 | 181621 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2340 Irving St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5988377.8972 | 2106492.1372 | 37.7633554905962 | -122.483388734412 | (37.7633554905962, -122.483388734412) | 1 | 8 | 3 | 56 | 35 | |||
| 107025 | 182656 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2618 Ortega St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 0ft | 5985872.0635 | 2102330.847 | 37.7517835760889 | -122.491749119446 | (37.7517835760889, -122.491749119446) | 1 | 8 | 3 | 56 | 35 | |||
| 114123 | 36797 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1350 Donner Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | 8 | 3x3 | Permit Number 39527 | 6015213.5435 | 2090847.5562 | 37.7219240080036 | -122.389479539312 | (37.7219240080036, -122.389479539312) | 10 | 3 | 8 | 58 | 1 | |
| 116024 | 39860 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 70 13th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50122 | 6008235.62773227 | 2108364.64558499 | 37.7696326766808 | -122.414839630355 | (37.7696326766808, -122.414839630355) | 8 | 4 | 9 | 28853 | 19 | ||
| 118808 | 42738 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 2155 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42735 | 6011836.19977805 | 2087516.89388515 | 37.7125908452343 | -122.400920338197 | (37.7125908452343, -122.400920338197) | 10 | 3 | 8 | 309 | 1 | ||
| 121022 | 241220 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2800 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009102.18096 | 2106403.85246 | 37.7642974442959 | -122.411703675409 | (37.7642974442959, -122.411703675409) | 8 | 4 | 7 | 28859 | 19 | |||
| 138796 | 241213 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2801 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6009032.16938 | 2106352.76347 | 37.7641532379917 | -122.411942216073 | (37.7641532379917, -122.411942216073) | 8 | 4 | 7 | 28859 | 19 | |||
| 142699 | 52313 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 4400HOFFMAN 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2009 12:00:00 AM | 3x3 | Permit Number 52154 | 6000634.55195661 | 2101724.81174328 | 37.7509712947951 | -122.440655099281 | (37.7509712947951, -122.440655099281) | 2 | 4 | 5 | 28862 | 22 | ||
| 145108 | 28414 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 600X Monterey Blvd | 3 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 5 | 5998107.3609693 | 2094732.8027768 | 37.7316286888145 | -122.448890739326 | (37.7316286888145, -122.448890739326) | 9 | 7 | 4 | 59 | 40 | ||
| 146756 | 44262 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 300 Duboce Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2001 12:00:00 AM | Permit Number 43693 | 6004891.25445895 | 2108442.06671817 | 37.7696567724968 | -122.426413224583 | (37.7696567724968, -122.426413224583) | 7 | 4 | 5 | 28852 | 10 | |||
| 151718 | 28415 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 692X Monterey Blvd | 3 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 3X3 | 5997509.7184819 | 2094751.8939266 | 37.7316469123248 | -122.450958273614 | (37.7316469123248, -122.450958273614) | 9 | 7 | 4 | 59 | 40 | ||
| 153487 | 215427 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 15 Fairfield Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993797.5326 | 2092869.73491 | 37.7262657471456 | -122.463655385788 | (37.7262657471456, -122.463655385788) | 9 | 8 | 4 | 59 | 40 | |||
| 153581 | 49076 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 1970 Ocean Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46231 | 5993706.31601319 | 2092791.54243423 | 37.7260457932168 | -122.46396504093 | (37.7260457932168, -122.46396504093) | 9 | 8 | 4 | 59 | 40 | ||
| 153681 | 241192 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 3630 20th St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 3ft | 6006049.00576 | 2104357.91631 | 37.7585080370469 | -122.422118403835 | (37.7585080370469, -122.422118403835) | 2 | 4 | 5 | 28859 | 19 | |||
| 163325 | 34077 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 2851X 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/2011 12:00:00 AM | 6 | 3x3 | Permit Number 768574 | 6007780.97837226 | 2105869.55428135 | 37.7627561815899 | -122.41623551069 | (37.7627561815899, -122.41623551069) | 8 | 4 | 7 | 28859 | 19 |
| 164234 | 215418 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 286 Orizaba Ave | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | 5994025.68496 | 2088506.93737 | 37.7142996980529 | -122.462550356439 | (37.7142996980529, -122.462550356439) | 9 | 8 | 6 | 28861 | 24 | ||||
| 169337 | 258432 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2450 Irving St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5988181.8432 | 2106487.3051 | 37.7633308106608 | -122.484066458576 | (37.7633308106608, -122.484066458576) | 1 | 8 | 3 | 56 | 35 | ||||
| 179353 | 197990 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 155 Grace St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6008384.45392 | 2110216.9376 | 37.774726996282 | -122.414455930021 | (37.774726996282, -122.414455930021) | 8 | 2 | 9 | 28853 | 34 |
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) );