trees
979 rows where qSpecies_id = 13 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2825 | 92602 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2201 Baker St | 11 | 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 | ||
4377 | 88323 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 125 Lisbon St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51312 | 6003417 | 2092629 | 37.7261543381556 | -122.430384225952 | (37.7261543381556, -122.430384225952) | 9 | 7 | 6 | 28861 | 5 | |||
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 | ||||
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 | |||||
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 | ||||
7146 | 112795 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1235 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2015 12:00:00 AM | 3x3 | 5983624.1 | 2106731.7 | 37.7637354441658 | -122.499848016409 | (37.7637354441658, -122.499848016409) | 1 | 8 | 3 | 56 | 35 | |||
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 | ||||
8586 | 50836 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 202 Kirkham St | 2 | 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 | |||
9218 | 106080 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 188 The Embarcadero | 1 | Front Yard : Yard | Tree | Private 2 | 03/20/2014 12:00:00 AM | Permit Number 771259 | 6015087.8131 | 2116516.98611 | 37.7923997963133 | -122.391708043282 | (37.7923997963133, -122.391708043282) | 12 | 2 | 9 | 28855 | 6 | |||
9598 | 99292 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1300 Minnesota St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2012 12:00:00 AM | 3x3 | Permit Number 768897 | 6015320.4 | 2102511.6 | 37.753957014382 | -122.389924521932 | (37.753957014382, -122.389924521932) | 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 | ||||
10565 | 65035 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1205 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51820 | 6003879.11104946 | 2101261.18670708 | 37.7498825208731 | -122.429402039878 | (37.7498825208731, -122.429402039878) | 2 | 4 | 5 | 28862 | 22 | ||
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 | ||||
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 | |||
12106 | 112557 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 35 DOLORES ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/28/2015 12:00:00 AM | 3x3 | 6004913 | 2108042 | 37.7685595148495 | -122.426309519551 | (37.7685595148495, -122.426309519551) | 8 | 4 | 5 | 28853 | 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 | |||
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 | ||||
15864 | 112555 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 35 DOLORES ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/28/2015 12:00:00 AM | 3x3 | 6004913 | 2108042 | 37.7685595148495 | -122.426309519551 | (37.7685595148495, -122.426309519551) | 8 | 4 | 5 | 28853 | 19 | |||
16524 | 84225 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1361 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50686 | 6011917.47723073 | 2088615.29524593 | 37.7156113688947 | -122.400716532679 | (37.7156113688947, -122.400716532679) | 10 | 7 | 8 | 309 | 39 | ||
17107 | 82354 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 254 Dublin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50649 | 6004015.90676212 | 2089097.25184538 | 37.7164908413301 | -122.428062269463 | (37.7164908413301, -122.428062269463) | 9 | 7 | 6 | 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 | |||
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 | |||
25966 | 95564 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 497 Elizabeth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767357 | 6003239 | 2102086.6 | 37.7521126499553 | -122.431674496468 | (37.7521126499553, -122.431674496468) | 2 | 4 | 5 | 28862 | 22 | |
26931 | 37803 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 465 Woolsey St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010402.90992445 | 2091781.87036726 | 37.7242215408534 | -122.406174555323 | (37.7242215408534, -122.406174555323) | 10 | 3 | 7 | 309 | 28 | ||
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 | ||
28421 | 95734 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 626 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767481 | 6002384.8 | 2090170.7 | 37.7193458734928 | -122.433776853042 | (37.7193458734928, -122.433776853042) | 9 | 7 | 6 | 28861 | 5 | |
28513 | 37585 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 210 Eagle St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | Permit Number 40016 | 5999628.99810136 | 2104552.86123042 | 37.7586791121732 | -122.444335603116 | (37.7586791121732, -122.444335603116) | 2 | 4 | 5 | 28862 | 3 | ||
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 | |||
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 | ||
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 | ||||
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 | ||
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 | |||
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 | ||||
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 | |||
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 | |||
45290 | 112888 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3980 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/2015 12:00:00 AM | Permit Number 774440 | 5995705.4 | 2115208.7 | 37.7877126116995 | -122.458676518899 | (37.7877126116995, -122.458676518899) | 11 | 6 | 1 | 54 | 31 | |||
45409 | 114908 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 281 LOBOS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994225 | 2088676 | 37.714775380269 | -122.461873702271 | (37.714775380269, -122.461873702271) | 9 | 8 | 6 | 28861 | 24 | ||||
46594 | 112556 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 35 DOLORES ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/28/2015 12:00:00 AM | 3x3 | 6004913 | 2108042 | 37.7685595148495 | -122.426309519551 | (37.7685595148495, -122.426309519551) | 8 | 4 | 5 | 28853 | 19 | |||
46621 | 88242 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2501 Turk Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51228 | 5998431.6 | 2111697.4 | 37.7782278105943 | -122.448991394173 | (37.7782278105943, -122.448991394173) | 15 | 6 | 2 | 54 | 16 | ||
48245 | 96117 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 201 Andover St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767772 | 6007577 | 2097739 | 37.7404200508617 | -122.416365084697 | (37.7404200508617, -122.416365084697) | 2 | 7 | 7 | 28859 | 2 | |
48862 | 87126 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 438 33rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2008 12:00:00 AM | 3x3 | Permit Number 50074 | 5985668.2 | 2112929.7 | 37.7808731376826 | -122.493234847229 | (37.7808731376826, -122.493234847229) | 11 | 6 | 2 | 55 | 26 | ||
49147 | 95703 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 497 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767357 | 6003239 | 2102086.6 | 37.7521126499553 | -122.431674496468 | (37.7521126499553, -122.431674496468) | 2 | 4 | 5 | 28862 | 22 | |
49485 | 95113 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 887 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2010 12:00:00 AM | 3x3 | Permit Number 54041 | 6001057 | 2091844.3 | 37.7238657652599 | -122.438486397461 | (37.7238657652599, -122.438486397461) | 9 | 7 | 6 | 28861 | 25 | |
51683 | 87914 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 101 Wool St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50936 | 6007398 | 2097753 | 37.7404484242714 | -122.41698498961 | (37.7404484242714, -122.41698498961) | 2 | 7 | 7 | 28859 | 2 | ||
52836 | 88007 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1394 Masonic Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/15/2010 12:00:00 AM | 3x3 | Permit Number 53732 | 5999618.7 | 2107794 | 37.7675778847064 | -122.444604170057 | (37.7675778847064, -122.444604170057) | 15 | 5 | 11 | 29492 | 9 | |
53186 | 109760 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3590 20TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | 3x3 | Permit Number 772584 | 6006354 | 2104372 | 37.7585639052988 | -122.421064595152 | (37.7585639052988, -122.421064595152) | 2 | 4 | 7 | 28859 | 19 | ||
53411 | 114722 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 465 Woolsey St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010466.6 | 2091788 | 37.7242419338513 | -122.405954818575 | (37.7242419338513, -122.405954818575) | 10 | 3 | 7 | 309 | 28 | |||
55630 | 95830 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 5 Lucerne St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/2011 12:00:00 AM | 3x3 | Permit Number 767564 | 6011975 | 2109856 | 37.7739369979495 | -122.402010048031 | (37.7739369979495, -122.402010048031) | 14 | 2 | 9 | 28853 | 34 | |
56875 | 82146 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1083 Portola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2008 12:00:00 AM | 3x3 | Permit Number 51167 | 5995391.16373818 | 2098013.23554983 | 37.7404802453018 | -122.458518484651 | (37.7404802453018, -122.458518484651) | 9 | 7 | 4 | 59 | 40 | ||
57445 | 94819 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1551 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53898 | 5993027.2 | 2104915.2 | 37.7592951275131 | -122.467193784759 | (37.7592951275131, -122.467193784759) | 1 | 8 | 4 | 56 | 12 | |
57946 | 88834 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 156 Collins St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2008 12:00:00 AM | 3x3 | Permit Number 51716 | 5998112 | 2113497 | 37.7831507592552 | -122.450226753873 | (37.7831507592552, -122.450226753873) | 15 | 6 | 1 | 54 | 31 | |||
58308 | 104296 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 4267 24TH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 770781 | 6001461 | 2101700 | 37.7509501962946 | -122.437795389969 | (37.7509501962946, -122.437795389969) | 2 | 4 | 5 | 28862 | 22 | ||||
58995 | 87898 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 700 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50917 | 6007438 | 2097723.6 | 37.7403699483878 | -122.416844602518 | (37.7403699483878, -122.416844602518) | 2 | 7 | 7 | 28859 | 2 | ||
59519 | 95549 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1712 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767351 | 6002582 | 2100598 | 37.7479880436154 | -122.433840109923 | (37.7479880436154, -122.433840109923) | 2 | 4 | 5 | 63 | 22 | |
59609 | 255543 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 201X San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006716 | 2104916 | 37.7600780028247 | -122.419851234809 | (37.7600780028247, -122.419851234809) | 2 | 4 | 7 | 28859 | 19 | ||||
60421 | 112587 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 790 Tehama St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008900 | 2110136 | 37.7745337092857 | -122.412666821872 | (37.7745337092857, -122.412666821872) | 8 | 2 | 9 | 28853 | 34 | ||||
60873 | 99585 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 301X Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2013 12:00:00 AM | 6003014.6 | 2106437.9 | 37.7640475560396 | -122.432761315556 | (37.7640475560396, -122.432761315556) | 15 | 4 | 5 | 28862 | 3 | ||||
62045 | 49067 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1298 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50555 | 5995836.31315767 | 2092013.47244835 | 37.7240319217297 | -122.45654557668 | (37.7240319217297, -122.45654557668) | 9 | 8 | 4 | 28861 | 40 | ||
62070 | 115256 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 277 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | Permit Number 773180 | 5995612.8 | 2091840.6 | 37.7235444201772 | -122.457305721784 | (37.7235444201772, -122.457305721784) | 9 | 8 | 4 | 28861 | 24 | |||
62564 | 87900 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 700 Eugenia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50917 | 6007438 | 2097723.6 | 37.7403699483878 | -122.416844602518 | (37.7403699483878, -122.416844602518) | 2 | 7 | 7 | 28859 | 2 | ||
63096 | 39742 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 4248 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50468 | 6002277.29168205 | 2104153.16512299 | 37.7577323837885 | -122.435148020003 | (37.7577323837885, -122.435148020003) | 2 | 4 | 5 | 28862 | 3 | ||
63821 | 94705 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 682 12th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53845 | 5992291.3 | 2110837.3 | 37.7755131276945 | -122.470170100471 | (37.7755131276945, -122.470170100471) | 11 | 6 | 2 | 54 | 11 | ||
65376 | 88526 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1680 McAllister St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51817 | 6001106 | 2111441 | 37.7776763890724 | -122.439721299373 | (37.7776763890724, -122.439721299373) | 15 | 5 | 11 | 29490 | 41 | |||
65512 | 108459 | Private 9 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 771 11th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 773786 | 5992558.08669 | 2110211.94426 | 37.7738114893979 | -122.469201704334 | (37.7738114893979, -122.469201704334) | 11 | 6 | 2 | 54 | 11 | |||
66254 | 51656 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 949 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50463 | 6003796.70592748 | 2102740.00151399 | 37.7539383334149 | -122.42979246605 | (37.7539383334149, -122.42979246605) | 2 | 4 | 5 | 28862 | 22 | ||
66397 | 84634 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 361 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50931 | 6008966.27725874 | 2096629.00783692 | 37.7374502806236 | -122.411483091014 | (37.7374502806236, -122.411483091014) | 10 | 7 | 7 | 28859 | 2 | ||
66805 | 258499 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 379 Arleta Ave | 1 | Sidewalk: Curb side : | Tree | DPW 1 | 6009061.07772 | 2088406.01218 | 37.7148769915418 | -122.41057481256 | (37.7148769915418, -122.41057481256) | 9 | 7 | 8 | 309 | 39 | |||||
67330 | 96066 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 957 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767691 | 6008013 | 2102358 | 37.7531273009994 | -122.415184444517 | (37.7531273009994, -122.415184444517) | 2 | 4 | 7 | 28859 | 19 | |
67384 | 112573 | Section 143 10 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 56 ROCKWOOD CT | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x6 | Permit Number 776002 | 5995685 | 2098946 | 37.7430582687021 | -122.457569991387 | (37.7430582687021, -122.457569991387) | 1 | 8 | 4 | 59 | 40 | ||
69766 | 82961 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3925 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50821 | 6002789.88777109 | 2105883.76961321 | 37.7625133012574 | -122.433498925711 | (37.7625133012574, -122.433498925711) | 15 | 4 | 5 | 28862 | 3 | ||
70116 | 88597 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 77 Jordan Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2008 12:00:00 AM | 3x3 | Permit Number 51542 | 5996162.8 | 2114014.5 | 37.7844599367093 | -122.457007600103 | (37.7844599367093, -122.457007600103) | 11 | 6 | 1 | 54 | 31 | |||
73635 | 98412 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 55 19th Ave | 4 | Sidewalk: Curb side : | Tree | Private 2 | 02/09/2012 12:00:00 AM | Permit Number 768592 | 5990099.2 | 2106073.1 | 37.7623049568555 | -122.477404745944 | (37.7623049568555, -122.477404745944) | 1 | 8 | 3 | 56 | 35 | |||
73758 | 53191 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 720@ 20TH ST. Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50943 | 6002391.64717096 | 2103940.90451156 | 37.7571560601551 | -122.434737353785 | (37.7571560601551, -122.434737353785) | 2 | 4 | 5 | 28862 | 3 | ||
74030 | 97099 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1096@Jones Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008668 | 2115966 | 37.7905284677514 | -122.413881848265 | (37.7905284677514, -122.413881848265) | 5 | 1 | 10 | 28857 | 21 | ||||
75809 | 109758 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3590 20TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | 3x3 | Permit Number 772584 | 6006354 | 2104372 | 37.7585639052988 | -122.421064595152 | (37.7585639052988, -122.421064595152) | 2 | 4 | 7 | 28859 | 19 | ||
76365 | 92601 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2201 Baker St | 10 | 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 | ||
76660 | 98411 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 55 19th Ave | 3 | Sidewalk: Curb side : | Tree | Private 2 | 02/09/2012 12:00:00 AM | Permit Number 768592 | 5990099.2 | 2106073.1 | 37.7623049568555 | -122.477404745944 | (37.7623049568555, -122.477404745944) | 1 | 8 | 3 | 56 | 35 | |||
78939 | 32526 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 871 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2015 12:00:00 AM | Permit Number 776214 | 6007576.4663397 | 2095282.92697428 | 37.7336761840288 | -122.416193025137 | (37.7336761840288, -122.416193025137) | 2 | 7 | 7 | 28859 | 2 | ||
79934 | 106843 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1869 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2014 12:00:00 AM | Permit Number 773317 | 6004088.44172 | 2118602.99638 | 37.7975107321666 | -122.429915018594 | (37.7975107321666, -122.429915018594) | 13 | 9 | 1 | 57 | 17 | |||
80624 | 98410 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 55 19th Ave | 2 | Sidewalk: Curb side : | Tree | Private 2 | 02/09/2012 12:00:00 AM | Permit Number 768592 | 5990099.2 | 2106073.1 | 37.7623049568555 | -122.477404745944 | (37.7623049568555, -122.477404745944) | 1 | 8 | 3 | 56 | 35 | |||
80677 | 114721 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 465 Woolsey St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010466.6 | 2091788 | 37.7242419338513 | -122.405954818575 | (37.7242419338513, -122.405954818575) | 10 | 3 | 7 | 309 | 28 | |||
81178 | 87912 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 101 Wool St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50936 | 6007398 | 2097753 | 37.7404484242714 | -122.41698498961 | (37.7404484242714, -122.41698498961) | 2 | 7 | 7 | 28859 | 2 | ||
82307 | 255594 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 199X San Carlos St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006714 | 2105007 | 37.7603277549802 | -122.419864609266 | (37.7603277549802, -122.419864609266) | 2 | 4 | 7 | 28859 | 19 | ||||
84024 | 96116 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 201 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767772 | 6007577 | 2097739 | 37.7404200508617 | -122.416365084697 | (37.7404200508617, -122.416365084697) | 2 | 7 | 7 | 28859 | 2 | |
85856 | 52415 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 445 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50993 | 5997805.99655674 | 2094075.37872241 | 37.729806319232 | -122.449885248514 | (37.729806319232, -122.449885248514) | 9 | 7 | 4 | 28861 | 40 | ||
85859 | 258498 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 379 Arleta Ave | 1 | Sidewalk: Curb side : | Tree | DPW 1 | 6009061.07772 | 2088406.01218 | 37.7148769915418 | -122.41057481256 | (37.7148769915418, -122.41057481256) | 9 | 7 | 8 | 309 | 39 | |||||
86141 | 88503 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 7 Wheat St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51441 | 6012178 | 2091435 | 37.7233682355202 | -122.400013942822 | (37.7233682355202, -122.400013942822) | 10 | 3 | 8 | 58 | 1 | |||
87081 | 89047 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 4552 19th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2008 12:00:00 AM | 3x3 | Permit Number 51787 | 6000860 | 2104654 | 37.7590269716409 | -122.440085499527 | (37.7590269716409, -122.440085499527) | 2 | 4 | 5 | 28862 | 3 | |||
88504 | 96118 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 201 Andover St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767772 | 6007577 | 2097739 | 37.7404200508617 | -122.416365084697 | (37.7404200508617, -122.416365084697) | 2 | 7 | 7 | 28859 | 2 | |
88916 | 95123 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 75 Oneida Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2010 12:00:00 AM | 3x3 | Permit Number 54050 | 6000595.4 | 2090675.6 | 37.7206305128633 | -122.439998309146 | (37.7206305128633, -122.439998309146) | 9 | 7 | 6 | 28861 | 25 | |
89411 | 255593 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 199X San Carlos St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006714 | 2105007 | 37.7603277549802 | -122.419864609266 | (37.7603277549802, -122.419864609266) | 2 | 4 | 7 | 28859 | 19 | ||||
89811 | 87785 | 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 | |||
91046 | 89190 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 370 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013271 | 2113050 | 37.7827792408585 | -122.397751016594 | (37.7827792408585, -122.397751016594) | 6 | 2 | 9 | 28856 | 34 | ||||
91671 | 112388 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 4200 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002010.54318716 | 2105309.8458945 | 37.7608931983337 | -122.436153317055 | (37.7608931983337, -122.436153317055) | 15 | 4 | 5 | 28862 | 3 | ||||
92704 | 88376 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 563 14th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51354 | 5991545.8 | 2111599.6 | 37.7775630683787 | -122.472804534873 | (37.7775630683787, -122.472804534873) | 11 | 6 | 2 | 54 | 26 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );