trees
138 rows where Neighborhoods (old) = 26 and qCaretaker_id = 4 sorted by qCaretaker_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
143111 | 99364 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 18 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | Permit Number 773617 | 5986846.87705 | 2112774.48123 | 37.7805158200694 | -122.489145865965 | (37.7805158200694, -122.489145865965) | 11 | 6 | 2 | 55 | 26 | |
145506 | 95508 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 600X 32nd Ave | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 8 | 3x3 | 5985983.44854 | 2112162.31032 | 37.7787845389083 | -122.492087745218 | (37.7787845389083, -122.492087745218) | 11 | 6 | 2 | 55 | 26 | |||
148520 | 99343 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 450 30th Ave | 21 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 24 | 3x3 | 5986574.07493 | 2113086.23058 | 37.781355867791 | -122.490112542148 | (37.781355867791, -122.490112542148) | 11 | 6 | 2 | 55 | 26 | ||
149215 | 99352 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5986835.92891 | 2113074.05562 | 37.7813377268782 | -122.489205771916 | (37.7813377268782, -122.489205771916) | 11 | 6 | 2 | 55 | 26 | ||
149298 | 95153 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 250 23rd Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 18 | 5988721.45224 | 2113658.22406 | 37.783051567455 | -122.482725682991 | (37.783051567455, -122.482725682991) | 11 | 6 | 2 | 55 | 26 | |||
149644 | 95479 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5986565.4115 | 2111984.30283 | 37.7783297825409 | -122.490061437893 | (37.7783297825409, -122.490061437893) | 11 | 6 | 2 | 55 | 26 | ||
150203 | 99348 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5986834.12581 | 2113156.33503 | 37.7815635374039 | -122.489218060874 | (37.7815635374039, -122.489218060874) | 11 | 6 | 2 | 55 | 26 | ||
152325 | 95504 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 500X 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5985982.4173 | 2112269.22924 | 37.7790780474023 | -122.492099187045 | (37.7790780474023, -122.492099187045) | 11 | 6 | 2 | 55 | 26 | |||
152853 | 95517 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 10 | 3x3 | 5985993.99278 | 2111923.13747 | 37.778128454962 | -122.492033654936 | (37.778128454962, -122.492033654936) | 11 | 6 | 2 | 55 | 26 | |||
154427 | 95448 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986572.26887 | 2111788.56268 | 37.7777927361738 | -122.490023315176 | (37.7777927361738, -122.490023315176) | 11 | 6 | 2 | 55 | 26 | ||
154949 | 95476 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986563.84754 | 2112047.92011 | 37.778504366165 | -122.490071528655 | (37.778504366165, -122.490071528655) | 11 | 6 | 2 | 55 | 26 | ||
155407 | 99339 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 17 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 3.5x3.5 | 5986576.13047 | 2112991.43823 | 37.7810957151351 | -122.490098456538 | (37.7810957151351, -122.490098456538) | 11 | 6 | 2 | 55 | 26 | ||
160497 | 95509 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 02/19/2015 02:37:00 PM | 3 | 3x3 | 5985988.58257 | 2112092.73248 | 37.7785937981587 | -122.492064860632 | (37.7785937981587, -122.492064860632) | 11 | 6 | 2 | 55 | 26 | ||
161839 | 95485 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 10 | 3x3 | 5986006.6183 | 2111569.83262 | 37.7771591186395 | -122.491963960946 | (37.7771591186395, -122.491963960946) | 11 | 6 | 2 | 55 | 26 | |||
163049 | 95455 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5986575.69735 | 2111690.69221 | 37.7775242118699 | -122.490004254704 | (37.7775242118699, -122.490004254704) | 11 | 6 | 2 | 55 | 26 | ||
164971 | 95474 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5986559.68186 | 2112141.60911 | 37.7787613662348 | -122.490092832202 | (37.7787613662348, -122.490092832202) | 11 | 6 | 2 | 55 | 26 | ||
165116 | 99363 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 17 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | Permit Number 773617 | 5986845.56233 | 2112796.17507 | 37.7805753084335 | -122.489152009534 | (37.7805753084335, -122.489152009534) | 11 | 6 | 2 | 55 | 26 | |
165795 | 95471 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | 5986558.17112 | 2112222.97674 | 37.778984690357 | -122.49010404497 | (37.778984690357, -122.49010404497) | 11 | 6 | 2 | 55 | 26 | ||
166185 | 95516 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5 | 3x3 | 5985994.45155 | 2111944.68724 | 37.7781876512929 | -122.492033654948 | (37.7781876512929, -122.492033654948) | 11 | 6 | 2 | 55 | 26 | |||
166601 | 95494 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5986000.13497 | 2111717.29406 | 37.7775636267397 | -122.491997248036 | (37.7775636267397, -122.491997248036) | 11 | 6 | 2 | 55 | 26 | |||
170197 | 99330 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 4x4 | 5986582.50919 | 2112777.47658 | 37.780508610058 | -122.490060647344 | (37.780508610058, -122.490060647344) | 11 | 6 | 2 | 55 | 26 | ||
173471 | 99329 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 5986584.84396 | 2112715.96758 | 37.7803398602424 | -122.490048044897 | (37.7803398602424, -122.490048044897) | 11 | 6 | 2 | 55 | 26 | ||
174849 | 47197 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2899X Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/08/2002 12:00:00 AM | 3 | 3x3 | 5986581.22601267 | 2112881.07204474 | 37.7807929786872 | -122.490072708464 | (37.7807929786872, -122.490072708464) | 11 | 6 | 2 | 55 | 26 | |
176883 | 99366 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 20 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5986848.25067 | 2112734.65735 | 37.7804065552175 | -122.489138185351 | (37.7804065552175, -122.489138185351) | 11 | 6 | 2 | 55 | 26 | ||
177073 | 95511 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 02/19/2015 02:32:00 PM | 3 | 3x3 | 5985988.37339 | 2112068.78219 | 37.7785280252799 | -122.492063820389 | (37.7785280252799, -122.492063820389) | 11 | 6 | 2 | 55 | 26 | ||
178939 | 47202 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2801X Clement St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/08/2002 12:00:00 AM | 12 | 3x3 | Permit Number 45157 | 5986698.68199 | 2113217.08014 | 37.7817224192006 | -122.489691093913 | (37.7817224192006, -122.489691093913) | 11 | 6 | 2 | 55 | 26 |
181422 | 99357 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5986839.06552 | 2112970.96623 | 37.7810548559101 | -122.489187339385 | (37.7810548559101, -122.489187339385) | 11 | 6 | 2 | 55 | 26 | ||
183752 | 95147 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 250 23rd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 13 | 5988726.59645 | 2113538.2792 | 37.7827225319963 | -122.482699093759 | (37.7827225319963, -122.482699093759) | 11 | 6 | 2 | 55 | 26 | |||
185821 | 95518 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5 | 3x3 | 5985992.05689 | 2111902.81718 | 37.7780725480885 | -122.492038855286 | (37.7780725480885, -122.492038855286) | 11 | 6 | 2 | 55 | 26 | |||
185924 | 95496 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 600X 32nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5 | 3x3 | 5986002.12653 | 2111683.71465 | 37.7774715436696 | -122.491987885766 | (37.7774715436696, -122.491987885766) | 11 | 6 | 2 | 55 | 26 | |||
187692 | 95457 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986582.95432 | 2111498.49198 | 37.776996908357 | -122.489965010916 | (37.776996908357, -122.489965010916) | 11 | 6 | 2 | 55 | 26 | ||
188415 | 99369 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 23 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 3x3 | 5986847.81361 | 2112672.32158 | 37.7802353734381 | -122.489135113122 | (37.7802353734381, -122.489135113122) | 11 | 6 | 2 | 55 | 26 | ||
188665 | 47198 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/08/2002 12:00:00 AM | 8 | 4x4 | Permit Number 45157 | 5986584.00139 | 2112756.95832 | 37.7804523599117 | -122.490053975567 | (37.7804523599117, -122.490053975567) | 11 | 6 | 2 | 55 | 26 |
189654 | 95453 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986555.22372 | 2112267.25724 | 37.7791060998783 | -122.490117499027 | (37.7791060998783, -122.490117499027) | 11 | 6 | 2 | 55 | 26 | ||
191029 | 95148 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 250 23rd Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 5988724.77962 | 2113566.52719 | 37.7827999873072 | -122.482707449869 | (37.7827999873072, -122.482707449869) | 11 | 6 | 2 | 55 | 26 | |||
191041 | 95487 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5986008.46306 | 2111529.36899 | 37.7770481248733 | -122.491954599624 | (37.7770481248733, -122.491954599624) | 11 | 6 | 2 | 55 | 26 | |||
191220 | 95472 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986558.09049 | 2112203.93573 | 37.7789324044573 | -122.490102922958 | (37.7789324044573, -122.490102922958) | 11 | 6 | 2 | 55 | 26 | ||
194074 | 95493 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 600X 32nd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | 3x3 | 5986013.17376 | 2111397.5149 | 37.7766863664514 | -122.491928594282 | (37.7766863664514, -122.491928594282) | 11 | 6 | 2 | 55 | 26 |
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) );