Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 58961 | 58961 | 31221 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 766 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/1995 12:00:00 AM | Permit Number 34908 | 5981084.03491617 | 2110503.52214182 | 37.773942382229706 | -122.50891323703699 | (37.7739423822297, -122.508913237037) | |||
| 107182 | 107182 | 38361 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1626 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/1998 12:00:00 AM | Permit Number 40425 | 5980991.46797396 | 2103984.91123867 | 37.756038708992 | -122.5087493697 | (37.756038708992, -122.5087493697) | ||
| 1091 | 1091 | 110107 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4130 MORAGA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/2016 12:00:00 AM | 15 | 3x3 | Permit Number 774958 | 5981430.4 | 2103553.9 | 37.7548811373619 | -122.507199448976 | (37.7548811373619, -122.507199448976) | |
| 127619 | 127619 | 31933 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1282 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776912 | 5981529.52333604 | 2106358.00177396 | 37.76258623775 | -122.507064660839 | (37.76258623775, -122.507064660839) | |
| 62048 | 62048 | 37093 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1426 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 3 | Permit Number 39693 | 5981559.2885 | 2105362.1483 | 37.7598536626334 | -122.506887844351 | (37.7598536626334, -122.506887844351) | |
| 188830 | 188830 | 118808 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 894 46th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5981738.117319999 | 2109674.1043 | 37.771703578835 | -122.50658917067 | (37.771703578835, -122.50658917067) | |||
| 151869 | 151869 | 118809 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 894 46th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 5981738.19338 | 2109667.15136 | 37.771684492567395 | -122.50658839183001 | (37.7716844925674, -122.50658839183) | |||
| 163381 | 163381 | 118557 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 8100 Geary Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5981820.409519999 | 2112394.33685 | 37.7791773847362 | -122.506506292125 | (37.7791773847362, -122.506506292125) | |||
| 77897 | 77897 | 105128 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1835 47TH AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774579 | 5981612.2 | 2102591.6 | 37.752249639902296 | -122.506499383522 | (37.7522496399023, -122.506499383522) | |
| 40560 | 40560 | 118432 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5426 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5981813.70914 | 2111694.92203 | 37.7772566032383 | -122.506477588254 | (37.7772566032383, -122.506477588254) | |||
| 71678 | 71678 | 118556 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 8100 Geary Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5981834.606430001 | 2112394.66752 | 37.7791791285364 | -122.506457204565 | (37.7791791285364, -122.506457204565) | |||
| 69346 | 69346 | 69027 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3830 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1994 12:00:00 AM | 0 | Permit Number 33031 | 5981593.45716069 | 2100816.99566217 | 37.747375971680796 | -122.50643260796801 | (37.7473759716808, -122.506432607968) | |
| 180295 | 180295 | 47842 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4430 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/14/2002 12:00:00 AM | 2 | Permit Number 45603 | 5981809.260840001 | 2110330.3031 | 37.773509497941106 | -122.506391755128 | (37.7735094979411, -122.506391755128) | |
| 69636 | 69636 | 118804 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6940 Fulton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 5981816.18929 | 2109660.54581 | 37.77167094779411 | -122.506318113931 | (37.7716709477941, -122.506318113931) | |||
| 41651 | 41651 | 47841 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4424 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/14/2002 12:00:00 AM | 3 | Permit Number 45602 | 5981838.80851 | 2110330.1740900003 | 37.773510883288395 | -122.506289537608 | (37.7735108832884, -122.506289537608) | |
| 167438 | 167438 | 119074 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 727 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 1ft | 5981953.2643 | 2110779.7275400003 | 37.7747519632118 | -122.505926961402 | (37.7747519632118, -122.505926961402) | |||
| 180644 | 180644 | 34699 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 783 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 5 | Permit Number 38358 | 5981962.67601 | 2110441.20269 | 37.7738230269301 | -122.505869302151 | (37.7738230269301, -122.505869302151) | |
| 107966 | 107966 | 184153 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1583 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5981862.9826 | 2104319.103 | 37.757007636949204 | -122.505760207392 | (37.7570076369492, -122.505760207392) | |||
| 147881 | 147881 | 47827 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 879 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/13/2002 12:00:00 AM | 3 | Permit Number 45589 | 5981988.70883 | 2109787.39481 | 37.7720293934096 | -122.505730773826 | (37.7720293934096, -122.505730773826) | |
| 50563 | 50563 | 183288 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1285 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5982099.3385 | 2106416.2727 | 37.762779775667 | -122.505098228653 | (37.762779775667, -122.505098228653) | |||
| 12766 | 12766 | 31651 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3530 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/02/2016 12:00:00 AM | 3 | Permit Number 778640 | 5981977.0239 | 2096750.5895 | 37.736233320022 | -122.50480501648701 | (37.736233320022, -122.504805016487) | |
| 173520 | 173520 | 183203 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2495 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5982070.7667 | 2098188.3746 | 37.7401865975237 | -122.50458740789101 | (37.7401865975237, -122.504587407891) | |||
| 155748 | 155748 | 183205 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2499 46th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5982072.7972 | 2098155.8861 | 37.7400975124895 | -122.504577980898 | (37.7400975124895, -122.504577980898) | |||
| 162877 | 162877 | 74930 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4045 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 5 | 5982222.2441 | 2104869.0336 | 37.758538728740504 | -122.50455850908999 | (37.7585387287405, -122.50455850909) | ||
| 150731 | 150731 | 74788 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4045 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 5 | 5982233.8553 | 2104870.2558 | 37.758542767533 | -122.504518443568 | (37.758542767533, -122.504518443568) | ||
| 157821 | 157821 | 74635 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4045 Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 4 | 5982248.2166 | 2104869.6447 | 37.7585419343481 | -122.504468731299 | (37.7585419343481, -122.504468731299) | ||
| 145577 | 145577 | 38376 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3809 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/1998 12:00:00 AM | Permit Number 40435 | 5982211.97867906 | 2102828.4142054003 | 37.7529351608085 | -122.504442832568 | (37.7529351608085, -122.504442832568) | ||
| 53271 | 53271 | 74480 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4045 Kirkham St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 5 | 5982259.5223 | 2104870.2558 | 37.7585442772343 | -122.504429677037 | (37.7585442772343, -122.504429677037) | ||
| 153208 | 153208 | 52037 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2530 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2005 12:00:00 AM | 0 | Permit Number 48249 | 5982130.19675143 | 2097871.80760373 | 37.7393208872786 | -122.50435848033001 | (37.7393208872786, -122.50435848033) | ||
| 62150 | 62150 | 184538 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1939 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5982255.8834 | 2101901.5386 | 37.750392802727795 | -122.504222349881 | (37.7503928027278, -122.504222349881) | |||
| 44034 | 44034 | 38344 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1858 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1998 12:00:00 AM | 2 | Permit Number 40411 | 5982279.7422 | 2102452.6585 | 37.7519074266581 | -122.504180665511 | (37.7519074266581, -122.504180665511) | |
| 27024 | 27024 | 38346 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1862 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1998 12:00:00 AM | 3 | Permit Number 40413 | 5982280.7574 | 2102429.3074 | 37.7518433707941 | -122.50417542529499 | (37.7518433707941, -122.504175425295) | |
| 97557 | 97557 | 109717 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3832 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773646 | 5982350.4 | 2103585.5 | 37.7550220459753 | -122.50402022585101 | (37.7550220459753, -122.504020225851) |
| 151829 | 151829 | 39816 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2135 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | 3 | Permit Number 41147 | 5982300.3859 | 2100562.0651 | 37.746717599317 | -122.50396925971201 | (37.746717599317, -122.503969259712) | |
| 131677 | 131677 | 184456 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2150 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982348.1034 | 2100464.5996 | 37.746452792008704 | -122.50379704294399 | (37.7464527920087, -122.503797042944) | |||
| 65967 | 65967 | 69012 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2170 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1994 12:00:00 AM | 3 | Permit Number 33015 | 5982352.1644 | 2100332.9535 | 37.746091567164896 | -122.503773252601 | (37.7460915671649, -122.503773252601) | |
| 46613 | 46613 | 70168 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5129 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1993 12:00:00 AM | 6 | 5982718.93125 | 2111668.1719299997 | 37.7772364107813 | -122.50334420523399 | (37.7772364107813, -122.503344205234) | ||
| 180643 | 180643 | 184496 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1870 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982593.1208 | 2102386.6662 | 37.751744655158205 | -122.503092090825 | (37.7517446551582, -122.503092090825) | |||
| 61476 | 61476 | 69162 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1201 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1994 12:00:00 AM | 6 | Permit Number 33199 | 5982705.2838 | 2106882.9636 | 37.7640968091015 | -122.503037064776 | (37.7640968091015, -122.503037064776) | |
| 161396 | 161396 | 117651 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5101 Anza St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 5982808.62425 | 2111663.8514799997 | 37.77722982032 | -122.503033613638 | (37.77722982032, -122.503033613638) | |||
| 47556 | 47556 | 117652 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5101 Anza St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 5982828.88915 | 2111662.8174900003 | 37.7772281723606 | -122.502963435462 | (37.7772281723606, -122.502963435462) | |||
| 66665 | 66665 | 184455 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2167 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982617.4871 | 2100369.1647 | 37.7462065900459 | -122.50285849639401 | (37.7462065900459, -122.502858496394) | |||
| 146687 | 146687 | 185238 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2519 44th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5982696.2593 | 2097960.1988 | 37.7395968623425 | -122.502407859991 | (37.7395968623425, -122.502407859991) | |||
| 61623 | 61623 | 117713 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 499 41st Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 1ft | 5983130.2288 | 2112588.4481099998 | 37.779787390189 | -122.501989530515 | (37.779787390189, -122.501989530515) | |||
| 38939 | 38939 | 117714 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 499 41st Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 5983131.928719999 | 2112572.07967 | 37.779742547104895 | -122.501982438335 | (37.7797425471049, -122.501982438335) | |||
| 63291 | 63291 | 183624 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1427 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5983067.6354 | 2105411.9181 | 37.7600790269008 | -122.50167497723301 | (37.7600790269008, -122.501674977233) | |||
| 32716 | 32716 | 117876 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 870 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5983272.478209999 | 2109867.2911 | 37.7723242388321 | -122.50129609848999 | (37.7723242388321, -122.50129609849) | |||
| 49088 | 49088 | 117875 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 870 41st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5983273.23794 | 2109885.94663 | 37.7723755061498 | -122.50129485073 | (37.7723755061498, -122.50129485073) | |||
| 178057 | 178057 | 183269 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1249 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5983336.1919 | 2106636.3882 | 37.763456845523 | -122.500836736792 | (37.763456845523, -122.500836736792) | |||
| 157394 | 157394 | 69156 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1255 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1994 12:00:00 AM | 7 | Permit Number 33192 | 5983336.7375 | 2106596.5609 | 37.763347523099796 | -122.5008319043 | (37.7633475230998, -122.5008319043) | |
| 186359 | 186359 | 62064 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1259 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1985 12:00:00 AM | 8 | Permit Number 22145 | 5983337.283 | 2106566.0084 | 37.763263666636206 | -122.50082775809099 | (37.7632636666362, -122.500827758091) | ||
| 75212 | 75212 | 117735 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 486 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5983485.16347 | 2112571.27712 | 37.7797610881372 | -122.50076040526301 | (37.7797610881372, -122.500760405263) | |||
| 173438 | 173438 | 61360 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 771 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/1984 12:00:00 AM | 6 | Permit Number 21269 | 5983513.83177 | 2110574.47725 | 37.774280138594 | -122.500513546398 | (37.774280138594, -122.500513546398) | ||
| 178385 | 178385 | 117907 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 771 40th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5983515.60054 | 2110554.4350099997 | 37.7742252122257 | -122.500505945779 | (37.7742252122257, -122.500505945779) | |||
| 164971 | 164971 | 117745 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 433 39th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5983738.48385 | 2112900.68218 | 37.7806804074829 | -122.499908428658 | (37.7806804074829, -122.499908428658) | |||
| 131278 | 131278 | 117746 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 433 39th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5983739.045419999 | 2112883.08497 | 37.7806321236335 | -122.49990518483 | (37.7806321236335, -122.49990518483) | |||
| 169063 | 169063 | 117791 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3835 Balboa St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 5983712.00909 | 2111006.51054 | 37.775478008697704 | -122.499859966334 | (37.7754780086977, -122.499859966334) | |||
| 110292 | 110292 | 109264 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3338X Ortega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | 5983663.54917 | 2102222.75157 | 37.7513574508855 | -122.499378353213 | (37.7513574508855, -122.499378353213) | |
| 124674 | 124674 | 109263 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3338X Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | 5983663.54917 | 2102222.75157 | 37.7513574508855 | -122.499378353213 | (37.7513574508855, -122.499378353213) | |
| 112197 | 112197 | 104793 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 700 39th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 5983853.5987599995 | 2111004.1266 | 37.775479771007205 | -122.499370005427 | (37.7754797710072, -122.499370005427) | ||||
| 87035 | 87035 | 104818 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 700 39th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | Permit Number 771234 | 5983853.47864 | 2110990.25289 | 37.7754416707598 | -122.49936939548401 | (37.7754416707598, -122.499369395484) | ||
| 157787 | 157787 | 104792 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 700 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Permit Number 771234 | 5983853.47126 | 2110973.3906900003 | 37.775395371596 | -122.49936817466299 | (37.775395371596, -122.499368174663) | |||
| 87751 | 87751 | 115170 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2483 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | Permit Number 775167 | 5983603.3 | 2098266.1 | 37.7404900382804 | -122.499294352828 | (37.7404900382804, -122.499294352828) | |||
| 137376 | 137376 | 52565 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1490 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2016 12:00:00 AM | 3 | Permit Number 776032 | 5983749.00829455 | 2105020.42381918 | 37.759044091677204 | -122.49928954186399 | (37.7590440916772, -122.499289541864) | |
| 37431 | 37431 | 183681 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1323 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5983973.0216 | 2106131.3597 | 37.7621075487897 | -122.49859687365499 | (37.7621075487897, -122.498596873655) | |||
| 172132 | 172132 | 183682 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1323 39th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5983973.4902 | 2106147.0568 | 37.7621506760822 | -122.498596412549 | (37.7621506760822, -122.498596412549) | |||
| 106629 | 106629 | 24728 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 7350X Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 5 | 5984131.94818 | 2112492.82889 | 37.7795836433147 | -122.498517132313 | (37.7795836433147, -122.498517132313) | |||
| 124412 | 124412 | 24726 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 7350X Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 5 | 5984167.63724 | 2112494.16793 | 37.7795894128065 | -122.498393769373 | (37.7795894128065, -122.498393769373) | |||
| 70293 | 70293 | 117983 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 82 Shore View Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 5984187.509869999 | 2112858.34 | 37.7805904888414 | -122.498351927647 | (37.7805904888414, -122.498351927647) | |||
| 67406 | 67406 | 69044 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1426 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1994 12:00:00 AM | 2 | Permit Number 33051 | 5984041.3218 | 2105444.0326 | 37.760224347253704 | -122.498309886187 | (37.7602243472537, -122.498309886187) | |
| 55853 | 55853 | 117982 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 82 Shore View Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 5ft | 5984203.12595 | 2112857.2788400003 | 37.780588490902204 | -122.498297826626 | (37.7805884909022, -122.498297826626) | |||
| 105390 | 105390 | 24727 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 7360X Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 5 | 5984208.26148 | 2112495.49313 | 37.7795954335493 | -122.498253332745 | (37.7795954335493, -122.498253332745) | |||
| 163543 | 163543 | 69142 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2510 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/18/1994 12:00:00 AM | 4 | Permit Number 33175 | 5983984.3277 | 2098057.6781 | 37.739940114671796 | -122.49796154087299 | (37.7399401146718, -122.497961540873) | |
| 135818 | 135818 | 184586 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1750 39th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5984116.0189 | 2103254.2105 | 37.7542160870284 | -122.497889842793 | (37.7542160870284, -122.497889842793) | |||
| 136011 | 136011 | 184902 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1798 39th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5984123.4641 | 2103002.4247 | 37.7535251895885 | -122.497845504869 | (37.7535251895885, -122.497845504869) | |||
| 155893 | 155893 | 184903 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1798 39th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5984124.141 | 2103020.0227 | 37.75357354849729 | -122.49784446339899 | (37.7535735484973, -122.497844463399) | |||
| 43308 | 43308 | 184901 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1798 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5984126.5099 | 2102985.5036 | 37.7534789074993 | -122.497833722621 | (37.7534789074993, -122.497833722621) | |||
| 55767 | 55767 | 184899 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3136 Noriega St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5984158.9984 | 2102960.4604 | 37.7534120503685 | -122.497719523191 | (37.7534120503685, -122.497719523191) | |||
| 68260 | 68260 | 101374 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3136 Noriega St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 5984176.5964 | 2102959.4451 | 37.753410294226605 | -122.497658591569 | (37.7534102942266, -122.497658591569) | |||
| 44113 | 44113 | 101373 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3136 Noriega St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 5984197.9169 | 2102961.1373 | 37.7534161902989 | -122.49758498684099 | (37.7534161902989, -122.497584986841) | |||
| 117324 | 117324 | 90664 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3600X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984368.50089 | 2110421.4059900003 | 37.773909982922 | -122.497545831628 | (37.773909982922, -122.497545831628) | ||
| 61074 | 61074 | 101372 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3136 Noriega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 5984213.4843 | 2102962.4909 | 37.753420819406706 | -122.497531252237 | (37.7534208194067, -122.497531252237) | |||
| 143249 | 143249 | 109192 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3826 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773182 | 5984114.7 | 2098211.0 | 37.7403687376469 | -122.497522091318 | (37.7403687376469, -122.497522091318) |
| 65494 | 65494 | 101371 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3136 Noriega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 5984231.0823 | 2102962.1525 | 37.7534209217472 | -122.49747037058201 | (37.7534209217472, -122.497470370582) | |||
| 18490 | 18490 | 90663 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3600X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984396.70061 | 2110421.43862 | 37.7739117254104 | -122.497448288038 | (37.7739117254104, -122.497448288038) | ||
| 76729 | 76729 | 43046 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2223 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2000 12:00:00 AM | 0 | Permit Number 42900 | 5984177.60639634 | 2100035.08697595 | 37.7453808710845 | -122.497439220864 | (37.7453808710845, -122.497439220864) | |
| 169894 | 169894 | 101370 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3136 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 5984248.6802 | 2102962.4909 | 37.75342288235571 | -122.49740953923401 | (37.7534228823557, -122.497409539234) | |||
| 151665 | 151665 | 118213 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 786 37th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5984488.76737 | 2110557.5844099997 | 37.7742909385344 | -122.49713987037701 | (37.7742909385344, -122.497139870377) | |||
| 131565 | 131565 | 184310 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1566 38th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5984383.5526 | 2104514.4673 | 37.7576920825092 | -122.49705767506501 | (37.7576920825092, -122.497057675065) | |||
| 137389 | 137389 | 184581 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1747 38th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 5984379.9879 | 2103282.6380000003 | 37.754309612877606 | -122.49697908435499 | (37.7543096128776, -122.496979084355) | |||
| 150618 | 150618 | 183671 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1251 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5984575.2383 | 2106662.4217 | 37.763600995187296 | -122.496553259461 | (37.7636009951873, -122.496553259461) | |||
| 51348 | 51348 | 118064 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 422 36th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5984714.3913900005 | 2112995.82117 | 37.7809988539809 | -122.496539369065 | (37.7809988539809, -122.496539369065) | |||
| 176699 | 176699 | 63185 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 422 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | 10 | Permit Number 23724 | 5984714.39169 | 2112987.07257 | 37.7809748328781 | -122.49653872225099 | (37.7809748328781, -122.496538722251) | |
| 181162 | 181162 | 118063 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 436 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 5984715.27231 | 2112914.45835 | 37.7807755068603 | -122.49653031581998 | (37.7807755068603, -122.49653031582) | |||
| 25851 | 25851 | 118062 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 440 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5984715.49156 | 2112889.6967 | 37.780707531386795 | -122.49652772957899 | (37.7807075313868, -122.496527729579) | |||
| 175779 | 175779 | 183158 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2343 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5984828.8916 | 2099248.795 | 37.7432600786984 | -122.495129244676 | (37.7432600786984, -122.495129244676) | |||
| 166532 | 166532 | 183159 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2343 37th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5984829.5681 | 2099229.5136 | 37.743207176803296 | -122.495125484028 | (37.7432071768033, -122.495125484028) | |||
| 186185 | 186185 | 118197 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 854 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5985129.46511 | 2110039.1376900002 | 37.7729049579345 | -122.49488537836599 | (37.7729049579345, -122.494885378366) | |||
| 42460 | 42460 | 118196 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 854 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5985129.69705 | 2110050.01685 | 37.7729348425865 | -122.49488537836099 | (37.7729348425865, -122.494885378361) | |||
| 34509 | 34509 | 32604 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1327 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 6 | Permit Number 37070 | 5985214.1986 | 2106157.4162 | 37.7622518049359 | -122.49430610263501 | (37.7622518049359, -122.494306102635) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");