trees
61 rows where Zip Codes = 29490 and qSpecies_id = 162
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
74594 | 26720 | DPW Maintained 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1203X Webster St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6003742.20526 | 2112831.75991 | 37.7816447668943 | -122.430701039692 | (37.7816447668943, -122.430701039692) | 15 | 9 | 11 | 29490 | 41 | |||
76359 | 26443 | DPW Maintained 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1430 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 6003606.97335 | 2112834.41067 | 37.7816443828524 | -122.431169066991 | (37.7816443828524, -122.431169066991) | 15 | 9 | 11 | 29490 | 41 | |||
78486 | 94301 | Significant Tree 6 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1150X Fillmore St | 5 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | |||||
79085 | 26721 | DPW Maintained 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1203X Webster St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6003742.20526 | 2112831.75991 | 37.7816447668943 | -122.430701039692 | (37.7816447668943, -122.430701039692) | 15 | 9 | 11 | 29490 | 41 | |||
80702 | 103188 | DPW Maintained 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1125 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6003319.4 | 2112265.6 | 37.7800662706417 | -122.432123301144 | (37.7800662706417, -122.432123301144) | 15 | 9 | 11 | 29490 | 41 | |||
89137 | 103239 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1240 Fillmore St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003317 | 2112564 | 37.7808854664086 | -122.432152919664 | (37.7808854664086, -122.432152919664) | 15 | 9 | 11 | 29490 | 41 | ||||
93396 | 26439 | DPW Maintained 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1410 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 6003703.23726 | 2112842.65121 | 37.7816724639119 | -122.430836627926 | (37.7816724639119, -122.430836627926) | 15 | 9 | 11 | 29490 | 41 | |||
94027 | 26445 | DPW Maintained 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1442 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2X2 | 6003549.33255 | 2112826.4539 | 37.7816192690049 | -122.431367908549 | (37.7816192690049, -122.431367908549) | 15 | 9 | 11 | 29490 | 41 | |||
102520 | 94372 | DPW Maintained 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1633 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 4x4 | 6003065.02645 | 2113947.68581 | 37.7846704302621 | -122.433123511568 | (37.7846704302621, -122.433123511568) | 13 | 9 | 11 | 29490 | 13 | |||
109943 | 29075 | DPW Maintained 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1146 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/15/2005 12:00:00 AM | 3 | 3x3 | 6004514.09191 | 2112609.33919 | 37.7810777550034 | -122.428014822778 | (37.7810777550034, -122.428014822778) | 7 | 9 | 11 | 29490 | 41 | ||
111460 | 22621 | DPW Maintained 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1100X Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/15/2005 12:00:00 AM | 3 | 4x4 | 6004069.05987 | 2112481.21433 | 37.7807007681203 | -122.429545270382 | (37.7807007681203, -122.429545270382) | 7 | 9 | 11 | 29490 | 41 | ||
111521 | 26440 | DPW Maintained 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1410 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 6003703.23726 | 2112842.65121 | 37.7816724639119 | -122.430836627926 | (37.7816724639119, -122.430836627926) | 15 | 9 | 11 | 29490 | 41 | |||
120173 | 5950 | DPW Maintained 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1499X Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6003288.58523 | 2112739.98604 | 37.7813670689673 | -122.432263792423 | (37.7813670689673, -122.432263792423) | 15 | 9 | 11 | 29490 | 41 | ||
120446 | 26444 | DPW Maintained 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1434 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 6003588.47201 | 2112826.80892 | 37.7816224618989 | -122.431232530045 | (37.7816224618989, -122.431232530045) | 15 | 9 | 11 | 29490 | 41 | |||
120826 | 103181 | DPW Maintained 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1125 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6003319.4 | 2112265.6 | 37.7800662706417 | -122.432123301144 | (37.7800662706417, -122.432123301144) | 15 | 9 | 11 | 29490 | 41 | |||
122963 | 12332 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1105X Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6004706.62549 | 2112590.71039 | 37.7810374956819 | -122.427347425327 | (37.7810374956819, -122.427347425327) | 7 | 9 | 11 | 29490 | 41 | ||
125310 | 94299 | Significant Tree 6 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1150X Fillmore St | 4 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | |||||
128969 | 103167 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1201X Fillmore St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003055.6 | 2112559.2 | 37.7808574628324 | -122.43305688657 | (37.7808574628324, -122.43305688657) | 15 | 9 | 11 | 29490 | 41 | ||||
129932 | 45608 | DPW Maintained 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1100X Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/06/2001 12:00:00 AM | 2 | Permit Number 44335 | 6003389.50485138 | 2112095.5826587 | 37.7796034198271 | -122.431868633724 | (37.7796034198271, -122.431868633724) | 15 | 9 | 11 | 29490 | 41 | ||
132671 | 103165 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1201X Fillmore St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003055.6 | 2112559.2 | 37.7808574628324 | -122.43305688657 | (37.7808574628324, -122.43305688657) | 15 | 9 | 11 | 29490 | 41 | ||||
133799 | 103242 | DPW Maintained 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1290 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6003293 | 2112734 | 37.7813508831163 | -122.432248091846 | (37.7813508831163, -122.432248091846) | 15 | 9 | 11 | 29490 | 41 | |||
136721 | 103205 | DPW Maintained 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1113 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6003277.3 | 2112173.6 | 37.7798112746289 | -122.432262371693 | (37.7798112746289, -122.432262371693) | 15 | 9 | 11 | 29490 | 41 | ||||
138711 | 103164 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1201X Fillmore St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003055.6 | 2112559.2 | 37.7808574628324 | -122.43305688657 | (37.7808574628324, -122.43305688657) | 15 | 9 | 11 | 29490 | 41 | ||||
143287 | 103243 | DPW Maintained 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1290 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6003293 | 2112734 | 37.7813508831163 | -122.432248091846 | (37.7813508831163, -122.432248091846) | 15 | 9 | 11 | 29490 | 41 | |||
146493 | 103241 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1240 Fillmore St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003317 | 2112564 | 37.7808854664086 | -122.432152919664 | (37.7808854664086, -122.432152919664) | 15 | 9 | 11 | 29490 | 41 | ||||
150341 | 26715 | DPW Maintained 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1203X Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 6003742.20526 | 2112831.75991 | 37.7816447668943 | -122.430701039692 | (37.7816447668943, -122.430701039692) | 15 | 9 | 11 | 29490 | 41 | |||
153059 | 26716 | DPW Maintained 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1203X Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6003742.20526 | 2112831.75991 | 37.7816447668943 | -122.430701039692 | (37.7816447668943, -122.430701039692) | 15 | 9 | 11 | 29490 | 41 | |||
153073 | 94297 | Significant Tree 6 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1150X Fillmore St | 3 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | |||||
156305 | 22630 | DPW Maintained 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1170 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6004485.54362 | 2112758.65341 | 37.7814861196775 | -122.428124229573 | (37.7814861196775, -122.428124229573) | 7 | 9 | 11 | 29490 | 41 | ||
158977 | 5952 | DPW Maintained 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1499X Eddy St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6003344.76358 | 2112747.58282 | 37.781391112972 | -122.432069985491 | (37.781391112972, -122.432069985491) | 15 | 9 | 11 | 29490 | 41 | ||
159118 | 26441 | DPW Maintained 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1422 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2X2 | 6003645.85463 | 2112834.73007 | 37.7816474630851 | -122.43103457907 | (37.7816474630851, -122.43103457907) | 15 | 9 | 11 | 29490 | 41 | |||
159685 | 103244 | DPW Maintained 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1290 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6003293 | 2112734 | 37.7813508831163 | -122.432248091846 | (37.7813508831163, -122.432248091846) | 15 | 9 | 11 | 29490 | 41 | |||
178520 | 26446 | DPW Maintained 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1446 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2x2 | 6003531.77334 | 2112813.93522 | 37.7815839006792 | -122.431427761093 | (37.7815839006792, -122.431427761093) | 15 | 9 | 11 | 29490 | 41 | |||
180041 | 103162 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1201X Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003055.6 | 2112559.2 | 37.7808574628324 | -122.43305688657 | (37.7808574628324, -122.43305688657) | 15 | 9 | 11 | 29490 | 41 | ||||
181097 | 103175 | DPW Maintained 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1125 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6003319.4 | 2112265.6 | 37.7800662706417 | -122.432123301144 | (37.7800662706417, -122.432123301144) | 15 | 9 | 11 | 29490 | 41 | |||
183100 | 103210 | DPW Maintained 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1113 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/08/2013 12:00:00 AM | 3x3 | 6003277.3 | 2112173.6 | 37.7798112746289 | -122.432262371693 | (37.7798112746289, -122.432262371693) | 15 | 9 | 11 | 29490 | 41 | |||
184436 | 103202 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1117 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003337 | 2112136 | 37.7797114192122 | -122.432053157487 | (37.7797114192122, -122.432053157487) | 15 | 9 | 11 | 29490 | 41 | ||||
190661 | 117083 | DPW Maintained 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1548 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 5x5 | 6003183 | 2113711 | 37.7840272420603 | -122.432698449568 | (37.7840272420603, -122.432698449568) | 13 | 9 | 11 | 29490 | 41 | |||
191009 | 29074 | DPW Maintained 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1149 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/15/2005 12:00:00 AM | 3 | 3x3 | 6004485.54395 | 2112758.65374 | 37.7814861206023 | -122.428124228455 | (37.7814861206023, -122.428124228455) | 7 | 9 | 11 | 29490 | 41 | ||
192340 | 103236 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1240 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003317 | 2112564 | 37.7808854664086 | -122.432152919664 | (37.7808854664086, -122.432152919664) | 15 | 9 | 11 | 29490 | 41 |
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) );