trees
979 rows where qSpecies_id = 13 sorted by qCaretaker_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
3837 | 255657 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1421 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/22/2018 12:00:00 AM | 3 | 6000959.70168 | 2111031.39919 | 37.7765434007218 | -122.44019801367 | (37.7765434007218, -122.44019801367) | 15 | 5 | 11 | 29492 | 10 | |||
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 | |||
4723 | 259742 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 259 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/11/2019 12:00:00 AM | 3 | 6005340.35583 | 2109906.90312 | 37.7737042366543 | -122.424964031136 | (37.7737042366543, -122.424964031136) | 7 | 9 | 11 | 28852 | 10 | ||
4879 | 260889 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 527 45th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5981905.91133 | 2112171.65096 | 37.7785709887537 | -122.506193994794 | (37.7785709887537, -122.506193994794) | 11 | 6 | 2 | 55 | 26 | |||
5106 | 147909 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 69 Almaden Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 5995874.31253 | 2112332.21787 | 37.7798242673223 | -122.45788388223 | (37.7798242673223, -122.45788388223) | 11 | 6 | 2 | 54 | 16 | |||
5226 | 259803 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 199x Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
5771 | 18021 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2725 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000769.3896 | 2114817.5231 | 37.7869282913907 | -122.441128056615 | (37.7869282913907, -122.441128056615) | 13 | 6 | 1 | 29490 | 27 | |||
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 | ||||
6875 | 260888 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 528 45th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5981946.38688 | 2112159.7169 | 37.7785406040131 | -122.50605309173 | (37.7785406040131, -122.50605309173) | 11 | 6 | 2 | 55 | 26 | |||
8414 | 260883 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 122 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5988999.56708 | 2114522.30916 | 37.7854402782048 | -122.481826844764 | (37.7854402782048, -122.481826844764) | 11 | 6 | 2 | 55 | 26 | ||
9454 | 260881 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 751 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985678.2622 | 2110774.56948 | 37.7749563544765 | -122.493041236092 | (37.7749563544765, -122.493041236092) | 11 | 6 | 2 | 55 | 26 | |||
10679 | 259873 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2666 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 5996410.48132 | 2110785.34876 | 37.7756077608376 | -122.455917191866 | (37.7756077608376, -122.455917191866) | 11 | 6 | 2 | 54 | 16 | ||
14232 | 90568 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1818 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/14/2019 12:00:00 AM | 3 | 3x3 | 5989946.28172 | 2110622.60957 | 37.7747877973492 | -122.478266291409 | (37.7747877973492, -122.478266291409) | 11 | 6 | 2 | 55 | 26 | ||
15038 | 259861 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 201x Wilde Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
15229 | 259804 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 199x Harkness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
15796 | 260912 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 99x Belvedere St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | |||||||||||||
18076 | 131000 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 937 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/09/2014 12:00:00 AM | 2 | Width 3ft | 6007889.3393 | 2120258.19812 | 37.8022700164033 | -122.416880201885 | (37.8022700164033, -122.416880201885) | 5 | 1 | 10 | 308 | 32 | ||
19166 | 144984 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 718 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x5 | 5990699.49046 | 2110468.54979 | 37.7744084860936 | -122.475649562098 | (37.7744084860936, -122.475649562098) | 11 | 6 | 2 | 54 | 26 | |||
19358 | 259860 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 201x Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
22156 | 150165 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1091 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2018 12:00:00 AM | 3 | Width 3ft | 6014460.64342 | 2105255.76526 | 37.7614441832169 | -122.39308978288 | (37.7614441832169, -122.39308978288) | 10 | 3 | 8 | 28856 | 29 | ||
30957 | 251545 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 347 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6004948 | 2106317 | 37.7638250559684 | -122.426065641314 | (37.7638250559684, -122.426065641314) | 8 | 4 | 5 | 28859 | 19 | ||||
33582 | 103859 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1475 Polk St | 3 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006677 | 2115920.4 | 37.7902912446707 | -122.420767361582 | (37.7902912446707, -122.420767361582) | 13 | 9 | 10 | 28858 | 21 | ||
33672 | 103773 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1288 Polk St | 3 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 6006856.2 | 2115250.5 | 37.7884619632914 | -122.420099779635 | (37.7884619632914, -122.420099779635) | 13 | 9 | 10 | 28858 | 21 | |||
34100 | 103787 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1217 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006790.1 | 2115111 | 37.7880752061995 | -122.420318570601 | (37.7880752061995, -122.420318570601) | 13 | 9 | 10 | 28858 | 21 | ||
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 | |||
35478 | 141579 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 500 BAKER ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 0ft | 6000650.2876 | 2110740.0178 | 37.7757257205697 | -122.441247451765 | (37.7757257205697, -122.441247451765) | 15 | 5 | 11 | 29492 | 10 | |||
38086 | 85870 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2310 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/22/2007 12:00:00 AM | 3 | 3x3 | 6008150.98253 | 2104964.863142 | 37.7602929064273 | -122.414891759956 | (37.7602929064273, -122.414891759956) | 2 | 4 | 7 | 28859 | 19 | ||
39534 | 8225 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1500X Galvez Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/10/2015 08:37:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.7396967491289 | -122.385840466933 | (37.7396967491289, -122.385840466933) | 10 | 3 | 8 | 58 | 1 | ||
42861 | 103782 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1237 Polk St | 2 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006764.1 | 2115217.5 | 37.7883661638156 | -122.420416088533 | (37.7883661638156, -122.420416088533) | 13 | 9 | 10 | 28858 | 21 | ||
45229 | 13059 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 583 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/28/2015 07:23:00 AM | 3 | 2x2 | 6009557.0524 | 2120495.5376 | 37.8030153566132 | -122.41112585507 | (37.8030153566132, -122.41112585507) | 3 | 1 | 10 | 308 | 23 | ||
46494 | 48393 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1325 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/17/2018 12:00:00 AM | 4 | Permit Number 45775 | 5994526.88441 | 2112095.32134 | 37.7790963088496 | -122.462528007047 | (37.7790963088496, -122.462528007047) | 11 | 6 | 2 | 54 | 11 | |
48795 | 145061 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 618 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/24/2018 12:00:00 AM | 3 | 5x5 | 5991308.93205 | 2111174.50243 | 37.7763821517422 | -122.47359291598 | (37.7763821517422, -122.47359291598) | 11 | 6 | 2 | 54 | 26 | ||
49029 | 26689 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1295X Pierce St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4X4 | 6002245.89461 | 2112942.9215 | 37.7818651028046 | -122.435885513106 | (37.7818651028046, -122.435885513106) | 15 | 5 | 11 | 29490 | 41 | |||
52659 | 6741 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1300X Fairfax Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2017 01:50:00 PM | 3 | 3x3 | 6016924.03316 | 2097256.88159 | 37.7396174392826 | -122.384012840031 | (37.7396174392826, -122.384012840031) | 10 | 3 | 8 | 58 | 1 | ||
62298 | 103869 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1411 Polk St | 4 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006684.9 | 2115784.5 | 37.7899185422019 | -122.420730376301 | (37.7899185422019, -122.420730376301) | 13 | 9 | 10 | 28858 | 21 | ||
62327 | 103775 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1288 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006856.2 | 2115250.5 | 37.7884619632914 | -122.420099779635 | (37.7884619632914, -122.420099779635) | 13 | 9 | 10 | 28858 | 21 | ||
64797 | 103852 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1507 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006614.6 | 2116113.6 | 37.7908182067111 | -122.420996984718 | (37.7908182067111, -122.420996984718) | 13 | 9 | 10 | 28858 | 21 | ||
65379 | 24369 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 134 Duboce Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/19/2016 04:44:00 AM | 3 | 3x3 | 6005829.4207618 | 2108507.0022787 | 37.7698880583785 | -122.423172750169 | (37.7698880583785, -122.423172750169) | 8 | 4 | 5 | 28853 | 19 | ||
65644 | 109906 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1415 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 1 | 3x3 | 6008272.88194 | 2109795.90835 | 37.7735646809973 | -122.414812077722 | (37.7735646809973, -122.414812077722) | 8 | 2 | 9 | 28853 | 34 | |||
66307 | 47394 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 492 03rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/14/2002 12:00:00 AM | 2 | Permit Number 45308 | 5995008.66399 | 2112223.96074 | 37.7794772512056 | -122.460870672851 | (37.7794772512056, -122.460870672851) | 11 | 6 | 2 | 54 | 11 | |
66805 | 258499 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 379 Arleta Ave | 1 | Sidewalk: Curb side : | Tree | DPW 1 | 6009061.07772 | 2088406.01218 | 37.7148769915418 | -122.41057481256 | (37.7148769915418, -122.41057481256) | 9 | 7 | 8 | 309 | 39 | |||||
68819 | 131009 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 150x Drumm St | 4 | Median : Yard | Tree | DPW 1 | 4 | Width 7ft | 6013684.35472 | 2117443.22893 | 37.7948650355324 | -122.396629040522 | (37.7948650355324, -122.396629040522) | 4 | 1 | 10 | 28860 | 6 | |||
70101 | 103767 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1323 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006757 | 2115467 | 37.7890508291132 | -122.420458370284 | (37.7890508291132, -122.420458370284) | 13 | 9 | 10 | 28858 | 21 | ||
76227 | 18413 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 799X Potrero Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/05/2013 12:00:00 AM | 3 | 4X4 | 6010481.3464666 | 2104567.7087473 | 37.7593330783471 | -122.406804093165 | (37.7593330783471, -122.406804093165) | 10 | 4 | 8 | 28859 | 19 | ||
76327 | 109486 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1314 POLK ST | 1 | Sidewalk: Curb side : Pot | Landscaping | DPW 1 | 01/23/2016 04:50:00 AM | 3 | 3x3 | 6006825.7 | 2115468.8 | 37.7890596427133 | -122.420220804515 | (37.7890596427133, -122.420220804515) | 13 | 9 | 10 | 28858 | 21 | ||
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 | |||
79462 | 150164 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1091 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2018 12:00:00 AM | 3 | Width 3ft | 6014439.46295 | 2105255.42016 | 37.7614420590332 | -122.393163013761 | (37.7614420590332, -122.393163013761) | 10 | 3 | 8 | 28856 | 29 | ||
80700 | 253542 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1000 Cayuga Ave | 10 | Back Yard : Yard | Tree | DPW 1 | 10/03/2017 02:42:00 PM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
81645 | 47396 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 492 03rd Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/14/2002 12:00:00 AM | 3 | Permit Number 45308 | 5995005.9977 | 2112260.59137 | 37.7795776757203 | -122.46088255216 | (37.7795776757203, -122.46088255216) | 11 | 6 | 2 | 54 | 11 | |
83365 | 6755 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1215 Fairfax Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/03/2017 06:41:00 AM | 3 | 3x3 | 6017521.0990665 | 2096743.3718322 | 37.7382404347673 | -122.381912713319 | (37.7382404347673, -122.381912713319) | 10 | 3 | 8 | 58 | 1 | ||
85859 | 258498 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 379 Arleta Ave | 1 | Sidewalk: Curb side : | Tree | DPW 1 | 6009061.07772 | 2088406.01218 | 37.7148769915418 | -122.41057481256 | (37.7148769915418, -122.41057481256) | 9 | 7 | 8 | 309 | 39 | |||||
89050 | 103865 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1424 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006775 | 2115831.4 | 37.7900523957484 | -122.420421968076 | (37.7900523957484, -122.420421968076) | 13 | 9 | 10 | 28858 | 21 | ||
91960 | 103860 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1475 Polk St | 4 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006677 | 2115920.4 | 37.7902912446707 | -122.420767361582 | (37.7902912446707, -122.420767361582) | 13 | 9 | 10 | 28858 | 21 | ||
92614 | 109488 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1314 POLK ST | 3 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 01/23/2016 04:53:00 AM | 3 | 3x3 | 6006825.7 | 2115468.8 | 37.7890596427133 | -122.420220804515 | (37.7890596427133, -122.420220804515) | 13 | 9 | 10 | 28858 | 21 | ||
95991 | 253541 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1000 Cayuga Ave | 9 | Back Yard : Yard | Tree | DPW 1 | 10/03/2017 03:59:00 PM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
102492 | 103866 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1411 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006684.9 | 2115784.5 | 37.7899185422019 | -122.420730376301 | (37.7899185422019, -122.420730376301) | 13 | 9 | 10 | 28858 | 21 | ||
104295 | 47397 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 492 03rd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/14/2002 12:00:00 AM | 2 | Permit Number 45308 | 5995007.08219 | 2112241.09178 | 37.7795241974528 | -122.460877386845 | (37.7795241974528, -122.460877386845) | 11 | 6 | 2 | 54 | 11 | |
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 | ||
105559 | 103810 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1145 Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006819.8 | 2114898.5 | 37.7874934070669 | -122.420200726176 | (37.7874934070669, -122.420200726176) | 13 | 9 | 10 | 28858 | 21 | ||
106265 | 253543 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1000 Cayuga Ave | 11 | Back Yard : Yard | Tree | DPW 1 | 10/03/2017 02:35:00 PM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
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 | |||
108440 | 17981 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2583 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/28/2014 12:00:00 AM | 3 | 3x3 | 6001557.63 | 2114929.1565 | 37.7872796746141 | -122.438408931359 | (37.7872796746141, -122.438408931359) | 13 | 6 | 11 | 29490 | 27 | ||
111438 | 1922 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 66 Berkeley Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/08/2016 02:50:00 PM | 3 | 3x3 | 6001235.3932896 | 2097346.6778621 | 37.7389841732277 | -122.438263722762 | (37.7389841732277, -122.438263722762) | 2 | 7 | 5 | 63 | 7 | ||
118918 | 253544 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1000 Cayuga Ave | 12 | Back Yard : Yard | Tree | DPW 1 | 10/03/2017 02:38:00 PM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
119007 | 109908 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1401 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/18/2015 02:04:00 PM | 3 | 3x3 | Permit Number 778313 | 6008340.42119 | 2109862.66125 | 37.7737517633724 | -122.414583173274 | (37.7737517633724, -122.414583173274) | 8 | 2 | 9 | 28853 | 34 | |
123403 | 94055 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 179 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/22/2010 12:00:00 AM | 3 | 3x9 | 6005293.28741 | 2109516.64513 | 37.7726300238656 | -122.42509907481 | (37.7726300238656, -122.42509907481) | 7 | 9 | 11 | 28852 | 10 | ||
126116 | 236828 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 11 Woodland Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/10/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 783065 | 5997011.57389 | 2106623.6128 | 37.7642151878129 | -122.453537316698 | (37.7642151878129, -122.453537316698) | 15 | 5 | 11 | 29492 | 12 | |
128715 | 103863 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1435 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006674.8 | 2115856.4 | 37.790115392534 | -122.42077042798 | (37.790115392534, -122.42077042798) | 13 | 9 | 10 | 28858 | 21 | ||
128948 | 103768 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1323 Polk St | 2 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006757 | 2115467 | 37.7890508291132 | -122.420458370284 | (37.7890508291132, -122.420458370284) | 13 | 9 | 10 | 28858 | 21 | ||
131007 | 103774 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1288 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006856.2 | 2115250.5 | 37.7884619632914 | -122.420099779635 | (37.7884619632914, -122.420099779635) | 13 | 9 | 10 | 28858 | 21 | ||
131049 | 150163 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1091 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2018 12:00:00 AM | 0 | Width 3ft | 6014400.34034 | 2105251.569 | 37.7614293111323 | -122.393298054181 | (37.7614293111323, -122.393298054181) | 10 | 3 | 8 | 28856 | 29 | ||
131845 | 253506 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1401 Fulton St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6001009 | 2111012 | 37.7764929420148 | -122.440026085657 | (37.7764929420148, -122.440026085657) | 15 | 5 | 11 | 29492 | 10 | ||||
132118 | 147269 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 319 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 4ft | 5987740.91933 | 2113799.84011 | 37.7833833082347 | -122.48612828182 | (37.7833833082347, -122.48612828182) | 11 | 6 | 2 | 55 | 26 | |||
132302 | 143863 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3131 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 4ft | 5985738.04922 | 2113178.19583 | 37.78155952089 | -122.493011518265 | (37.78155952089, -122.493011518265) | 11 | 6 | 2 | 55 | 26 | |||
133305 | 124465 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 325 Willard St North | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 3 | Width 3ft | 5996246.86985 | 2110596.93026 | 37.77508102137 | -122.4564695325 | (37.77508102137, -122.4564695325) | 11 | 6 | 2 | 54 | 16 | |
139510 | 254105 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3107 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 5985853 | 2113163 | 37.7815245194182 | -122.492612729734 | (37.7815245194182, -122.492612729734) | 11 | 6 | 2 | 55 | 26 | ||||
144751 | 109487 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1314 POLK ST | 2 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 10/31/2017 02:27:00 PM | 3 | 3x3 | 6006825.7 | 2115468.8 | 37.7890596427133 | -122.420220804515 | (37.7890596427133, -122.420220804515) | 13 | 9 | 10 | 28858 | 21 | ||
145436 | 147382 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 735 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2018 12:00:00 AM | 3 | 3x5 | 5988794.34162 | 2110291.35438 | 37.7738113254544 | -122.482226768263 | (37.7738113254544, -122.482226768263) | 11 | 6 | 2 | 55 | 26 | ||
149876 | 103868 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1411 Polk St | 3 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006684.9 | 2115784.5 | 37.7899185422019 | -122.420730376301 | (37.7899185422019, -122.420730376301) | 13 | 9 | 10 | 28858 | 21 | ||
150561 | 150166 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1091 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2018 12:00:00 AM | 0 | Width 3ft | 6014482.7986 | 2105256.28423 | 37.7614468389081 | -122.393013193016 | (37.7614468389081, -122.393013193016) | 10 | 3 | 8 | 28856 | 29 | ||
151406 | 143864 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3123 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 4ft | 5985786.64325 | 2113178.68848 | 37.7815637153323 | -122.492843444866 | (37.7815637153323, -122.492843444866) | 11 | 6 | 2 | 55 | 26 | |||
151626 | 103864 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1435 Polk St | 2 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006674.8 | 2115856.4 | 37.790115392534 | -122.42077042798 | (37.790115392534, -122.42077042798) | 13 | 9 | 10 | 28858 | 21 | ||
152426 | 450 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 700x 23rd Ave | 10 | Median : Cutout | Tree | DPW 1 | 05/29/2015 01:42:00 PM | 3 | 5988819.93055 | 2110324.80979 | 37.773904673102 | -122.482140704549 | (37.773904673102, -122.482140704549) | 11 | 6 | 2 | 55 | 26 | |||
154786 | 248942 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1500x Galvez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 03/18/2017 12:56:00 PM | 3 | 3x3 | 6016393 | 2097292 | 37.7396844950272 | -122.385851388433 | (37.7396844950272, -122.385851388433) | 10 | 3 | 8 | 58 | 1 | |
154917 | 26561 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 430 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 3 | 3X3 | 6010306.7503709 | 2097855.6706051 | 37.7408935295991 | -122.406934857164 | (37.7408935295991, -122.406934857164) | 10 | 3 | 7 | 58 | 2 | ||
155187 | 103861 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1436 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006766.2 | 2115894.4 | 37.7902248822442 | -122.420456889097 | (37.7902248822442, -122.420456889097) | 13 | 9 | 10 | 28858 | 21 | ||
160290 | 254859 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1940 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 3 | 3x3 | 5999835 | 2111295 | 37.7772030846682 | -122.444107613365 | (37.7772030846682, -122.444107613365) | 15 | 5 | 11 | 29490 | 16 | |
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 | |||
163713 | 253540 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1000 Cayuga Ave | 8 | Back Yard : Yard | Tree | DPW 1 | 10/03/2017 04:11:00 PM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
163849 | 8230 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1500X Galvez Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/10/2015 08:33:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.7396967491289 | -122.385840466933 | (37.7396967491289, -122.385840466933) | 10 | 3 | 8 | 58 | 1 | ||
165177 | 103867 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1411 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006684.9 | 2115784.5 | 37.7899185422019 | -122.420730376301 | (37.7899185422019, -122.420730376301) | 13 | 9 | 10 | 28858 | 21 | ||
166987 | 254106 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3129 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x4 | 5985757 | 2113159 | 37.7815079229311 | -122.492944544174 | (37.7815079229311, -122.492944544174) | 11 | 6 | 2 | 55 | 26 | ||||
174738 | 202868 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 721 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2018 12:00:00 AM | 0 | Width 3ft | 6011581.65303 | 2104944.91806 | 37.7604303154251 | -122.403025207773 | (37.7604303154251, -122.403025207773) | 10 | 3 | 8 | 28856 | 29 | ||
176203 | 103811 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1145 Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006819.8 | 2114898.5 | 37.7874934070669 | -122.420200726176 | (37.7874934070669, -122.420200726176) | 13 | 9 | 10 | 28858 | 21 | ||
180872 | 122238 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1645 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2018 12:00:00 AM | 3 | Width 5ft | 5990263.53816 | 2114709.99218 | 37.786029027112 | -122.477467650491 | (37.786029027112, -122.477467650491) | 11 | 6 | 2 | 55 | 26 | ||
180960 | 94054 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 185 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/22/2010 12:00:00 AM | 3 | 3x9 | 6005268.81764 | 2109524.34557 | 37.7726497850887 | -122.425184266439 | (37.7726497850887, -122.425184266439) | 7 | 9 | 11 | 28852 | 10 | ||
183758 | 8223 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1500X Galvez Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/10/2015 08:24:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.7396967491289 | -122.385840466933 | (37.7396967491289, -122.385840466933) | 10 | 3 | 8 | 58 | 1 | ||
186711 | 5393 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 347 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/10/2014 12:00:00 AM | 3 | 6x7 | 6004928.4905 | 2106245.94468 | 37.7636288523174 | -122.426128059965 | (37.7636288523174, -122.426128059965) | 8 | 4 | 5 | 28859 | 19 | ||
188424 | 143862 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3141 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 4ft | 5985712.91878 | 2113178.76157 | 37.781559604533 | -122.493098498008 | (37.781559604533, -122.493098498008) | 11 | 6 | 2 | 55 | 26 |
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) );