trees
6,344 rows where qSpecies_id = 19 sorted by qAddress
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
382 | 34903 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1997 12:00:00 AM | Permit Number 38505 | ||||||||||||||
1118 | 36625 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
2140 | 46192 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
3497 | 46195 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
4058 | 34900 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1997 12:00:00 AM | Permit Number 38505 | ||||||||||||||
4969 | 36620 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
8285 | 36624 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
8825 | 36621 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
8963 | 36618 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
9853 | 46194 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
10529 | 46191 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
10686 | 34901 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1997 12:00:00 AM | Permit Number 38505 | ||||||||||||||
11435 | 36622 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
11841 | 34905 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1997 12:00:00 AM | Permit Number 38505 | ||||||||||||||
12228 | 34902 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1997 12:00:00 AM | Permit Number 38505 | ||||||||||||||
13013 | 46193 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
13886 | 34906 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1997 12:00:00 AM | Permit Number 38505 | ||||||||||||||
14106 | 36623 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
14123 | 36635 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
15275 | 36627 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
15484 | 36610 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
17350 | 34904 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1997 12:00:00 AM | Permit Number 38505 | ||||||||||||||
17701 | 46199 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
19128 | 36616 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
19157 | 46202 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
42848 | 34235 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/1997 12:00:00 AM | Permit Number 38048 | 6016895.91787464 | 2103845.69851644 | 37.7577074184489 | -122.384568876102 | (37.7577074184489, -122.384568876102) | 10 | 3 | 8 | 28856 | 29 | ||||
3531 | 39973 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 0 Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 41235 | ||||||||||||||
3892 | 39976 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 0 Steiner St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 41235 | ||||||||||||||
10274 | 39974 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 0 Steiner St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 41235 | ||||||||||||||
177213 | 123900 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1 11th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 10ft | 5992382.46379 | 2114901.63457 | 37.7866779493995 | -122.470150767402 | (37.7866779493995, -122.470150767402) | 11 | 6 | 1 | 54 | 11 | |||
25931 | 193290 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1 Ardath Ct | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017463.55131 | 2095291.12818 | 37.734249684563 | -122.382010696451 | (37.734249684563, -122.382010696451) | 10 | 3 | 8 | 58 | 1 | |||
70092 | 193288 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1 Ardath Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017236.66649 | 2095426.16645 | 37.7346079402901 | -122.382804511829 | (37.7346079402901, -122.382804511829) | 10 | 3 | 8 | 58 | 1 | |||
163466 | 193289 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1 Ardath Ct | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017396.94192 | 2095313.39296 | 37.7343071404432 | -122.382242537166 | (37.7343071404432, -122.382242537166) | 10 | 3 | 8 | 58 | 1 | |||
187988 | 193291 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1 Ardath Ct | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017457.59567 | 2095286.93969 | 37.7342378548914 | -122.382030995952 | (37.7342378548914, -122.382030995952) | 10 | 3 | 8 | 58 | 1 | |||
151045 | 245061 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1 Baker St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6000833.6361 | 2109001.0122 | 37.7709612910265 | -122.44048845278 | (37.7709612910265, -122.44048845278) | 15 | 5 | 11 | 29492 | 9 | |||
63765 | 254732 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 1 Bernice St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008554 | 2108538 | 37.7701265512244 | -122.41375065145 | (37.7701265512244, -122.41375065145) | 8 | 2 | 9 | 28853 | 19 | ||||
75528 | 254731 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 1 Bernice St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008554 | 2108538 | 37.7701265512244 | -122.41375065145 | (37.7701265512244, -122.41375065145) | 8 | 2 | 9 | 28853 | 19 | ||||
138835 | 254730 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 1 Bernice St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008554 | 2108538 | 37.7701265512244 | -122.41375065145 | (37.7701265512244, -122.41375065145) | 8 | 2 | 9 | 28853 | 19 | ||||
45640 | 201340 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1 Bitting Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6012714.10336 | 2092626.08619 | 37.7266685912663 | -122.398244248089 | (37.7266685912663, -122.398244248089) | 10 | 3 | 8 | 58 | 1 | ||||
77963 | 201342 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1 Bitting Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6012732.15495 | 2092620.25423 | 37.7266535833942 | -122.398181434938 | (37.7266535833942, -122.398181434938) | 10 | 3 | 8 | 58 | 1 | ||||
91646 | 229657 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1 Bradford St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6009643.76186 | 2098683.06501 | 37.7431282531763 | -122.409285608865 | (37.7431282531763, -122.409285608865) | 10 | 7 | 7 | 28859 | 2 | |||
141321 | 230854 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1 Castro St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002226.53145 | 2107879.97904 | 37.7679624253424 | -122.435590183343 | (37.7679624253424, -122.435590183343) | 15 | 5 | 5 | 28862 | 3 | |||
132233 | 60992 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1 College Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31624 | 6004216.5458966 | 2095763.6003461 | 37.7348065076562 | -122.42784349559 | (37.7348065076562, -122.42784349559) | 2 | 7 | 5 | 28861 | 2 | ||
132973 | 230558 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1 College Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004244.19102 | 2095797.65599 | 37.7349015806344 | -122.427750342524 | (37.7349015806344, -122.427750342524) | 2 | 7 | 5 | 28861 | 2 | |||
167496 | 202086 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1 Gould St | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 6012832.48602 | 2091118.85258 | 37.7225366273418 | -122.397729326873 | (37.7225366273418, -122.397729326873) | 10 | 3 | 8 | 58 | 1 | ||||
121042 | 192961 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1 Missouri St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6013428.8993 | 2106971.39143 | 37.7660975461955 | -122.396778462849 | (37.7660975461955, -122.396778462849) | 14 | 3 | 8 | 28856 | 20 | |||
122730 | 192963 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1 Missouri St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6013426.6142 | 2107013.53276 | 37.7662131297585 | -122.396789321282 | (37.7662131297585, -122.396789321282) | 14 | 3 | 8 | 28856 | 20 | |||
139189 | 192964 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1 Missouri St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6013426.74121 | 2107037.58883 | 37.7662791894618 | -122.396790568631 | (37.7662791894618, -122.396790568631) | 14 | 3 | 8 | 28856 | 20 | |||
162508 | 192960 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6013429.15967 | 2106956.37648 | 37.7660563329628 | -122.396776509533 | (37.7660563329628, -122.396776509533) | 14 | 3 | 8 | 28856 | 20 | |||
183024 | 192962 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1 Missouri St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6013428.91312 | 2106990.27483 | 37.7661493965951 | -122.39677973902 | (37.7661493965951, -122.39677973902) | 14 | 3 | 8 | 28856 | 20 | |||
21701 | 113690 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 1 WALTER U LUM PL | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010972 | 2117336 | 37.7944192831765 | -122.406006661324 | (37.7944192831765, -122.406006661324) | 3 | 1 | 10 | 28857 | 4 | ||||
149183 | 113691 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 1 WALTER U LUM PL | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010972 | 2117336 | 37.7944192831765 | -122.406006661324 | (37.7944192831765, -122.406006661324) | 3 | 1 | 10 | 28857 | 4 | ||||
172725 | 143502 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1 Walter U Lum Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6011053.9105 | 2117332.9615 | 37.7944155210534 | -122.405723025535 | (37.7944155210534, -122.405723025535) | 3 | 1 | 10 | 28857 | 4 | |||
45867 | 107185 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 10 Florence St | 1 | Front Yard : Cutout | Tree | Private 2 | Permit Number 773363 | 6008515.42073 | 2118375.20615 | 37.7971349853662 | -122.41458032272 | (37.7971349853662, -122.41458032272) | 5 | 1 | 10 | 308 | 21 | ||||
8426 | 177304 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 10 Ruth St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 2ft | 6001647.41554 | 2091598.69121 | 37.723224945954 | -122.436427860461 | (37.723224945954, -122.436427860461) | 9 | 7 | 6 | 28861 | 25 | |||
75615 | 177303 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 10 Ruth St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 2ft | 6001666.9736 | 2091588.58341 | 37.7231983035377 | -122.436359529079 | (37.7231983035377, -122.436359529079) | 9 | 7 | 6 | 28861 | 25 | |||
34953 | 193206 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 10 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6014561.27051 | 2112829.17177 | 37.7822446640061 | -122.393271731912 | (37.7822446640061, -122.393271731912) | 6 | 2 | 9 | 28856 | 6 | |||
72138 | 193207 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 10 South Park | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6014550.69631 | 2112820.94102 | 37.7822214767738 | -122.393307738057 | (37.7822214767738, -122.393307738057) | 6 | 2 | 9 | 28856 | 6 | |||
65489 | 230266 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 10 Wilder St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002981.00853 | 2095469.58645 | 37.7339292399232 | -122.432094183112 | (37.7339292399232, -122.432094183112) | 2 | 7 | 5 | 63 | 7 | |||
92985 | 65368 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 10 Wilder St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1989 12:00:00 AM | Permit Number 28206 | 6003053.48376145 | 2095454.29402477 | 37.7338913591524 | -122.43184252277 | (37.7338913591524, -122.43184252277) | 2 | 7 | 5 | 63 | 7 | ||
3365 | 46090 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 100 19th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2001 12:00:00 AM | Permit Number 44465 | 5989930.31260509 | 2114699.05014668 | 37.7859796419382 | -122.478619707642 | (37.7859796419382, -122.478619707642) | 11 | 6 | 2 | 55 | 26 | |||
36841 | 46092 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2001 12:00:00 AM | 2 | Permit Number 44465 | 5989927.3729 | 2114632.55981 | 37.7857969074812 | -122.478625013843 | (37.7857969074812, -122.478625013843) | 11 | 6 | 2 | 55 | 26 | ||
72023 | 46091 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 100 19th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2001 12:00:00 AM | Permit Number 44465 | 5989930.31260509 | 2114699.05014668 | 37.7859796419382 | -122.478619707642 | (37.7859796419382, -122.478619707642) | 11 | 6 | 2 | 55 | 26 | |||
11668 | 140846 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100 COMMONWEALTH AVE | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5996563.342 | 2113760.0078 | 37.7837841621477 | -122.455603469395 | (37.7837841621477, -122.455603469395) | 11 | 6 | 1 | 54 | 31 | |||
184067 | 140847 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100 COMMONWEALTH AVE | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5996563.0036 | 2113772.191 | 37.7838175945574 | -122.455605521023 | (37.7838175945574, -122.455605521023) | 11 | 6 | 1 | 54 | 31 | |||
31963 | 33498 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 100 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37606 | 6006683.58482984 | 2099106.89574168 | 37.7441257054073 | -122.419551194294 | (37.7441257054073, -122.419551194294) | 2 | 7 | 7 | 28859 | 2 | |||
10670 | 258171 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100 Dartmouth St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6008455.21796 | 2093605.41918 | 37.7291194808141 | -122.413036341511 | (37.7291194808141, -122.413036341511) | 9 | 3 | 7 | 309 | 28 | |||
165376 | 52505 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 100 Delano Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48612 | 6000459.21212403 | 2092796.53249414 | 37.7264463554341 | -122.440621115176 | (37.7264463554341, -122.440621115176) | 9 | 7 | 6 | 28861 | 25 | ||
170396 | 52504 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 100 Delano Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48612 | 6000459.21212403 | 2092796.53249414 | 37.7264463554341 | -122.440621115176 | (37.7264463554341, -122.440621115176) | 9 | 7 | 6 | 28861 | 25 | ||
170820 | 52503 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 100 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48612 | 6000459.21212403 | 2092796.53249414 | 37.7264463554341 | -122.440621115176 | (37.7264463554341, -122.440621115176) | 9 | 7 | 6 | 28861 | 25 | ||
85497 | 230739 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6001694.43925 | 2105191.75415 | 37.7605509828717 | -122.437238123552 | (37.7605509828717, -122.437238123552) | 2 | 4 | 5 | 28862 | 3 | |||
172586 | 230738 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001693.29132 | 2105215.82364 | 37.7606170065784 | -122.437243817162 | (37.7606170065784, -122.437243817162) | 2 | 4 | 5 | 28862 | 3 | |||
160272 | 208602 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100 Edgewood Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 16 | Width 4ft | 5996618.83287 | 2106426.3084 | 37.7636509189712 | -122.454881430853 | (37.7636509189712, -122.454881430853) | 15 | 5 | 11 | 29492 | 12 | |||
104336 | 230116 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100 Ellert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007159.83351 | 2097032.66206 | 37.7384571357853 | -122.417757432077 | (37.7384571357853, -122.417757432077) | 2 | 7 | 7 | 28859 | 2 | |||
80497 | 12527 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3x3 | 5995151.97418 | 2114942.29811 | 37.7869493206202 | -122.460571940769 | (37.7869493206202, -122.460571940769) | 11 | 6 | 1 | 54 | 11 | |||
24130 | 130570 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100 Maple St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5996597.05315 | 2115854.8899 | 37.7895380830687 | -122.455638313754 | (37.7895380830687, -122.455638313754) | 11 | 6 | 1 | 54 | 31 | |||
73442 | 130568 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100 Maple St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5996607.55895 | 2115808.58588 | 37.7894115475449 | -122.455598616792 | (37.7894115475449, -122.455598616792) | 11 | 6 | 1 | 54 | 31 | |||
112750 | 130566 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100 Maple St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5996609.34051 | 2115762.66793 | 37.7892855714198 | -122.45558913254 | (37.7892855714198, -122.45558913254) | 11 | 6 | 1 | 54 | 31 | |||
114616 | 130567 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100 Maple St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5996608.23291 | 2115784.90382 | 37.7893465616436 | -122.455594572544 | (37.7893465616436, -122.455594572544) | 11 | 6 | 1 | 54 | 31 | |||
146810 | 130571 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100 Maple St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5996592.08363 | 2115880.31383 | 37.7896076051683 | -122.455657346114 | (37.7896076051683, -122.455657346114) | 11 | 6 | 1 | 54 | 31 | |||
179445 | 130569 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100 Maple St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996602.67631 | 2115833.52881 | 37.7894797539414 | -122.455617313707 | (37.7894797539414, -122.455617313707) | 11 | 6 | 1 | 54 | 31 | |||
192003 | 130565 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100 Maple St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5996612.8231 | 2115714.26414 | 37.7891528674534 | -122.455573583256 | (37.7891528674534, -122.455573583256) | 11 | 6 | 1 | 54 | 31 | |||
133600 | 91383 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 100 SAN JOSE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006168 | 2102576 | 37.7536220187283 | -122.421580311855 | (37.7536220187283, -122.421580311855) | 2 | 4 | 5 | 28859 | 19 | |||
9744 | 19850 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100 STAIRWAY27 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 10ST | |||||||||||||
1398 | 20032 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100 STAIRWAY51 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3ST | |||||||||||||
178526 | 230130 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006162.21511 | 2102529.99038 | 37.7534953607276 | -122.42159704979 | (37.7534953607276, -122.42159704979) | 2 | 4 | 5 | 28859 | 19 | |||
76896 | 193108 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100 Thornton Ave | 2 | : | Tree | Private 2 | 4 | Width 3ft | 6014279.85245 | 2094099.91382 | 37.7308025157065 | -122.392934532911 | (37.7308025157065, -122.392934532911) | 10 | 3 | 8 | 58 | 1 | |||
172424 | 193107 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100 Thornton Ave | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6014292.79104 | 2094097.73703 | 37.7307972573678 | -122.392889649557 | (37.7307972573678, -122.392889649557) | 10 | 3 | 8 | 58 | 1 | |||
102867 | 130905 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1000 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008670.58834 | 2116008.76921 | 37.7906460469339 | -122.413875919432 | (37.7906460469339, -122.413875919432) | 5 | 1 | 10 | 28857 | 21 | |||
28318 | 103825 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1000 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006956.54225 | 2114398.79268 | 37.7861290373663 | -122.41969215528 | (37.7861290373663, -122.41969215528) | 13 | 9 | 9 | 28858 | 36 | ||
79894 | 130882 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1000 Polk St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6006947.79281 | 2114448.21135 | 37.7862642360477 | -122.419725933829 | (37.7862642360477, -122.419725933829) | 13 | 9 | 9 | 28858 | 36 | |||
125347 | 103824 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1000 Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006951.91038 | 2114418.64606 | 37.7861832889612 | -122.419709589538 | (37.7861832889612, -122.419709589538) | 13 | 9 | 9 | 28858 | 36 | ||
168428 | 103823 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1000 Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006948.13322 | 2114434.09135 | 37.7862254851663 | -122.419723753855 | (37.7862254851663, -122.419723753855) | 13 | 9 | 9 | 28858 | 36 | ||
94907 | 230011 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1000 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5997298.06475 | 2106860.60293 | 37.7648823210859 | -122.452563536173 | (37.7648823210859, -122.452563536173) | 15 | 5 | 11 | 29492 | 9 | |||
181969 | 4711 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1000 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 3X3 | 6008439.857 | 2120847.9647 | 37.8039203178058 | -122.415016905088 | (37.8039203178058, -122.415016905088) | 5 | 1 | 10 | 308 | 23 | |||
73205 | 229402 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1000 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009946.62507 | 2103338.81408 | 37.7559288758449 | -122.408566739378 | (37.7559288758449, -122.408566739378) | 2 | 4 | 7 | 28859 | 19 | |||
121382 | 229403 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1000 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009946.56186 | 2103326.03812 | 37.7558937923786 | -122.408566056777 | (37.7558937923786, -122.408566056777) | 2 | 4 | 7 | 28859 | 19 | |||
138102 | 229404 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1000 York St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009947.44128 | 2103311.08092 | 37.7558527725071 | -122.408561960379 | (37.7558527725071, -122.408561960379) | 2 | 4 | 7 | 28859 | 19 | |||
46457 | 46114 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1001 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2001 12:00:00 AM | Permit Number 44473 | 5998803.64501261 | 2106479.79215495 | 37.7639228586403 | -122.447328728164 | (37.7639228586403, -122.447328728164) | 15 | 5 | 11 | 29492 | 9 | |||
188655 | 229597 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1001 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5998810.79476 | 2106435.70161 | 37.7638022056215 | -122.447300825876 | (37.7638022056215, -122.447300825876) | 15 | 5 | 11 | 29492 | 9 |
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) );