trees
33 rows where SiteOrder = 1, Zip Codes = 29491 and qSpecies_id = 65 sorted by PlotSize
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4566 | 65966 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2644 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | 23 | Permit Number 28988 | 5989285.4992 | 2097339.4197 | 37.7382773344848 | -122.479579961543 | (37.7382773344848, -122.479579961543) | 1 | 8 | 3 | 29491 | 35 | |
| 13131 | 261138 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2600 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5984799 | 2099596 | 37.7442116594147 | -122.4952581999 | (37.7442116594147, -122.4952581999) | 1 | 8 | 3 | 29491 | 35 | ||||
| 78891 | 115281 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2320 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | Permit Number 774954 | 5988790.4 | 2098360 | 37.7410508098993 | -122.481366468975 | (37.7410508098993, -122.481366468975) | 1 | 8 | 3 | 29491 | 35 | |||
| 85940 | 65809 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2268 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | Permit Number 28777 | 5991325.30735018 | 2099972.38049218 | 37.7456250483576 | -122.472719302053 | (37.7456250483576, -122.472719302053) | 1 | 8 | 4 | 29491 | 40 | ||
| 90019 | 115171 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2218 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 774487 | 5982698.2 | 2099998.9 | 37.7451946889287 | -122.502552005341 | (37.7451946889287, -122.502552005341) | 1 | 8 | 3 | 29491 | 35 | |||
| 111638 | 115173 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2063 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 775267 | 5982265.3 | 2101066.7 | 37.7481011229623 | -122.504127955016 | (37.7481011229623, -122.504127955016) | 1 | 8 | 3 | 29491 | 35 | |||
| 135735 | 97220 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 120 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 776182 | 5993132 | 2101212 | 37.749133146159 | -122.466562169914 | (37.749133146159, -122.466562169914) | 1 | 8 | 4 | 29491 | 12 | |||
| 172961 | 46374 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2135 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/2016 12:00:00 AM | 3 | Permit Number 778548 | 5982916.26389717 | 2100594.08542438 | 37.7468417151598 | -122.50184201898 | (37.7468417151598, -122.50184201898) | 1 | 8 | 3 | 29491 | 35 | |
| 174591 | 51092 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1962 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/26/2004 12:00:00 AM | 8 | Permit Number 47549 | 5987266.4855 | 2101911.4788 | 37.7507135030867 | -122.486896287824 | (37.7507135030867, -122.486896287824) | 1 | 8 | 3 | 29491 | 35 | ||
| 192251 | 44734 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1434 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/2001 12:00:00 AM | 15 | Permit Number 43849 | 5988947.4767 | 2101073.1476 | 37.7485095315689 | -122.481021968545 | (37.7485095315689, -122.481021968545) | 1 | 8 | 3 | 29491 | 35 | |
| 77808 | 104992 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2423 47TH AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 01/14/2016 12:00:00 AM | 10 | 2x6 | Permit Number 775156 | 5981729.7 | 2098576.9 | 37.7412333126477 | -122.505795454359 | (37.7412333126477, -122.505795454359) | 1 | 8 | 3 | 29491 | 35 | |
| 1599 | 110941 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2484 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 3x3 | 5984310 | 2098290 | 37.7405970958294 | -122.496852660576 | (37.7405970958294, -122.496852660576) | 1 | 8 | 3 | 29491 | 35 | ||
| 5467 | 261155 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2119 41st Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 3x3 | 5983519 | 2100707 | 37.7471871347586 | -122.499766192027 | (37.7471871347586, -122.499766192027) | 1 | 8 | 3 | 29491 | 35 | |||
| 11799 | 261147 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3220x Santiago St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | DPW | 3x3 | 5982825 | 2099474 | 37.7437609086011 | -122.502074725774 | (37.7437609086011, -122.502074725774) | 1 | 8 | 3 | 29491 | 35 | |||
| 12483 | 261152 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2279 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5982935 | 2099631 | 37.7441984490884 | -122.501705991239 | (37.7441984490884, -122.501705991239) | 1 | 8 | 3 | 29491 | 35 | |||
| 12905 | 261154 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2246 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5982704 | 2099822 | 37.7447093112365 | -122.502518859637 | (37.7447093112365, -122.502518859637) | 1 | 8 | 3 | 29491 | 35 | |||
| 15772 | 261153 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2291 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5982938 | 2099557 | 37.7439954416833 | -122.501690144388 | (37.7439954416833, -122.501690144388) | 1 | 8 | 3 | 29491 | 35 | |||
| 17368 | 261151 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2107 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 3x3 | 5982896 | 2100761 | 37.7472988260012 | -122.501924436785 | (37.7472988260012, -122.501924436785) | 1 | 8 | 3 | 29491 | 35 | |||
| 48427 | 109287 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2646 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773636 | 5982487.2 | 2097095.3 | 37.7372098007713 | -122.503066669454 | (37.7372098007713, -122.503066669454) | 1 | 8 | 3 | 29491 | 35 |
| 125569 | 109039 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2439 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773557 | 5985453.6 | 2098605.4 | 37.7415300428197 | -122.492921815189 | (37.7415300428197, -122.492921815189) | 1 | 8 | 3 | 29491 | 35 |
| 138216 | 121328 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2455 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5986403.9195 | 2098529.3345 | 37.7413767161187 | -122.489630387324 | (37.7413767161187, -122.489630387324) | 1 | 8 | 3 | 29491 | 35 | |||
| 157166 | 106344 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2428 14th Ave | 1 | Median : Cutout | Tree | Private 2 | 04/18/2014 12:00:00 AM | 3x3 | 5992079 | 2098890.7 | 37.7426986307713 | -122.470034423922 | (37.7426986307713, -122.470034423922) | 1 | 8 | 4 | 29491 | 40 | |||
| 187229 | 83487 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2051 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2008 12:00:00 AM | 10 | 3x3 | Permit Number 50156 | 5982589.2289 | 2101159.5488 | 37.7483751044578 | -122.503014711943 | (37.7483751044578, -122.503014711943) | 1 | 8 | 3 | 29491 | 35 | |
| 145605 | 183545 | Planning Code 138.1 required 2 | Agonis flexuosa :: Peppermint Willow 65 | 2580 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/2017 12:00:00 AM | 3 | 4x4 | Permit Number 777874 | 5988340.9772 | 2097760.0505 | 37.7393773655768 | -122.482876432223 | (37.7393773655768, -122.482876432223) | 1 | 8 | 3 | 29491 | 35 | |
| 5407 | 43618 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1918 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/28/2020 12:00:00 AM | 3 | 5x5 | Permit Number 43270 | 5985398.78072313 | 2102143.2200772 | 37.7512407312978 | -122.493371949534 | (37.7512407312978, -122.493371949534) | 1 | 8 | 3 | 29491 | 35 |
| 40098 | 182924 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2627 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5981795.9682 | 2097192.3992 | 37.7374357552632 | -122.505463727969 | (37.7374357552632, -122.505463727969) | 1 | 8 | 3 | 29491 | 35 | |||
| 114225 | 185942 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2001 Sunset Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984826.9443 | 2101536.2304 | 37.7495406390981 | -122.495304634302 | (37.7495406390981, -122.495304634302) | 1 | 8 | 3 | 29491 | 35 | |||
| 12846 | 203946 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2467 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2020 10:17:00 AM | 3 | Width 3ft | 5991366.65316 | 2098632.35377 | 37.7419480728373 | -122.472478660456 | (37.7419480728373, -122.472478660456) | 1 | 8 | 4 | 29491 | 40 | ||
| 74291 | 164206 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2539 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 5991384.96424 | 2098131.18541 | 37.7405730525915 | -122.472378820421 | (37.7405730525915, -122.472378820421) | 1 | 8 | 4 | 29491 | 40 | |||
| 62410 | 203526 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2424 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5992054.19197 | 2098908.13909 | 37.7427450799172 | -122.470121471754 | (37.7427450799172, -122.470121471754) | 1 | 8 | 4 | 29491 | 40 | |||
| 73816 | 203517 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 301 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5993021.77901 | 2102511.9902 | 37.7526962240514 | -122.467037812458 | (37.7526962240514, -122.467037812458) | 1 | 8 | 4 | 29491 | 12 | |||
| 144334 | 203523 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2478 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 4ft | 5992065.08232 | 2098589.24151 | 37.7418700980333 | -122.470060601112 | (37.7418700980333, -122.470060601112) | 1 | 8 | 4 | 29491 | 40 | |||
| 175320 | 203524 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2428 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5992056.59882 | 2098873.80652 | 37.7426509505813 | -122.470110650206 | (37.7426509505813, -122.470110650206) | 1 | 8 | 4 | 29491 | 40 |
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) );