trees
3,267 rows where qSpecies_id = 67 sorted by PermitNotes descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
68944 | 49893 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 6@ OCEAN Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50572 | 5993153.17842145 | 2093093.53426236 | 37.7268430955942 | -122.46589912079 | (37.7268430955942, -122.46589912079) | 9 | 8 | 4 | 59 | 40 | ||
108217 | 87177 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1572 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50147 | 6014901.6694 | 2093877.1498 | 37.7302253707536 | -122.390769233 | (37.7302253707536, -122.390769233) | 10 | 3 | 8 | 58 | 1 | |
186897 | 82990 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 737 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50125 | 6009298.17418 | 2110240.35937 | 37.7748425951352 | -122.411296828379 | (37.7748425951352, -122.411296828379) | 8 | 2 | 9 | 28853 | 34 | |
58579 | 56293 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 214 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2007 12:00:00 AM | 3x3 | Permit Number 50007 | 6007818.00861163 | 2100270.55026834 | 37.7473846745488 | -122.415710973202 | (37.7473846745488, -122.415710973202) | 2 | 7 | 7 | 28859 | 2 | ||
101695 | 65575 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 44 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/28/2007 12:00:00 AM | 3x3 | Permit Number 49937 | 6007552.07395288 | 2099897.22885684 | 37.7463446647462 | -122.41660411777 | (37.7463446647462, -122.41660411777) | 2 | 7 | 7 | 28859 | 2 | ||
177709 | 42671 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1115 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3 | 3x3 | Permit Number 49824 | 6007552.92747 | 2119520.43861 | 37.8002253861525 | -122.417992022918 | (37.8002253861525, -122.417992022918) | 5 | 1 | 1 | 28858 | 32 | |
54750 | 81857 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 550 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2007 12:00:00 AM | 2 | 3x3 | Permit Number 49819 | 6013442.18813 | 2112205.75243 | 37.780470662242 | -122.397099557694 | (37.780470662242, -122.397099557694) | 6 | 2 | 9 | 28856 | 34 | |
163250 | 86756 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3630 18th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49737 | 6005363 | 2105488 | 37.7615722645382 | -122.424571307751 | (37.7615722645382, -122.424571307751) | 8 | 4 | 5 | 28859 | 19 | |||
178022 | 83014 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 815 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49726 | 5994400.44945449 | 2090555.08730476 | 37.7199450051039 | -122.461403423134 | (37.7199450051039, -122.461403423134) | 9 | 8 | 6 | 28861 | 24 | ||
74335 | 52816 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 201CLAREMONT Granville Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2006 12:00:00 AM | Permit Number 48842 | 5994261.61912336 | 2098704.96828598 | 37.7423145902485 | -122.462474141393 | (37.7423145902485, -122.462474141393) | 1 | 8 | 4 | 59 | 40 | |||
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 | ||
69122 | 51863 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1105 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 48085 | 6002530.44355674 | 2102366.89187427 | 37.752842076313 | -122.434144824059 | (37.752842076313, -122.434144824059) | 2 | 4 | 5 | 28862 | 22 | ||||
69032 | 51091 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 780 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/26/2004 12:00:00 AM | Permit Number 47548 | 6001488.77752298 | 2100017.17375191 | 37.7463311353619 | -122.437578831852 | (37.7463311353619, -122.437578831852) | 2 | 7 | 5 | 63 | 22 | |||
172692 | 50945 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1356 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2004 12:00:00 AM | 11 | Permit Number 47441 | 6016050.0855 | 2093024.8319 | 37.7279487256885 | -122.386739556348 | (37.7279487256885, -122.386739556348) | 10 | 3 | 8 | 58 | 1 | ||
128433 | 50912 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2046 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2004 12:00:00 AM | Permit Number 47415 | 5990698.44477594 | 2101463.24729555 | 37.749682273113 | -122.474995684738 | (37.749682273113, -122.474995684738) | 1 | 8 | 4 | 29491 | 12 | ||
188058 | 50847 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 176 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2004 12:00:00 AM | Permit Number 47363 | 6004021.29629095 | 2101032.3582184 | 37.7492622601609 | -122.42889404474 | (37.7492622601609, -122.42889404474) | 2 | 4 | 5 | 28862 | 22 | |||
137560 | 49972 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 919@ HOFFMAN Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2003 12:00:00 AM | Permit Number 46723 | 6000510.08423821 | 2101956.9058674 | 37.7516014804748 | -122.441102169267 | (37.7516014804748, -122.441102169267) | 2 | 4 | 5 | 28862 | 22 | |||
84838 | 37812 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 374 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/01/2003 12:00:00 AM | 6 | Permit Number 46656 | 6004021.4993 | 2091137.98354 | 37.722094560208 | -122.428188292583 | (37.722094560208, -122.428188292583) | 9 | 7 | 6 | 28861 | 5 | |
173480 | 49882 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 162 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/30/2003 12:00:00 AM | 3x3 | Permit Number 46648 | 6006777.25795679 | 2098638.4411642 | 37.7428447101937 | -122.41919406962 | (37.7428447101937, -122.41919406962) | 2 | 7 | 7 | 28859 | 2 | |
104970 | 49862 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 75@ LAGUNA Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/17/2004 12:00:00 AM | Permit Number 46631 | 6005455.52049644 | 2109220.32111529 | 37.7718255527878 | -122.424516811052 | (37.7718255527878, -122.424516811052) | 7 | 9 | 5 | 28852 | 10 | ||
122052 | 49694 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2346@ SANTIAGO 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2003 12:00:00 AM | Permit Number 46515 | 5991078.68424096 | 2099435.0073044 | 37.7441352809508 | -122.4735328886 | (37.7441352809508, -122.4735328886) | 1 | 8 | 4 | 29491 | 40 | |||
39133 | 49207 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2550 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46296 | 5987860.19003089 | 2106475.09481786 | 37.7632785526853 | -122.485178041739 | (37.7632785526853, -122.485178041739) | 1 | 8 | 3 | 56 | 35 | |||
172747 | 49206 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2550 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46296 | 5987860.19003089 | 2106475.09481786 | 37.7632785526853 | -122.485178041739 | (37.7632785526853, -122.485178041739) | 1 | 8 | 3 | 56 | 35 | |||
20386 | 49124 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 235 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/14/2003 12:00:00 AM | Permit Number 46255 | 5992667.25802575 | 2095222.38841823 | 37.7326603583325 | -122.467733682241 | (37.7326603583325, -122.467733682241) | 9 | 8 | 4 | 59 | 40 | ||
29608 | 33761 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1800X Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/2002 12:00:00 AM | 6 | 3x3 | Permit Number 46016 | 6003491.84820405 | 2114902.28438826 | 37.7873157193536 | -122.431715030855 | (37.7873157193536, -122.431715030855) | 13 | 9 | 11 | 29490 | 27 | |
186467 | 48734 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 112 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2002 12:00:00 AM | Permit Number 46014 | 6001443.50423179 | 2107544.90678437 | 37.7669978945619 | -122.438274574244 | (37.7669978945619, -122.438274574244) | 15 | 5 | 5 | 28862 | 3 | |||
136347 | 48569 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 150 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/2002 12:00:00 AM | Permit Number 45988 | 5992993.59423207 | 2088277.32681995 | 37.7136097512741 | -122.466100961633 | (37.7136097512741, -122.466100961633) | 9 | 8 | 6 | 64 | 24 | ||
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 | |
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 | |
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 | |
60996 | 39584 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 812 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2002 12:00:00 AM | Permit Number 45485 | 6011827.16127123 | 2104595.75128112 | 37.759485287628 | -122.402151554664 | (37.759485287628, -122.402151554664) | 10 | 3 | 8 | 28856 | 29 | ||
104045 | 31621 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 263 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/21/2002 12:00:00 AM | 5 | Permit Number 45471 | 6004202.65828 | 2091873.57703 | 37.7241245863632 | -122.427614452251 | (37.7241245863632, -122.427614452251) | 9 | 7 | 6 | 28861 | 5 | |
102231 | 47679 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 327 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/21/2002 12:00:00 AM | 6 | Permit Number 45466 | 6013233.56276 | 2105528.81136 | 37.762125666091 | -122.397352923703 | (37.762125666091, -122.397352923703) | 10 | 3 | 8 | 28856 | 29 | |
160584 | 47356 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 401 Ralston St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45281 | 5992189.97123037 | 2090518.77996357 | 37.7197178411259 | -122.469041573173 | (37.7197178411259, -122.469041573173) | 9 | 8 | 6 | 64 | 24 | ||
36269 | 47348 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 46 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45274 | 5994469.1469604 | 2090229.4816179 | 37.7190549234375 | -122.461142372223 | (37.7190549234375, -122.461142372223) | 9 | 8 | 6 | 28861 | 24 | ||
35966 | 47272 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2407 Lincoln Wy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2002 12:00:00 AM | Permit Number 45213 | 5988289.74121062 | 2107116.743846 | 37.7650653584421 | -122.483739432305 | (37.7650653584421, -122.483739432305) | 1 | 8 | 3 | 56 | 35 | |||
12837 | 47215 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 106 Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 6 | Permit Number 45166 | 6006633.47627 | 2094299.61445 | 37.7309231552671 | -122.419383490876 | (37.7309231552671, -122.419383490876) | 9 | 7 | 7 | 309 | 5 | |
122751 | 46792 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 283 Brentwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2002 12:00:00 AM | Permit Number 44883 | 5994892.79937141 | 2095160.94854023 | 37.7326199133932 | -122.460035042749 | (37.7326199133932, -122.460035042749) | 9 | 8 | 4 | 59 | 40 | ||
182656 | 46678 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1262 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/19/2002 12:00:00 AM | Permit Number 44808 | 5990516.58000296 | 2106798.86325494 | 37.7643219173773 | -122.476014208181 | (37.7643219173773, -122.476014208181) | 11 | 8 | 3 | 56 | 12 | ||
123766 | 46369 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 14 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/04/2002 12:00:00 AM | 12 | Permit Number 44606 | 5993652.77755 | 2115385.98394 | 37.788081196911 | -122.465791026812 | (37.788081196911, -122.465791026812) | 11 | 6 | 1 | 54 | 11 | ||
161366 | 46208 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 297 Wheeler Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/03/2002 12:00:00 AM | 12 | Permit Number 44524 | 6012148.34549 | 2087261.89541 | 37.711908076982 | -122.399823563722 | (37.711908076982, -122.399823563722) | 10 | 3 | 8 | 309 | 1 | ||
102189 | 46107 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 76 Oakwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/2001 12:00:00 AM | Permit Number 44471 | 6005231.58471967 | 2105020.01841489 | 37.7602798751206 | -122.424992522324 | (37.7602798751206, -122.424992522324) | 2 | 4 | 5 | 28859 | 19 | ||
175101 | 45780 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 646 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2001 12:00:00 AM | Permit Number 44420 | 5990064.86918672 | 2110959.72836088 | 37.7757203159741 | -122.47788072714 | (37.7757203159741, -122.47788072714) | 11 | 6 | 2 | 55 | 26 | |||
166334 | 45756 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1395 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/2001 12:00:00 AM | Permit Number 44403 | 6003940.26983915 | 2100157.37260664 | 37.7468551666159 | -122.429111856365 | (37.7468551666159, -122.429111856365) | 2 | 7 | 5 | 63 | 22 | |||
45623 | 45667 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3201 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/2001 12:00:00 AM | 5 | Permit Number 44363 | 5999332.42339 | 2119845.91977 | 37.8006529814106 | -122.446461503008 | (37.8006529814106, -122.446461503008) | 13 | 9 | 1 | 57 | 17 | ||
128142 | 45665 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1610 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/07/2001 12:00:00 AM | 9 | Permit Number 44361 | 6006993.4943 | 2116431.09301 | 37.7917113145738 | -122.41970856252 | (37.7917113145738, -122.41970856252) | 13 | 9 | 10 | 28858 | 21 | ||
130481 | 40767 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 84 Entrada Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/2001 12:00:00 AM | Permit Number 44234 | 5992466.60656122 | 2092147.31894937 | 37.7242053909011 | -122.468203758492 | (37.7242053909011, -122.468203758492) | 9 | 8 | 4 | 59 | 40 | ||
158165 | 40766 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 84 Entrada Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/2001 12:00:00 AM | Permit Number 44234 | 5992466.60656122 | 2092147.31894937 | 37.7242053909011 | -122.468203758492 | (37.7242053909011, -122.468203758492) | 9 | 8 | 4 | 59 | 40 | ||
171633 | 45438 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 601 Urbano Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/2001 12:00:00 AM | Permit Number 44225 | 5992911.96074183 | 2091864.48215283 | 37.7234545015521 | -122.466643698449 | (37.7234545015521, -122.466643698449) | 9 | 8 | 4 | 59 | 40 | ||
87798 | 45341 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 667 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/27/2001 12:00:00 AM | Permit Number 44171 | 5994015.44130584 | 2090992.03620537 | 37.7211225948175 | -122.462765934958 | (37.7211225948175, -122.462765934958) | 9 | 8 | 6 | 64 | 24 | ||
194122 | 45253 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 574 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2001 12:00:00 AM | Permit Number 44100 | 6009814.86507162 | 2098861.28779426 | 37.7436271988368 | -122.408706547484 | (37.7436271988368, -122.408706547484) | 2 | 7 | 7 | 28859 | 2 | ||
142830 | 45179 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 45 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/23/2001 12:00:00 AM | Permit Number 44027 | 6010663.82431958 | 2100176.74245024 | 37.7472866643277 | -122.405863682898 | (37.7472866643277, -122.405863682898) | 2 | 7 | 7 | 28859 | 2 | ||
69246 | 45091 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1900 Ortega St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2001 12:00:00 AM | Permit Number 43969 | 5988148.79891202 | 2102403.3041825 | 37.7521153260597 | -122.48388126909 | (37.7521153260597, -122.48388126909) | 1 | 8 | 3 | 56 | 35 | ||
91727 | 45088 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1900 Ortega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2001 12:00:00 AM | 2 | Permit Number 43969 | 5988077.6041 | 2102404.3375 | 37.7521140184342 | -122.484127544226 | (37.7521140184342, -122.484127544226) | 1 | 8 | 3 | 56 | 35 | |
169862 | 45087 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2237 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2001 12:00:00 AM | 4 | Permit Number 43968 | 5987019.1297 | 2102979.8533 | 37.7536325457586 | -122.487830139981 | (37.7536325457586, -122.487830139981) | 1 | 8 | 3 | 56 | 35 | |
169256 | 45059 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2346 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2001 12:00:00 AM | 0 | Permit Number 43944 | 5988289.16857731 | 2099339.5667467 | 37.7437112876863 | -122.483171307647 | (37.7437112876863, -122.483171307647) | 1 | 8 | 3 | 29491 | 35 | |
46940 | 44811 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2700x Kirkham St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2001 12:00:00 AM | Permit Number 43905 | 5986360 | 2105036 | 37.7592396918496 | -122.490260766294 | (37.7592396918496, -122.490260766294) | 1 | 8 | 3 | 56 | 35 | ||
162927 | 44471 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 133 Harvard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2001 12:00:00 AM | 7 | Permit Number 43785 | 6006112.38548 | 2093200.59482 | 37.7278761253611 | -122.421106983998 | (37.7278761253611, -122.421106983998) | 9 | 7 | 7 | 309 | 5 | |
174351 | 31018 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 21 Naylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 6 | Permit Number 43762 | 6002296.8403 | 2087180.6482 | 37.7111308594726 | -122.433867290956 | (37.7111308594726, -122.433867290956) | 9 | 7 | 6 | 28861 | 5 | |
186704 | 44402 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1162 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 7 | Permit Number 43756 | 6001306.88514 | 2087104.50261 | 37.7108655531865 | -122.437283363033 | (37.7108655531865, -122.437283363033) | 9 | 7 | 6 | 28861 | 5 | |
150300 | 44345 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 64 Montana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2001 12:00:00 AM | 3x3 | Permit Number 43728 | 5996130.57054216 | 2089332.51676928 | 37.7166875400006 | -122.455334718534 | (37.7166875400006, -122.455334718534) | 9 | 8 | 6 | 28861 | 24 | ||
52861 | 44282 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1588 Newhall St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2001 12:00:00 AM | Permit Number 43704 | 6014189.45600011 | 2095460.4720274 | 37.7345333093335 | -122.393342225003 | (37.7345333093335, -122.393342225003) | 10 | 3 | 8 | 58 | 1 | |||
145385 | 44097 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 690 De Haro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2000 12:00:00 AM | Permit Number 43610 | 6012084.69063396 | 2105194.13037963 | 37.7611426751013 | -122.401302935991 | (37.7611426751013, -122.401302935991) | 10 | 3 | 8 | 28856 | 29 | |||
179916 | 44096 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 690 De Haro St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2000 12:00:00 AM | Permit Number 43610 | 6012084.69063396 | 2105194.13037963 | 37.7611426751013 | -122.401302935991 | (37.7611426751013, -122.401302935991) | 10 | 3 | 8 | 28856 | 29 | |||
100228 | 43816 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2633 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2000 12:00:00 AM | 4 | Permit Number 43447 | 5986134.8144 | 2097343.6322 | 37.738105378566 | -122.490473636095 | (37.738105378566, -122.490473636095) | 1 | 8 | 3 | 29491 | 35 | |
170090 | 43815 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2633 33rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2000 12:00:00 AM | 4 | Permit Number 43447 | 5986135.8757 | 2097320.2838 | 37.7380413320507 | -122.490468249476 | (37.7380413320507, -122.490468249476) | 1 | 8 | 3 | 29491 | 35 | |
66511 | 43782 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 125 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | 4 | Permit Number 43412 | 5989265.29398 | 2114516.23084 | 37.7854390383616 | -122.480907074228 | (37.7854390383616, -122.480907074228) | 11 | 6 | 2 | 55 | 26 | |
37915 | 43699 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 901 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 4 | Permit Number 43342 | 5992748.80796 | 2111348.45458 | 37.7769430589995 | -122.468624685117 | (37.7769430589995, -122.468624685117) | 11 | 6 | 2 | 54 | 11 | |
131960 | 43698 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 901 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 4 | Permit Number 43342 | 5992720.92787 | 2111349.56559 | 37.7769444989499 | -122.468721210908 | (37.7769444989499, -122.468721210908) | 11 | 6 | 2 | 54 | 11 | |
134998 | 43663 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 646 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 3 | Permit Number 43306 | 5992570.03325 | 2111039.10475 | 37.7760833392201 | -122.469220595166 | (37.7760833392201, -122.469220595166) | 11 | 6 | 2 | 54 | 11 | |
159950 | 43629 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2819 Pacheco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | 4 | Permit Number 43278 | 5986182.935 | 2101604.9629 | 37.7498086596621 | -122.490620697371 | (37.7498086596621, -122.490620697371) | 1 | 8 | 3 | 29491 | 35 | |
6980 | 43621 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2095 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43271 | 5985386.76911027 | 2100967.4929928 | 37.7480118028434 | -122.493326874686 | (37.7480118028434, -122.493326874686) | 1 | 8 | 3 | 29491 | 35 | ||
53062 | 43620 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2095 35th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43271 | 5985386.76911027 | 2100967.4929928 | 37.7480118028434 | -122.493326874686 | (37.7480118028434, -122.493326874686) | 1 | 8 | 3 | 29491 | 35 | ||
63650 | 43622 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2095 35th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43271 | 5985386.76911027 | 2100967.4929928 | 37.7480118028434 | -122.493326874686 | (37.7480118028434, -122.493326874686) | 1 | 8 | 3 | 29491 | 35 | ||
80478 | 43619 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2095 35th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43271 | 5985386.76911027 | 2100967.4929928 | 37.7480118028434 | -122.493326874686 | (37.7480118028434, -122.493326874686) | 1 | 8 | 3 | 29491 | 35 | ||
41349 | 43584 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 117 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43245 | 6005148.55344947 | 2099289.0817491 | 37.7445393628941 | -122.424871957382 | (37.7445393628941, -122.424871957382) | 2 | 7 | 5 | 63 | 22 | ||
117404 | 43562 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 406 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43223 | 6003924.16559982 | 2098981.19483718 | 37.7436247428067 | -122.429083695417 | (37.7436247428067, -122.429083695417) | 2 | 7 | 5 | 63 | 22 | ||
94137 | 43556 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 338 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43219 | 6003694.36665872 | 2099553.79617946 | 37.745183962731 | -122.429919119626 | (37.745183962731, -122.429919119626) | 2 | 7 | 5 | 63 | 22 | ||
70304 | 43528 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1596 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2000 12:00:00 AM | Permit Number 43202 | 6000228.69199764 | 2110281.0663022 | 37.7744415315581 | -122.442672890747 | (37.7744415315581, -122.442672890747) | 15 | 5 | 11 | 29492 | 16 | ||
43191 | 43520 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 720 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2000 12:00:00 AM | 5 | Permit Number 43195 | 5999637.6503 | 2111009.9076 | 37.776409033576 | -122.444769809105 | (37.776409033576, -122.444769809105) | 15 | 5 | 11 | 29492 | 16 | |
46244 | 43503 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 414 Jarboe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2000 12:00:00 AM | Permit Number 43181 | 6008275.24653868 | 2096942.34637883 | 37.7382718551597 | -122.413894474617 | (37.7382718551597, -122.413894474617) | 2 | 7 | 7 | 28859 | 2 | ||
800 | 43502 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 401 Gates St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2000 12:00:00 AM | Permit Number 43180 | 6008272.42807324 | 2096955.00828501 | 37.7383064636933 | -122.413905114955 | (37.7383064636933, -122.413905114955) | 2 | 7 | 7 | 28859 | 2 | ||
21768 | 43501 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 401 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2000 12:00:00 AM | Permit Number 43180 | 6008272.42807324 | 2096955.00828501 | 37.7383064636933 | -122.413905114955 | (37.7383064636933, -122.413905114955) | 2 | 7 | 7 | 28859 | 2 | ||
186819 | 43500 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 401 Gates St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2000 12:00:00 AM | Permit Number 43180 | 6008272.42807324 | 2096955.00828501 | 37.7383064636933 | -122.413905114955 | (37.7383064636933, -122.413905114955) | 2 | 7 | 7 | 28859 | 2 | ||
134722 | 43410 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 500 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | Permit Number 43153 | 6003043.41412422 | 2103902.50262654 | 37.7570875987945 | -122.432480551364 | (37.7570875987945, -122.432480551364) | 2 | 4 | 5 | 28862 | 3 | ||
26126 | 43383 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 841 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | Permit Number 43131 | 6001927.7573942 | 2101646.83292556 | 37.7508307421205 | -122.436177496021 | (37.7508307421205, -122.436177496021) | 2 | 4 | 5 | 28862 | 22 | ||
71686 | 43362 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1100X Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | 4 | 3x9 | Permit Number 43112 | 6003157.69483217 | 2101814.87307727 | 37.751361942995 | -122.431936260805 | (37.751361942995, -122.431936260805) | 2 | 4 | 5 | 28862 | 22 |
6771 | 43351 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 385 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1977 12:00:00 AM | 26 | 3x3 | Permit Number 43103 | 6010005.03169 | 2109964.91982 | 37.7741259209126 | -122.408832212936 | (37.7741259209126, -122.408832212936) | 8 | 2 | 9 | 28853 | 34 | |
163089 | 43337 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 451 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/2000 12:00:00 AM | 8 | Permit Number 43094 | 6003321.30466 | 2090952.47585 | 37.7215455546665 | -122.430595462026 | (37.7215455546665, -122.430595462026) | 9 | 7 | 6 | 28861 | 5 | |
65675 | 43164 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 243 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 7 | Permit Number 42974 | 6005687.81247 | 2092539.35146 | 37.7260365522386 | -122.42252777796 | (37.7260365522386, -122.42252777796) | 9 | 7 | 7 | 309 | 5 | |
129177 | 43165 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 243 Madison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 6 | Permit Number 42974 | 6005684.86708 | 2092551.58359 | 37.7260699728301 | -122.422538828812 | (37.7260699728301, -122.422538828812) | 9 | 7 | 7 | 309 | 5 | |
179519 | 43151 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 331 Gambier St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 6 | Permit Number 42962 | 6006091.63711 | 2092241.6461 | 37.7252418914959 | -122.421110649635 | (37.7252418914959, -122.421110649635) | 9 | 7 | 7 | 309 | 5 | |
180962 | 43130 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 64 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/02/2003 12:00:00 AM | Permit Number 42948 | 6007257.5436596 | 2099135.12051049 | 37.7442355171504 | -122.417568566517 | (37.7442355171504, -122.417568566517) | 2 | 7 | 7 | 28859 | 2 | ||
159951 | 43090 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 146 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2000 12:00:00 AM | Permit Number 42926 | 6008611.57202226 | 2112975.23965235 | 37.7823133939911 | -122.413865436957 | (37.7823133939911, -122.413865436957) | 7 | 10 | 9 | 28852 | 36 | |||
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 | |
6979 | 42994 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 500 Yale St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42870 | 6007553.67502493 | 2091408.33369541 | 37.7230361052022 | -122.415997529963 | (37.7230361052022, -122.415997529963) | 9 | 3 | 7 | 309 | 28 | ||
68826 | 42991 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 500 Yale St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42870 | 6007553.67502493 | 2091408.33369541 | 37.7230361052022 | -122.415997529963 | (37.7230361052022, -122.415997529963) | 9 | 3 | 7 | 309 | 28 | ||
156851 | 42992 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 500 Yale St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42870 | 6007553.67502493 | 2091408.33369541 | 37.7230361052022 | -122.415997529963 | (37.7230361052022, -122.415997529963) | 9 | 3 | 7 | 309 | 28 | ||
169813 | 42993 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 500 Yale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42870 | 6007553.67502493 | 2091408.33369541 | 37.7230361052022 | -122.415997529963 | (37.7230361052022, -122.415997529963) | 9 | 3 | 7 | 309 | 28 | ||
78218 | 42900 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2200 Wawona St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/03/2000 12:00:00 AM | Permit Number 42815 | 5986138.5427207 | 2097288.78551671 | 37.737955001906 | -122.490456711772 | (37.737955001906, -122.490456711772) | 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) );