trees
612 rows where SiteOrder = 1 and qSpecies_id = 65 sorted by Longitude
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 | ||||||||||||
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 | |
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 | |
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 | |
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 | |||
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 | |
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 | |||
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 | |
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 | |||
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 | |||
26137 | 108762 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 500X Lathrop Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 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 | |
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 | |
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 | |
8836 | 262545 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 1919 Donner Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/2020 12:00:00 AM | 3 | 3x3 | 6011672 | 2093386 | 37.7286970547273 | -122.401900181645 | (37.7286970547273, -122.401900181645) | 10 | 3 | 8 | 58 | 1 | ||
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 | ||
13677 | 73831 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 102 Teddy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 19 | 6010808.25129 | 2088026.19044 | 37.713931877121 | -122.404509096323 | (37.713931877121, -122.404509096323) | 9 | 7 | 8 | 309 | 39 | |||
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 | |
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 | |||
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 | |
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 | ||
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 | |
141890 | 39929 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 137 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1999 12:00:00 AM | Permit Number 767825 | 6010490.84450997 | 2087849.27835868 | 37.7134283686634 | -122.405593725995 | (37.7134283686634, -122.405593725995) | 9 | 7 | 8 | 309 | 39 | ||
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 |
83049 | 39933 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 180 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1999 12:00:00 AM | 17 | Permit Number 41204 | 6010299.07366 | 2087996.8284 | 37.7138227857583 | -122.406266946271 | (37.7138227857583, -122.406266946271) | 9 | 7 | 8 | 309 | 39 | |
190685 | 39931 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 175 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1999 12:00:00 AM | 16 | Permit Number 41202 | 6010293.70332 | 2087956.69983 | 37.7137123004597 | -122.406282682604 | (37.7137123004597, -122.406282682604) | 9 | 7 | 8 | 309 | 39 | |
164548 | 175191 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 193 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6010202.71269 | 2087988.02388 | 37.7137932196449 | -122.406599386967 | (37.7137932196449, -122.406599386967) | 9 | 7 | 8 | 309 | 39 | |||
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 | |||
103566 | 248075 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 407 Holladay Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6010292.79484 | 2098665.98806 | 37.743117705012 | -122.407040212138 | (37.743117705012, -122.407040212138) | 10 | 7 | 7 | 28859 | 2 | |||
88122 | 248073 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 440 Holladay Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6010194.15796 | 2098463.12553 | 37.7425551682987 | -122.407366975408 | (37.7425551682987, -122.407366975408) | 10 | 7 | 7 | 28859 | 2 | |||
74836 | 66622 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 867 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/15/1991 12:00:00 AM | Permit Number 29826 | 6010209.78585513 | 2104179.32451342 | 37.7582514640983 | -122.407715901057 | (37.7582514640983, -122.407715901057) | 10 | 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 | |
73407 | 113205 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 50x DASHIELL HAMMETT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 6010410 | 2116139 | 37.7911011617465 | -122.407866810246 | (37.7911011617465, -122.407866810246) | 5 | 1 | 10 | 28857 | 21 | ||||
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 | |||
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 | |||
127600 | 39936 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 262 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1999 12:00:00 AM | 11 | Permit Number 41207 | 6009779.33678 | 2088185.9421 | 37.7143129666441 | -122.408076686195 | (37.7143129666441, -122.408076686195) | 9 | 7 | 8 | 309 | 39 | |
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 | |||
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 | |
183922 | 221794 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 63 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009581.16571 | 2099887.27047 | 37.7464312301328 | -122.409587024721 | (37.7464312301328, -122.409587024721) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |
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 | |
159038 | 221793 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 26 Norwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6009169.37019 | 2099491.8572 | 37.745322428991 | -122.410983048655 | (37.745322428991, -122.410983048655) | 2 | 7 | 7 | 28859 | 2 | |||
129447 | 63292 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 3075 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1987 12:00:00 AM | Permit Number 23858 | 6009183.06965006 | 2100534.27317896 | 37.7481854410784 | -122.411009292537 | (37.7481854410784, -122.411009292537) | 2 | 4 | 7 | 28859 | 2 | ||
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 | |
167156 | 69206 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2864 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | Permit Number 33255 | 6008953.68763074 | 2101781.1943032 | 37.7515963427841 | -122.411890591701 | (37.7515963427841, -122.411890591701) | 2 | 4 | 7 | 28859 | 19 | ||
21022 | 69205 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2860 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | Permit Number 33254 | 6008952.43931379 | 2101803.50283851 | 37.7516575269948 | -122.411896484829 | (37.7516575269948, -122.411896484829) | 2 | 4 | 7 | 28859 | 19 | ||
129894 | 69204 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2850 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | Permit Number 33252 | 6008949.31851966 | 2101859.27420808 | 37.7518104876034 | -122.411911217702 | (37.7518104876034, -122.411911217702) | 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 | |||
6832 | 221870 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 530 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6008584.18129 | 2096552.27767 | 37.7372181568784 | -122.412798757353 | (37.7372181568784, -122.412798757353) | 10 | 7 | 7 | 28859 | 2 | |||
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 | |||
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 | |
64032 | 221815 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3734 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008428.67762 | 2097499.17078 | 37.7398093887782 | -122.413403351802 | (37.7398093887782, -122.413403351802) | 2 | 7 | 7 | 28859 | 2 | |||
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 | ||
19306 | 221827 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 499X Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008328.718 | 2096529.81834 | 37.7371421461853 | -122.413680425731 | (37.7371421461853, -122.413680425731) | 2 | 7 | 7 | 28859 | 2 | |||
47768 | 221885 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 100 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008227.02437 | 2099369.61702 | 37.7449338966774 | -122.414232888254 | (37.7449338966774, -122.414232888254) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
150990 | 64607 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2451 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/18/1988 12:00:00 AM | 20 | Permit Number 25510 | 6008240.6573587 | 2104159.54552526 | 37.7580867271242 | -122.414524628823 | (37.7580867271242, -122.414524628823) | 2 | 4 | 7 | 28859 | 19 | |
168785 | 221814 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 78 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007954.65071 | 2098276.18605 | 37.7419162746098 | -122.415097327373 | (37.7419162746098, -122.415097327373) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
155422 | 221812 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 724 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007603.04648 | 2096007.03362 | 37.7356659171455 | -122.416152394917 | (37.7356659171455, -122.416152394917) | 2 | 7 | 7 | 28859 | 2 | |||
92787 | 114424 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 724 MOULTRIE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 4x2 | 6007601 | 2096031 | 37.735731608506 | -122.416161167234 | (37.735731608506, -122.416161167234) | 2 | 7 | 7 | 28859 | 2 | |||
79694 | 221813 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 810 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007573.94838 | 2095674.48731 | 37.7347511816054 | -122.416229453325 | (37.7347511816054, -122.416229453325) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |
10474 | 221869 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 673 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007432.02888 | 2095820.07599 | 37.7351429550833 | -122.416730429683 | (37.7351429550833, -122.416730429683) | 2 | 7 | 7 | 28859 | 2 | |||
148843 | 221818 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 36 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007500.06769 | 2099881.60431 | 37.7462988382332 | -122.416782843047 | (37.7462988382332, -122.416782843047) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
35130 | 63135 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 25 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/11/1986 12:00:00 AM | Permit Number 23650 | 6007455.65629161 | 2099393.17627053 | 37.7449552262088 | -122.416901813576 | (37.7449552262088, -122.416901813576) | 2 | 7 | 7 | 28859 | 2 | ||
23336 | 63134 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 27 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/11/1986 12:00:00 AM | Permit Number 23649 | 6007447.90223159 | 2099378.78534919 | 37.7449152757931 | -122.416927606356 | (37.7449152757931, -122.416927606356) | 2 | 7 | 7 | 28859 | 2 | ||
180514 | 221817 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 25 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6007435.65723 | 2099387.93304 | 37.7449397045122 | -122.416970595441 | (37.7449397045122, -122.416970595441) | 2 | 7 | 7 | 28859 | 2 | |||
152526 | 221816 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 27 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6007421.73456 | 2099361.81155 | 37.7448671975643 | -122.417016887145 | (37.7448671975643, -122.417016887145) | 2 | 7 | 7 | 28859 | 2 | |||
60245 | 108910 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 129 Ellert St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773054 | 6007361.2 | 2097016.9 | 37.7384251864379 | -122.417060086005 | (37.7384251864379, -122.417060086005) | 2 | 7 | 7 | 28859 | 2 |
32001 | 221822 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 129 Ellert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6007356.42456 | 2097004.67982 | 37.7383913638823 | -122.417075731561 | (37.7383913638823, -122.417075731561) | 2 | 7 | 7 | 28859 | 2 | |||
56987 | 63133 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 28 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/11/1986 12:00:00 AM | Permit Number 23648 | 6007400.02445462 | 2099399.55358264 | 37.7449696074565 | -122.417094630618 | (37.7449696074565, -122.417094630618) | 2 | 7 | 7 | 28859 | 2 | ||
104584 | 221882 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 36 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007355.35831 | 2099292.63872 | 37.7446735303753 | -122.417241503608 | (37.7446735303753, -122.417241503608) | 2 | 7 | 7 | 28859 | 2 | |||
1806 | 221820 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 368 Highland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 2ft | 6007294.28583 | 2096507.5919 | 37.7370229743371 | -122.417255362169 | (37.7370229743371, -122.417255362169) | 2 | 7 | 7 | 28859 | 2 | |||
76448 | 108926 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 36 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772355 | 6007347.4 | 2099299.8 | 37.7446927459132 | -122.417269529335 | (37.7446927459132, -122.417269529335) | 2 | 7 | 7 | 28859 | 2 |
58635 | 63004 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 368 Highland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1986 12:00:00 AM | 20 | 4x6 | Permit Number 23414 | 6007279.07639479 | 2096499.56656681 | 37.7370000828457 | -122.417307379598 | (37.7370000828457, -122.417307379598) | 2 | 7 | 7 | 28859 | 2 |
754 | 34739 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 581 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 3x3 | Permit Number 38389 | 6007302.61875581 | 2103939.58827334 | 37.7574300317864 | -122.417753185833 | (37.7574300317864, -122.417753185833) | 2 | 4 | 7 | 28859 | 19 | |
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 | |||
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 | |||
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 | |||
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 | |||
100205 | 221884 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 230 Esmeralda Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 6007166.67292 | 2098807.97162 | 37.7433321258706 | -122.417859593245 | (37.7433321258706, -122.417859593245) | 2 | 7 | 7 | 28859 | 2 | |||
132571 | 63129 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 34 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/11/1986 12:00:00 AM | Permit Number 23643 | 6007144.61352889 | 2099320.79872129 | 37.7447389927671 | -122.417972215495 | (37.7447389927671, -122.417972215495) | 2 | 7 | 7 | 28859 | 2 | ||
185506 | 63233 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 200x ESMERALDA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/13/1987 12:00:00 AM | Permit Number 23781 | 6007093 | 2098828 | 37.7433829729046 | -122.41811575542 | (37.7433829729046, -122.41811575542) | 2 | 7 | 7 | 28859 | 2 | ||
142834 | 33539 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 253 BOCANA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2015 12:00:00 AM | 4x4 | Permit Number 775951 | 6007035 | 2097463 | 37.7396317225537 | -122.418219548801 | (37.7396317225537, -122.418219548801) | 2 | 7 | 7 | 28859 | 2 | ||
4442 | 221873 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 253 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007019.01293 | 2097474.10434 | 37.7396613127072 | -122.418275612445 | (37.7396613127072, -122.418275612445) | 2 | 7 | 7 | 28859 | 2 | |||
157705 | 221881 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6007048.87361 | 2099774.96937 | 37.7459806544792 | -122.418335462324 | (37.7459806544792, -122.418335462324) | 2 | 7 | 7 | 28859 | 2 | |||
109510 | 221880 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 47 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6007035.70082 | 2099744.20537 | 37.7458954419332 | -122.418378831241 | (37.7458954419332, -122.418378831241) | 2 | 7 | 7 | 28859 | 2 | |||
70357 | 221879 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 43 Powers Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6006986.90322 | 2099718.335 | 37.745821660643 | -122.418545732803 | (37.745821660643, -122.418545732803) | 2 | 7 | 7 | 28859 | 2 | |||
65100 | 221877 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 22 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006964.5888 | 2099612.44373 | 37.7455296507747 | -122.418615385312 | (37.7455296507747, -122.418615385312) | 2 | 7 | 7 | 28859 | 2 | |||
53970 | 221876 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 24 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 6006954.78098 | 2099597.50642 | 37.7454880840995 | -122.418648240225 | (37.7454880840995, -122.418648240225) | 2 | 7 | 7 | 28859 | 2 | |||
107607 | 37527 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1244 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 19 | Permit Number 39976 | 6007268.1881 | 2115618.13797 | 37.7894946107457 | -122.418700444082 | (37.7894946107457, -122.418700444082) | 13 | 9 | 10 | 28858 | 21 | |
33290 | 63461 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 45 Powers Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1987 12:00:00 AM | Permit Number 24052 | 6006867.21716204 | 2099801.68707108 | 37.7460437878528 | -122.418965501899 | (37.7460437878528, -122.418965501899) | 2 | 7 | 7 | 28859 | 2 | ||
154695 | 4846 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 210 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/27/1992 12:00:00 AM | 15 | 3X3 | 6006713.9746 | 2097429.76412 | 37.7395223890352 | -122.419327161814 | (37.7395223890352, -122.419327161814) | 2 | 7 | 7 | 28859 | 2 | ||
121688 | 4845 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 202 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/27/1992 12:00:00 AM | 24 | 3X3 | 6006694.31051 | 2097440.2331 | 37.7395500270059 | -122.41939589432 | (37.7395500270059, -122.41939589432) | 2 | 7 | 7 | 28859 | 2 | ||
130795 | 81299 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 109 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 12 | 3x3 | Permit Number 50541 | 6006708.25661782 | 2103139.88479614 | 37.7552007652727 | -122.419751988993 | (37.7552007652727, -122.419751988993) | 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 |
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) );