trees
139 rows where Zip Codes = 28861 and qSpecies_id = 65 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
143006 | 161013 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 46 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781526 | 6004792.42669 | 2090835.59849 | 37.7213078665529 | -122.425501874617 | (37.7213078665529, -122.425501874617) | 9 | 7 | 6 | 28861 | 5 | |
143450 | 221902 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 7 Marsily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6004251.61559 | 2095453.80279 | 37.7339578572562 | -122.427700181935 | (37.7339578572562, -122.427700181935) | 2 | 7 | 5 | 28861 | 25 | |||
146650 | 170415 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 216 Theresa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 779296 | 6001929.08412 | 2093967.91374 | 37.7297462952572 | -122.435623604862 | (37.7297462952572, -122.435623604862) | 9 | 7 | 6 | 28861 | 25 | |
146877 | 203582 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 24 Gennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5997457.41638 | 2093726.64675 | 37.7288288329774 | -122.451065185614 | (37.7288288329774, -122.451065185614) | 9 | 7 | 4 | 28861 | 40 | |||
148858 | 203581 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 24 Gennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 5997456.8868 | 2093709.98189 | 37.7287830449036 | -122.451065815142 | (37.7287830449036, -122.451065815142) | 9 | 7 | 4 | 28861 | 40 | |||
149081 | 221900 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 7 Marsily St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6004249.68912 | 2095508.61359 | 37.7341082463924 | -122.427710746252 | (37.7341082463924, -122.427710746252) | 2 | 7 | 5 | 28861 | 25 | |||
151528 | 175210 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 66 Madison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 2ft | 6005427.44885 | 2093231.28592 | 37.7279217605751 | -122.423477009653 | (37.7279217605751, -122.423477009653) | 9 | 7 | 6 | 28861 | 5 | |||
152880 | 221838 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 115 Cuvier St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004035.03303 | 2095100.17103 | 37.7329746104714 | -122.42842377735 | (37.7329746104714, -122.42842377735) | 9 | 7 | 5 | 28861 | 25 | |||
156296 | 87374 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 149 Staples Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50353 | 5999085.2 | 2093741.7 | 37.7289632252792 | -122.445438930282 | (37.7289632252792, -122.445438930282) | 9 | 7 | 4 | 28861 | 40 | |||
159787 | 203555 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 209 Farallones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 5994968.99544 | 2088379.28856 | 37.7140034838548 | -122.459280689461 | (37.7140034838548, -122.459280689461) | 9 | 8 | 6 | 28861 | 24 | |||
160387 | 203556 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 209 Farallones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5994991.30881 | 2088378.07982 | 37.7140014477822 | -122.45920347906 | (37.7140014477822, -122.45920347906) | 9 | 8 | 6 | 28861 | 24 | |||
163287 | 160137 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 61 Seminole Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781533 | 5999114.78388 | 2090156.18461 | 37.7191199185408 | -122.445078994094 | (37.7191199185408, -122.445078994094) | 9 | 7 | 6 | 28861 | 25 | |
166822 | 221848 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Marys Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6004429.19741 | 2095585.11426 | 37.7343284525969 | -122.427095576708 | (37.7343284525969, -122.427095576708) | 2 | 7 | 5 | 28861 | 25 | |||
167184 | 221846 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Marys Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6004388.2708 | 2095606.1808 | 37.7343839821397 | -122.427238573395 | (37.7343839821397, -122.427238573395) | 2 | 7 | 5 | 28861 | 25 | |||
167603 | 108846 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 970 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 772762 | 6001611.41863 | 2086816.80035 | 37.7100928934503 | -122.436210250619 | (37.7100928934503, -122.436210250619) | 9 | 7 | 6 | 28861 | 5 | |
168312 | 175182 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 647 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6002406.62971 | 2090005.70634 | 37.718894076269 | -122.433689610108 | (37.718894076269, -122.433689610108) | 9 | 7 | 6 | 28861 | 5 | |||
169503 | 65718 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 206 Pope St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1990 12:00:00 AM | 22 | Permit Number 28650 | 6000369.4893 | 2087691.53319 | 37.7124240746766 | -122.440565289581 | (37.7124240746766, -122.440565289581) | 9 | 7 | 6 | 28861 | 5 | |
171813 | 35138 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 832 Naples St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | 9 | Permit Number 38668 | 6001976.8462 | 2088896.96126 | 37.7158253124776 | -122.435095942923 | (37.7158253124776, -122.435095942923) | 9 | 7 | 6 | 28861 | 5 | |
172010 | 175193 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 28 Harrington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002083.86995 | 2092418.47999 | 37.7255006920777 | -122.434977725241 | (37.7255006920777, -122.434977725241) | 9 | 7 | 6 | 28861 | 25 | |||
172281 | 203590 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 120 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5999238.54402 | 2093513.75556 | 37.7283460957772 | -122.444892431558 | (37.7283460957772, -122.444892431558) | 9 | 7 | 4 | 28861 | 40 | |||
172356 | 175209 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 9 Athens St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6005385.77988 | 2093250.96165 | 37.7279734338052 | -122.423622458831 | (37.7279734338052, -122.423622458831) | 9 | 7 | 6 | 28861 | 5 | |||
172987 | 95109 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 615 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2010 12:00:00 AM | 9 | 3x3 | Permit Number 54038 | 6001824.30736 | 2093468.52552 | 37.7283691373029 | -122.435950110013 | (37.7283691373029, -122.435950110013) | 9 | 7 | 6 | 28861 | 25 |
175391 | 203584 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 391 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 5ft | 5997518.2723 | 2093790.63155 | 37.729008004011 | -122.450859415354 | (37.729008004011, -122.450859415354) | 9 | 7 | 4 | 28861 | 40 | |||
177042 | 221839 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 98 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6004329.20117 | 2095336.95284 | 37.7336414020218 | -122.42742362331 | (37.7336414020218, -122.42742362331) | 2 | 7 | 5 | 28861 | 25 | |||
181669 | 221897 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 7 Marsily St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6004313.27155 | 2095583.983 | 37.7343187902678 | -122.427496289445 | (37.7343187902678, -122.427496289445) | 2 | 7 | 5 | 28861 | 25 | |||
182887 | 203553 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 259 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5994715.67756 | 2090305.5088 | 37.7192778601644 | -122.46029572277 | (37.7192778601644, -122.46029572277) | 9 | 8 | 6 | 28861 | 24 | |||
183128 | 175208 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 9 Athens St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6005371.81589 | 2093231.88981 | 37.727920278496 | -122.423669377345 | (37.727920278496, -122.423669377345) | 9 | 7 | 6 | 28861 | 5 | |||
183603 | 67515 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 179 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1992 12:00:00 AM | Permit Number 31051 | 5998906.63498153 | 2093763.92891486 | 37.7290140653184 | -122.446057838601 | (37.7290140653184, -122.446057838601) | 9 | 7 | 4 | 28861 | 40 | ||
186207 | 114881 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 122 COLLEGE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6004593 | 2095924 | 37.7352682180932 | -122.426553380791 | (37.7352682180932, -122.426553380791) | 2 | 7 | 5 | 28861 | 2 | |||
186585 | 175207 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 9 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6005359.84242 | 2093211.49837 | 37.7278636122004 | -122.423709320725 | (37.7278636122004, -122.423709320725) | 9 | 7 | 6 | 28861 | 5 | |||
186672 | 160894 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 642 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/11/2017 08:21:00 AM | 3 | Width 0ft | 6002380.66916 | 2090044.63219 | 37.7189994849067 | -122.433782126067 | (37.7189994849067, -122.433782126067) | 9 | 7 | 6 | 28861 | 5 | |
189738 | 203583 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 24 Gennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5997456.92965 | 2093746.95791 | 37.72888457474 | -122.451068332359 | (37.72888457474, -122.451068332359) | 9 | 7 | 4 | 28861 | 40 | |||
192333 | 221847 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Marys Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6004411.28278 | 2095593.12873 | 37.7343494454616 | -122.427158084072 | (37.7343494454616, -122.427158084072) | 2 | 7 | 5 | 28861 | 25 | |||
20955 | 203536 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 347 Hearst Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 6ft | 5999101.32072 | 2094349.11818 | 37.7306319736778 | -122.445426858158 | (37.7306319736778, -122.445426858158) | 9 | 7 | 4 | 28861 | 40 | |||
16252 | 203564 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 202 Elmwood Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 3ft | 5994856.42725 | 2092686.28381 | 37.7258229929193 | -122.459981583277 | (37.7258229929193, -122.459981583277) | 9 | 8 | 4 | 28861 | 40 | |||
93237 | 203567 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 209 Colon Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 3ft | 5996068.02094 | 2094221.27645 | 37.7301073235953 | -122.455904133578 | (37.7301073235953, -122.455904133578) | 9 | 7 | 4 | 28861 | 40 | |||
159587 | 203566 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 209 Colon Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 3ft | 5996063.41122 | 2094232.89601 | 37.7301389635391 | -122.455920909543 | (37.7301389635391, -122.455920909543) | 9 | 7 | 4 | 28861 | 40 | |||
69909 | 175176 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 226 Rome St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 5998630.92665 | 2088821.65601 | 37.7154279802818 | -122.446655529047 | (37.7154279802818, -122.446655529047) | 9 | 7 | 6 | 28861 | 25 | |||
156178 | 175175 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 231 Rome St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 3ft | 5998599.64276 | 2088795.69735 | 37.7153549166607 | -122.446761792925 | (37.7153549166607, -122.446761792925) | 9 | 7 | 6 | 28861 | 25 |
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) );