trees
29 rows where PlotSize = "Width 2ft" and qSpecies_id = 133
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8606 | 190946 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 40 Bluxome St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6013405.51497 | 2110852.0091 | 37.7767515500726 | -122.397131477343 | (37.7767515500726, -122.397131477343) | 6 | 2 | 9 | 28856 | 34 | |||
14448 | 206509 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1023 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5990938.9472 | 2104480.79856 | 37.7579816107664 | -122.474384202485 | (37.7579816107664, -122.474384202485) | 1 | 8 | 4 | 56 | 12 | |||
22339 | 206516 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1019 Lawton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5991047.26108 | 2104483.88717 | 37.7579963659448 | -122.474009836278 | (37.7579963659448, -122.474009836278) | 1 | 8 | 4 | 56 | 12 | |||
32203 | 206500 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 245 Lawton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5993474.54652 | 2104572.66216 | 37.7583804205467 | -122.465621770525 | (37.7583804205467, -122.465621770525) | 1 | 8 | 4 | 56 | 12 | |||
35595 | 206499 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 245 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5993488.07663 | 2104571.64852 | 37.7583784177465 | -122.46557490416 | (37.7583784177465, -122.46557490416) | 1 | 8 | 4 | 56 | 12 | |||
43073 | 206510 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1023 Lawton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5990951.63934 | 2104480.53076 | 37.7579816107816 | -122.474340288587 | (37.7579816107816, -122.474340288587) | 1 | 8 | 4 | 56 | 12 | |||
59033 | 126376 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 122 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6001336.2876 | 2121154.5777 | 37.8043604581295 | -122.439621194774 | (37.8043604581295, -122.439621194774) | 13 | 9 | 1 | 57 | 17 | |||
62155 | 206498 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 245 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5993516.66966 | 2104572.87128 | 37.7583834242608 | -122.465476106443 | (37.7583834242608, -122.465476106443) | 1 | 8 | 4 | 56 | 12 | |||
63353 | 206511 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1023 Lawton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5990966.24876 | 2104480.85465 | 37.7579833464788 | -122.474289787164 | (37.7579833464788, -122.474289787164) | 1 | 8 | 4 | 56 | 12 | |||
73036 | 206517 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1019 Lawton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5991060.29058 | 2104484.56084 | 37.7579989703891 | -122.473964824336 | (37.7579989703891, -122.473964824336) | 1 | 8 | 4 | 56 | 12 | |||
76572 | 223055 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 42 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6002598.631 | 2096412.43412 | 37.7364963969952 | -122.433483533142 | (37.7364963969952, -122.433483533142) | 2 | 7 | 5 | 63 | 7 | |||
99367 | 176074 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 786 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6001892.13578 | 2089268.05693 | 37.7168394482606 | -122.435415271495 | (37.7168394482606, -122.435415271495) | 9 | 7 | 6 | 28861 | 5 | |||
114457 | 206501 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 245 Lawton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5993462.44278 | 2104571.82213 | 37.7583774159051 | -122.465663569242 | (37.7583774159051, -122.465663569242) | 1 | 8 | 4 | 56 | 12 | |||
114669 | 206502 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 245 Lawton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5993453.26762 | 2104570.92091 | 37.7583744121607 | -122.465695235269 | (37.7583744121607, -122.465695235269) | 1 | 8 | 4 | 56 | 12 | |||
114901 | 126377 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 122 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6001345.97363 | 2121147.25207 | 37.8043408951819 | -122.439587150049 | (37.8043408951819, -122.439587150049) | 13 | 9 | 1 | 57 | 17 | |||
117905 | 206513 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1023 Lawton St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5990992.34085 | 2104483.78156 | 37.757992894562 | -122.47419976413 | (37.757992894562, -122.47419976413) | 1 | 8 | 4 | 56 | 12 | |||
119257 | 223030 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 125 Belgrave Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5997950.67072 | 2104889.0935 | 37.7595064230002 | -122.450164233094 | (37.7595064230002, -122.450164233094) | 15 | 5 | 11 | 28862 | 12 | |||
124950 | 176073 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 774 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6001923.16259 | 2089317.3719 | 37.7169766182659 | -122.43531155268 | (37.7169766182659, -122.43531155268) | 9 | 7 | 6 | 28861 | 5 | |||
126152 | 206533 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 665 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5995361.50595 | 2093791.16395 | 37.7288857636427 | -122.458315510062 | (37.7288857636427, -122.458315510062) | 9 | 7 | 4 | 28861 | 40 | |||
126227 | 206696 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 230 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6000774.6257 | 2094855.98841 | 37.7321191034008 | -122.439678327791 | (37.7321191034008, -122.439678327791) | 9 | 7 | 4 | 63 | 40 | |||
128797 | 206534 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 665 Miramar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5995362.10243 | 2093779.40423 | 37.7288535085691 | -122.458312597175 | (37.7288535085691, -122.458312597175) | 9 | 7 | 4 | 28861 | 40 | |||
130434 | 206512 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1023 Lawton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5990980.22345 | 2104481.19226 | 37.7579850830548 | -122.474241481884 | (37.7579850830548, -122.474241481884) | 1 | 8 | 4 | 56 | 12 | |||
136667 | 206535 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 665 Miramar Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5995362.41808 | 2093767.65006 | 37.7288212525964 | -122.458310655534 | (37.7288212525964, -122.458310655534) | 9 | 7 | 4 | 28861 | 40 | |||
140979 | 206548 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 160 Dorantes Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5993741.10567 | 2099827.07051 | 37.7453656117262 | -122.464355354239 | (37.7453656117262, -122.464355354239) | 1 | 8 | 4 | 29491 | 40 | |||
155534 | 206514 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1023 Lawton St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5991006.3222 | 2104484.4348 | 37.7579954981234 | -122.474151458838 | (37.7579954981234, -122.474151458838) | 1 | 8 | 4 | 56 | 12 | |||
159595 | 206508 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1023 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5990927.20691 | 2104481.04629 | 37.7579816107755 | -122.474424823051 | (37.7579816107755, -122.474424823051) | 1 | 8 | 4 | 56 | 12 | |||
167985 | 206518 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1019 Lawton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5991072.98938 | 2104484.60902 | 37.7579998382313 | -122.473920910448 | (37.7579998382313, -122.473920910448) | 1 | 8 | 4 | 56 | 12 | |||
181480 | 206515 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1019 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5991033.61709 | 2104484.17502 | 37.7579963659675 | -122.474057043516 | (37.7579963659675, -122.474057043516) | 1 | 8 | 4 | 56 | 12 | |||
192064 | 223029 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 170 Belgrave Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5997728.70717 | 2104908.9589 | 37.75954826396 | -122.450933321612 | (37.75954826396, -122.450933321612) | 15 | 5 | 11 | 29492 | 12 |
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) );