trees
7,322 rows where qSpecies_id = 1 sorted by Zip Codes descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 93859 | 218574 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 95 Rossmoor Dr | 3 | : | Tree | Private 2 | 7 | Width 3ft | 5990724.62929 | 2094434.60047 | 37.730384930811 | -122.474392290997 | (37.730384930811, -122.474392290997) | 9 | 8 | 4 | 64 | 40 | |||
| 94073 | 32176 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 171 Lakeshore Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35513 | 5984396.34237134 | 2094161.85808413 | 37.7292673830802 | -122.496249618321 | (37.7292673830802, -122.496249618321) | 1 | 8 | 4 | 64 | 35 | ||
| 95015 | 218489 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 471 Orizaba Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994001.40662 | 2089639.16253 | 37.7174071201144 | -122.462716356901 | (37.7174071201144, -122.462716356901) | 9 | 8 | 6 | 64 | 24 | |||
| 95780 | 357 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3690X 19th Ave | 4 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 2 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) | 9 | 8 | 4 | 64 | 40 | ||
| 96790 | 238 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3007 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2006 12:00:00 AM | 6 | 2 | 5990525.39569 | 2095120.45771 | 37.7322565763444 | -122.47513111186 | (37.7322565763444, -122.47513111186) | 1 | 8 | 4 | 64 | 35 | ||
| 97522 | 45493 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3017 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2001 12:00:00 AM | 5 | Permit Number 44269 | 5989985.33852 | 2095139.43836 | 37.7322773768865 | -122.476999578465 | (37.7322773768865, -122.476999578465) | 1 | 8 | 4 | 64 | 35 | |
| 97878 | 29255 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3201X 19th Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2006 12:00:00 AM | 6 | 3X3 | 5990532.43506 | 2093914.77746 | 37.7289464910226 | -122.475018795259 | (37.7289464910226, -122.475018795259) | 1 | 8 | 4 | 64 | 14 | ||
| 98917 | 346 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3590X 19th Ave | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/07/2015 01:09:00 PM | 3 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | 9 | 8 | 4 | 64 | 40 | ||
| 99102 | 25456 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 16X Randolph St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/15/2003 12:00:00 AM | 6 | 3X3 | 5993915.5443 | 2088541.6497 | 37.7143886663254 | -122.462933559746 | (37.7143886663254, -122.462933559746) | 9 | 8 | 6 | 64 | 24 | ||
| 101708 | 218550 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25 Elmhurst Dr | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5991159.53615 | 2094513.62652 | 37.7306271038561 | -122.472894532173 | (37.7306271038561, -122.472894532173) | 9 | 8 | 4 | 64 | 40 | |||
| 104298 | 218515 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 312 Vernon St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 5992482.76796 | 2089904.38544 | 37.7180477764537 | -122.467984821937 | (37.7180477764537, -122.467984821937) | 9 | 8 | 6 | 64 | 24 | |||
| 104402 | 19345 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 533 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 5992567.96665 | 2089831.72635 | 37.7178531919482 | -122.467685048229 | (37.7178531919482, -122.467685048229) | 9 | 8 | 6 | 64 | 24 | |||
| 104804 | 36264 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 80 Elmhurst Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/1998 12:00:00 AM | Permit Number 39274 | 5991040.15921142 | 2094553.62712809 | 37.7307300237066 | -122.473310148521 | (37.7307300237066, -122.473310148521) | 9 | 8 | 4 | 64 | 40 | |||
| 105713 | 218598 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3588 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5990581.32335 | 2092740.52687 | 37.7257251269062 | -122.474764114777 | (37.7257251269062, -122.474764114777) | 9 | 8 | 4 | 64 | 40 | |||
| 106588 | 218542 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 Rossmoor Dr | 3 | : | Tree | Private 2 | 5 | Width 2ft | 5991269.73751 | 2094338.22324 | 37.7301518696951 | -122.472500770291 | (37.7301518696951, -122.472500770291) | 9 | 8 | 4 | 64 | 40 | |||
| 106601 | 218592 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3656 19th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5990548.88588 | 2092187.93065 | 37.7242059561335 | -122.474835931037 | (37.7242059561335, -122.474835931037) | 9 | 8 | 4 | 64 | 40 | |||
| 107046 | 218539 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 167 Eucalyptus Dr | 2 | : | Tree | Private 2 | 4 | Width 2ft | 5991186.57078 | 2094655.95963 | 37.7310194798608 | -122.472811444694 | (37.7310194798608, -122.472811444694) | 9 | 8 | 4 | 64 | 40 | |||
| 108455 | 218529 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 183 Eucalyptus Dr | 3 | : | Tree | Private 2 | 5 | Width 3ft | 5990845.10794 | 2094666.97645 | 37.7310299560481 | -122.473992731197 | (37.7310299560481, -122.473992731197) | 9 | 8 | 4 | 64 | 40 | |||
| 109431 | 218581 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3676 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 11/07/2015 01:12:00 PM | 1 | Width 3ft | 5990520.50321 | 2091736.3366 | 37.7229643467231 | -122.474901096827 | (37.7229643467231, -122.474901096827) | 9 | 8 | 4 | 64 | 40 | ||
| 109580 | 217577 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5993183.8279 | 2088548.9495 | 37.7143665355122 | -122.465463170823 | (37.7143665355122, -122.465463170823) | 9 | 8 | 6 | 64 | 24 | |||
| 109950 | 45494 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3017 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2001 12:00:00 AM | 5 | Permit Number 44269 | 5989985.69339 | 2095129.18531 | 37.732249245209 | -122.476997602683 | (37.732249245209, -122.476997602683) | 1 | 8 | 4 | 64 | 35 | |
| 112114 | 218595 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3648 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990560.35043 | 2092310.81203 | 37.7245440220735 | -122.474805265068 | (37.7245440220735, -122.474805265068) | 9 | 8 | 4 | 64 | 40 | |||
| 112738 | 19324 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 209 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5993447.93037 | 2089821.98942 | 37.7178772263366 | -122.464642720891 | (37.7178772263366, -122.464642720891) | 9 | 8 | 6 | 64 | 24 | |||
| 112883 | 36288 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 68drive Rossmoor Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1998 12:00:00 AM | Permit Number 39282 | 5990862.16369743 | 2094546.76991481 | 37.7307008871423 | -122.473925000502 | (37.7307008871423, -122.473925000502) | 9 | 8 | 4 | 64 | 40 | |||
| 112948 | 36253 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25 Elmhurst Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/2005 12:00:00 AM | Permit Number 39270 | 5991200.33310514 | 2094436.30103714 | 37.7304171492597 | -122.472747856373 | (37.7304171492597, -122.472747856373) | 9 | 8 | 4 | 64 | 40 | ||
| 113754 | 32178 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 171 Lakeshore Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1995 12:00:00 AM | Permit Number 35513 | 5984396.34237134 | 2094161.85808413 | 37.7292673830802 | -122.496249618321 | (37.7292673830802, -122.496249618321) | 1 | 8 | 4 | 64 | 35 | |||
| 113977 | 45496 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3025 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2001 12:00:00 AM | 6 | Permit Number 44270 | 5989987.17329 | 2095091.0184 | 37.7321445344446 | -122.476989698518 | (37.7321445344446, -122.476989698518) | 1 | 8 | 4 | 64 | 35 | |
| 114593 | 218530 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 179 Eucalyptus Dr | 2 | : | Tree | Private 2 | 3 | Width 2ft | 5990903.39265 | 2094666.82321 | 37.7310329112435 | -122.473791221893 | (37.7310329112435, -122.473791221893) | 9 | 8 | 4 | 64 | 40 | |||
| 115071 | 218548 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25 Elmhurst Dr | 3 | : | Tree | Private 2 | 8 | Width 3ft | 5991200.16843 | 2094507.91417 | 37.7306137713995 | -122.47275364526 | (37.7306137713995, -122.47275364526) | 9 | 8 | 4 | 64 | 40 | |||
| 115082 | 218527 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 183 Eucalyptus Dr | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5990817.95884 | 2094667.89607 | 37.7310309084509 | -122.474086656376 | (37.7310309084509, -122.474086656376) | 9 | 8 | 4 | 64 | 40 | |||
| 115882 | 32180 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 183 Lakeshore Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35514 | 5984280.14048735 | 2094205.11731478 | 37.7293793539098 | -122.496654523481 | (37.7293793539098, -122.496654523481) | 1 | 8 | 4 | 64 | 35 | ||
| 117267 | 218540 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 Rossmoor Dr | 1 | : | Tree | Private 2 | 7 | Width 2ft | 5991304.84344 | 2094334.70837 | 37.7301442506463 | -122.472379149601 | (37.7301442506463, -122.472379149601) | 9 | 8 | 4 | 64 | 40 | |||
| 120373 | 36285 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 62 Rossmoor Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1998 12:00:00 AM | Permit Number 39280 | 5990920.84116695 | 2094554.1128949 | 37.7307244477014 | -122.47372268091 | (37.7307244477014, -122.47372268091) | 9 | 8 | 4 | 64 | 40 | |||
| 121026 | 287 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3355 19th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/1998 12:00:00 AM | 6 | 2 | 5990530.52606 | 2093814.1828 | 37.7286701727855 | -122.475018054542 | (37.7286701727855, -122.475018054542) | 1 | 8 | 4 | 64 | 14 | ||
| 123199 | 352 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3590X 19th Ave | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/18/1994 12:00:00 AM | 3 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | 9 | 8 | 4 | 64 | 40 | ||
| 123888 | 360 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3690X 19th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 2 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) | 9 | 8 | 4 | 64 | 40 | ||
| 124114 | 36257 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25 Elmhurst Dr | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1998 12:00:00 AM | Permit Number 39270 | 5991200.33310514 | 2094436.30103714 | 37.7304171492597 | -122.472747856373 | (37.7304171492597, -122.472747856373) | 9 | 8 | 4 | 64 | 40 | ||
| 124442 | 180231 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3353 19th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5990562.76114 | 2094328.81344 | 37.7300850869359 | -122.474944167153 | (37.7300850869359, -122.474944167153) | 1 | 8 | 4 | 64 | 14 | |||
| 125999 | 218528 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 183 Eucalyptus Dr | 2 | : | Tree | Private 2 | 5 | Width 3ft | 5990831.87058 | 2094666.90886 | 37.7310290036836 | -122.474038489609 | (37.7310290036836, -122.474038489609) | 9 | 8 | 4 | 64 | 40 | |||
| 126450 | 19359 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 709 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/22/2013 12:00:00 AM | 3 | 3x3 | 5992105.28308 | 2089838.41555 | 37.717844832756 | -122.469284812649 | (37.717844832756, -122.469284812649) | 9 | 8 | 6 | 64 | 24 | ||
| 126464 | 218544 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 20 Elmhurst Dr | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5991241.31591 | 2094410.9683 | 37.7303499642599 | -122.472604328142 | (37.7303499642599, -122.472604328142) | 9 | 8 | 4 | 64 | 40 | |||
| 128682 | 218571 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 98 Rossmoor Dr | 2 | : | Tree | Private 2 | 4 | Width 3ft | 5990740.27734 | 2094470.45315 | 37.7304842798098 | -122.474340809303 | (37.7304842798098, -122.474340809303) | 9 | 8 | 4 | 64 | 40 | |||
| 128823 | 218590 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3658 19th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5990546.45442 | 2092151.5417 | 37.7241059002597 | -122.474841681324 | (37.7241059002597, -122.474841681324) | 9 | 8 | 4 | 64 | 40 | |||
| 129165 | 32181 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 187 Lakeshore Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35515 | 5984242.60551895 | 2094230.34339508 | 37.7294464187928 | -122.496786144383 | (37.7294464187928, -122.496786144383) | 1 | 8 | 4 | 64 | 35 | ||
| 129783 | 102970 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1299X Junipero Serra Blvd | 17 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 2 | 5991413.8 | 2088806.6 | 37.714971736494 | -122.471599792301 | (37.714971736494, -122.471599792301) | 9 | 8 | 6 | 64 | 24 | |||
| 130902 | 217576 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 330 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5993083.2188 | 2088553.7101 | 37.7143738038723 | -122.465811258445 | (37.7143738038723, -122.465811258445) | 9 | 8 | 6 | 64 | 24 | |||
| 131469 | 19322 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 145 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/24/1994 12:00:00 AM | 6 | 3x3 | 5993547.63626 | 2089819.89616 | 37.7178772263409 | -122.464297932498 | (37.7178772263409, -122.464297932498) | 9 | 8 | 6 | 64 | 24 | ||
| 132218 | 36254 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25 Elmhurst Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/2005 12:00:00 AM | Permit Number 39270 | 5991200.33310514 | 2094436.30103714 | 37.7304171492597 | -122.472747856373 | (37.7304171492597, -122.472747856373) | 9 | 8 | 4 | 64 | 40 | ||
| 132296 | 218557 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 56 Rossmoor Dr | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5990972.9543 | 2094544.43485 | 37.7307008923158 | -122.473541813811 | (37.7307008923158, -122.473541813811) | 9 | 8 | 4 | 64 | 40 | |||
| 132476 | 218594 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3650 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 11/07/2015 01:09:00 PM | 3 | Width 3ft | 5990557.36485 | 2092274.4351 | 37.7244439670999 | -122.474812931796 | (37.7244439670999, -122.474812931796) | 9 | 8 | 4 | 64 | 40 | ||
| 133062 | 180225 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2901 Ocean Ave | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5989891.99303 | 2095239.26614 | 37.7325460628359 | -122.477329584708 | (37.7325460628359, -122.477329584708) | 1 | 8 | 4 | 64 | 35 | |||
| 133376 | 19353 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 650 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2008 12:00:00 AM | 5 | 3X3 | 5992332.13199 | 2089866.75244 | 37.717935745217 | -122.468502763995 | (37.717935745217, -122.468502763995) | 9 | 8 | 6 | 64 | 24 | ||
| 135712 | 180235 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3353 19th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5990554.42532 | 2094179.36297 | 37.7296742505655 | -122.474962079861 | (37.7296742505655, -122.474962079861) | 1 | 8 | 4 | 64 | 14 | |||
| 136079 | 1236 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3702X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/22/2008 12:00:00 AM | 3 | 3X5 | 5993199.6595 | 2087639.36817 | 37.7118699556054 | -122.465342418633 | (37.7118699556054, -122.465342418633) | 9 | 8 | 4 | 64 | 24 | ||
| 136190 | 218599 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3584 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990587.1686 | 2092822.2365 | 37.7259498198091 | -122.474749869532 | (37.7259498198091, -122.474749869532) | 9 | 8 | 4 | 64 | 40 | |||
| 136528 | 18592 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 345 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | 11/27/2007 12:00:00 AM | 3 | 3X3 | 5993019.1084 | 2088489.2823 | 37.7141932021811 | -122.466028168642 | (37.7141932021811, -122.466028168642) | 9 | 8 | 6 | 64 | 24 | ||
| 137566 | 218532 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 175 Eucalyptus Dr | 2 | : | Tree | Private 2 | 2 | Width 2ft | 5991015.99501 | 2094660.59708 | 37.7310223370113 | -122.473401486299 | (37.7310223370113, -122.473401486299) | 9 | 8 | 4 | 64 | 40 | |||
| 137605 | 87590 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3690X 19th Ave | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 4 | 5990484.73648 | 2091103.44002 | 37.7212244974117 | -122.474978557179 | (37.7212244974117, -122.474978557179) | 9 | 8 | 4 | 64 | 40 | |||
| 139432 | 180234 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3353 19th Ave | 8 | : | Tree | Private 2 | 1 | Width 3ft | 5990557.66801 | 2094210.25193 | 37.7297592517825 | -122.474953123507 | (37.7297592517825, -122.474953123507) | 1 | 8 | 4 | 64 | 14 | |||
| 139524 | 269 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3201X 19th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2006 12:00:00 AM | 6 | 3X3 | 5990532.43506 | 2093914.77746 | 37.7289464910226 | -122.475018795259 | (37.7289464910226, -122.475018795259) | 1 | 8 | 4 | 64 | 14 | ||
| 139889 | 253835 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3353 19th Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 5990554.42532 | 2094179.36297 | 37.7296742505655 | -122.474962079861 | (37.7296742505655, -122.474962079861) | 1 | 8 | 4 | 64 | 14 | ||||
| 140678 | 367 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3690X 19th Ave | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/12/1994 12:00:00 AM | 12 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) | 9 | 8 | 4 | 64 | 40 | ||
| 141998 | 342 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3590X 19th Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | 9 | 8 | 4 | 64 | 40 | ||
| 143644 | 218543 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10 Elmhurst Dr | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5991239.17772 | 2094375.63397 | 37.7302528212926 | -122.472609144905 | (37.7302528212926, -122.472609144905) | 9 | 8 | 4 | 64 | 40 | |||
| 144088 | 1229 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3600X Alemany Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/1998 12:00:00 AM | 12 | 3X5 | 5993524.0546702 | 2087589.4711722 | 37.7117516532039 | -122.464217607089 | (37.7117516532039, -122.464217607089) | 9 | 8 | 4 | 64 | 24 | ||
| 144275 | 218520 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 286 Ramsell St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5992992.28014 | 2089088.20524 | 37.7158361528844 | -122.466164394478 | (37.7158361528844, -122.466164394478) | 9 | 8 | 6 | 64 | 24 | |||
| 145595 | 218578 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3682 19th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5990515.20945 | 2091643.13765 | 37.7227081388421 | -122.474912596441 | (37.7227081388421, -122.474912596441) | 9 | 8 | 4 | 64 | 40 | |||
| 146262 | 218568 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 83 Rossmoor Dr | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5990778.04492 | 2094453.64092 | 37.7304403056549 | -122.47420901636 | (37.7304403056549, -122.47420901636) | 9 | 8 | 4 | 64 | 40 | |||
| 147508 | 25460 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 232 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1998 12:00:00 AM | 6 | 3X3 | 5993318.5551 | 2088549.4255 | 37.7143756119157 | -122.464997538688 | (37.7143756119157, -122.464997538688) | 9 | 8 | 6 | 64 | 24 | ||
| 147760 | 1228 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3600X Alemany Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/1998 12:00:00 AM | 12 | 3X5 | 5993524.0546702 | 2087589.4711722 | 37.7117516532039 | -122.464217607089 | (37.7117516532039, -122.464217607089) | 9 | 8 | 4 | 64 | 24 | ||
| 147967 | 36263 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 70 Elmhurst Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1998 12:00:00 AM | Permit Number 39273 | 5991114.00910077 | 2094553.32638824 | 37.7307334739303 | -122.473054818526 | (37.7307334739303, -122.473054818526) | 9 | 8 | 4 | 64 | 40 | ||
| 148158 | 347 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3590X 19th Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/24/2008 12:00:00 AM | 25 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | 9 | 8 | 4 | 64 | 40 | ||
| 149045 | 388 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3721X 19th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2006 12:00:00 AM | 3 | 2 | 5990351.3309 | 2090950.31436 | 37.7207963201663 | -122.475428522866 | (37.7207963201663, -122.475428522866) | 1 | 8 | 4 | 64 | 14 | ||
| 149049 | 355 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3690X 19th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 2 | 2 | 5990489.7429471 | 2091103.380949 | 37.7212246253597 | -122.474961247123 | (37.7212246253597, -122.474961247123) | 9 | 8 | 4 | 64 | 40 | ||
| 149170 | 48570 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 286 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/2002 12:00:00 AM | Permit Number 45989 | 5993003.15768778 | 2089092.02343663 | 37.7158472643099 | -122.466127074247 | (37.7158472643099, -122.466127074247) | 9 | 8 | 6 | 64 | 24 | ||
| 152642 | 383 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3721X 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2006 12:00:00 AM | 3 | 2 | 5990351.3309 | 2090950.31436 | 37.7207963201663 | -122.475428522866 | (37.7207963201663, -122.475428522866) | 1 | 8 | 4 | 64 | 14 | ||
| 153992 | 218584 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3672 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 11/07/2015 01:03:00 PM | 3 | Width 3ft | 5990526.83563 | 2091826.2003 | 37.7232114570186 | -122.474885763392 | (37.7232114570186, -122.474885763392) | 9 | 8 | 4 | 64 | 40 | ||
| 154370 | 36284 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 62 Rossmoor Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1998 12:00:00 AM | Permit Number 39280 | 5990920.84116695 | 2094554.1128949 | 37.7307244477014 | -122.47372268091 | (37.7307244477014, -122.47372268091) | 9 | 8 | 4 | 64 | 40 | |||
| 155009 | 29256 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3201X 19th Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2006 12:00:00 AM | 6 | 3X3 | 5990532.43506 | 2093914.77746 | 37.7289464910226 | -122.475018795259 | (37.7289464910226, -122.475018795259) | 1 | 8 | 4 | 64 | 14 | ||
| 155827 | 237 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3007 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/2006 12:00:00 AM | 6 | 2 | 5990538.44703 | 2095140.6475 | 37.7323127688129 | -122.475087464208 | (37.7323127688129, -122.475087464208) | 1 | 8 | 4 | 64 | 35 | ||
| 156504 | 36290 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 68drive Rossmoor Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1998 12:00:00 AM | Permit Number 39282 | 5990862.16369743 | 2094546.76991481 | 37.7307008871423 | -122.473925000502 | (37.7307008871423, -122.473925000502) | 9 | 8 | 4 | 64 | 40 | |||
| 156650 | 218554 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 20 Rossmoor Dr | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5991096.97089 | 2094386.86315 | 37.7302754212525 | -122.473101586686 | (37.7302754212525, -122.473101586686) | 9 | 8 | 4 | 64 | 40 | |||
| 158486 | 218563 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 74 Rossmoor Dr | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5990853.66269 | 2094536.86772 | 37.7306732058057 | -122.473953667332 | (37.7306732058057, -122.473953667332) | 9 | 8 | 4 | 64 | 40 | |||
| 158866 | 36277 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 50 Rossmoor Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1998 12:00:00 AM | Permit Number 39278 | 5991022.47129898 | 2094553.69914368 | 37.7307291972141 | -122.473371303037 | (37.7307291972141, -122.473371303037) | 9 | 8 | 4 | 64 | 40 | |||
| 158887 | 345 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3590X 19th Ave | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | 9 | 8 | 4 | 64 | 40 | |||
| 159041 | 218577 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3694 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990498.54553 | 2091379.01526 | 37.7219819587905 | -122.474950929165 | (37.7219819587905, -122.474950929165) | 9 | 8 | 4 | 64 | 40 | |||
| 159151 | 218558 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 55 Rossmoor Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 5990953.73418 | 2094508.65771 | 37.7306015442135 | -122.47360565129 | (37.7306015442135, -122.47360565129) | 9 | 8 | 4 | 64 | 40 | |||
| 159231 | 88437 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 424 Garfield St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2008 12:00:00 AM | 3x3 | Permit Number 51401 | 5992930 | 2090509 | 37.7197337184937 | -122.46648286823 | (37.7197337184937, -122.46648286823) | 9 | 8 | 6 | 64 | 24 | |||
| 160572 | 180224 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3599 Alemany Blvd | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5993480.96313 | 2087505.0727 | 37.7115174312511 | -122.464360418308 | (37.7115174312511, -122.464360418308) | 9 | 8 | 4 | 64 | 24 | |||
| 160787 | 25469 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 345 Randolph St | 2 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | 03/15/2003 12:00:00 AM | 3 | 3X3 | 5993035.9294 | 2088489.917 | 37.7141959153246 | -122.465970075328 | (37.7141959153246, -122.465970075328) | 9 | 8 | 6 | 64 | 24 | ||
| 161003 | 409 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3838 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2008 12:00:00 AM | 3 | 2X3 | 5990744.20002 | 2090277.41879 | 37.7189714809286 | -122.474021438444 | (37.7189714809286, -122.474021438444) | 9 | 8 | 4 | 64 | 40 | ||
| 161246 | 218569 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 95 Rossmoor Dr | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5990765.45397 | 2094449.75445 | 37.7304289049727 | -122.474252261144 | (37.7304289049727, -122.474252261144) | 9 | 8 | 4 | 64 | 40 | |||
| 162501 | 218561 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 71 Rossmoor Dr | 2 | : | Tree | Private 2 | 5 | Width 3ft | 5990869.78333 | 2094510.42853 | 37.7306015442042 | -122.473896008201 | (37.7306015442042, -122.473896008201) | 9 | 8 | 4 | 64 | 40 | |||
| 163234 | 218526 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 424 Garfield St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5992849.69775 | 2090512.21172 | 37.7197379029691 | -122.466760675572 | (37.7197379029691, -122.466760675572) | 9 | 8 | 6 | 64 | 24 | |||
| 163294 | 36293 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 74 Rossmoor Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1998 12:00:00 AM | Permit Number 39284 | 5990814.34200545 | 2094529.58563397 | 37.7306509333598 | -122.474089072475 | (37.7306509333598, -122.474089072475) | 9 | 8 | 4 | 64 | 40 | |||
| 163342 | 36262 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 70 Elmhurst Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1998 12:00:00 AM | Permit Number 39273 | 5991114.00910077 | 2094553.32638824 | 37.7307334739303 | -122.473054818526 | (37.7307334739303, -122.473054818526) | 9 | 8 | 4 | 64 | 40 | ||
| 164342 | 218589 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3658 19th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5990546.49635 | 2092127.24741 | 37.7240391966337 | -122.474839763947 | (37.7240391966337, -122.474839763947) | 9 | 8 | 4 | 64 | 40 | |||
| 165664 | 50398 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 11 Sylvan Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2003 12:00:00 AM | 5 | Permit Number 47049 | 5987519.13546 | 2095787.07004 | 37.7339122247558 | -122.485573207637 | (37.7339122247558, -122.485573207637) | 1 | 8 | 4 | 64 | 35 | |
| 166219 | 218533 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 175 Eucalyptus Dr | 3 | : | Tree | Private 2 | 3 | Width 2ft | 5991030.95126 | 2094659.58794 | 37.7310204322329 | -122.473349706944 | (37.7310204322329, -122.473349706944) | 9 | 8 | 4 | 64 | 40 | |||
| 167284 | 36266 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 80 Elmhurst Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/1998 12:00:00 AM | Permit Number 39274 | 5991040.15921142 | 2094553.62712809 | 37.7307300237066 | -122.473310148521 | (37.7307300237066, -122.473310148521) | 9 | 8 | 4 | 64 | 40 |
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) );