trees
26 rows where Zip Codes = 63 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1839 | 227130 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 200 Portola Dr | 2 | : | Tree | Private 2 | 3 | Width 3ft | 5999573.30223 | 2100550.73469 | 37.7476870722101 | -122.444240631696 | (37.7476870722101, -122.444240631696) | 2 | 4 | 5 | 63 | 38 | |||
| 3377 | 227135 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 200 Portola Dr | 11 | : | Tree | Private 2 | 2 | Width 3ft | 5999460.85655 | 2100362.14837 | 37.7471628438967 | -122.444615908893 | (37.7471628438967, -122.444615908893) | 2 | 4 | 5 | 63 | 38 | |||
| 26064 | 227132 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 200 Portola Dr | 5 | : | Tree | Private 2 | 3 | Width 3ft | 5999561.91472 | 2100471.96222 | 37.7474701323504 | -122.444274349099 | (37.7474701323504, -122.444274349099) | 2 | 4 | 5 | 63 | 38 | |||
| 31769 | 227126 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1689 Noe St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 4ft | 6003395.21055 | 2098417.4445 | 37.742046857971 | -122.430872467617 | (37.742046857971, -122.430872467617) | 2 | 7 | 5 | 63 | 22 | |||
| 36433 | 227134 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 200 Portola Dr | 10 | : | Tree | Private 2 | 3 | Width 3ft | 5999484.90108 | 2100375.94772 | 37.747202105595 | -122.444533756725 | (37.747202105595, -122.444533756725) | 2 | 4 | 5 | 63 | 38 | |||
| 36462 | 227586 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 494 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6003707.36504 | 2095900.15245 | 37.7351526308975 | -122.429613645169 | (37.7351526308975, -122.429613645169) | 2 | 7 | 5 | 63 | 7 | |||
| 45123 | 107987 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 233 Laidley St | Sidewalk: Property side : Yard | Tree | Private 2 | 11/10/2014 12:00:00 AM | 3 | Permit Number 771182 | 6004231.95883 | 2097050.3446 | 37.7383404878499 | -122.427881865747 | (37.7383404878499, -122.427881865747) | 2 | 7 | 5 | 63 | 7 | |||
| 45819 | 207011 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 16 Circular Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6001351.22893 | 2094512.68179 | 37.7312092646733 | -122.437660309391 | (37.7312092646733, -122.437660309391) | 9 | 7 | 4 | 63 | 40 | |||
| 53980 | 207012 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 16 Circular Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6001339.26796 | 2094505.80603 | 37.731189705325 | -122.437701168268 | (37.731189705325, -122.437701168268) | 9 | 7 | 4 | 63 | 40 | |||
| 59014 | 95404 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 395 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767278 | 6003403.3 | 2099172.9 | 37.7441216223731 | -122.430898399301 | (37.7441216223731, -122.430898399301) | 2 | 7 | 5 | 63 | 22 | |
| 59553 | 237223 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 478 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/28/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 781633 | 6003374.63036 | 2100117.41801 | 37.7467134247776 | -122.431064932422 | (37.7467134247776, -122.431064932422) | 2 | 7 | 5 | 63 | 22 | |
| 60329 | 255502 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 248 Arlington St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781971 | 6004730.8147 | 2096705.01729 | 37.7374205056678 | -122.426132488181 | (37.7374205056678, -122.426132488181) | 2 | 7 | 5 | 63 | 7 | |
| 72338 | 227121 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 791 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6001433.87774 | 2099966.59062 | 37.7461891245209 | -122.437765046244 | (37.7461891245209, -122.437765046244) | 2 | 7 | 5 | 63 | 22 | |||
| 74921 | 227129 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 291 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6001319.20971 | 2096463.36674 | 37.7365635736601 | -122.437910673444 | (37.7365635736601, -122.437910673444) | 2 | 7 | 5 | 63 | 7 | |||
| 77256 | 227128 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 248 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004363.96226 | 2096949.74054 | 37.7380717187222 | -122.427418297528 | (37.7380717187222, -122.427418297528) | 2 | 7 | 5 | 63 | 7 | |||
| 101817 | 227101 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 395 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003382.77934 | 2099193.25446 | 37.7441763482743 | -122.430970807578 | (37.7441763482743, -122.430970807578) | 2 | 7 | 5 | 63 | 22 | |||
| 101921 | 227133 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 200 Portola Dr | 9 | : | Tree | Private 2 | 4 | Width 3ft | 5999502.63692 | 2100390.28597 | 37.7472424869628 | -122.44447345809 | (37.7472424869628, -122.44447345809) | 2 | 4 | 5 | 63 | 38 | |||
| 115282 | 207013 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 178 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6000221.87075 | 2094376.84303 | 37.7307720044131 | -122.441554946711 | (37.7307720044131, -122.441554946711) | 9 | 7 | 4 | 63 | 40 | |||
| 136658 | 227102 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1451 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 6ft | 6003961.99133 | 2099782.46881 | 37.7458269972341 | -122.4290100202 | (37.7458269972341, -122.4290100202) | 2 | 7 | 5 | 63 | 22 | |||
| 142256 | 227131 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 200 Portola Dr | 3 | : | Tree | Private 2 | 3 | Width 3ft | 5999574.51262 | 2100531.90957 | 37.7476354520323 | -122.44423509368 | (37.7476354520323, -122.44423509368) | 2 | 4 | 5 | 63 | 38 | |||
| 148992 | 94654 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 494 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53793 | 6003689 | 2095884 | 37.7351072400417 | -122.429675988088 | (37.7351072400417, -122.429675988088) | 2 | 7 | 5 | 63 | 7 | |
| 167882 | 94679 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 218 Roanoke St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53815 | 6003547 | 2096007 | 37.7354369283878 | -122.430175705062 | (37.7354369283878, -122.430175705062) | 2 | 7 | 5 | 63 | 7 | |
| 171991 | 47551 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1689 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45415 | 6003395.23441175 | 2098403.20907691 | 37.7420077721371 | -122.430871369414 | (37.7420077721371, -122.430871369414) | 2 | 7 | 5 | 63 | 22 | ||
| 181974 | 227119 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 799 Duncan St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6001473.16561 | 2099668.76787 | 37.7453736076231 | -122.437607869022 | (37.7453736076231, -122.437607869022) | 2 | 7 | 5 | 63 | 22 | |||
| 189084 | 247053 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 507 Valley St | 1 | : | Tree | Private 2 | 3 | Width 2ft | 6002585.44242 | 2099146.18361 | 37.744001891474 | -122.433724457916 | (37.744001891474, -122.433724457916) | 2 | 7 | 5 | 63 | 22 | |||
| 192824 | 227120 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 799 Duncan St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6001486.23397 | 2099669.55813 | 37.7453765205103 | -122.43756273743 | (37.7453765205103, -122.43756273743) | 2 | 7 | 5 | 63 | 22 |
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) );