trees
3,267 rows where qSpecies_id = 67 sorted by PlantDate
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||
12140 | 260108 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 921 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008890 | 2090823 | 37.7215039438499 | -122.411336776053 | (37.7215039438499, -122.411336776053) | 9 | 3 | 7 | 309 | 28 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
13824 | 101104 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1580 Noriega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 25190 | 5989126.9 | 2103185.1 | 37.754318820325 | -122.480556110859 | (37.754318820325, -122.480556110859) | 1 | 8 | 3 | 56 | 35 | ||||
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 | |||
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 | |||
14928 | 120545 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2195 18th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990654 | 2100514 | 37.7470733117967 | -122.475080088588 | (37.7470733117967, -122.475080088588) | 1 | 8 | 4 | 29491 | 40 | ||||
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 | |||
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 | |||
15598 | 112413 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 469x IVY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005169 | 2110996 | 37.7766849510116 | -122.425634307332 | (37.7766849510116, -122.425634307332) | 7 | 9 | 11 | 28852 | 10 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
19054 | 261690 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 181 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004415 | 2097502 | 37.7395909842107 | -122.427281162901 | (37.7395909842107, -122.427281162901) | 2 | 7 | 5 | 63 | 7 | ||||
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 | |||
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 | |||
19837 | 200793 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1574 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6015536.4716 | 2095847.5097 | 37.7356707824742 | -122.388712112413 | (37.7356707824742, -122.388712112413) | 10 | 3 | 8 | 58 | 1 | |||
19859 | 204521 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 400x Marietta Dr | 41 | Median : Cutout | Tree | DPW 1 | 15 | Width 3ft | 5999107.98616 | 2096985.95215 | 37.7378724775396 | -122.445593357764 | (37.7378724775396, -122.445593357764) | 9 | 7 | 4 | 59 | 40 | |||
20025 | 200070 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1531 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6015257.2685 | 2093882.9208 | 37.7302609400431 | -122.389540272139 | (37.7302609400431, -122.389540272139) | 10 | 3 | 8 | 58 | 1 | |||
20102 | 123930 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 211 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5993036.60641 | 2114007.84585 | 37.7842616458582 | -122.467822579411 | (37.7842616458582, -122.467822579411) | 11 | 6 | 2 | 54 | 11 | |||
20134 | 121874 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 198 18th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 5990255.88241 | 2114155.38481 | 37.7845057863421 | -122.477453587346 | (37.7845057863421, -122.477453587346) | 11 | 6 | 2 | 55 | 26 | |||
20172 | 204460 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 376 Magellan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5993909.76368 | 2099645.45971 | 37.7448766746103 | -122.463758987709 | (37.7448766746103, -122.463758987709) | 1 | 8 | 4 | 29491 | 40 | |||
20306 | 121801 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1235 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 6008572.2717 | 2110960.39862 | 37.7767789137416 | -122.413858829626 | (37.7767789137416, -122.413858829626) | 8 | 2 | 9 | 28853 | 34 | |||
20326 | 125762 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2399 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001485.39053 | 2119019.34574 | 37.7985061611824 | -122.438952098255 | (37.7985061611824, -122.438952098255) | 13 | 9 | 1 | 57 | 17 | |||
20370 | 205716 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 141 Taraval St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5993207.78236 | 2099148.98665 | 37.7434730091666 | -122.466150216684 | (37.7434730091666, -122.466150216684) | 1 | 8 | 4 | 59 | 40 | |||
20480 | 222416 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 35 Diamond St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6001716.41483 | 2105639.1941 | 37.7617807931825 | -122.437194157484 | (37.7617807931825, -122.437194157484) | 15 | 4 | 5 | 28862 | 3 | |||
20497 | 2478 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2303X Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6003659.52132 | 2115878.15996 | 37.7900047293604 | -122.431204600475 | (37.7900047293604, -122.431204600475) | 13 | 9 | 1 | 29490 | 27 | |||
20542 | 247885 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 387 Mayflower St | 6 | Side Yard : Yard | Tree | Private 2 | 11 | 6009895.87707 | 2098407.02536 | 37.7423844301873 | -122.408394391499 | (37.7423844301873, -122.408394391499) | 10 | 7 | 7 | 28859 | 2 | ||||
20579 | 175642 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 275 De Long St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 10ft | 5993719.3869 | 2086798.38844 | 37.709590783961 | -122.463485117168 | (37.709590783961, -122.463485117168) | 9 | 8 | 6 | 28861 | 25 | |||
20601 | 205709 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 141 Taraval St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5993183.34743 | 2099146.30567 | 37.7434642380824 | -122.466234511037 | (37.7434642380824, -122.466234511037) | 1 | 8 | 4 | 59 | 40 | |||
20625 | 188952 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1727 La Salle Ave | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6014856.84284 | 2096629.67768 | 37.7377807655571 | -122.391116524617 | (37.7377807655571, -122.391116524617) | 10 | 3 | 8 | 58 | 1 | |||
20790 | 182821 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1807 30th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5986876.8744 | 2102880.1943 | 37.7533506103474 | -122.488314760472 | (37.7533506103474, -122.488314760472) | 1 | 8 | 3 | 56 | 35 | |||
20911 | 188282 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 11 Rosie Lee Ln | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6018083.14168 | 2094370.92156 | 37.731757175754 | -122.379804637898 | (37.731757175754, -122.379804637898) | 10 | 3 | 8 | 58 | 1 |
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) );