trees
134 rows where Zip Codes = 56 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 149723 | 254437 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1408 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/06/2015 01:04:00 PM | 3x3 | 5981264 | 2105479 | 37.7601571100533 | -122.507917756824 | (37.7601571100533, -122.507917756824) | 1 | 8 | 3 | 56 | 35 | ||
| 152474 | 94162 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1750 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53533 | 5993469.4 | 2103573.4 | 37.7556364086322 | -122.465566975178 | (37.7556364086322, -122.465566975178) | 1 | 8 | 4 | 56 | 12 | ||
| 152525 | 109744 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4307 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772150 | 5981459.9 | 2104819.9 | 37.7583589503944 | -122.507191346523 | (37.7583589503944, -122.507191346523) | 1 | 8 | 3 | 56 | 35 |
| 152713 | 48663 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1300 11th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2002 12:00:00 AM | Permit Number 45949 | 5992726.08644889 | 2106595.37916826 | 37.7638910715093 | -122.468357408335 | (37.7638910715093, -122.468357408335) | 1 | 8 | 11 | 56 | 12 | ||
| 156551 | 206986 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1284 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5992719.06604 | 2106665.13626 | 37.7640822005694 | -122.468386764944 | (37.7640822005694, -122.468386764944) | 11 | 8 | 11 | 56 | 12 | |||
| 158383 | 206998 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 223 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994252.21923 | 2105280.12164 | 37.7603677459862 | -122.462983582339 | (37.7603677459862, -122.462983582339) | 1 | 5 | 4 | 56 | 12 | |||
| 158809 | 184688 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1611 37th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 01/03/2019 12:00:00 AM | 3 | Width 0ft | Permit Number 782745 | 5984657.9281 | 2104207.7196 | 37.7568659135367 | -122.496086155975 | (37.7568659135367, -122.496086155975) | 1 | 8 | 3 | 56 | 35 | |
| 161367 | 182659 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2252 Ortega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5986985.3742 | 2102363.8158 | 37.7519391046129 | -122.487901613135 | (37.7519391046129, -122.487901613135) | 1 | 8 | 3 | 56 | 35 | |||
| 162961 | 69182 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1371 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50160 | 5982122.5039 | 2105769.199 | 37.7610044592096 | -122.504970155565 | (37.7610044592096, -122.504970155565) | 1 | 8 | 3 | 56 | 35 | |
| 165167 | 95901 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1700 23rd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2011 12:00:00 AM | 3x3 | Permit Number 767603 | 5989092 | 2103686.6 | 37.7556937768723 | -122.480713514054 | (37.7556937768723, -122.480713514054) | 1 | 8 | 3 | 56 | 35 | |
| 167096 | 98557 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3906 Judah St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/07/2012 12:00:00 AM | 3 | 5982438 | 2105598 | 37.7605529521075 | -122.503866330302 | (37.7605529521075, -122.503866330302) | 1 | 8 | 3 | 56 | 35 | |||
| 167767 | 88087 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1254 38th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51087 | 5984334.6 | 2106629.9 | 37.7634975987144 | -122.497383137852 | (37.7634975987144, -122.497383137852) | 1 | 8 | 3 | 56 | 35 | |||
| 168187 | 836 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1396X 48th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2017 10:52:00 AM | 3 | 3X3 | 5981241.3128 | 2105622.3145 | 37.7605492737866 | -122.508006856179 | (37.7605492737866, -122.508006856179) | 1 | 8 | 3 | 56 | 35 | ||
| 169035 | 47267 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1386 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 1 | Permit Number 45208 | 5988680.1995 | 2105896.4201 | 37.7617374028544 | -122.48229953296 | (37.7617374028544, -122.48229953296) | 1 | 8 | 3 | 56 | 35 | |
| 169137 | 98848 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1795X 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2012 12:00:00 AM | 3x3 | Permit Number 768753 | 5986486.2 | 2103095 | 37.7539176067687 | -122.489681571094 | (37.7539176067687, -122.489681571094) | 1 | 8 | 3 | 56 | 35 | ||
| 169433 | 115802 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1218 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774518 | 5981226.5 | 2106751.9 | 37.7636499175412 | -122.50814192749 | (37.7636499175412, -122.50814192749) | 1 | 8 | 3 | 56 | 35 | |
| 172462 | 206985 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1498 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5990877.17813 | 2105275.09317 | 37.7601589539866 | -122.474655794123 | (37.7601589539866, -122.474655794123) | 1 | 8 | 4 | 56 | 12 | |||
| 172804 | 31938 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1335 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/29/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50210 | 5981495.7067 | 2105969.8095 | 37.761518381611 | -122.507152818801 | (37.761518381611, -122.507152818801) | 1 | 8 | 3 | 56 | 35 | |
| 175408 | 95911 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1845 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767612 | 5989071.1412 | 2105102.6181 | 37.7595805696676 | -122.480889318141 | (37.7595805696676, -122.480889318141) | 1 | 8 | 3 | 56 | 35 |
| 176687 | 63095 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1314 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2016 12:00:00 AM | 1 | Permit Number 775034 | 5982157.61974918 | 2106142.20642168 | 37.7620306969809 | -122.504876348182 | (37.7620306969809, -122.504876348182) | 1 | 8 | 3 | 56 | 35 | ||
| 178343 | 46893 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1383 11th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | Permit Number 44948 | 5992692.47897134 | 2106059.86172468 | 37.7624187406256 | -122.468434681685 | (37.7624187406256, -122.468434681685) | 1 | 8 | 11 | 56 | 12 | ||
| 178982 | 95429 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1437 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767294 | 5988962.2823 | 2105532.8441 | 37.760755525792 | -122.481297307618 | (37.760755525792, -122.481297307618) | 1 | 8 | 3 | 56 | 35 |
| 181063 | 182513 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1573 34th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 03/23/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 777985 | 5985578.9968 | 2104511.5721 | 37.7577541150318 | -122.492923184352 | (37.7577541150318, -122.492923184352) | 1 | 8 | 3 | 56 | 35 | |
| 181692 | 182658 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2242 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5987004.6631 | 2102364.6195 | 37.7519424365087 | -122.487834969288 | (37.7519424365087, -122.487834969288) | 1 | 8 | 3 | 56 | 35 | |||
| 182139 | 183687 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1341 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 33196 | 5983043.3769 | 2106010.2341 | 37.7617204082059 | -122.501803142928 | (37.7617204082059, -122.501803142928) | 1 | 8 | 3 | 56 | 35 | |
| 184192 | 113139 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1799x 25TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5988397 | 2103119 | 37.7540948807956 | -122.483075414994 | (37.7540948807956, -122.483075414994) | 1 | 8 | 3 | 56 | 35 | ||||
| 185808 | 183691 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1341 42nd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983046.4226 | 2105931.5142 | 37.7615044445987 | -122.501786784798 | (37.7615044445987, -122.501786784798) | 1 | 8 | 3 | 56 | 35 | ||
| 186945 | 254438 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1412 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/06/2015 01:14:00 PM | 3x3 | 5981265 | 2105453 | 37.7600857804311 | -122.507912368787 | (37.7600857804311, -122.507912368787) | 1 | 8 | 3 | 56 | 35 | ||
| 187202 | 183640 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1484 47th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5981572.1323 | 2104991.2828 | 37.7588361283195 | -122.506815916291 | (37.7588361283195, -122.506815916291) | 1 | 8 | 3 | 56 | 35 | |||
| 188586 | 69101 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1672 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773502 | 5992502.12347703 | 2104077.04435662 | 37.7569634473758 | -122.468948742276 | (37.7569634473758, -122.468948742276) | 1 | 8 | 4 | 56 | 12 |
| 193090 | 184126 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1643 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5986219.0266 | 2104040.7857 | 37.7564988729574 | -122.490675089245 | (37.7564988729574, -122.490675089245) | 1 | 8 | 3 | 56 | 35 | |||
| 193269 | 95900 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1700 23rd Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2011 12:00:00 AM | 3x3 | Permit Number 767603 | 5989092 | 2103686.6 | 37.7556937768723 | -122.480713514054 | (37.7556937768723, -122.480713514054) | 1 | 8 | 3 | 56 | 35 | |
| 193752 | 184292 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1543 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 0 | 3x3 | 5983695 | 2104642 | 37.7580018774889 | -122.499448359455 | (37.7580018774889, -122.499448359455) | 1 | 8 | 3 | 56 | 35 | ||
| 194395 | 183689 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1351 42nd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5983050 | 2105938 | 37.7615224629013 | -122.501774892125 | (37.7615224629013, -122.501774892125) | 1 | 8 | 3 | 56 | 35 |
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) );