trees
35 rows where Supervisor Districts = 4 and qSpecies_id = 97 sorted by qSiteInfo
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5392 | 60144 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1614 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1982 12:00:00 AM | Permit Number 19674 | 5990908.81036863 | 2104400.55481137 | 37.7577595366377 | -122.474482571431 | (37.7577595366377, -122.474482571431) | 1 | 8 | 4 | 56 | 12 | ||
7426 | 218839 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 850 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2010 12:00:00 AM | 2 | Width 3ft | Permit Number 54033 | 5990579.44919 | 2099089.86589 | 37.7431586880264 | -122.475233923312 | (37.7431586880264, -122.475233923312) | 1 | 8 | 4 | 29491 | 40 | |
12747 | 65465 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 618 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1989 12:00:00 AM | Permit Number 28343 | 5994991.49008264 | 2091257.73775868 | 37.7219083154277 | -122.459411273619 | (37.7219083154277, -122.459411273619) | 9 | 8 | 4 | 28861 | 24 | ||
24232 | 218833 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1550 Ulloa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991183.94041 | 2098426.02106 | 37.7413709589947 | -122.473095372371 | (37.7413709589947, -122.473095372371) | 1 | 8 | 4 | 29491 | 40 | |||
28762 | 218828 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 831 Rivera St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5990524.89237 | 2100389.62216 | 37.7467243191683 | -122.475517447198 | (37.7467243191683, -122.475517447198) | 1 | 8 | 4 | 29491 | 40 | |||
34968 | 258294 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2498X 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991168 | 2098442 | 37.7414139101312 | -122.473151653247 | (37.7414139101312, -122.473151653247) | 1 | 8 | 4 | 29491 | 40 | ||||
40301 | 218803 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2370 Funston Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5992349.88043 | 2099344.31841 | 37.7439598068059 | -122.469130812732 | (37.7439598068059, -122.469130812732) | 1 | 8 | 4 | 29491 | 40 | |||
42835 | 218840 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 18 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992943.37066 | 2098991.78527 | 37.7430261153754 | -122.467053051482 | (37.7430261153754, -122.467053051482) | 1 | 8 | 4 | 59 | 40 | |||
44712 | 30926 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 230 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 13 | Permit Number 34739 | 5996065.71046 | 2091231.30039 | 37.7218974306099 | -122.455696079012 | (37.7218974306099, -122.455696079012) | 9 | 8 | 4 | 28861 | 24 | |
51427 | 65673 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 355 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/1990 12:00:00 AM | Permit Number 28593 | 5997947.70792661 | 2098297.78452014 | 37.7414081426615 | -122.449699493918 | (37.7414081426615, -122.449699493918) | 9 | 7 | 4 | 59 | 40 | ||
51462 | 218829 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 833 Rivera St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5990502.9727 | 2100388.60646 | 37.746720259628 | -122.475593168284 | (37.746720259628, -122.475593168284) | 1 | 8 | 4 | 29491 | 40 | |||
54947 | 63166 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1534 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1986 12:00:00 AM | Permit Number 23703 | 5992780.43210356 | 2105015.68842996 | 37.7595567946867 | -122.468054529997 | (37.7595567946867, -122.468054529997) | 1 | 8 | 4 | 56 | 12 | ||
55197 | 60152 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1790 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1982 12:00:00 AM | Permit Number 19683 | 5990948.80079989 | 2103226.18449464 | 37.7545373426794 | -122.474258577533 | (37.7545373426794, -122.474258577533) | 1 | 8 | 4 | 56 | 12 | ||
57590 | 218841 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1522 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5994017.40797 | 2105128.44374 | 37.7599377495509 | -122.463784669644 | (37.7599377495509, -122.463784669644) | 1 | 5 | 4 | 56 | 12 | |||
73159 | 218834 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1550 Ulloa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991139.93283 | 2098423.38649 | 37.7413611770786 | -122.473247341618 | (37.7413611770786, -122.473247341618) | 1 | 8 | 4 | 29491 | 40 | |||
106260 | 218807 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 238 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 5999815.89022 | 2094384.28046 | 37.7307692875673 | -122.442959015043 | (37.7307692875673, -122.442959015043) | 9 | 7 | 4 | 63 | 40 | |||
107613 | 258293 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2498X 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991168 | 2098442 | 37.7414139101312 | -122.473151653247 | (37.7414139101312, -122.473151653247) | 1 | 8 | 4 | 29491 | 40 | ||||
109653 | 173730 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 387 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999535 | 2094919 | 37.7322214835803 | -122.443968498715 | (37.7322214835803, -122.443968498715) | 9 | 7 | 4 | 63 | 40 | ||||
120941 | 218832 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1550 Ulloa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991196.18997 | 2098425.25378 | 37.7413695614616 | -122.473052962144 | (37.7413695614616, -122.473052962144) | 1 | 8 | 4 | 29491 | 40 | |||
132605 | 218804 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 161 San Rafael Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5991882.49508 | 2095116.63402 | 37.7323246389721 | -122.470439076297 | (37.7323246389721, -122.470439076297) | 9 | 8 | 4 | 59 | 40 | |||
133330 | 218838 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 723 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5990942.64769 | 2099036.77615 | 37.74303396195 | -122.473974219529 | (37.74303396195, -122.473974219529) | 1 | 8 | 4 | 29491 | 40 | |||
135076 | 218835 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1550 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991107.25372 | 2098449.01305 | 37.7414296487733 | -122.473362202106 | (37.7414296487733, -122.473362202106) | 1 | 8 | 4 | 29491 | 40 | |||
135351 | 218830 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 833 Rivera St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5990479.90891 | 2100386.13678 | 37.7467121414596 | -122.475672739417 | (37.7467121414596, -122.475672739417) | 1 | 8 | 4 | 29491 | 40 | |||
139406 | 218842 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 101 Stanford Heights Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5997801.41833 | 2096410.61107 | 37.7362180487182 | -122.450069323134 | (37.7362180487182, -122.450069323134) | 9 | 7 | 4 | 59 | 40 | |||
145876 | 218802 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2370 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5992350.84884 | 2099324.20257 | 37.7439046297971 | -122.46912600049 | (37.7439046297971, -122.46912600049) | 1 | 8 | 4 | 29491 | 40 | |||
153527 | 65474 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1185 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/11/1989 12:00:00 AM | Permit Number 28355 | 5995034.99249971 | 2091783.3730714 | 37.7233540853263 | -122.459298943633 | (37.7233540853263, -122.459298943633) | 9 | 8 | 4 | 28861 | 24 | ||
163838 | 218836 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1550 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991107.22907 | 2098459.95547 | 37.7414596924238 | -122.473363085249 | (37.7414596924238, -122.473363085249) | 1 | 8 | 4 | 29491 | 40 | |||
178322 | 30927 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 236 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 13 | Permit Number 34740 | 5996038.7385 | 2091232.95448 | 37.7219004244455 | -122.455789433158 | (37.7219004244455, -122.455789433158) | 9 | 8 | 4 | 28861 | 24 | |
182989 | 218837 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 725 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5990923.73813 | 2099033.65671 | 37.7430243014348 | -122.474039375442 | (37.7430243014348, -122.474039375442) | 1 | 8 | 4 | 29491 | 40 | |||
184346 | 218831 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1550 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991205.91202 | 2098425.81226 | 37.7413716577778 | -122.473019387736 | (37.7413716577778, -122.473019387736) | 1 | 8 | 4 | 29491 | 40 | |||
189826 | 218806 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 217 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5999893.77638 | 2094346.53737 | 37.7306700941413 | -122.44268704209 | (37.7306700941413, -122.44268704209) | 9 | 7 | 4 | 63 | 40 | |||
98687 | 218805 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 67 Marne Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 5995289.12081 | 2097585.29615 | 37.73929936437 | -122.458840331911 | (37.73929936437, -122.458840331911) | 9 | 7 | 4 | 59 | 40 | |||
98693 | 218808 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 379 Flood Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 5998237.66884 | 2094066.68072 | 37.7298071263007 | -122.448392288972 | (37.7298071263007, -122.448392288972) | 9 | 7 | 4 | 28861 | 40 | ||||
113933 | 218843 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 661 Rockdale Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 5997657.5738 | 2098142.02161 | 37.7409638520942 | -122.450691444481 | (37.7409638520942, -122.450691444481) | 9 | 7 | 4 | 59 | 40 | |||
184895 | 218827 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 15 Rossmoor Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5991236.4555 | 2094303.51433 | 37.7300546412872 | -122.472613299773 | (37.7300546412872, -122.472613299773) | 9 | 8 | 4 | 64 | 40 |
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) );