trees
7,322 rows where qSpecies_id = 1 sorted by Fire Prevention Districts
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 | ||||||||||||||
283 | 78989 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2319 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5988235.2891 | 2099507.8812 | 37.7441702991504 | -122.483369943638 | (37.7441702991504, -122.483369943638) | 1 | 8 | 3 | 29491 | 35 | |||
287 | 39813 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000 41st Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/12/2019 12:00:00 AM | 3 | 3x10 | Permit Number 41144 | 5983552 | 2101519 | 37.7494185989562 | -122.499712087956 | (37.7494185989562, -122.499712087956) | 1 | 8 | 3 | 29491 | 35 |
725 | 183610 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1954 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5986022.0269 | 2101933.6639 | 37.7507017829524 | -122.491201304809 | (37.7507017829524, -122.491201304809) | 1 | 8 | 3 | 29491 | 35 | |||
759 | 181983 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2478 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5986456.7133 | 2098393.9658 | 37.7410081118776 | -122.489437895882 | (37.7410081118776, -122.489437895882) | 1 | 8 | 3 | 29491 | 35 | |||
827 | 258419 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1838 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2019 05:59:00 PM | 3 | 3x3 | 5990003 | 2106579 | 37.7636884395526 | -122.477774444731 | (37.7636884395526, -122.477774444731) | 1 | 8 | 3 | 56 | 35 | ||
882 | 31596 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1319 Ortega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/1995 12:00:00 AM | 3 | Permit Number 35123 | 5989912.9927 | 2102412.7013 | 37.7522436720962 | -122.477781174123 | (37.7522436720962, -122.477781174123) | 1 | 8 | 3 | 29491 | 35 | |
965 | 184959 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000 41st Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2019 12:00:00 AM | 3 | 3x10 | 5983552 | 2101519 | 37.7494185989562 | -122.499712087956 | (37.7494185989562, -122.499712087956) | 1 | 8 | 3 | 29491 | 35 | |
1020 | 256741 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1494 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x3 | 5987774.09162 | 2105131.6228 | 37.7595847299836 | -122.485377233769 | (37.7595847299836, -122.485377233769) | 1 | 8 | 3 | 56 | 35 | ||
1226 | 264874 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2218 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/2020 12:00:00 AM | 3 | 4x6 | 5985178 | 2100085 | 37.7455765035143 | -122.493983750596 | (37.7455765035143, -122.493983750596) | 1 | 8 | 3 | 29491 | 35 | |
1253 | 86079 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2321 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987612.7621 | 2099475.5619 | 37.7440453083682 | -122.485520107247 | (37.7440453083682, -122.485520107247) | 1 | 8 | 3 | 29491 | 35 | ||
1721 | 86502 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1410 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5987758.3934 | 2105633.7162 | 37.7609624268951 | -122.48546837117 | (37.7609624268951, -122.48546837117) | 1 | 8 | 3 | 56 | 35 | ||
2075 | 75757 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2194 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5988246.235 | 2100404.2075 | 37.7466320110547 | -122.483397789712 | (37.7466320110547, -122.483397789712) | 1 | 8 | 3 | 29491 | 35 | |||
2195 | 258431 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2450 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2019 05:45:00 PM | 3 | 3x3 | 5988181.8432 | 2106487.3051 | 37.7633308106608 | -122.484066458576 | (37.7633308106608, -122.484066458576) | 1 | 8 | 3 | 56 | 35 | ||
2574 | 216200 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1650 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/11/2020 12:00:00 AM | 3 | 4x4 | Permit Number 784456 | 5992806.74011 | 2104217.97153 | 37.7573679916535 | -122.467905522425 | (37.7573679916535, -122.467905522425) | 1 | 8 | 4 | 56 | 12 | |
3199 | 218700 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2290 14th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992022.37081 | 2099856.7917 | 37.745347997612 | -122.470300568125 | (37.745347997612, -122.470300568125) | 1 | 8 | 4 | 29491 | 40 | |||
3285 | 184909 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1990 41st Ave | 28 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2019 12:00:00 AM | 3 | Width 0ft | 5983540.025 | 2101883.0946 | 37.75041759921 | -122.4997804049 | (37.75041759921, -122.4997804049) | 1 | 8 | 3 | 29491 | 35 | ||
3289 | 262310 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1356 20th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/2016 12:00:00 AM | 5989914.31197 | 2106134.19071 | 37.7624619657204 | -122.478048663847 | (37.7624619657204, -122.478048663847) | 1 | 8 | 3 | 56 | 35 | |||||
3557 | 44729 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1250 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/2001 12:00:00 AM | 3 | Permit Number 43848 | 5989582.3113 | 2101095.9623 | 37.7486090577263 | -122.478828414076 | (37.7486090577263, -122.478828414076) | 1 | 8 | 3 | 29491 | 35 | |
3718 | 85909 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2234 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988258.4084 | 2100094.7734 | 37.745783095491 | -122.483333016616 | (37.745783095491, -122.483333016616) | 1 | 8 | 3 | 29491 | 35 | ||
3964 | 37244 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2550 Ortega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | 4 | Permit Number 39799 | 5986061.104 | 2102337.4318 | 37.7518127029083 | -122.491095885429 | (37.7518127029083, -122.491095885429) | 1 | 8 | 3 | 56 | 35 | |
4130 | 92248 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1475 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52695 | 5985867.8936 | 2105206.8448 | 37.759680032266 | -122.491975261997 | (37.759680032266, -122.491975261997) | 1 | 8 | 3 | 56 | 35 | |
4152 | 37192 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1695 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/09/1998 12:00:00 AM | 4 | Permit Number 39759 | 5986844.2604 | 2103759.2633 | 37.7557623917813 | -122.488492147727 | (37.7557623917813, -122.488492147727) | 1 | 8 | 3 | 56 | 35 | |
4287 | 85892 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2450 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988312.1108 | 2098619.8624 | 37.7417365040241 | -122.483039240723 | (37.7417365040241, -122.483039240723) | 1 | 8 | 3 | 29491 | 35 | ||
4422 | 183782 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2295 32nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/2020 12:00:00 AM | 3 | 5x5 | 5986367.7435 | 2099662.7006 | 37.7444865241588 | -122.489838803613 | (37.7444865241588, -122.489838803613) | 1 | 8 | 3 | 29491 | 35 | ||
4538 | 78935 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2131 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5986022.5823 | 2100717.4644 | 37.7473624613212 | -122.491109891303 | (37.7473624613212, -122.491109891303) | 1 | 8 | 3 | 29491 | 35 | |||
4605 | 85901 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2282 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988268.6501 | 2099782.4008 | 37.7449259990071 | -122.483274709024 | (37.7449259990071, -122.483274709024) | 1 | 8 | 3 | 29491 | 35 | ||
4620 | 115387 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 34 Madrone Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x8 | 5992895.1 | 2098893.2 | 37.7427526388588 | -122.467212790357 | (37.7427526388588, -122.467212790357) | 1 | 8 | 4 | 59 | 40 | |||
4733 | 70369 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1454 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5983117.2046 | 2105238.7271 | 37.7596064047755 | -122.50149073173 | (37.7596064047755, -122.50149073173) | 1 | 8 | 3 | 56 | 35 | |||
5020 | 183923 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2290 24th Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5988873.2152 | 2100272.077 | 37.7463056861858 | -122.481220108991 | (37.7463056861858, -122.481220108991) | 1 | 8 | 3 | 29491 | 35 | |||
5395 | 214900 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 69 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992595.17834 | 2098673.73573 | 37.7421327279347 | -122.468233863115 | (37.7421327279347, -122.468233863115) | 1 | 8 | 4 | 59 | 40 | |||
5603 | 36757 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1578 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39522 | 5993099.35503511 | 2104739.07158377 | 37.7588156897013 | -122.466931435386 | (37.7588156897013, -122.466931435386) | 1 | 8 | 4 | 56 | 12 | |||
5775 | 182783 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1790 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 5989709.7208 | 2103167.237 | 37.7543036278795 | -122.478539284935 | (37.7543036278795, -122.478539284935) | 1 | 8 | 3 | 56 | 35 | |||
5875 | 99834 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1399X FUNSTON AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | Permit Number 44828 | 5992090 | 2106254 | 37.7629169745179 | -122.470532554608 | (37.7629169745179, -122.470532554608) | 1 | 8 | 11 | 56 | 12 | ||
5881 | 101267 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2230 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2019 06:01:00 PM | 3 | 3x3 | 5988779 | 2106526 | 37.7634718046826 | -122.482003947791 | (37.7634718046826, -122.482003947791) | 1 | 8 | 3 | 56 | 35 | ||
6071 | 258212 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2501 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5987967 | 2106401 | 37.7630813299835 | -122.484803190012 | (37.7630813299835, -122.484803190012) | 1 | 8 | 3 | 56 | 35 | ||||
6095 | 261222 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1890 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2020 12:00:00 AM | 3 | 5x5 | 5982931 | 2102276 | 37.751460650826 | -122.501915490969 | (37.751460650826, -122.501915490969) | 1 | 8 | 3 | 56 | 35 | |
6260 | 215528 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994077.87758 | 2097807.84952 | 37.7398407436586 | -122.463044382805 | (37.7398407436586, -122.463044382805) | 1 | 8 | 4 | 59 | 40 | |||
6264 | 45045 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2310 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/2001 12:00:00 AM | 5 | 6x7.5 | Permit Number 43931 | 5988588.7333 | 2099576.402 | 37.7443790032439 | -122.482152844384 | (37.7443790032439, -122.482152844384) | 1 | 8 | 3 | 29491 | 35 |
6888 | 218618 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 420 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5993537.76675 | 2105312.92426 | 37.7604166340443 | -122.465456904135 | (37.7604166340443, -122.465456904135) | 1 | 8 | 11 | 56 | 12 | |||
6902 | 60051 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1435 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/1982 12:00:00 AM | 1 | Permit Number 53408 | 5988341.1998 | 2105537.0323 | 37.7607308969178 | -122.483445635266 | (37.7607308969178, -122.483445635266) | 1 | 8 | 3 | 56 | 35 | |
7361 | 101278 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2323 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 5988461 | 2106418 | 37.7631567663104 | -122.483095878101 | (37.7631567663104, -122.483095878101) | 1 | 8 | 3 | 56 | 35 | |||
7410 | 181709 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3345 Lincoln Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5985298.0363 | 2107014.13 | 37.7646090072485 | -122.4940792882 | (37.7646090072485, -122.4940792882) | 1 | 8 | 3 | 56 | 35 | |||
7746 | 183279 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1266 40th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2020 12:00:00 AM | 3 | Width 0ft | 5983691.9101 | 2106542.6848 | 37.7632204410264 | -122.499599515641 | (37.7632204410264, -122.499599515641) | 1 | 8 | 3 | 56 | 35 | ||
7879 | 44719 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1996 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2001 12:00:00 AM | 4 | Permit Number 43840 | 5989755.3727 | 2101809.9749 | 37.7505795958207 | -122.478282176517 | (37.7505795958207, -122.478282176517) | 1 | 8 | 3 | 29491 | 35 | ||
7969 | 85906 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2254 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988263.956 | 2099971.0192 | 37.7454436220707 | -122.483304764 | (37.7454436220707, -122.483304764) | 1 | 8 | 3 | 29491 | 35 | ||
8072 | 218709 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 505 Pacheco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5993385.55576 | 2101846.28179 | 37.7508893502708 | -122.465731455467 | (37.7508893502708, -122.465731455467) | 1 | 8 | 4 | 29491 | 40 | |||
8074 | 86491 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1610 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987803.6185 | 2104298.7956 | 37.7572997330502 | -122.485214007697 | (37.7572997330502, -122.485214007697) | 1 | 8 | 3 | 56 | 35 | ||
8139 | 72882 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2610 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5988659.6012 | 2097522.8498 | 37.7387446083711 | -122.481757414628 | (37.7387446083711, -122.481757414628) | 1 | 8 | 3 | 29491 | 35 | |||
8819 | 218630 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 823 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/2016 12:00:00 AM | 1 | Width 3ft | Permit Number 777479 | 5990637.31518 | 2099027.3446 | 37.7429903745186 | -122.475029277203 | (37.7429903745186, -122.475029277203) | 1 | 8 | 4 | 29491 | 40 | |
8851 | 218714 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 80 Linares Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5994120.79386 | 2102087.9404 | 37.7515952659274 | -122.463206485604 | (37.7515952659274, -122.463206485604) | 1 | 8 | 4 | 29491 | 40 | |||
8882 | 86419 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2315 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988234.1046 | 2099528.0173 | 37.7442255186266 | -122.483375515142 | (37.7442255186266, -122.483375515142) | 1 | 8 | 3 | 29491 | 35 | ||
8987 | 258434 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2539 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2019 06:04:00 PM | 3 | 3x3 | 5987814 | 2106396 | 37.7630586892031 | -122.485331991607 | (37.7630586892031, -122.485331991607) | 1 | 8 | 3 | 56 | 35 | ||
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 | ||
9127 | 95439 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1874 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 3x3 | Permit Number 767301 | 5986339.2 | 2102491.9 | 37.7522530747906 | -122.490145565656 | (37.7522530747906, -122.490145565656) | 1 | 8 | 3 | 56 | 35 | |
9382 | 261223 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1423 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2019 12:00:00 AM | 3 | 4x6 | 5983358 | 2105437 | 37.7601649454773 | -122.500672615898 | (37.7601649454773, -122.500672615898) | 1 | 8 | 3 | 56 | 35 | |
9772 | 95689 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2415 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767440 | 5982968.9 | 2098671.4 | 37.7415656423265 | -122.501517800216 | (37.7415656423265, -122.501517800216) | 1 | 8 | 3 | 29491 | 35 | |
10145 | 71168 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2186 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5988245.3089 | 2100453.2879 | 37.7467667189168 | -122.483404589395 | (37.7467667189168, -122.483404589395) | 1 | 8 | 3 | 29491 | 35 | |||
10279 | 184173 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1655 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2020 12:00:00 AM | 3 | 3x3 | 5985600.4798 | 2103955.1922 | 37.7562277056326 | -122.492807908824 | (37.7562277056326, -122.492807908824) | 1 | 8 | 3 | 56 | 35 | ||
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 | ||
10409 | 256902 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2051 34th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782737 | 5985693.46852 | 2101265.2111 | 37.7488471905551 | -122.492288254945 | (37.7488471905551, -122.492288254945) | 1 | 8 | 3 | 29491 | 35 | |
10594 | 93463 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1739 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/28/2017 01:05:00 PM | 3 | 3x3 | 5987772.1588 | 2098929.0107 | 37.7425539090053 | -122.484928867121 | (37.7425539090053, -122.484928867121) | 1 | 8 | 3 | 29491 | 35 | ||
10623 | 211213 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 45 Dorantes Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 34 | Width 3ft | 5994039.80885 | 2100040.77009 | 37.7459695901264 | -122.463337999768 | (37.7459695901264, -122.463337999768) | 1 | 8 | 4 | 29491 | 40 | |||
10640 | 41309 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 34 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2000 12:00:00 AM | Permit Number 41981 | 5992910.03093479 | 2098919.83529447 | 37.7428266345167 | -122.467163100034 | (37.7428266345167, -122.467163100034) | 1 | 8 | 4 | 59 | 40 | |||
10784 | 182179 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1899 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5988456.0889 | 2104402.0801 | 37.7576213116198 | -122.482965106086 | (37.7576213116198, -122.482965106086) | 1 | 8 | 3 | 56 | 35 | |||
11018 | 258435 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2511 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2019 06:07:00 PM | 3 | 3x3 | 5987985 | 2106413 | 37.7631153270305 | -122.484741815217 | (37.7631153270305, -122.484741815217) | 1 | 8 | 3 | 56 | 35 | ||
11042 | 261805 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1287 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2020 12:00:00 AM | 3 | 5x5 | 5985805 | 2106480 | 37.7631720865119 | -122.49228652724 | (37.7631720865119, -122.49228652724) | 1 | 8 | 3 | 56 | 35 | ||
11044 | 182369 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1506 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2020 12:00:00 AM | 3 | 4x4 | 5985301.1453 | 2104914.1641 | 37.7588432684324 | -122.493913764581 | (37.7588432684324, -122.493913764581) | 1 | 8 | 3 | 56 | 35 | ||
11587 | 184946 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000 41st Ave | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | FUF | 3 | 3x10 | 5983552 | 2101519 | 37.7494185989562 | -122.499712087956 | (37.7494185989562, -122.499712087956) | 1 | 8 | 3 | 29491 | 35 | ||
11626 | 262262 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1324 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2020 12:00:00 AM | 3 | 4x4 | Permit Number 784290 | 5993653.14185 | 2106470.72632 | 37.763602309694 | -122.465141974097 | (37.763602309694, -122.465141974097) | 1 | 8 | 11 | 56 | 12 | |
11652 | 218696 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2290 14th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992021.2645 | 2099916.70116 | 37.7455124296592 | -122.470308755549 | (37.7455124296592, -122.470308755549) | 1 | 8 | 4 | 29491 | 40 | |||
11708 | 86525 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1427 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2006 12:00:00 AM | 3 | 3x3 | 5987718.830744 | 2105574.527974 | 37.7607976071546 | -122.4856008555 | (37.7607976071546, -122.4856008555) | 1 | 8 | 3 | 56 | 35 | ||
12143 | 214862 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1380 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5992741.54711 | 2106079.28932 | 37.7624749178083 | -122.468266387997 | (37.7624749178083, -122.468266387997) | 1 | 8 | 11 | 56 | 12 | |||
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 | ||
12476 | 78459 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2912 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5990004.06273 | 2095836.28778 | 37.7341918338916 | -122.476985746011 | (37.7341918338916, -122.476985746011) | 1 | 8 | 4 | 64 | 35 | |||
13358 | 218639 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 34 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5992909.97248 | 2098898.73996 | 37.7427687086985 | -122.467161768702 | (37.7427687086985, -122.467161768702) | 1 | 8 | 4 | 59 | 40 | |||
13535 | 82196 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1615 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5988380.7024 | 2104309.4625 | 37.7573626218542 | -122.483219031327 | (37.7573626218542, -122.483219031327) | 1 | 8 | 3 | 56 | 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) );