trees
723 rows where qLegalStatus_id = 1 and qSpecies_id = 65 sorted by Zip Codes
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 | ||||||||||||
3705 | 244981 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 200 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 07/31/2019 12:00:00 AM | 3 | Width 0ft | Permit Number 781995 | 6005180.5539 | 2109687.8318 | 37.7730936920725 | -122.425501217452 | (37.7730936920725, -122.425501217452) | 7 | 9 | 11 | 28852 | 10 |
8756 | 221784 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 201 Buchanan St | 5 | : | Tree | Private 2 | 5 | Width 3ft | 6004701.97389 | 2109293.67351 | 37.7719843770185 | -122.427128606994 | (37.7719843770185, -122.427128606994) | 7 | 9 | 11 | 28852 | 10 | |||
21320 | 221799 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 430 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6004120.07608 | 2110306.19132 | 37.7747315801401 | -122.42921364562 | (37.7747315801401, -122.42921364562) | 7 | 9 | 11 | 28852 | 10 | |||
29277 | 256167 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 200 Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 6005182.68808 | 2109644.93499 | 37.772976028407 | -122.425490781615 | (37.772976028407, -122.425490781615) | 7 | 9 | 11 | 28852 | 10 | ||||
33220 | 139917 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1000 LAGUNA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6004809.1682 | 2112368.8803 | 37.7804342038606 | -122.426976875009 | (37.7804342038606, -122.426976875009) | 7 | 9 | 11 | 28852 | 41 | |||
36626 | 245863 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 138 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781995 | 6005228.3599 | 2109588.7098 | 37.7728242280559 | -122.42532879528 | (37.7728242280559, -122.42532879528) | 7 | 9 | 11 | 28852 | 10 | |
92411 | 244965 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 250 Lily St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6005276.5809 | 2110102.9361 | 37.7742388930949 | -122.42519859053 | (37.7742388930949, -122.42519859053) | 7 | 9 | 11 | 28852 | 10 | |||
121537 | 256166 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 200 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 6005182.68808 | 2109644.93499 | 37.772976028407 | -122.425490781615 | (37.772976028407, -122.425490781615) | 7 | 9 | 11 | 28852 | 10 | ||||
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 | |
146765 | 139915 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1000 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004816.1035 | 2112332.8828 | 37.7803357557587 | -122.426950318013 | (37.7803357557587, -122.426950318013) | 7 | 9 | 11 | 28852 | 41 | |||
157942 | 221798 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 430 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6004116.67022 | 2110321.94704 | 37.7747746486742 | -122.429226550889 | (37.7747746486742, -122.429226550889) | 7 | 9 | 11 | 28852 | 10 | |||
172746 | 256165 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 200 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 6005182.68808 | 2109644.93499 | 37.772976028407 | -122.425490781615 | (37.772976028407, -122.425490781615) | 7 | 9 | 11 | 28852 | 10 | ||||
185738 | 139916 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1000 LAGUNA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6004814.4523 | 2112350.3862 | 37.7803837224117 | -122.426957277261 | (37.7803837224117, -122.426957277261) | 7 | 9 | 11 | 28852 | 41 | |||
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 | |
19773 | 113547 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2017 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/2015 12:00:00 AM | 1 | Permit Number 775016 | 6011715.20847 | 2105100.54779 | 37.7608650971692 | -122.40257424272 | (37.7608650971692, -122.40257424272) | 10 | 3 | 8 | 28856 | 29 | ||
43175 | 38227 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1099 Mississippi St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1998 12:00:00 AM | 14 | Permit Number 40351 | 6014264.01456 | 2102105.05687 | 37.7527820922208 | -122.393549330162 | (37.7527820922208, -122.393549330162) | 10 | 3 | 8 | 28856 | 29 | ||
93867 | 189215 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1400 20th St | 2 | : | Tree | Private 2 | 14 | Width 3ft | 6013696.29673 | 2104791.67795 | 37.7601274111746 | -122.395700842123 | (37.7601274111746, -122.395700842123) | 10 | 3 | 8 | 28856 | 29 | |||
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 | |||
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 | |
182539 | 38225 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1099 Mississippi St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1998 12:00:00 AM | 13 | Permit Number 40351 | 6014263.22127 | 2102058.4146 | 37.7526539784223 | -122.39354880945 | (37.7526539784223, -122.39354880945) | 10 | 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 | |
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 | |
23153 | 125554 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 22 Dashiell Hammett St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 1ft | 6010380.8435 | 2116036.16558 | 37.7908171708214 | -122.40796043625 | (37.7908171708214, -122.40796043625) | 5 | 1 | 10 | 28857 | 21 | |||
23331 | 125557 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 22 Dashiell Hammett St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 1ft | 6010370.0822 | 2116109.39697 | 37.7910176441083 | -122.40800283658 | (37.7910176441083, -122.40800283658) | 5 | 1 | 10 | 28857 | 21 | |||
26119 | 125558 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 39 Dashiell Hammett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 1ft | 6010359.2219 | 2116035.15877 | 37.7908131958158 | -122.408035175278 | (37.7908131958158, -122.408035175278) | 5 | 1 | 10 | 28857 | 21 | |||
70877 | 125553 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 22 Dashiell Hammett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 1ft | 6010381.65829 | 2116025.18682 | 37.7907870714036 | -122.407956842555 | (37.7907870714036, -122.407956842555) | 5 | 1 | 10 | 28857 | 21 | |||
117746 | 109922 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 20 Dashiell Hammett St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6010385.90065 | 2115990.02467 | 37.7906907621072 | -122.407939683476 | (37.7906907621072, -122.407939683476) | 5 | 1 | 10 | 28857 | 21 | |||
140770 | 125556 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 22 Dashiell Hammett St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 1ft | 6010373.88988 | 2116082.2243 | 37.7909432476765 | -122.407987745034 | (37.7909432476765, -122.407987745034) | 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 | |||
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 | |||
182873 | 125555 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 22 Dashiell Hammett St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 1ft | 6010375.3917 | 2116064.19944 | 37.7908938398292 | -122.40798127711 | (37.7908938398292, -122.40798127711) | 5 | 1 | 10 | 28857 | 21 | |||
46734 | 125549 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1445 Greenwich St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6006015.52243 | 2119649.2025 | 37.8004922923456 | -122.423321211112 | (37.8004922923456, -122.423321211112) | 13 | 9 | 1 | 28858 | 32 | |||
64277 | 37529 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1244 Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 21 | Permit Number 39976 | 6007263.39142 | 2115650.05703 | 37.7895819825607 | -122.418719304647 | (37.7895819825607, -122.418719304647) | 13 | 9 | 10 | 28858 | 21 | |
71978 | 37528 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1244 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 21 | Permit Number 39976 | 6007265.87204 | 2115633.53426 | 37.789536754768 | -122.418709549719 | (37.789536754768, -122.418709549719) | 13 | 9 | 10 | 28858 | 21 | |
81710 | 125550 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1445 Greenwich St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6006031.52695 | 2119650.26621 | 37.8004961162623 | -122.423265904597 | (37.8004961162623, -122.423265904597) | 13 | 9 | 1 | 28858 | 32 | |||
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 | |
150779 | 125547 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1445 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6005968.56582 | 2119641.09275 | 37.8004673748183 | -122.423483123267 | (37.8004673748183, -122.423483123267) | 13 | 9 | 1 | 28858 | 32 | |||
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 | |
160053 | 107230 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1445 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6005960.15833 | 2119639.59713 | 37.8004627936866 | -122.423512110213 | (37.8004627936866, -122.423512110213) | 13 | 9 | 1 | 28858 | 32 | |||
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 | |
169489 | 63578 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1359 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1987 12:00:00 AM | 17 | Permit Number 24201 | 6006442.54317 | 2119356.06995 | 37.799711515327 | -122.421822711261 | (37.799711515327, -122.421822711261) | 13 | 9 | 1 | 28858 | 32 | |
178287 | 125551 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1445 Greenwich St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6006045.33094 | 2119651.17602 | 37.8004993933977 | -122.423218201864 | (37.8004993933977, -122.423218201864) | 13 | 9 | 1 | 28858 | 32 | |||
193967 | 125548 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1445 Greenwich St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6006007.30583 | 2119647.97872 | 37.8004884684307 | -122.423349556855 | (37.8004884684307, -122.423349556855) | 13 | 9 | 1 | 28858 | 32 | |||
578 | 221823 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 199X Ogden Ave | 6 | Sidewalk: Curb side : Pot | Tree | Private 2 | 13 | Width 4ft | 6007760.27568 | 2096148.55485 | 37.7360633428545 | -122.415618808282 | (37.7360633428545, -122.415618808282) | 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 | |||
2752 | 221825 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 499X Tompkins Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008302.15962 | 2096532.14097 | 37.7371470321954 | -122.41377241466 | (37.7371470321954, -122.41377241466) | 2 | 7 | 7 | 28859 | 2 | |||
3673 | 221872 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 619 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007332.3833 | 2097776.98457 | 37.740510589287 | -122.417213566178 | (37.740510589287, -122.417213566178) | 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 | |||
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 | |||
10220 | 221824 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 199X Ogden Ave | 10 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 4ft | 6007730.82531 | 2096150.27006 | 37.7360663969372 | -122.415720751814 | (37.7360663969372, -122.415720751814) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
12895 | 221826 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 499X Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008314.44854 | 2096531.09899 | 37.7371448612571 | -122.413729852457 | (37.7371448612571, -122.413729852457) | 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 | |||
17657 | 221821 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 368 Highland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3x5 | 6007305.19909 | 2096505.34711 | 37.7370174246124 | -122.417217471014 | (37.7370174246124, -122.417217471014) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
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 | |||
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 | |||
32667 | 221878 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 18 Coleridge St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6006985.0649 | 2099647.22119 | 37.7456262946341 | -122.41854704763 | (37.7456262946341, -122.41854704763) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
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 | |||
48444 | 221887 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4107 Ogden Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008432.72367 | 2096048.99248 | 37.7358277429522 | -122.41328683742 | (37.7358277429522, -122.41328683742) | 10 | 7 | 7 | 28859 | 2 | |||
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 | |||
53011 | 221889 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 190 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006689.37303 | 2102664.80303 | 37.7538952362014 | -122.419783585756 | (37.7538952362014, -122.419783585756) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
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 |
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 | |||
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 | |||
64776 | 221819 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 68 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006048.67396 | 2097610.71259 | 37.7399817402673 | -122.421640334157 | (37.7399817402673, -122.421640334157) | 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 | |||
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 | |||
71384 | 221875 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 319 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 4ft | 6006211.14692 | 2098216.1896 | 37.7416534045787 | -122.421121550328 | (37.7416534045787, -122.421121550328) | 2 | 7 | 7 | 28859 | 2 | |||
79681 | 221871 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 619 Eugenia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007314.53376 | 2097779.75076 | 37.7405171804218 | -122.417275479073 | (37.7405171804218, -122.417275479073) | 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 | |||
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 | |||
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 | |||
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 | |||
95633 | 221883 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 34 Prospect Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007121.00835 | 2099271.28888 | 37.7446017212974 | -122.418050328662 | (37.7446017212974, -122.418050328662) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |
99508 | 221835 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 585 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007295.48201 | 2103941.69106 | 37.7574354039359 | -122.41777801665 | (37.7574354039359, -122.41777801665) | 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 | |||
101047 | 221790 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3456 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | Width 5ft | 6005327.10837 | 2103145.45598 | 37.7551381613168 | -122.424528807253 | (37.7551381613168, -122.424528807253) | 2 | 4 | 5 | 28859 | 19 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
126786 | 248223 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 70 Fair Ave | 5 | Side Yard : Yard | Tree | Private 2 | 18 | 6007150.20605 | 2099339.87769 | 37.744791694087 | -122.417954229812 | (37.744791694087, -122.417954229812) | 2 | 7 | 7 | 28859 | 2 | ||||
129007 | 221787 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 124 27th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 8ft | 6005680.59891 | 2100245.58826 | 37.7471957491868 | -122.423100223394 | (37.7471957491868, -122.423100223394) | 2 | 7 | 5 | 28859 | 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 | |||
144794 | 32372 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 90 Leese St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/2018 12:00:00 AM | 3 | Permit Number 782452 | 6005529.07574 | 2096212.96171 | 37.7361145169719 | -122.423337554504 | (37.7361145169719, -122.423337554504) | 2 | 7 | 7 | 28859 | 2 | |
145041 | 221874 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 371 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 29 | Width 3ft | 6006129.02794 | 2097974.50861 | 37.7409851732348 | -122.421388331502 | (37.7409851732348, -122.421388331502) | 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 | |||
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 | |||
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 | |||
153194 | 221788 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 67 Richland Ave | 1 | : | Tree | Private 2 | 20 | Width 4ft | 6005032.77253 | 2096203.58298 | 37.7360607419969 | -122.425052810752 | (37.7360607419969, -122.425052810752) | 2 | 7 | 5 | 28859 | 2 |
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) );