trees
3,709 rows where qSpecies_id = 9 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 274 | 232433 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 Church St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6004078.25972 | 2108290.75217 | 37.7691953086514 | -122.429214555715 | (37.7691953086514, -122.429214555715) | 7 | 9 | 5 | 28862 | 3 | |||
| 291 | 210733 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 239 Ramsell St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5992956.15258 | 2088805.34296 | 37.7150573966491 | -122.466268722147 | (37.7150573966491, -122.466268722147) | 9 | 8 | 6 | 64 | 24 | |||
| 1727 | 249457 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 201 Olive St | 2 | : | Tree | Private 2 | 11 | Width 4ft | 6006319.82833 | 2113698.46294 | 37.7841702168319 | -122.421845255461 | (37.7841702168319, -122.421845255461) | 7 | 9 | 11 | 28858 | 41 | |||
| 6418 | 194172 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 664 Wisconsin St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6012676.7573 | 2104370.99604 | 37.7589155441312 | -122.399197435936 | (37.7589155441312, -122.399197435936) | 10 | 3 | 8 | 28856 | 29 | |||
| 9805 | 246529 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 95 Laguna St | 2 | : | Tree | Private 2 | 10 | Width 4ft | 6005210.23202 | 2109136.89842 | 37.77158263905 | -122.425359343752 | (37.77158263905, -122.425359343752) | 7 | 9 | 5 | 28852 | 10 | |||
| 10208 | 250096 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1701 Pine St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6005700.60971 | 2115508.13842 | 37.789104197049 | -122.42411627476 | (37.789104197049, -122.42411627476) | 13 | 9 | 1 | 28858 | 41 | |||
| 18494 | 250097 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1701 Pine St | 3 | : | Tree | Private 2 | 4 | Width 3ft | 6005753.06256 | 2115514.84991 | 37.7891255865184 | -122.423935271799 | (37.7891255865184, -122.423935271799) | 13 | 9 | 1 | 28858 | 41 | |||
| 23967 | 210736 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 279 Ramsell St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5992958.08764 | 2089050.23377 | 37.7157299195648 | -122.466279820655 | (37.7157299195648, -122.466279820655) | 9 | 8 | 6 | 64 | 24 | |||
| 25388 | 250487 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 222 El Camino Del Mar | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5987893.38095 | 2115356.60419 | 37.7876666226671 | -122.485715124257 | (37.7876666226671, -122.485715124257) | 11 | 6 | 1 | 55 | 33 | |||
| 29652 | 247670 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 170 Divisadero St | 1 | : | Tree | Private 2 | 4 | Width 4ft | 6001927.47375 | 2108582.27333 | 37.7698737616969 | -122.436674865568 | (37.7698737616969, -122.436674865568) | 15 | 5 | 5 | 29492 | 9 | |||
| 38141 | 210728 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 113 Majestic Ave | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5997053.85221 | 2089279.44742 | 37.716594756218 | -122.4521395823 | (37.716594756218, -122.4521395823) | 9 | 8 | 6 | 28861 | 24 | |||
| 39257 | 249461 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 201 Olive St | 6 | : | Tree | Private 2 | 9 | Width 4ft | 6006433.55883 | 2113714.71473 | 37.7842212533479 | -122.42145294241 | (37.7842212533479, -122.42145294241) | 7 | 9 | 11 | 28858 | 41 | |||
| 41527 | 194178 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 198 Missouri St | 2 | : | Tree | Private 2 | 4 | Width 4ft | 6013413.48709 | 2106240.03726 | 37.7640885515801 | -122.396780493551 | (37.7640885515801, -122.396780493551) | 14 | 3 | 8 | 28856 | 29 | |||
| 43038 | 194194 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1888 Illinois St | 1 | : | Tree | Private 2 | 10 | Width 4ft | 6016264.99223 | 2100427.37243 | 37.7482865000228 | -122.386512551535 | (37.7482865000228, -122.386512551535) | 10 | 3 | 8 | 58 | 1 | |||
| 44605 | 246528 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 95 Laguna St | 1 | : | Tree | Private 2 | 13 | Width 7ft | 6005204.62433 | 2109172.65839 | 37.7716805104709 | -122.425381286315 | (37.7716805104709, -122.425381286315) | 7 | 9 | 5 | 28852 | 10 | |||
| 45992 | 247778 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 250 30th St | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6004957.69836 | 2098452.79483 | 37.7422323278575 | -122.42547239214 | (37.7422323278575, -122.42547239214) | 2 | 7 | 5 | 63 | 22 | |||
| 51418 | 210594 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1598 10th Ave | 8 | : | Tree | Private 2 | 6 | Width 2ft | 5993107.5867 | 2104697.22808 | 37.758701273452 | -122.466899924805 | (37.758701273452, -122.466899924805) | 1 | 8 | 4 | 56 | 12 | |||
| 54847 | 249458 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 201 Olive St | 3 | : | Tree | Private 2 | 8 | Width 4ft | 6006350.21001 | 2113701.7523 | 37.7841809619115 | -122.421740379236 | (37.7841809619115, -122.421740379236) | 7 | 9 | 11 | 28858 | 41 | |||
| 56635 | 247623 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 261 Bradford St | 1 | : | Tree | Private 2 | 3 | Width 4ft | 6009541.50836 | 2097060.71504 | 37.7386679035942 | -122.409524699022 | (37.7386679035942, -122.409524699022) | 10 | 7 | 7 | 28859 | 2 | |||
| 56719 | 247696 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 66 Central Ave | 1 | : | Tree | Private 2 | 3 | Width 4ft | 5999969.16959 | 2108614.08966 | 37.7698496373709 | -122.443450859673 | (37.7698496373709, -122.443450859673) | 15 | 5 | 11 | 29492 | 9 | |||
| 60206 | 249451 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 251 Olive St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6006114.5159 | 2113666.03761 | 37.7840696042744 | -122.422553259352 | (37.7840696042744, -122.422553259352) | 7 | 9 | 11 | 28858 | 41 | |||
| 65824 | 194119 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 75 Oak Grove St | 4 | : | Tree | Private 2 | 7 | Width 3ft | 6012059.36571 | 2111084.51172 | 37.7773149177954 | -122.401804583142 | (37.7773149177954, -122.401804583142) | 14 | 2 | 9 | 28856 | 34 | |||
| 66577 | 232434 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 Church St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6004077.27006 | 2108309.37309 | 37.7692463811546 | -122.429219306844 | (37.7692463811546, -122.429219306844) | 7 | 9 | 5 | 28862 | 3 | |||
| 67266 | 194174 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 638 Arkansas St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6012975.69145 | 2104038.69902 | 37.7580197843001 | -122.398140262177 | (37.7580197843001, -122.398140262177) | 10 | 3 | 8 | 28856 | 29 | |||
| 70001 | 249448 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 238 Olive St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6006176.73504 | 2113699.88088 | 37.7841660394729 | -122.422340408706 | (37.7841660394729, -122.422340408706) | 7 | 9 | 11 | 28858 | 41 | |||
| 70346 | 249453 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 251 Olive St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6006151.02275 | 2113672.37502 | 37.7840890647107 | -122.422427409114 | (37.7840890647107, -122.422427409114) | 7 | 9 | 11 | 28858 | 41 | |||
| 72990 | 210727 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 20 Majestic Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5997384.6848 | 2089822.80773 | 37.7181056433352 | -122.451035225606 | (37.7181056433352, -122.451035225606) | 9 | 8 | 6 | 28861 | 24 | |||
| 74889 | 249460 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 201 Olive St | 5 | : | Tree | Private 2 | 11 | Width 4ft | 6006400.35451 | 2113710.64508 | 37.7842082068819 | -122.421567528645 | (37.7842082068819, -122.421567528645) | 7 | 9 | 11 | 28858 | 41 | |||
| 75801 | 232436 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 98 Laussat St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6004291.45992 | 2109275.43151 | 37.7719110660771 | -122.428547305538 | (37.7719110660771, -122.428547305538) | 7 | 9 | 11 | 28852 | 10 | |||
| 76952 | 194195 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 9 Pomona St | 1 | : | Tree | Private 2 | 2 | Width 6ft | 6014203.67115 | 2094680.19203 | 37.7323916096872 | -122.393238495663 | (37.7323916096872, -122.393238495663) | 10 | 3 | 8 | 58 | 1 | |||
| 84342 | 249452 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 251 Olive St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6006131.50296 | 2113669.15355 | 37.7840791181899 | -122.422494711663 | (37.7840791181899, -122.422494711663) | 7 | 9 | 11 | 28858 | 41 | |||
| 84624 | 250766 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 242 32nd Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5985905.94434 | 2114279.52557 | 37.7845932723154 | -122.492511820787 | (37.7845932723154, -122.492511820787) | 11 | 6 | 1 | 55 | 33 | |||
| 86323 | 210737 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 283 Ramsell St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5992959.06004 | 2089081.22924 | 37.7158150817716 | -122.466278710897 | (37.7158150817716, -122.466278710897) | 9 | 8 | 6 | 64 | 24 | |||
| 90815 | 210735 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 274 Ramsell St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5992991.6057 | 2089025.54794 | 37.7156640721019 | -122.466162174951 | (37.7156640721019, -122.466162174951) | 9 | 8 | 6 | 64 | 24 | |||
| 91693 | 246530 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 95 Laguna St | 3 | : | Tree | Private 2 | 13 | Width 7ft | 6005220.62037 | 2109069.23024 | 37.7713974254703 | -122.425318593679 | (37.7713974254703, -122.425318593679) | 7 | 9 | 5 | 28852 | 10 | |||
| 94459 | 232432 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 Church St | 3 | : | Tree | Private 2 | 15 | Width 4ft | 6004078.65513 | 2108269.95494 | 37.7691382268875 | -122.429211704867 | (37.7691382268875, -122.429211704867) | 7 | 9 | 5 | 28862 | 3 | |||
| 94721 | 249455 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 251 Olive St | 5 | : | Tree | Private 2 | 9 | Width 3ft | 6006189.18478 | 2113676.83316 | 37.7841034583637 | -122.422295698907 | (37.7841034583637, -122.422295698907) | 7 | 9 | 11 | 28858 | 41 | |||
| 113765 | 249449 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 250 Olive St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6006158.32839 | 2113696.95162 | 37.7841569581316 | -122.422403881033 | (37.7841569581316, -122.422403881033) | 7 | 9 | 11 | 28858 | 41 | |||
| 115367 | 233148 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3980 22nd St | 10 | : | Tree | Private 2 | 6 | 6001886.52284 | 2102943.06219 | 37.7543875349734 | -122.4364128508 | (37.7543875349734, -122.4364128508) | 2 | 4 | 5 | 28862 | 22 | ||||
| 120082 | 249456 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 201 Olive St | 1 | : | Tree | Private 2 | 4 | Width 4ft | 6006295.7266 | 2113694.91688 | 37.784159120994 | -122.421928386997 | (37.784159120994, -122.421928386997) | 7 | 9 | 11 | 28858 | 41 | |||
| 121787 | 210725 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 20 Edgar Ave | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5997113.75654 | 2090895.52443 | 37.7210355581178 | -122.452049055632 | (37.7210355581178, -122.452049055632) | 9 | 8 | 6 | 28861 | 24 | |||
| 130017 | 250126 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1730 Pine St | 2 | : | Tree | Private 2 | 10 | Width 3ft | 6005603.2664 | 2115542.36715 | 37.7891926840386 | -122.424455506243 | (37.7891926840386, -122.424455506243) | 13 | 9 | 1 | 28858 | 41 | |||
| 132521 | 194179 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 198 Missouri St | 3 | : | Tree | Private 2 | 5 | Width 4ft | 6013413.98851 | 2106222.803 | 37.7640412580141 | -122.396777550962 | (37.7640412580141, -122.396777550962) | 14 | 3 | 8 | 28856 | 29 | |||
| 135208 | 249462 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 201 Olive St | 7 | : | Tree | Private 2 | 9 | Width 4ft | 6006460.85988 | 2113718.34687 | 37.784232765583 | -122.421358748315 | (37.784232765583, -122.421358748315) | 7 | 9 | 11 | 28858 | 41 | |||
| 136508 | 249459 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 201 Olive St | 4 | : | Tree | Private 2 | 8 | Width 4ft | 6006372.75274 | 2113706.04085 | 37.784194008402 | -122.421662693996 | (37.784194008402, -122.421662693996) | 7 | 9 | 11 | 28858 | 41 | |||
| 138848 | 233160 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 130 Saint Germain Ave | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5997752.88642 | 2104152.69917 | 37.7574731484793 | -122.450795169568 | (37.7574731484793, -122.450795169568) | 15 | 5 | 4 | 28862 | 38 | |||
| 142682 | 249454 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 251 Olive St | 4 | : | Tree | Private 2 | 6 | Width 3ft | 6006170.8585 | 2113675.59 | 37.7840990111962 | -122.422359012976 | (37.7840990111962, -122.422359012976) | 7 | 9 | 11 | 28858 | 41 | |||
| 143103 | 210729 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2950 San Jose Ave | 3 | : | Tree | Private 2 | 3 | Width 3ft | 5996042.96304 | 2087509.51727 | 37.711676981779 | -122.455505847225 | (37.711676981779, -122.455505847225) | 9 | 8 | 6 | 28861 | 24 | |||
| 145156 | 210596 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1598 10th Ave | 13 | : | Tree | Private 2 | 8 | Width 2ft | 5993107.01633 | 2104712.46351 | 37.7587430730523 | -122.466903004965 | (37.7587430730523, -122.466903004965) | 1 | 8 | 4 | 56 | 12 | |||
| 148198 | 249450 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 250 Olive St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6006131.65251 | 2113691.8301 | 37.7841413908581 | -122.422495806137 | (37.7841413908581, -122.422495806137) | 7 | 9 | 11 | 28858 | 41 | |||
| 148696 | 232431 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 340 Church St | 1 | : | Tree | Private 2 | 1 | Width 2ft | 6004146.95621 | 2106961.59739 | 37.7655496594068 | -122.428882166285 | (37.7655496594068, -122.428882166285) | 8 | 4 | 5 | 28862 | 3 | |||
| 149249 | 194121 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 174 Langton St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6010449.01935 | 2110432.74871 | 37.7754353293039 | -122.407329361273 | (37.7754353293039, -122.407329361273) | 8 | 2 | 9 | 28853 | 34 | |||
| 156449 | 210597 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1598 10th Ave | 16 | : | Tree | Private 2 | 5 | Width 2ft | 5993106.74835 | 2104720.89396 | 37.7587662054039 | -122.466904544628 | (37.7587662054039, -122.466904544628) | 1 | 8 | 4 | 56 | 12 | |||
| 162835 | 249447 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 238 Olive St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6006223.8532 | 2113706.94532 | 37.7841880944532 | -122.422177898507 | (37.7841880944532, -122.422177898507) | 7 | 9 | 11 | 28858 | 41 | |||
| 165446 | 233147 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3978 22nd St | 3 | : | Tree | Private 2 | 2 | 6001977.86453 | 2102958.17095 | 37.7544342097936 | -122.436098049399 | (37.7544342097936, -122.436098049399) | 2 | 4 | 5 | 28862 | 22 | ||||
| 165519 | 210731 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 555 Arch St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5992721.77233 | 2090849.66532 | 37.7206570847417 | -122.46722738773 | (37.7206570847417, -122.46722738773) | 9 | 8 | 6 | 64 | 24 | |||
| 165522 | 210726 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2 Majestic Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5997442.65634 | 2089908.86719 | 37.7183452613979 | -122.450841045792 | (37.7183452613979, -122.450841045792) | 9 | 8 | 6 | 28861 | 24 | |||
| 168209 | 210738 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 291 Ramsell St | 1 | : | Tree | Private 2 | 12 | Width 3ft | 5992961.95972 | 2089127.53233 | 37.7159423862175 | -122.46627205144 | (37.7159423862175, -122.46627205144) | 9 | 8 | 6 | 64 | 24 | |||
| 168662 | 194120 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 75 Oak Grove St | 5 | : | Tree | Private 2 | 5 | Width 3ft | 6012056.17784 | 2111087.81775 | 37.7773238174893 | -122.401815843529 | (37.7773238174893, -122.401815843529) | 14 | 2 | 9 | 28856 | 34 | |||
| 174105 | 210595 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1598 10th Ave | 11 | : | Tree | Private 2 | 6 | Width 2ft | 5993107.35573 | 2104707.43103 | 37.7587292747629 | -122.466901465326 | (37.7587292747629, -122.466901465326) | 1 | 8 | 4 | 56 | 12 | |||
| 177977 | 210739 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 378 Victoria St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 5993261.2949 | 2089711.81841 | 37.7175639618854 | -122.465279833897 | (37.7175639618854, -122.465279833897) | 9 | 8 | 6 | 64 | 24 | |||
| 178 | 233603 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 199 Franconia St | 9 | : Yard | Tree | Private 2 | 6 | Width 3ft | 6010152.72418 | 2099634.52308 | 37.7457692517475 | -122.407592814071 | (37.7457692517475, -122.407592814071) | 2 | 7 | 7 | 28859 | 2 | |||
| 17455 | 233602 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 199 Franconia St | 8 | : Yard | Tree | Private 2 | 6 | Width 3ft | 6010143.5997 | 2099646.47131 | 37.7458015482156 | -122.407625207637 | (37.7458015482156, -122.407625207637) | 2 | 7 | 7 | 28859 | 2 | |||
| 18454 | 233232 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 199 Franconia St | 5 | : Yard | Tree | Private 2 | 10 | Width 3ft | 6010129.8045 | 2099669.06085 | 37.7458628019252 | -122.407674502171 | (37.7458628019252, -122.407674502171) | 2 | 7 | 7 | 28859 | 2 | |||
| 57749 | 233228 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 199 Franconia St | 1 | : Yard | Tree | Private 2 | 6 | Width 3ft | 6010113.61596 | 2099694.13241 | 37.7459307367175 | -122.407732247644 | (37.7459307367175, -122.407732247644) | 2 | 7 | 7 | 28859 | 2 | |||
| 105926 | 233233 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 199 Franconia St | 6 | : Yard | Tree | Private 2 | 9 | Width 3ft | 6010125.25157 | 2099665.50304 | 37.745852778088 | -122.407689994823 | (37.745852778088, -122.407689994823) | 2 | 7 | 7 | 28859 | 2 | |||
| 105985 | 233604 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 199 Franconia St | 10 | : Yard | Tree | Private 2 | 3 | Width 3ft | 6010160.0797 | 2099615.71546 | 37.7457180218657 | -122.407566053833 | (37.7457180218657, -122.407566053833) | 2 | 7 | 7 | 28859 | 2 | |||
| 113227 | 233234 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 199 Franconia St | 7 | : Yard | Tree | Private 2 | 4 | Width 3ft | 6010136.86006 | 2099655.53222 | 37.7458260502241 | -122.407649151211 | (37.7458260502241, -122.407649151211) | 2 | 7 | 7 | 28859 | 2 | |||
| 121948 | 177876 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 4117 San Bruno Ave | 1 | : Yard | Tree | Private 2 | 37 | Width 10ft | 6011467.53014 | 2087476.31968 | 37.7124588649577 | -122.402191732263 | (37.7124588649577, -122.402191732263) | 10 | 7 | 8 | 309 | 39 | |||
| 134390 | 233605 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 199 Franconia St | 12 | : Yard | Tree | Private 2 | 9 | Width 3ft | 6010122.88511 | 2099649.32748 | 37.7458082310637 | -122.407697037414 | (37.7458082310637, -122.407697037414) | 2 | 7 | 7 | 28859 | 2 | |||
| 135325 | 233231 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 199 Franconia St | 4 | : Yard | Tree | Private 2 | 6 | Width 3ft | 6010116.17645 | 2099679.88413 | 37.7458917573937 | -122.407722389299 | (37.7458917573937, -122.407722389299) | 2 | 7 | 7 | 28859 | 2 | |||
| 146203 | 233229 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 199 Franconia St | 2 | : Yard | Tree | Private 2 | 5 | Width 3ft | 6010110.29265 | 2099690.95534 | 37.745921827137 | -122.407743515268 | (37.745921827137, -122.407743515268) | 2 | 7 | 7 | 28859 | 2 | |||
| 158865 | 194131 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1310 Indiana St | 4 | : Yard | Tree | Private 2 | 37 | 6014985.85621 | 2102536.59701 | 37.754007092062 | -122.391083210127 | (37.754007092062, -122.391083210127) | 10 | 3 | 8 | 28856 | 29 | ||||
| 160292 | 233230 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 199 Franconia St | 3 | : Yard | Tree | Private 2 | 5 | Width 3ft | 6010120.38838 | 2099686.6934 | 37.7459106899441 | -122.407708305 | (37.7459106899441, -122.407708305) | 2 | 7 | 7 | 28859 | 2 | |||
| 10271 | 262199 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 801 Sanchez St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6003778 | 2103544 | 37.7561448640021 | -122.429914501498 | (37.7561448640021, -122.429914501498) | 2 | 4 | 5 | 28862 | 22 | ||||
| 30830 | 253551 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1000 Cayuga Ave | 19 | Back Yard : Yard | Tree | DPW 1 | 09/22/2017 04:40:00 PM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
| 55894 | 253546 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1000 Cayuga Ave | 14 | Back Yard : Yard | Tree | DPW 1 | 09/27/2017 11:50:00 AM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
| 56235 | 253550 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1000 Cayuga Ave | 18 | Back Yard : Yard | Tree | DPW 1 | 09/27/2017 11:43:00 AM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
| 58983 | 253548 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1000 Cayuga Ave | 16 | Back Yard : Yard | Tree | DPW 1 | 09/22/2017 04:31:00 PM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
| 61431 | 253549 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1000 Cayuga Ave | 17 | Back Yard : Yard | Tree | DPW 1 | 09/27/2017 11:46:00 AM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
| 71809 | 96274 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 55@ Alemany Trumbull St | 2 | Back Yard : Yard | Tree | Private 2 | 2 | 6004001.3006 | 2094332.00643 | 37.7308634942567 | -122.428485665086 | (37.7308634942567, -122.428485665086) | 9 | 7 | 6 | 28861 | 5 | ||||
| 87305 | 253547 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1000 Cayuga Ave | 15 | Back Yard : Yard | Tree | DPW 1 | 09/27/2017 11:40:00 AM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
| 150154 | 96278 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 55@ Alemany Trumbull St | 6 | Back Yard : Yard | Tree | Private 2 | 2 | 6003898.31997 | 2094328.29867 | 37.7308474854131 | -122.428841421596 | (37.7308474854131, -122.428841421596) | 9 | 7 | 6 | 28861 | 5 | ||||
| 196 | 116631 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 5732X GEARY BLVD | 12 | Front Yard : Cutout | Tree | MTA 3 | DPW | 3x3 | 5989254 | 2112678 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | 11 | 6 | 2 | 55 | 26 | |||
| 416 | 116621 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 5732X GEARY BLVD | 2 | Front Yard : Cutout | Tree | MTA 3 | DPW | 3x3 | 5989254 | 2112678 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | 11 | 6 | 2 | 55 | 26 | |||
| 6720 | 116625 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 5732X GEARY BLVD | 6 | Front Yard : Cutout | Tree | MTA 3 | DPW | 3x3 | 5989254 | 2112678 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | 11 | 6 | 2 | 55 | 26 | |||
| 34791 | 116627 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 5732X GEARY BLVD | 8 | Front Yard : Cutout | Tree | MTA 3 | DPW | 3x3 | 5989254 | 2112678 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | 11 | 6 | 2 | 55 | 26 | |||
| 36632 | 116630 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 5732X GEARY BLVD | 11 | Front Yard : Cutout | Tree | MTA 3 | DPW | 3x3 | 5989254 | 2112678 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | 11 | 6 | 2 | 55 | 26 | |||
| 54248 | 115888 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 811 TREAT AVE | 1 | Front Yard : Cutout | Tree | Private 2 | 20 | 3x3 | 6008597 | 2103712 | 37.7568778816719 | -122.413260590978 | (37.7568778816719, -122.413260590978) | 2 | 4 | 7 | 28859 | 19 | |||
| 85516 | 116628 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 5732X GEARY BLVD | 9 | Front Yard : Cutout | Tree | MTA 3 | DPW | 3x3 | 5989254 | 2112678 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | 11 | 6 | 2 | 55 | 26 | |||
| 89112 | 106184 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 1327 ULLOA ST | 1 | Front Yard : Cutout | Tree | Private 2 | FUF | 2 | 4x4 | 5991893.8 | 2098371.4 | 37.7412620575898 | -122.470636971077 | (37.7412620575898, -122.470636971077) | 1 | 8 | 4 | 59 | 40 | ||
| 102606 | 116620 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 5732X GEARY BLVD | 1 | Front Yard : Cutout | Tree | MTA 3 | DPW | 12 | 3x3 | 5989254 | 2112678 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | 11 | 6 | 2 | 55 | 26 | ||
| 107761 | 116629 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 5732X GEARY BLVD | 10 | Front Yard : Cutout | Tree | MTA 3 | DPW | 3x3 | 5989254 | 2112678 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | 11 | 6 | 2 | 55 | 26 | |||
| 134678 | 116624 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 5732X GEARY BLVD | 5 | Front Yard : Cutout | Tree | MTA 3 | DPW | 3x3 | 5989254 | 2112678 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | 11 | 6 | 2 | 55 | 26 | |||
| 167673 | 116622 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 5732X GEARY BLVD | 3 | Front Yard : Cutout | Tree | MTA 3 | DPW | 3x3 | 5989254 | 2112678 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | 11 | 6 | 2 | 55 | 26 | |||
| 174243 | 116623 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 5732X GEARY BLVD | 4 | Front Yard : Cutout | Tree | MTA 3 | DPW | 3x3 | 5989254 | 2112678 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | 11 | 6 | 2 | 55 | 26 | |||
| 67 | 99921 | Section 806 (d) 5 | Olea europaea :: Olive Tree 9 | 1740 Jones St | 1 | Front Yard : Yard | Tree | Private 2 | 06/01/2015 12:00:00 AM | 3 | Permit Number 774389 | 6008331.64636 | 2118443.68708 | 37.7973126906849 | -122.415221079511 | (37.7973126906849, -122.415221079511) | 5 | 1 | 10 | 308 | 21 | ||
| 357 | 232461 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1300 San Jose Ave | 12 | Front Yard : Yard | Tree | Private 2 | 11 | 6003612.68018 | 2095726.39764 | 37.7346701778724 | -122.429928614715 | (37.7346701778724, -122.429928614715) | 2 | 7 | 5 | 63 | 7 | ||||
| 3001 | 80365 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 500 Campbell Ave | 1 | Front Yard : Yard | Tree | Private 2 | FUF | 1 | 6010298.58269 | 2088549.93008 | 37.7153414628213 | -122.406307590233 | (37.7153414628213, -122.406307590233) | 9 | 7 | 8 | 309 | 39 | |||
| 5173 | 169519 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 1753 Noe St | 1 | Front Yard : Yard | Tree | Private 2 | 0 | 8x8 | Permit Number 779099 | 6003417.91334 | 2098032.77345 | 37.7409919262491 | -122.430766523865 | (37.7409919262491, -122.430766523865) | 2 | 7 | 5 | 63 | 7 |
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) );