trees
26 rows where Zip Codes = 59 and qSpecies_id = 6
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6051 | 207048 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 658 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 772511 | 5997718.79866 | 2095007.66028 | 37.7323611532403 | -122.450253874818 | (37.7323611532403, -122.450253874818) | 9 | 7 | 4 | 59 | 40 | |
| 12204 | 164659 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 150 Granville Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 785596 | 5994533.58351 | 2098539.8464 | 37.7418768645301 | -122.461521809887 | (37.7418768645301, -122.461521809887) | 1 | 8 | 4 | 59 | 40 | |
| 14691 | 69919 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 95 Mercedes Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2015 12:00:00 AM | Permit Number 776113 | 5991810.08250882 | 2093768.29366569 | 37.7286182461033 | -122.470591251084 | (37.7286182461033, -122.470591251084) | 9 | 8 | 4 | 59 | 40 | ||
| 19808 | 207047 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 654 Joost Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5997739.24902 | 2095008.66176 | 37.7323650733825 | -122.450183245677 | (37.7323650733825, -122.450183245677) | 9 | 7 | 4 | 59 | 40 | |||
| 28945 | 157260 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1059 Portola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781960 | 5995594.16193 | 2098091.79633 | 37.7407076181758 | -122.457822284089 | (37.7407076181758, -122.457822284089) | 9 | 7 | 4 | 59 | 40 | |
| 29381 | 94673 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 662 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53809 | 5997706.3 | 2095032.9 | 37.7324297402139 | -122.450298904109 | (37.7324297402139, -122.450298904109) | 9 | 7 | 4 | 59 | 40 | |
| 50062 | 254193 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1265 Monterey Blvd | 1 | Front Yard : Cutout | Tree | Private 2 | FUF | 01/19/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781221 | 5994091.43615 | 2094320.67109 | 37.7302665946388 | -122.462744594485 | (37.7302665946388, -122.462744594485) | 9 | 8 | 4 | 59 | 40 |
| 53141 | 71841 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 95 Mercedes Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2015 12:00:00 AM | Permit Number 776113 | 5991810.08250882 | 2093768.29366569 | 37.7286182461033 | -122.470591251084 | (37.7286182461033, -122.470591251084) | 9 | 8 | 4 | 59 | 40 | ||
| 57763 | 207044 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 755 Foerster St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5998014.32968 | 2095894.50831 | 37.7348131350024 | -122.44929603208 | (37.7348131350024, -122.44929603208) | 9 | 7 | 4 | 59 | 40 | |||
| 63727 | 207043 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 73 Keystone Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5994097.83418 | 2093287.06293 | 37.7274289275879 | -122.46264752637 | (37.7274289275879, -122.46264752637) | 9 | 8 | 4 | 59 | 40 | |||
| 64471 | 207005 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 171 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2014 12:00:00 AM | 1 | Width 3ft | Permit Number 773294 | 5992787.45104 | 2098017.32873 | 37.7403415032629 | -122.467521326669 | (37.7403415032629, -122.467521326669) | 1 | 8 | 4 | 59 | 40 | |
| 66000 | 88139 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 523 Teresita Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2008 12:00:00 AM | 3x3 | Permit Number 51168 | 5998937.5 | 2097522.9 | 37.7393370734625 | -122.446221422912 | (37.7393370734625, -122.446221422912) | 9 | 7 | 4 | 59 | 40 | |||
| 79056 | 94672 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 658 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53808 | 5997731.1 | 2095032.6 | 37.732430335747 | -122.450213143469 | (37.732430335747, -122.450213143469) | 9 | 7 | 4 | 59 | 40 | |
| 79084 | 207006 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 243 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992316.05801 | 2097825.56846 | 37.7397877510963 | -122.469137249186 | (37.7397877510963, -122.469137249186) | 1 | 8 | 4 | 59 | 40 | |||
| 80935 | 207042 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 40 Vasquez Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5995660.33467 | 2100048.89738 | 37.746085134133 | -122.457735064227 | (37.746085134133, -122.457735064227) | 1 | 5 | 4 | 59 | 40 | |||
| 81975 | 207014 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 651 Joost Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2017 12:00:00 AM | 3 | Width 1ft | Permit Number 771866 | 5997782.54111 | 2094977.36202 | 37.7322816090925 | -122.450031320482 | (37.7322816090925, -122.450031320482) | 9 | 7 | 4 | 59 | 40 | |
| 89273 | 38913 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 70 Borica St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40725 | 5992519.41888039 | 2091685.55807474 | 37.7229405587858 | -122.467987623931 | (37.7229405587858, -122.467987623931) | 9 | 8 | 4 | 59 | 40 | ||
| 104768 | 207004 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 171 Wawona St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2014 12:00:00 AM | 1 | Width 3ft | Permit Number 773294 | 5992803.19794 | 2098037.09896 | 37.7403966964551 | -122.46746831791 | (37.7403966964551, -122.46746831791) | 1 | 8 | 4 | 59 | 40 | |
| 109198 | 94671 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 654 Joost Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53807 | 5997755.7 | 2095032.2 | 37.7324306451966 | -122.450128067067 | (37.7324306451966, -122.450128067067) | 9 | 7 | 4 | 59 | 40 | |
| 147878 | 207049 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 662 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5997703.56918 | 2095007.7992 | 37.7323606631136 | -122.450306536421 | (37.7323606631136, -122.450306536421) | 9 | 7 | 4 | 59 | 40 | |||
| 150135 | 50120 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 243 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/14/2012 12:00:00 AM | Permit Number 769150 | 5992346.75268289 | 2097836.73381964 | 37.7398201819052 | -122.469031933295 | (37.7398201819052, -122.469031933295) | 1 | 8 | 4 | 59 | 40 | |||
| 154355 | 38914 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 70 Borica St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40725 | 5992519.41888039 | 2091685.55807474 | 37.7229405587858 | -122.467987623931 | (37.7229405587858, -122.467987623931) | 9 | 8 | 4 | 59 | 40 | ||
| 161683 | 207045 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 607 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5998977.59415 | 2096753.43976 | 37.7372266087217 | -122.446027465895 | (37.7372266087217, -122.446027465895) | 9 | 7 | 4 | 59 | 40 | |||
| 165946 | 207007 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 127 Westgate Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5993382.10868 | 2093854.31743 | 37.7289452232334 | -122.465162955333 | (37.7289452232334, -122.465162955333) | 9 | 8 | 4 | 59 | 40 | |||
| 173911 | 207046 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 654 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5997758.19926 | 2095006.4821 | 37.7323601729864 | -122.450117573561 | (37.7323601729864, -122.450117573561) | 9 | 7 | 4 | 59 | 40 | |||
| 189614 | 94670 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 654 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53807 | 5997755.7 | 2095032.2 | 37.7324306451966 | -122.450128067067 | (37.7324306451966, -122.450128067067) | 9 | 7 | 4 | 59 | 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) );