trees
455 rows where SiteOrder = 1, qLegalStatus_id = 1 and qSpecies_id = 65 sorted by Police 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6446 | 262161 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 8 Mill St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | ||||||||||||
57235 | 125546 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1070 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6007858.97154 | 2118915.83985 | 37.798582528908 | -122.416890128576 | (37.798582528908, -122.416890128576) | 5 | 1 | 10 | 308 | 32 | |||
96623 | 91462 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1001 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52106 | 6007994.73789 | 2119928.92262 | 37.8013718365043 | -122.416492132729 | (37.8013718365043, -122.416492132729) | 5 | 1 | 1 | 308 | 32 | |
145545 | 249373 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 649 Jones St | 1 | : | Tree | Private 2 | 06/22/1998 12:00:00 AM | 21 | Width 4ft | Permit Number 39973 | 6008805.56783 | 2114728.16614 | 37.7871374013058 | -122.4133182966 | (37.7871374013058, -122.4133182966) | 5 | 1 | 10 | 28852 | 36 | |
154146 | 40163 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 39201 Dashiell Hammett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Permit Number 41356 | 6010358.38502 | 2116055.23844 | 37.7908682829043 | -122.40803948753 | (37.7908682829043, -122.40803948753) | 5 | 1 | 10 | 28857 | 21 | |||
156056 | 62982 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1391 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/1991 12:00:00 AM | 20 | Permit Number 30047 | 6006920.35815 | 2118393.21581 | 37.7970946941148 | -122.420100923242 | (37.7970946941148, -122.420100923242) | 5 | 1 | 10 | 28858 | 32 | |
156364 | 125552 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 22 Dashiell Hammett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 1ft | 6010384.14225 | 2116014.5877 | 37.7907581078366 | -122.407947500375 | (37.7907581078366, -122.407947500375) | 5 | 1 | 10 | 28857 | 21 | |||
164826 | 66782 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1001 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/1991 12:00:00 AM | 14 | Permit Number 30052 | 6006921.4512 | 2120474.40868 | 37.8028091860666 | -122.420244926256 | (37.8028091860666, -122.420244926256) | 5 | 1 | 1 | 28858 | 32 | |
3939 | 53160 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1747@ 3RD ST Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2006 12:00:00 AM | 8 | Permit Number 49080 | 6014477.38224 | 2095160.1105 | 37.7337245704136 | -122.392325759332 | (37.7337245704136, -122.392325759332) | 10 | 3 | 8 | 58 | 1 | |
4010 | 32946 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 265 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/02/2018 12:00:00 AM | 3 | Permit Number 782101 | 6012936.74876 | 2105822.26722 | 37.7629149012172 | -122.398400087987 | (37.7629149012172, -122.398400087987) | 14 | 3 | 8 | 28856 | 29 | |
4665 | 255219 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 668 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x5 | 6010649.61655 | 2091566.6998 | 37.7236445235288 | -122.405306576793 | (37.7236445235288, -122.405306576793) | 10 | 3 | 7 | 309 | 28 | ||
15220 | 63283 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 42 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1987 12:00:00 AM | 11 | Permit Number 23848 | 6013931.58226 | 2095527.61 | 37.7347033259801 | -122.394238486043 | (37.7347033259801, -122.394238486043) | 10 | 3 | 8 | 58 | 1 | |
21642 | 38204 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 691 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | 14 | Permit Number 40328 | 6010720.89935 | 2091470.20831 | 37.7233835629968 | -122.405053372309 | (37.7233835629968, -122.405053372309) | 10 | 3 | 7 | 309 | 28 | |
21660 | 65231 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 812 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1989 12:00:00 AM | 10 | Permit Number 28018 | 6008328.075 | 2093605.15348 | 37.7291116131036 | -122.41347586773 | (37.7291116131036, -122.41347586773) | 9 | 3 | 7 | 309 | 28 | ||
43315 | 38214 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 331 Wayland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | 11 | Permit Number 40337 | 6010588.27199 | 2092325.30166 | 37.7257240567036 | -122.405572039215 | (37.7257240567036, -122.405572039215) | 10 | 3 | 7 | 309 | 28 | |
53408 | 37793 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 347 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/06/1998 12:00:00 AM | 15 | Permit Number 40121 | 6009401.77176 | 2092702.5768 | 37.7266935573585 | -122.409700314138 | (37.7266935573585, -122.409700314138) | 10 | 3 | 7 | 309 | 28 | |
59999 | 38206 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 756 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | 11 | Permit Number 40330 | 6010781.48445 | 2091161.67808 | 37.7225397893635 | -122.404822228563 | (37.7225397893635, -122.404822228563) | 10 | 3 | 7 | 309 | 28 | |
60136 | 108565 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 521 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772537 | 6010495.60195 | 2092202.94019 | 37.7253828953025 | -122.405883778414 | (37.7253828953025, -122.405883778414) | 10 | 3 | 7 | 309 | 28 |
60145 | 38581 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1483 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 15 | Permit Number 40541 | 6015866.8585 | 2094128.4257 | 37.7309688285238 | -122.387449938884 | (37.7309688285238, -122.387449938884) | 10 | 3 | 8 | 58 | 1 | |
65829 | 68256 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 243 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 16 | Permit Number 32061 | 6009551.9423 | 2093241.4503 | 37.7281816043806 | -122.409219186739 | (37.7281816043806, -122.409219186739) | 10 | 3 | 7 | 309 | 28 | |
77457 | 175216 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 240 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6010752.32605 | 2091460.28671 | 37.7233580771044 | -122.404944037249 | (37.7233580771044, -122.404944037249) | 10 | 3 | 7 | 309 | 28 | |||
88150 | 82830 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1475 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2009 12:00:00 AM | 9 | 3x3 | Permit Number 52467 | 6015906.1825 | 2094100.414 | 37.7308940918936 | -122.387312034756 | (37.7308940918936, -122.387312034756) | 10 | 3 | 8 | 58 | 1 | |
103811 | 189214 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1498 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6014376.75149 | 2102028.72002 | 37.7525787510095 | -122.393154121288 | (37.7525787510095, -122.393154121288) | 10 | 3 | 8 | 28856 | 29 | |||
104017 | 35736 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 351 Hale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/14/1998 12:00:00 AM | 9 | Permit Number 39011 | 6008805.61164 | 2094302.44729 | 37.731053034462 | -122.411874232722 | (37.731053034462, -122.411874232722) | 9 | 3 | 7 | 309 | 28 | |
108759 | 175185 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 526 Lathrop Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6012801.34824 | 2086611.11374 | 37.7101575412033 | -122.397520974627 | (37.7101575412033, -122.397520974627) | 10 | 3 | 8 | 309 | 1 | |||
127470 | 189220 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1652 La Salle Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 8ft | 6015291.93207 | 2096384.83865 | 37.737132622377 | -122.389595102843 | (37.737132622377, -122.389595102843) | 10 | 3 | 8 | 58 | 1 | |||
146627 | 175215 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 857 Barneveld Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 33 | Width 8ft | 6010301.67863 | 2094727.33157 | 37.7323034959049 | -122.406731980322 | (37.7323034959049, -122.406731980322) | 10 | 3 | 7 | 309 | 28 | |||
158774 | 83067 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 624 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 10 | 3x6 | Permit Number 52379 | 6012068.69574 | 2105475.40084 | 37.7619140888872 | -122.401378022999 | (37.7619140888872, -122.401378022999) | 10 | 3 | 8 | 28856 | 29 | |
160888 | 97263 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 220 Gaven St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773740 | 6009330.61336 | 2094994.97082 | 37.7329839958128 | -122.410108077526 | (37.7329839958128, -122.410108077526) | 10 | 3 | 7 | 309 | 28 | |
165874 | 38552 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1820 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 16 | Permit Number 40520 | 6015364.9925 | 2093693.5794 | 37.7297470188732 | -122.389154637038 | (37.7297470188732, -122.389154637038) | 10 | 3 | 8 | 58 | 1 | |
186443 | 83009 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 622 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 10 | 3x3 | Permit Number 52378 | 6012068.99141 | 2105489.95153 | 37.7619540583423 | -122.401378022995 | (37.7619540583423, -122.401378022995) | 10 | 3 | 8 | 28856 | 29 | |
188936 | 113546 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2017 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/2015 12:00:00 AM | 1 | Permit Number 775016 | 6011705.09048 | 2105100.13383 | 37.7608633956443 | -122.402609207467 | (37.7608633956443, -122.402609207467) | 10 | 3 | 8 | 28856 | 29 | ||
190011 | 66065 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 615 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/06/1990 12:00:00 AM | 15 | Permit Number 29105 | 6013588.8129 | 2104207.15934 | 37.7585164708659 | -122.396031617282 | (37.7585164708659, -122.396031617282) | 10 | 3 | 8 | 28856 | 29 | |
191642 | 202091 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 82 Carr St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6012965.80047 | 2090628.94188 | 37.7211988543156 | -122.397234148441 | (37.7211988543156, -122.397234148441) | 10 | 3 | 8 | 58 | 1 | |||
8855 | 221923 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 274 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002696.84533 | 2104324.2367 | 37.758225920618 | -122.433709258485 | (37.758225920618, -122.433709258485) | 2 | 4 | 5 | 28862 | 3 | |||
10243 | 221904 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 583 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 785229 | 6001404.83719 | 2101424.58127 | 37.7501907685919 | -122.437969880314 | (37.7501907685919, -122.437969880314) | 2 | 4 | 5 | 28862 | 22 | |
15498 | 221829 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2451 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6008243.92561 | 2104140.04763 | 37.7580333739666 | -122.414511946088 | (37.7580333739666, -122.414511946088) | 2 | 4 | 7 | 28859 | 19 | |||
20666 | 221837 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 109 Bartlett St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 4ft | 6006703.42014 | 2103074.38684 | 37.7550206505078 | -122.419764067776 | (37.7550206505078, -122.419764067776) | 2 | 4 | 7 | 28859 | 19 | |||
22632 | 221918 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 78 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6004080.11539 | 2102633.34286 | 37.7536615185686 | -122.428804766139 | (37.7536615185686, -122.428804766139) | 2 | 4 | 5 | 28862 | 22 | |||
24073 | 221906 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 879 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6002491.82292 | 2103096.81966 | 37.7548440920015 | -122.434330562332 | (37.7548440920015, -122.434330562332) | 2 | 4 | 5 | 28862 | 22 | |||
25181 | 221922 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 142 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002658.74413 | 2105066.93812 | 37.7602630379377 | -122.433894115042 | (37.7602630379377, -122.433894115042) | 2 | 4 | 5 | 28862 | 3 | |||
41894 | 221832 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 573 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007293.28891 | 2103997.59658 | 37.7575887842104 | -122.417789563935 | (37.7575887842104, -122.417789563935) | 2 | 4 | 7 | 28859 | 19 | |||
42770 | 221831 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 569 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007292.05586 | 2104018.90213 | 37.7576472149557 | -122.417795338504 | (37.7576472149557, -122.417795338504) | 2 | 4 | 7 | 28859 | 19 | |||
45404 | 221907 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1217 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6003244.02772 | 2101149.87665 | 37.7495409130801 | -122.431590240821 | (37.7495409130801, -122.431590240821) | 2 | 4 | 5 | 28862 | 22 | |||
49629 | 221833 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 577 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007293.94274 | 2103980.62531 | 37.7575422218038 | -122.417786099775 | (37.7575422218038, -122.417786099775) | 2 | 4 | 7 | 28859 | 19 | |||
61694 | 26511 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2850 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008945.12722 | 2101866.39993 | 37.7518298180943 | -122.411926215341 | (37.7518298180943, -122.411926215341) | 2 | 4 | 7 | 28859 | 19 | |||
67738 | 221916 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 429 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6004184.08219 | 2101438.38346 | 37.7503863234716 | -122.428360063075 | (37.7503863234716, -122.428360063075) | 2 | 4 | 5 | 28862 | 22 | |||
71659 | 221855 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 310 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6000611.21677 | 2101947.64163 | 37.7515818030572 | -122.440751776575 | (37.7515818030572, -122.440751776575) | 2 | 4 | 5 | 28862 | 22 | |||
72559 | 221853 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 430 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6002339.61262 | 2100938.00703 | 37.7489078650277 | -122.434702583968 | (37.7489078650277, -122.434702583968) | 2 | 4 | 5 | 28862 | 22 | |||
72933 | 221807 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3720 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6004936.8002 | 2102544.12819 | 37.7534650059101 | -122.425835807291 | (37.7534650059101, -122.425835807291) | 2 | 4 | 5 | 28862 | 22 | |||
73986 | 221859 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 861 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6000847.19345 | 2101982.10251 | 37.7516898602076 | -122.439938212095 | (37.7516898602076, -122.439938212095) | 2 | 4 | 5 | 28862 | 22 | |||
85505 | 221920 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 963 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 29 | 4x4 | 6003802.10196 | 2102678.82151 | 37.7537706531042 | -122.429769441907 | (37.7537706531042, -122.429769441907) | 2 | 4 | 5 | 28862 | 22 | |||
87625 | 221792 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2818 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6009842.62719 | 2102814.79283 | 37.7544842057885 | -122.408889429605 | (37.7544842057885, -122.408889429605) | 2 | 4 | 7 | 28859 | 19 | |||
87919 | 221912 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 424 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003582.26596 | 2102758.00468 | 37.7539756202844 | -122.43053533425 | (37.7539756202844, -122.43053533425) | 2 | 4 | 5 | 28862 | 22 | |||
88668 | 221892 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3272 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007901.84296 | 2101535.98387 | 37.7508639830901 | -122.415510655785 | (37.7508639830901, -122.415510655785) | 2 | 4 | 7 | 28859 | 19 | |||
91117 | 221789 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3456 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 5ft | 6005341.04131 | 2103147.38287 | 37.7551442389361 | -122.424480760089 | (37.7551442389361, -122.424480760089) | 2 | 4 | 5 | 28859 | 19 | |||
91243 | 221828 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1070 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6008613.25764 | 2102303.67809 | 37.7530118609308 | -122.413104786776 | (37.7530118609308, -122.413104786776) | 2 | 4 | 7 | 28859 | 19 | |||
98506 | 221791 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 867 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/15/1991 12:00:00 AM | 30 | Width 6ft | Permit Number 29826 | 6010196.62735 | 2104192.74111 | 37.7582875664398 | -122.407762355146 | (37.7582875664398, -122.407762355146) | 10 | 4 | 7 | 28859 | 19 | |
99045 | 221908 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1175 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6003228.29657 | 2101452.81084 | 37.7503718075255 | -122.431666264992 | (37.7503718075255, -122.431666264992) | 2 | 4 | 5 | 28862 | 22 | |||
100713 | 221919 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 80 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 5ft | 6004080.1128 | 2102611.51792 | 37.7536015922648 | -122.428803219313 | (37.7536015922648, -122.428803219313) | 2 | 4 | 5 | 28862 | 22 | |||
105651 | 32556 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 233 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/1996 12:00:00 AM | 7 | Permit Number 37043 | 6004755.28395 | 2103949.67696 | 37.7573140539292 | -122.42656360702 | (37.7573140539292, -122.42656360702) | 2 | 4 | 5 | 28862 | 3 | ||
120305 | 221888 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 192 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006128.60788 | 2102045.32396 | 37.7521626832758 | -122.421678849418 | (37.7521626832758, -122.421678849418) | 2 | 4 | 5 | 28859 | 19 | |||
121593 | 221917 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1033 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6003826.31981 | 2102255.52555 | 37.7526097533439 | -122.429655503209 | (37.7526097533439, -122.429655503209) | 2 | 4 | 5 | 28862 | 22 | |||
125012 | 221854 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4418 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6000475.00831 | 2102295.38218 | 37.7525288566262 | -122.441247749083 | (37.7525288566262, -122.441247749083) | 2 | 4 | 5 | 28862 | 22 | |||
130543 | 221890 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 190 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006689.76882 | 2102684.09428 | 37.7539482278401 | -122.419783585763 | (37.7539482278401, -122.419783585763) | 2 | 4 | 7 | 28859 | 19 | |||
131328 | 221913 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3947 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6003448.79955 | 2102413.03039 | 37.7530208406643 | -122.430972273466 | (37.7530208406643, -122.430972273466) | 2 | 4 | 5 | 28862 | 22 | |||
139150 | 221852 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4338 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | Width 4ft | 6001688.98407 | 2100608.31061 | 37.747965638118 | -122.436928854805 | (37.747965638118, -122.436928854805) | 2 | 4 | 5 | 28862 | 22 | |||
139226 | 221921 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 474 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002945.55902 | 2105503.88006 | 37.7614790472472 | -122.432933374683 | (37.7614790472472, -122.432933374683) | 15 | 4 | 5 | 28862 | 3 | |||
143155 | 221914 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 476 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6003319.74249 | 2102160.73191 | 37.7523207750848 | -122.431400568387 | (37.7523207750848, -122.431400568387) | 2 | 4 | 5 | 28862 | 22 | |||
144494 | 221905 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 572 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6002660.0308 | 2103294.31011 | 37.7553958998276 | -122.433762967812 | (37.7553958998276, -122.433762967812) | 2 | 4 | 5 | 28862 | 22 | |||
152125 | 221834 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 581 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6007293.84054 | 2103959.34746 | 37.7574837919732 | -122.417784945026 | (37.7574837919732, -122.417784945026) | 2 | 4 | 7 | 28859 | 19 | |||
155147 | 221860 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 516 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/1998 12:00:00 AM | 15 | Width 3ft | Permit Number 39568 | 6001163.03933 | 2103237.69221 | 37.7551553815387 | -122.438935950032 | (37.7551553815387, -122.438935950032) | 2 | 4 | 5 | 28862 | 22 | |
162952 | 221836 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 585 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007298.30885 | 2103900.40234 | 37.7573221936904 | -122.417765313729 | (37.7573221936904, -122.417765313729) | 2 | 4 | 7 | 28859 | 19 | |||
163060 | 221924 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 651 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003063.54599 | 2104384.44794 | 37.7584120469841 | -122.432445349468 | (37.7584120469841, -122.432445349468) | 2 | 4 | 5 | 28862 | 3 | |||
3367 | 221931 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2136 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003273.64696 | 2107146.54353 | 37.7660080078823 | -122.431915952764 | (37.7660080078823, -122.431915952764) | 15 | 5 | 5 | 28862 | 3 | |||
9645 | 203569 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 181 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5994053.625 | 2104649.1203 | 37.7586237384107 | -122.463624625377 | (37.7586237384107, -122.463624625377) | 1 | 5 | 4 | 56 | 12 | |||
12478 | 246193 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 755 Buena Vista Ave West | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2019 12:00:00 AM | 3 | Width 0ft | 5999885.5759 | 2108037.456 | 37.7682615787189 | -122.443698575802 | (37.7682615787189, -122.443698575802) | 15 | 5 | 11 | 29492 | 9 | ||
31198 | 84402 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1852 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51006 | 6000688.3478 | 2111734.5053 | 37.778458498926 | -122.441187160325 | (37.778458498926, -122.441187160325) | 15 | 5 | 11 | 29490 | 41 | |
31207 | 32474 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 7 Ord St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1996 12:00:00 AM | 15 | Permit Number 36982 | 6000854.39467 | 2106273.37873 | 37.7634730690508 | -122.440221013784 | (37.7634730690508, -122.440221013784) | 15 | 5 | 5 | 28862 | 3 | |
34536 | 221809 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1216 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5998224.25103 | 2106127.66613 | 37.7629228845101 | -122.449307297897 | (37.7629228845101, -122.449307297897) | 15 | 5 | 11 | 29492 | 9 | |||
48932 | 221930 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2134 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6003302.06195 | 2107147.52772 | 37.7660123210304 | -122.431817741407 | (37.7660123210304, -122.431817741407) | 15 | 5 | 5 | 28862 | 3 | |||
59484 | 221933 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4166 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001253.22781 | 2105851.44827 | 37.7623372504834 | -122.438811343586 | (37.7623372504834, -122.438811343586) | 15 | 5 | 5 | 28862 | 3 | |||
59779 | 221868 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 30 Woodland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5997080.14125 | 2106419.81481 | 37.7636595407827 | -122.45328544896 | (37.7636595407827, -122.45328544896) | 15 | 5 | 11 | 29492 | 12 | |||
75216 | 221785 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 69 Scott St | 1 | : | Tree | Private 2 | 19 | Width 3ft | 6002359.55948 | 2108655.68222 | 37.7700998701305 | -122.435185544178 | (37.7700998701305, -122.435185544178) | 15 | 5 | 5 | 29492 | 9 | |||
76975 | 203510 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1366 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5993979.28828 | 2106206.5915 | 37.7628958661671 | -122.46399477014 | (37.7628958661671, -122.46399477014) | 1 | 5 | 11 | 56 | 12 | |||
90849 | 221932 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 265 Henry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001846.56535 | 2107325.41516 | 37.7664181410013 | -122.436864736716 | (37.7664181410013, -122.436864736716) | 15 | 5 | 5 | 28862 | 3 | |||
97000 | 221811 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 115 Clifford Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5999522.48156 | 2106496.55689 | 37.7640099400302 | -122.444843701773 | (37.7640099400302, -122.444843701773) | 15 | 5 | 5 | 29492 | 9 | |||
101822 | 203519 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1531 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5994271.83336 | 2105139.6012 | 37.7599830430151 | -122.462905551751 | (37.7599830430151, -122.462905551751) | 1 | 5 | 4 | 56 | 12 | |||
103782 | 221810 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1214 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5998223.78162 | 2106145.07477 | 37.7629706574012 | -122.449310175733 | (37.7629706574012, -122.449310175733) | 15 | 5 | 11 | 29492 | 9 | |||
107364 | 221928 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3666 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6002501.47722 | 2106518.4971 | 37.7642397410968 | -122.434541817574 | (37.7642397410968, -122.434541817574) | 15 | 5 | 5 | 28862 | 3 | |||
117834 | 221786 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 65 Scott St | 1 | : | Tree | Private 2 | 20 | Width 2ft | 6002363.3837 | 2108638.99661 | 37.7700542727214 | -122.435171122647 | (37.7700542727214, -122.435171122647) | 15 | 5 | 5 | 29492 | 9 | |||
122230 | 69299 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1632 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/14/1994 12:00:00 AM | 25 | Permit Number 33374 | 5999947.983 | 2110939.1774 | 37.7762325313103 | -122.443691201885 | (37.7762325313103, -122.443691201885) | 15 | 5 | 11 | 29492 | 16 | |
130358 | 247338 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 220 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6002315.9732 | 2109334.9211 | 37.7719624169971 | -122.435384903619 | (37.7719624169971, -122.435384903619) | 15 | 5 | 11 | 29492 | 9 | |||
137299 | 203520 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1537 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5994273.74981 | 2105115.42997 | 37.7599167854573 | -122.462897170087 | (37.7599167854573, -122.462897170087) | 1 | 5 | 4 | 56 | 12 | |||
151367 | 64508 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 841 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/21/1988 12:00:00 AM | 36 | Permit Number 25389 | 6000432.9415 | 2111897.9264 | 37.7788926598871 | -122.442082438032 | (37.7788926598871, -122.442082438032) | 15 | 5 | 11 | 29490 | 16 | |
163225 | 120637 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 401 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | 3x3 | 6000628.4194 | 2110406.526 | 37.77480879071 | -122.441299165195 | (37.77480879071, -122.441299165195) | 15 | 5 | 11 | 29492 | 16 | |||
181596 | 140134 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1624 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5999973.0263 | 2110940.5311 | 37.7762376765447 | -122.443604667807 | (37.7762376765447, -122.443604667807) | 15 | 5 | 11 | 29492 | 16 | |||
185444 | 221929 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 70 Beaver St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002463.4686 | 2106805.25277 | 37.7650249445694 | -122.434693785007 | (37.7650249445694, -122.434693785007) | 15 | 5 | 5 | 28862 | 3 | |||
189079 | 253703 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1221 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998953 | 2105574 | 37.7614443133046 | -122.446746977382 | (37.7614443133046, -122.446746977382) | 15 | 5 | 11 | 29492 | 12 | ||||
1872 | 70589 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 339 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 19 | 5989627.95381 | 2113064.98358 | 37.7814753940656 | -122.479546175065 | (37.7814753940656, -122.479546175065) | 11 | 6 | 2 | 55 | 26 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );