trees
3,709 rows where qSpecies_id = 9 sorted by Longitude
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 134856 | 18557 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1700X Quesada Ave | 12 | Median : Cutout | Tree | DPW 1 | 12 | 19 | 6014589.42489 | 2095117.74479 | 37.7336144637386 | -122.391935430178 | (37.7336144637386, -122.391935430178) | 10 | 3 | 8 | 58 | 1 | |||
| 161780 | 254037 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1731 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/13/2017 12:00:00 AM | 3 | 12x2.5 | Permit Number 780972 | 6014574.1968 | 2095082.34136 | 37.7335164076979 | -122.391985603642 | (37.7335164076979, -122.391985603642) | 10 | 3 | 8 | 58 | 1 | |
| 42358 | 50355 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 200 Townsend St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | Permit Number 47030 | 6014664.3812076 | 2111605.18300999 | 37.7788895958171 | -122.392829354684 | (37.7788895958171, -122.392829354684) | 6 | 2 | 9 | 28856 | 34 | |||
| 63337 | 50358 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 200 Townsend St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774276 | 6014664.3812076 | 2111605.18300999 | 37.7788895958171 | -122.392829354684 | (37.7788895958171, -122.392829354684) | 6 | 2 | 9 | 28856 | 34 | |
| 66873 | 50353 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 200 Townsend St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | Permit Number 47030 | 6014664.3812076 | 2111605.18300999 | 37.7788895958171 | -122.392829354684 | (37.7788895958171, -122.392829354684) | 6 | 2 | 9 | 28856 | 34 | |||
| 115834 | 50354 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 200 Townsend St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | Permit Number 47030 | 6014664.3812076 | 2111605.18300999 | 37.7788895958171 | -122.392829354684 | (37.7788895958171, -122.392829354684) | 6 | 2 | 9 | 28856 | 34 | |||
| 146597 | 50356 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 200 Townsend St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | Permit Number 47030 | 6014664.3812076 | 2111605.18300999 | 37.7788895958171 | -122.392829354684 | (37.7788895958171, -122.392829354684) | 6 | 2 | 9 | 28856 | 34 | |||
| 180851 | 50357 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 200 Townsend St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | Permit Number 47030 | 6014664.3812076 | 2111605.18300999 | 37.7788895958171 | -122.392829354684 | (37.7788895958171, -122.392829354684) | 6 | 2 | 9 | 28856 | 34 | |||
| 87052 | 194141 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1150 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6014495.65311 | 2104838.55415 | 37.7603005567538 | -122.392939507061 | (37.7603005567538, -122.392939507061) | 10 | 3 | 8 | 28856 | 29 | |||
| 150277 | 194201 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 662 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6014609.10852 | 2111624.98762 | 37.778940904644 | -122.393021952422 | (37.778940904644, -122.393021952422) | 6 | 2 | 9 | 28856 | 34 | |||
| 34138 | 194200 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 662 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6014600.86316 | 2111636.1866 | 37.7789711964939 | -122.393051260428 | (37.7789711964939, -122.393051260428) | 6 | 2 | 9 | 28856 | 34 | |||
| 79646 | 194199 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 662 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6014592.76918 | 2111644.13802 | 37.7789925796789 | -122.393079817478 | (37.7789925796789, -122.393079817478) | 6 | 2 | 9 | 28856 | 34 | |||
| 90195 | 194198 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 662 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6014579.53841 | 2111655.87054 | 37.779024059548 | -122.393126409551 | (37.779024059548, -122.393126409551) | 6 | 2 | 9 | 28856 | 34 | |||
| 22082 | 194142 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1150 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6014441.06503 | 2104835.74487 | 37.760289810759 | -122.393128106577 | (37.760289810759, -122.393128106577) | 10 | 3 | 8 | 28856 | 29 | |||
| 57616 | 194197 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 662 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6014568.0664 | 2111668.64931 | 37.779058509869 | -122.393166990581 | (37.779058509869, -122.393166990581) | 6 | 2 | 9 | 28856 | 34 | |||
| 4050 | 173690 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 690X 03RD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2015 12:00:00 AM | 3x3 | 6014548 | 2111604 | 37.7788798826953 | -122.393231883862 | (37.7788798826953, -122.393231883862) | 6 | 2 | 9 | 28856 | 34 | |||
| 39870 | 173692 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 690X 03RD ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | 3x3 | 6014548 | 2111604 | 37.7788798826953 | -122.393231883862 | (37.7788798826953, -122.393231883862) | 6 | 2 | 9 | 28856 | 34 | |||
| 45341 | 173691 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 690X 03RD ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | 3x3 | 6014548 | 2111604 | 37.7788798826953 | -122.393231883862 | (37.7788798826953, -122.393231883862) | 6 | 2 | 9 | 28856 | 34 | |||
| 76566 | 116718 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 690X 03RD ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | 4 | 3x3 | 6014548 | 2111604 | 37.7788798826953 | -122.393231883862 | (37.7788798826953, -122.393231883862) | 6 | 2 | 9 | 28856 | 34 | ||
| 109650 | 173689 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 690X 03RD ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | 3x3 | 6014548 | 2111604 | 37.7788798826953 | -122.393231883862 | (37.7788798826953, -122.393231883862) | 6 | 2 | 9 | 28856 | 34 | |||
| 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 | |||
| 118937 | 194196 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 662 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6014545.33966 | 2111694.20215 | 37.7791274096345 | -122.393247400759 | (37.7791274096345, -122.393247400759) | 6 | 2 | 9 | 28856 | 34 | |||
| 108288 | 38776 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 660 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/21/2017 12:00:00 AM | 3 | Permit Number 779488 | 6014510.81012 | 2111730.04342 | 37.7792239033058 | -122.39336936233 | (37.7792239033058, -122.39336936233) | 6 | 2 | 9 | 28856 | 34 | |
| 11711 | 38775 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 660 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/1998 12:00:00 AM | 8 | Permit Number 40638 | 6014484.21875 | 2111755.81993 | 37.7792932023544 | -122.393463157999 | (37.7792932023544, -122.393463157999) | 6 | 2 | 9 | 28856 | 34 | |
| 144619 | 22376 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 5538 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6014077.5103 | 2092853.4647 | 37.7273687774645 | -122.393546865436 | (37.7273687774645, -122.393546865436) | 10 | 3 | 8 | 58 | 1 | |||
| 174446 | 22377 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 5538 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6014067.3893 | 2092832.2588 | 37.7273099879691 | -122.393580370471 | (37.7273099879691, -122.393580370471) | 10 | 3 | 8 | 58 | 1 | |||
| 121396 | 194145 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 101 Pennsylvania Ave | 2 | Front Yard : Yard | Tree | Private 2 | 1 | 6014334.84146 | 2106266.74633 | 37.7642131274542 | -122.393595642523 | (37.7642131274542, -122.393595642523) | 14 | 3 | 8 | 310 | 29 | ||||
| 132364 | 194143 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 398 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6014307.9415 | 2105321.38647 | 37.7616158808886 | -122.393622512488 | (37.7616158808886, -122.393622512488) | 10 | 3 | 8 | 28856 | 29 | |||
| 163434 | 194144 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 398 Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6014306.7738 | 2105309.42714 | 37.7615829782863 | -122.393625714059 | (37.7615829782863, -122.393625714059) | 10 | 3 | 8 | 28856 | 29 | |||
| 132402 | 194146 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 101 Pennsylvania Ave | 11 | Front Yard : Yard | Tree | Private 2 | 1 | 6014326.39851 | 2106410.8143 | 37.7646082374101 | -122.393634928533 | (37.7646082374101, -122.393634928533) | 14 | 3 | 8 | 310 | 29 | ||||
| 80862 | 194147 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 101 Pennsylvania Ave | 21 | Front Yard : Yard | Tree | Private 2 | 1 | 6014318.41099 | 2106520.50187 | 37.7649089715932 | -122.393670233204 | (37.7649089715932, -122.393670233204) | 14 | 3 | 8 | 310 | 29 | ||||
| 59802 | 194181 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1100 19th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 6014289.35036 | 2105289.58696 | 37.7615275332955 | -122.393684586385 | (37.7615275332955, -122.393684586385) | 10 | 3 | 8 | 28856 | 29 | |||
| 193627 | 194182 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1100 19th St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6014281.16459 | 2105289.06186 | 37.7615256366132 | -122.393712861061 | (37.7615256366132, -122.393712861061) | 10 | 3 | 8 | 28856 | 29 | |||
| 2720 | 194183 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1100 19th St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 6014273.14939 | 2105289.03804 | 37.7615251258084 | -122.393740580889 | (37.7615251258084, -122.393740580889) | 10 | 3 | 8 | 28856 | 29 | |||
| 93812 | 194184 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1100 19th St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 6014267.11596 | 2105288.72453 | 37.7615239296995 | -122.393761426258 | (37.7615239296995, -122.393761426258) | 10 | 3 | 8 | 28856 | 29 | |||
| 150607 | 194148 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 101 Pennsylvania Ave | 32 | Front Yard : Yard | Tree | Private 2 | 1 | 6014289.98871 | 2106632.9609 | 37.7652161800146 | -122.393776411647 | (37.7652161800146, -122.393776411647) | 14 | 3 | 8 | 310 | 29 | ||||
| 29510 | 194185 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1100 19th St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6014258.375 | 2105287.7993 | 37.7615209034762 | -122.393791593112 | (37.7615209034762, -122.393791593112) | 10 | 3 | 8 | 28856 | 29 | |||
| 25411 | 35425 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1500 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1998 12:00:00 AM | 1 | Permit Number 38875 | 6014191.96931 | 2102014.24795 | 37.7525287469064 | -122.393792121935 | (37.7525287469064, -122.393792121935) | 10 | 3 | 8 | 28856 | 29 | |
| 15955 | 194186 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1100 19th St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 6014251.5779 | 2105287.03748 | 37.7615184339579 | -122.393815048338 | (37.7615184339579, -122.393815048338) | 10 | 3 | 8 | 28856 | 29 | |||
| 269 | 194187 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1100 19th St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 6014241.14855 | 2105287.11165 | 37.7615180580268 | -122.393851124637 | (37.7615180580268, -122.393851124637) | 10 | 3 | 8 | 28856 | 29 | |||
| 68211 | 194188 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1100 19th St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 6014234.44538 | 2105287.05965 | 37.7615175427279 | -122.393874304681 | (37.7615175427279, -122.393874304681) | 10 | 3 | 8 | 28856 | 29 | |||
| 51734 | 194189 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1120 19th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 6014227.51606 | 2105285.95725 | 37.7615141306866 | -122.39389819336 | (37.7615141306866, -122.39389819336) | 10 | 3 | 8 | 28856 | 29 | |||
| 9397 | 194190 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1120 19th St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 6014220.74696 | 2105285.57644 | 37.7615127088737 | -122.393921578412 | (37.7615127088737, -122.393921578412) | 10 | 3 | 8 | 28856 | 29 | |||
| 84656 | 194191 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1120 19th St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 6014209.54825 | 2105284.76713 | 37.7615098643081 | -122.393960253779 | (37.7615098643081, -122.393960253779) | 10 | 3 | 8 | 28856 | 29 | |||
| 5300 | 194149 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 101 Pennsylvania Ave | 40 | Front Yard : Yard | Tree | Private 2 | 1 | 6014236.41284 | 2106693.24116 | 37.765378718967 | -122.393965939285 | (37.765378718967, -122.393965939285) | 14 | 3 | 8 | 28856 | 20 | ||||
| 173981 | 49805 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1142SSIPPI 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | 9 | Permit Number 46600 | 6014194.88278 | 2105753.61687 | 37.7627964083541 | -122.394043799009 | (37.7627964083541, -122.394043799009) | 14 | 3 | 8 | 28856 | 29 | |
| 11523 | 80597 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 443 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6014099.89803 | 2105040.34202 | 37.7608326316413 | -122.394322377476 | (37.7608326316413, -122.394322377476) | 10 | 3 | 8 | 28856 | 29 | |||
| 122463 | 69120 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 412 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/1994 12:00:00 AM | 7 | Permit Number 33138 | 6014035.5481 | 2105155.35128 | 37.7611448447834 | -122.394552990631 | (37.7611448447834, -122.394552990631) | 10 | 3 | 8 | 28856 | 29 | ||
| 164356 | 102011 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 469 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6014033.25215 | 2112677.25893 | 37.7817981973592 | -122.395087809375 | (37.7817981973592, -122.395087809375) | 6 | 2 | 9 | 28856 | 6 | |||
| 35295 | 22437 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6025 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6013597.3212 | 2091386.3105 | 37.7233135750036 | -122.39510416905 | (37.7233135750036, -122.39510416905) | 10 | 3 | 8 | 58 | 1 | |||
| 163943 | 30785 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 477 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2011 12:00:00 AM | 4 | 3x3 | Permit Number 768077 | 6014008.78756 | 2112650.38701 | 37.781723052716 | -122.395170563181 | (37.781723052716, -122.395170563181) | 6 | 2 | 9 | 28856 | 6 |
| 113954 | 30784 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 477 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2011 12:00:00 AM | 3 | Permit Number 768077 | 6013997.85284 | 2112638.1915 | 37.7816889585265 | -122.39520753791 | (37.7816889585265, -122.39520753791) | 6 | 2 | 9 | 28856 | 6 | |
| 52842 | 22433 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6000 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/1992 12:00:00 AM | 3 | 3X3 | 6013569.5341 | 2091525.6902 | 37.7236947383504 | -122.395209983132 | (37.7236947383504, -122.395209983132) | 10 | 3 | 8 | 58 | 1 | ||
| 117097 | 48876 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1230 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2002 12:00:00 AM | 7 | Permit Number 46083 | 6013856.10138 | 2105736.56258 | 37.7627307461431 | -122.395214338574 | (37.7627307461431, -122.395214338574) | 14 | 3 | 8 | 28856 | 29 | ||
| 187657 | 194203 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 485 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6013979.41846 | 2112620.06664 | 37.7816381665966 | -122.395270042584 | (37.7816381665966, -122.395270042584) | 6 | 2 | 9 | 28856 | 6 | |||
| 168304 | 22459 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6150 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6013537.9663 | 2091442.0718 | 37.7234633834037 | -122.395313253548 | (37.7234633834037, -122.395313253548) | 10 | 3 | 8 | 58 | 1 | |||
| 65335 | 22455 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 6146X 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/1996 12:00:00 AM | 12 | 3X3 | 6013520.36476 | 2091382.05626 | 37.7232976138509 | -122.395369896984 | (37.7232976138509, -122.395369896984) | 10 | 3 | 8 | 58 | 1 | ||
| 167965 | 22457 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6150X 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 6013494.5908 | 2091319.1743 | 37.7231235191025 | -122.395454590098 | (37.7231235191025, -122.395454590098) | 10 | 3 | 8 | 58 | 1 | ||||
| 150283 | 194180 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1300 19th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 4ft | 6013731.52974 | 2105262.35745 | 37.7614217541331 | -122.395611964818 | (37.7614217541331, -122.395611964818) | 10 | 3 | 8 | 28856 | 29 | |||
| 62809 | 194219 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1121 Jamestown Ave | 18 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 6013415.40609 | 2090027.00023 | 37.7195710634281 | -122.395637826651 | (37.7195710634281, -122.395637826651) | 10 | 3 | 8 | 58 | 1 | ||||
| 19850 | 194218 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1121 Jamestown Ave | 17 | Sidewalk: Curb side : Yard | Tree | Private 2 | 30 | 6013410.02884 | 2090031.5953 | 37.7195833814573 | -122.395656735769 | (37.7195833814573, -122.395656735769) | 10 | 3 | 8 | 58 | 1 | ||||
| 106687 | 194217 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1121 Jamestown Ave | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 27 | 6013395.77535 | 2090042.77857 | 37.7196132956026 | -122.395706788434 | (37.7196132956026, -122.395706788434) | 10 | 3 | 8 | 58 | 1 | ||||
| 132901 | 194216 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1121 Jamestown Ave | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6013384.67345 | 2090050.69381 | 37.7196344116892 | -122.395745718284 | (37.7196344116892, -122.395745718284) | 10 | 3 | 8 | 58 | 1 | ||||
| 171602 | 194215 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1121 Jamestown Ave | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 6013366.63798 | 2090065.79888 | 37.7196748838817 | -122.395809118718 | (37.7196748838817, -122.395809118718) | 10 | 3 | 8 | 58 | 1 | ||||
| 58659 | 194175 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 651 Missouri St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6013644.33168 | 2103874.07024 | 37.7576049693161 | -122.395816267403 | (37.7576049693161, -122.395816267403) | 10 | 3 | 8 | 28856 | 29 | ||||
| 160828 | 194176 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 651 Missouri St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6013621.31247 | 2103918.94326 | 37.7577269002821 | -122.395899022122 | (37.7577269002821, -122.395899022122) | 10 | 3 | 8 | 28856 | 29 | ||||
| 169223 | 194177 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 651 Missouri St | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6013615.77637 | 2103967.79396 | 37.7578607257013 | -122.395921591509 | (37.7578607257013, -122.395921591509) | 10 | 3 | 8 | 28856 | 29 | ||||
| 21543 | 43290 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1521 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | 13 | Permit Number 43058 | 6013412.47316 | 2104729.6995 | 37.7599414394556 | -122.396678114697 | (37.7599414394556, -122.396678114697) | 10 | 3 | 8 | 28856 | 29 | |
| 175976 | 12928 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6481X 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6013096.23046 | 2090034.75353 | 37.7195745928355 | -122.396741651947 | (37.7195745928355, -122.396741651947) | 10 | 3 | 8 | 58 | 1 | |||
| 185332 | 12929 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6481X 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6013096.23046 | 2090034.75353 | 37.7195745928355 | -122.396741651947 | (37.7195745928355, -122.396741651947) | 10 | 3 | 8 | 58 | 1 | |||
| 33765 | 114495 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 506 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6013529.42992 | 2111411.97981 | 37.7782959999017 | -122.396742081688 | (37.7782959999017, -122.396742081688) | 6 | 2 | 9 | 28856 | 34 | |||
| 126142 | 69441 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 598 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/16/1994 12:00:00 AM | 7 | Permit Number 33548 | 6013520.05596 | 2111448.24133 | 37.7783950440445 | -122.396777052727 | (37.7783950440445, -122.396777052727) | 6 | 2 | 9 | 28856 | 34 | |
| 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 | |||
| 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 | |||
| 11947 | 114496 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 506 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6013514.3964 | 2111397.60401 | 37.778255690483 | -122.396793080454 | (37.778255690483, -122.396793080454) | 6 | 2 | 9 | 28856 | 34 | |||
| 22646 | 114497 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 506 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6013500.00708 | 2111383.84435 | 37.7782171086788 | -122.396841893834 | (37.7782171086788, -122.396841893834) | 6 | 2 | 9 | 28856 | 34 | |||
| 29216 | 66152 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 524 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/28/1990 12:00:00 AM | 1 | Permit Number 29222 | 6013567.57589 | 2114946.80542 | 37.7880039412658 | -122.396858007884 | (37.7880039412658, -122.396858007884) | 12 | 2 | 9 | 28855 | 6 | ||
| 179680 | 114498 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 506 Brannan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/27/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777227 | 6013489.27726 | 2111373.99556 | 37.778189468908 | -122.396878321792 | (37.778189468908, -122.396878321792) | 6 | 2 | 9 | 28856 | 34 | |
| 32000 | 194202 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 578 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6013469.95477 | 2111501.26737 | 37.7785378527742 | -122.396954091481 | (37.7785378527742, -122.396954091481) | 6 | 2 | 9 | 28856 | 34 | |||
| 177443 | 67718 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 578 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1992 12:00:00 AM | 4 | Permit Number 31332 | 6013462.54602 | 2111509.80626 | 37.7785608862176 | -122.3969803202 | (37.7785608862176, -122.3969803202) | 6 | 2 | 9 | 28856 | 34 | |
| 192589 | 22511 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6424 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6013025.9659 | 2090108.36392 | 37.719772801157 | -122.396989691115 | (37.719772801157, -122.396989691115) | 10 | 3 | 8 | 58 | 1 | |||
| 79435 | 22512 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6424 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6013020.80961 | 2090093.5041 | 37.719731712041 | -122.397006473368 | (37.719731712041, -122.397006473368) | 10 | 3 | 8 | 58 | 1 | |||
| 85424 | 22513 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6424 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6013017.34088 | 2090082.06317 | 37.7197001044495 | -122.39701766186 | (37.7197001044495, -122.39701766186) | 10 | 3 | 8 | 58 | 1 | |||
| 54899 | 194214 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1030 Le Conte Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6013004.48576 | 2089699.06872 | 37.7186477627738 | -122.397035257987 | (37.7186477627738, -122.397035257987) | 10 | 3 | 8 | 58 | 1 | |||
| 138217 | 22519 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 6520X 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6012970.43876 | 2089969.7044 | 37.719388978809 | -122.397171912348 | (37.719388978809, -122.397171912348) | 10 | 3 | 8 | 58 | 1 | |||
| 15702 | 66427 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 95 Carr St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/1991 12:00:00 AM | 8 | Permit Number 29569 | 6012980.71061 | 2090558.71757 | 37.7210068625643 | -122.397177686318 | (37.7210068625643, -122.397177686318) | 10 | 3 | 8 | 58 | 1 | ||
| 60988 | 194221 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1080 Key Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 6012968.46094 | 2090076.8184 | 37.7196829822717 | -122.397186255957 | (37.7196829822717, -122.397186255957) | 10 | 3 | 8 | 58 | 1 | |||
| 187048 | 194222 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1080 Key Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 6012957.45228 | 2090084.12895 | 37.7197024427026 | -122.397224821584 | (37.7197024427026, -122.397224821584) | 10 | 3 | 8 | 58 | 1 | |||
| 145738 | 12932 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6540X 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6012937.6533 | 2089925.98182 | 37.7192671001169 | -122.39728217588 | (37.7192671001169, -122.39728217588) | 10 | 3 | 8 | 58 | 1 | |||
| 165879 | 12933 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6540X 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6012937.6533 | 2089925.98182 | 37.7192671001169 | -122.39728217588 | (37.7192671001169, -122.39728217588) | 10 | 3 | 8 | 58 | 1 | |||
| 130480 | 194223 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1080 Key Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 6012938.89979 | 2090098.87174 | 37.7197418905657 | -122.397289984657 | (37.7197418905657, -122.397289984657) | 10 | 3 | 8 | 58 | 1 | |||
| 74424 | 22518 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6518 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6012926.62983 | 2089906.00338 | 37.7192116295963 | -122.397318879858 | (37.7192116295963, -122.397318879858) | 10 | 3 | 8 | 58 | 1 | |||
| 85570 | 194220 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6524 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6012914.00103 | 2089890.00071 | 37.7191669863524 | -122.397361411494 | (37.7191669863524, -122.397361411494) | 10 | 3 | 8 | 58 | 1 | |||
| 158487 | 22520 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6530 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/1992 12:00:00 AM | 6 | 3X3 | 6012891.87458 | 2089879.75625 | 37.719137625171 | -122.397437176644 | (37.719137625171, -122.397437176644) | 10 | 3 | 8 | 58 | 1 | ||
| 183582 | 62098 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 263 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51774 | 6013213.82245 | 2105839.16693 | 37.7629767350191 | -122.397442964743 | (37.7629767350191, -122.397442964743) | 14 | 3 | 8 | 28856 | 29 | |
| 129712 | 111972 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 240 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2015 12:00:00 AM | 1 | 3x3 | 6012967.33594 | 2095411.30766 | 37.7343303393552 | -122.39756408274 | (37.7343303393552, -122.39756408274) | 10 | 3 | 8 | 58 | 1 | ||
| 34785 | 22523 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6600 03rd St | 3 | Median : Cutout | Tree | DPW 1 | 12 | 3X3 | 6012847.5284056 | 2089784.7633559 | 37.7188743244909 | -122.397583806576 | (37.7188743244909, -122.397583806576) | 10 | 3 | 8 | 58 | 1 | |||
| 20943 | 54784 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 201 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50703 | 6012788.79472 | 2087552.61474 | 37.7127420182918 | -122.397630353754 | (37.7127420182918, -122.397630353754) | 10 | 3 | 8 | 309 | 1 | |
| 129374 | 110930 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2 Connecticut St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 6013101.5791 | 2106846.11839 | 37.7657353505351 | -122.397901817734 | (37.7657353505351, -122.397901817734) | 14 | 3 | 8 | 28856 | 20 | ||||
| 161414 | 39557 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2 Connecticut St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | 10 | Permit Number 40979 | 6013095.63903 | 2106895.18187 | 37.7658697371335 | -122.397925805346 | (37.7658697371335, -122.397925805346) | 14 | 3 | 8 | 28856 | 20 |
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) );