979 rows where qSpecies_id = 13 sorted by PlantDate

View and edit SQL

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)
558 230313 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 968 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6010194.52879 2103588.60829 37.7566286356186 -122.407727015404 (37.7566286356186, -122.407727015404) 2 4 7 28859 19
863 230293 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 3500 19th St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 5ft Permit Number 769041 6006188.70146 2104951.15176 37.7601448013679 -122.421677407793 (37.7601448013679, -122.421677407793) 2 4 5 28859 19
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
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
2106 193374 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 778 Tehama St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6008975.96564 2110229.86919 37.7747957152898 -122.412410677425 (37.7747957152898, -122.412410677425) 8 2 9 28853 34
2501 78191 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 680 Tennessee St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     6015407.71241 2105894.14692 37.7632496064147 -122.389858829046 (37.7632496064147, -122.389858829046) 14 3 8 28856 29
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
3141 117754 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 406 39th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   5983780.49053 2113060.07342 37.7811205143771 -122.499774894109 (37.7811205143771, -122.499774894109) 11 6 2 55 26
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
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
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
4490 224675 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 121 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6007745.9196 2107233.93005 37.7665004685576 -122.4164534151 (37.7665004685576, -122.4164534151) 8 4 7 28853 19
4664 171655 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 101 Princeton St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x5   6007664.95872 2093252.16101 37.7281051161408 -122.415743336498 (37.7281051161408, -122.415743336498) 9 3 7 309 5
4773 165865 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 275 Bonview St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 3x4   6006836.83511 2097542.23848 37.7398381374333 -122.418910337746 (37.7398381374333, -122.418910337746) 2 7 7 28859 2
4996 255545 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 201X San Carlos St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006716 2104916 37.7600780028247 -122.419851234809 (37.7600780028247, -122.419851234809) 2 4 7 28859 19
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
5290 89193 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 370 03rd St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013271 2113050 37.7827792408585 -122.397751016594 (37.7827792408585, -122.397751016594) 6 2 9 28856 34
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
5427 146424 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2131 North Point St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6000557.07663 2120624.21431 37.8028598421591 -122.442279615007 (37.8028598421591, -122.442279615007) 13 9 1 57 17
5638 89169 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 370 03rd St 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013271 2113050 37.7827792408585 -122.397751016594 (37.7827792408585, -122.397751016594) 6 2 9 28856 34
5720 80737 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 186 Allison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     6000043.55254 2087718.30936 37.7124790304587 -122.44169374357 (37.7124790304587, -122.44169374357) 9 7 6 28861 5
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
5797 230342 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 65 Chenery St 7 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6004911.05921 2097907.10852 37.7407313620627 -122.425594827655 (37.7407313620627, -122.425594827655) 2 7 5 63 7
6004 230296 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 3500 19th St 5 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 5ft Permit Number 769041 6006123.35153 2104947.42015 37.7601308699707 -122.421903157405 (37.7601308699707, -122.421903157405) 2 4 5 28859 19
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
7003 177395 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 715 Madrid St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6001937.65614 2089768.77997 37.7182169074587 -122.435293726344 (37.7182169074587, -122.435293726344) 9 7 6 28861 5
7285 261471 Undocumented 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1785 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005616 2107209 37.7663120077949 -122.423818660091 (37.7663120077949, -122.423818660091) 8 4 5 28853 19
7356 71615 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 536 40th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   2     5983503.66193 2112151.1699 37.7786086821922 -122.500665338334 (37.7786086821922, -122.500665338334) 11 6 2 55 26
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
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
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
9085 119446 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 885 32nd Ave 2 Sidewalk: Property side : Yard Tree Private 2     2 Width 6ft   5985992 2109886 37.7725349378609 -122.491890533583 (37.7725349378609, -122.491890533583) 11 6 2 55 26
9101 149740 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 600 San Bruno Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     0 5x5   6010932.22924 2105459.16725 37.7618060416252 -122.405307491047 (37.7618060416252, -122.405307491047) 10 3 8 28856 29
9116 229637 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 209 Nevada St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6009018.53484 2097336.36234 37.7393954533353 -122.411352367829 (37.7393954533353, -122.411352367829) 10 7 7 28859 2
10033 80634 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 577 Arkansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     6013018.0309 2104352.7115 37.7588843520526 -122.398015861652 (37.7588843520526, -122.398015861652) 10 3 8 28856 29
10144 97101 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1096@Jones Pine St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008668 2115966 37.7905284677514 -122.413881848265 (37.7905284677514, -122.413881848265) 5 1 10 28857 21
10157 124335 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 176 Palm Ave 2 Sidewalk: Curb side : Pot Tree Private 2     2 Width 2ft   5995959.20478 2113110.98096 37.7819674207447 -122.457646568088 (37.7819674207447, -122.457646568088) 11 6 1 54 31
10512 230294 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 3500 19th St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 5ft Permit Number 769041 6006176.61067 2104951.77673 37.760145835588 -122.421719268545 (37.760145835588, -122.421719268545) 2 4 5 28859 19
10935 230295 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 3500 19th St 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 5ft Permit Number 769041 6006165.12102 2104950.71502 37.7601422724637 -122.421758930432 (37.7601422724637, -122.421758930432) 2 4 5 28859 19
11103 149739 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 600 San Bruno Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 5x5   6010931.02944 2105481.85704 37.7618682756098 -122.405313238612 (37.7618682756098, -122.405313238612) 10 3 8 28856 29
11108 86883 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 550 Jersey St   Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 49808 6001589 2101474 37.750336931821 -122.43733657342 (37.750336931821, -122.43733657342) 2 4 5 28862 22
11300 159230 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 144 Naglee Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x5   5998399.17588 2087828.03812 37.712686491475 -122.44738508425 (37.712686491475, -122.44738508425) 9 7 6 28861 25
11428 122390 Undocumented 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1958 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x2   5991007 2102078 37.7513881006776 -122.473973545995 (37.7513881006776, -122.473973545995) 1 8 4 29491 12
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
11517 72252 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 531 Madrid St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     6002585.93283 2090796.9641 37.7210768666757 -122.433126335006 (37.7210768666757, -122.433126335006) 9 7 6 28861 5
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
12009 162257 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 778 Girard St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 4x5   6011373.11147 2091245.9028 37.7228041046152 -122.402783015826 (37.7228041046152, -122.402783015826) 10 3 7 309 28
12319 149738 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 600 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 5x5   6010928.54307 2105503.65431 37.7619279870025 -122.405323373095 (37.7619279870025, -122.405323373095) 10 3 8 28856 29
12327 230292 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 3500 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 5ft Permit Number 769041 6006199.95177 2104950.54929 37.7601437815195 -122.421638455465 (37.7601437815195, -122.421638455465) 2 4 5 28859 19
12333 95563 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 497 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   6003239 2102086.6 37.7521126499553 -122.431674496468 (37.7521126499553, -122.431674496468) 2 4 5 28862 22
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
13984 115980 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2x Olmstead St 5 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6011593.71434 2091235.60939 37.7227881560287 -122.402019710862 (37.7227881560287, -122.402019710862) 10 3 7 309 28
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
15021 160935 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 528 Lisbon St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 5x5   6001887.44706 2090275.94834 37.7196066271205 -122.435503539072 (37.7196066271205, -122.435503539072) 9 7 6 28861 5
15592 261192 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 600X Benton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007231 2095349 37.7338381748563 -122.417392087376 (37.7338381748563, -122.417392087376) 2 7 7 28859 2
15878 165756 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 673 Moultrie St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x5   6007653.4982 2096223.70099 37.7362636749309 -122.415993302149 (37.7362636749309, -122.415993302149) 2 7 7 28859 2
16255 130986 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 3147 Gough St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6004613.79741 2120397.19916 37.8024668888085 -122.428225084716 (37.8024668888085, -122.428225084716) 13 9 1 57 17
16696 195151 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1912 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 3x3   6012043 2105629 37.7623344042956 -122.401477690357 (37.7623344042956, -122.401477690357) 8 3 8 28856 29
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
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
18901 230332 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 73 Leese St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6005526.20735 2096295.99594 37.736342348511 -122.423353372654 (37.736342348511, -122.423353372654) 2 7 7 28859 2
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
20727 130987 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1332 Bush St 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6006981.76642 2115388.70116 37.7888485036088 -122.419675148215 (37.7888485036088, -122.419675148215) 13 9 10 28858 21
21174 177436 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 99 Karen Ct 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6010107.2934 2091444.47715 37.7232785896114 -122.407172691281 (37.7232785896114, -122.407172691281) 10 3 7 309 28
21267 177432 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 66 Gladstone Dr 1 Sidewalk: Curb side : Pot Tree Private 2     3 Width 2ft   6006350.82649 2094014.80407 37.730125204807 -122.420340452271 (37.730125204807, -122.420340452271) 9 7 7 28861 5
21421 193318 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 136 Hawthorne St 4 : Tree Private 2     10 Width 2ft   6013332.96782 2113640.49809 37.7844040630434 -122.397578060899 (37.7844040630434, -122.397578060899) 6 2 9 28856 6
21530 120427 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 459 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5989038.74655 2112201.43488 37.7790700882049 -122.481521260476 (37.7790700882049, -122.481521260476) 11 6 2 55 26
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
21839 230285 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 112 27th St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   6005732.266 2100246.49817 37.7472011631029 -122.422921627052 (37.7472011631029, -122.422921627052) 2 7 5 28859 22
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
24096 105848 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 790 Tehama St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6008900 2110136 37.7745337092857 -122.412666821872 (37.7745337092857, -122.412666821872) 8 2 9 28853 34
24131 177447 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 762 Prague St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6002442.74838 2087164.23323 37.7110940664123 -122.433361825211 (37.7110940664123, -122.433361825211) 9 7 6 28861 5
24707 230280 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 201 Webster St 3 : Tree Private 2     2 Width 3ft   6004189.92363 2109488.51079 37.7724903832539 -122.428913720795 (37.7724903832539, -122.428913720795) 7 9 11 29492 10
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
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
25495 208853 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 54 Martha Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 2ft   6000650.73977 2095621.13276 37.7342129598544 -122.440161475975 (37.7342129598544, -122.440161475975) 9 7 5 63 40
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
26858 193333 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1258 Minnesota St 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6015305.27356 2102653.19148 37.7543449556813 -122.389986723422 (37.7543449556813, -122.389986723422) 10 3 8 28856 29
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
27143 193373 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 77 Beale St 10 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6013783.27133 2116255.65231 37.7916097334637 -122.396203501097 (37.7916097334637, -122.396203501097) 12 2 9 28855 6
27525 230338 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 31 Walter St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6003171.49131 2108119.01737 37.7686723924455 -122.43233874923 (37.7686723924455, -122.43233874923) 15 5 5 28862 3
29659 250186 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 665 Parker Ave 3 : Tree Private 2     2 Width 4ft   5997220.39466 2110886.14724 37.7759309780695 -122.4531227967 (37.7759309780695, -122.4531227967) 15 6 2 54 16
30292 230302 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2908 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6009976.47339 2101651.34742 37.7512971397648 -122.408344495308 (37.7512971397648, -122.408344495308) 2 4 7 28859 19
30764 97025 Property Tree 8 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
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
31341 230282 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 175 Haight St 1 : Tree Private 2     3 Width 3ft   6005285.87309 2109545.94561 37.7727100570619 -122.425126806975 (37.7727100570619, -122.425126806975) 7 9 11 28852 10
32076 208848 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 281 Lobos St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5994210.24416 2088699.7294 37.7148396860693 -122.461926423875 (37.7148396860693, -122.461926423875) 9 8 6 28861 24
32238 177429 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 278 Ney St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6005195.23308 2094056.19803 37.7301736773527 -122.424338433387 (37.7301736773527, -122.424338433387) 9 7 6 28861 5
32359 193327 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1398 Tennessee St 4 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 5ft   6015585.42977 2102602.25227 37.7542206208044 -122.389014307158 (37.7542206208044, -122.389014307158) 10 3 8 28856 29
32889 193331 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1258 Minnesota St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6015302.57075 2102682.83592 37.754426203129 -122.38999814121 (37.754426203129, -122.38999814121) 10 3 8 28856 29
33124 218387 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 50 San Marcos Ave 9 Sidewalk: Curb side : Yard Tree Private 2     2 Width 0ft   5993857.52408 2100226.90247 37.7464701590844 -122.463981819901 (37.7464701590844, -122.463981819901) 1 8 4 29491 40
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
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
33693 230355 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 397 30th St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6004002.34815 2098351.08289 37.7418990256315 -122.428768448829 (37.7418990256315, -122.428768448829) 2 7 5 63 7
33699 230351 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 132 Moffitt St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6002667.45566 2096824.4771 37.7376316768553 -122.433275010943 (37.7376316768553, -122.433275010943) 2 7 5 63 7
33704 249813 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 260 Chestnut St 3 Front Yard : Yard Tree Private 2     3 Width 0ft   6010621.11973 2121031.89357 37.8045476726861 -122.407481446514 (37.8045476726861, -122.407481446514) 3 1 10 308 23
34068 119038 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 675 44th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 4ft   5982249.27103 2111200.72651 37.7759253222044 -122.504934234985 (37.7759253222044, -122.504934234985) 11 6 2 55 26
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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);