Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, PlantType, qCareAssistant, DBH
qLegalStatus ✖
qCaretaker ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
47177 | 47177 | 177448 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1022 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6001291.58576 | 2086844.2282099999 | 37.7101500273691 | -122.437317616421 | (37.7101500273691, -122.437317616421) | |||
165176 | 165176 | 114986 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1028 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2015 12:00:00 AM | 1 | Permit Number 770492 | 6001259.4385 | 2086848.65908 | 37.7101603659725 | -122.437429040618 | (37.7101603659725, -122.437429040618) | ||
109947 | 109947 | 120109 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 555 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2016 12:00:00 AM | 3 | 3x3 | 5997970.0 | 2087042.0 | 37.7105036758619 | -122.44881186315901 | (37.7105036758619, -122.448811863159) | ||
28727 | 28727 | 177449 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 324 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001907.3749400005 | 2086972.3844599999 | 37.7105369040276 | -122.43519848992901 | (37.7105369040276, -122.435198489929) | |||
97637 | 97637 | 83771 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 924 Rutland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50981 | 6009720.30690757 | 2087000.33290755 | 37.7110542204407 | -122.408197148869 | (37.7110542204407, -122.408197148869) | |
43609 | 43609 | 177447 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 762 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002442.748380001 | 2087164.23323 | 37.711094066412294 | -122.433361825211 | (37.7110940664123, -122.433361825211) | |||
156758 | 156758 | 69419 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 168 Seville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 9 | Permit Number 33524 | 6001328.44378 | 2087365.87339 | 37.7115844451475 | -122.437227553813 | (37.7115844451475, -122.437227553813) | |
47863 | 47863 | 177393 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1657 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 6006855.18138 | 2087491.9955900002 | 37.7122433757141 | -122.41813457086599 | (37.7122433757141, -122.418134570866) | |||
60469 | 60469 | 80737 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 186 Allison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2003 12:00:00 AM | 1 | 6000043.5525400005 | 2087718.3093599998 | 37.7124790304587 | -122.44169374357 | (37.7124790304587, -122.44169374357) | ||
131019 | 131019 | 177392 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1654 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 6006773.14965 | 2087593.0806 | 37.7125163163365 | -122.41842526053101 | (37.7125163163365, -122.418425260531) | |||
51443 | 51443 | 105800 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 207 Raymond Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/2014 12:00:00 AM | 3 | Permit Number 769635 | 6010004.04754 | 2087785.0667299998 | 37.713224823850005 | -122.407271751589 | (37.71322482385, -122.407271751589) | ||
53993 | 53993 | 177425 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1764 Cayuga Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 8ft | 5997936.35064 | 2088551.93116 | 37.7146476772225 | -122.44903686276301 | (37.7146476772225, -122.449036862763) | |||
82889 | 82889 | 114908 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 281 LOBOS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994225.0 | 2088676.0 | 37.714775380268996 | -122.461873702271 | (37.714775380269, -122.461873702271) | ||||
146559 | 146559 | 208848 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 281 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5994210.24416 | 2088699.7294 | 37.7148396860693 | -122.46192642387501 | (37.7148396860693, -122.461926423875) | |||
69630 | 69630 | 177417 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1x Rolph St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 4ft | 6000503.4246 | 2088653.73075 | 37.7150736797726 | -122.440171325345 | (37.7150736797726, -122.440171325345) | |||
123330 | 123330 | 84225 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1361 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50686 | 6011917.47723073 | 2088615.29524593 | 37.7156113688947 | -122.400716532679 | (37.7156113688947, -122.400716532679) | ||
45146 | 45146 | 177401 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 263 Dublin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003956.36283 | 2088919.05641 | 37.7159981864394 | -122.42825539008601 | (37.7159981864394, -122.428255390086) | |||
49439 | 49439 | 83995 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 254 Dublin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51873 | 6003949.050969999 | 2088987.2537599998 | 37.7161850277922 | -122.428285520976 | (37.7161850277922, -122.428285520976) | |
66636 | 66636 | 82354 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 254 Dublin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50649 | 6004015.90676212 | 2089097.25184538 | 37.716490841330106 | -122.428062269463 | (37.7164908413301, -122.428062269463) | ||
187349 | 187349 | 177394 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 833 France Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6003056.79218 | 2089215.7831299999 | 37.716761991458604 | -122.431385897768 | (37.7167619914586, -122.431385897768) | |||
35817 | 35817 | 83433 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 760 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/2005 12:00:00 AM | 4 | 6000998.571 | 2089370.50235 | 37.7170699516967 | -122.43851121642099 | (37.7170699516967, -122.438511216421) | ||
64511 | 64511 | 177400 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1112 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6003994.8137 | 2089359.3172799998 | 37.7172092225078 | -122.428153843121 | (37.7172092225078, -122.428153843121) | |||
114640 | 114640 | 108839 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1112 Russia Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770758 | 6003955.6442 | 2089384.8090099997 | 37.7172770009516 | -122.42829104937599 | (37.7172770009516, -122.428291049376) | |
146771 | 146771 | 88351 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 700 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51333 | 6002622.22718 | 2089414.5665400003 | 37.7172831683531 | -122.432902166399 | (37.7172831683531, -122.432902166399) | |
160548 | 160548 | 177398 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 650 France Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6002590.58454 | 2089466.88592 | 37.7174250310079 | -122.433015275935 | (37.7174250310079, -122.433015275935) | |||
62272 | 62272 | 177397 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 650 France Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6002573.73742 | 2089477.3552599999 | 37.717452821874105 | -122.433074256169 | (37.7174528218741, -122.433074256169) | |||
34070 | 34070 | 177396 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 650 France Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002554.32379 | 2089489.05378 | 37.7174838421787 | -122.433142195459 | (37.7174838421787, -122.433142195459) | |||
106504 | 106504 | 88322 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 645 France Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51311 | 6002646.5 | 2089495.7 | 37.717507319615706 | -122.432824059512 | (37.7175073196157, -122.432824059512) | ||
125699 | 125699 | 88320 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 645 France Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51311 | 6002646.5 | 2089495.7 | 37.717507319615706 | -122.432824059512 | (37.7175073196157, -122.432824059512) | |||
44168 | 44168 | 177405 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 688 Vienna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002677.6930599995 | 2089500.91725 | 37.71752341415829 | -122.432716611994 | (37.7175234141583, -122.432716611994) | |||
10860 | 10860 | 104506 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 631 France Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 3x3 | 6002582.75614 | 2089515.1433 | 37.7175570910528 | -122.43304578096 | (37.7175570910528, -122.43304578096) | ||
121083 | 121083 | 177404 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 688 Vienna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002686.6432 | 2089516.6103299998 | 37.717567011481705 | -122.432686795869 | (37.7175670114817, -122.432686795869) | |||
129025 | 129025 | 88319 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 631 France Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51310 | 6002604.8 | 2089521.8 | 37.7175766192591 | -122.43297006078501 | (37.7175766192591, -122.432970060785) | |||
36649 | 36649 | 177403 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 688 Vienna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002695.8436900005 | 2089531.77748 | 37.7176091789075 | -122.432656076817 | (37.7176091789075, -122.432656076817) | |||
11429 | 11429 | 83565 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 647 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769747 | 6003095.84203 | 2089582.30789 | 37.7177706009018 | -122.43127706988199 | (37.7177706009018, -122.431277069882) |
168525 | 168525 | 177402 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 670 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002753.398469999 | 2089622.73249 | 37.7178621851574 | -122.43246362908701 | (37.7178621851574, -122.432463629087) | |||
153491 | 153491 | 177399 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 908 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6003531.7567 | 2089652.07353 | 37.7179868563895 | -122.429775281212 | (37.7179868563895, -122.429775281212) | |||
41811 | 41811 | 108815 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 474 Munich St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774652 | 6003779.44726 | 2089723.3814299998 | 37.7181966752665 | -122.42892420414499 | (37.7181966752665, -122.428924204145) | |
34177 | 34177 | 177411 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 474 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6003775.47727 | 2089725.4167 | 37.7182020389599 | -122.42893807173 | (37.7182020389599, -122.42893807173) | |||
11033 | 11033 | 83366 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 618 Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52311 | 6003144.474669999 | 2089738.5573200001 | 37.718202383405206 | -122.43112011482701 | (37.7182023834052, -122.431120114827) | |
23545 | 23545 | 177395 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 715 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6001937.656140001 | 2089768.77997 | 37.718216907458704 | -122.435293726344 | (37.7182169074587, -122.435293726344) | |||
38105 | 38105 | 177410 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 470 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6003782.11139 | 2089736.37793 | 37.718232511606296 | -122.428915921448 | (37.7182325116063, -122.428915921448) | |||
10886 | 10886 | 83673 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 618 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52311 | 6003154.7737300005 | 2089756.30482 | 37.7182516977425 | -122.43108578140499 | (37.7182516977425, -122.431085781405) | |
144343 | 144343 | 108814 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 470 Munich St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774651 | 6003792.96606 | 2089744.94608 | 37.7182566522639 | -122.42887901198 | (37.7182566522639, -122.42887901198) | |
98401 | 98401 | 88306 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 575 Athens St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51300 | 6003350.0 | 2089985.0 | 37.718890705147 | -122.43042727566299 | (37.718890705147, -122.430427275663) | |||
173639 | 173639 | 177414 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 575 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6003352.2884599995 | 2089985.19468 | 37.7188913693287 | -122.430419379246 | (37.7188913693287, -122.430419379246) | |||
63292 | 63292 | 177412 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 539 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6003697.3420400005 | 2090030.0653 | 37.719034114214004 | -122.42922986306401 | (37.719034114214, -122.429229863064) | |||
36589 | 36589 | 177408 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 638 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6002397.88484 | 2090069.70643 | 37.71906931008821 | -122.43372440936301 | (37.7190693100882, -122.433724409363) | |||
171641 | 171641 | 177409 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 659 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6002137.168430001 | 2090084.38724 | 37.719094822944996 | -122.434626653316 | (37.719094822945, -122.434626653316) | |||
112316 | 112316 | 88332 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 659 Madrid St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51320 | 6002140.0 | 2090092.0 | 37.7191158866353 | -122.434617409737 | (37.7191158866353, -122.434617409737) | |||
173626 | 173626 | 177407 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 626 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6002434.78266 | 2090132.2743 | 37.7192432011957 | -122.433601337127 | (37.7192432011957, -122.433601337127) | |||
127266 | 127266 | 95734 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 626 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767481 | 6002384.8 | 2090170.7 | 37.7193458734928 | -122.43377685304199 | (37.7193458734928, -122.433776853042) | |
71769 | 71769 | 177406 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 618 Edinburgh St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002461.15734 | 2090172.80832 | 37.7193559950662 | -122.433513065093 | (37.7193559950662, -122.433513065093) | |||
103099 | 103099 | 88326 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 559 Lisbon St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51315 | 6001911.0 | 2090236.0 | 37.7194982755804 | -122.43541926902701 | (37.7194982755804, -122.435419269027) | |||
120151 | 120151 | 88327 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 559 Lisbon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51315 | 6001911.0 | 2090236.0 | 37.7194982755804 | -122.43541926902701 | (37.7194982755804, -122.435419269027) | ||
49891 | 49891 | 177413 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 518 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003506.69699 | 2090312.38662 | 37.719798511885706 | -122.42990897621401 | (37.7197985118857, -122.429908976214) | |||
124961 | 124961 | 88312 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 518 Athens St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51303 | 6003514.0 | 2090320.0 | 37.7198198301278 | -122.42988427506201 | (37.7198198301278, -122.429884275062) | |||
29927 | 29927 | 83659 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 559 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/2005 12:00:00 AM | 6 | 6001685.54257 | 2090383.4533900002 | 37.7198903425557 | -122.436209138162 | (37.7198903425557, -122.436209138162) | ||
71293 | 71293 | 208847 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 422 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995505.44933 | 2090582.5246599999 | 37.7200838784427 | -122.457585828931 | (37.7200838784427, -122.457585828931) | |||
25005 | 25005 | 177418 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 857 Dartmouth St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 4ft | 6009516.77243 | 2090302.7647799999 | 37.720110619797104 | -122.409133494811 | (37.7201106197971, -122.409133494811) | |||
60907 | 60907 | 50426 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 250 Howth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 773627 | 5997303.25557645 | 2090612.9654569 | 37.7202705700793 | -122.45137364778 | (37.7202705700793, -122.45137364778) | |
96004 | 96004 | 95123 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 75 Oneida Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 3x3 | Permit Number 54050 | 6000595.4 | 2090675.6 | 37.720630512863295 | -122.439998309146 | (37.7206305128633, -122.439998309146) | |
13056 | 13056 | 108448 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 90-98X Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2014 12:00:00 AM | 3 | 3x3 | 6004670.84101 | 2090640.5659299998 | 37.7207654791334 | -122.42590828635599 | (37.7207654791334, -122.425908286356) | |
147335 | 147335 | 95762 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 417 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767499 | 6004100.3891199995 | 2090668.84671 | 37.720810876907 | -122.427882177716 | (37.720810876907, -122.427882177716) |
143274 | 143274 | 122379 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 466 Vernon St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 10/26/2016 12:00:00 AM | 3 | 3x3 | 5992521.0 | 2090937.0 | 37.7208852925782 | -122.46792773796801 | (37.7208852925782, -122.467927737968) | ||
31130 | 31130 | 177416 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 538 Madrid St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6002518.22292 | 2090772.4099400002 | 37.721005605292504 | -122.433358634398 | (37.7210056052925, -122.433358634398) | |||
2517 | 2517 | 178826 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 927 Brazil Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004356.8834 | 2090741.4764900003 | 37.7210248094256 | -122.427000725205 | (37.7210248094256, -122.427000725205) | |||
2512 | 2512 | 178827 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 927 Brazil Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004338.08735 | 2090755.04432 | 37.7210610008535 | -122.427066663506 | (37.7210610008535, -122.427066663506) | |||
60143 | 60143 | 72252 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 531 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 1 | 6002585.93283 | 2090796.9641 | 37.7210768666757 | -122.43312633500601 | (37.7210768666757, -122.433126335006) | ||
139591 | 139591 | 87070 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 395 Byxbee St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947.0 | 2091188.0 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | |||
143622 | 143622 | 87071 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 395 Byxbee St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947.0 | 2091188.0 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | |||
25430 | 25430 | 113267 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 83 Exeter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/2015 12:00:00 AM | 2 | Permit Number 774551 | 6012507.044369999 | 2090789.37208 | 37.7216138123142 | -122.398831200496 | (37.7216138123142, -122.398831200496) | ||
3940 | 3940 | 179536 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1880 Alemany Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 10:42:00 AM | 3 | Width 3ft | 6000969.55481 | 2091096.3953200001 | 37.7218072142025 | -122.438735113438 | (37.7218072142025, -122.438735113438) | ||
44581 | 44581 | 177415 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 451 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003094.686869999 | 2091098.4419099998 | 37.7219335042119 | -122.431389232421 | (37.7219335042119, -122.431389232421) | |||
76764 | 76764 | 108377 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 226 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 3x3 | Permit Number 773810 | 6004631.19295 | 2091083.0586299999 | 37.7219782266077 | -122.42607682199801 | (37.7219782266077, -122.426076821998) | |
10319 | 10319 | 109211 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 819 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773413 | 6011187.7232800005 | 2090968.5283099997 | 37.722032138266 | -122.403404362845 | (37.722032138266, -122.403404362845) | |
3896 | 3896 | 253542 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1000 Cayuga Ave | 10 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 10/03/2017 02:42:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
3899 | 3899 | 253541 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1000 Cayuga Ave | 9 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 10/03/2017 03:59:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
3900 | 3900 | 253543 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1000 Cayuga Ave | 11 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 10/03/2017 02:35:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
3902 | 3902 | 253544 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1000 Cayuga Ave | 12 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 10/03/2017 02:38:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
3906 | 3906 | 253540 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1000 Cayuga Ave | 8 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 10/03/2017 04:11:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
71256 | 71256 | 52791 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 955@ MOSCOW Excelsior Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2006 12:00:00 AM | 1 | Permit Number 48832 | 6004754.52241 | 2091271.3997400003 | 37.7225023397811 | -122.425663900979 | (37.7225023397811, -122.425663900979) | ||
26519 | 26519 | 115980 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2x Olmstead St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6011593.71434 | 2091235.60939 | 37.722788156028706 | -122.402019710862 | (37.7227881560287, -122.402019710862) | |||
171742 | 171742 | 115979 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2x Olmstead St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6011610.19593 | 2091240.25279 | 37.722801825729604 | -122.401963063449 | (37.7228018257296, -122.401963063449) | |||
172623 | 172623 | 115978 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2x Olmstead St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6011623.9012 | 2091244.95295 | 37.7228154963084 | -122.40191601721001 | (37.7228154963084, -122.40191601721) | |||
182061 | 182061 | 115977 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2x Olmstead St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6011639.0005 | 2091249.90123 | 37.722829925953896 | -122.40186416949 | (37.7228299259539, -122.40186416949) | |||
12646 | 12646 | 115976 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2x Olmstead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6011653.53869 | 2091254.58415 | 37.7228435956385 | -122.401814242757 | (37.7228435956385, -122.401814242757) | |||
174665 | 174665 | 177435 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 99 Karen Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6010088.68836 | 2091439.3296700001 | 37.72326341446679 | -122.407236642978 | (37.7232634144668, -122.407236642978) | |||
75167 | 75167 | 177436 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 99 Karen Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6010107.2934 | 2091444.47715 | 37.7232785896114 | -122.40717269128099 | (37.7232785896114, -122.407172691281) | |||
110088 | 110088 | 114688 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 231 Dwight St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/01/2015 12:00:00 AM | Permit Number 774702 | 6010865.8 | 2091429.3 | 37.723279336417704 | -122.404549596707 | (37.7232793364177, -122.404549596707) | |||
36033 | 36033 | 177437 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 93 Karen Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6010115.68283 | 2091447.6223799998 | 37.72328769526371 | -122.407143912081 | (37.7232876952637, -122.407143912081) | |||
171865 | 171865 | 114755 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 89 Karen Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/2015 12:00:00 AM | 1 | Permit Number 777135 | 6010155.72688 | 2091460.8073900002 | 37.723326139481294 | -122.407006415641 | (37.7233261394813, -122.407006415641) | ||
176355 | 176355 | 177438 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 83 Karen Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6010165.7616 | 2091462.99776 | 37.723332715313894 | -122.406971881647 | (37.7233327153139, -122.406971881647) | |||
37487 | 37487 | 177439 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 79 Karen Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6010188.86492 | 2091471.00105 | 37.7233559834822 | -122.406892581232 | (37.7233559834822, -122.406892581232) | |||
94923 | 94923 | 88503 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 7 Wheat St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51441 | 6012178.0 | 2091435.0 | 37.723368235520205 | -122.400013942822 | (37.7233682355202, -122.400013942822) | |||
149083 | 149083 | 177440 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 71 Karen Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6010238.57006 | 2091486.2001099999 | 37.7234004981218 | -122.406721829644 | (37.7234004981218, -122.406721829644) | |||
41960 | 41960 | 177441 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 71 Karen Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6010258.66598 | 2091491.8701799999 | 37.7234171913236 | -122.406652760812 | (37.7234171913236, -122.406652760812) | |||
160433 | 160433 | 177442 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 67 Karen Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6010267.21749 | 2091493.9064200001 | 37.723423260860706 | -122.40662334309799 | (37.7234232608607, -122.406623343098) | |||
56518 | 56518 | 177443 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 63 Karen Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6010306.59987 | 2091507.00491 | 37.7234614298874 | -122.40648812732799 | (37.7234614298874, -122.406488127328) | |||
129834 | 129834 | 208845 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 277 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5995629.339 | 2091829.15928 | 37.7235139565963 | -122.457247722532 | (37.7235139565963, -122.457247722532) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");