trees
2,180 rows where qSpecies_id = 57 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
77590 | 173780 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 99X Cleveland St | 3 | Side Yard : Yard | Tree | Private 2 | 3x6 | 6010549 | 2110746 | 37.7763010397716 | -122.407005587048 | (37.7763010397716, -122.407005587048) | 14 | 2 | 9 | 28853 | 34 | ||||
77862 | 39881 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 21 Stillman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/21/1999 12:00:00 AM | Permit Number 41174 | 6014188.8231878 | 2113135.05532668 | 37.7830638517017 | -122.394581669285 | (37.7830638517017, -122.394581669285) | 6 | 2 | 9 | 28856 | 6 | ||
78075 | 98679 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 199X Park St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6006189.1 | 2096374.1 | 37.7365941955595 | -122.421067016387 | (37.7365941955595, -122.421067016387) | 2 | 7 | 7 | 28859 | 2 | ||||
79334 | 33772 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 3101 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/08/1987 12:00:00 AM | Permit Number 37819 | 6009092.65010174 | 2104478.80438725 | 37.7590111673758 | -122.41160061802 | (37.7590111673758, -122.41160061802) | 2 | 4 | 7 | 28859 | 19 | ||
80257 | 122411 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 8 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
80424 | 110186 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 625 Holly Park Cir | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6006167.62160945 | 2096413.49051844 | 37.7367011423593 | -122.421144072665 | (37.7367011423593, -122.421144072665) | 2 | 7 | 7 | 28859 | 2 | ||||
81077 | 61842 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1061 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | Permit Number 21881 | 6010272.43259961 | 2103046.27865741 | 37.7551438802467 | -122.4074193619 | (37.7551438802467, -122.4074193619) | 10 | 4 | 7 | 28859 | 19 | ||
81604 | 112350 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 130 WEST PORTAL AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992742 | 2097684 | 37.7394236424672 | -122.46765424156 | (37.7394236424672, -122.46765424156) | 1 | 8 | 4 | 59 | 40 | ||||
81722 | 103609 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 200X Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004748.9 | 2109266.8 | 37.7719132424086 | -122.426964371637 | (37.7719132424086, -122.426964371637) | 7 | 9 | 5 | 28852 | 10 | ||||
81991 | 63237 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 3659 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/23/1988 12:00:00 AM | Permit Number 23785 | 6005918.83139631 | 2104302.58106763 | 37.7583487563714 | -122.422564673736 | (37.7583487563714, -122.422564673736) | 2 | 4 | 5 | 28859 | 19 | ||
82152 | 61697 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 22 Ramona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1984 12:00:00 AM | Permit Number 21696 | 6005166.04109398 | 2107681.05439541 | 37.767582744756 | -122.425408581153 | (37.767582744756, -122.425408581153) | 8 | 4 | 5 | 28853 | 19 | ||
82436 | 68881 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 318 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | Permit Number 32853 | 5998787.73896502 | 2093851.41161762 | 37.7292474820186 | -122.446475160796 | (37.7292474820186, -122.446475160796) | 9 | 7 | 4 | 28861 | 40 | ||
84029 | 102075 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 273 Magellan Ave | 5 | Front Yard : Yard | Tree | Private 2 | 5994674.1 | 2100293.4 | 37.7466997707371 | -122.461163031194 | (37.7466997707371, -122.461163031194) | 1 | 8 | 4 | 29491 | 40 | |||||
84106 | 121040 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2101 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006363 | 2118098 | 37.7962526868942 | -122.422008539697 | (37.7962526868942, -122.422008539697) | 13 | 9 | 10 | 28858 | 32 | ||||
85101 | 89033 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 272 Main St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
85229 | 68478 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1064 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32347 | 6010221.7563028 | 2103020.9810754 | 37.755071582179 | -122.407592832606 | (37.755071582179, -122.407592832606) | 2 | 4 | 7 | 28859 | 19 | ||
85919 | 98676 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 199X Park St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6006189.1 | 2096374.1 | 37.7365941955595 | -122.421067016387 | (37.7365941955595, -122.421067016387) | 2 | 7 | 7 | 28859 | 2 | ||||
86241 | 68860 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 388 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | Permit Number 32823 | 5998853.5547129 | 2094405.18527642 | 37.7307717735093 | -122.446287451153 | (37.7307717735093, -122.446287451153) | 9 | 7 | 4 | 59 | 40 | ||
86724 | 37256 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 4200 20th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | Permit Number 39805 | 6002396.16255256 | 2104159.25249428 | 37.7577558475859 | -122.434737351341 | (37.7577558475859, -122.434737351341) | 2 | 4 | 5 | 28862 | 3 | ||
86839 | 62794 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1866 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23151 | 6000307.76766309 | 2093181.82122993 | 37.727495644326 | -122.441172281845 | (37.727495644326, -122.441172281845) | 9 | 7 | 6 | 28861 | 25 | ||
87128 | 61700 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 38 Ramona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1984 12:00:00 AM | Permit Number 21699 | 6005171.1078492 | 2107589.60782986 | 37.7673319406498 | -122.425384547486 | (37.7673319406498, -122.425384547486) | 8 | 4 | 5 | 28853 | 19 | ||
87145 | 113435 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 198x HIGHLAND AVE | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 4x4 | 6006173 | 2096415 | 37.7367055902603 | -122.421125584355 | (37.7367055902603, -122.421125584355) | 2 | 7 | 7 | 28859 | 2 | ||||
87418 | 256350 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3000X Sunset Blvd | 29 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
87613 | 61851 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1109 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | Permit Number 21890 | 6010288.8067389 | 2102753.58958513 | 37.7543411376679 | -122.407342102556 | (37.7543411376679, -122.407342102556) | 10 | 4 | 7 | 28859 | 19 | ||
88005 | 37257 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 4200 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | Permit Number 39805 | 6002396.16255256 | 2104159.25249428 | 37.7577558475859 | -122.434737351341 | (37.7577558475859, -122.434737351341) | 2 | 4 | 5 | 28862 | 3 | ||
88222 | 62786 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 154 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23142 | 6000618.91780925 | 2091744.38237049 | 37.723566485054 | -122.439993611308 | (37.723566485054, -122.439993611308) | 9 | 7 | 6 | 28861 | 25 | ||
88252 | 34045 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 298 Alabama St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37957 | 6008878.33665025 | 2106854.71470607 | 37.7655228486031 | -122.41250976517 | (37.7655228486031, -122.41250976517) | 8 | 4 | 7 | 28853 | 19 | ||
88458 | 58585 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 103 Grattan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/17/1979 12:00:00 AM | 3x3 | Permit Number 17781 | 5998130.9907032 | 2106502.59817932 | 37.7639470183873 | -122.44965687079 | (37.7639470183873, -122.44965687079) | 15 | 5 | 11 | 29492 | 9 | ||
89027 | 66553 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 160 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/10/1991 12:00:00 AM | Permit Number 29737 | 6005262.81634386 | 2104026.69666345 | 37.7575542112069 | -122.424813838267 | (37.7575542112069, -122.424813838267) | 2 | 4 | 5 | 28859 | 19 | ||
89908 | 67501 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 394 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/18/1993 12:00:00 AM | Permit Number 31030 | 5998815.69417134 | 2094405.78441062 | 37.7307712562319 | -122.446418383601 | (37.7307712562319, -122.446418383601) | 9 | 7 | 4 | 59 | 40 | ||
90014 | 111067 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 1800 10TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993175 | 2103134 | 37.7544129453028 | -122.466553158269 | (37.7544129453028, -122.466553158269) | 1 | 8 | 4 | 56 | 12 | ||||
90343 | 64694 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 114 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2009 12:00:00 AM | 3x3 | Permit Number 52635 | 6005548.53237974 | 2104042.55194245 | 37.7576138796481 | -122.423826843051 | (37.7576138796481, -122.423826843051) | 2 | 4 | 5 | 28859 | 19 | ||
90755 | 61047 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 104 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | Permit Number 32830 | 5999375.36037511 | 2093808.9050602 | 37.7291643148165 | -122.444440655825 | (37.7291643148165, -122.444440655825) | 9 | 7 | 4 | 28861 | 40 | ||
91360 | 110190 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 625 Holly Park Cir | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6006167.62160945 | 2096413.49051844 | 37.7367011423593 | -122.421144072665 | (37.7367011423593, -122.421144072665) | 2 | 7 | 7 | 28859 | 2 | |||||
92435 | 112343 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 28 WEST PORTAL AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993108 | 2098132 | 37.7406748633007 | -122.466421337063 | (37.7406748633007, -122.466421337063) | 1 | 8 | 4 | 59 | 40 | ||||
92548 | 122410 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 7 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
92761 | 110187 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 625 Holly Park Cir | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6006167.62160945 | 2096413.49051844 | 37.7367011423593 | -122.421144072665 | (37.7367011423593, -122.421144072665) | 2 | 7 | 7 | 28859 | 2 | |||||
93252 | 114797 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 103 Grattan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998130.9907032 | 2106502.59817932 | 37.7639470183873 | -122.44965687079 | (37.7639470183873, -122.44965687079) | 15 | 5 | 11 | 29492 | 9 | ||||
93937 | 33597 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 236 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/27/1996 12:00:00 AM | Permit Number 37705 | 6006736.00716085 | 2097819.44866051 | 37.7405936167848 | -122.419278618744 | (37.7405936167848, -122.419278618744) | 2 | 7 | 7 | 28859 | 2 | ||
94603 | 69203 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2837 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | Permit Number 33251 | 6008996.86818866 | 2101940.25932804 | 37.7520355221792 | -122.411752505652 | (37.7520355221792, -122.411752505652) | 2 | 4 | 7 | 28859 | 19 | ||
94622 | 37259 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 4200 20th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | Permit Number 39805 | 6002396.16255256 | 2104159.25249428 | 37.7577558475859 | -122.434737351341 | (37.7577558475859, -122.434737351341) | 2 | 4 | 5 | 28862 | 3 | ||
95918 | 58460 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 225 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1978 12:00:00 AM | 3x3 | Permit Number 17614 | 5998947.71410924 | 2106866.99110148 | 37.7649942410987 | -122.446858301796 | (37.7649942410987, -122.446858301796) | 15 | 5 | 11 | 29492 | 9 | ||
96498 | 35728 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 190 Dartmouth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/14/1998 12:00:00 AM | Permit Number 39007 | 6008565.46175199 | 2093223.89460892 | 37.7280780839519 | -122.412628258541 | (37.7280780839519, -122.412628258541) | 9 | 3 | 7 | 309 | 28 | ||
96878 | 34781 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1167 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38419 | 6008092.50780159 | 2101138.05263813 | 37.7497820686377 | -122.414823157313 | (37.7497820686377, -122.414823157313) | 2 | 4 | 7 | 28859 | 19 | ||
97197 | 52416 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 734 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/21/2005 12:00:00 AM | Permit Number 48535 | 6001832.35713287 | 2089688.63788093 | 37.717990874718 | -122.435651969168 | (37.717990874718, -122.435651969168) | 9 | 7 | 6 | 28861 | 5 | ||
98412 | 37252 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 4200 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | Permit Number 39805 | 6002396.16255256 | 2104159.25249428 | 37.7577558475859 | -122.434737351341 | (37.7577558475859, -122.434737351341) | 2 | 4 | 5 | 28862 | 3 | ||
98675 | 61701 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 92 Ramona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1984 12:00:00 AM | Permit Number 21700 | 6005188.20814874 | 2107280.97565933 | 37.7664854766417 | -122.425303435058 | (37.7664854766417, -122.425303435058) | 8 | 4 | 5 | 28853 | 19 | ||
98851 | 98677 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 199X Park St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6006189.1 | 2096374.1 | 37.7365941955595 | -122.421067016387 | (37.7365941955595, -122.421067016387) | 2 | 7 | 7 | 28859 | 2 | ||||
100174 | 35727 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 190 Dartmouth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/14/1998 12:00:00 AM | Permit Number 39007 | 6008565.46175199 | 2093223.89460892 | 37.7280780839519 | -122.412628258541 | (37.7280780839519, -122.412628258541) | 9 | 3 | 7 | 309 | 28 | ||
100593 | 33771 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 3101 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 37819 | 6009092.65010174 | 2104478.80438725 | 37.7590111673758 | -122.41160061802 | (37.7590111673758, -122.41160061802) | 2 | 4 | 7 | 28859 | 19 | ||||
102212 | 51620 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 419 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48838 | 6004007.75048659 | 2096078.78682851 | 37.7356601244905 | -122.428587833263 | (37.7356601244905, -122.428587833263) | 2 | 7 | 5 | 63 | 7 | |||
102355 | 96885 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2200X San Jose Ave | 10 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | 9 | 7 | 6 | 28861 | 25 | |||||
102801 | 122418 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 15 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
104224 | 61861 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2750 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | Permit Number 21901 | 6010264.84701821 | 2102255.53595422 | 37.7529722519848 | -122.407389851976 | (37.7529722519848, -122.407389851976) | 2 | 4 | 7 | 28859 | 19 | ||
104567 | 254405 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 321 Lexington St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | Width 3ft | 6006540.69106 | 2104208.04068 | 37.7581242333638 | -122.420407294379 | (37.7581242333638, -122.420407294379) | 2 | 4 | 7 | 28859 | 19 | ||||
105593 | 63619 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 801X Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/1987 12:00:00 AM | Permit Number 24261 | 5993268.63068404 | 2106608.32607844 | 37.7639579422382 | -122.466481867874 | (37.7639579422382, -122.466481867874) | 1 | 8 | 11 | 56 | 12 | |||
106232 | 62791 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 292 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23147 | 5999722.02733953 | 2091630.11110927 | 37.7232016241068 | -122.443085790223 | (37.7232016241068, -122.443085790223) | 9 | 7 | 6 | 28861 | 25 | ||
106590 | 122342 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 1250X Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994723 | 2112183 | 37.7793483429351 | -122.461855927769 | (37.7793483429351, -122.461855927769) | 11 | 6 | 2 | 54 | 11 | ||||
108150 | 35775 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 3523 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1998 12:00:00 AM | Permit Number 39031 | 6006108.80208441 | 2104899.31213539 | 37.7599979560694 | -122.421950059612 | (37.7599979560694, -122.421950059612) | 2 | 4 | 5 | 28859 | 19 | ||
108151 | 61696 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 537 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1984 12:00:00 AM | Permit Number 21695 | 6005240.89979754 | 2107791.37505015 | 37.7678898880098 | -122.425157505123 | (37.7678898880098, -122.425157505123) | 8 | 4 | 5 | 28853 | 19 | ||
110802 | 101266 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2126 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989175 | 2106519 | 37.7634756077712 | -122.480633814056 | (37.7634756077712, -122.480633814056) | 1 | 8 | 3 | 56 | 35 | ||||
111216 | 94496 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1600X Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2015 12:00:00 AM | 6x7 | 5998899.3 | 2109049 | 37.7709827197678 | -122.447182803026 | (37.7709827197678, -122.447182803026) | 15 | 5 | 11 | 29492 | 9 | |||
112331 | 103606 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 100X Buchanan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | ||||
112530 | 57913 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 29 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/09/1985 12:00:00 AM | Permit Number 16871 | 6006087.6140587 | 2100217.61014619 | 37.7471418876888 | -122.421690807656 | (37.7471418876888, -122.421690807656) | 2 | 7 | 5 | 28859 | 22 | ||
113820 | 65617 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 127 Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1990 12:00:00 AM | Permit Number 28524 | 6004220.92651357 | 2094058.36358609 | 37.7301245583022 | -122.42770689303 | (37.7301245583022, -122.42770689303) | 9 | 7 | 6 | 28861 | 5 | ||
113902 | 34533 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 395 Moultrie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/1997 12:00:00 AM | Permit Number 38241 | 6007729.86435225 | 2097252.7163141 | 37.7390934181522 | -122.415802113579 | (37.7390934181522, -122.415802113579) | 2 | 7 | 7 | 28859 | 2 | |||
114397 | 66457 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 441 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/1991 12:00:00 AM | Permit Number 29607 | 6004072.71052571 | 2110301.27189775 | 37.7747153911121 | -122.429377141824 | (37.7747153911121, -122.429377141824) | 7 | 9 | 11 | 29492 | 10 | ||
114572 | 62790 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 199 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23146 | 6000313.64252899 | 2091641.02456839 | 37.7232653049393 | -122.441041479459 | (37.7232653049393, -122.441041479459) | 9 | 7 | 6 | 28861 | 25 | ||
115029 | 61248 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1100 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1993 12:00:00 AM | Permit Number 21122 | 6007711.12009364 | 2119245.98740089 | 37.7994807139026 | -122.417425152198 | (37.7994807139026, -122.417425152198) | 5 | 1 | 1 | 308 | 32 | ||
115057 | 34423 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 136 Roanoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/17/2004 12:00:00 AM | Permit Number 47622 | 6003411.17015121 | 2096158.68200715 | 37.7358457184137 | -122.430656139914 | (37.7358457184137, -122.430656139914) | 2 | 7 | 5 | 63 | 7 | ||
115523 | 62784 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 137 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23140 | 6000712.17881294 | 2091681.24596218 | 37.7233984355119 | -122.439666701145 | (37.7233984355119, -122.439666701145) | 9 | 7 | 6 | 28861 | 25 | ||
116313 | 253374 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 99x Ogden Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007537 | 2096150 | 37.7360547576169 | -122.416390866966 | (37.7360547576169, -122.416390866966) | 2 | 7 | 7 | 28859 | 2 | ||||
117136 | 109995 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 501X Shotwell St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
117142 | 105876 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2X 27th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006029.15636 | 2100240.43464 | 37.7472012619439 | -122.421894571047 | (37.7472012619439, -122.421894571047) | 2 | 7 | 5 | 28859 | 22 | ||||
117331 | 32822 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 4251 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37180 | 6001518.68863728 | 2102305.7083643 | 37.7526166065877 | -122.437639271349 | (37.7526166065877, -122.437639271349) | 2 | 4 | 5 | 28862 | 22 | ||
117442 | 101265 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2034 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989459.10715 | 2106523.86109 | 37.7635054630097 | -122.47965154526 | (37.7635054630097, -122.47965154526) | 1 | 8 | 3 | 56 | 35 | ||||
118121 | 62788 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 190 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23144 | 6000370.84981794 | 2091713.58104778 | 37.7234677867045 | -122.440848927652 | (37.7234677867045, -122.440848927652) | 9 | 7 | 6 | 28861 | 25 | ||
119688 | 37554 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 4515#A 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1998 12:00:00 AM | Permit Number 39993 | 6000985.32111964 | 2105199.93654746 | 37.7605331136342 | -122.439691220259 | (37.7605331136342, -122.439691220259) | 2 | 4 | 5 | 28862 | 3 | ||
120471 | 61847 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1050 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | Permit Number 21886 | 6010217.4028677 | 2103099.43948978 | 37.7552867678032 | -122.407613419659 | (37.7552867678032, -122.407613419659) | 2 | 4 | 7 | 28859 | 19 | ||
121065 | 173749 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3299x 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006897 | 2106023 | 37.7631277620706 | -122.419303771356 | (37.7631277620706, -122.419303771356) | 8 | 4 | 7 | 28859 | 19 | ||||
121584 | 37255 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 4200 20th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | Permit Number 39805 | 6002396.16255256 | 2104159.25249428 | 37.7577558475859 | -122.434737351341 | (37.7577558475859, -122.434737351341) | 2 | 4 | 5 | 28862 | 3 | ||
122227 | 67018 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 400 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1992 12:00:00 AM | Permit Number 30374 | 5995620.26197767 | 2090586.55623665 | 37.7201015427641 | -122.457189254526 | (37.7201015427641, -122.457189254526) | 9 | 8 | 6 | 28861 | 24 | ||
122469 | 40057 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1311 Shafter Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | Permit Number 41291 | 6016435.57889801 | 2093012.13201176 | 37.7279351895138 | -122.385405998165 | (37.7279351895138, -122.385405998165) | 10 | 3 | 8 | 58 | 1 | ||
123182 | 121041 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2101 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006363 | 2118098 | 37.7962526868942 | -122.422008539697 | (37.7962526868942, -122.422008539697) | 13 | 9 | 10 | 28858 | 32 | ||||
123233 | 62782 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 131 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23138 | 6000753.3579224 | 2091686.36985433 | 37.7234148482869 | -122.439524720053 | (37.7234148482869, -122.439524720053) | 9 | 7 | 6 | 28861 | 25 | ||
124351 | 92632 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1680 Eddy St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/22/2009 12:00:00 AM | 3x3 | Permit Number 52927 | 6002403.9 | 2112682.2 | 37.7811582017665 | -122.435320233246 | (37.7811582017665, -122.435320233246) | 15 | 5 | 11 | 29490 | 41 | ||
126115 | 67341 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2522 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/1992 12:00:00 AM | Permit Number 30826 | 6011374.71716137 | 2101864.13092105 | 37.7519595969717 | -122.40352415268 | (37.7519595969717, -122.40352415268) | 10 | 4 | 8 | 28859 | 19 | ||
126150 | 64553 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 363 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1988 12:00:00 AM | Permit Number 25442 | 6000196.58694342 | 2110119.71759225 | 37.7739966786528 | -122.442772359687 | (37.7739966786528, -122.442772359687) | 15 | 5 | 11 | 29492 | 16 | ||
126405 | 65909 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1371 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1990 12:00:00 AM | Permit Number 28918 | 5994237.48770801 | 2106190.93763502 | 37.7628677616586 | -122.463100618919 | (37.7628677616586, -122.463100618919) | 1 | 5 | 11 | 56 | 12 | ||
126825 | 105873 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2X 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006029.15636 | 2100240.43464 | 37.7472012619439 | -122.421894571047 | (37.7472012619439, -122.421894571047) | 2 | 7 | 5 | 28859 | 22 | ||||
127158 | 63919 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 361 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/12/1988 12:00:00 AM | Permit Number 24639 | 6004187.93187702 | 2099820.2683611 | 37.745943572802 | -122.428231443138 | (37.745943572802, -122.428231443138) | 2 | 7 | 5 | 63 | 22 | ||
127812 | 59184 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 226 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/15/1988 12:00:00 AM | Permit Number 25686 | 6001313.09402132 | 2109464.81176347 | 37.7722620581627 | -122.438863239887 | (37.7722620581627, -122.438863239887) | 15 | 5 | 11 | 29492 | 9 | ||
128931 | 121622 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 298X Staples Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998141 | 2093851 | 37.7292093905587 | -122.448710954214 | (37.7292093905587, -122.448710954214) | 9 | 7 | 4 | 28861 | 40 | ||||
129881 | 107956 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2299X 25TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012136 | 2101880 | 37.7520456635859 | -122.400892625965 | (37.7520456635859, -122.400892625965) | 10 | 3 | 8 | 28856 | 29 | ||||
130256 | 122454 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 298 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6008878.33665025 | 2106854.71470607 | 37.7655228486031 | -122.41250976517 | (37.7655228486031, -122.41250976517) | 8 | 4 | 7 | 28853 | 19 | ||||
130273 | 51073 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 553 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2004 12:00:00 AM | Permit Number 47535 | 6002758.66460209 | 2103250.32502289 | 37.7552807236709 | -122.433418719485 | (37.7552807236709, -122.433418719485) | 2 | 4 | 5 | 28862 | 22 | |||
131250 | 92843 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 3440 25th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2009 12:00:00 AM | 3x3 | 6006883 | 2101475 | 37.7506392147773 | -122.419029591774 | (37.7506392147773, -122.419029591774) | 2 | 4 | 7 | 28859 | 19 | |||
131466 | 61866 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1337 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | Permit Number 21906 | 6010360.39666157 | 2101479.92866797 | 37.7508479533215 | -122.407004757895 | (37.7508479533215, -122.407004757895) | 10 | 4 | 7 | 28859 | 19 | ||
131561 | 58390 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 100 Foerster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/08/1994 12:00:00 AM | Permit Number 17524 | 5998126.0559233 | 2093810.47392433 | 37.7290972609549 | -122.448759699122 | (37.7290972609549, -122.448759699122) | 9 | 7 | 4 | 28861 | 40 | ||
131640 | 62783 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 136 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23139 | 6000734.28765752 | 2091758.59405485 | 37.7236120741182 | -122.439595817461 | (37.7236120741182, -122.439595817461) | 9 | 7 | 6 | 28861 | 25 |
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) );