trees
979 rows where qSpecies_id = 13 sorted by PlantDate
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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) );