trees
3,267 rows where qSpecies_id = 67 sorted by qLegalStatus_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10804 | 125788 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2812 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 6ft | 5999154.81918 | 2118474.67758 | 37.7968777722368 | -122.446977352345 | (37.7968777722368, -122.446977352345) | 13 | 9 | 1 | 57 | 17 | |||
| 10882 | 32604 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1327 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 6 | Permit Number 37070 | 5985214.1986 | 2106157.4162 | 37.7622518049359 | -122.494306102635 | (37.7622518049359, -122.494306102635) | 1 | 8 | 3 | 56 | 35 | |
| 10973 | 10788 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1200X Hudson Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x4 | 6017715.9911991 | 2094753.0263542 | 37.7327861010711 | -122.381100521913 | (37.7327861010711, -122.381100521913) | 10 | 3 | 8 | 58 | 1 | |||
| 10999 | 31902 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 965 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | 14 | Permit Number 35327 | 6008027.66279 | 2109898.08591 | 37.7738314549808 | -122.415667565898 | (37.7738314549808, -122.415667565898) | 8 | 2 | 9 | 28853 | 34 | |
| 11001 | 222338 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3847 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6002778.03156 | 2102959.54865 | 37.7544834197881 | -122.433330965848 | (37.7544834197881, -122.433330965848) | 2 | 4 | 5 | 28862 | 22 | |||
| 11008 | 125832 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1700 Vallejo St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6005294.88878 | 2118203.51089 | 37.7964820948146 | -122.425711940964 | (37.7964820948146, -122.425711940964) | 13 | 9 | 1 | 28858 | 17 | |||
| 11399 | 73153 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1970 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6001494.4295 | 2115195.887 | 37.7880084528635 | -122.438646710686 | (37.7880084528635, -122.438646710686) | 13 | 6 | 1 | 29490 | 27 | |||
| 11604 | 54558 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 50 Maddux Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/1972 12:00:00 AM | 8 | Permit Number 10353 | 6012731.08144 | 2095469.91543 | 37.7344781060868 | -122.398385007285 | (37.7344781060868, -122.398385007285) | 10 | 3 | 8 | 58 | 1 | ||
| 11637 | 220924 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 121 Bradford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6009569.56061 | 2097892.28263 | 37.7409527796372 | -122.409486379805 | (37.7409527796372, -122.409486379805) | 10 | 7 | 7 | 28859 | 2 | |||
| 11996 | 204552 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 60 | Median : Cutout | Tree | DPW 1 | 11 | Width 5ft | 5999641.44525 | 2097441.40723 | 37.7391534907361 | -122.443781647414 | (37.7391534907361, -122.443781647414) | 9 | 7 | 4 | 59 | 40 | |||
| 12005 | 222475 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1712 Sanchez St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 3ft | 6003947.79258 | 2098269.9182 | 37.7416730781499 | -122.428951298963 | (37.7416730781499, -122.428951298963) | 2 | 7 | 5 | 63 | 7 | |||
| 12081 | 69044 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1426 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1994 12:00:00 AM | 2 | Permit Number 33051 | 5984041.3218 | 2105444.0326 | 37.7602243472537 | -122.498309886187 | (37.7602243472537, -122.498309886187) | 1 | 8 | 3 | 56 | 35 | |
| 12114 | 78378 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 35 Russia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6001605.25452 | 2090913.72299 | 37.7213417817901 | -122.436524599656 | (37.7213417817901, -122.436524599656) | 9 | 7 | 6 | 28861 | 5 | |||
| 12167 | 259578 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 350 Public Park | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 3x3 | 5994424 | 2098888 | 37.7428264992104 | -122.461925951337 | (37.7428264992104, -122.461925951337) | 1 | 8 | 4 | 59 | 40 | ||||
| 12234 | 112475 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1799X Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5988753.5421 | 2104412.2034 | 37.7576664111078 | -122.481937145542 | (37.7576664111078, -122.481937145542) | 1 | 8 | 3 | 56 | 35 | |||
| 12374 | 65607 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 182 Maynard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/09/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767458 | 6004579.16944 | 2093759.75788 | 37.7293249116129 | -122.426447147525 | (37.7293249116129, -122.426447147525) | 9 | 7 | 6 | 28861 | 5 |
| 12455 | 222436 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 277 Corbett Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999681.48171 | 2105384.26851 | 37.760964945302 | -122.444213835499 | (37.760964945302, -122.444213835499) | 15 | 5 | 5 | 28862 | 3 | |||
| 12481 | 220975 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 27 Dawnview Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5998722.32011 | 2100761.22513 | 37.7482164410366 | -122.447198415596 | (37.7482164410366, -122.447198415596) | 2 | 5 | 5 | 63 | 38 | |||
| 12522 | 125844 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1463 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6006489.38359 | 2117961.8198 | 37.7958858973642 | -122.421561549045 | (37.7958858973642, -122.421561549045) | 13 | 9 | 10 | 28858 | 32 | |||
| 12669 | 222494 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 21 Harry St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 2ft | 6003368.61725 | 2097750.91511 | 37.7402152150692 | -122.430916860842 | (37.7402152150692, -122.430916860842) | 2 | 7 | 5 | 63 | 7 | |||
| 12837 | 47215 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 106 Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 6 | Permit Number 45166 | 6006633.47627 | 2094299.61445 | 37.7309231552671 | -122.419383490876 | (37.7309231552671, -122.419383490876) | 9 | 7 | 7 | 309 | 5 | |
| 12851 | 188928 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6012639.77007 | 2101842.50365 | 37.7519707940373 | -122.39914787158 | (37.7519707940373, -122.39914787158) | 10 | 3 | 8 | 28856 | 29 | |||
| 12915 | 120365 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2250 Cabrillo St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5988577.68715 | 2110575.68251 | 37.7745794071716 | -122.482997045151 | (37.7745794071716, -122.482997045151) | 11 | 6 | 2 | 55 | 26 | |||
| 12936 | 189036 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 90 Russ St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010111.83402 | 2111767.71706 | 37.7790819623998 | -122.408589963453 | (37.7790819623998, -122.408589963453) | 14 | 2 | 9 | 28853 | 34 | |||
| 13010 | 247253 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1118 Waller St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6000028.37595 | 2108519.10482 | 37.7695922091358 | -122.443239243804 | (37.7695922091358, -122.443239243804) | 15 | 5 | 11 | 29492 | 9 | |||
| 13088 | 8817 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3800 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5995279.8386756 | 2112876.8357526 | 37.7812854712581 | -122.459979879431 | (37.7812854712581, -122.459979879431) | 11 | 6 | 2 | 54 | 11 | |||
| 13274 | 188254 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1039 Jamestown Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6013780.02718 | 2089753.49239 | 37.7188403408752 | -122.39435831441 | (37.7188403408752, -122.39435831441) | 10 | 3 | 8 | 58 | 1 | ||||
| 13378 | 73382 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 502 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6001158.1468 | 2110520.1446 | 37.7751509205215 | -122.439474878934 | (37.7751509205215, -122.439474878934) | 15 | 5 | 11 | 29492 | 10 | |||
| 13380 | 55308 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1595 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/1972 12:00:00 AM | 10 | Permit Number 11237 | 6005282.80537 | 2119544.50402 | 37.8001634372533 | -122.425849253052 | (37.8001634372533, -122.425849253052) | 13 | 9 | 1 | 57 | 17 | ||
| 13520 | 175634 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 29 Tucker Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010973.25986 | 2088486.32565 | 37.7152045356343 | -122.403971122781 | (37.7152045356343, -122.403971122781) | 9 | 7 | 8 | 309 | 39 | |||
| 14011 | 247884 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 387 Mayflower St | 5 | Side Yard : Yard | Tree | Private 2 | 8 | 6009916.04567 | 2098399.55514 | 37.7423650480079 | -122.408324127476 | (37.7423650480079, -122.408324127476) | 10 | 7 | 7 | 28859 | 2 | ||||
| 14118 | 125818 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2081 Green St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6003105.57534 | 2118201.45062 | 37.7963524818244 | -122.433287285795 | (37.7963524818244, -122.433287285795) | 13 | 9 | 1 | 57 | 17 | |||
| 14482 | 175650 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Cardenas Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 5990453.87404 | 2090277.74723 | 37.7189555611377 | -122.475024995517 | (37.7189555611377, -122.475024995517) | 1 | 8 | 4 | 64 | 14 | |||
| 14659 | 55328 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 225 Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1972 12:00:00 AM | 8 | Permit Number 11259 | 6011565.54063 | 2089256.51546 | 37.717352394562 | -122.40197804257 | (37.717352394562, -122.40197804257) | 10 | 7 | 8 | 309 | 39 | ||
| 14798 | 199912 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1319 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6016381.1458 | 2093047.4167 | 37.728029062608 | -122.385596634641 | (37.728029062608, -122.385596634641) | 10 | 3 | 8 | 58 | 1 | |||
| 14824 | 188911 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6012384.77523 | 2101833.46813 | 37.751931770655 | -122.400029051595 | (37.751931770655, -122.400029051595) | 10 | 3 | 8 | 28856 | 29 | |||
| 14853 | 188956 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1706 La Salle Ave | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6014961.30392 | 2096622.74747 | 37.7377675329349 | -122.390754864938 | (37.7377675329349, -122.390754864938) | 10 | 3 | 8 | 58 | 1 | |||
| 14863 | 222337 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 584 Diamond St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6001829.51468 | 2102403.81265 | 37.7529036455068 | -122.436571403945 | (37.7529036455068, -122.436571403945) | 2 | 4 | 5 | 28862 | 22 | |||
| 14974 | 71651 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 177 Wilson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5994505.19973 | 2086471.6739 | 37.7087389470079 | -122.460745569971 | (37.7087389470079, -122.460745569971) | 9 | 8 | 6 | 28861 | 25 | |||
| 15023 | 125822 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2301 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6003751.95692 | 2115935.88569 | 37.7901684673368 | -122.430888902704 | (37.7901684673368, -122.430888902704) | 13 | 9 | 1 | 29490 | 27 | |||
| 15047 | 222339 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 902 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003088.6063 | 2102957.06813 | 37.7544942233475 | -122.432256740954 | (37.7544942233475, -122.432256740954) | 2 | 4 | 5 | 28862 | 22 | |||
| 15197 | 205713 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 141 Taraval St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5993198.15008 | 2099148.55003 | 37.7434712545842 | -122.466183490689 | (37.7434712545842, -122.466183490689) | 1 | 8 | 4 | 59 | 40 | |||
| 15203 | 70396 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 309 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6005777.21829 | 2092245.96314 | 37.7252360153268 | -122.422197872442 | (37.7252360153268, -122.422197872442) | 9 | 7 | 7 | 309 | 5 | |||
| 15208 | 56135 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 719 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/1973 12:00:00 AM | 10 | Permit Number 12238 | 6012444.68154 | 2104578.12119 | 37.7594713278533 | -122.400014612979 | (37.7594713278533, -122.400014612979) | 10 | 3 | 8 | 28856 | 29 | ||
| 15293 | 78417 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3345 Ocean Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5988680.63361 | 2095198.47268 | 37.7323636938327 | -122.481514509695 | (37.7323636938327, -122.481514509695) | 1 | 8 | 4 | 64 | 35 | |||
| 15323 | 222453 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 349 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004042.83429 | 2109029.18488 | 37.7712208597768 | -122.429389756259 | (37.7712208597768, -122.429389756259) | 7 | 9 | 11 | 29492 | 10 | |||
| 15396 | 71222 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2207 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5987585.8685 | 2100255.6538 | 37.746185666387 | -122.485670338512 | (37.746185666387, -122.485670338512) | 1 | 8 | 3 | 29491 | 35 | |||
| 15502 | 78224 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1214 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6009704.84764 | 2090538.93921 | 37.7207696402774 | -122.408500030351 | (37.7207696402774, -122.408500030351) | 9 | 3 | 7 | 309 | 28 | |||
| 15573 | 10975 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1468X Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016410.2814628 | 2096936.3836856 | 37.7387090009717 | -122.385766856192 | (37.7387090009717, -122.385766856192) | 10 | 3 | 8 | 58 | 1 | |||
| 15665 | 222485 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 45 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002560.02403 | 2096411.24476 | 37.7364909407996 | -122.433616928699 | (37.7364909407996, -122.433616928699) | 2 | 7 | 5 | 63 | 7 | |||
| 15793 | 42348 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 380X Flood Ave | 7 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2000 12:00:00 AM | 3 | 8x45 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 |
| 15816 | 26895 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1245X Lane St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4 | 6015870.9547371 | 2095407.1210845 | 37.7344800964063 | -122.387524951 | (37.7344800964063, -122.387524951) | 10 | 3 | 8 | 58 | 1 | |||
| 15917 | 247048 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 537 Valley St | 2 | : | Tree | Private 2 | 8 | Width 3ft | 6002432.31725 | 2099137.61339 | 37.7439696696596 | -122.434253316852 | (37.7439696696596, -122.434253316852) | 2 | 7 | 5 | 63 | 22 | |||
| 16073 | 222257 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 34 Putnam St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009162.53021 | 2097236.17229 | 37.7391284284365 | -122.410847419192 | (37.7391284284365, -122.410847419192) | 10 | 7 | 7 | 28859 | 2 | |||
| 16154 | 188901 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1640 20th St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 3ft | 6013030.31907 | 2104757.32999 | 37.7599960301161 | -122.39800174768 | (37.7599960301161, -122.39800174768) | 10 | 3 | 8 | 28856 | 29 | |||
| 16202 | 8839 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4000 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 12 | M6 | 5994660.7719396 | 2112852.5225639 | 37.7811830898725 | -122.462119766821 | (37.7811830898725, -122.462119766821) | 11 | 6 | 2 | 54 | 11 | |||
| 16254 | 189034 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 50 Russ St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010058.78317 | 2111821.06751 | 37.7792254789148 | -122.408777253584 | (37.7792254789148, -122.408777253584) | 14 | 2 | 9 | 28853 | 34 | |||
| 16361 | 188907 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1551 19th St | 3 | : | Tree | Private 2 | 8 | Width 3ft | 6013010.92349 | 2105173.17566 | 37.7611367706692 | -122.398098002138 | (37.7611367706692, -122.398098002138) | 10 | 3 | 8 | 28856 | 29 | |||
| 16632 | 42238 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 479 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 3 | Permit Number 42487 | 6010497.26908 | 2112250.8624 | 37.7804301450699 | -122.407290649051 | (37.7804301450699, -122.407290649051) | 14 | 2 | 9 | 28853 | 34 | |
| 16704 | 30848 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1153 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/16/1995 12:00:00 AM | 14 | Permit Number 34697 | 6002549.89906 | 2102133.17334 | 37.7522014449412 | -122.434060837652 | (37.7522014449412, -122.434060837652) | 2 | 4 | 5 | 28862 | 22 | |
| 16774 | 8683 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2900 Geary Blvd | 10 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5998150.0688375 | 2113145.5858248 | 37.7821880464461 | -122.450069715057 | (37.7821880464461, -122.450069715057) | 15 | 6 | 1 | 54 | 31 | |||
| 16874 | 55307 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2770 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2012 12:00:00 AM | 2 | Permit Number 769514 | 6005272.5834 | 2119510.27332 | 37.8000688708465 | -122.42588218711 | (37.8000688708465, -122.42588218711) | 13 | 9 | 1 | 57 | 17 | ||
| 16928 | 118190 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 830 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5985433.46743 | 2110210.14946 | 37.7733922984241 | -122.493846418352 | (37.7733922984241, -122.493846418352) | 11 | 6 | 2 | 55 | 26 | |||
| 17030 | 220770 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 54 Pearl St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6005613.92059 | 2108688.47135 | 37.7703741651755 | -122.423931067487 | (37.7703741651755, -122.423931067487) | 8 | 2 | 5 | 28853 | 19 | |||
| 17168 | 8947 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4800 Geary Blvd | 7 | Median : Cutout | Tree | DPW 1 | 3 | M6 | 5992178.808881 | 2112763.6040387 | 37.780795730088 | -122.470699570025 | (37.780795730088, -122.470699570025) | 11 | 6 | 2 | 54 | 11 | |||
| 17297 | 189039 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 90 Russ St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010144.76793 | 2111731.54232 | 37.7789844794824 | -122.408473478765 | (37.7789844794824, -122.408473478765) | 14 | 2 | 9 | 28853 | 34 | |||
| 17307 | 74930 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4045 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5982222.2441 | 2104869.0336 | 37.7585387287405 | -122.50455850909 | (37.7585387287405, -122.50455850909) | 1 | 8 | 3 | 56 | 35 | |||
| 17440 | 188953 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1723 La Salle Ave | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6014879.29111 | 2096612.07207 | 37.7377336698595 | -122.391037679267 | (37.7377336698595, -122.391037679267) | 10 | 3 | 8 | 58 | 1 | |||
| 17521 | 142554 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 670 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6008032.7708 | 2121023.624 | 37.8043797498479 | -122.416438106574 | (37.8043797498479, -122.416438106574) | 5 | 1 | 10 | 308 | 32 | |||
| 17591 | 222359 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 496 Alvarado St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003219.50427 | 2102739.56773 | 37.7539044398485 | -122.431788533216 | (37.7539044398485, -122.431788533216) | 2 | 4 | 5 | 28862 | 22 | |||
| 17592 | 205706 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 141 Taraval St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5993174.64326 | 2099144.25251 | 37.7434580984164 | -122.466264458435 | (37.7434580984164, -122.466264458435) | 1 | 8 | 4 | 59 | 40 | |||
| 17841 | 107624 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 467 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6011064.4697 | 2111919.17259 | 37.7795511306237 | -122.405305061079 | (37.7795511306237, -122.405305061079) | 14 | 2 | 9 | 28853 | 34 | |||
| 17947 | 222204 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1 Worth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6000891.10082 | 2103189.05131 | 37.7550063494651 | -122.439872903318 | (37.7550063494651, -122.439872903318) | 2 | 4 | 5 | 28862 | 22 | |||
| 17982 | 222370 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 474 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003587.51416 | 2105510.95685 | 37.7615348690537 | -122.430713623055 | (37.7615348690537, -122.430713623055) | 15 | 4 | 5 | 28862 | 3 | |||
| 18096 | 222289 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 414 Jarboe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008310.20149 | 2096947.01161 | 37.7382866279206 | -122.413773947135 | (37.7382866279206, -122.413773947135) | 2 | 7 | 7 | 28859 | 2 | |||
| 18175 | 259579 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 398 Public Park | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 3x3 | 5994369 | 2098919 | 37.7429084509163 | -122.462118372119 | (37.7429084509163, -122.462118372119) | 1 | 8 | 4 | 59 | 40 | ||||
| 18204 | 125749 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2672 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6000224.25426 | 2118193.8188 | 37.7961676486817 | -122.443256684343 | (37.7961676486817, -122.443256684343) | 13 | 9 | 1 | 57 | 17 | |||
| 18263 | 182776 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1588 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5989115.047 | 2103129.9656 | 37.754166747114 | -122.480593065279 | (37.754166747114, -122.480593065279) | 1 | 8 | 3 | 56 | 35 | |||
| 18312 | 220994 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 610 Clipper St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6001267.97032 | 2100902.17536 | 37.7487485824887 | -122.438405750225 | (37.7487485824887, -122.438405750225) | 2 | 4 | 5 | 28862 | 22 | |||
| 18314 | 204568 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 61 Burnside Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6001187.03477 | 2095752.39336 | 37.7346038888419 | -122.438316738047 | (37.7346038888419, -122.438316738047) | 2 | 7 | 5 | 63 | 7 | ||||
| 18488 | 9093 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5700 Geary Blvd | 6 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5989210.8329 | 2112629.8539 | 37.7802564116082 | -122.48095732695 | (37.7802564116082, -122.48095732695) | 11 | 6 | 2 | 55 | 26 | |||
| 18532 | 205861 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 78 Montana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 1ft | 5996047.17386 | 2089324.02533 | 37.7166594390586 | -122.455622364282 | (37.7166594390586, -122.455622364282) | 9 | 8 | 6 | 28861 | 24 | |||
| 18558 | 220932 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 56 Mirabel Ave | 1 | Front Yard : Cutout | Tree | DPW 1 | 3 | 3x3 | Permit Number 785183 | 6007687.03242 | 2099968.45973 | 37.7465478380206 | -122.416142489803 | (37.7465478380206, -122.416142489803) | 2 | 7 | 7 | 28859 | 2 | ||
| 18810 | 222355 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3723 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6003572.59677 | 2103006.45022 | 37.7546572452572 | -122.430586499386 | (37.7546572452572, -122.430586499386) | 2 | 4 | 5 | 28862 | 22 | |||
| 18815 | 199909 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1335 Shafter Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 11 | Width 0ft | 6016305.1286 | 2093102.5016 | 37.7281761084423 | -122.385863268846 | (37.7281761084423, -122.385863268846) | 10 | 3 | 8 | 58 | 1 | |||
| 18867 | 53701 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2656 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/18/1970 12:00:00 AM | 12 | Permit Number 6647 | 5999210.43552 | 2117936.02801 | 37.7954019613927 | -122.446746130351 | (37.7954019613927, -122.446746130351) | 13 | 9 | 1 | 57 | 17 | ||
| 18975 | 220935 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 155 Appleton Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006002.55434 | 2096896.9185 | 37.7380192208112 | -122.421749109831 | (37.7380192208112, -122.421749109831) | 2 | 7 | 7 | 28859 | 2 | |||
| 19003 | 188986 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Maddux Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6012667.64033 | 2095215.60548 | 37.7337762895405 | -122.398586505788 | (37.7337762895405, -122.398586505788) | 10 | 3 | 8 | 58 | 1 | |||
| 19025 | 222376 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 468 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002942.3584 | 2105536.15659 | 37.7615674892747 | -122.4329467503 | (37.7615674892747, -122.4329467503) | 15 | 4 | 5 | 28862 | 3 | |||
| 19238 | 220864 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3902 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004445.39995 | 2100759.97843 | 37.7485383641568 | -122.427408084817 | (37.7485383641568, -122.427408084817) | 2 | 4 | 5 | 28862 | 22 | |||
| 19318 | 217698 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 170 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5992683.9237 | 2097587.0358 | 37.7391540498051 | -122.467847991527 | (37.7391540498051, -122.467847991527) | 1 | 8 | 4 | 59 | 40 | |||
| 19471 | 188996 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1770 La Salle Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6014669.28207 | 2096840.44612 | 37.7383490822538 | -122.391779751256 | (37.7383490822538, -122.391779751256) | 10 | 3 | 8 | 58 | 1 | |||
| 19634 | 53513 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1370 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1973 12:00:00 AM | 11 | Permit Number 12550 | 6015991.6954 | 2093066.1456 | 37.7280589319949 | -122.386944294451 | (37.7280589319949, -122.386944294451) | 10 | 3 | 8 | 58 | 1 | ||
| 19656 | 125824 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2210 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6004068.4927 | 2116354.72552 | 37.7913364249795 | -122.429823600886 | (37.7913364249795, -122.429823600886) | 13 | 9 | 1 | 29490 | 27 | |||
| 19661 | 175653 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 5988966.88544 | 2089648.46014 | 37.7171414055178 | -122.480118843736 | (37.7171414055178, -122.480118843736) | 1 | 8 | 4 | 64 | 14 | ||||
| 19708 | 2726 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2211 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002817.4873 | 2114756.5606 | 37.7868773504916 | -122.434037754471 | (37.7868773504916, -122.434037754471) | 13 | 9 | 11 | 29490 | 27 | |||
| 19761 | 222251 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 579 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008186.23233 | 2096156.66605 | 37.7361095491164 | -122.414146672953 | (37.7361095491164, -122.414146672953) | 2 | 7 | 7 | 28859 | 2 | |||
| 19762 | 123002 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 22 07th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993654.52362 | 2115347.42219 | 37.7879754176374 | -122.465782182912 | (37.7879754176374, -122.465782182912) | 11 | 6 | 1 | 54 | 11 | |||
| 19793 | 204525 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 400x Marietta Dr | 35 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 5999144.59173 | 2097002.17091 | 37.7379191001944 | -122.44546796079 | (37.7379191001944, -122.44546796079) | 9 | 7 | 4 | 59 | 40 | |||
| 19821 | 4865 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 32 Crags Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/14/1992 12:00:00 AM | 35 | 3X3 | 6000909.0364823 | 2098039.6345395 | 37.7408683019977 | -122.439441771578 | (37.7408683019977, -122.439441771578) | 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) );