trees
858 rows where qSpecies_id = 85 sorted by PlotSize
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
849 | 51822 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 11 | Permit Number 48062 | 6008911.92726 | 2109811.9687 | 37.7736446648878 | -122.412602652111 | (37.7736446648878, -122.412602652111) | 8 | 2 | 9 | 28853 | 34 | ||
2231 | 245261 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1350 Noe St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6003201.63898 | 2100380.79003 | 37.7474267787221 | -122.431681919499 | (37.7474267787221, -122.431681919499) | 2 | 4 | 5 | 63 | 22 | ||||
2442 | 35339 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 740 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 9 | Permit Number 38804 | 6013014.621 | 2103534.39703 | 37.7566372493387 | -122.397970249845 | (37.7566372493387, -122.397970249845) | 10 | 3 | 8 | 28856 | 29 | |
5526 | 71641 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1327 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6011027.0266 | 2119468.0848 | 37.800276548465 | -122.405966529737 | (37.800276548465, -122.405966529737) | 3 | 1 | 10 | 308 | 23 | |||
6527 | 40000 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 881 Innes Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 14 | Permit Number 41257 | 6019376.91864 | 2094304.02926 | 37.7316447838739 | -122.375327100491 | (37.7316447838739, -122.375327100491) | 10 | 3 | 8 | 58 | 1 | |
7978 | 81424 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 936 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6008224.91775 | 2115730.6565 | 37.7898573783726 | -122.415398222545 | (37.7898573783726, -122.415398222545) | 5 | 1 | 10 | 28858 | 21 | |||
10272 | 80644 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 369 Gaven St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6008610.79188 | 2094726.87163 | 37.7322074806863 | -122.412577751678 | (37.7322074806863, -122.412577751678) | 9 | 3 | 7 | 309 | 28 | |||
11004 | 51713 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 175@ 6th ST Bluxome St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2019 12:00:00 AM | 3 | Permit Number 47987 | 6012693.61148 | 2110101.74925 | 37.7746518507372 | -122.399541492249 | (37.7746518507372, -122.399541492249) | 14 | 2 | 9 | 28856 | 20 | ||
11748 | 61613 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1546 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/19/1984 12:00:00 AM | 17 | Permit Number 21590 | 6006691.8914 | 2116275.8765 | 37.7912681342545 | -122.42074108486 | (37.7912681342545, -122.42074108486) | 13 | 9 | 10 | 28858 | 21 | |
12232 | 240848 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 450 Florida St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6009181.67793 | 2106295.69441 | 37.7640049263208 | -122.411421075131 | (37.7640049263208, -122.411421075131) | 8 | 4 | 7 | 28859 | 19 | ||||
13586 | 32270 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1654 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1996 12:00:00 AM | 13 | Permit Number 36856 | 6002284.74056 | 2121254.77264 | 37.8046895029868 | -122.436346174145 | (37.8046895029868, -122.436346174145) | 13 | 9 | 1 | 57 | 17 | ||
14849 | 179597 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 25 Otsego Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6000936.4483 | 2092902.26266 | 37.7267638312622 | -122.438978907964 | (37.7267638312622, -122.438978907964) | 9 | 7 | 6 | 28861 | 25 | ||||
15102 | 49150 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 4199 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2003 12:00:00 AM | Permit Number 46273 | 6003544.55958588 | 2093981.972593 | 37.7298765227481 | -122.430039732071 | (37.7298765227481, -122.430039732071) | 9 | 7 | 6 | 28861 | 5 | |||
15752 | 62590 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 3550 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1986 12:00:00 AM | 12 | Permit Number 22896 | 5984601.92533 | 2110430.06768 | 37.7739474449292 | -122.496739029498 | (37.7739474449292, -122.496739029498) | 11 | 6 | 2 | 55 | 26 | |
16751 | 78587 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1361 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6012314.29117 | 2102093.10716 | 37.7526407529845 | -122.400291031321 | (37.7526407529845, -122.400291031321) | 10 | 3 | 8 | 28856 | 29 | |||
17510 | 70565 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 210 Townsend St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6014527.51657 | 2111489.70716 | 37.7785649223813 | -122.39329474466 | (37.7785649223813, -122.39329474466) | 6 | 2 | 9 | 28856 | 34 | |||
18132 | 38160 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 48 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | Permit Number 773760 | 6009245.10254035 | 2094077.23333811 | 37.7304592916016 | -122.41033893557 | (37.7304592916016, -122.41033893557) | 9 | 3 | 7 | 309 | 28 | |
18241 | 215179 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 747 Detroit St | 12 | Side Yard : Yard | Tree | Private 2 | 5 | 5999425.63373 | 2095397.4728 | 37.7335290182456 | -122.444380974518 | (37.7335290182456, -122.444380974518) | 9 | 7 | 4 | 59 | 40 | ||||
18467 | 51710 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 175@ 6th ST Bluxome St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2019 12:00:00 AM | 3 | Permit Number 47987 | 6012671.60652 | 2110080.29176 | 37.7745917067712 | -122.399616105424 | (37.7745917067712, -122.399616105424) | 14 | 2 | 9 | 28856 | 20 | ||
19243 | 197785 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2347 19th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6010748.45807 | 2105046.89477 | 37.7606637578537 | -122.405914042413 | (37.7606637578537, -122.405914042413) | 10 | 3 | 8 | 28856 | 29 | ||||
19679 | 40601 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1745 Alameda St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/2003 12:00:00 AM | 13 | Permit Number 47084 | 6011717.76597 | 2107914.27714 | 37.7685911090192 | -122.402763284706 | (37.7685911090192, -122.402763284706) | 8 | 2 | 8 | 28853 | 20 | |
19713 | 50720 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1350 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/01/2004 12:00:00 AM | Permit Number 47273 | 5999239.23876402 | 2108409.63945521 | 37.7692466150992 | -122.44596095669 | (37.7692466150992, -122.44596095669) | 15 | 5 | 11 | 29492 | 9 | ||
19979 | 41630 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 175 Bluxome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2005 12:00:00 AM | 11 | Permit Number 47987 | 6012549.77298 | 2109959.42064 | 37.7742530301757 | -122.400029064208 | (37.7742530301757, -122.400029064208) | 14 | 2 | 9 | 28856 | 20 | ||
20367 | 52364 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1030@ CEDAR Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | 8 | Permit Number 48499 | 6006935.64598 | 2114546.93824 | 37.7865346316038 | -122.419774966644 | (37.7865346316038, -122.419774966644) | 13 | 9 | 9 | 28858 | 36 | |
20782 | 40002 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 881 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 8 | Permit Number 41257 | 6019340.13593 | 2094332.72798 | 37.731721560802 | -122.375456255711 | (37.731721560802, -122.375456255711) | 10 | 3 | 8 | 58 | 1 | |
21167 | 179605 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 247 Mount Vernon Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 5998680.84891 | 2089595.4146 | 37.7175553958555 | -122.446538611763 | (37.7175553958555, -122.446538611763) | 9 | 7 | 6 | 28861 | 25 | ||||
22473 | 37940 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 728 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/21/2003 12:00:00 AM | 12 | Permit Number 46514 | 6015675.91863 | 2103966.98263 | 37.7579728963479 | -122.388796638862 | (37.7579728963479, -122.388796638862) | 10 | 3 | 8 | 28856 | 29 | |
23586 | 51714 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 175@ 6th ST Bluxome St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2005 12:00:00 AM | 14 | Permit Number 47987 | 6012645.95948 | 2110058.2702 | 37.7745298109235 | -122.399703277606 | (37.7745298109235, -122.399703277606) | 14 | 2 | 9 | 28856 | 20 | ||
24014 | 62260 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 126 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/07/1985 12:00:00 AM | 12 | Permit Number 22386 | 6000410.66201 | 2092263.48087 | 37.7249799531412 | -122.440750730657 | (37.7249799531412, -122.440750730657) | 9 | 7 | 6 | 28861 | 25 | |
26447 | 42664 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 780 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2011 12:00:00 AM | 6 | Permit Number 768090 | 6007065.06318 | 2121240.35517 | 37.8049203715397 | -122.419802335728 | (37.8049203715397, -122.419802335728) | 5 | 1 | 1 | 28858 | 32 | ||
27265 | 45778 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1033 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2001 12:00:00 AM | 14 | Permit Number 44419 | 6006891.87332 | 2114501.10639 | 37.7864063226311 | -122.41992315605 | (37.7864063226311, -122.41992315605) | 13 | 9 | 10 | 28858 | 36 | ||
27267 | 73457 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 33 Rausch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2015 12:00:00 AM | 3 | Permit Number 774688 | 6009719.27808 | 2110896.03825 | 37.7766665443529 | -122.40988643061 | (37.7766665443529, -122.40988643061) | 8 | 2 | 9 | 28853 | 34 | ||
27271 | 50760 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1247 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2004 12:00:00 AM | Permit Number 47299 | 6009900.23371634 | 2109608.97618966 | 37.7731427119765 | -122.409169607112 | (37.7731427119765, -122.409169607112) | 14 | 2 | 9 | 28853 | 34 | |||
28707 | 50621 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 820 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2003 12:00:00 AM | Permit Number 47218 | 6019242.65386152 | 2094476.11509562 | 37.7321099088197 | -122.375803212343 | (37.7321099088197, -122.375803212343) | 10 | 3 | 8 | 58 | 1 | |||
33656 | 179619 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 104 Burrows St | 2 | Side Yard : Yard | Tree | Private 2 | 4 | 6011168.71552 | 2093496.29206 | 37.7289717927968 | -122.4036478336 | (37.7289717927968, -122.4036478336) | 10 | 3 | 7 | 309 | 28 | ||||
33843 | 51717 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 175@ 6th ST Bluxome St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2005 12:00:00 AM | 12 | Permit Number 47987 | 6012600.34291 | 2110009.85826 | 37.7743943397653 | -122.399857674991 | (37.7743943397653, -122.399857674991) | 14 | 2 | 9 | 28856 | 20 | ||
36658 | 66354 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 334 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1990 12:00:00 AM | 13 | Permit Number 29475 | 6003787.88189 | 2089236.55246 | 37.7168604267574 | -122.428860361341 | (37.7168604267574, -122.428860361341) | 9 | 7 | 6 | 28861 | 5 | ||
37599 | 51826 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 15 | Permit Number 48062 | 6008951.49863 | 2109770.91917 | 37.7735341733012 | -122.412462865995 | (37.7735341733012, -122.412462865995) | 8 | 2 | 9 | 28853 | 34 | ||
39190 | 41631 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 175 Bluxome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2005 12:00:00 AM | 13 | Permit Number 47987 | 6012575.96802 | 2109987.3858 | 37.7743312765925 | -122.399940414441 | (37.7743312765925, -122.399940414441) | 14 | 2 | 9 | 28856 | 20 | ||
39234 | 51943 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 3724 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2005 12:00:00 AM | Permit Number 48168 | 6004898.66350081 | 2102543.97492913 | 37.7534624298516 | -122.425967681323 | (37.7534624298516, -122.425967681323) | 2 | 4 | 5 | 28862 | 22 | |||
40405 | 48612 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 201 Ulloa St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | Permit Number 45914 | 5996181.58703013 | 2099061.98037763 | 37.7434052350482 | -122.455861320442 | (37.7434052350482, -122.455861320442) | 1 | 5 | 4 | 59 | 40 | ||
41439 | 50825 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 260 San Leandro Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/2004 12:00:00 AM | Permit Number 47345 | 5992354.32900617 | 2095121.08916568 | 37.7323641420519 | -122.468808176404 | (37.7323641420519, -122.468808176404) | 9 | 8 | 4 | 59 | 40 | |||
46103 | 39999 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 881 Innes Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 13 | Permit Number 41257 | 6019347.79521 | 2094325.03679 | 37.7317008637943 | -122.375429242788 | (37.7317008637943, -122.375429242788) | 10 | 3 | 8 | 58 | 1 | |
46814 | 51711 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 175@ 6th ST Bluxome St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2005 12:00:00 AM | Permit Number 47987 | 6012686.20544956 | 2110082.45661085 | 37.7745984647237 | -122.399565756547 | (37.7745984647237, -122.399565756547) | 14 | 2 | 9 | 28856 | 20 | |||
46902 | 95103 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2200@Broderick Beach St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/08/2008 12:00:00 AM | 12 | 5999638.34857 | 2120885.83168 | 37.8035257685578 | -122.445477697742 | (37.8035257685578, -122.445477697742) | 13 | 9 | 1 | 57 | 17 | |||
46969 | 43209 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 33 University St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 15 | Permit Number 43000 | 6007755.9781 | 2093953.95749 | 37.7300372142398 | -122.415478343147 | (37.7300372142398, -122.415478343147) | 9 | 3 | 7 | 309 | 28 | |
47199 | 42979 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 308 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | 10 | Permit Number 42863 | 6006597.58462 | 2092494.33475 | 37.7259642287513 | -122.419379553644 | (37.7259642287513, -122.419379553644) | 9 | 7 | 7 | 309 | 5 | |
47899 | 215180 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 48 Melrose Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 5999778.0534 | 2095525.26911 | 37.7339000182695 | -122.443171738004 | (37.7339000182695, -122.443171738004) | 9 | 7 | 4 | 63 | 40 | ||||
48581 | 121492 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1809 19th St | 1 | Front Yard : Yard | Tree | Private 2 | 13 | 6012288.86366 | 2105128.25072 | 37.760973173204 | -122.400592156703 | (37.760973173204, -122.400592156703) | 10 | 3 | 8 | 28856 | 29 | ||||
49411 | 51824 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 12 | Permit Number 48062 | 6008839.3407 | 2109885.31137 | 37.7738419725734 | -122.412858927409 | (37.7738419725734, -122.412858927409) | 8 | 2 | 9 | 28853 | 34 | ||
49931 | 50761 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1247 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2004 12:00:00 AM | Permit Number 47299 | 6009900.23371634 | 2109608.97618966 | 37.7731427119765 | -122.409169607112 | (37.7731427119765, -122.409169607112) | 14 | 2 | 9 | 28853 | 34 | |||
53030 | 60578 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 801 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1982 12:00:00 AM | 10 | Permit Number 20192 | 6015478.27896 | 2103906.06329 | 37.7577946687129 | -122.389475912095 | (37.7577946687129, -122.389475912095) | 10 | 3 | 8 | 28856 | 29 | ||
53573 | 93802 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 21 Bishop St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 6010948.90983 | 2089721.21702 | 37.7185939356312 | -122.404142145962 | (37.7185939356312, -122.404142145962) | 10 | 7 | 8 | 309 | 39 | ||||
54197 | 51828 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 11 | Permit Number 48062 | 6008816.98399 | 2109909.48162 | 37.7739070834758 | -122.412937972431 | (37.7739070834758, -122.412937972431) | 8 | 2 | 9 | 28853 | 34 | ||
54708 | 45779 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1033 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2005 12:00:00 AM | 13 | Permit Number 48205 | 6006884.42122 | 2114521.64488 | 37.7864622964456 | -122.419950396487 | (37.7864622964456, -122.419950396487) | 13 | 9 | 10 | 28858 | 36 | |
55030 | 116917 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 252 HERMANN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 6004064 | 2108728 | 37.7703950777069 | -122.429295062823 | (37.7703950777069, -122.429295062823) | 7 | 9 | 11 | 29492 | 10 | ||||
55640 | 31053 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 40 South Hill Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 10 | Permit Number 34806 | 6002711.16213 | 2087562.81668 | 37.7122037138071 | -122.432462573298 | (37.7122037138071, -122.432462573298) | 9 | 7 | 6 | 28861 | 5 | |
56765 | 111767 | Undocumented 4 | Syagrus romanzoffianum :: Queen Palm 85 | 4966 17th St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5997580.2349427 | 2105651.04183436 | 37.7615773358373 | -122.45150033551 | (37.7615773358373, -122.45150033551) | 15 | 5 | 11 | 29492 | 9 | |||||
57294 | 87534 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2515 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 6010931.8007 | 2093898.1841 | 37.7300620671282 | -122.404495148402 | (37.7300620671282, -122.404495148402) | 10 | 3 | 7 | 309 | 28 | ||||
58557 | 95102 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 2200 Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2008 12:00:00 AM | 5999690 | 2120891 | 37.8035429078816 | -122.445299328106 | (37.8035429078816, -122.445299328106) | 13 | 9 | 1 | 57 | 17 | ||||
58846 | 51534 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 772 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2005 12:00:00 AM | 10 | Permit Number 47835 | 6012007.91318 | 2110835.16017 | 37.7766273842858 | -122.401965041949 | (37.7766273842858, -122.401965041949) | 14 | 2 | 9 | 28856 | 34 | ||
59274 | 85361 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 30 Dore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/2007 12:00:00 AM | 12 | Permit Number 49638 | 6008746.14707 | 2109938.9547 | 37.7739840330773 | -122.413185094432 | (37.7739840330773, -122.413185094432) | 8 | 2 | 9 | 28853 | 34 | ||
61723 | 111634 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 85 | 3009 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6009514.91537658 | 2100993.40768569 | 37.7494647260255 | -122.40989418187 | (37.7494647260255, -122.40989418187) | 2 | 4 | 7 | 28859 | 19 | |||
61990 | 40622 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 2675 Taylor St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1999 12:00:00 AM | Permit Number 41626 | 6008278.01579529 | 2121980.95813259 | 37.8070221359583 | -122.415657237402 | (37.8070221359583, -122.415657237402) | 5 | 1 | 10 | 308 | 23 | |||
63418 | 43902 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1938 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2000 12:00:00 AM | 11 | Permit Number 43504 | 6013487.64027 | 2095982.13361 | 37.735926667475 | -122.395805194058 | (37.735926667475, -122.395805194058) | 10 | 3 | 8 | 58 | 1 | ||
63657 | 51599 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1288 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/04/2005 12:00:00 AM | Permit Number 47893 | 6002992.45198434 | 2111708.96678382 | 37.7785193529519 | -122.433214576841 | (37.7785193529519, -122.433214576841) | 15 | 9 | 11 | 29490 | 41 | |||
64188 | 40003 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 881 Innes Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 8 | Permit Number 41257 | 6019368.47353 | 2094309.06128 | 37.7316581360927 | -122.375356645916 | (37.7316581360927, -122.375356645916) | 10 | 3 | 8 | 58 | 1 | |
67452 | 46436 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 160 Corwin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/2002 12:00:00 AM | Permit Number 44654 | 6000678.81028631 | 2104119.18809943 | 37.7575481921194 | -122.44067377633 | (37.7575481921194, -122.44067377633) | 2 | 4 | 5 | 28862 | 38 | |||
68638 | 57152 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1548 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1974 12:00:00 AM | Permit Number 53479 | 6007084.13005826 | 2107360.24310609 | 37.7668100557647 | -122.41875139025 | (37.7668100557647, -122.41875139025) | 8 | 4 | 7 | 28853 | 19 | |||
70636 | 33147 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2301 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 1 | Permit Number 37372 | 5987301.0757 | 2099570.9968 | 37.7442891825609 | -122.486604840877 | (37.7442891825609, -122.486604840877) | 1 | 8 | 3 | 29491 | 35 | |
70738 | 197763 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1405 Minnesota St | 1 | Back Yard : Yard | Tree | Private 2 | 3 | 6015410.29997 | 2101920.42662 | 37.7523387624307 | -122.389572339186 | (37.7523387624307, -122.389572339186) | 10 | 3 | 8 | 28856 | 1 | ||||
71401 | 48528 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 350(REVISED) Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | Permit Number 45846 | 6002907.64330557 | 2106199.19589491 | 37.763386065819 | -122.433114190665 | (37.763386065819, -122.433114190665) | 15 | 4 | 5 | 28862 | 3 | |||
74104 | 40001 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 881 Innes Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 12 | Permit Number 41257 | 6019355.96693 | 2094318.55144 | 37.7316835059849 | -122.375400541805 | (37.7316835059849, -122.375400541805) | 10 | 3 | 8 | 58 | 1 | |
74181 | 40602 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1745 Alameda St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/2003 12:00:00 AM | 15 | Permit Number 47084 | 6011826.18199 | 2107919.61674 | 37.7686118231125 | -122.40238865592 | (37.7686118231125, -122.40238865592) | 8 | 2 | 8 | 28853 | 20 | |
76561 | 96527 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 206 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2011 12:00:00 AM | Permit Number 56866 | 6005415 | 2102506 | 37.7533873269869 | -122.424179377033 | (37.7533873269869, -122.424179377033) | 2 | 4 | 5 | 28859 | 19 | |||
78859 | 53588 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1409 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/1969 12:00:00 AM | 9 | Permit Number 6517 | 6006718.9791 | 2115736.7746 | 37.7897894207569 | -122.420609076139 | (37.7897894207569, -122.420609076139) | 13 | 9 | 10 | 28858 | 21 | ||
79080 | 64359 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 369 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1988 12:00:00 AM | 11 | Permit Number 25197 | 6011195.22959 | 2119324.38957 | 37.7998914022152 | -122.405374352958 | (37.7998914022152, -122.405374352958) | 3 | 1 | 10 | 308 | 23 | |
79374 | 52363 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1030@ CEDAR Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | 11 | Permit Number 48499 | 6006937.73357 | 2114525.88261 | 37.7864769356114 | -122.41976624951 | (37.7864769356114, -122.41976624951) | 13 | 9 | 9 | 28858 | 36 | |
79636 | 51823 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 13 | Permit Number 48062 | 6008893.04946 | 2109829.84045 | 37.7736926770172 | -122.412669217211 | (37.7736926770172, -122.412669217211) | 8 | 2 | 9 | 28853 | 34 | ||
79981 | 197760 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1221 Harrison St | 6 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | 6009984.84437 | 2109679.97053 | 37.773342385672 | -122.408881936452 | (37.773342385672, -122.408881936452) | 14 | 2 | 9 | 28853 | 34 | ||||
80860 | 33863 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 281 Clara St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/1997 12:00:00 AM | 9 | Permit Number 37859 | 6011402.4962 | 2111360.89694 | 37.7780371282385 | -122.404096375858 | (37.7780371282385, -122.404096375858) | 14 | 2 | 9 | 28856 | 34 | ||
82759 | 35347 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1141 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2014 12:00:00 AM | 10 | Permit Number 773064 | 6012246.4084 | 2103087.65437 | 37.7553677771151 | -122.400595641589 | (37.7553677771151, -122.400595641589) | 10 | 3 | 8 | 28856 | 29 | |
83463 | 62605 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 799 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/1986 12:00:00 AM | 14 | Permit Number 22913 | 5984493.96165 | 2110453.83892 | 37.774006387575 | -122.497114243221 | (37.774006387575, -122.497114243221) | 11 | 6 | 2 | 55 | 26 | ||
86009 | 40007 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 939 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 19 | Permit Number 41260 | 6019022.80772 | 2094568.61704 | 37.7323517975898 | -122.37656969105 | (37.7323517975898, -122.37656969105) | 10 | 3 | 8 | 58 | 1 | |
86596 | 253386 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 726 El Camino Del Mar | 1 | Front Yard : Cutout | Tree | Private 2 | 5986306 | 2114851 | 37.7861857583172 | -122.491169854158 | (37.7861857583172, -122.491169854158) | 11 | 6 | 1 | 55 | 33 | |||||
94598 | 240880 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2318 22nd St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6011232.06922 | 2103723.4899 | 37.7570570177965 | -122.40414829912 | (37.7570570177965, -122.40414829912) | 10 | 4 | 8 | 28859 | 19 | ||||
94918 | 61868 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1352 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/2005 12:00:00 AM | Permit Number 21908 | 6010316.20997421 | 2101337.00017342 | 37.7504530304494 | -122.407147486405 | (37.7504530304494, -122.407147486405) | 2 | 4 | 7 | 28859 | 19 | ||
94951 | 40575 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1745 Alameda St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 16 | Permit Number 42197 | 6011865.56753 | 2107924.68372 | 37.7686279344547 | -122.402252780039 | (37.7686279344547, -122.402252780039) | 8 | 2 | 8 | 28853 | 20 | |
96554 | 49572 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1250 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2003 12:00:00 AM | 7 | Permit Number 46457 | 6008112 | 2116793 | 37.7927679657247 | -122.41586416619 | (37.7927679657247, -122.41586416619) | 5 | 1 | 10 | 28858 | 21 | ||
96728 | 31051 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 40 South Hill Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 10 | Permit Number 34806 | 6002706.14254 | 2087539.54135 | 37.7121395201911 | -122.432478261058 | (37.7121395201911, -122.432478261058) | 9 | 7 | 6 | 28861 | 5 | |
96742 | 58378 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1020 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2013 12:00:00 AM | 4 | Permit Number 769968 | 6011874.40937 | 2103617.93894 | 37.7568030681131 | -122.401919409461 | (37.7568030681131, -122.401919409461) | 10 | 3 | 8 | 28856 | 29 | ||
100832 | 197769 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1301 Minnesota St | 54 | Front Yard : Yard | Tree | Private 2 | 7 | 6015357.64937 | 2102415.32545 | 37.7536947305524 | -122.389788979575 | (37.7536947305524, -122.389788979575) | 10 | 3 | 8 | 28856 | 29 | ||||
100870 | 54823 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1438 Underwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1972 12:00:00 AM | 7 | Permit Number 10677 | 6015466.1212 | 2093109.3415 | 37.7281484238722 | -122.388764251275 | (37.7281484238722, -122.388764251275) | 10 | 3 | 8 | 58 | 1 | ||
102852 | 253387 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 726 El Camino Del Mar | 2 | Front Yard : Cutout | Tree | Private 2 | 5986306 | 2114851 | 37.7861857583172 | -122.491169854158 | (37.7861857583172, -122.491169854158) | 11 | 6 | 1 | 55 | 33 | |||||
105569 | 49744 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 27 Bishop St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 12 | Permit Number 46543 | 6010938.20638 | 2089696.59945 | 37.7185257427455 | -122.404177411982 | (37.7185257427455, -122.404177411982) | 10 | 7 | 8 | 309 | 39 | |
108001 | 35885 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 65 Elmira St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1998 12:00:00 AM | 3 | Permit Number 39085 | 6011186.47786 | 2096510.21791 | 37.7372483911964 | -122.403798418789 | (37.7372483911964, -122.403798418789) | 10 | 3 | 8 | 58 | 1 | |
108605 | 179608 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 239 Naples St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6004077.01735 | 2092129.72211 | 37.7248207965363 | -122.428067019004 | (37.7248207965363, -122.428067019004) | 9 | 7 | 6 | 28861 | 5 | ||||
108934 | 104726 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 85 | 1079 Church St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 770313 | 6004474.7 | 2102638.1 | 37.7536969056436 | -122.427440543051 | (37.7536969056436, -122.427440543051) | 2 | 4 | 5 | 28862 | 22 | ||||
109530 | 34193 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 353 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/1997 12:00:00 AM | 11 | Permit Number 38012 | 6014082.04806 | 2105345.22896 | 37.7616687924926 | -122.394405461342 | (37.7616687924926, -122.394405461342) | 10 | 3 | 8 | 28856 | 29 | ||
109883 | 240849 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 450 Florida St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6009178.7151 | 2106293.81333 | 37.7639995951253 | -122.411431189821 | (37.7639995951253, -122.411431189821) | 8 | 4 | 7 | 28859 | 19 |
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) );