trees
508 rows where qSpecies_id = 25 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
91533 | 32276 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 333 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 9 | 6x6 | Permit Number 37277 | 6014077.27946 | 2105468.87126 | 37.7620080221813 | -122.394430611806 | (37.7620080221813, -122.394430611806) | 10 | 3 | 8 | 28856 | 29 |
94859 | 192414 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 740 Rhode Island St | 3 | : | Tree | Private 2 | 16 | Width 3ft | 6011806.79674 | 2104934.73644 | 37.7604149289253 | -122.402245819308 | (37.7604149289253, -122.402245819308) | 10 | 3 | 8 | 28856 | 29 | |||
95128 | 67495 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1126 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/1992 12:00:00 AM | 18 | Permit Number 31020 | 6011901.71261 | 2103178.79248 | 37.7555987922788 | -122.401794116823 | (37.7555987922788, -122.401794116823) | 10 | 3 | 8 | 28856 | 29 | |
98073 | 192411 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 650 Rhode Island St | 3 | : | Tree | Private 2 | 5 | Width 3ft | 6011779.44506 | 2105347.31232 | 37.7615462436837 | -122.402369426605 | (37.7615462436837, -122.402369426605) | 10 | 3 | 8 | 28856 | 29 | |||
103330 | 192412 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 650 Rhode Island St | 4 | : | Tree | Private 2 | 5 | Width 3ft | 6011780.95507 | 2105331.83928 | 37.7615038424566 | -122.402363116082 | (37.7615038424566, -122.402363116082) | 10 | 3 | 8 | 28856 | 29 | |||
110175 | 192409 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 650 Rhode Island St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6011776.86645 | 2105375.28628 | 37.7616229099979 | -122.40238031202 | (37.7616229099979, -122.40238031202) | 10 | 3 | 8 | 28856 | 29 | |||
112771 | 51725 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1904 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2005 12:00:00 AM | 6 | Permit Number 48537 | 6012320.61849 | 2104715.41974 | 37.7598414015724 | -122.400453331067 | (37.7598414015724, -122.400453331067) | 10 | 3 | 8 | 28856 | 29 | ||
127888 | 67548 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1120 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 16 | Permit Number 31094 | 6011900.0943 | 2103205.59495 | 37.7556722956615 | -122.401801597389 | (37.7556722956615, -122.401801597389) | 10 | 3 | 8 | 28856 | 29 | |
128657 | 192413 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 650 Rhode Island St | 5 | : | Tree | Private 2 | 8 | Width 3ft | 6011782.001 | 2105308.50285 | 37.7614398242054 | -122.402357857724 | (37.7614398242054, -122.402357857724) | 10 | 3 | 8 | 28856 | 29 | |||
137812 | 192423 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 80 Carolina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6012208.34529 | 2107668.53767 | 37.7679437428368 | -122.401049131921 | (37.7679437428368, -122.401049131921) | 14 | 3 | 8 | 28856 | 20 | |||
141749 | 41187 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 380 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | 8 | Permit Number 46607 | 6013185.95339 | 2105307.79412 | 37.7615161505792 | -122.39750208615 | (37.7615161505792, -122.39750208615) | 10 | 3 | 8 | 28856 | 29 | |
157151 | 67546 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1139 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 19 | Permit Number 31092 | 6011964.43282 | 2103102.09088 | 37.7553916864972 | -122.401571818805 | (37.7553916864972, -122.401571818805) | 10 | 3 | 8 | 28856 | 29 | |
160751 | 192416 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1400 20th St | 3 | : | Tree | Private 2 | 9 | Width 3ft | 6013651.01145 | 2104790.61421 | 37.7601219711709 | -122.395857388933 | (37.7601219711709, -122.395857388933) | 10 | 3 | 8 | 28856 | 29 | |||
171102 | 32928 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1550 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2001 12:00:00 AM | 11 | Permit Number 44256 | 6012662.29085 | 2106602.53119 | 37.7650420397834 | -122.399404128919 | (37.7650420397834, -122.399404128919) | 14 | 3 | 8 | 28856 | 20 | |
172851 | 192410 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 650 Rhode Island St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6011779.10813 | 2105360.6424 | 37.7615828263046 | -122.402371529224 | (37.7615828263046, -122.402371529224) | 10 | 3 | 8 | 28856 | 29 | |||
178250 | 192407 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 862 Kansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011557.46585 | 2104307.68727 | 37.758679270636 | -122.403064037781 | (37.758679270636, -122.403064037781) | 10 | 3 | 8 | 28856 | 29 | |||
183084 | 32275 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 333 Mississippi St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1996 12:00:00 AM | 11 | 6x6 | Permit Number 36861 | 6014077.35334 | 2105478.23544 | 37.7620337382821 | -122.394431011984 | (37.7620337382821, -122.394431011984) | 10 | 3 | 8 | 28856 | 29 | |
184446 | 192406 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 718 De Haro St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | 6012081.21103 | 2105020.2958 | 37.7606651697825 | -122.401302754214 | (37.7606651697825, -122.401302754214) | 10 | 3 | 8 | 28856 | 29 | ||||
186605 | 32984 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 10X Sierra St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 5x9 | Permit Number 37296 | 6013812.07366772 | 2104214.5102771 | 37.7585490739971 | -122.395259990599 | (37.7585490739971, -122.395259990599) | 10 | 3 | 8 | 28856 | 29 | |
191383 | 66066 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1431 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/06/1990 12:00:00 AM | 11 | Permit Number 29106 | 6013625.10181 | 2104739.90322 | 37.7599812884231 | -122.395943445033 | (37.7599812884231, -122.395943445033) | 10 | 3 | 8 | 28856 | 29 | |
193185 | 119913 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 225 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013509 | 2106013 | 37.7634704729857 | -122.396434224989 | (37.7634704729857, -122.396434224989) | 14 | 3 | 8 | 28856 | 29 | ||||
34506 | 128874 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1270 Clay St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6008580.96851 | 2116980.96928 | 37.7933104368651 | -122.414254814618 | (37.7933104368651, -122.414254814618) | 5 | 1 | 10 | 28857 | 21 | |||
92905 | 128873 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1270 Clay St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6008597.37413 | 2116983.75832 | 37.7933190163979 | -122.414198247271 | (37.7933190163979, -122.414198247271) | 5 | 1 | 10 | 28857 | 21 | |||
182240 | 128872 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1270 Clay St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6008617.8933 | 2116985.80522 | 37.7933257892186 | -122.414127394165 | (37.7933257892186, -122.414127394165) | 5 | 1 | 10 | 28857 | 21 | |||
23417 | 128877 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1237x Robert C Levy Tunl | 6 | Median : Yard | Tree | DPW 1 | 3 | 6007635.08843 | 2118146.70213 | 37.796458073045 | -122.417610293998 | (37.796458073045, -122.417610293998) | 5 | 1 | 10 | 28858 | 32 | ||||
46881 | 128878 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2507 Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006675.76572 | 2119877.35226 | 37.8011559740396 | -122.421052707221 | (37.8011559740396, -122.421052707221) | 5 | 9 | 1 | 28858 | 32 | |||
121745 | 128876 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1237x Robert C Levy Tunl | 5 | Median : Yard | Tree | DPW 1 | 3 | 6007635.33447 | 2118142.36056 | 37.7964461660197 | -122.417609134775 | (37.7964461660197, -122.417609134775) | 5 | 1 | 10 | 28858 | 32 | ||||
172661 | 128875 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1237x Robert C Levy Tunl | 2 | Median : Yard | Tree | DPW 1 | 2 | 6007636.05536 | 2118136.67489 | 37.7964305951503 | -122.417606237154 | (37.7964305951503, -122.417606237154) | 5 | 1 | 10 | 28858 | 32 | ||||
42 | 221891 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 180 Bartlett St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006685.21207 | 2102724.39469 | 37.7540586268078 | -122.419802203518 | (37.7540586268078, -122.419802203518) | 2 | 4 | 7 | 28859 | 19 | |||
2212 | 225967 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3599 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005877.12817 | 2101963.64024 | 37.7519242145407 | -122.422542702196 | (37.7519242145407, -122.422542702196) | 2 | 4 | 5 | 28859 | 19 | |||
4619 | 84421 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 3450 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50587 | 6006545.62237249 | 2104975.62835635 | 37.7602321285391 | -122.420444723128 | (37.7602321285391, -122.420444723128) | 2 | 4 | 7 | 28859 | 19 | ||
4939 | 225906 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3749 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6005541.4535 | 2101364.78602 | 37.7502609561874 | -122.423660939909 | (37.7502609561874, -122.423660939909) | 2 | 4 | 5 | 28859 | 19 | |||
7174 | 225912 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1038 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6005698.15966 | 2102902.03106 | 37.7544907204839 | -122.423228299447 | (37.7544907204839, -122.423228299447) | 2 | 4 | 5 | 28859 | 19 | |||
7369 | 228945 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 25 Camp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/11/2020 12:00:00 AM | 3 | 3x3 | 6005777.88967 | 2106349.43528 | 37.7639609845445 | -122.423197607405 | (37.7639609845445, -122.423197607405) | 8 | 4 | 5 | 28859 | 19 | |
7887 | 152881 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3572 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005780.88013 | 2104928.47476 | 37.7600595303512 | -122.42308625784 | (37.7600595303512, -122.42308625784) | 2 | 4 | 5 | 28859 | 19 | |||
8075 | 225935 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1250 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/1994 12:00:00 AM | 10 | Width 3ft | Permit Number 33274 | 6008670.47689 | 2101262.07632 | 37.7501550682215 | -122.412833276033 | (37.7501550682215, -122.412833276033) | 2 | 4 | 7 | 28859 | 19 | |
10559 | 10061 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 490 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 2X2 | 6005517.65207 | 2106131.14555 | 37.7633469229371 | -122.424082167969 | (37.7633469229371, -122.424082167969) | 8 | 4 | 5 | 28859 | 19 | |||
14626 | 225965 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 81 Bernal Heights Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009494.27227 | 2098224.22173 | 37.7418599932559 | -122.409770124916 | (37.7418599932559, -122.409770124916) | 10 | 7 | 7 | 28859 | 2 | |||
19562 | 62935 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 108 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/05/1986 12:00:00 AM | Permit Number 23316 | 6007129.03577236 | 2097271.50045175 | 37.7391111999262 | -122.417880841628 | (37.7391111999262, -122.417880841628) | 2 | 7 | 7 | 28859 | 2 | ||
20477 | 39576 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 300 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 40993 | 6009738.16770437 | 2099629.76502916 | 37.7457329730731 | -122.409025961078 | (37.7457329730731, -122.409025961078) | 2 | 7 | 7 | 28859 | 2 | ||
21411 | 10091 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 708 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/1992 12:00:00 AM | 50 | 3X3 | 6005589.43333 | 2104821.82229 | 37.7597558823477 | -122.423740797923 | (37.7597558823477, -122.423740797923) | 2 | 4 | 5 | 28859 | 19 | ||
21840 | 67067 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 22 Newman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1992 12:00:00 AM | Permit Number 30456 | 6006871.92388007 | 2096801.0625203 | 37.7378050085566 | -122.418736466303 | (37.7378050085566, -122.418736466303) | 2 | 7 | 7 | 28859 | 2 | ||
24456 | 225946 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3557 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6005893.76776 | 2102550.85426 | 37.7535375074585 | -122.422526882211 | (37.7535375074585, -122.422526882211) | 2 | 4 | 5 | 28859 | 19 | |||
25081 | 225931 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 337 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6007076.3964 | 2096610.27498 | 37.737292658529 | -122.418015982652 | (37.737292658529, -122.418015982652) | 2 | 7 | 7 | 28859 | 2 | |||
27196 | 225957 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 38 Newman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007027 | 2096768 | 37.7377229562927 | -122.418197948284 | (37.7377229562927, -122.418197948284) | 2 | 7 | 7 | 28859 | 2 | |||
28366 | 36001 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 172 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39150 | 6007547.55752373 | 2100224.75713647 | 37.7472437298861 | -122.41664293336 | (37.7472437298861, -122.41664293336) | 2 | 7 | 7 | 28859 | 2 | ||
29333 | 225916 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3778 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005165.83624 | 2104308.70302 | 37.7583230563848 | -122.425169300823 | (37.7583230563848, -122.425169300823) | 2 | 4 | 5 | 28859 | 19 | |||
31110 | 48958 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1521 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2002 12:00:00 AM | Permit Number 46145 | 6009607.60540748 | 2100518.70293664 | 37.7481664860313 | -122.40954015648 | (37.7481664860313, -122.40954015648) | 2 | 7 | 7 | 28859 | 2 | |||
32183 | 225901 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1 Camp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6005825.23106 | 2106352.45228 | 37.7639719400684 | -122.423034081872 | (37.7639719400684, -122.423034081872) | 8 | 4 | 5 | 28859 | 19 | |||
33078 | 52211 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 3778 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/2005 12:00:00 AM | Permit Number 48395 | 6005137.28408737 | 2104311.29818782 | 37.758328569096 | -122.425268231472 | (37.758328569096, -122.425268231472) | 2 | 4 | 5 | 28859 | 19 | ||
33525 | 67084 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 200 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1992 12:00:00 AM | Permit Number 30482 | 6007092.73898781 | 2097018.14574656 | 37.738413501248 | -122.417988384197 | (37.738413501248, -122.417988384197) | 2 | 7 | 7 | 28859 | 2 | ||
34641 | 108168 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 2x FRANCONIA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6009949 | 2099997 | 37.74675312806 | -122.40832282803 | (37.74675312806, -122.40832282803) | 2 | 7 | 7 | 28859 | 2 | ||||
35950 | 10087 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 673 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4x4 | 6005642.33302 | 2105078.49447 | 37.7604636299235 | -122.423576092482 | (37.7604636299235, -122.423576092482) | 2 | 4 | 5 | 28859 | 19 | |||
38084 | 10079 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 614 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6005561.0033 | 2105378.47551 | 37.7612827162343 | -122.423878706238 | (37.7612827162343, -122.423878706238) | 2 | 4 | 5 | 28859 | 19 | |||
38898 | 225905 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3620 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6006092.03845 | 2100850.85024 | 37.7488808700704 | -122.421720479039 | (37.7488808700704, -122.421720479039) | 2 | 4 | 5 | 28859 | 19 | |||
41440 | 10174 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1038 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 2x2 | 6005692.3267338 | 2102916.9952862 | 37.7545314795937 | -122.423249534916 | (37.7545314795937, -122.423249534916) | 2 | 4 | 5 | 28859 | 19 | |||
41477 | 34073 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 2055 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37966 | 6008112.18575803 | 2106463.32400128 | 37.764405154005 | -122.415132009891 | (37.764405154005, -122.415132009891) | 8 | 4 | 7 | 28859 | 19 | ||
44035 | 117516 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 1115 YORK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6010054 | 2102576 | 37.7538403715297 | -122.408141603779 | (37.7538403715297, -122.408141603779) | 2 | 4 | 7 | 28859 | 19 | |||
50698 | 66557 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 3772 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/10/1991 12:00:00 AM | Permit Number 29741 | 6005175.23956871 | 2104313.40408574 | 37.7583364956152 | -122.425137114448 | (37.7583364956152, -122.425137114448) | 2 | 4 | 5 | 28859 | 19 | ||
51655 | 225914 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 611 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009855.21876 | 2105398.04081 | 37.7615779286091 | -122.409028144648 | (37.7615779286091, -122.409028144648) | 2 | 4 | 8 | 28859 | 19 | |||
52777 | 225919 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1683 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009340.70254 | 2099660.44823 | 37.745794948977 | -122.410402509267 | (37.745794948977, -122.410402509267) | 2 | 7 | 7 | 28859 | 2 | |||
53260 | 10131 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 899 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/04/1992 12:00:00 AM | 6 | 3X3 | 6005716.19449 | 2103799.35315 | 37.7569555760466 | -122.423229711377 | (37.7569555760466, -122.423229711377) | 2 | 4 | 5 | 28859 | 19 | ||
55505 | 225970 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2846 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 4x4 | 6009214.74518 | 2103362.9385 | 37.7559541000213 | -122.411099534231 | (37.7559541000213, -122.411099534231) | 2 | 4 | 7 | 28859 | 19 | |||
57051 | 225959 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 20 Newman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/15/2005 12:00:00 AM | 12 | Width 3ft | Permit Number 48238 | 6006979.14621 | 2096796.63822 | 37.7377988968125 | -122.418365432231 | (37.7377988968125, -122.418365432231) | 2 | 7 | 7 | 28859 | 2 | |
58299 | 225971 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3446 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006565.68979 | 2104973.14116 | 37.7602264301236 | -122.420375142719 | (37.7602264301236, -122.420375142719) | 2 | 4 | 7 | 28859 | 19 | |||
59021 | 221893 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3164 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008601.79804 | 2101572.78068 | 37.7510043375848 | -122.413092739446 | (37.7510043375848, -122.413092739446) | 2 | 4 | 7 | 28859 | 19 | |||
60771 | 36002 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 183 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39151 | 6007567.43623945 | 2100291.02417946 | 37.747426802297 | -122.416578887563 | (37.747426802297, -122.416578887563) | 2 | 7 | 7 | 28859 | 2 | ||
63701 | 27660 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1360 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3x3 | 6005798.59708 | 2101052.03016 | 37.7494167122272 | -122.422749495892 | (37.7494167122272, -122.422749495892) | 2 | 4 | 5 | 28859 | 19 | |||
63945 | 225932 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 557 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6009854.01904 | 2098898.01508 | 37.743730236853 | -122.408573752301 | (37.743730236853, -122.408573752301) | 2 | 7 | 7 | 28859 | 2 | |||
64828 | 225913 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 699 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6005644.87336 | 2104976.18097 | 37.760182844481 | -122.423560032385 | (37.760182844481, -122.423560032385) | 2 | 4 | 5 | 28859 | 19 | |||
67422 | 225911 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 886 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6005643.7507 | 2103817.72642 | 37.7570019361197 | -122.42348155573 | (37.7570019361197, -122.42348155573) | 2 | 4 | 5 | 28859 | 19 | |||
72350 | 225922 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 22 Franconia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009935.78986 | 2099989.59836 | 37.7467320650326 | -122.408367985612 | (37.7467320650326, -122.408367985612) | 2 | 7 | 7 | 28859 | 2 | |||
72540 | 225944 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3386 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005759.14871 | 2103755.79247 | 37.7568383926032 | -122.423078063208 | (37.7568383926032, -122.423078063208) | 2 | 4 | 5 | 28859 | 19 | |||
72787 | 225929 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 56 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008145.90084 | 2098385.005 | 37.7422258131659 | -122.414443742389 | (37.7422258131659, -122.414443742389) | 2 | 7 | 7 | 28859 | 2 | |||
74513 | 10124 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 877 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6005714.7162163 | 2103867.2939475 | 37.7571420422058 | -122.42323965319 | (37.7571420422058, -122.42323965319) | 2 | 4 | 5 | 28859 | 19 | |||
75291 | 421 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 685X Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6005653.198434 | 2104994.6037312 | 37.7602338989595 | -122.423532549649 | (37.7602338989595, -122.423532549649) | 2 | 4 | 5 | 28859 | 19 | |||
76434 | 67080 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 343 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1992 12:00:00 AM | Permit Number 30477 | 6007097.80000141 | 2096683.93673196 | 37.7374961220492 | -122.417947200602 | (37.7374961220492, -122.417947200602) | 2 | 7 | 7 | 28859 | 2 | ||
76873 | 34040 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 2741 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37955 | 6008443.32721054 | 2106790.24036099 | 37.7653213944342 | -122.414009808345 | (37.7653213944342, -122.414009808345) | 8 | 4 | 7 | 28859 | 19 | ||
83523 | 221894 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3164 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008618.93304 | 2101573.97925 | 37.7510085904948 | -122.413033569448 | (37.7510085904948, -122.413033569448) | 2 | 4 | 7 | 28859 | 19 | |||
83630 | 225921 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 300 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009716.79458 | 2099617.55194 | 37.7456982412969 | -122.40909900492 | (37.7456982412969, -122.40909900492) | 2 | 7 | 7 | 28859 | 2 | |||
85249 | 225908 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3772 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6005343.316 | 2101393.98229 | 37.7503299359862 | -122.424348189214 | (37.7503299359862, -122.424348189214) | 2 | 4 | 5 | 28859 | 19 | |||
85822 | 48957 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1521 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2002 12:00:00 AM | Permit Number 46145 | 6009607.60540748 | 2100518.70293664 | 37.7481664860313 | -122.40954015648 | (37.7481664860313, -122.40954015648) | 2 | 7 | 7 | 28859 | 2 | |||
87206 | 10130 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 899 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/04/1992 12:00:00 AM | 6 | 3X3 | 6005717.32362 | 2103778.46659 | 37.7568982901448 | -122.423224321766 | (37.7568982901448, -122.423224321766) | 2 | 4 | 5 | 28859 | 19 | ||
89804 | 108167 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 2x FRANCONIA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6009908 | 2100009 | 37.7467837814289 | -122.40846544894 | (37.7467837814289, -122.40846544894) | 2 | 7 | 7 | 28859 | 2 | ||||
89880 | 225934 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1256 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008672.01096 | 2101240.80305 | 37.7500967426882 | -122.412826467282 | (37.7500967426882, -122.412826467282) | 2 | 4 | 7 | 28859 | 19 | |||
90032 | 10155 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 988 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2x2 | 6005676.86794 | 2103220.79798 | 37.7553647787894 | -122.423324590769 | (37.7553647787894, -122.423324590769) | 2 | 4 | 5 | 28859 | 19 | |||
91917 | 34747 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 2747 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38395 | 6008968.42681544 | 2102467.18370323 | 37.7534807427404 | -122.411888091902 | (37.7534807427404, -122.411888091902) | 2 | 4 | 7 | 28859 | 19 | ||
92806 | 69223 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1256 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | Permit Number 33275 | 6008667.10840058 | 2101226.16540452 | 37.7500562758063 | -122.412842385916 | (37.7500562758063, -122.412842385916) | 2 | 4 | 7 | 28859 | 19 | ||
94079 | 10152 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 981 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005742.33218 | 2103287.18966 | 37.7555507693625 | -122.423102914188 | (37.7555507693625, -122.423102914188) | 2 | 4 | 5 | 28859 | 19 | |||
94309 | 69219 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1232 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | Permit Number 33271 | 6008659.77445957 | 2101360.31284296 | 37.7504242029934 | -122.412877230419 | (37.7504242029934, -122.412877230419) | 2 | 4 | 7 | 28859 | 19 | ||
96105 | 10071 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 563 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2x3 | 6005607.25335 | 2105721.20389 | 37.7622263784702 | -122.423743116346 | (37.7622263784702, -122.423743116346) | 8 | 4 | 5 | 28859 | 19 | |||
96140 | 225960 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 202 Jarboe Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008021.65482 | 2096973.39205 | 37.7383428544349 | -122.414773468947 | (37.7383428544349, -122.414773468947) | 2 | 7 | 7 | 28859 | 2 | |||
96340 | 225941 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2741 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008479.57157 | 2106789.99356 | 37.7653227523561 | -122.413884429728 | (37.7653227523561, -122.413884429728) | 8 | 4 | 7 | 28859 | 19 | |||
96869 | 239616 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 998 Alabama St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009140.95631 | 2103384.46491 | 37.756009068389 | -122.411356242114 | (37.756009068389, -122.411356242114) | 2 | 4 | 7 | 28859 | 19 | |||
99644 | 225943 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3386 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005777.63765 | 2103756.42358 | 37.75684116881 | -122.423014166371 | (37.75684116881, -122.423014166371) | 2 | 4 | 5 | 28859 | 19 | |||
100531 | 225930 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 269 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006712.58135 | 2098072.63553 | 37.7412874920181 | -122.419377573329 | (37.7412874920181, -122.419377573329) | 2 | 7 | 7 | 28859 | 2 | |||
101930 | 225902 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 44 Camp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6005679.36245 | 2106382.2556 | 37.7640455405875 | -122.423540717652 | (37.7640455405875, -122.423540717652) | 8 | 4 | 5 | 28859 | 19 | |||
105362 | 34074 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 2055 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37966 | 6008112.18575803 | 2106463.32400128 | 37.764405154005 | -122.415132009891 | (37.764405154005, -122.415132009891) | 8 | 4 | 7 | 28859 | 19 | ||
108269 | 26529 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2747 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3x3 | 6008970.13177 | 2102467.22828 | 37.75348096079 | -122.411882198931 | (37.75348096079, -122.411882198931) | 2 | 4 | 7 | 28859 | 19 | |||
108389 | 225962 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 200 Jarboe Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007966.25264 | 2096976.90694 | 37.738349392503 | -122.414965271836 | (37.738349392503, -122.414965271836) | 2 | 7 | 7 | 28859 | 2 |
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) );