trees
138 rows where Zip Codes = 55 and qCaretaker_id = 4 sorted by Latitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
69617 | 95465 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 601X 30th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5986594.5418 | 2111220.34134 | 37.7762338621769 | -122.489904464478 | (37.7762338621769, -122.489904464478) | 11 | 6 | 2 | 55 | 26 | ||
125188 | 95464 | 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 | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5986592.75422 | 2111242.97331 | 37.7762958987751 | -122.489912313045 | (37.7762958987751, -122.489912313045) | 11 | 6 | 2 | 55 | 26 | |
113585 | 95463 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5986592.12306 | 2111264.12941 | 37.7763539505765 | -122.489916052727 | (37.7763539505765, -122.489916052727) | 11 | 6 | 2 | 55 | 26 | |
93459 | 95462 | 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 | 5986590.67553 | 2111282.39545 | 37.7764040194223 | -122.489922403821 | (37.7764040194223, -122.489922403821) | 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 | |||
23432 | 95461 | 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 | 5986588.1418 | 2111391.86812 | 37.7767044523908 | -122.489939222082 | (37.7767044523908, -122.489939222082) | 11 | 6 | 2 | 55 | 26 | ||
62037 | 95492 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 600X 32nd Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | 3x3 | 5986013.63252 | 2111419.06509 | 37.7767455639501 | -122.491928594276 | (37.7767455639501, -122.491928594276) | 11 | 6 | 2 | 55 | 26 | |||
18124 | 95460 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5986585.7747 | 2111417.7398 | 37.7767753504668 | -122.489949313769 | (37.7767753504668, -122.489949313769) | 11 | 6 | 2 | 55 | 26 | |
118940 | 95491 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5986009.30138 | 2111441.61533 | 37.7768072273274 | -122.491945237383 | (37.7768072273274, -122.491945237383) | 11 | 6 | 2 | 55 | 26 | |||
51914 | 95459 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 657X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 18 | 3x3 | 5986588.2 | 2111449.2 | 37.776861872872 | -122.489943238472 | (37.776861872872, -122.489943238472) | 11 | 6 | 2 | 55 | 26 | ||
66912 | 95490 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5986007.65609 | 2111463.21002 | 37.7768664240251 | -122.491952519112 | (37.7768664240251, -122.491952519112) | 11 | 6 | 2 | 55 | 26 | |||
112874 | 95489 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | 3x3 | 5986007.8525 | 2111486.56221 | 37.7769305539658 | -122.491953559362 | (37.7769305539658, -122.491953559362) | 11 | 6 | 2 | 55 | 26 | |||
105937 | 95458 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5986582.44659 | 2111474.61787 | 37.7769313271764 | -122.489965010922 | (37.7769313271764, -122.489965010922) | 11 | 6 | 2 | 55 | 26 | |
111453 | 95488 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | 3x3 | 5986007.7101 | 2111508.12486 | 37.776989750535 | -122.491955639862 | (37.776989750535, -122.491955639862) | 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 | ||
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 | |||
104893 | 95486 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5986007.39345 | 2111549.75354 | 37.7771040325177 | -122.491959800837 | (37.7771040325177, -122.491959800837) | 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 | |||
88671 | 95484 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 15 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | 3x3 | 5986002.98697 | 2111639.37953 | 37.7773498623685 | -122.491981644298 | (37.7773498623685, -122.491981644298) | 11 | 6 | 2 | 55 | 26 | |||
140462 | 95497 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | 3x3 | 5985999.23129 | 2111660.71954 | 37.7774082364223 | -122.491996207782 | (37.7774082364223, -122.491996207782) | 11 | 6 | 2 | 55 | 26 | |||
103512 | 95456 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5986576.02446 | 2111660.34524 | 37.7774409068096 | -122.490000890521 | (37.7774409068096, -122.490000890521) | 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 | |||
117212 | 95495 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600X 32nd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | 3x3 | 5986000.95497 | 2111699.3103 | 37.7775142963957 | -122.491993087037 | (37.7775142963957, -122.491993087037) | 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 | ||
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 | |||
46265 | 95452 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986573.32223 | 2111731.41091 | 37.7776358751612 | -122.490015466607 | (37.7776358751612, -122.490015466607) | 11 | 6 | 2 | 55 | 26 | ||
113014 | 95451 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986574.08529 | 2111752.05161 | 37.7776925932181 | -122.490014345501 | (37.7776925932181, -122.490014345501) | 11 | 6 | 2 | 55 | 26 | ||
33781 | 95450 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5986571.54012 | 2111769.53516 | 37.7777404494553 | -122.49002443627 | (37.7777404494553, -122.49002443627) | 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 | ||
8399 | 95483 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 17 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 5986569.82886 | 2111856.71768 | 37.7779797279503 | -122.490036770148 | (37.7779797279503, -122.490036770148) | 11 | 6 | 2 | 55 | 26 | ||
23043 | 95519 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5 | 3x3 | 5985993.74648 | 2111883.31804 | 37.7780191077803 | -122.49203157445 | (37.7780191077803, -122.49203157445) | 11 | 6 | 2 | 55 | 26 | |||
51466 | 95482 | 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 | 5986568.36529 | 2111879.34223 | 37.7780417630679 | -122.490043497613 | (37.7780417630679, -122.490043497613) | 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 | |||
4799 | 95481 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5986568.37611 | 2111910.32722 | 37.778126839673 | -122.490045739805 | (37.778126839673, -122.490045739805) | 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 | |||
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 | |||
23321 | 95480 | 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 | 5986567.36684 | 2111939.07455 | 37.7782057127303 | -122.490051346189 | (37.7782057127303, -122.490051346189) | 11 | 6 | 2 | 55 | 26 | ||
8020 | 95515 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | 3x3 | 5985992.57608 | 2111969.58011 | 37.7782558903759 | -122.492041976045 | (37.7782558903759, -122.492041976045) | 11 | 6 | 2 | 55 | 26 | |||
11601 | 95514 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 02/19/2015 02:29:00 PM | 3 | 3x3 | 5985991.7561 | 2111987.56369 | 37.7783052202186 | -122.492046137036 | (37.7783052202186, -122.492046137036) | 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 | ||
102251 | 95513 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | 3x3 | 5985988.88946 | 2112008.28561 | 37.7783619491242 | -122.49205757976 | (37.7783619491242, -122.49205757976) | 11 | 6 | 2 | 55 | 26 | |||
58702 | 95478 | 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 | 5986565.85749 | 2112005.2728 | 37.7783873861575 | -122.490061437886 | (37.7783873861575, -122.490061437886) | 11 | 6 | 2 | 55 | 26 | ||
106937 | 95512 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 600X 32nd Ave | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 10 | 3x3 | 5985990.17986 | 2112026.52369 | 37.7784121011104 | -122.492054459017 | (37.7784121011104, -122.492054459017) | 11 | 6 | 2 | 55 | 26 | |||
28985 | 95477 | 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 | 5986565.00775 | 2112026.27031 | 37.7784449897253 | -122.490065922262 | (37.7784449897253, -122.490065922262) | 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 | ||
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 | ||
44906 | 95475 | 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 | 5986561.73612 | 2112070.55828 | 37.7785664008394 | -122.490080498329 | (37.7785664008394, -122.490080498329) | 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 | ||
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 | ||
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 | |||
41997 | 95473 | 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 | 5986560.12785 | 2112162.57896 | 37.7788189695175 | -122.490092832211 | (37.7788189695175, -122.490092832211) | 11 | 6 | 2 | 55 | 26 | ||
56509 | 95507 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 600X 32nd Ave | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 10 | 3x3 | 5985983.58763 | 2112182.96811 | 37.7788412674233 | -122.492088785464 | (37.7788412674233, -122.492088785464) | 11 | 6 | 2 | 55 | 26 | |||
129627 | 95506 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 600X 32nd Ave | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | 3X3 | 5985984.41707 | 2112207.80318 | 37.7789095059085 | -122.4920877452 | (37.7789095059085, -122.4920877452) | 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 | ||
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 | ||
123758 | 95505 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 600X 32nd Ave | 15 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5985982.87909 | 2112248.55872 | 37.7790213190615 | -122.492096067193 | (37.7790213190615, -122.492096067193) | 11 | 6 | 2 | 55 | 26 | |||
71210 | 95454 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986556.01855 | 2112243.67907 | 37.7790414073553 | -122.490113014651 | (37.7790414073553, -122.490113014651) | 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 | |||
70160 | 95470 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 539X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | 5986557.7 | 2112257.8 | 37.7790802775989 | -122.490108236864 | (37.7790802775989, -122.490108236864) | 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 | ||
123553 | 95503 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 500X 32nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 8 | 3x3 | 5985983.49633 | 2112291.66361 | 37.7791397088392 | -122.492097106557 | (37.7791397088392, -122.492097106557) | 11 | 6 | 2 | 55 | 26 | |||
115615 | 95468 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 535X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/12/2011 12:00:00 AM | 3 | 3x3 | 53267 | 5986556.7 | 2112284.6 | 37.7791538043677 | -122.490113668043 | (37.7791538043677, -122.490113668043) | 11 | 6 | 2 | 55 | 26 |
134117 | 95467 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 533X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | 5986556.1 | 2112298 | 37.7791905619119 | -122.490116729573 | (37.7791905619119, -122.490116729573) | 11 | 6 | 2 | 55 | 26 | ||
46093 | 95466 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 529X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 5986555.1 | 2112324.8 | 37.7792640886788 | -122.490122160768 | (37.7792640886788, -122.490122160768) | 11 | 6 | 2 | 55 | 26 | ||
113363 | 95502 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 500X 32nd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5985980.32699 | 2112340.5385 | 37.7792737200362 | -122.492111670045 | (37.7792737200362, -122.492111670045) | 11 | 6 | 2 | 55 | 26 | |||
48931 | 95501 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 500X 32nd Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 8 | 3x3 | 5985979.29593 | 2112362.71829 | 37.7793345591202 | -122.492116870392 | (37.7793345591202, -122.492116870392) | 11 | 6 | 2 | 55 | 26 | |||
110253 | 95500 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 500X 32nd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 8 | 3x3 | 5985980.30461 | 2112381.8602 | 37.7793871762895 | -122.492114790789 | (37.7793871762895, -122.492114790789) | 11 | 6 | 2 | 55 | 26 | |||
118868 | 95499 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500X 32nd Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 18 | 3x3 | 5985977.73249 | 2112402.27637 | 37.7794430828921 | -122.49212519236 | (37.7794430828921, -122.49212519236) | 11 | 6 | 2 | 55 | 26 | |||
38417 | 95498 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500X 32nd Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 18 | 3x3 | 5985976.05543 | 2112422.37376 | 37.7794981665366 | -122.492132474117 | (37.7794981665366, -122.492132474117) | 11 | 6 | 2 | 55 | 26 | |||
85468 | 95510 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 500X 32nd Ave | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 02/19/2015 02:35:00 PM | 3 | 3x3 | 5985969.9 | 2112493.2 | 37.7796922752829 | -122.492158984519 | (37.7796922752829, -122.492158984519) | 11 | 6 | 2 | 55 | 26 | ||
18070 | 99372 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 499X 29th Ave | 26 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 3x3 | 5986859.5 | 2112566.5 | 37.7799454996166 | -122.489086903101 | (37.7799454996166, -122.489086903101) | 11 | 6 | 2 | 55 | 26 | ||
126742 | 99373 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 499X 29th Ave | 27 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5986859.5 | 2112566.5 | 37.7799454996166 | -122.489086903101 | (37.7799454996166, -122.489086903101) | 11 | 6 | 2 | 55 | 26 | ||
55540 | 60316 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/07/1982 12:00:00 AM | 8 | 4x4 | 5986588.61699 | 2112633.05068 | 37.7801124144217 | -122.490028891926 | (37.7801124144217, -122.490028891926) | 11 | 6 | 2 | 55 | 26 | |
34496 | 99371 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 25 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5986853.20034 | 2112633.29686 | 37.7801285370834 | -122.489113608336 | (37.7801285370834, -122.489113608336) | 11 | 6 | 2 | 55 | 26 | ||
71997 | 99370 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 24 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986851.72562 | 2112647.47743 | 37.7801673868145 | -122.489119752829 | (37.7801673868145, -122.489119752829) | 11 | 6 | 2 | 55 | 26 | ||
36069 | 99326 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986588.88353 | 2112653.99552 | 37.7801699385412 | -122.490029510836 | (37.7801699385412, -122.490029510836) | 11 | 6 | 2 | 55 | 26 | ||
110143 | 99327 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | 5986588.01582 | 2112673.64698 | 37.7802238451734 | -122.490033958427 | (37.7802238451734, -122.490033958427) | 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 | ||
127671 | 99328 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5986586.09055 | 2112693.96092 | 37.7802795090296 | -122.490042113304 | (37.7802795090296, -122.490042113304) | 11 | 6 | 2 | 55 | 26 | ||
142644 | 99368 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 22 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5986849.57732 | 2112692.62378 | 37.7802912204421 | -122.489130504747 | (37.7802912204421, -122.489130504747) | 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 | ||
44884 | 99367 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 21 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5986848.24353 | 2112713.43374 | 37.7803482808136 | -122.489136649255 | (37.7803482808136, -122.489136649255) | 11 | 6 | 2 | 55 | 26 | ||
75748 | 47199 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/08/2002 12:00:00 AM | 8 | 4x4 | Permit Number 45157 | 5986584.12235 | 2112732.41489 | 37.7803849777225 | -122.490051751347 | (37.7803849777225, -122.490051751347) | 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 | ||
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 |
136557 | 99365 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 19 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5986845.14154 | 2112755.50502 | 37.7804636155038 | -122.489150474302 | (37.7804636155038, -122.489150474302) | 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 | ||
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 | |
23426 | 99331 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986581.6367 | 2112796.91447 | 37.7805619300043 | -122.490065095801 | (37.7805619300043, -122.490065095801) | 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 | |
75990 | 99332 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 4x4 | 5986580.56369 | 2112816.99686 | 37.7806170078534 | -122.490070285368 | (37.7806170078534, -122.490070285368) | 11 | 6 | 2 | 55 | 26 | ||
85465 | 99333 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 30 | 4x4 | 5986581.86078 | 2112837.66907 | 37.7806738435833 | -122.490067319136 | (37.7806738435833, -122.490067319136) | 11 | 6 | 2 | 55 | 26 | ||
69455 | 99362 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 16 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986843.02407 | 2112864.76375 | 37.7807634852432 | -122.489165834601 | (37.7807634852432, -122.489165834601) | 11 | 6 | 2 | 55 | 26 | ||
123461 | 99334 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 450 30th Ave | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | 5986579.77919 | 2112870.79018 | 37.7807646631349 | -122.490076957163 | (37.7807646631349, -122.490076957163) | 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 | |
113863 | 99361 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 15 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986841.31224 | 2112888.67684 | 37.7808290438523 | -122.489173515193 | (37.7808290438523, -122.489173515193) | 11 | 6 | 2 | 55 | 26 | ||
32232 | 99335 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 450 30th Ave | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 30 | 3.5x3.5 | 5986578.25407 | 2112899.8451 | 37.780844350584 | -122.490084370963 | (37.780844350584, -122.490084370963) | 11 | 6 | 2 | 55 | 26 | ||
98082 | 99360 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5986841.26301 | 2112907.24873 | 37.7808800340934 | -122.489175051323 | (37.7808800340934, -122.489175051323) | 11 | 6 | 2 | 55 | 26 | ||
64192 | 99336 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 450 30th Ave | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5986577.60051 | 2112919.49158 | 37.7808982560395 | -122.490088077428 | (37.7808982560395, -122.490088077428) | 11 | 6 | 2 | 55 | 26 | ||
80354 | 99359 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986842.11085 | 2112926.24344 | 37.7809322376389 | -122.489173515185 | (37.7809322376389, -122.489173515185) | 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) );