trees
979 rows where qSpecies_id = 13 sorted by DBH descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3743 | 193316 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 136 Hawthorne St | 2 | : | Tree | Private 2 | 9 | Width 2ft | 6013300.83104 | 2113672.81478 | 37.7844910077044 | -122.397691511273 | (37.7844910077044, -122.397691511273) | 6 | 2 | 9 | 28856 | 6 | |||
13364 | 70607 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1256 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6007485.00571 | 2115457.39575 | 37.7890654569562 | -122.417938877483 | (37.7890654569562, -122.417938877483) | 13 | 1 | 10 | 28858 | 21 | |||
37097 | 193317 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 136 Hawthorne St | 3 | : | Tree | Private 2 | 9 | Width 2ft | 6013319.34244 | 2113654.62795 | 37.7844421016727 | -122.397626191699 | (37.7844421016727, -122.397626191699) | 6 | 2 | 9 | 28856 | 6 | |||
50794 | 69419 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 168 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | 9 | Permit Number 33524 | 6001328.44378 | 2087365.87339 | 37.7115844451475 | -122.437227553813 | (37.7115844451475, -122.437227553813) | 9 | 7 | 6 | 28861 | 5 | |
52182 | 230325 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 30 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6004684.33252 | 2103302.03118 | 37.7555317594992 | -122.426762864436 | (37.7555317594992, -122.426762864436) | 2 | 4 | 5 | 28862 | 22 | |||
162700 | 136 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1025X 14th St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3X3 | 6001971.14414 | 2107605.72409 | 37.7671948800673 | -122.436453906645 | (37.7671948800673, -122.436453906645) | 15 | 5 | 5 | 28862 | 3 | |||
171907 | 59600 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1116 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/26/1981 12:00:00 AM | 9 | Permit Number 19001 | 6015518.08801 | 2103793.04215 | 37.757486543884 | -122.389330342431 | (37.757486543884, -122.389330342431) | 10 | 3 | 8 | 28856 | 29 | ||
173449 | 193315 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 136 Hawthorne St | 1 | : | Tree | Private 2 | 9 | Width 2ft | 6013291.13873 | 2113684.88595 | 37.7845236126199 | -122.39772589056 | (37.7845236126199, -122.39772589056) | 6 | 2 | 9 | 28856 | 6 | |||
5292 | 241594 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 687 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007646.0169 | 2096174.81068 | 37.7361290122323 | -122.416015706955 | (37.7361290122323, -122.416015706955) | 2 | 7 | 7 | 28859 | 2 | |||
7414 | 70266 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 414 23rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5988762.33088 | 2112478.21963 | 37.7798139854521 | -122.482497769619 | (37.7798139854521, -122.482497769619) | 11 | 6 | 2 | 55 | 26 | |||
11453 | 130994 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 800 Lombard St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008432.69085 | 2120383.1883 | 37.8026437557674 | -122.415008787324 | (37.8026437557674, -122.415008787324) | 5 | 1 | 10 | 308 | 32 | |||
11942 | 34949 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1246 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | Permit Number 38547 | 6007519.49351 | 2115461.74269 | 37.7890793334842 | -122.417819862092 | (37.7890793334842, -122.417819862092) | 13 | 1 | 10 | 28858 | 21 | ||
14077 | 70606 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1250 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6007500.28626 | 2115460.0775 | 37.7890736803541 | -122.417886198793 | (37.7890736803541, -122.417886198793) | 13 | 1 | 10 | 28858 | 21 | |||
33289 | 248252 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 110 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006810.41598 | 2098914.4324 | 37.7436043875329 | -122.41909899034 | (37.7436043875329, -122.41909899034) | 2 | 7 | 7 | 28859 | 2 | |||
81489 | 45681 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 440 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/2001 12:00:00 AM | 8 | Permit Number 44368 | 6014041.20893 | 2105068.96138 | 37.7609079516478 | -122.394527362641 | (37.7609079516478, -122.394527362641) | 10 | 3 | 8 | 28856 | 29 | ||
96875 | 177423 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 270 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5999939.77666 | 2092147.85861 | 37.7246356530907 | -122.442370227117 | (37.7246356530907, -122.442370227117) | 9 | 7 | 6 | 28861 | 25 | |||
97084 | 250221 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 312 Filbert St | 2 | Side Yard : Yard | Tree | Private 2 | 8 | Width 0ft | 6011282.00764 | 2120080.85256 | 37.8019733165766 | -122.405127362244 | (37.8019733165766, -122.405127362244) | 3 | 1 | 10 | 308 | 23 | |||
143709 | 230301 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1083 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010010.1738 | 2102926.15109 | 37.754799354323 | -122.40831786098 | (37.754799354323, -122.40831786098) | 2 | 4 | 7 | 28859 | 19 | |||
153748 | 34942 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 462 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1997 12:00:00 AM | 8 | Permit Number 38539 | 5995310.64413 | 2112404.55918 | 37.7799904974934 | -122.459839088006 | (37.7799904974934, -122.459839088006) | 11 | 6 | 2 | 54 | 11 | ||
164921 | 177414 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 575 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6003352.28846 | 2089985.19468 | 37.7188913693287 | -122.430419379246 | (37.7188913693287, -122.430419379246) | 9 | 7 | 6 | 28861 | 5 | |||
186179 | 230297 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1171 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008685.11737 | 2101744.284 | 37.7514799242568 | -122.412816735721 | (37.7514799242568, -122.412816735721) | 2 | 4 | 7 | 28859 | 19 | |||
189398 | 130985 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2098 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5999249.25927 | 2121180.66389 | 37.8043130782603 | -122.446845381305 | (37.8043130782603, -122.446845381305) | 13 | 9 | 1 | 57 | 17 | |||
6177 | 70542 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 657 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | 6001053.4846 | 2110988.4642 | 37.7764308509595 | -122.439870513201 | (37.7764308509595, -122.439870513201) | 15 | 5 | 11 | 29492 | 10 | ||||
21538 | 123622 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 111 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5995179.48554 | 2114830.2995 | 37.7866433854107 | -122.460468639914 | (37.7866433854107, -122.460468639914) | 11 | 6 | 1 | 54 | 11 | |||
54419 | 131003 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1109 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011959.67514 | 2119544.33527 | 37.8005380309676 | -122.402744545519 | (37.8005380309676, -122.402744545519) | 3 | 1 | 10 | 308 | 23 | |||
62802 | 110565 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 135 Theresa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x9 | 6002103.51268 | 2093689.48997 | 37.7289917127743 | -122.435000682233 | (37.7289917127743, -122.435000682233) | 9 | 7 | 6 | 28861 | 25 | |||
69271 | 177392 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1654 Sunnydale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 6006773.14965 | 2087593.0806 | 37.7125163163365 | -122.418425260531 | (37.7125163163365, -122.418425260531) | 9 | 7 | 8 | 309 | 39 | |||
76797 | 177417 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1x Rolph St | 1 | Median : Cutout | Tree | DPW 1 | 7 | Width 4ft | 6000503.4246 | 2088653.73075 | 37.7150736797726 | -122.440171325345 | (37.7150736797726, -122.440171325345) | 9 | 7 | 6 | 28861 | 5 | |||
102109 | 230324 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 14 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004676.49219 | 2103485.42894 | 37.7560348834086 | -122.426803038952 | (37.7560348834086, -122.426803038952) | 2 | 4 | 5 | 28862 | 22 | |||
116168 | 230299 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 590 York St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009785.6882 | 2105558.56974 | 37.762014809365 | -122.409279952113 | (37.762014809365, -122.409279952113) | 8 | 4 | 8 | 28859 | 19 | |||
116678 | 31977 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 134 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/30/1995 12:00:00 AM | 7 | Permit Number 35376 | 5995230.64434 | 2114664.73917 | 37.7861917443429 | -122.460279644251 | (37.7861917443429, -122.460279644251) | 11 | 6 | 1 | 54 | 11 | |
131626 | 84840 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1107 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2007 12:00:00 AM | 7 | Permit No. 49267 | 6009440.82091 | 2117125.31431 | 37.7937550347318 | -122.411289855968 | (37.7937550347318, -122.411289855968) | 3 | 1 | 10 | 28857 | 21 | ||
158639 | 230350 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 35 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002643.63835 | 2096299.62877 | 37.7361892128574 | -122.433319865541 | (37.7361892128574, -122.433319865541) | 2 | 7 | 5 | 63 | 7 | |||
163039 | 122918 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 336 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5992182.56375 | 2113171.96239 | 37.7819171874048 | -122.470716333226 | (37.7819171874048, -122.470716333226) | 11 | 6 | 2 | 54 | 11 | |||
171700 | 230310 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 322 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005451.16912 | 2101791.33905 | 37.7514270756131 | -122.424003479091 | (37.7514270756131, -122.424003479091) | 2 | 4 | 5 | 28859 | 19 | |||
175599 | 130981 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3001 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6003397.35892 | 2118675.30556 | 37.7976701136348 | -122.432311513284 | (37.7976701136348, -122.432311513284) | 13 | 9 | 1 | 57 | 17 | |||
182368 | 177398 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 650 France Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6002590.58454 | 2089466.88592 | 37.7174250310079 | -122.433015275935 | (37.7174250310079, -122.433015275935) | 9 | 7 | 6 | 28861 | 5 | |||
190891 | 230337 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 823 Castro St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002470.86224 | 2103420.79735 | 37.7557324674964 | -122.434426212412 | (37.7557324674964, -122.434426212412) | 2 | 4 | 5 | 28862 | 22 | |||
3356 | 74692 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 200 Green St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6011876.44918 | 2119465.43765 | 37.8003167500634 | -122.403026990216 | (37.8003167500634, -122.403026990216) | 3 | 1 | 10 | 308 | 23 | |||
7661 | 83659 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 559 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6001685.54257 | 2090383.45339 | 37.7198903425557 | -122.436209138162 | (37.7198903425557, -122.436209138162) | 9 | 7 | 6 | 28861 | 5 | |||
8067 | 106254 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1912X 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | Permit Number 770844 | 6012043 | 2105629 | 37.7623344042956 | -122.401477690357 | (37.7623344042956, -122.401477690357) | 8 | 3 | 8 | 28856 | 29 | ||
23346 | 177418 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 857 Dartmouth St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 4ft | 6009516.77243 | 2090302.76478 | 37.7201106197971 | -122.409133494811 | (37.7201106197971, -122.409133494811) | 9 | 3 | 7 | 309 | 28 | |||
24379 | 84492 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1726 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50144 | 6014424.88297 | 2094914.9156 | 37.733048399857 | -122.392490121246 | (37.733048399857, -122.392490121246) | 10 | 3 | 8 | 58 | 1 | |
26823 | 130979 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3001 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6003392.63825 | 2118710.53887 | 37.7977665875245 | -122.432330365752 | (37.7977665875245, -122.432330365752) | 13 | 9 | 1 | 57 | 17 | |||
27090 | 130990 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1465 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007716.27446 | 2117147.85171 | 37.7937200456874 | -122.417258554752 | (37.7937200456874, -122.417258554752) | 5 | 1 | 10 | 28858 | 32 | |||
39763 | 177405 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 688 Vienna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6002677.69306 | 2089500.91725 | 37.7175234141583 | -122.432716611994 | (37.7175234141583, -122.432716611994) | 9 | 7 | 6 | 28861 | 5 | |||
49090 | 51497 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 741 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50950 | 6009247.81044 | 2119754.33215 | 37.8009628437188 | -122.412143582356 | (37.8009628437188, -122.412143582356) | 3 | 1 | 10 | 308 | 4 | |
50268 | 120234 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 896 24th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5988543.40273 | 2109982.31108 | 37.7729481790861 | -122.483072139836 | (37.7729481790861, -122.483072139836) | 11 | 6 | 2 | 55 | 26 | |||
54645 | 130980 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3001 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6003394.29695 | 2118690.35312 | 37.797711256726 | -122.43232318378 | (37.797711256726, -122.43232318378) | 13 | 9 | 1 | 57 | 17 | |||
59490 | 12529 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 105 Lake St | 1 | Front Yard : Cutout | Tree | Private 2 | FUF | 07/12/2004 12:00:00 AM | 6 | 3x3 | Permit Number 773769 | 5995136.95364 | 2114887.49287 | 37.7867979761022 | -122.460619935074 | (37.7867979761022, -122.460619935074) | 11 | 6 | 1 | 54 | 11 |
84525 | 30506 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3615 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/1998 12:00:00 AM | 6 | Permit Number 40581 | 5997549.20453 | 2115073.94574 | 37.7874484120486 | -122.452287614306 | (37.7874484120486, -122.452287614306) | 11 | 6 | 1 | 54 | 31 | ||
104335 | 120377 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 101 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5987995.99107 | 2115194.27342 | 37.7872268871617 | -122.485348201277 | (37.7872268871617, -122.485348201277) | 11 | 6 | 1 | 55 | 33 | |||
108983 | 131005 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1109 Sansome St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011966.28047 | 2119507.31076 | 37.8004367394276 | -122.40271908303 | (37.8004367394276, -122.40271908303) | 3 | 1 | 10 | 308 | 23 | |||
122005 | 230335 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 823 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002473.18997 | 2103401.0764 | 37.7556784506177 | -122.434416752458 | (37.7556784506177, -122.434416752458) | 2 | 4 | 5 | 28862 | 22 | |||
137702 | 230320 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 469 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6002876.4268 | 2099458.33871 | 37.7448755037027 | -122.432740595108 | (37.7448755037027, -122.432740595108) | 2 | 7 | 5 | 63 | 22 | |||
139581 | 177403 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 688 Vienna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6002695.84369 | 2089531.77748 | 37.7176091789075 | -122.432656076817 | (37.7176091789075, -122.432656076817) | 9 | 7 | 6 | 28861 | 5 | |||
150010 | 208856 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 331 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5999876.46994 | 2094937.06877 | 37.7322905690371 | -122.442789260809 | (37.7322905690371, -122.442789260809) | 9 | 7 | 4 | 63 | 40 | |||
158560 | 70331 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 73 Danton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2010 12:00:00 AM | 6 | 3x3 | Permit Number 54058 | 6002878.82262 | 2094505.59831 | 37.731276553757 | -122.43237864406 | (37.731276553757, -122.43237864406) | 9 | 7 | 5 | 28861 | 25 |
172305 | 37859 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 127 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/17/2004 12:00:00 AM | 6 | Permit Number 47618 | 6004006.38058 | 2093054.46604 | 37.7273559413142 | -122.428377081834 | (37.7273559413142, -122.428377081834) | 9 | 7 | 6 | 28861 | 5 | |
182757 | 230303 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2784 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6010083.7548 | 2102826.74916 | 37.7545305388726 | -122.408056386695 | (37.7545305388726, -122.408056386695) | 2 | 4 | 7 | 28859 | 19 | |||
188530 | 177404 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 688 Vienna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6002686.6432 | 2089516.61033 | 37.7175670114817 | -122.432686795869 | (37.7175670114817, -122.432686795869) | 9 | 7 | 6 | 28861 | 5 | |||
895 | 56729 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1547 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2012 12:00:00 AM | 5 | Permit Number 769649 | 6015653.0224 | 2095684.4557 | 37.7352295280363 | -122.388297771341 | (37.7352295280363, -122.388297771341) | 10 | 3 | 8 | 58 | 1 | ||
1903 | 220552 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 13 Ohlone Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | Permit Number 785489 | 6002169.64489 | 2096371.31931 | 37.7363591568587 | -122.434963778568 | (37.7363591568587, -122.434963778568) | 2 | 7 | 5 | 63 | 7 | ||
18090 | 177402 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 670 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002753.39847 | 2089622.73249 | 37.7178621851574 | -122.432463629087 | (37.7178621851574, -122.432463629087) | 9 | 7 | 6 | 28861 | 5 | |||
24814 | 130998 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2201 Leavenworth St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6007580.24685 | 2119942.9983 | 37.8013871663302 | -122.417927457909 | (37.8013871663302, -122.417927457909) | 5 | 1 | 1 | 28858 | 32 | |||
40064 | 84782 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 228 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2007 12:00:00 AM | 5 | Permit No. 49243 | 6013990.15625 | 2105982.37522 | 37.7634131481085 | -122.394767902514 | (37.7634131481085, -122.394767902514) | 14 | 3 | 8 | 28856 | 29 | ||
45858 | 88076 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 674 Thornton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51071 | 6011923.03733 | 2094336.64392 | 37.7313213328046 | -122.401099095547 | (37.7313213328046, -122.401099095547) | 10 | 3 | 8 | 58 | 1 | |
47926 | 110564 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 135 Theresa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x9 | 6002092.75194 | 2093699.46339 | 37.7290184865087 | -122.435038595882 | (37.7290184865087, -122.435038595882) | 9 | 7 | 6 | 28861 | 25 | |||
49171 | 94884 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2010 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/23/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53951 | 6013072.55459 | 2096282.04692 | 37.736727066797 | -122.397261344859 | (37.736727066797, -122.397261344859) | 10 | 3 | 8 | 58 | 1 |
49758 | 230319 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 119 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005056.96104 | 2098704.08914 | 37.7429279327818 | -122.425147048897 | (37.7429279327818, -122.425147048897) | 2 | 7 | 5 | 63 | 22 | |||
58397 | 177397 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 650 France Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6002573.73742 | 2089477.35526 | 37.7174528218741 | -122.433074256169 | (37.7174528218741, -122.433074256169) | 9 | 7 | 6 | 28861 | 5 | |||
67350 | 56947 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 690 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/1974 12:00:00 AM | 5 | Permit Number 14199 | 6012986.78866 | 2103864.51855 | 37.7575421408828 | -122.398089663624 | (37.7575421408828, -122.398089663624) | 10 | 3 | 8 | 28856 | 29 | ||
80833 | 230356 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 137 Randall St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004658.9023 | 2097536.10277 | 37.7396984133428 | -122.42644028119 | (37.7396984133428, -122.42644028119) | 2 | 7 | 5 | 63 | 7 | |||
84671 | 88351 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 700 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51333 | 6002622.22718 | 2089414.56654 | 37.7172831683531 | -122.432902166399 | (37.7172831683531, -122.432902166399) | 9 | 7 | 6 | 28861 | 5 | |
88701 | 230357 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 137 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004642.12984 | 2097534.33192 | 37.7396926028383 | -122.426498147168 | (37.7396926028383, -122.426498147168) | 2 | 7 | 5 | 63 | 7 | |||
90525 | 230323 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 12 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004674.70805 | 2103511.60917 | 37.7561066672951 | -122.426811073486 | (37.7561066672951, -122.426811073486) | 2 | 4 | 5 | 28862 | 22 | |||
95963 | 123057 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 514 Funston Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5991919.13974 | 2111920.98536 | 37.7784671102548 | -122.47153646454 | (37.7784671102548, -122.47153646454) | 11 | 6 | 2 | 54 | 11 | |||
100635 | 177413 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 518 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003506.69699 | 2090312.38662 | 37.7197985118857 | -122.429908976214 | (37.7197985118857, -122.429908976214) | 9 | 7 | 6 | 28861 | 5 | |||
104340 | 60605 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 703 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/17/1983 12:00:00 AM | 5 | Permit Number 20227 | 6001028.5934 | 2111122.4037 | 37.7767971980591 | -122.439966224713 | (37.7767971980591, -122.439966224713) | 15 | 5 | 11 | 29492 | 41 | ||
112413 | 131004 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1109 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6011962.57681 | 2119524.82057 | 37.8004846103385 | -122.402733131341 | (37.8004846103385, -122.402733131341) | 3 | 1 | 10 | 308 | 23 | |||
121231 | 27188 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 258 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/2002 12:00:00 AM | 5 | 2X3 | 6002908.14927 | 2093727.2885 | 37.7291411540255 | -122.43222169349 | (37.7291411540255, -122.43222169349) | 9 | 7 | 6 | 28861 | 25 | ||
133316 | 130999 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2009 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008124.35834 | 2119571.24818 | 37.8003970406522 | -122.416018243071 | (37.8003970406522, -122.416018243071) | 5 | 1 | 1 | 308 | 32 | |||
148719 | 95104 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2200 Beach St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/08/2008 12:00:00 AM | 5 | 5999633.73017 | 2120895.6152 | 37.8035523678131 | -122.445494383786 | (37.8035523678131, -122.445494383786) | 13 | 9 | 1 | 57 | 17 | |||
150499 | 88037 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2301X Lyon St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51052 | 5999275.57165 | 2116691.87228 | 37.7919895603315 | -122.446431199448 | (37.7919895603315, -122.446431199448) | 11 | 6 | 1 | 29490 | 30 | |
153621 | 178827 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 927 Brazil Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004338.08735 | 2090755.04432 | 37.7210610008535 | -122.427066663506 | (37.7210610008535, -122.427066663506) | 9 | 7 | 6 | 28861 | 5 | |||
168146 | 177409 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 659 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6002137.16843 | 2090084.38724 | 37.719094822945 | -122.434626653316 | (37.719094822945, -122.434626653316) | 9 | 7 | 6 | 28861 | 5 | |||
168316 | 193322 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2111 18th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6011436.66428 | 2105551.33646 | 37.7620873073181 | -122.403569326371 | (37.7620873073181, -122.403569326371) | 10 | 3 | 8 | 28856 | 29 | |||
176927 | 130997 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2201 Leavenworth St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6007578.93915 | 2119952.78886 | 37.8014139751467 | -122.417932677574 | (37.8014139751467, -122.417932677574) | 5 | 1 | 1 | 28858 | 32 | |||
185258 | 230286 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3714 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005720.70834 | 2100540.11628 | 37.748006719144 | -122.422982458079 | (37.748006719144, -122.422982458079) | 2 | 4 | 5 | 28859 | 19 | |||
192999 | 230348 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 280 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6004547.50076 | 2096560.53724 | 37.7370134334286 | -122.42675600438 | (37.7370134334286, -122.42675600438) | 2 | 7 | 5 | 63 | 7 | |||
107450 | 4378 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2425X Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6006994.61601 | 2120672.53629 | 37.8033573165358 | -122.420005806422 | (37.8033573165358, -122.420005806422) | 5 | 1 | 1 | 28858 | 32 | |||
1439 | 72311 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3769 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5996250.37824 | 2115874.50597 | 37.7895720432509 | -122.456839183887 | (37.7895720432509, -122.456839183887) | 11 | 6 | 1 | 54 | 31 | |||
2571 | 219957 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3933 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003591.26694 | 2101840.52548 | 37.7514569483989 | -122.430438748853 | (37.7514569483989, -122.430438748853) | 2 | 4 | 5 | 28862 | 22 | |||
3991 | 131008 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 150x Drumm St | 3 | Median : Yard | Tree | DPW 1 | 4 | Width 7ft | 6013685.84477 | 2117434.71438 | 37.7948417395127 | -122.396623287539 | (37.7948417395127, -122.396623287539) | 4 | 1 | 10 | 28860 | 6 | |||
8309 | 55891 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1981 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/24/1979 12:00:00 AM | 4 | Permit Number 17936 | 6003525.54431 | 2118603.6465 | 37.7974806237872 | -122.431862837898 | (37.7974806237872, -122.431862837898) | 13 | 9 | 1 | 57 | 17 | ||
8374 | 208843 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 40 Agua Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5997291.06099 | 2098595.63938 | 37.7421883896873 | -122.451991423486 | (37.7421883896873, -122.451991423486) | 9 | 7 | 4 | 59 | 40 | |||
18162 | 83433 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 760 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6000998.571 | 2089370.50235 | 37.7170699516967 | -122.438511216421 | (37.7170699516967, -122.438511216421) | 9 | 7 | 6 | 28861 | 5 | |||
25069 | 193337 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1270 Minnesota St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015308.47907 | 2102559.27559 | 37.7540872603324 | -122.389969077812 | (37.7540872603324, -122.389969077812) | 10 | 3 | 8 | 28856 | 29 | |||
33505 | 110563 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 135 Theresa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x9 | 6002082.974 | 2093709.61136 | 37.7290457953117 | -122.435073124425 | (37.7290457953117, -122.435073124425) | 9 | 7 | 6 | 28861 | 25 | |||
34619 | 131007 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 150x Drumm St | 2 | Median : Yard | Tree | DPW 1 | 4 | Width 7ft | 6013687.07221 | 2117423.51513 | 37.7948110573238 | -122.396618254944 | (37.7948110573238, -122.396618254944) | 4 | 1 | 10 | 28860 | 6 |
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) );