trees
3,709 rows where qSpecies_id = 9 sorted by rowid descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 194497 | 161370 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 530 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x3 | 6002550.45613 | 2090822.0233 | 37.7211436611464 | -122.433250757115 | (37.7211436611464, -122.433250757115) | 9 | 7 | 6 | 28861 | 5 | |||
| 194462 | 233115 | Prune Opt Out 3 | Olea europaea :: Olive Tree 9 | 29 Kronquist Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | Permit Number 788008 | 6002251.64499 | 2100180.50663 | 37.7468229532305 | -122.434952608978 | (37.7468229532305, -122.434952608978) | 2 | 7 | 5 | 63 | 22 | ||
| 194457 | 233114 | Prune Opt Out 3 | Olea europaea :: Olive Tree 9 | 29 Kronquist Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | Permit Number 788008 | 6002253.24641 | 2100155.04403 | 37.7467531298542 | -122.434945250724 | (37.7467531298542, -122.434945250724) | 2 | 7 | 5 | 63 | 22 | ||
| 194435 | 103878 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 791 Vienna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2017 12:00:00 AM | 3 | 6x6 | Permit Number 776939 | 6002377.91546 | 2088944.75079 | 37.7159792979937 | -122.433713076995 | (37.7159792979937, -122.433713076995) | 9 | 7 | 6 | 28861 | 5 | |
| 194431 | 265089 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 747 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002550 | 2089172 | 37.7166130372881 | -122.433134500018 | (37.7166130372881, -122.433134500018) | 9 | 7 | 6 | 28861 | 5 | ||||
| 194367 | 56573 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 250 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/2019 12:00:00 AM | 3 | 5x5 | 6010068.531 | 2121298.26 | 37.8052481034096 | -122.409412549107 | (37.8052481034096, -122.409412549107) | 3 | 1 | 10 | 308 | 23 | ||
| 194309 | 214611 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1325 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | Width 2ft | Permit Number 780527 | 5993298.90225 | 2106431.45371 | 37.7634740439193 | -122.466364312861 | (37.7634740439193, -122.466364312861) | 1 | 8 | 11 | 56 | 12 | |
| 194308 | 204823 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1325 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 780527 | 5993302.77838 | 2106404.87542 | 37.7634012905668 | -122.466348974927 | (37.7634012905668, -122.466348974927) | 1 | 8 | 11 | 56 | 12 | |
| 194306 | 264992 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 721 Irving St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 780527 | 5993542.41381 | 2106613.40944 | 37.7639876944061 | -122.465535310621 | (37.7639876944061, -122.465535310621) | 1 | 8 | 11 | 56 | 12 | |
| 194196 | 142624 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1715 STOCKTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6010019.4916 | 2119981.5764 | 37.8016300687184 | -122.409489272704 | (37.8016300687184, -122.409489272704) | 3 | 1 | 10 | 308 | 23 | |||
| 194187 | 51521 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 743 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/13/2005 12:00:00 AM | 6 | Permit Number 47824 | 5983198.06767 | 2110736.10989 | 37.7747053938125 | -122.501617774439 | (37.7747053938125, -122.501617774439) | 11 | 6 | 2 | 55 | 26 | |
| 193963 | 17739 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1339X Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/1992 12:00:00 AM | 6 | 3X3 | 6002224.0418527 | 2113098.314365 | 37.7822905309042 | -122.435972235897 | (37.7822905309042, -122.435972235897) | 15 | 5 | 11 | 29490 | 41 | ||
| 193925 | 1427 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 65 Arguello Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 5X5PL | 5995465.80895 | 2115602.75583 | 37.7887808090871 | -122.459534003067 | (37.7887808090871, -122.459534003067) | 11 | 6 | 1 | 54 | 11 | |||
| 193899 | 194160 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 850 Carolina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6012410.93258 | 2104077.30942 | 37.7580943272971 | -122.400096162605 | (37.7580943272971, -122.400096162605) | 10 | 3 | 8 | 28856 | 29 | |||
| 193795 | 132023 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 928 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007881.27524 | 2120306.58627 | 37.8024024244937 | -122.416911537842 | (37.8024024244937, -122.416911537842) | 5 | 1 | 1 | 308 | 32 | |||
| 193701 | 210609 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1265 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5994217.96426 | 2106915.76714 | 37.7648568297895 | -122.463220740766 | (37.7648568297895, -122.463220740766) | 11 | 5 | 11 | 56 | 12 | |||
| 193649 | 233674 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 355 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002852.36128 | 2101503.85208 | 37.7504906385289 | -122.432969920439 | (37.7504906385289, -122.432969920439) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 | |||
| 193587 | 210846 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 32 Valletta Ct | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5999371.80606 | 2096444.1801 | 37.7363999581985 | -122.444642277914 | (37.7363999581985, -122.444642277914) | 9 | 7 | 4 | 63 | 40 | |||
| 193517 | 47181 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 201 26th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2002 12:00:00 AM | 6 | 4.5x6 | Permit Number 45142 | 5987713.21287 | 2114556.61779 | 37.785459589237 | -122.486279710203 | (37.785459589237, -122.486279710203) | 11 | 6 | 1 | 55 | 26 |
| 193445 | 232946 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 40 Jersey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004897.91883 | 2101663.1471 | 37.7510438394105 | -122.425907561499 | (37.7510438394105, -122.425907561499) | 2 | 4 | 5 | 28862 | 22 | |||
| 193440 | 18851 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2195 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6004377.36753 | 2116024.81596 | 37.7904480629835 | -122.428731372449 | (37.7904480629835, -122.428731372449) | 13 | 9 | 1 | 28858 | 27 | |||
| 193437 | 233637 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 758x San Jose Ave | 2 | Median : Cutout | Tree | DPW 1 | 4 | Width 3ft | 6005642.24056 | 2098618.09907 | 37.7427248694691 | -122.423117200821 | (37.7427248694691, -122.423117200821) | 2 | 7 | 7 | 28859 | 2 | |||
| 193433 | 178034 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1378x Geneva Ave | 2 | Median : Yard | Tree | DPW 1 | 7 | 6002495.00651 | 2087816.3446 | 37.7128875861582 | -122.433227774048 | (37.7128875861582, -122.433227774048) | 9 | 7 | 6 | 28861 | 5 | ||||
| 193424 | 233763 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 29 Belcher St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003807.8031 | 2108151.33307 | 37.768797183273 | -122.430140102893 | (37.768797183273, -122.430140102893) | 7 | 9 | 5 | 28862 | 3 | |||
| 193337 | 184540 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3131 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5984528.9702 | 2103585.9441 | 37.7551511364506 | -122.496486253509 | (37.7551511364506, -122.496486253509) | 1 | 8 | 3 | 56 | 35 | |||
| 193295 | 39638 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 555 Arch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41032 | 5992713.01716207 | 2090887.82450944 | 37.7207613551784 | -122.46726042451 | (37.7207613551784, -122.46726042451) | 9 | 8 | 6 | 64 | 24 | ||
| 193284 | 177865 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 989 Naples St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001720.67634 | 2088389.37557 | 37.7144170451902 | -122.43594508462 | (37.7144170451902, -122.43594508462) | 9 | 7 | 6 | 28861 | 5 | |||
| 193283 | 232962 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 10 Carmel St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5998932.61026 | 2105423.58947 | 37.7610301587293 | -122.446806673598 | (37.7610301587293, -122.446806673598) | 15 | 5 | 11 | 29492 | 12 | |||
| 193158 | 178007 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 99 Trumbull St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004047.84176 | 2094334.75752 | 37.7308736817673 | -122.42832496073 | (37.7308736817673, -122.42832496073) | 9 | 7 | 6 | 28861 | 5 | |||
| 193124 | 232950 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 410 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003783.54215 | 2100140.11142 | 37.7467988981531 | -122.429652575025 | (37.7467988981531, -122.429652575025) | 2 | 7 | 5 | 63 | 22 | |||
| 193115 | 68187 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3590 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/1993 12:00:00 AM | 8 | Permit Number 31963 | 5997636.2297 | 2115794.80313 | 37.7894326798088 | -122.452038555144 | (37.7894326798088, -122.452038555144) | 11 | 6 | 1 | 54 | 31 | ||
| 193085 | 1417 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 15 Arguello Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X5 | 5995446.00012 | 2115789.30403 | 37.7892918808868 | -122.459616055153 | (37.7892918808868, -122.459616055153) | 11 | 6 | 1 | 54 | 11 | |||
| 193056 | 113612 | Section 143 10 | Olea europaea :: Olive Tree 9 | 595 ALABAMA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 3x3 | 6009000 | 2105472 | 37.7617330585457 | -122.411991234579 | (37.7617330585457, -122.411991234579) | 8 | 4 | 7 | 28859 | 19 | |||
| 193018 | 210716 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 224 Farallones St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5994841.51939 | 2088418.33199 | 37.7141033580681 | -122.459724118176 | (37.7141033580681, -122.459724118176) | 9 | 8 | 6 | 28861 | 24 | |||
| 192946 | 232848 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 845 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008580.13412 | 2103620.66511 | 37.7566261498966 | -122.413312460905 | (37.7566261498966, -122.413312460905) | 2 | 4 | 7 | 28859 | 19 | |||
| 192822 | 210673 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 116 Dorado Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5994621.31128 | 2093151.84201 | 37.727087777865 | -122.460828081873 | (37.727087777865, -122.460828081873) | 9 | 8 | 4 | 28861 | 40 | |||
| 192664 | 233715 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 4400 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001323.43234 | 2104683.24656 | 37.7591336477134 | -122.438484830315 | (37.7591336477134, -122.438484830315) | 2 | 4 | 5 | 28862 | 3 | |||
| 192598 | 233064 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1037 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6001346.73145 | 2100610.16606 | 37.7479512741444 | -122.438112480405 | (37.7479512741444, -122.438112480405) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 | |||
| 192576 | 232469 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1300 San Jose Ave | 33 | Front Yard : Yard | Tree | Private 2 | 10 | 6003464.52997 | 2095634.55653 | 37.7344096119087 | -122.430434269353 | (37.7344096119087, -122.430434269353) | 2 | 7 | 5 | 63 | 7 | ||||
| 192554 | 232920 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3893 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6004542.27754 | 2101311.7699 | 37.7500589342791 | -122.427112380544 | (37.7500589342791, -122.427112380544) | 2 | 4 | 5 | 28862 | 22 | |||
| 192497 | 122229 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 761 14th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5991623.94602 | 2110243.98291 | 37.7738454364146 | -122.472435352053 | (37.7738454364146, -122.472435352053) | 11 | 6 | 2 | 54 | 26 | |||
| 192490 | 210795 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 88 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5992506.66983 | 2098544.35554 | 37.741772370506 | -122.468530483796 | (37.741772370506, -122.468530483796) | 1 | 8 | 4 | 29491 | 40 | |||
| 192460 | 809 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 600X 39th Ave | 7 | Median : Cutout | Tree | DPW 1 | 6 | 6-HOA | 5983831.1679936 | 2111715.0127262 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | 11 | 6 | 2 | 55 | 26 | |||
| 192411 | 18815 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1800X Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6006086.60229 | 2116306.71294 | 37.7913186696705 | -122.422837564717 | (37.7913186696705, -122.422837564717) | 13 | 9 | 1 | 28858 | 27 | |||
| 192390 | 233087 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 61 Homestead St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6000994.9382 | 2101341.57112 | 37.7499395241022 | -122.439381383367 | (37.7499395241022, -122.439381383367) | 2 | 4 | 5 | 28862 | 22 | |||
| 192389 | 177931 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Bucareli Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 5988808.76092 | 2089375.86435 | 37.7163837365992 | -122.480645454328 | (37.7163837365992, -122.480645454328) | 1 | 8 | 4 | 64 | 14 | ||||
| 192263 | 177961 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Grijalva Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 5989118.28423 | 2089183.86132 | 37.7158745287534 | -122.479561562622 | (37.7158745287534, -122.479561562622) | 1 | 8 | 4 | 64 | 14 | ||||
| 192124 | 232466 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1300 San Jose Ave | 23 | Front Yard : Yard | Tree | Private 2 | 12 | 6003503.44574 | 2095655.81053 | 37.7344701749411 | -122.430301240716 | (37.7344701749411, -122.430301240716) | 2 | 7 | 5 | 63 | 7 | ||||
| 192072 | 210676 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 105 Maywood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5994232.52898 | 2095915.26292 | 37.7346530772751 | -122.46237243275 | (37.7346530772751, -122.46237243275) | 9 | 8 | 4 | 59 | 40 | |||
| 191976 | 232859 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 660 York St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009811.5773 | 2105096.24111 | 37.7607468102296 | -122.409157786424 | (37.7607468102296, -122.409157786424) | 2 | 4 | 8 | 28859 | 19 | |||
| 191883 | 218170 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1434 Portola Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 5992917.22018 | 2097403.64204 | 37.73866396546 | -122.467028035039 | (37.73866396546, -122.467028035039) | 1 | 8 | 4 | 59 | 40 | |||
| 191848 | 13048 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 540 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:08:00 PM | 3 | 3x3 | 6009740.68961 | 2120642.26789 | 37.8034285381407 | -122.410500739276 | (37.8034285381407, -122.410500739276) | 3 | 1 | 10 | 308 | 23 | ||
| 191801 | 1415 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 15 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X5 | 5995460.39194 | 2115783.72708 | 37.7892773956462 | -122.45956585741 | (37.7892773956462, -122.45956585741) | 11 | 6 | 1 | 54 | 11 | |||
| 191664 | 43935 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1900 11th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/2000 12:00:00 AM | Permit Number 43523 | 5992873.88147935 | 2102526.51410864 | 37.7527275651303 | -122.467550320151 | (37.7527275651303, -122.467550320151) | 1 | 8 | 4 | 29491 | 12 | |||
| 191644 | 51457 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 501 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/2004 12:00:00 AM | Permit Number 47772 | 6007598.88566769 | 2095737.65957423 | 37.7349260410204 | -122.416147708857 | (37.7349260410204, -122.416147708857) | 2 | 7 | 7 | 28859 | 2 | ||
| 191605 | 18613 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 645 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5992222.8127 | 2088500.1488 | 37.7141770675516 | -122.468781240528 | (37.7141770675516, -122.468781240528) | 9 | 8 | 6 | 64 | 24 | |||
| 191572 | 177880 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 439 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010673.53523 | 2092649.98514 | 37.7266203372468 | -122.405300143582 | (37.7266203372468, -122.405300143582) | 10 | 3 | 7 | 309 | 28 | |||
| 191455 | 117750 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 415 39th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 4ft | 5983735.53337 | 2113025.8643 | 37.7810239479026 | -122.499927891557 | (37.7810239479026, -122.499927891557) | 11 | 6 | 2 | 55 | 26 | |||
| 191402 | 210873 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 62 Marston Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 5998923.83927 | 2093227.89544 | 37.7275432251404 | -122.445959824297 | (37.7275432251404, -122.445959824297) | 9 | 7 | 4 | 28861 | 40 | |||
| 191342 | 55286 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1259 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/1972 12:00:00 AM | 9 | Permit Number 11212 | 5988298.2438 | 2106737.9903 | 37.7640258998421 | -122.483682252657 | (37.7640258998421, -122.483682252657) | 1 | 8 | 3 | 56 | 35 | ||
| 191195 | 50239 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1446 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/2003 12:00:00 AM | 4 | Permit Number 46945 | 5985903.9099 | 2105369.6531 | 37.7601291639736 | -122.491862687346 | (37.7601291639736, -122.491862687346) | 1 | 8 | 3 | 56 | 35 | |
| 191162 | 2000 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 500X Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/22/2004 12:00:00 AM | 12 | 3X3 | 6002728.1222807 | 2095276.2570246 | 37.733384060718 | -122.432954679755 | (37.733384060718, -122.432954679755) | 2 | 7 | 5 | 63 | 7 | ||
| 191152 | 141168 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1901 O'Farrell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6002181.99 | 2113276.5722 | 37.7827775927641 | -122.43613047662 | (37.7827775927641, -122.43613047662) | 15 | 5 | 11 | 29490 | 41 | |||
| 191147 | 80027 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 258 11th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50612 | 5992475.28108 | 2113734.99529 | 37.7834800444352 | -122.46974467857 | (37.7834800444352, -122.46974467857) | 11 | 6 | 2 | 54 | 11 | |
| 191119 | 9730 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 637 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x4 | 6005783.8123 | 2111973.7899 | 37.7794044450654 | -122.423577021981 | (37.7794044450654, -122.423577021981) | 7 | 9 | 11 | 28852 | 41 | |||
| 191115 | 140972 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2330 O'Farrell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6000189.5474 | 2113039.1932 | 37.7820124123021 | -122.443006413955 | (37.7820124123021, -122.443006413955) | 15 | 5 | 1 | 29490 | 16 | |||
| 191042 | 37100 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1538 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/09/2003 12:00:00 AM | 6 | Permit Number 46585 | 5981585.229 | 2104585.7036 | 37.7577232947481 | -122.506740540912 | (37.7577232947481, -122.506740540912) | 1 | 8 | 3 | 56 | 35 | |
| 190929 | 138052 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1801 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6003417.3541 | 2114976.1709 | 37.7875143701184 | -122.431978042658 | (37.7875143701184, -122.431978042658) | 13 | 9 | 11 | 29490 | 27 | |||
| 190899 | 131996 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2526 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007018.30389 | 2120919.94417 | 37.8040379702445 | -122.419941400575 | (37.8040379702445, -122.419941400575) | 5 | 1 | 1 | 28858 | 32 | |||
| 190890 | 121354 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 399X Cargo Way | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6017829 | 2098352 | 37.7426744040176 | -122.380959936377 | (37.7426744040176, -122.380959936377) | 10 | 3 | 8 | 58 | 1 | |||
| 190819 | 138520 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2180 POST ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6001715.6385 | 2113960.819 | 37.784629854048 | -122.437792875854 | (37.784629854048, -122.437792875854) | 13 | 6 | 11 | 29490 | 13 | |||
| 190775 | 18996 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3001 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/10/2011 12:00:00 AM | 6 | 3x3 | 6000347.20569 | 2115461.97657 | 37.7886737365383 | -122.442635001919 | (37.7886737365383, -122.442635001919) | 13 | 6 | 1 | 29490 | 27 | ||
| 190737 | 233210 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 421 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007049.61539 | 2097875.22188 | 37.7407644148534 | -122.418198232968 | (37.7407644148534, -122.418198232968) | 2 | 7 | 7 | 28859 | 2 | |||
| 190725 | 132014 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1059 Vallejo St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6008488.51458 | 2118614.01673 | 37.797789188388 | -122.414690333816 | (37.797789188388, -122.414690333816) | 5 | 1 | 10 | 308 | 21 | ||||
| 190658 | 102732 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1217 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6016939.1559 | 2092633.1782 | 37.7269225044661 | -122.383638730259 | (37.7269225044661, -122.383638730259) | 10 | 3 | 8 | 58 | 1 | |||
| 190565 | 19035 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3227 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5999339.77887 | 2115319.94044 | 37.7882262635735 | -122.446110316852 | (37.7882262635735, -122.446110316852) | 13 | 6 | 1 | 29490 | 31 | |||
| 190479 | 8761 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3355 Geary Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/10/1994 12:00:00 AM | 3 | 3X3 | 5996781.7933 | 2112879.265 | 37.7813784089154 | -122.454784059286 | (37.7813784089154, -122.454784059286) | 11 | 6 | 2 | 54 | 16 | ||
| 190300 | 194161 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 882 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6012411.15187 | 2103867.3361 | 37.7575177989154 | -122.400080658315 | (37.7575177989154, -122.400080658315) | 10 | 3 | 8 | 28856 | 29 | |||
| 190055 | 119375 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 870 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5986062.66321 | 2109973.28361 | 37.7727787239531 | -122.491652532124 | (37.7727787239531, -122.491652532124) | 11 | 6 | 2 | 55 | 26 | |||
| 190001 | 177942 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Josepha Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5989710.75871 | 2089436.68507 | 37.7166031181237 | -122.477532185763 | (37.7166031181237, -122.477532185763) | 1 | 8 | 4 | 64 | 14 | ||||
| 189997 | 9192 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6138 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 4X4 | 5987910.6661 | 2112635.8342 | 37.7801971691873 | -122.485455585501 | (37.7801971691873, -122.485455585501) | 11 | 6 | 2 | 55 | 26 | |||
| 189969 | 139012 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2569 SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6000213.2565 | 2114045.1151 | 37.7847757661737 | -122.442996653485 | (37.7847757661737, -122.442996653485) | 15 | 6 | 11 | 29490 | 13 | |||
| 189959 | 87209 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 157 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2008 12:00:00 AM | 1 | 3x3 | Permit Number 50220 | 5988004.21673 | 2114956.06701 | 37.7865733196184 | -122.48530225694 | (37.7865733196184, -122.48530225694) | 11 | 6 | 1 | 55 | 33 | |
| 189951 | 210644 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2240 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5990741.44467 | 2100142.94942 | 37.7460595708971 | -122.474750637535 | (37.7460595708971, -122.474750637535) | 1 | 8 | 4 | 29491 | 40 | |||
| 189878 | 49929 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 661@ 20th ST Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/02/2003 12:00:00 AM | Permit Number 46686 | 6007929.10907089 | 2104086.31182212 | 37.757868136537 | -122.415596914544 | (37.757868136537, -122.415596914544) | 2 | 4 | 7 | 28859 | 19 | ||
| 189809 | 8989 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 5145 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5990994.34586 | 2112623.63727 | 37.7803428541028 | -122.47478694253 | (37.7803428541028, -122.47478694253) | 11 | 6 | 2 | 54 | 26 | |||
| 189429 | 248224 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 71 Fair Ave | 1 | Side Yard : Yard | Tree | Private 2 | 11 | 6007158.82795 | 2099359.78048 | 37.7448468279249 | -122.417925827442 | (37.7448468279249, -122.417925827442) | 2 | 7 | 7 | 28859 | 2 | ||||
| 189229 | 88020 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 198 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 51047 | 6008282.3 | 2112522.3 | 37.7810512330082 | -122.41497250722 | (37.7810512330082, -122.41497250722) | 7 | 10 | 9 | 28852 | 36 | ||
| 189213 | 210872 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 371 Staples Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 5997627.30354 | 2093781.83319 | 37.7289900868006 | -122.450481853864 | (37.7289900868006, -122.450481853864) | 9 | 7 | 4 | 28861 | 40 | |||
| 189196 | 233663 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 4228 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001688.82561 | 2102366.10628 | 37.7527921169643 | -122.437055232911 | (37.7527921169643, -122.437055232911) | 2 | 4 | 5 | 28862 | 22 | |||
| 189151 | 35163 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 308 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/1998 12:00:00 AM | Permit Number 38695 | 6002288.53719642 | 2109541.57984353 | 37.7725282925067 | -122.435494593001 | (37.7725282925067, -122.435494593001) | 15 | 5 | 11 | 29492 | 9 | ||
| 189066 | 131968 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2654 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006939.68178 | 2121495.98775 | 37.805615209341 | -122.420254387139 | (37.805615209341, -122.420254387139) | 5 | 1 | 1 | 28858 | 32 | |||
| 189053 | 80939 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 84 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52317 | 6005052.37903 | 2092785.76243 | 37.7266772742187 | -122.424741955571 | (37.7266772742187, -122.424741955571) | 9 | 7 | 6 | 28861 | 5 | |
| 188980 | 210675 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 105 Maywood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5994239.22716 | 2095898.63187 | 37.7346077982181 | -122.462348069202 | (37.7346077982181, -122.462348069202) | 9 | 8 | 4 | 59 | 40 | |||
| 188930 | 252933 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 72 Edgar Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997141 | 2091205 | 37.7218868659906 | -122.451977199572 | (37.7218868659906, -122.451977199572) | 9 | 8 | 6 | 28861 | 24 | |||||
| 188838 | 23692 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 444 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/16/2002 12:00:00 AM | 6 | 3X3 | 6012360.1719452 | 2117827.4460445 | 37.795846218583 | -122.401237940514 | (37.795846218583, -122.401237940514) | 3 | 1 | 10 | 28860 | 4 | ||
| 188820 | 18910 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2606 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | Permit Number 776094 | 6002223.7217 | 2115788.31992 | 37.7896765820735 | -122.436165905566 | (37.7896765820735, -122.436165905566) | 13 | 6 | 1 | 29490 | 27 | ||
| 188812 | 42041 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2 Jersey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42361 | 6005111.36941388 | 2101648.34848969 | 37.7510152664316 | -122.425168374318 | (37.7510152664316, -122.425168374318) | 2 | 4 | 5 | 28862 | 22 |
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) );