trees
3,267 rows where qSpecies_id = 67 sorted by XCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
129854 | 38361 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1626 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/1998 12:00:00 AM | Permit Number 40425 | 5980991.46797396 | 2103984.91123867 | 37.756038708992 | -122.5087493697 | (37.756038708992, -122.5087493697) | 1 | 8 | 3 | 56 | 35 | ||
4178 | 31221 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 766 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/1995 12:00:00 AM | Permit Number 34908 | 5981084.03491617 | 2110503.52214182 | 37.7739423822297 | -122.508913237037 | (37.7739423822297, -122.508913237037) | 11 | 6 | 2 | 55 | 26 | |||
107773 | 31933 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1282 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776912 | 5981529.52333604 | 2106358.00177396 | 37.76258623775 | -122.507064660839 | (37.76258623775, -122.507064660839) | 1 | 8 | 3 | 56 | 35 | |
127512 | 37093 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1426 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 3 | Permit Number 39693 | 5981559.2885 | 2105362.1483 | 37.7598536626334 | -122.506887844351 | (37.7598536626334, -122.506887844351) | 1 | 8 | 3 | 56 | 35 | |
65850 | 69027 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3830 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1994 12:00:00 AM | 0 | Permit Number 33031 | 5981593.45716069 | 2100816.99566217 | 37.7473759716808 | -122.506432607968 | (37.7473759716808, -122.506432607968) | 1 | 8 | 3 | 29491 | 35 | |
170081 | 105128 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1835 47TH AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774579 | 5981612.2 | 2102591.6 | 37.7522496399023 | -122.506499383522 | (37.7522496399023, -122.506499383522) | 1 | 8 | 3 | 56 | 35 | |
28203 | 118808 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 894 46th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 5981738.11732 | 2109674.1043 | 37.771703578835 | -122.50658917067 | (37.771703578835, -122.50658917067) | 11 | 6 | 2 | 55 | 26 | |||
104696 | 118809 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 894 46th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 5981738.19338 | 2109667.15136 | 37.7716844925674 | -122.50658839183 | (37.7716844925674, -122.50658839183) | 11 | 6 | 2 | 55 | 26 | |||
76758 | 47842 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4430 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/14/2002 12:00:00 AM | 2 | Permit Number 45603 | 5981809.26084 | 2110330.3031 | 37.7735094979411 | -122.506391755128 | (37.7735094979411, -122.506391755128) | 11 | 6 | 2 | 55 | 26 | |
84035 | 118432 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5426 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5981813.70914 | 2111694.92203 | 37.7772566032383 | -122.506477588254 | (37.7772566032383, -122.506477588254) | 11 | 6 | 2 | 55 | 26 | |||
64279 | 118804 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 6940 Fulton St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 5981816.18929 | 2109660.54581 | 37.7716709477941 | -122.506318113931 | (37.7716709477941, -122.506318113931) | 11 | 6 | 2 | 55 | 26 | |||
162305 | 118557 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 8100 Geary Blvd | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5981820.40952 | 2112394.33685 | 37.7791773847362 | -122.506506292125 | (37.7791773847362, -122.506506292125) | 11 | 6 | 2 | 55 | 26 | |||
23969 | 118556 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 8100 Geary Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5981834.60643 | 2112394.66752 | 37.7791791285364 | -122.506457204565 | (37.7791791285364, -122.506457204565) | 11 | 6 | 2 | 55 | 26 | |||
25635 | 47841 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4424 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/14/2002 12:00:00 AM | 3 | Permit Number 45602 | 5981838.80851 | 2110330.17409 | 37.7735108832884 | -122.506289537608 | (37.7735108832884, -122.506289537608) | 11 | 6 | 2 | 55 | 26 | |
135277 | 184153 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1583 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5981862.9826 | 2104319.103 | 37.7570076369492 | -122.505760207392 | (37.7570076369492, -122.505760207392) | 1 | 8 | 3 | 56 | 35 | |||
114183 | 119074 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 727 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 1ft | 5981953.2643 | 2110779.72754 | 37.7747519632118 | -122.505926961402 | (37.7747519632118, -122.505926961402) | 11 | 6 | 2 | 55 | 26 | |||
104318 | 34699 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 783 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 5 | Permit Number 38358 | 5981962.67601 | 2110441.20269 | 37.7738230269301 | -122.505869302151 | (37.7738230269301, -122.505869302151) | 11 | 6 | 2 | 55 | 26 | |
122615 | 31651 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3530 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/02/2016 12:00:00 AM | 3 | Permit Number 778640 | 5981977.0239 | 2096750.5895 | 37.736233320022 | -122.504805016487 | (37.736233320022, -122.504805016487) | 1 | 8 | 3 | 29491 | 35 | |
147461 | 47827 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 879 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/13/2002 12:00:00 AM | 3 | Permit Number 45589 | 5981988.70883 | 2109787.39481 | 37.7720293934096 | -122.505730773826 | (37.7720293934096, -122.505730773826) | 11 | 6 | 2 | 55 | 26 | |
2685 | 264708 | Private 9 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4345 Clement St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/17/2020 12:00:00 AM | 3 | 5982064.28374 | 2113052.50483 | 37.7809988756405 | -122.505711450059 | (37.7809988756405, -122.505711450059) | 11 | 6 | 2 | 55 | 26 | |||
19591 | 264707 | Private 9 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4345 Clement St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/17/2020 12:00:00 AM | 3 | 5982064.28374 | 2113052.50483 | 37.7809988756405 | -122.505711450059 | (37.7809988756405, -122.505711450059) | 11 | 6 | 2 | 55 | 26 | |||
34351 | 183203 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2495 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5982070.7667 | 2098188.3746 | 37.7401865975237 | -122.504587407891 | (37.7401865975237, -122.504587407891) | 1 | 8 | 3 | 29491 | 35 | |||
111280 | 183205 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2499 46th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5982072.7972 | 2098155.8861 | 37.7400975124895 | -122.504577980898 | (37.7400975124895, -122.504577980898) | 1 | 8 | 3 | 29491 | 35 | |||
54046 | 183288 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1285 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5982099.3385 | 2106416.2727 | 37.762779775667 | -122.505098228653 | (37.762779775667, -122.505098228653) | 1 | 8 | 3 | 56 | 35 | |||
189991 | 52037 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2530 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2005 12:00:00 AM | 0 | Permit Number 48249 | 5982130.19675143 | 2097871.80760373 | 37.7393208872786 | -122.50435848033 | (37.7393208872786, -122.50435848033) | 1 | 8 | 3 | 29491 | 35 | ||
191388 | 38376 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3809 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/1998 12:00:00 AM | Permit Number 40435 | 5982211.97867906 | 2102828.4142054 | 37.7529351608085 | -122.504442832568 | (37.7529351608085, -122.504442832568) | 1 | 8 | 3 | 56 | 35 | ||
17307 | 74930 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4045 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5982222.2441 | 2104869.0336 | 37.7585387287405 | -122.50455850909 | (37.7585387287405, -122.50455850909) | 1 | 8 | 3 | 56 | 35 | |||
3122 | 74788 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4045 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5982233.8553 | 2104870.2558 | 37.758542767533 | -122.504518443568 | (37.758542767533, -122.504518443568) | 1 | 8 | 3 | 56 | 35 | |||
3452 | 74635 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4045 Kirkham St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5982248.2166 | 2104869.6447 | 37.7585419343481 | -122.504468731299 | (37.7585419343481, -122.504468731299) | 1 | 8 | 3 | 56 | 35 | |||
21089 | 184538 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1939 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5982255.8834 | 2101901.5386 | 37.7503928027278 | -122.504222349881 | (37.7503928027278, -122.504222349881) | 1 | 8 | 3 | 29491 | 35 | |||
1234 | 74480 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4045 Kirkham St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5982259.5223 | 2104870.2558 | 37.7585442772343 | -122.504429677037 | (37.7585442772343, -122.504429677037) | 1 | 8 | 3 | 56 | 35 | |||
69457 | 38344 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1858 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1998 12:00:00 AM | 2 | Permit Number 40411 | 5982279.7422 | 2102452.6585 | 37.7519074266581 | -122.504180665511 | (37.7519074266581, -122.504180665511) | 1 | 8 | 3 | 56 | 35 | |
56078 | 38346 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1862 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1998 12:00:00 AM | 3 | Permit Number 40413 | 5982280.7574 | 2102429.3074 | 37.7518433707941 | -122.504175425295 | (37.7518433707941, -122.504175425295) | 1 | 8 | 3 | 56 | 35 | |
86371 | 39816 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2135 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | 3 | Permit Number 41147 | 5982300.3859 | 2100562.0651 | 37.746717599317 | -122.503969259712 | (37.746717599317, -122.503969259712) | 1 | 8 | 3 | 29491 | 35 | |
82681 | 184456 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2150 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5982348.1034 | 2100464.5996 | 37.7464527920087 | -122.503797042944 | (37.7464527920087, -122.503797042944) | 1 | 8 | 3 | 29491 | 35 | |||
105935 | 109717 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3832 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773646 | 5982350.4 | 2103585.5 | 37.7550220459753 | -122.504020225851 | (37.7550220459753, -122.504020225851) | 1 | 8 | 3 | 56 | 35 |
171540 | 69012 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2170 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1994 12:00:00 AM | 3 | Permit Number 33015 | 5982352.1644 | 2100332.9535 | 37.7460915671649 | -122.503773252601 | (37.7460915671649, -122.503773252601) | 1 | 8 | 3 | 29491 | 35 | |
181520 | 184496 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1870 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5982593.1208 | 2102386.6662 | 37.7517446551582 | -122.503092090825 | (37.7517446551582, -122.503092090825) | 1 | 8 | 3 | 56 | 35 | |||
182161 | 184455 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2167 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5982617.4871 | 2100369.1647 | 37.7462065900459 | -122.502858496394 | (37.7462065900459, -122.502858496394) | 1 | 8 | 3 | 29491 | 35 | |||
181868 | 185238 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2519 44th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5982696.2593 | 2097960.1988 | 37.7395968623425 | -122.502407859991 | (37.7395968623425, -122.502407859991) | 1 | 8 | 3 | 29491 | 35 | |||
24325 | 69162 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1201 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1994 12:00:00 AM | 6 | Permit Number 33199 | 5982705.2838 | 2106882.9636 | 37.7640968091015 | -122.503037064776 | (37.7640968091015, -122.503037064776) | 1 | 8 | 3 | 56 | 35 | |
9250 | 70168 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5129 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5982718.93125 | 2111668.17193 | 37.7772364107813 | -122.503344205234 | (37.7772364107813, -122.503344205234) | 11 | 6 | 2 | 55 | 26 | |||
6350 | 117651 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5101 Anza St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 5982808.62425 | 2111663.85148 | 37.77722982032 | -122.503033613638 | (37.77722982032, -122.503033613638) | 11 | 6 | 2 | 55 | 26 | |||
141582 | 117652 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5101 Anza St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 5982828.88915 | 2111662.81749 | 37.7772281723606 | -122.502963435462 | (37.7772281723606, -122.502963435462) | 11 | 6 | 2 | 55 | 26 | |||
1528 | 70442 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 200 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/2017 12:00:00 AM | 3 | Permit Number 780711 | 5983049.5384 | 2098315.9426 | 37.7405943893559 | -122.501212699104 | (37.7405943893559, -122.501212699104) | 1 | 8 | 3 | 29491 | 35 | |
174500 | 183624 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1427 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5983067.6354 | 2105411.9181 | 37.7600790269008 | -122.501674977233 | (37.7600790269008, -122.501674977233) | 1 | 8 | 3 | 56 | 35 | |||
121183 | 117713 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 499 41st Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 1ft | 5983130.2288 | 2112588.44811 | 37.779787390189 | -122.501989530515 | (37.779787390189, -122.501989530515) | 11 | 6 | 2 | 55 | 26 | |||
136284 | 117714 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 499 41st Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 1ft | 5983131.92872 | 2112572.07967 | 37.7797425471049 | -122.501982438335 | (37.7797425471049, -122.501982438335) | 11 | 6 | 2 | 55 | 26 | |||
135528 | 117876 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 870 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5983272.47821 | 2109867.2911 | 37.7723242388321 | -122.50129609849 | (37.7723242388321, -122.50129609849) | 11 | 6 | 2 | 55 | 26 | |||
49264 | 117875 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 870 41st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5983273.23794 | 2109885.94663 | 37.7723755061498 | -122.50129485073 | (37.7723755061498, -122.50129485073) | 11 | 6 | 2 | 55 | 26 | |||
47761 | 183269 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1249 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5983336.1919 | 2106636.3882 | 37.763456845523 | -122.500836736792 | (37.763456845523, -122.500836736792) | 1 | 8 | 3 | 56 | 35 | |||
40436 | 69156 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1255 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1994 12:00:00 AM | 7 | Permit Number 33192 | 5983336.7375 | 2106596.5609 | 37.7633475230998 | -122.5008319043 | (37.7633475230998, -122.5008319043) | 1 | 8 | 3 | 56 | 35 | |
33832 | 62064 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1259 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1985 12:00:00 AM | 8 | Permit Number 22145 | 5983337.283 | 2106566.0084 | 37.7632636666362 | -122.500827758091 | (37.7632636666362, -122.500827758091) | 1 | 8 | 3 | 56 | 35 | ||
73358 | 117735 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 486 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5983485.16347 | 2112571.27712 | 37.7797610881372 | -122.500760405263 | (37.7797610881372, -122.500760405263) | 11 | 6 | 2 | 55 | 26 | |||
127861 | 61360 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 771 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/15/1984 12:00:00 AM | 6 | Permit Number 21269 | 5983513.83177 | 2110574.47725 | 37.774280138594 | -122.500513546398 | (37.774280138594, -122.500513546398) | 11 | 6 | 2 | 55 | 26 | ||
71762 | 117907 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 771 40th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5983515.60054 | 2110554.43501 | 37.7742252122257 | -122.500505945779 | (37.7742252122257, -122.500505945779) | 11 | 6 | 2 | 55 | 26 | |||
38082 | 115170 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2483 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 775167 | 5983603.3 | 2098266.1 | 37.7404900382804 | -122.499294352828 | (37.7404900382804, -122.499294352828) | 1 | 8 | 3 | 29491 | 35 | |||
22981 | 109263 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3338X Ortega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | 5983663.54917 | 2102222.75157 | 37.7513574508855 | -122.499378353213 | (37.7513574508855, -122.499378353213) | 1 | 8 | 3 | 29491 | 35 | |
67897 | 109264 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3338X Ortega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | 5983663.54917 | 2102222.75157 | 37.7513574508855 | -122.499378353213 | (37.7513574508855, -122.499378353213) | 1 | 8 | 3 | 29491 | 35 | |
183164 | 117791 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3835 Balboa St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 5983712.00909 | 2111006.51054 | 37.7754780086977 | -122.499859966334 | (37.7754780086977, -122.499859966334) | 11 | 6 | 2 | 55 | 26 | |||
136055 | 117745 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 433 39th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 5983738.48385 | 2112900.68218 | 37.7806804074829 | -122.499908428658 | (37.7806804074829, -122.499908428658) | 11 | 6 | 2 | 55 | 26 | |||
174080 | 117746 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 433 39th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 5983739.04542 | 2112883.08497 | 37.7806321236335 | -122.49990518483 | (37.7806321236335, -122.49990518483) | 11 | 6 | 2 | 55 | 26 | |||
169323 | 52565 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1490 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2016 12:00:00 AM | 3 | Permit Number 776032 | 5983749.00829455 | 2105020.42381918 | 37.7590440916772 | -122.499289541864 | (37.7590440916772, -122.499289541864) | 1 | 8 | 3 | 56 | 35 | |
133138 | 104792 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 700 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Permit Number 771234 | 5983853.47126 | 2110973.39069 | 37.775395371596 | -122.499368174663 | (37.775395371596, -122.499368174663) | 11 | 6 | 2 | 55 | 26 | |||
130941 | 104818 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 700 39th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 771234 | 5983853.47864 | 2110990.25289 | 37.7754416707598 | -122.499369395484 | (37.7754416707598, -122.499369395484) | 11 | 6 | 2 | 55 | 26 | ||
128751 | 104793 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 700 39th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5983853.59876 | 2111004.1266 | 37.7754797710072 | -122.499370005427 | (37.7754797710072, -122.499370005427) | 11 | 6 | 2 | 55 | 26 | ||||
123354 | 183681 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1323 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5983973.0216 | 2106131.3597 | 37.7621075487897 | -122.498596873655 | (37.7621075487897, -122.498596873655) | 1 | 8 | 3 | 56 | 35 | |||
52426 | 183682 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1323 39th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5983973.4902 | 2106147.0568 | 37.7621506760822 | -122.498596412549 | (37.7621506760822, -122.498596412549) | 1 | 8 | 3 | 56 | 35 | |||
129594 | 69142 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2510 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/1994 12:00:00 AM | 4 | Permit Number 33175 | 5983984.3277 | 2098057.6781 | 37.7399401146718 | -122.497961540873 | (37.7399401146718, -122.497961540873) | 1 | 8 | 3 | 29491 | 35 | |
177990 | 254744 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1301X 39th Ave | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 1x4 | 5984000 | 2105977 | 37.7616853026946 | -122.498492164913 | (37.7616853026946, -122.498492164913) | 1 | 8 | 3 | 56 | 35 | ||||
12081 | 69044 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1426 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1994 12:00:00 AM | 2 | Permit Number 33051 | 5984041.3218 | 2105444.0326 | 37.7602243472537 | -122.498309886187 | (37.7602243472537, -122.498309886187) | 1 | 8 | 3 | 56 | 35 | |
152564 | 109192 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3826 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773182 | 5984114.7 | 2098211 | 37.7403687376469 | -122.497522091318 | (37.7403687376469, -122.497522091318) | 1 | 8 | 3 | 29491 | 35 |
28404 | 184586 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1750 39th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984116.0189 | 2103254.2105 | 37.7542160870284 | -122.497889842793 | (37.7542160870284, -122.497889842793) | 1 | 8 | 3 | 56 | 35 | |||
104111 | 184902 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1798 39th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5984123.4641 | 2103002.4247 | 37.7535251895885 | -122.497845504869 | (37.7535251895885, -122.497845504869) | 1 | 8 | 3 | 56 | 35 | |||
48772 | 184903 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1798 39th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5984124.141 | 2103020.0227 | 37.7535735484973 | -122.497844463399 | (37.7535735484973, -122.497844463399) | 1 | 8 | 3 | 56 | 35 | |||
106339 | 184901 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1798 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5984126.5099 | 2102985.5036 | 37.7534789074993 | -122.497833722621 | (37.7534789074993, -122.497833722621) | 1 | 8 | 3 | 56 | 35 | |||
175155 | 24728 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 7350X Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 5 | 5984131.94818 | 2112492.82889 | 37.7795836433147 | -122.498517132313 | (37.7795836433147, -122.498517132313) | 11 | 6 | 2 | 55 | 26 | |||
82190 | 184899 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3136 Noriega St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5984158.9984 | 2102960.4604 | 37.7534120503685 | -122.497719523191 | (37.7534120503685, -122.497719523191) | 1 | 8 | 3 | 56 | 35 | |||
113492 | 24726 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 7350X Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 5 | 5984167.63724 | 2112494.16793 | 37.7795894128065 | -122.498393769373 | (37.7795894128065, -122.498393769373) | 11 | 6 | 2 | 55 | 26 | |||
36857 | 101374 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3136 Noriega St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 5984176.5964 | 2102959.4451 | 37.7534102942266 | -122.497658591569 | (37.7534102942266, -122.497658591569) | 1 | 8 | 3 | 56 | 35 | |||
164403 | 43046 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2223 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2000 12:00:00 AM | 0 | Permit Number 42900 | 5984177.60639634 | 2100035.08697595 | 37.7453808710845 | -122.497439220864 | (37.7453808710845, -122.497439220864) | 1 | 8 | 3 | 29491 | 35 | |
23467 | 117983 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 82 Shore View Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 5ft | 5984187.50987 | 2112858.34 | 37.7805904888414 | -122.498351927647 | (37.7805904888414, -122.498351927647) | 11 | 6 | 2 | 55 | 26 | |||
44502 | 101373 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3136 Noriega St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 5984197.9169 | 2102961.1373 | 37.7534161902989 | -122.497584986841 | (37.7534161902989, -122.497584986841) | 1 | 8 | 3 | 56 | 35 | |||
160740 | 117982 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 82 Shore View Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 5ft | 5984203.12595 | 2112857.27884 | 37.7805884909022 | -122.498297826626 | (37.7805884909022, -122.498297826626) | 11 | 6 | 2 | 55 | 26 | |||
124137 | 24727 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 7360X Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 5 | 5984208.26148 | 2112495.49313 | 37.7795954335493 | -122.498253332745 | (37.7795954335493, -122.498253332745) | 11 | 6 | 2 | 55 | 26 | |||
36905 | 101372 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3136 Noriega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 5984213.4843 | 2102962.4909 | 37.7534208194067 | -122.497531252237 | (37.7534208194067, -122.497531252237) | 1 | 8 | 3 | 56 | 35 | |||
42177 | 101371 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3136 Noriega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 5984231.0823 | 2102962.1525 | 37.7534209217472 | -122.497470370582 | (37.7534209217472, -122.497470370582) | 1 | 8 | 3 | 56 | 35 | |||
120148 | 101370 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3136 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 5984248.6802 | 2102962.4909 | 37.7534228823557 | -122.497409539234 | (37.7534228823557, -122.497409539234) | 1 | 8 | 3 | 56 | 35 | |||
169539 | 90664 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3600X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984368.50089 | 2110421.40599 | 37.773909982922 | -122.497545831628 | (37.773909982922, -122.497545831628) | 11 | 6 | 2 | 55 | 26 | ||
21896 | 184581 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1747 38th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5984379.9879 | 2103282.638 | 37.7543096128776 | -122.496979084355 | (37.7543096128776, -122.496979084355) | 1 | 8 | 3 | 56 | 35 | |||
168218 | 184310 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1566 38th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984383.5526 | 2104514.4673 | 37.7576920825092 | -122.497057675065 | (37.7576920825092, -122.497057675065) | 1 | 8 | 3 | 56 | 35 | |||
5466 | 90663 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3600X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984396.70061 | 2110421.43862 | 37.7739117254104 | -122.497448288038 | (37.7739117254104, -122.497448288038) | 11 | 6 | 2 | 55 | 26 | ||
116427 | 118213 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 786 37th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5984488.76737 | 2110557.58441 | 37.7742909385344 | -122.497139870377 | (37.7742909385344, -122.497139870377) | 11 | 6 | 2 | 55 | 26 | |||
117486 | 183671 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1251 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5984575.2383 | 2106662.4217 | 37.7636009951873 | -122.496553259461 | (37.7636009951873, -122.496553259461) | 1 | 8 | 3 | 56 | 35 | |||
136536 | 118064 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 422 36th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5984714.39139 | 2112995.82117 | 37.7809988539809 | -122.496539369065 | (37.7809988539809, -122.496539369065) | 11 | 6 | 2 | 55 | 26 | |||
137642 | 63185 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 422 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1986 12:00:00 AM | 10 | Permit Number 23724 | 5984714.39169 | 2112987.07257 | 37.7809748328781 | -122.496538722251 | (37.7809748328781, -122.496538722251) | 11 | 6 | 2 | 55 | 26 | |
58836 | 118063 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 436 36th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 5984715.27231 | 2112914.45835 | 37.7807755068603 | -122.49653031582 | (37.7807755068603, -122.49653031582) | 11 | 6 | 2 | 55 | 26 | |||
145361 | 118062 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 440 36th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 5984715.49156 | 2112889.6967 | 37.7807075313868 | -122.496527729579 | (37.7807075313868, -122.496527729579) | 11 | 6 | 2 | 55 | 26 | |||
126169 | 183158 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2343 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5984828.8916 | 2099248.795 | 37.7432600786984 | -122.495129244676 | (37.7432600786984, -122.495129244676) | 1 | 8 | 3 | 29491 | 35 | |||
42870 | 183159 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2343 37th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5984829.5681 | 2099229.5136 | 37.7432071768033 | -122.495125484028 | (37.7432071768033, -122.495125484028) | 1 | 8 | 3 | 29491 | 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) );