trees
979 rows where qSpecies_id = 13 sorted by qCareAssistant
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17760 | 158440 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 49 Van Buren St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2020 12:00:00 AM | 3 | 3x3 | Permit Number 785489 | 6002067.69843 | 2096375.7626 | 37.7363655681024 | -122.435316567307 | (37.7363655681024, -122.435316567307) | 2 | 7 | 5 | 63 | 7 | |
18060 | 258219 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 477 Eucalyptus Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/03/2019 12:00:00 AM | 3 | 3x3 | Permit Number 774069 | 5989683 | 2094686 | 37.7310148065902 | -122.478011682019 | (37.7310148065902, -122.478011682019) | 1 | 8 | 4 | 64 | 14 | |
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 | ||
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 | |||
18550 | 116935 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1275 Minnesota St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015368.35588 | 2102637.50716 | 37.7543053881926 | -122.389767471397 | (37.7543053881926, -122.389767471397) | 10 | 3 | 8 | 28856 | 29 | ||
18618 | 170106 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 527 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/18/2020 12:00:00 AM | 3 | 6x10 | Permit Number 783167 | 5997920.28587 | 2095246.22061 | 37.7330277118397 | -122.449574473879 | (37.7330277118397, -122.449574473879) | 9 | 7 | 4 | 59 | 40 | |
18657 | 251312 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1499 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2019 12:00:00 AM | 3 | 4x4 | Permit Number 779703 | 6003369 | 2099547 | 37.7451468706327 | -122.431043696183 | (37.7451468706327, -122.431043696183) | 2 | 7 | 5 | 63 | 22 | |
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 | |||
19852 | 33783 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 77 Beale St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774395 | 6013842.92338 | 2116188.62598 | 37.7914290137913 | -122.395992405042 | (37.7914290137913, -122.395992405042) | 12 | 2 | 9 | 28855 | 6 | |
19938 | 103781 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1237 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 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 | ||
20416 | 17382 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1627 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2015 12:00:00 AM | 1 | 3X3 | Permit Number 776412 | 6014690.32946 | 2095358.97831 | 37.7342824432881 | -122.39160343105 | (37.7342824432881, -122.39160343105) | 10 | 3 | 8 | 58 | 1 | |
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 | |||
21342 | 88261 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 229 Douglass St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51248 | 6001199 | 2104918 | 37.7597711445886 | -122.438931999231 | (37.7597711445886, -122.438931999231) | 2 | 4 | 5 | 28862 | 3 | |||
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 | |||
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 | ||
22457 | 93624 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 149 Collins St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2010 12:00:00 AM | Permit Number 53164 | 5998064 | 2113562 | 37.783326485193 | -122.450397500912 | (37.783326485193, -122.450397500912) | 15 | 6 | 1 | 54 | 31 | |||
23205 | 81367 | Undocumented 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1001 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 11/08/2003 12:00:00 AM | 3x3 | 6006914.85774282 | 2114314.60875621 | 37.7858955407321 | -122.419830397182 | (37.7858955407321, -122.419830397182) | 13 | 9 | 9 | 28858 | 36 | |||
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 | |||
24065 | 95100 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2200 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773992 | 5999642.14759 | 2120895.84862 | 37.8035534892505 | -122.445465271815 | (37.8035534892505, -122.445465271815) | 13 | 9 | 1 | 57 | 17 | |
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 | |||
24293 | 94928 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 929#4 Broderick St | Sidewalk: Curb side : | Landscaping | Private 2 | 12/08/2010 12:00:00 AM | 3 | 26x6 | Permit Number 54775 | 6000937 | 2111843 | 37.7787705583514 | -122.440334763546 | (37.7787705583514, -122.440334763546) | 15 | 5 | 11 | 29490 | 41 | ||
24379 | 84492 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1726 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50144 | 6014424.88297 | 2094914.9156 | 37.733048399857 | -122.392490121246 | (37.733048399857, -122.392490121246) | 10 | 3 | 8 | 58 | 1 | |
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 | |||
26112 | 112553 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 35 DOLORES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/28/2015 12:00:00 AM | 2 | 3x3 | 6004913 | 2108042 | 37.7685595148495 | -122.426309519551 | (37.7685595148495, -122.426309519551) | 8 | 4 | 5 | 28853 | 19 | ||
26576 | 173651 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 80 Entrada Ct | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/21/2016 12:00:00 AM | 3 | 4x10 | 5992424.45657 | 2092194.59394 | 37.7243327619491 | -122.468352901223 | (37.7243327619491, -122.468352901223) | 9 | 8 | 4 | 59 | 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 | |||
26944 | 105800 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 207 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2014 12:00:00 AM | 3 | Permit Number 769635 | 6010004.04754 | 2087785.06673 | 37.71322482385 | -122.407271751589 | (37.71322482385, -122.407271751589) | 9 | 7 | 8 | 309 | 39 | ||
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 | |||
27321 | 243475 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 109X Jarboe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779653 | 6007857.826 | 2097024.89565 | 37.7384750655589 | -122.415343555473 | (37.7384750655589, -122.415343555473) | 2 | 7 | 7 | 28859 | 2 | |
27335 | 50837 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 202 Kirkham St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2004 12:00:00 AM | Permit Number 47354 | 5994277.69303186 | 2105335.48637483 | 37.7605212305047 | -122.462899497742 | (37.7605212305047, -122.462899497742) | 1 | 5 | 11 | 56 | 12 | |||
27502 | 92600 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2201 Baker St | 9 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/25/2009 12:00:00 AM | 3x3 | Permit Number 52915 | 5999814 | 2116396 | 37.7912079107295 | -122.444546965455 | (37.7912079107295, -122.444546965455) | 13 | 6 | 1 | 29490 | 27 | ||
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 | |||
29086 | 112523 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 195 02nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2015 12:00:00 AM | 1 | 3x3 | Permit Number 776238 | 5995199.36548 | 2114291.31706 | 37.7851646286632 | -122.460360793578 | (37.7851646286632, -122.460360793578) | 11 | 6 | 2 | 54 | 11 | |
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 | |||
29687 | 88259 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1460 Clayton St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51244 | 5999422 | 2104472 | 37.758445274906 | -122.445045681381 | (37.758445274906, -122.445045681381) | 2 | 5 | 5 | 28862 | 3 | |||
29701 | 88320 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 645 France Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51311 | 6002646.5 | 2089495.7 | 37.7175073196157 | -122.432824059512 | (37.7175073196157, -122.432824059512) | 9 | 7 | 6 | 28861 | 5 | |||
29714 | 65128 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 184 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50320 | 5989636.73328 | 2114131.59369 | 37.7844045165702 | -122.47959386665 | (37.7844045165702, -122.47959386665) | 11 | 6 | 2 | 55 | 26 | |
30093 | 98453 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 518 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768642 | 6014340.87186 | 2104676.45619 | 37.7598468721503 | -122.393463482668 | (37.7598468721503, -122.393463482668) | 10 | 3 | 8 | 28856 | 29 | |
30146 | 87902 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 223 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50920 | 6007150.2 | 2097674.7 | 37.7402194874954 | -122.417836238094 | (37.7402194874954, -122.417836238094) | 2 | 7 | 7 | 28859 | 2 | ||
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 | |||
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 | |||
32475 | 255482 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1559 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2018 12:00:00 AM | 3 | 3x5 | 5993958 | 2104895 | 37.7592933500003 | -122.463973185629 | (37.7592933500003, -122.463973185629) | 1 | 8 | 4 | 56 | 12 | ||
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 | |||
32930 | 83189 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1670 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53556 | 5992811.58181355 | 2104100.90541778 | 37.7570468381941 | -122.467880263564 | (37.7570468381941, -122.467880263564) | 1 | 8 | 4 | 56 | 12 | ||
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 | |||
33479 | 116924 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 900x 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015542.44799 | 2102559.60008 | 37.7541011242826 | -122.389159972153 | (37.7541011242826, -122.389159972153) | 10 | 3 | 8 | 28856 | 29 | ||
33505 | 110563 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 135 Theresa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x9 | 6002082.974 | 2093709.61136 | 37.7290457953117 | -122.435073124425 | (37.7290457953117, -122.435073124425) | 9 | 7 | 6 | 28861 | 25 | |||
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 | |||
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 | |||
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 | ||
34124 | 99576 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 301X Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2012 12:00:00 AM | 3 | 3x3 | 768682 | 6002944.2 | 2106475.3 | 37.7641462544056 | -122.433007480488 | (37.7641462544056, -122.433007480488) | 15 | 4 | 5 | 28862 | 3 | |
34346 | 99307 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 59 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777839 | 6006944.8 | 2099028.3 | 37.7439246092205 | -122.418642395457 | (37.7439246092205, -122.418642395457) | 2 | 7 | 7 | 28859 | 2 | |
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 | |||
34827 | 103801 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1157 Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006858.38304 | 2114906.78358 | 37.7875183256613 | -122.420067824472 | (37.7875183256613, -122.420067824472) | 13 | 9 | 10 | 28858 | 21 | ||
34828 | 116927 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 900x 24th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015494.24319 | 2102557.91546 | 37.7540938262957 | -122.389326559889 | (37.7540938262957, -122.389326559889) | 10 | 3 | 8 | 28856 | 29 | ||
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 | |||
35612 | 255646 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1542 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2018 12:00:00 AM | 3 | 3x5 | Permit Number 779777 | 5989956.05847 | 2104865.26605 | 37.7589802621415 | -122.477811515827 | (37.7589802621415, -122.477811515827) | 1 | 8 | 3 | 56 | 35 | |
36556 | 88319 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 631 France Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51310 | 6002604.8 | 2089521.8 | 37.7175766192591 | -122.432970060785 | (37.7175766192591, -122.432970060785) | 9 | 7 | 6 | 28861 | 5 | |||
37097 | 193317 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 136 Hawthorne St | 3 | : | Tree | Private 2 | 9 | Width 2ft | 6013319.34244 | 2113654.62795 | 37.7844421016727 | -122.397626191699 | (37.7844421016727, -122.397626191699) | 6 | 2 | 9 | 28856 | 6 | |||
37490 | 113226 | Undocumented 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1118 POLK ST | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3x3 | 6006956 | 2114756 | 37.787109810462 | -122.419719385886 | (37.787109810462, -122.419719385886) | 13 | 9 | 10 | 28858 | 21 | ||||
37561 | 230306 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 65 Oakwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6005267.4467 | 2105080.91438 | 37.7604491067472 | -122.424872824933 | (37.7604491067472, -122.424872824933) | 2 | 4 | 5 | 28859 | 19 | |||
37616 | 230346 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1801 Church St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004582.48938 | 2098325.90354 | 37.7418627065067 | -122.426760715042 | (37.7418627065067, -122.426760715042) | 2 | 7 | 5 | 63 | 7 | |||
37880 | 53932 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 140 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/1972 12:00:00 AM | 1 | Permit Number 9646 | 5993064.17697 | 2114524.47346 | 37.7856817557629 | -122.467764782699 | (37.7856817557629, -122.467764782699) | 11 | 6 | 2 | 54 | 11 | ||
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 | ||
38136 | 230345 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1801 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004583.18993 | 2098311.13062 | 37.7418221830485 | -122.426757240969 | (37.7418221830485, -122.426757240969) | 2 | 7 | 5 | 63 | 7 | |||
38286 | 103800 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1157 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006858.38304 | 2114906.78358 | 37.7875183256613 | -122.420067824472 | (37.7875183256613, -122.420067824472) | 13 | 9 | 10 | 28858 | 21 | ||
38386 | 89162 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 370 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2008 12:00:00 AM | 3x3 | Permit Number 51807 | 6013271 | 2113050 | 37.7827792408585 | -122.397751016594 | (37.7827792408585, -122.397751016594) | 6 | 2 | 9 | 28856 | 34 | ||
38498 | 88312 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 518 Athens St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51303 | 6003514 | 2090320 | 37.7198198301278 | -122.429884275062 | (37.7198198301278, -122.429884275062) | 9 | 7 | 6 | 28861 | 5 | |||
38674 | 177406 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 618 Edinburgh St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002461.15734 | 2090172.80832 | 37.7193559950662 | -122.433513065093 | (37.7193559950662, -122.433513065093) | 9 | 7 | 6 | 28861 | 5 | |||
38952 | 177433 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 439 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008733.06168 | 2093861.61414 | 37.7298385306021 | -122.412093908309 | (37.7298385306021, -122.412093908309) | 9 | 3 | 7 | 309 | 28 | |||
39488 | 177445 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 15 Karen Ct | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6010506.33995 | 2091553.32971 | 37.7235998004623 | -122.405800920297 | (37.7235998004623, -122.405800920297) | 10 | 3 | 7 | 309 | 28 | |||
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 | ||
39755 | 247755 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 52 Alpine Ter | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6001613.95356 | 2108514.35375 | 37.7696694492075 | -122.437754457603 | (37.7696694492075, -122.437754457603) | 15 | 5 | 5 | 29492 | 9 | |||
39763 | 177405 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 688 Vienna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6002677.69306 | 2089500.91725 | 37.7175234141583 | -122.432716611994 | (37.7175234141583, -122.432716611994) | 9 | 7 | 6 | 28861 | 5 | |||
40035 | 105251 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 500 36th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2014 12:00:00 AM | 1 | Permit Number 771049 | 5984733.08187 | 2112389.43293 | 37.7793349822998 | -122.496429952441 | (37.7793349822998, -122.496429952441) | 11 | 6 | 2 | 55 | 26 | ||
40064 | 84782 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 228 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2007 12:00:00 AM | 5 | Permit No. 49243 | 6013990.15625 | 2105982.37522 | 37.7634131481085 | -122.394767902514 | (37.7634131481085, -122.394767902514) | 14 | 3 | 8 | 28856 | 29 | ||
40320 | 177441 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 71 Karen Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010258.66598 | 2091491.87018 | 37.7234171913236 | -122.406652760812 | (37.7234171913236, -122.406652760812) | 10 | 3 | 7 | 309 | 28 | |||
40470 | 87788 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 114 Theresa St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50526 | 6002199.1 | 2093679.9 | 37.7289708079503 | -122.434669544642 | (37.7289708079503, -122.434669544642) | 9 | 7 | 6 | 28861 | 25 | |||
41323 | 177426 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 125 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6003455.72001 | 2092686.06716 | 37.7263132250654 | -122.430254442684 | (37.7263132250654, -122.430254442684) | 9 | 7 | 6 | 28861 | 5 |
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) );