trees
1,377 rows where qSpecies_id = 61 sorted by qLegalStatus_id 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20401 | 140131 | Permitted Site 7 | Tristania conferta :: 61 | 501 GOUGH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/2002 12:00:00 AM | 5 | Width 0ft | 6005847.0047 | 2111508.1975 | 37.7781296085056 | -122.423325305774 | (37.7781296085056, -122.423325305774) | 7 | 9 | 11 | 28852 | 10 | ||
| 24778 | 115380 | Permitted Site 7 | Tristania conferta :: 61 | 1657X York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 775521 | 6010720.61658 | 2099977.21326 | 37.7467419766429 | -122.405653246985 | (37.7467419766429, -122.405653246985) | 2 | 7 | 7 | 28859 | 2 | ||
| 28143 | 7043 | Permitted Site 7 | Tristania conferta :: 61 | 1300 Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2010 12:00:00 AM | 12 | 3X3 | 6001130.7028 | 2110062.144 | 37.773891804124 | -122.439536974078 | (37.773891804124, -122.439536974078) | 15 | 5 | 11 | 29492 | 10 | ||
| 36704 | 111994 | Permitted Site 7 | Tristania conferta :: 61 | 1244 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2015 12:00:00 AM | 3 | 3x3 | 5993400.7 | 2107017.1 | 37.7650879480266 | -122.466054789326 | (37.7650879480266, -122.466054789326) | 11 | 8 | 11 | 56 | 12 | ||
| 48284 | 158174 | Permitted Site 7 | Tristania conferta :: 61 | 134 Miguel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781228 | 6004059.11028 | 2096889.51678 | 37.7378891113908 | -122.428468031191 | (37.7378891113908, -122.428468031191) | 2 | 7 | 5 | 63 | 7 |
| 58879 | 49069 | Permitted Site 7 | Tristania conferta :: 61 | 1298 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2015 12:00:00 AM | 3x3 | Permit Number 776020 | 5995836.31315767 | 2092013.47244835 | 37.7240319217297 | -122.45654557668 | (37.7240319217297, -122.45654557668) | 9 | 8 | 4 | 28861 | 40 | ||
| 66530 | 122823 | Permitted Site 7 | Tristania conferta :: 61 | 1736 Stockton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 4x4 | 6010043.2132 | 2120098.5684 | 37.8019526289989 | -122.409415446027 | (37.8019526289989, -122.409415446027) | 3 | 1 | 10 | 308 | 23 | ||
| 75375 | 158175 | Permitted Site 7 | Tristania conferta :: 61 | 300 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781228 | 6004086.99843 | 2096830.17567 | 37.7377277523181 | -122.428367379954 | (37.7377277523181, -122.428367379954) | 2 | 7 | 5 | 63 | 7 |
| 76664 | 109151 | Permitted Site 7 | Tristania conferta :: 61 | 727 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 769036 | 5986896.6 | 2110966.4 | 37.7755542438819 | -122.48884090533 | (37.7755542438819, -122.48884090533) | 11 | 6 | 2 | 55 | 26 |
| 87850 | 54270 | Permitted Site 7 | Tristania conferta :: 61 | 1240 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2015 12:00:00 AM | 3 | Permit Number 10023 | 5993331.28695265 | 2107027.13972063 | 37.7651115096687 | -122.466295599736 | (37.7651115096687, -122.466295599736) | 11 | 8 | 11 | 56 | 12 | ||
| 95289 | 115299 | Permitted Site 7 | Tristania conferta :: 61 | 177 Lomita Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 775793 | 5991298.7 | 2104254.5 | 37.757381090716 | -122.473123533862 | (37.757381090716, -122.473123533862) | 1 | 8 | 4 | 56 | 12 | |||
| 97027 | 115300 | Permitted Site 7 | Tristania conferta :: 61 | 177 Lomita Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 775793 | 5991298.7 | 2104254.5 | 37.757381090716 | -122.473123533862 | (37.757381090716, -122.473123533862) | 1 | 8 | 4 | 56 | 12 | |||
| 103346 | 248512 | Permitted Site 7 | Tristania conferta :: 61 | 19 Beulah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1979 12:00:00 AM | 17 | Width 0ft | Permit Number 17888 | 5997839.8141 | 2107820.479 | 37.7675489217125 | -122.450758985918 | (37.7675489217125, -122.450758985918) | 15 | 5 | 11 | 29492 | 9 | |
| 104677 | 111746 | Permitted Site 7 | Tristania conferta :: 61 | 398X 03rd St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/22/2015 12:00:00 AM | 3 | 10x20 | Permit Number 775763 | 6013296.04718 | 2113048.21405 | 37.7827757318295 | -122.397664238011 | (37.7827757318295, -122.397664238011) | 6 | 2 | 9 | 28856 | 34 | |
| 148527 | 119142 | Permitted Site 7 | Tristania conferta :: 61 | 583 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781376 | 5981295.16505 | 2111765.56723 | 37.7774200299425 | -122.508276611938 | (37.7774200299425, -122.508276611938) | 11 | 6 | 2 | 55 | 26 |
| 160101 | 200822 | Permitted Site 7 | Tristania conferta :: 61 | 5266 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/16/2018 11:25:00 AM | 4 | Width 0ft | 6014368.9731 | 2093728.901 | 37.7297887395904 | -122.392600482998 | (37.7297887395904, -122.392600482998) | 10 | 3 | 8 | 58 | 1 | ||
| 172109 | 111747 | Permitted Site 7 | Tristania conferta :: 61 | 398X 03rd St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/22/2015 12:00:00 AM | 3 | 10x20 | Permit Number 775763 | 6013296.04718 | 2113048.21405 | 37.7827757318295 | -122.397664238011 | (37.7827757318295, -122.397664238011) | 6 | 2 | 9 | 28856 | 34 | |
| 173272 | 22329 | Permitted Site 7 | Tristania conferta :: 61 | 5166 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/2001 12:00:00 AM | 3 | 3X3 | 6014522.2059 | 2094241.4361 | 37.7312045661254 | -122.392106565106 | (37.7312045661254, -122.392106565106) | 10 | 3 | 8 | 58 | 1 | ||
| 185914 | 99306 | Permitted Site 7 | Tristania conferta :: 61 | 1345 Turk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2012 12:00:00 AM | 3x3 | Permit Number 768843 | 6003605.0174 | 2112439.8748 | 37.780560974986 | -122.43114766452 | (37.780560974986, -122.43114766452) | 15 | 9 | 11 | 29490 | 41 | ||
| 369 | 138522 | Undocumented 4 | Tristania conferta :: 61 | 1602 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6001658.1955 | 2114019.9111 | 37.7847888393579 | -122.437995843174 | (37.7847888393579, -122.437995843174) | 13 | 6 | 11 | 29490 | 13 | |||
| 32994 | 257945 | Undocumented 4 | Tristania conferta :: 61 | 901x Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005635 | 2113075 | 37.782419697088 | -122.42417016492 | (37.782419697088, -122.42417016492) | 7 | 9 | 11 | 28852 | 41 | ||||
| 70529 | 200821 | Undocumented 4 | Tristania conferta :: 61 | 5210 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6014424.8043 | 2093925.5984 | 37.7303319313757 | -122.392421219379 | (37.7303319313757, -122.392421219379) | 10 | 3 | 8 | 58 | 1 | |||
| 72043 | 257947 | Undocumented 4 | Tristania conferta :: 61 | 901x Gough St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005635 | 2113075 | 37.782419697088 | -122.42417016492 | (37.782419697088, -122.42417016492) | 7 | 9 | 11 | 28852 | 41 | ||||
| 82752 | 257946 | Undocumented 4 | Tristania conferta :: 61 | 901x Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005635 | 2113075 | 37.782419697088 | -122.42417016492 | (37.782419697088, -122.42417016492) | 7 | 9 | 11 | 28852 | 41 | ||||
| 91678 | 257943 | Undocumented 4 | Tristania conferta :: 61 | 901x Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005635 | 2113075 | 37.782419697088 | -122.42417016492 | (37.782419697088, -122.42417016492) | 7 | 9 | 11 | 28852 | 41 | ||||
| 103530 | 113554 | Undocumented 4 | Tristania conferta :: 61 | 400X Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6007659.5152 | 2112834.4553 | 37.7818733205533 | -122.4171491612 | (37.7818733205533, -122.4171491612) | 7 | 9 | 9 | 28852 | 36 | |||
| 122790 | 257949 | Undocumented 4 | Tristania conferta :: 61 | 901x Gough St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005635 | 2113075 | 37.782419697088 | -122.42417016492 | (37.782419697088, -122.42417016492) | 7 | 9 | 11 | 28852 | 41 | ||||
| 128744 | 257950 | Undocumented 4 | Tristania conferta :: 61 | 901x Gough St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005635 | 2113075 | 37.782419697088 | -122.42417016492 | (37.782419697088, -122.42417016492) | 7 | 9 | 11 | 28852 | 41 | ||||
| 129159 | 247296 | Undocumented 4 | Tristania conferta :: 61 | 759 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6002955.2349 | 2109573.4516 | 37.7726536468991 | -122.433190698089 | (37.7726536468991, -122.433190698089) | 15 | 5 | 11 | 29492 | 9 | |||
| 138329 | 200932 | Undocumented 4 | Tristania conferta :: 61 | 4101 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6015570.0337 | 2097446.6824 | 37.7400636451013 | -122.388707674257 | (37.7400636451013, -122.388707674257) | 10 | 3 | 8 | 58 | 1 | |||
| 141864 | 246311 | Undocumented 4 | Tristania conferta :: 61 | 1601 Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6007089.8834 | 2109370.8451 | 37.772331017243 | -122.418874102872 | (37.772331017243, -122.418874102872) | 8 | 2 | 9 | 28853 | 19 | |||
| 160460 | 257944 | Undocumented 4 | Tristania conferta :: 61 | 901x Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005635 | 2113075 | 37.782419697088 | -122.42417016492 | (37.782419697088, -122.42417016492) | 7 | 9 | 11 | 28852 | 41 | ||||
| 161319 | 257953 | Undocumented 4 | Tristania conferta :: 61 | 901x Gough St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005635 | 2113075 | 37.782419697088 | -122.42417016492 | (37.782419697088, -122.42417016492) | 7 | 9 | 11 | 28852 | 41 | ||||
| 161373 | 255639 | Undocumented 4 | Tristania conferta :: 61 | 200 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999023 | 2112089 | 37.7793368479896 | -122.446973720271 | (37.7793368479896, -122.446973720271) | 15 | 5 | 1 | 54 | 16 | ||||
| 187605 | 257952 | Undocumented 4 | Tristania conferta :: 61 | 901x Gough St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005635 | 2113075 | 37.782419697088 | -122.42417016492 | (37.782419697088, -122.42417016492) | 7 | 9 | 11 | 28852 | 41 | ||||
| 190547 | 257948 | Undocumented 4 | Tristania conferta :: 61 | 901x Gough St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005635 | 2113075 | 37.782419697088 | -122.42417016492 | (37.782419697088, -122.42417016492) | 7 | 9 | 11 | 28852 | 41 | ||||
| 130 | 13128 | DPW Maintained 1 | Tristania conferta :: 61 | 1714 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6004131.2449 | 2119777.2826 | 37.8007374433085 | -122.429850711739 | (37.8007374433085, -122.429850711739) | 13 | 9 | 1 | 57 | 17 | |||
| 209 | 138219 | DPW Maintained 1 | Tristania conferta :: 61 | 101 Anza St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5998675.4325 | 2112652.6916 | 37.7808647356786 | -122.448216697429 | (37.7808647356786, -122.448216697429) | 15 | 6 | 2 | 54 | 16 | |||
| 303 | 87474 | DPW Maintained 1 | Tristania conferta :: 61 | 6290 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x5 | 6013182.5276 | 2090518.895 | 37.7209087510834 | -122.39647726989 | (37.7209087510834, -122.39647726989) | 10 | 3 | 8 | 58 | 1 | |||
| 788 | 200933 | DPW Maintained 1 | Tristania conferta :: 61 | 4210 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6015403.5213 | 2097186.1672 | 37.7393390938031 | -122.389265224086 | (37.7393390938031, -122.389265224086) | 10 | 3 | 8 | 58 | 1 | |||
| 899 | 9520 | DPW Maintained 1 | Tristania conferta :: 61 | 1046 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2000 12:00:00 AM | 3 | 3X3 | 6004532.0878 | 2112270.4724 | 37.7801483287397 | -122.427928412048 | (37.7801483287397, -122.427928412048) | 7 | 9 | 11 | 29490 | 41 | ||
| 1099 | 138916 | DPW Maintained 1 | Tristania conferta :: 61 | 707 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004396.0968 | 2110813.5411 | 37.7761402601039 | -122.428295000541 | (37.7761402601039, -122.428295000541) | 7 | 9 | 11 | 28852 | 10 | |||
| 1178 | 7095 | DPW Maintained 1 | Tristania conferta :: 61 | 1970 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1994 12:00:00 AM | 18 | 3X3 | 5998027.6156 | 2109626.606 | 37.7725188329855 | -122.45023961224 | (37.7725188329855, -122.45023961224) | 15 | 5 | 11 | 29492 | 16 | ||
| 1224 | 81614 | DPW Maintained 1 | Tristania conferta :: 61 | 1450@ Shafter Hawes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6017097.2029 | 2092677.3305 | 37.7270524726432 | -122.383095431375 | (37.7270524726432, -122.383095431375) | 10 | 3 | 8 | 58 | 1 | |||
| 1445 | 140697 | DPW Maintained 1 | Tristania conferta :: 61 | 859 MASONIC AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999231.335 | 2109939.9835 | 37.7734481000077 | -122.446098386426 | (37.7734481000077, -122.446098386426) | 15 | 5 | 11 | 29492 | 16 | |||
| 1715 | 122822 | DPW Maintained 1 | Tristania conferta :: 61 | 1736 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6010044.5984 | 2120081.0225 | 37.8019045299018 | -122.409409413578 | (37.8019045299018, -122.409409413578) | 3 | 1 | 10 | 308 | 23 | |||
| 2490 | 195264 | DPW Maintained 1 | Tristania conferta :: 61 | 681 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 771659 | 6011775.98455 | 2114888.82062 | 37.7877448438967 | -122.403052549837 | (37.7877448438967, -122.403052549837) | 12 | 2 | 9 | 28855 | 6 | |
| 2931 | 6985 | DPW Maintained 1 | Tristania conferta :: 61 | 819 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2008 12:00:00 AM | 3 | 3X3 | 6003479.628 | 2110333.4443 | 37.7747701331995 | -122.431431030712 | (37.7747701331995, -122.431431030712) | 15 | 9 | 11 | 29492 | 10 | ||
| 3148 | 24262 | DPW Maintained 1 | Tristania conferta :: 61 | 600X Willow St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/19/2004 12:00:00 AM | 3 | 3X3 | 6004514.0905 | 2113119.5269 | 37.7824786038336 | -122.428051195433 | (37.7824786038336, -122.428051195433) | 7 | 9 | 11 | 29490 | 41 | ||
| 3420 | 79436 | DPW Maintained 1 | Tristania conferta :: 61 | 606 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6004047.0413 | 2110853.2815 | 37.7762296204821 | -122.429505312147 | (37.7762296204821, -122.429505312147) | 7 | 9 | 11 | 28852 | 10 | |||
| 3600 | 23929 | DPW Maintained 1 | Tristania conferta :: 61 | 1715 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/1992 12:00:00 AM | 20 | 4X4 | 6003463.555 | 2114659.6298 | 37.7866478474124 | -122.431795587112 | (37.7866478474124, -122.431795587112) | 13 | 9 | 11 | 29490 | 27 | ||
| 3625 | 22438 | DPW Maintained 1 | Tristania conferta :: 61 | 6025 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6013608.4406 | 2091403.3166 | 37.7233608886837 | -122.395066921688 | (37.7233608886837, -122.395066921688) | 10 | 3 | 8 | 58 | 1 | |||
| 3754 | 261321 | DPW Maintained 1 | Tristania conferta :: 61 | 2353 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001169.3018 | 2119289.54 | 37.7992300540772 | -122.440065245785 | (37.7992300540772, -122.440065245785) | 13 | 9 | 1 | 57 | 17 | ||||
| 3757 | 29485 | DPW Maintained 1 | Tristania conferta :: 61 | 1608 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2006 12:00:00 AM | 12 | 3x3 | 6016787.6638 | 2093383.8729 | 37.7289753898862 | -122.38421469762 | (37.7289753898862, -122.38421469762) | 10 | 3 | 8 | 58 | 1 | ||
| 4020 | 22395 | DPW Maintained 1 | Tristania conferta :: 61 | 5700 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/31/2011 12:00:00 AM | 6 | 3x3 | 6013894.8509 | 2092365.7305 | 37.7260194067343 | -122.394144192498 | (37.7260194067343, -122.394144192498) | 10 | 3 | 8 | 58 | 1 | ||
| 4029 | 138227 | DPW Maintained 1 | Tristania conferta :: 61 | 101 Anza St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5998554.9543 | 2112632.7248 | 37.7808030238066 | -122.448632050181 | (37.7808030238066, -122.448632050181) | 15 | 6 | 2 | 54 | 16 | |||
| 4086 | 69819 | DPW Maintained 1 | Tristania conferta :: 61 | 3521 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5983899.4988 | 2104926.7311 | 37.7587956653789 | -122.498762161048 | (37.7587956653789, -122.498762161048) | 1 | 8 | 3 | 56 | 35 | |||
| 4210 | 29504 | DPW Maintained 1 | Tristania conferta :: 61 | 1800X Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2006 12:00:00 AM | 12 | 3x3 | 6016442.8409 | 2092919.0689 | 37.7276800583286 | -122.385374410624 | (37.7276800583286, -122.385374410624) | 10 | 3 | 8 | 58 | 1 | ||
| 4257 | 4614 | DPW Maintained 1 | Tristania conferta :: 61 | 347 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/1991 12:00:00 AM | 30 | 3x3 | 6010525.6854 | 2118803.2675 | 37.7984230708943 | -122.407654474652 | (37.7984230708943, -122.407654474652) | 3 | 1 | 10 | 308 | 4 | ||
| 4598 | 140349 | DPW Maintained 1 | Tristania conferta :: 61 | 1314 ELLIS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6004502.4614 | 2113302.7614 | 37.7829810622913 | -122.428104489199 | (37.7829810622913, -122.428104489199) | 7 | 9 | 11 | 29490 | 41 | |||
| 4786 | 70866 | DPW Maintained 1 | Tristania conferta :: 61 | 499 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6005878.7494 | 2111261.8484 | 37.7774549853258 | -122.423197973584 | (37.7774549853258, -122.423197973584) | 7 | 9 | 11 | 28852 | 10 | |||
| 4802 | 65984 | DPW Maintained 1 | Tristania conferta :: 61 | 1520 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1990 12:00:00 AM | 14 | Permit Number 29013 | 6010137.4433 | 2119339.4921 | 37.7998736715658 | -122.409035773182 | (37.7998736715658, -122.409035773182) | 3 | 1 | 10 | 308 | 23 | |
| 4874 | 143132 | DPW Maintained 1 | Tristania conferta :: 61 | 2435 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6000754.0798 | 2119231.0352 | 37.7990457686205 | -122.441497852636 | (37.7990457686205, -122.441497852636) | 13 | 9 | 1 | 57 | 17 | |||
| 4880 | 10701 | DPW Maintained 1 | Tristania conferta :: 61 | 1290 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6001704.3359 | 2110485.9297 | 37.7750880443133 | -122.437583041692 | (37.7750880443133, -122.437583041692) | 15 | 5 | 11 | 29492 | 10 | |||
| 5148 | 247454 | DPW Maintained 1 | Tristania conferta :: 61 | 563 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6003114.7156 | 2110238.7499 | 37.7744894374273 | -122.432686570898 | (37.7744894374273, -122.432686570898) | 15 | 9 | 11 | 29492 | 10 | |||
| 5348 | 72411 | DPW Maintained 1 | Tristania conferta :: 61 | 475 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6x6 | 6010101.0381 | 2120567.585 | 37.8032436723817 | -122.409248460006 | (37.8032436723817, -122.409248460006) | 3 | 1 | 10 | 308 | 23 | ||
| 5368 | 73913 | DPW Maintained 1 | Tristania conferta :: 61 | 499 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6005876.1258 | 2111280.7378 | 37.7775067029674 | -122.423208392543 | (37.7775067029674, -122.423208392543) | 7 | 9 | 11 | 28852 | 10 | |||
| 5423 | 138217 | DPW Maintained 1 | Tristania conferta :: 61 | 101 Anza St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5998640.9134 | 2112646.2616 | 37.7808451071221 | -122.448335652205 | (37.7808451071221, -122.448335652205) | 15 | 6 | 2 | 54 | 16 | |||
| 5658 | 6307 | DPW Maintained 1 | Tristania conferta :: 61 | 1804 Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4x4 | 6002139.3488 | 2112974.3616 | 37.781945376326 | -122.436256362281 | (37.781945376326, -122.436256362281) | 15 | 5 | 11 | 29490 | 41 | |||
| 5852 | 83783 | DPW Maintained 1 | Tristania conferta :: 61 | 606 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6004048.7127 | 2110839.5763 | 37.7761920840099 | -122.429498552699 | (37.7761920840099, -122.429498552699) | 7 | 9 | 11 | 28852 | 10 | |||
| 5894 | 29427 | DPW Maintained 1 | Tristania conferta :: 61 | 2501X Ingalls St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6015373.5361 | 2091407.2745 | 37.7234697537221 | -122.388965539304 | (37.7234697537221, -122.388965539304) | 10 | 3 | 8 | 58 | 1 | ||
| 5979 | 137873 | DPW Maintained 1 | Tristania conferta :: 61 | 1805 PINE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6005262.4155 | 2115445.1649 | 37.7889065369741 | -122.425627888461 | (37.7889065369741, -122.425627888461) | 13 | 9 | 11 | 28858 | 27 | |||
| 6244 | 138902 | DPW Maintained 1 | Tristania conferta :: 61 | 518 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6004070.6412 | 2110683.9615 | 37.7757660455959 | -122.42941159626 | (37.7757660455959, -122.42941159626) | 7 | 9 | 11 | 28852 | 10 | |||
| 6267 | 200934 | DPW Maintained 1 | Tristania conferta :: 61 | 4220 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6015398.3252 | 2097166.7998 | 37.7392856268198 | -122.389281837998 | (37.7392856268198, -122.389281837998) | 10 | 3 | 8 | 58 | 1 | |||
| 6338 | 141477 | DPW Maintained 1 | Tristania conferta :: 61 | 25 KITTREDGE TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5997952.6249 | 2111528.1769 | 37.777735763362 | -122.450636133087 | (37.777735763362, -122.450636133087) | 15 | 6 | 2 | 54 | 16 | |||
| 6704 | 13114 | DPW Maintained 1 | Tristania conferta :: 61 | 1618 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2005 12:00:00 AM | 12 | 3x3 | 6004576.6984 | 2119842.3294 | 37.800941260536 | -122.428313896065 | (37.800941260536, -122.428313896065) | 13 | 9 | 1 | 57 | 17 | ||
| 6717 | 138911 | DPW Maintained 1 | Tristania conferta :: 61 | 723 HAYES ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004266.8521 | 2110794.1209 | 37.776079623036 | -122.428740708053 | (37.776079623036, -122.428740708053) | 7 | 9 | 11 | 28852 | 10 | |||
| 6940 | 140679 | DPW Maintained 1 | Tristania conferta :: 61 | 1303 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004187.9883 | 2112981.79 | 37.7820819575387 | -122.429169542785 | (37.7820819575387, -122.429169542785) | 7 | 9 | 11 | 29490 | 41 | |||
| 7492 | 138882 | DPW Maintained 1 | Tristania conferta :: 61 | 510 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6004088.2198 | 2110564.2595 | 37.7754383685459 | -122.429342249625 | (37.7754383685459, -122.429342249625) | 7 | 9 | 11 | 28852 | 10 | |||
| 7542 | 247487 | DPW Maintained 1 | Tristania conferta :: 61 | 312 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6002757.5424 | 2109611.6714 | 37.772747372498 | -122.433877269198 | (37.772747372498, -122.433877269198) | 15 | 5 | 11 | 29492 | 9 | |||
| 7868 | 140649 | DPW Maintained 1 | Tristania conferta :: 61 | 109 Shrader St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5997299.8022 | 2110011.7822 | 37.7735347493893 | -122.452784984309 | (37.7735347493893, -122.452784984309) | 15 | 5 | 2 | 29492 | 16 | |||
| 8629 | 29437 | DPW Maintained 1 | Tristania conferta :: 61 | 2307X Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6015612.318 | 2091732.5629 | 37.7243761643823 | -122.388162796666 | (37.7243761643823, -122.388162796666) | 10 | 3 | 8 | 58 | 1 | ||
| 8657 | 6306 | DPW Maintained 1 | Tristania conferta :: 61 | 1804 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6002160.6694 | 2112978.761 | 37.7819586673159 | -122.436182917866 | (37.7819586673159, -122.436182917866) | 15 | 5 | 11 | 29490 | 41 | |||
| 8686 | 199711 | DPW Maintained 1 | Tristania conferta :: 61 | 1510 Wallace Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6015245.4888 | 2092572.1176 | 37.7266610833371 | -122.389489489481 | (37.7266610833371, -122.389489489481) | 10 | 3 | 8 | 58 | 1 | |||
| 8843 | 57906 | DPW Maintained 1 | Tristania conferta :: 61 | 643 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1982 12:00:00 AM | 13 | Permit Number 20197 | 6000071.8454 | 2111132.0779 | 37.7767692506982 | -122.443276587526 | (37.7767692506982, -122.443276587526) | 15 | 5 | 11 | 29492 | 16 | |
| 8845 | 21605 | DPW Maintained 1 | Tristania conferta :: 61 | 1521 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4X4 | 6005164.0288 | 2114740.1913 | 37.7869652957353 | -122.425918090858 | (37.7869652957353, -122.425918090858) | 13 | 9 | 11 | 28858 | 13 | |||
| 8910 | 74145 | DPW Maintained 1 | Tristania conferta :: 61 | 499 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6005875.6011 | 2111298.5777 | 37.7775556573861 | -122.423211476089 | (37.7775556573861, -122.423211476089) | 7 | 9 | 11 | 28852 | 10 | |||
| 9366 | 13179 | DPW Maintained 1 | Tristania conferta :: 61 | 1976 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/14/1997 12:00:00 AM | 14 | 3X3 | 6002902.1538 | 2119607.7128 | 37.8002021701058 | -122.434091743886 | (37.8002021701058, -122.434091743886) | 13 | 9 | 1 | 57 | 17 | ||
| 10009 | 141171 | DPW Maintained 1 | Tristania conferta :: 61 | 1804 ELLIS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6002115.9977 | 2112972.331 | 37.7819384740439 | -122.436337000836 | (37.7819384740439, -122.436337000836) | 15 | 5 | 11 | 29490 | 41 | |||
| 10110 | 13676 | DPW Maintained 1 | Tristania conferta :: 61 | 681 Market St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2020 12:00:00 AM | 3 | 4X4 | Permit Number 771659 | 6011822.15902 | 2114934.32739 | 37.7878723731553 | -122.402895995877 | (37.7878723731553, -122.402895995877) | 12 | 2 | 9 | 28855 | 6 | |
| 10761 | 60596 | DPW Maintained 1 | Tristania conferta :: 61 | 1773 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1982 12:00:00 AM | 18 | Permit Number 20216 | 6000702.1439 | 2111336.8084 | 37.7773673101232 | -122.441110894469 | (37.7773673101232, -122.441110894469) | 15 | 5 | 11 | 29492 | 41 | |
| 10876 | 13180 | DPW Maintained 1 | Tristania conferta :: 61 | 1990 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1993 12:00:00 AM | 15 | 3X3 | 6002882.226 | 2119605.2218 | 37.8001941994801 | -122.434160523596 | (37.8001941994801, -122.434160523596) | 13 | 9 | 1 | 57 | 17 | ||
| 10885 | 13675 | DPW Maintained 1 | Tristania conferta :: 61 | 681 Market St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2020 12:00:00 AM | 3 | 4X4 | Permit Number 771659 | 6011805.84433 | 2114919.40836 | 37.7878304980227 | -122.402951392291 | (37.7878304980227, -122.402951392291) | 12 | 2 | 9 | 28855 | 6 | |
| 10938 | 28832 | DPW Maintained 1 | Tristania conferta :: 61 | 1500 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2005 12:00:00 AM | 12 | 4x4 | 6016972.3335 | 2093632.2976 | 37.7296677240114 | -122.383593562534 | (37.7296677240114, -122.383593562534) | 10 | 3 | 8 | 58 | 1 | ||
| 11077 | 141992 | DPW Maintained 1 | Tristania conferta :: 61 | 818 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/31/1991 12:00:00 AM | 9 | Width 0ft | 6003994.291 | 2111559.6951 | 37.7781662710742 | -122.429738185966 | (37.7781662710742, -122.429738185966) | 7 | 9 | 11 | 29490 | 41 | ||
| 11172 | 82387 | DPW Maintained 1 | Tristania conferta :: 61 | 615 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6010004.402 | 2119511.4587 | 37.8003383958996 | -122.409508291437 | (37.8003383958996, -122.409508291437) | 3 | 1 | 10 | 308 | 23 | |||
| 11372 | 121012 | DPW Maintained 1 | Tristania conferta :: 61 | 199X Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 4x4 | 6015178.5737 | 2115521.0723 | 37.7896702844128 | -122.391324356251 | (37.7896702844128, -122.391324356251) | 6 | 2 | 9 | 28855 | 6 | |||
| 11870 | 245936 | DPW Maintained 1 | Tristania conferta :: 61 | 188 Beulah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5997210.9895 | 2107777.1744 | 37.76739400269 | -122.452930870305 | (37.76739400269, -122.452930870305) | 15 | 5 | 11 | 29492 | 9 | |||
| 11906 | 13674 | DPW Maintained 1 | Tristania conferta :: 61 | 681 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2020 12:00:00 AM | 3 | 4X4 | Permit Number 771659 | 6011788.8197 | 2114903.8104 | 37.787786719038 | -122.403009197144 | (37.787786719038, -122.403009197144) | 12 | 2 | 9 | 28855 | 6 | |
| 12207 | 6322 | DPW Maintained 1 | Tristania conferta :: 61 | 1864 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6001909.5604 | 2112942.2115 | 37.7818440417219 | -122.43704902047 | (37.7818440417219, -122.43704902047) | 15 | 5 | 11 | 29490 | 41 |
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) );