trees
7,322 rows where qSpecies_id = 1 sorted by XCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
90 | 259864 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1398x Brussels St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | |||||||||||||
1095 | 255202 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Burrows St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
1138 | 260594 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3090x Jennings St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | ||||||||||||
2475 | 259866 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 101x Desmond St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
4112 | 255223 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1051 Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
6640 | 255204 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Burrows St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
6981 | 259867 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 101x Desmond St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
7570 | 36838 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
7587 | 259089 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1201 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
7844 | 36854 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
8196 | 255225 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 400 Bacon St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
8832 | 260593 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3090x Jennings St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | ||||||||||||
10581 | 260591 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3090x Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | ||||||||||||
11185 | 98268 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401X Esmeralda Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | |||||||||||||
11245 | 255201 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Burrows St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
11633 | 259865 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 101x Desmond St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
11767 | 255200 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
12758 | 260592 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3090x Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | ||||||||||||
13636 | 36840 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
13881 | 255222 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1051 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
14357 | 36839 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
14394 | 36837 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
15903 | 255203 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Burrows St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
18459 | 36836 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
157079 | 119174 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 738 La Playa | 1 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 7 | Width 8ft | 5980754.24139 | 2110680.27075 | 37.7744082353086 | -122.510067160899 | (37.7744082353086, -122.510067160899) | 11 | 6 | 2 | 55 | 26 | |||
41118 | 119176 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 742 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | Width 8ft | 5980756.08521 | 2110656.0073 | 37.7743417237871 | -122.510058979927 | (37.7743417237871, -122.510058979927) | 11 | 6 | 2 | 55 | 26 | |||
8267 | 119175 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 742 La Playa | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | Width 8ft | 5980756.90149 | 2110662.55033 | 37.7743597371632 | -122.510056642513 | (37.7743597371632, -122.510056642513) | 11 | 6 | 2 | 55 | 26 | |||
3579 | 119169 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 720 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 3ft | 5980759.87673 | 2110793.19365 | 37.7747186206505 | -122.510056058609 | (37.7747186206505, -122.510056058609) | 11 | 6 | 2 | 55 | 26 | |||
56411 | 119179 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 756 La Playa | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | Width 3ft | 5980765.91375 | 2110586.65735 | 37.7741518889865 | -122.510019828655 | (37.7741518889865, -122.510019828655) | 11 | 6 | 2 | 55 | 26 | |||
136118 | 119178 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 756 La Playa | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | Width 3ft | 5980765.96509 | 2110596.91774 | 37.7741800640196 | -122.510020413475 | (37.7741800640196, -122.510020413475) | 11 | 6 | 2 | 55 | 26 | |||
101951 | 50783 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 770 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2018 12:00:00 AM | 14 | Permit Number 47309 | 5980766.08534 | 2110461.55309 | 37.7738083996933 | -122.510009939122 | (37.7738083996933, -122.510009939122) | 11 | 6 | 2 | 55 | 26 | ||
95441 | 119180 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 756 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | Width 3ft | 5980766.80768 | 2110581.0869 | 37.7741366468987 | -122.510016322531 | (37.7741366468987, -122.510016322531) | 11 | 6 | 2 | 55 | 26 | |||
53123 | 119182 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 770 La Playa | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/08/2018 08:55:00 AM | 3 | Width 3ft | 5980768.60163 | 2110516.49212 | 37.7739593944882 | -122.510005317294 | (37.7739593944882, -122.510005317294) | 11 | 6 | 2 | 55 | 26 | ||
61314 | 119181 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 758 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 3ft | 5980769.04237 | 2110551.43207 | 37.7740553552846 | -122.510006388961 | (37.7740553552846, -122.510006388961) | 11 | 6 | 2 | 55 | 26 | |||
56005 | 119183 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 770 La Playa | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/13/2018 08:27:00 AM | 3 | Width 3ft | 5980769.13154 | 2110513.52409 | 37.7739512764073 | -122.510003263739 | (37.7739512764073, -122.510003263739) | 11 | 6 | 2 | 55 | 26 | ||
115445 | 119185 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 780 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | Width 4ft | 5980776.33193 | 2110309.65746 | 37.7733919433929 | -122.50996320874 | (37.7733919433929, -122.50996320874) | 11 | 6 | 2 | 55 | 26 | |||
138881 | 119184 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 780 La Playa | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | Width 4ft | 5980778.38631 | 2110329.2751 | 37.773445928821 | -122.509957560132 | (37.773445928821, -122.509957560132) | 11 | 6 | 2 | 55 | 26 | |||
125559 | 120527 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1672 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/2016 12:00:00 AM | 3 | 3x3 | 5981030 | 2103685 | 37.7552175094175 | -122.508593851446 | (37.7552175094175, -122.508593851446) | 1 | 8 | 3 | 56 | 35 | ||
159304 | 36090 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1726 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2008 12:00:00 AM | 3x3 | Permit Number 50757 | 5981042.98067926 | 2103306.534633 | 37.7541791163278 | -122.508520867013 | (37.7541791163278, -122.508520867013) | 1 | 8 | 3 | 56 | 35 | ||
184166 | 115674 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1433 48th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774098 | 5981190.2 | 2105303.4 | 37.7596706142775 | -122.508159957785 | (37.7596706142775, -122.508159957785) | 1 | 8 | 3 | 56 | 35 | ||
165381 | 31940 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1322 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/2011 12:00:00 AM | 3x3 | Permit Number 767124 | 5981230.33279016 | 2106058.35423449 | 37.7617458665939 | -122.508077193589 | (37.7617458665939, -122.508077193589) | 1 | 8 | 3 | 56 | 35 | |
51281 | 187631 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4255x Judah St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 03/28/2017 11:56:00 AM | 3 | 3x3 | 5981269 | 2105492 | 37.7601930989218 | -122.507901429287 | (37.7601930989218, -122.507901429287) | 1 | 8 | 3 | 56 | 35 | |
9722 | 253988 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 680 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | 3x3 | 5981392 | 2111100 | 37.7755982845187 | -122.507892228296 | (37.7755982845187, -122.507892228296) | 11 | 6 | 2 | 55 | 26 | ||
113378 | 53172 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2266# SANTIAGO 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50744 | 5981447.24626217 | 2099655.9464458 | 37.7441794455765 | -122.506852079976 | (37.7441794455765, -122.506852079976) | 1 | 8 | 3 | 29491 | 35 | ||
188211 | 37090 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1241 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 5 | Permit Number 39690 | 5981472.6931 | 2106630.1727 | 37.7633301936195 | -122.507281405917 | (37.7633301936195, -122.507281405917) | 1 | 8 | 3 | 56 | 35 | |
125542 | 81227 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1206 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50169 | 5981508.8658 | 2106840.309 | 37.7639092979165 | -122.50717188863 | (37.7639092979165, -122.50717188863) | 1 | 8 | 3 | 56 | 35 | |
173318 | 83338 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1509 47th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2008 12:00:00 AM | 1 | 3x3 | Permit Number 50174 | 5981536.4923 | 2104752.0807 | 37.7581772488217 | -122.506921430617 | (37.7581772488217, -122.506921430617) | 1 | 8 | 3 | 56 | 35 | |
178714 | 88105 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1509 47th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2008 12:00:00 AM | 3x3 | Permit Number 51109 | 5981537.1 | 2104800.5 | 37.7583102301918 | -122.506922920506 | (37.7583102301918, -122.506922920506) | 1 | 8 | 3 | 56 | 35 | |||
52235 | 90921 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5500 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2018 09:55:00 AM | 3 | 3x3 | 5981544.5953 | 2111683.77471 | 37.7772101475974 | -122.507407695808 | (37.7772101475974, -122.507407695808) | 11 | 6 | 2 | 55 | 26 | ||
12353 | 832 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1396 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/28/2017 12:18:00 PM | 3 | 3X3 | 5981551.7086 | 2105613.8347 | 37.7605442750604 | -122.506932728621 | (37.7605442750604, -122.506932728621) | 1 | 8 | 3 | 56 | 35 | ||
20393 | 90920 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5500 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2018 09:52:00 AM | 3 | 3x3 | 5981566.35935 | 2111684.48442 | 37.7772133782314 | -122.507332461007 | (37.7772133782314, -122.507332461007) | 11 | 6 | 2 | 55 | 26 | ||
10298 | 261226 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1582 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2019 12:00:00 AM | 3 | 4x6 | 5981619 | 2104320 | 37.7569957368703 | -122.506604043387 | (37.7569957368703, -122.506604043387) | 1 | 8 | 3 | 56 | 35 | ||
18992 | 261220 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2970 Sloat Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/2020 12:00:00 AM | 3 | 4x6 | 5981657 | 2096559 | 37.7356884360348 | -122.505897251941 | (37.7356884360348, -122.505897251941) | 1 | 8 | 3 | 29491 | 35 | |
186858 | 92455 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2379 47th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52845 | 5981718.2 | 2098908.8 | 37.7421439412615 | -122.505859816895 | (37.7421439412615, -122.505859816895) | 1 | 8 | 3 | 29491 | 35 | |
150776 | 46400 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2371 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/2011 12:00:00 AM | 0 | 3x3 | Permit Number 767122 | 5981730.59814192 | 2098955.65959072 | 37.7422733344517 | -122.505820421933 | (37.7422733344517, -122.505820421933) | 1 | 8 | 3 | 29491 | 35 |
71409 | 67533 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2379 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/24/1992 12:00:00 AM | 1 | Permit Number 31071 | 5981738.9441 | 2098908.0285 | 37.7421430439036 | -122.505788034349 | (37.7421430439036, -122.505788034349) | 1 | 8 | 3 | 29491 | 35 | ||
92043 | 92456 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2395 47th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52846 | 5981742.1 | 2098798.2 | 37.7418416710163 | -122.505768982243 | (37.7418416710163, -122.505768982243) | 1 | 8 | 3 | 29491 | 35 | |
5201 | 261538 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 667 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Width 3ft | 5981910 | 2111209 | 37.7759280729172 | -122.506108454702 | (37.7759280729172, -122.506108454702) | 11 | 6 | 2 | 55 | 26 | ||
2949 | 261537 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 612 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Width 3ft | 5981957 | 2111327 | 37.7762548329233 | -122.505954622938 | (37.7762548329233, -122.505954622938) | 11 | 6 | 2 | 55 | 26 | ||
10302 | 261536 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 602 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Width 3ft | 5981957 | 2111327 | 37.7762548329233 | -122.505954622938 | (37.7762548329233, -122.505954622938) | 11 | 6 | 2 | 55 | 26 | ||
33820 | 68570 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 871 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | 7 | Permit Number 32460 | 5981987.19537 | 2109819.09315 | 37.7721163387449 | -122.505738359213 | (37.7721163387449, -122.505738359213) | 11 | 6 | 2 | 55 | 26 | |
66351 | 84906 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4125 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2007 12:00:00 AM | 1 | Permit No. 49330 | 5982037.1515 | 2104863.4571 | 37.7585125281424 | -122.505198218309 | (37.7585125281424, -122.505198218309) | 1 | 8 | 3 | 56 | 35 | ||
137674 | 37081 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1233 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 5 | Permit Number 39682 | 5982089.3021 | 2106698.5454 | 37.7635542250983 | -122.505153861082 | (37.7635542250983, -122.505153861082) | 1 | 8 | 3 | 56 | 35 | |
46220 | 82983 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4109 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53508 | 5982104.069 | 2104866.8183 | 37.7585256942415 | -122.504967040604 | (37.7585256942415, -122.504967040604) | 1 | 8 | 3 | 56 | 35 | |
116651 | 92442 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1379 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52833 | 5982122.5039 | 2105719.7315 | 37.7608686355716 | -122.504966489709 | (37.7608686355716, -122.504966489709) | 1 | 8 | 3 | 56 | 35 |
181559 | 819 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1410 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/25/2008 12:00:00 AM | 3 | 3X3 | 5982179.061767 | 2105489.8566905 | 37.7602407921924 | -122.504753851013 | (37.7602407921924, -122.504753851013) | 1 | 8 | 3 | 56 | 35 | ||
15029 | 69788 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1526 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2020 12:00:00 AM | 3 | 4x6 | 5982204.5216 | 2104686.309 | 37.7580359763889 | -122.504606262253 | (37.7580359763889, -122.504606262253) | 1 | 8 | 3 | 56 | 35 | |
97974 | 40209 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 546 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 3 | Permit Number 41391 | 5982263.05386 | 2112038.67189 | 37.7782268854551 | -122.504948666417 | (37.7782268854551, -122.504948666417) | 11 | 6 | 2 | 55 | 26 | |
108692 | 52086 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 550 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 3 | Permit Number 48283 | 5982264.87127 | 2112012.82882 | 37.7781560348973 | -122.504940463882 | (37.7781560348973, -122.504940463882) | 11 | 6 | 2 | 55 | 26 | |
7653 | 118738 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 664 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Width 4ft | 5982292.77249 | 2111243.99533 | 37.7760466849131 | -122.504786961569 | (37.7760466849131, -122.504786961569) | 11 | 6 | 2 | 55 | 26 | ||
180151 | 82813 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2143 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50735 | 5982301.7396 | 2100521.1161 | 37.7466052443518 | -122.503961546355 | (37.7466052443518, -122.503961546355) | 1 | 8 | 3 | 29491 | 35 | |
43991 | 118444 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5248 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2018 09:37:00 AM | 3 | Width 3ft | 5982318.73314 | 2111710.8032 | 37.7773299298102 | -122.504731754716 | (37.7773299298102, -122.504731754716) | 11 | 6 | 2 | 55 | 26 | ||
67874 | 83248 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2274 45th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/2011 12:00:00 AM | 0 | 3x3 | Permit Number 767120 | 5982380.00830006 | 2099635.57983168 | 37.7441784094816 | -122.503625338719 | (37.7441784094816, -122.503625338719) | 1 | 8 | 3 | 29491 | 35 |
177010 | 83250 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2274 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767120 | 5982380.00830006 | 2099635.57983168 | 37.7441784094816 | -122.503625338719 | (37.7441784094816, -122.503625338719) | 1 | 8 | 3 | 29491 | 35 |
156502 | 254346 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5214 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | 5982448 | 2111730 | 37.7773902420223 | -122.504286008671 | (37.7773902420223, -122.504286008671) | 11 | 6 | 2 | 55 | 26 | |||
179592 | 184151 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1585 44th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5982482.7335 | 2104338.124 | 37.7570963201307 | -122.503618318652 | (37.7570963201307, -122.503618318652) | 1 | 8 | 3 | 56 | 35 | |||
142663 | 92443 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2638 45th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52834 | 5982485.5 | 2097144.3 | 37.7373442414634 | -122.503076173661 | (37.7373442414634, -122.503076173661) | 1 | 8 | 3 | 29491 | 35 | |
86187 | 83781 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1659 44th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2008 12:00:00 AM | 0 | 3x3 | Permit Number 50155 | 5982495.52405301 | 2103826.42890592 | 37.7556921018703 | -122.503536193946 | (37.7556921018703, -122.503536193946) | 1 | 8 | 3 | 56 | 35 | |
154851 | 81987 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 500 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2007 12:00:00 AM | 3 | 3x3 | Permit Number 50009 | 5982564.71804 | 2112307.54022 | 37.7789828620794 | -122.503925036148 | (37.7789828620794, -122.503925036148) | 11 | 6 | 2 | 55 | 26 | |
14830 | 146918 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 787 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:53:00 PM | 0 | Width 3ft | 5982587.71867 | 2110421.43363 | 37.7738055167411 | -122.503705750643 | (37.7738055167411, -122.503705750643) | 11 | 6 | 2 | 55 | 26 | ||
14155 | 69005 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2087 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2019 12:00:00 AM | 3 | 3x14 | Permit Number 33006 | 5982594.36064133 | 2100924.19223319 | 37.7477291823956 | -122.502979545621 | (37.7477291823956, -122.502979545621) | 1 | 8 | 3 | 29491 | 35 |
103691 | 81986 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 7849 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50009 | 5982597.59734 | 2112350.81407 | 37.7791036127035 | -122.503814501155 | (37.7791036127035, -122.503814501155) | 11 | 6 | 2 | 55 | 26 | |
1870 | 70434 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 855 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 3x3 | 5982604.49779 | 2109922.26737 | 37.772435937677 | -122.503610737191 | (37.772435937677, -122.503610737191) | 11 | 6 | 2 | 55 | 26 | ||
174535 | 81985 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 7849 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50009 | 5982611.12998 | 2112350.31973 | 37.77910305109 | -122.503767650406 | (37.77910305109, -122.503767650406) | 11 | 6 | 2 | 55 | 26 | |
110675 | 81984 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 7849 Geary Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50009 | 5982627.56911 | 2112351.39821 | 37.7791069788511 | -122.503710861606 | (37.7791069788511, -122.503710861606) | 11 | 6 | 2 | 55 | 26 | |
129319 | 81983 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 7849 Geary Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2007 12:00:00 AM | 3 | 3x3 | Permit Number 50009 | 5982648.09579 | 2112351.28707 | 37.7791078805619 | -122.503639844414 | (37.7791078805619, -122.503639844414) | 11 | 6 | 2 | 55 | 26 | |
163729 | 81980 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 7849 Geary Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2007 12:00:00 AM | 3 | 3x3 | Permit Number 50009 | 5982658.1733 | 2112352.78806 | 37.779112594333 | -122.503605093969 | (37.779112594333, -122.503605093969) | 11 | 6 | 2 | 55 | 26 | |
85484 | 90307 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4149X Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982661.59855 | 2110983.12426 | 37.7753520993274 | -122.503491793953 | (37.7753520993274, -122.503491793953) | 11 | 6 | 2 | 55 | 26 | ||
187184 | 90306 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4149X Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | 3x3 | 5982680.92988 | 2110985.11147 | 37.7753586920926 | -122.503425070684 | (37.7753586920926, -122.503425070684) | 11 | 6 | 2 | 55 | 26 | ||
17396 | 92434 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1226 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52824 | 5982777 | 2106752 | 37.7637414354066 | -122.502779328398 | (37.7637414354066, -122.502779328398) | 1 | 8 | 3 | 56 | 35 |
16971 | 92435 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1234 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52825 | 5982779 | 2106703 | 37.7636070129242 | -122.502768783764 | (37.7636070129242, -122.502768783764) | 1 | 8 | 3 | 56 | 35 |
133429 | 90971 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4101 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | 3x3 | 5982789.9497 | 2110989.59501 | 37.7753774110222 | -122.503048284011 | (37.7753774110222, -122.503048284011) | 11 | 6 | 2 | 55 | 26 | ||
119918 | 90970 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4101 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | 3x3 | 5982828.46355 | 2110990.35632 | 37.775381765002 | -122.502915114183 | (37.775381765002, -122.502915114183) | 11 | 6 | 2 | 55 | 26 | ||
100863 | 90969 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4101 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | 3x3 | 5982841.37806 | 2110990.2516 | 37.7753822364855 | -122.502870432858 | (37.7753822364855, -122.502870432858) | 11 | 6 | 2 | 55 | 26 | ||
131426 | 24786 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 7795X Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 5982848.85318 | 2112367.91788 | 37.7791653451953 | -122.502946585831 | (37.7791653451953, -122.502946585831) | 11 | 6 | 2 | 55 | 26 | |||
145111 | 24787 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 7795X Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/1996 12:00:00 AM | 3 | 2X2 | 5982848.85318 | 2112367.91788 | 37.7791653451953 | -122.502946585831 | (37.7791653451953, -122.502946585831) | 11 | 6 | 2 | 55 | 26 | ||
185568 | 24788 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 7795X Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 5982848.85318 | 2112367.91788 | 37.7791653451953 | -122.502946585831 | (37.7791653451953, -122.502946585831) | 11 | 6 | 2 | 55 | 26 | |||
86303 | 90936 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4100X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | 3x3 | 5982849.80185 | 2111047.09005 | 37.7755387934026 | -122.50284550193 | (37.7755387934026, -122.50284550193) | 11 | 6 | 2 | 55 | 26 | ||
9014 | 261225 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2111 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2020 12:00:00 AM | 3 | 4x6 | 5982897 | 2100735 | 37.7472274959484 | -122.501919055433 | (37.7472274959484, -122.501919055433) | 1 | 8 | 3 | 29491 | 35 | ||
16002 | 261224 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2251 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2019 12:00:00 AM | 3 | 4x6 | 5982929 | 2099807 | 37.7446813441512 | -122.501739756381 | (37.7446813441512, -122.501739756381) | 1 | 8 | 3 | 29491 | 35 |
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) );