trees
612 rows where SiteOrder = 1 and qSpecies_id = 65 sorted by Police Districts descending
This data as json, CSV (advanced)
qLegalStatus_id ✖
| 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 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 | |||
| 24285 | 115206 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 390 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2016 12:00:00 AM | Permit Number 775334 | 6003427 | 2108679.3 | 37.7702252763858 | -122.431494968546 | (37.7702252763858, -122.431494968546) | 15 | 9 | 11 | 29492 | 10 | |||
| 26083 | 65485 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 436 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1992 12:00:00 AM | Permit Number 30733 | 6004123.88206182 | 2110310.82859854 | 37.7747445284274 | -122.429200810683 | (37.7747445284274, -122.429200810683) | 7 | 9 | 11 | 28852 | 10 | ||
| 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 | |
| 39918 | 41209 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3241 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/1999 12:00:00 AM | 48 | Permit Number 41916 | 6000362.60573 | 2119451.91027 | 37.7996299225355 | -122.442868349911 | (37.7996299225355, -122.442868349911) | 13 | 9 | 1 | 57 | 17 | |
| 55347 | 63855 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 728 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24554 | 6003932.92812606 | 2110451.32130531 | 37.7751194750929 | -122.429871382589 | (37.7751194750929, -122.429871382589) | 7 | 9 | 11 | 29492 | 10 | ||
| 72775 | 125543 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 511 Webster St | 1 | : | Tree | Private 2 | 1 | Width 4ft | 6004027.82216 | 2110630.44547 | 37.7756166793921 | -122.429555900592 | (37.7756166793921, -122.429555900592) | 7 | 9 | 11 | 29492 | 10 | |||
| 77926 | 63770 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 533 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/20/1999 12:00:00 AM | Permit Number 24449 | 6003130.90758036 | 2110082.2752919 | 37.7740607150966 | -122.432619380335 | (37.7740607150966, -122.432619380335) | 15 | 9 | 11 | 29492 | 10 | ||
| 79432 | 41233 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3725 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/2014 12:00:00 AM | 3 | Permit Number 773159 | 6002526.96331 | 2121423.4126 | 37.8051663037497 | -122.435520011048 | (37.8051663037497, -122.435520011048) | 13 | 9 | 1 | 57 | 17 | |
| 83313 | 68880 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3633 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2018 12:00:00 AM | 3 | Permit Number 32851 | 6000180.50707 | 2120770.20455 | 37.8032392229736 | -122.443593228653 | (37.8032392229736, -122.443593228653) | 13 | 9 | 1 | 57 | 17 | |
| 85775 | 30579 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 396 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1995 12:00:00 AM | 2 | Permit Number 34554 | 6003425.76209 | 2108645.89167 | 37.7701334751172 | -122.43149686511 | (37.7701334751172, -122.43149686511) | 15 | 9 | 11 | 29492 | 10 | ||
| 91062 | 84740 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 143 Alhambra St | 1 | Front Yard : Cutout | Tree | Private 2 | 03/27/2007 12:00:00 AM | 13 | 4x6 | Permit Number 49254 | 6001588.49283 | 2120281.76365 | 37.8019782934262 | -122.438685839601 | (37.8019782934262, -122.438685839601) | 13 | 9 | 1 | 57 | 17 | |
| 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 | |
| 141712 | 125540 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 47 Casa Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001554.26648 | 2121557.3314 | 37.8054787165372 | -122.438895742254 | (37.8054787165372, -122.438895742254) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | |||
| 155522 | 247495 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 537 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003124.7415 | 2110167.9221 | 37.7742955303854 | -122.432646828997 | (37.7742955303854, -122.432646828997) | 15 | 9 | 11 | 29492 | 10 | |||
| 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 | |||
| 164117 | 109153 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 124 LILY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x2 | 6005951.6 | 2110200.9 | 37.7745459888588 | -122.422870538078 | (37.7745459888588, -122.422870538078) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | |
| 183625 | 244227 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 332 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003264.0141 | 2109482.4208 | 37.7724212100587 | -122.43211609665 | (37.7724212100587, -122.43211609665) | 15 | 9 | 11 | 29492 | 10 | |||
| 194425 | 221795 | Prune Opt Out 3 | Agonis flexuosa :: Peppermint Willow 65 | 438 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | Permit Number 787981 | 6004107.34969 | 2110372.49722 | 37.7749129194169 | -122.42926239785 | (37.7749129194169, -122.42926239785) | 7 | 9 | 11 | 28852 | 10 | ||
| 194440 | 221797 | Prune Opt Out 3 | Agonis flexuosa :: Peppermint Willow 65 | 436 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 3ft | Permit Number 787981 | 6004113.21358 | 2110335.22701 | 37.7748109165297 | -122.429239455258 | (37.7748109165297, -122.429239455258) | 7 | 9 | 11 | 28852 | 10 | ||
| 138 | 203559 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 145 Lakeview Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5997146.51683 | 2089373.33367 | 37.7168578537955 | -122.45182605794 | (37.7168578537955, -122.45182605794) | 9 | 8 | 6 | 28861 | 24 | |||
| 1157 | 115169 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1463 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 777351 | 5983676.8 | 2105200 | 37.759532920891 | -122.499552539829 | (37.759532920891, -122.499552539829) | 1 | 8 | 3 | 56 | 35 | |||
| 1576 | 260532 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1759 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 07/27/2019 12:00:00 AM | 3 | 5982834.94 | 2103154.54026 | 37.7538672331819 | -122.502312683451 | (37.7538672331819, -122.502312683451) | 1 | 8 | 3 | 56 | 35 | ||
| 1599 | 110941 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2484 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 3x3 | 5984310 | 2098290 | 37.7405970958294 | -122.496852660576 | (37.7405970958294, -122.496852660576) | 1 | 8 | 3 | 29491 | 35 | ||
| 1710 | 51499 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1518 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2005 12:00:00 AM | 1 | Permit Number 47812 | 5983157 | 2104773 | 37.758329986723 | -122.501318651686 | (37.758329986723, -122.501318651686) | 1 | 8 | 3 | 56 | 35 | ||
| 2188 | 260529 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1814 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 5982887.98375 | 2102765.67441 | 37.7528026329038 | -122.502100475367 | (37.7528026329038, -122.502100475367) | 1 | 8 | 3 | 56 | 35 | ||||
| 4566 | 65966 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2644 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | 23 | Permit Number 28988 | 5989285.4992 | 2097339.4197 | 37.7382773344848 | -122.479579961543 | (37.7382773344848, -122.479579961543) | 1 | 8 | 3 | 29491 | 35 | |
| 5407 | 43618 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1918 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/28/2020 12:00:00 AM | 3 | 5x5 | Permit Number 43270 | 5985398.78072313 | 2102143.2200772 | 37.7512407312978 | -122.493371949534 | (37.7512407312978, -122.493371949534) | 1 | 8 | 3 | 29491 | 35 |
| 5467 | 261155 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2119 41st Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 3x3 | 5983519 | 2100707 | 37.7471871347586 | -122.499766192027 | (37.7471871347586, -122.499766192027) | 1 | 8 | 3 | 29491 | 35 | |||
| 5498 | 183675 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1274 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5984003.8455 | 2106504.9034 | 37.7631350020634 | -122.498517860637 | (37.7631350020634, -122.498517860637) | 1 | 8 | 3 | 56 | 35 | |||
| 7243 | 203528 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 24 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 8ft | 5992568.77798 | 2096730.41145 | 37.7367953253409 | -122.46818381133 | (37.7367953253409, -122.46818381133) | 1 | 8 | 4 | 59 | 40 | |||
| 10364 | 64114 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1270 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1987 12:00:00 AM | Permit Number 24882 | 5992718.32165221 | 2106821.08244246 | 37.7645103445899 | -122.468400685881 | (37.7645103445899, -122.468400685881) | 11 | 8 | 11 | 56 | 12 | ||
| 11799 | 261147 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3220x Santiago St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | DPW | 3x3 | 5982825 | 2099474 | 37.7437609086011 | -122.502074725774 | (37.7437609086011, -122.502074725774) | 1 | 8 | 3 | 29491 | 35 | |||
| 12483 | 261152 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2279 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5982935 | 2099631 | 37.7441984490884 | -122.501705991239 | (37.7441984490884, -122.501705991239) | 1 | 8 | 3 | 29491 | 35 | |||
| 12846 | 203946 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2467 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2020 10:17:00 AM | 3 | Width 3ft | 5991366.65316 | 2098632.35377 | 37.7419480728373 | -122.472478660456 | (37.7419480728373, -122.472478660456) | 1 | 8 | 4 | 29491 | 40 | ||
| 12867 | 73402 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1434 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 16 | 5982802.3301 | 2105339.2702 | 37.759863969648 | -122.502587148941 | (37.759863969648, -122.502587148941) | 1 | 8 | 3 | 56 | 35 | |||
| 12905 | 261154 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2246 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5982704 | 2099822 | 37.7447093112365 | -122.502518859637 | (37.7447093112365, -122.502518859637) | 1 | 8 | 3 | 29491 | 35 | |||
| 13131 | 261138 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2600 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5984799 | 2099596 | 37.7442116594147 | -122.4952581999 | (37.7442116594147, -122.4952581999) | 1 | 8 | 3 | 29491 | 35 | ||||
| 15772 | 261153 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2291 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5982938 | 2099557 | 37.7439954416833 | -122.501690144388 | (37.7439954416833, -122.501690144388) | 1 | 8 | 3 | 29491 | 35 | |||
| 16252 | 203564 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 202 Elmwood Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 3ft | 5994856.42725 | 2092686.28381 | 37.7258229929193 | -122.459981583277 | (37.7258229929193, -122.459981583277) | 9 | 8 | 4 | 28861 | 40 | |||
| 17368 | 261151 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2107 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 3x3 | 5982896 | 2100761 | 37.7472988260012 | -122.501924436785 | (37.7472988260012, -122.501924436785) | 1 | 8 | 3 | 29491 | 35 | |||
| 19127 | 86386 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1515 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988049.4132 | 2104971.8792 | 37.759162153442 | -122.484413329834 | (37.759162153442, -122.484413329834) | 1 | 8 | 3 | 56 | 35 | ||
| 21373 | 109405 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 112 ORTEGA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2015 12:00:00 AM | 3x3 | Permit Number 775093 | 5993662.3 | 2102610.6 | 37.7530039316177 | -122.46482995514 | (37.7530039316177, -122.46482995514) | 1 | 8 | 4 | 56 | 12 | ||
| 21803 | 203503 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1347 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5991430.94358 | 2106235.13725 | 37.7628270518373 | -122.472810604751 | (37.7628270518373, -122.472810604751) | 1 | 8 | 11 | 56 | 12 | |||
| 23728 | 225 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2962 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/17/1991 12:00:00 AM | 40 | 3X4 | 5990608.66265 | 2095460.33335 | 37.7331946143326 | -122.474868041333 | (37.7331946143326, -122.474868041333) | 1 | 8 | 4 | 64 | 40 | ||
| 29613 | 218232 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 371 Wawona St | 1 | : | Tree | Private 2 | 33 | Width 2ft | 5991901.5455 | 2097060.86466 | 37.7376641082099 | -122.47051476505 | (37.7376641082099, -122.47051476505) | 1 | 8 | 4 | 59 | 40 | |||
| 29996 | 83821 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1514 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50163 | 5981890.7885 | 2104754.0668 | 37.7582035604252 | -122.505696289301 | (37.7582035604252, -122.505696289301) | 1 | 8 | 3 | 56 | 35 | |
| 31725 | 35065 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1725 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | Permit Number 38620 | 5993082.12771331 | 2103730.13138284 | 37.7560444079518 | -122.46691766691 | (37.7560444079518, -122.46691766691) | 1 | 8 | 4 | 56 | 12 | ||
| 35299 | 203521 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 54 Aloha Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5991886.81261 | 2104359.60659 | 37.757703719373 | -122.471097283818 | (37.757703719373, -122.471097283818) | 1 | 8 | 4 | 56 | 12 | |||
| 40098 | 182924 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2627 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5981795.9682 | 2097192.3992 | 37.7374357552632 | -122.505463727969 | (37.7374357552632, -122.505463727969) | 1 | 8 | 3 | 29491 | 35 | |||
| 47876 | 37084 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1487 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 9 | Permit Number 39685 | 5982148.9004 | 2105004.528 | 37.7589064434103 | -122.504822200215 | (37.7589064434103, -122.504822200215) | 1 | 8 | 3 | 56 | 35 | |
| 48427 | 109287 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2646 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773636 | 5982487.2 | 2097095.3 | 37.7372098007713 | -122.503066669454 | (37.7372098007713, -122.503066669454) | 1 | 8 | 3 | 29491 | 35 |
| 48944 | 203504 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1443 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5991444.34023 | 2105597.09319 | 37.761075927938 | -122.472717747032 | (37.761075927938, -122.472717747032) | 1 | 8 | 4 | 56 | 12 | |||
| 50392 | 203557 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 377 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5995020.43667 | 2088328.90175 | 37.7138680909275 | -122.459099244044 | (37.7138680909275, -122.459099244044) | 9 | 8 | 6 | 28861 | 24 | |||
| 51850 | 83832 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1311 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50170 | 5981489.3468 | 2106129.5123 | 37.7619565050576 | -122.507186662869 | (37.7619565050576, -122.507186662869) | 1 | 8 | 3 | 56 | 35 | |
| 54980 | 203512 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1742 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 5993754.13818 | 2103625.89987 | 37.7557969785536 | -122.464586080687 | (37.7557969785536, -122.464586080687) | 1 | 8 | 4 | 56 | 12 | |||
| 60347 | 62771 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1628 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/1986 12:00:00 AM | Permit Number 23125 | 5993111.44496049 | 2104385.34678202 | 37.7578451513046 | -122.466863908769 | (37.7578451513046, -122.466863908769) | 1 | 8 | 4 | 56 | 12 | ||
| 62410 | 203526 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2424 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5992054.19197 | 2098908.13909 | 37.7427450799172 | -122.470121471754 | (37.7427450799172, -122.470121471754) | 1 | 8 | 4 | 29491 | 40 | |||
| 63762 | 53384 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 259 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/21/2016 12:00:00 AM | Permit Number 772607 | 5994713.25997575 | 2090306.35958478 | 37.7192800571495 | -122.460304141 | (37.7192800571495, -122.460304141) | 9 | 8 | 6 | 28861 | 24 | ||
| 68583 | 38114 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1296 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1998 12:00:00 AM | 7 | Permit Number 40278 | 5987111.1601 | 2106473.2531 | 37.7632298344396 | -122.487768520051 | (37.7632298344396, -122.487768520051) | 1 | 8 | 3 | 56 | 35 | |
| 68631 | 68056 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1655 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1993 12:00:00 AM | Permit Number 31793 | 5993375.65948901 | 2104224.93951181 | 37.7574199602528 | -122.465938496778 | (37.7574199602528, -122.465938496778) | 1 | 8 | 4 | 56 | 12 | ||
| 69330 | 62770 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1622 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/1986 12:00:00 AM | Permit Number 23124 | 5993110.09884511 | 2104424.43713032 | 37.7579524055375 | -122.466871405848 | (37.7579524055375, -122.466871405848) | 1 | 8 | 4 | 56 | 12 | ||
| 73034 | 94147 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1838 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53552 | 5992870.9 | 2102941.4 | 37.7538665624087 | -122.467590799812 | (37.7538665624087, -122.467590799812) | 1 | 8 | 4 | 56 | 12 | ||
| 73567 | 83915 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1218 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50159 | 5982131.5385 | 2106775.0727 | 37.763766832166 | -122.505013452733 | (37.763766832166, -122.505013452733) | 1 | 8 | 3 | 56 | 35 | |
| 73816 | 203517 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 301 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5993021.77901 | 2102511.9902 | 37.7526962240514 | -122.467037812458 | (37.7526962240514, -122.467037812458) | 1 | 8 | 4 | 29491 | 12 | |||
| 74291 | 164206 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2539 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 5991384.96424 | 2098131.18541 | 37.7405730525915 | -122.472378820421 | (37.7405730525915, -122.472378820421) | 1 | 8 | 4 | 29491 | 40 | |||
| 76736 | 94821 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1435 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53901 | 5991436.1 | 2105639 | 37.7611905159112 | -122.472749301819 | (37.7611905159112, -122.472749301819) | 1 | 8 | 4 | 56 | 12 | |
| 77808 | 104992 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2423 47TH AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 01/14/2016 12:00:00 AM | 10 | 2x6 | Permit Number 775156 | 5981729.7 | 2098576.9 | 37.7412333126477 | -122.505795454359 | (37.7412333126477, -122.505795454359) | 1 | 8 | 3 | 29491 | 35 | |
| 78891 | 115281 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2320 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | Permit Number 774954 | 5988790.4 | 2098360 | 37.7410508098993 | -122.481366468975 | (37.7410508098993, -122.481366468975) | 1 | 8 | 3 | 29491 | 35 | |||
| 80252 | 112745 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 179 Caine Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/2014 12:00:00 AM | Permit Number 774163 | 5997059.3 | 2088800.2 | 37.7152791660762 | -122.452086194059 | (37.7152791660762, -122.452086194059) | 9 | 8 | 6 | 28861 | 24 | ||
| 85395 | 64103 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1274 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1987 12:00:00 AM | Permit Number 24869 | 5992719.22945305 | 2106794.6949286 | 37.7644379438855 | -122.468395626163 | (37.7644379438855, -122.468395626163) | 11 | 8 | 11 | 56 | 12 | ||
| 85940 | 65809 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2268 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | Permit Number 28777 | 5991325.30735018 | 2099972.38049218 | 37.7456250483576 | -122.472719302053 | (37.7456250483576, -122.472719302053) | 1 | 8 | 4 | 29491 | 40 | ||
| 86506 | 42268 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1463 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 3 | Permit Number 42509 | 5987415.8588 | 2105330.3292 | 37.7601094468303 | -122.486630755953 | (37.7601094468303, -122.486630755953) | 1 | 8 | 3 | 56 | 35 | |
| 87243 | 109278 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1626 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773630 | 5981021.8 | 2103979.8 | 37.7560264628403 | -122.508644093874 | (37.7560264628403, -122.508644093874) | 1 | 8 | 3 | 56 | 35 |
| 87773 | 203558 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 179 Caine Ave | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5997048.33435 | 2088809.54157 | 37.7153041877202 | -122.45212476956 | (37.7153041877202, -122.45212476956) | 9 | 8 | 6 | 28861 | 24 | |||
| 89653 | 66234 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 211 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29332 | 5995321.94630668 | 2091329.89787669 | 37.7221254446058 | -122.458274198204 | (37.7221254446058, -122.458274198204) | 9 | 8 | 4 | 28861 | 24 | ||
| 90019 | 115171 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2218 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 774487 | 5982698.2 | 2099998.9 | 37.7451946889287 | -122.502552005341 | (37.7451946889287, -122.502552005341) | 1 | 8 | 3 | 29491 | 35 | |||
| 92074 | 109191 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1340 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773400 | 5981564.2 | 2105932 | 37.7614186014043 | -122.506913128145 | (37.7614186014043, -122.506913128145) | 1 | 8 | 3 | 56 | 35 |
| 93053 | 109277 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1787 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772804 | 5981271.8 | 2102925.3 | 37.7531458375643 | -122.507701279468 | (37.7531458375643, -122.507701279468) | 1 | 8 | 3 | 56 | 35 |
| 95533 | 44242 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4007 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2001 12:00:00 AM | 7 | Permit Number 43678 | 5983296.4831 | 2106264.529 | 37.7624334942373 | -122.500946571761 | (37.7624334942373, -122.500946571761) | 1 | 8 | 3 | 56 | 35 | ||
| 95663 | 108501 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1221 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773645 | 5991730.30424 | 2107117.25477 | 37.7652664370978 | -122.471839523232 | (37.7652664370978, -122.471839523232) | 11 | 8 | 11 | 56 | 12 |
| 98589 | 203535 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 68 Rosewood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5994859.58645 | 2095502.43187 | 37.7335556327814 | -122.460174598491 | (37.7335556327814, -122.460174598491) | 9 | 8 | 4 | 59 | 40 | |||
| 100177 | 203509 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 942 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 5991897.43235 | 2105257.276 | 37.7601690974381 | -122.471125954211 | (37.7601690974381, -122.471125954211) | 1 | 8 | 4 | 56 | 12 | |||
| 101049 | 203522 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 62 Aloha Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5991862.2088 | 2104389.33207 | 37.7577839146257 | -122.471184538744 | (37.7577839146257, -122.471184538744) | 1 | 8 | 4 | 56 | 12 | |||
| 103379 | 60473 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 145 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2015 12:00:00 AM | Permit Number 774164 | 5997228.1128738 | 2089314.92516138 | 37.7167021506206 | -122.451539811129 | (37.7167021506206, -122.451539811129) | 9 | 8 | 6 | 28861 | 24 | |||
| 104709 | 66250 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 718 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29350 | 5994696.57852166 | 2091262.84709817 | 37.721905383508 | -122.460431070774 | (37.721905383508, -122.460431070774) | 9 | 8 | 4 | 28861 | 24 | ||
| 111638 | 115173 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2063 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 775267 | 5982265.3 | 2101066.7 | 37.7481011229623 | -122.504127955016 | (37.7481011229623, -122.504127955016) | 1 | 8 | 3 | 29491 | 35 | |||
| 114225 | 185942 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2001 Sunset Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984826.9443 | 2101536.2304 | 37.7495406390981 | -122.495304634302 | (37.7495406390981, -122.495304634302) | 1 | 8 | 3 | 29491 | 35 | |||
| 114233 | 114349 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1240 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | 3x15 | Permit Number 777354 | 5981849.8 | 2106648.5 | 37.7634027199113 | -122.50597849798 | (37.7634027199113, -122.50597849798) | 1 | 8 | 3 | 56 | 35 | ||
| 114804 | 83800 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1206 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50158 | 5982131.5385 | 2106862.8908 | 37.764007955481 | -122.505019961028 | (37.764007955481, -122.505019961028) | 1 | 8 | 3 | 56 | 35 | |
| 115923 | 203562 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1231 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5992350.00783 | 2107041.67016 | 37.7650947391427 | -122.469690631732 | (37.7650947391427, -122.469690631732) | 11 | 8 | 11 | 56 | 12 | |||
| 116085 | 183630 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1451 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5982140.873 | 2105232.9073 | 37.7595330357482 | -122.504866885279 | (37.7595330357482, -122.504866885279) | 1 | 8 | 3 | 56 | 35 | |||
| 116231 | 114809 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1271 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2015 12:00:00 AM | Permit Number 775836 | 5987972.1 | 2106659.4 | 37.763791122625 | -122.484804508138 | (37.763791122625, -122.484804508138) | 1 | 8 | 3 | 56 | 35 | |||
| 119492 | 203554 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 209 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5994942.92929 | 2088379.09284 | 37.7140014477918 | -122.459370769157 | (37.7140014477918, -122.459370769157) | 9 | 8 | 6 | 28861 | 24 | |||
| 122464 | 94832 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1212 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993646.6 | 2107243.8 | 37.7657245899289 | -122.465220756233 | (37.7657245899289, -122.465220756233) | 11 | 8 | 11 | 56 | 12 | ||||
| 122875 | 184596 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1754 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5983496.3685 | 2103208.1852 | 37.7540533675225 | -122.500029311717 | (37.7540533675225, -122.500029311717) | 1 | 8 | 3 | 56 | 35 | |||
| 123393 | 115172 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1255 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 775163 | 5982077.3 | 2106555.6 | 37.7631610318136 | -122.505184777155 | (37.7631610318136, -122.505184777155) | 1 | 8 | 3 | 56 | 35 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );