trees
1,746 rows where qSpecies_id = 10 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24550 | 43121 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 300 Elsie St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/2000 12:00:00 AM | Permit Number 42941 | 6006621.15716652 | 2097502.62281264 | 37.7397172147751 | -122.419653252856 | (37.7397172147751, -122.419653252856) | 2 | 7 | 7 | 28859 | 2 | ||
24917 | 33417 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 80 Westgate Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1996 12:00:00 AM | Permit Number 37527 | 5993258.22068719 | 2093571.67048868 | 37.7281619993725 | -122.465570716095 | (37.7281619993725, -122.465570716095) | 9 | 8 | 4 | 59 | 40 | ||
26385 | 31584 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1894 24th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/1995 12:00:00 AM | Permit Number 35120 | 5988803.26989649 | 2102446.27193627 | 37.7522713821241 | -122.481621183041 | (37.7522713821241, -122.481621183041) | 1 | 8 | 3 | 56 | 35 | ||
27275 | 43268 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 449 Holyoke St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | Permit Number 43044 | 6009825.48813974 | 2092359.64445753 | 37.7257756724777 | -122.408211357365 | (37.7257756724777, -122.408211357365) | 10 | 3 | 7 | 309 | 28 | ||
28913 | 42414 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 462 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42565 | 5998357.60439451 | 2094413.03350519 | 37.7307649857681 | -122.448002587308 | (37.7307649857681, -122.448002587308) | 9 | 7 | 4 | 59 | 40 | ||
29091 | 41414 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1101 Pacific Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/2000 12:00:00 AM | Permit Number 42026 | 6008853.95008654 | 2117958.40883134 | 37.7960095757906 | -122.413379432482 | (37.7960095757906, -122.413379432482) | 5 | 1 | 10 | 308 | 21 | |||
29753 | 69298 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1614 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/14/1994 12:00:00 AM | 14 | Permit Number 33372 | 6000007.5453 | 2110944.9306 | 37.776251725103 | -122.443485573615 | (37.776251725103, -122.443485573615) | 15 | 5 | 11 | 29492 | 16 | |
29850 | 43267 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 449 Holyoke St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | Permit Number 43044 | 6009825.48813974 | 2092359.64445753 | 37.7257756724777 | -122.408211357365 | (37.7257756724777, -122.408211357365) | 10 | 3 | 7 | 309 | 28 | ||
30110 | 210176 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 77 Mangels Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6000817.03746 | 2095186.42214 | 37.7330288117357 | -122.439555380593 | (37.7330288117357, -122.439555380593) | 9 | 7 | 5 | 63 | 40 | ||||
30669 | 40998 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1200 Illinois St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/1999 12:00:00 AM | Permit Number 41817 | 6016113.76612701 | 2103352.32554079 | 37.7563094360414 | -122.387239488996 | (37.7563094360414, -122.387239488996) | 10 | 3 | 8 | 28856 | 29 | |||
30783 | 42001 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 130 Manor Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2000 12:00:00 AM | Permit Number 42336 | 5993772.38783122 | 2093685.79470402 | 37.7285049990899 | -122.463801515353 | (37.7285049990899, -122.463801515353) | 9 | 8 | 4 | 59 | 40 | |||
31648 | 39798 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1920 41st Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41143 | 5983539.51267339 | 2102067.82749571 | 37.7509247944527 | -122.499795829171 | (37.7509247944527, -122.499795829171) | 1 | 8 | 3 | 29491 | 35 | ||
32010 | 41022 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1100 Illinois St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/1999 12:00:00 AM | Permit Number 41818 | 6016079.81700682 | 2103953.33797233 | 37.757957808739 | -122.387398822745 | (37.757957808739, -122.387398822745) | 10 | 3 | 8 | 28856 | 29 | |||
32971 | 38878 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 64 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40701 | 5995526.21364859 | 2115603.12418033 | 37.788785293559 | -122.459325039477 | (37.788785293559, -122.459325039477) | 11 | 6 | 1 | 54 | 31 | ||
32975 | 56049 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 345 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/1973 12:00:00 AM | 14 | Permit Number 12137 | 6014083.6423 | 2105399.63652 | 37.7618182724049 | -122.394403757141 | (37.7618182724049, -122.394403757141) | 10 | 3 | 8 | 28856 | 29 | ||
33183 | 39330 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 0 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40896 | 6017074.59942826 | 2104815.9109509 | 37.7603812969624 | -122.384018475054 | (37.7603812969624, -122.384018475054) | 10 | 3 | 8 | 310 | 29 | |||
33244 | 30872 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 587 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1995 12:00:00 AM | Permit Number 34706 | 5996404.87834636 | 2095840.32607721 | 37.7345721715471 | -122.45485651644 | (37.7345721715471, -122.45485651644) | 9 | 7 | 4 | 59 | 40 | |||
33523 | 35770 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 3678 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1998 12:00:00 AM | Permit Number 39029 | 6005058.98569186 | 2105477.55224933 | 37.7615264037651 | -122.425622026069 | (37.7615264037651, -122.425622026069) | 8 | 4 | 5 | 28859 | 19 | ||
33637 | 42425 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 571 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42576 | 5998313.53523714 | 2094957.68654916 | 37.7322579549975 | -122.448194144251 | (37.7322579549975, -122.448194144251) | 9 | 7 | 4 | 59 | 40 | ||
33785 | 42488 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 50 Phelan Ave | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997100.11501 | 2092805.52901 | 37.7262791995089 | -122.452233957334 | (37.7262791995089, -122.452233957334) | 9 | 7 | 4 | 28861 | 40 | ||
33875 | 41418 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1101 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/2000 12:00:00 AM | 6 | Permit Number 42026 | 6008769.45062 | 2117954.29462 | 37.7959935345349 | -122.413671526938 | (37.7959935345349, -122.413671526938) | 5 | 1 | 10 | 308 | 21 | ||
34777 | 35217 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 2349 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | Permit Number 40230 | 5992298.50027325 | 2099442.57015301 | 37.7442266120309 | -122.469315621961 | (37.7442266120309, -122.469315621961) | 1 | 8 | 4 | 29491 | 40 | ||
34916 | 33255 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2522 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/13/1996 12:00:00 AM | 7 | Permit Number 37433 | 5987086.6782 | 2098088.9597 | 37.7402074017234 | -122.487237339173 | (37.7402074017234, -122.487237339173) | 1 | 8 | 3 | 29491 | 35 | |
35122 | 202186 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1900 Armstrong Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6013197.89366 | 2093408.01538 | 37.7288425458475 | -122.396626579067 | (37.7288425458475, -122.396626579067) | 10 | 3 | 8 | 58 | 1 | ||||
35404 | 38127 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 2601 Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1998 12:00:00 AM | Permit Number 40291 | 5987686.55551532 | 2107103.11265871 | 37.7649928008384 | -122.485824675941 | (37.7649928008384, -122.485824675941) | 1 | 8 | 3 | 56 | 35 | ||
35951 | 39709 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 777 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41094 | 5996960.75086515 | 2094978.12726071 | 37.7322366517745 | -122.452872476937 | (37.7322366517745, -122.452872476937) | 9 | 7 | 4 | 59 | 40 | ||
36188 | 232101 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 3974 22nd St | 1 | Front Yard : Yard | Tree | Private 2 | 6 | 6002008.60082 | 2102955.96285 | 37.7544298930436 | -122.435991597528 | (37.7544298930436, -122.435991597528) | 2 | 4 | 5 | 28862 | 22 | ||||
36642 | 247979 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 501 Peralta Ave | 3 | Side Yard : Yard | Tree | Private 2 | 13 | 6009785.29961 | 2099426.45333 | 37.7451773638476 | -122.408848643569 | (37.7451773638476, -122.408848643569) | 2 | 7 | 7 | 28859 | 2 | ||||
37012 | 54473 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 75 Topeka Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/1972 12:00:00 AM | 11 | Permit Number 10265 | 6012333.35242 | 2095372.33986 | 37.73418801986 | -122.399753247508 | (37.73418801986, -122.399753247508) | 10 | 3 | 8 | 58 | 1 | ||
37131 | 43045 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2222 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2000 12:00:00 AM | 4 | Permit Number 42899 | 5984225.3291 | 2100029.5584 | 37.7453684881571 | -122.497273797993 | (37.7453684881571, -122.497273797993) | 1 | 8 | 3 | 29491 | 35 | |
37238 | 39807 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1920 41st Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41143 | 5983539.51267339 | 2102067.82749571 | 37.7509247944527 | -122.499795829171 | (37.7509247944527, -122.499795829171) | 1 | 8 | 3 | 29491 | 35 | ||
37242 | 39591 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 45 Southern Heights Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1998 12:00:00 AM | Permit Number 41001 | 6012325.10844747 | 2103966.01708403 | 37.7577839574034 | -122.400385164113 | (37.7577839574034, -122.400385164113) | 10 | 3 | 8 | 28856 | 29 | |||
37347 | 39524 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1330 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 10 | Permit Number 40968 | 6012453.7413 | 2107068.2011 | 37.7663090393741 | -122.400158161944 | (37.7663090393741, -122.400158161944) | 14 | 3 | 8 | 28856 | 20 | |
37994 | 39519 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1330 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 13 | Permit Number 40968 | 6012430.9158 | 2107067.2501 | 37.7663051554079 | -122.400237044743 | (37.7663051554079, -122.400237044743) | 14 | 3 | 8 | 28856 | 20 | |
38869 | 41019 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1100 Illinois St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/1999 12:00:00 AM | Permit Number 41818 | 6016079.81700682 | 2103953.33797233 | 37.757957808739 | -122.387398822745 | (37.757957808739, -122.387398822745) | 10 | 3 | 8 | 28856 | 29 | |||
40102 | 30859 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1256 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1995 12:00:00 AM | Permit Number 34699 | 5987105.97158028 | 2106720.29614463 | 37.7639078438446 | -122.487804616504 | (37.7639078438446, -122.487804616504) | 1 | 8 | 3 | 56 | 35 | |||
40184 | 52932 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 189 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | Permit Number 48918 | 6000194.36437989 | 2092360.19829328 | 37.7252331965683 | -122.441505382551 | (37.7252331965683, -122.441505382551) | 9 | 7 | 6 | 28861 | 25 | ||
40537 | 46684 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1507 26th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/2002 12:00:00 AM | 7 | Permit Number 44813 | 5988045.9304 | 2105005.4012 | 37.7592539929409 | -122.484427833563 | (37.7592539929409, -122.484427833563) | 1 | 8 | 3 | 56 | 35 | |
41220 | 33354 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 168 Kenwood Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42328 | 5994249.16422919 | 2093532.93310922 | 37.7281127414701 | -122.462142205261 | (37.7281127414701, -122.462142205261) | 9 | 8 | 4 | 59 | 40 | ||
41467 | 34200 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 310 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/1997 12:00:00 AM | Permit Number 38019 | 6004056.26152791 | 2096819.06663407 | 37.7376955101043 | -122.428472860635 | (37.7376955101043, -122.428472860635) | 2 | 7 | 5 | 63 | 7 | |||
41616 | 35270 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 249 Glenview Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | Permit Number 38754 | 5999067.663464 | 2100783.79548838 | 37.7482981400857 | -122.446005856491 | (37.7482981400857, -122.446005856491) | 2 | 5 | 5 | 63 | 38 | ||
41643 | 31101 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 25 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34831 | 6000068 | 2094066 | 37.7299097339823 | -122.442064596859 | (37.7299097339823, -122.442064596859) | 9 | 7 | 4 | 63 | 40 | ||
41998 | 41016 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1100 Illinois St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/1999 12:00:00 AM | Permit Number 41818 | 6016079.81700682 | 2103953.33797233 | 37.757957808739 | -122.387398822745 | (37.757957808739, -122.387398822745) | 10 | 3 | 8 | 28856 | 29 | |||
42704 | 41817 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 15 Encanto Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42203 | 6000006.05115839 | 2112265.23203581 | 37.7798768501445 | -122.443585609483 | (37.7798768501445, -122.443585609483) | 15 | 5 | 1 | 29490 | 16 | ||
43040 | 41409 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 3957 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42247 | 6003294.82239032 | 2104743.1831089 | 37.7594101598824 | -122.431671105438 | (37.7594101598824, -122.431671105438) | 2 | 4 | 5 | 28862 | 3 | ||
43556 | 115180 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2019 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 775162 | 5981635.3 | 2101323.4 | 37.7487688795742 | -122.506325467188 | (37.7487688795742, -122.506325467188) | 1 | 8 | 3 | 29491 | 35 | |||
43696 | 43112 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 200 Appleton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/13/2003 12:00:00 AM | Permit Number 42938 | 6005863.014 | 2096788.574 | 37.7377138611244 | -122.422223875233 | (37.7377138611244, -122.422223875233) | 2 | 7 | 7 | 28859 | 2 | ||
44393 | 42485 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 50 Phelan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/2002 12:00:00 AM | Permit Number 44826 | 5997092.52001 | 2092229.35701 | 37.7246967322782 | -122.452218657298 | (37.7246967322782, -122.452218657298) | 9 | 7 | 4 | 28861 | 40 | ||
44717 | 41015 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1100 Illinois St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/1999 12:00:00 AM | Permit Number 41818 | 6016079.81700682 | 2103953.33797233 | 37.757957808739 | -122.387398822745 | (37.757957808739, -122.387398822745) | 10 | 3 | 8 | 28856 | 29 | |||
44757 | 41021 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1100 Illinois St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/1999 12:00:00 AM | Permit Number 41818 | 6016079.81700682 | 2103953.33797233 | 37.757957808739 | -122.387398822745 | (37.757957808739, -122.387398822745) | 10 | 3 | 8 | 28856 | 29 | |||
45562 | 42478 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 50 Phelan Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997094.69001 | 2092450.71201 | 37.7253046451535 | -122.4522271205 | (37.7253046451535, -122.4522271205) | 9 | 7 | 4 | 28861 | 40 | ||
45566 | 40695 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 239 Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/1999 12:00:00 AM | 9 | Permit Number 41675 | 6004959.82025 | 2094081.11499 | 37.7302287977163 | -122.425154059106 | (37.7302287977163, -122.425154059106) | 9 | 7 | 6 | 28861 | 5 | |
45987 | 45046 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2331 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/2001 12:00:00 AM | 8 | Permit Number 43932 | 5988547.1447 | 2099445.4424 | 37.7440170036247 | -122.482287054322 | (37.7440170036247, -122.482287054322) | 1 | 8 | 3 | 29491 | 35 | |
46444 | 33254 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 2518 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/13/1996 12:00:00 AM | Permit Number 37432 | 5987089.34275763 | 2098119.32468859 | 37.7402909313254 | -122.487230356038 | (37.7402909313254, -122.487230356038) | 1 | 8 | 3 | 29491 | 35 | ||
47045 | 44415 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 715 Prague St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 10 | Permit Number 43765 | 6002616.35291 | 2087303.28452 | 37.7114857184532 | -122.432771733227 | (37.7114857184532, -122.432771733227) | 9 | 7 | 6 | 28861 | 5 | |
47283 | 41040 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 100 Jennings St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1999 12:00:00 AM | Permit Number 41824 | 6018973.83890969 | 2097433.1098399 | 37.7402144368946 | -122.376937636731 | (37.7402144368946, -122.376937636731) | 10 | 3 | 8 | 58 | 1 | |||
48307 | 35895 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 225 Industrial St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1998 12:00:00 AM | Permit Number 39088 | 6010847.02207847 | 2096940.13108018 | 37.7384098714444 | -122.405002340826 | (37.7384098714444, -122.405002340826) | 10 | 3 | 8 | 58 | 1 | ||
48435 | 69297 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1608 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/14/1994 12:00:00 AM | 13 | Permit Number 33371 | 6000041.7259 | 2110953.3912 | 37.7762769049899 | -122.443367941763 | (37.7762769049899, -122.443367941763) | 15 | 5 | 11 | 29492 | 16 | |
49321 | 104879 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 234 28th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11/25/2013 12:00:00 AM | Permit Number 771117 | 5987170.1 | 2114381 | 37.7849457229925 | -122.488145785283 | (37.7849457229925, -122.488145785283) | 11 | 6 | 1 | 55 | 33 | |||
50012 | 96691 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 3132@32nd Ave Clement St | 13 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/28/2011 12:00:00 AM | Permit Number 768040 | 5985890 | 2113240 | 37.7817381026149 | -122.492490401566 | (37.7817381026149, -122.492490401566) | 11 | 6 | 2 | 55 | 26 | |||
50403 | 41405 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1250 Sunnydale Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.7112689138709 | -122.413443728962 | (37.7112689138709, -122.413443728962) | 9 | 7 | 8 | 309 | 39 | ||
50553 | 35272 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 251 Glenview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | Permit Number 38755 | 5999077.63738514 | 2100785.4161936 | 37.7483031596888 | -122.44597148362 | (37.7483031596888, -122.44597148362) | 2 | 5 | 5 | 63 | 38 | ||
50765 | 41003 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1200 Illinois St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/1999 12:00:00 AM | Permit Number 41817 | 6016113.76612701 | 2103352.32554079 | 37.7563094360414 | -122.387239488996 | (37.7563094360414, -122.387239488996) | 10 | 3 | 8 | 28856 | 29 | |||
50768 | 46692 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1300 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/2002 12:00:00 AM | Permit Number 44821 | 5990845.37275011 | 2105216.85962142 | 37.7599972171805 | -122.474761542285 | (37.7599972171805, -122.474761542285) | 1 | 8 | 4 | 56 | 12 | ||
51632 | 31156 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 291 Staples Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42627 | 5998170.06868325 | 2093774.97571129 | 37.7290023079752 | -122.448604988547 | (37.7290023079752, -122.448604988547) | 9 | 7 | 4 | 28861 | 40 | ||
51953 | 35357 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 853 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 19 | Permit Number 38819 | 6011893.15946 | 2104410.58195 | 37.7589805372281 | -122.401910282252 | (37.7589805372281, -122.401910282252) | 10 | 3 | 8 | 28856 | 29 | |
52091 | 247982 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 499 Peralta Ave | 2 | Side Yard : Yard | Tree | Private 2 | 5 | 6009787.12522 | 2099515.94475 | 37.7454231899404 | -122.408848643548 | (37.7454231899404, -122.408848643548) | 2 | 7 | 7 | 28859 | 2 | ||||
52407 | 46691 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1039 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/2002 12:00:00 AM | Permit Number 44820 | 5991711.18613678 | 2105195.27676174 | 37.7599880896107 | -122.471765566972 | (37.7599880896107, -122.471765566972) | 1 | 8 | 4 | 56 | 12 | ||
53606 | 40984 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1300 Illinois St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/1999 12:00:00 AM | Permit Number 41816 | 6016132.48160546 | 2103021.5500289 | 37.7554022327395 | -122.387151692888 | (37.7554022327395, -122.387151692888) | 10 | 3 | 8 | 28856 | 29 | |||
54332 | 40999 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1200 Illinois St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/1999 12:00:00 AM | Permit Number 41817 | 6016113.76612701 | 2103352.32554079 | 37.7563094360414 | -122.387239488996 | (37.7563094360414, -122.387239488996) | 10 | 3 | 8 | 28856 | 29 | |||
54479 | 42489 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 50 Phelan Ave | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997100.11501 | 2092938.99301 | 37.7266456600516 | -122.452243583321 | (37.7266456600516, -122.452243583321) | 9 | 7 | 4 | 28861 | 40 | ||
54824 | 96690 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 3132@32nd Ave Clement St | 12 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/28/2011 12:00:00 AM | Permit Number 768040 | 5985890 | 2113240 | 37.7817381026149 | -122.492490401566 | (37.7817381026149, -122.492490401566) | 11 | 6 | 2 | 55 | 26 | |||
54883 | 45147 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1794 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/2001 12:00:00 AM | Permit Number 44001 | 5997992.79330429 | 2108930.04018436 | 37.7706042491421 | -122.450309844744 | (37.7706042491421, -122.450309844744) | 15 | 5 | 11 | 29492 | 9 | ||
54897 | 38563 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1444 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 7 | Permit Number 40529 | 6016067.4266 | 2095101.8608 | 37.7336527931474 | -122.386824395296 | (37.7336527931474, -122.386824395296) | 10 | 3 | 8 | 58 | 1 | |
55006 | 37915 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1310 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/21/2002 12:00:00 AM | Permit Number 45463 | 6013387.28238112 | 2106643.29255824 | 37.7651943429343 | -122.396899403082 | (37.7651943429343, -122.396899403082) | 14 | 3 | 8 | 28856 | 20 | ||
55572 | 45145 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1794 Page St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/2001 12:00:00 AM | Permit Number 44001 | 5997992.79330429 | 2108930.04018436 | 37.7706042491421 | -122.450309844744 | (37.7706042491421, -122.450309844744) | 15 | 5 | 11 | 29492 | 9 | ||
56289 | 41397 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1250 Sunnydale Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.7112689138709 | -122.413443728962 | (37.7112689138709, -122.413443728962) | 9 | 7 | 8 | 309 | 39 | ||
56348 | 40503 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 160 Aptos Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/1999 12:00:00 AM | Permit Number 41573 | 5992838.9416153 | 2093905.66279134 | 37.7290548678482 | -122.467044439005 | (37.7290548678482, -122.467044439005) | 9 | 8 | 4 | 59 | 40 | ||
57634 | 39525 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1330 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 13 | Permit Number 40968 | 6012506.0497 | 2107071.0543 | 37.7663197901014 | -122.399977436283 | (37.7663197901014, -122.399977436283) | 14 | 3 | 8 | 28856 | 20 | |
57653 | 45146 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1794 Page St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/2001 12:00:00 AM | Permit Number 44001 | 5997992.79330429 | 2108930.04018436 | 37.7706042491421 | -122.450309844744 | (37.7706042491421, -122.450309844744) | 15 | 5 | 11 | 29492 | 9 | ||
57661 | 202183 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1900 Armstrong Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6013209.30016 | 2093397.98949 | 37.7288156516218 | -122.39658644322 | (37.7288156516218, -122.39658644322) | 10 | 3 | 8 | 58 | 1 | ||||
57889 | 42490 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 50 Phelan Ave | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997102.28501 | 2092919.46201 | 37.7265921568632 | -122.452234673085 | (37.7265921568632, -122.452234673085) | 9 | 7 | 4 | 28861 | 40 | ||
57906 | 31613 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 367 27th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1995 12:00:00 AM | Permit Number 35134 | 5987438.17691479 | 2113501.64932662 | 37.7825469127425 | -122.48715372973 | (37.7825469127425, -122.48715372973) | 11 | 6 | 2 | 55 | 26 | |||
57952 | 31939 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1370 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | 7 | Permit Number 35354 | 5981544.9955 | 2105760.2879 | 37.7609459982399 | -122.506966809632 | (37.7609459982399, -122.506966809632) | 1 | 8 | 3 | 56 | 35 | |
58457 | 39851 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 3151 Ortega St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41160 | 5984281.43555925 | 2102217.56111428 | 37.7513794309419 | -122.49724128025 | (37.7513794309419, -122.49724128025) | 1 | 8 | 3 | 29491 | 35 | ||
58827 | 40981 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1495 Illinois St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/1999 12:00:00 AM | Permit Number 41815 | 6016236.41509471 | 2102138.50020991 | 37.7529833183766 | -122.386730679564 | (37.7529833183766, -122.386730679564) | 10 | 3 | 8 | 28856 | 29 | |||
59094 | 42480 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 50 Phelan Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997093.60501 | 2092500.62501 | 37.7254416323021 | -122.452234471094 | (37.7254416323021, -122.452234471094) | 9 | 7 | 4 | 28861 | 40 | ||
59118 | 115272 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1938 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | 0 | Permit Number 775650 | 5985734.3 | 2102018.9 | 37.7509190021287 | -122.49220255028 | (37.7509190021287, -122.49220255028) | 1 | 8 | 3 | 29491 | 35 | ||
59249 | 41008 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1200 Illinois St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/1999 12:00:00 AM | Permit Number 41817 | 6016113.76612701 | 2103352.32554079 | 37.7563094360414 | -122.387239488996 | (37.7563094360414, -122.387239488996) | 10 | 3 | 8 | 28856 | 29 | |||
59796 | 42432 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 158 Judson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42580 | 5999029.90712568 | 2093520.1665854 | 37.7283517896397 | -122.44561415687 | (37.7283517896397, -122.44561415687) | 9 | 7 | 4 | 28861 | 40 | ||
59987 | 210191 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 321 Melrose Ave | 1 | : Yard | Tree | Private 2 | 12 | 5997966.64829 | 2095534.34794 | 37.7338214930658 | -122.449434940488 | (37.7338214930658, -122.449434940488) | 9 | 7 | 4 | 59 | 40 | ||||
61194 | 41408 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1250 Sunnydale Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.7112689138709 | -122.413443728962 | (37.7112689138709, -122.413443728962) | 9 | 7 | 8 | 309 | 39 | ||
61406 | 32501 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 42 Bache St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | Permit Number 37006 | 6007173.83127039 | 2095597.26790323 | 37.7345166473806 | -122.417607327621 | (37.7345166473806, -122.417607327621) | 2 | 7 | 7 | 28859 | 2 | ||
61902 | 41417 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1101 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/2000 12:00:00 AM | 7 | Permit Number 42026 | 6008785.84855 | 2117957.11864 | 37.7960022093983 | -122.413614986564 | (37.7960022093983, -122.413614986564) | 5 | 1 | 10 | 308 | 21 | ||
61927 | 40469 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 251 Harold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1999 12:00:00 AM | Permit Number 41554 | 5996794.30906624 | 2091457.62107189 | 37.7225606398038 | -122.453193843047 | (37.7225606398038, -122.453193843047) | 9 | 8 | 4 | 28861 | 24 | ||
61935 | 52487 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 349@ ANDOVER Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | 14 | Permit Number 48597 | 6006928.39742445 | 2096056.46353797 | 37.7357636837766 | -122.418488426042 | (37.7357636837766, -122.418488426042) | 2 | 7 | 7 | 28859 | 2 | |
62643 | 42025 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 171 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42348 | 5993627.24240997 | 2093940.95109531 | 37.7291972307793 | -122.464321804087 | (37.7291972307793, -122.464321804087) | 9 | 8 | 4 | 59 | 40 | ||
62729 | 44390 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 15 Cordova St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/2001 12:00:00 AM | Permit Number 43749 | 6001647.0719332 | 2087964.37014378 | 37.7132458927569 | -122.436169094311 | (37.7132458927569, -122.436169094311) | 9 | 7 | 6 | 28861 | 5 | ||
62792 | 45148 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1794 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/2001 12:00:00 AM | Permit Number 44001 | 5997992.79330429 | 2108930.04018436 | 37.7706042491421 | -122.450309844744 | (37.7706042491421, -122.450309844744) | 15 | 5 | 11 | 29492 | 9 | ||
63309 | 96689 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 3132@32nd Ave Clement St | 11 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/28/2011 12:00:00 AM | Permit Number 768040 | 5985890 | 2113240 | 37.7817381026149 | -122.492490401566 | (37.7817381026149, -122.492490401566) | 11 | 6 | 2 | 55 | 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) );