trees
612 rows where SiteOrder = 1 and qSpecies_id = 65 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24073 | 221906 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 879 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6002491.82292 | 2103096.81966 | 37.7548440920015 | -122.434330562332 | (37.7548440920015, -122.434330562332) | 2 | 4 | 5 | 28862 | 22 | |||
| 24861 | 221804 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 266 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 39 | Width 4ft | 6004140.40735 | 2099573.26288 | 37.7452626636546 | -122.42837817451 | (37.7452626636546, -122.42837817451) | 2 | 7 | 5 | 63 | 22 | |||
| 25181 | 221922 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 142 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002658.74413 | 2105066.93812 | 37.7602630379377 | -122.433894115042 | (37.7602630379377, -122.433894115042) | 2 | 4 | 5 | 28862 | 3 | |||
| 27163 | 90684 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3932 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5983372.77926 | 2110387.45649 | 37.773758352537 | -122.500987630515 | (37.773758352537, -122.500987630515) | 11 | 6 | 2 | 55 | 26 | ||
| 28974 | 90762 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4025 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5983154.65976 | 2110328.999009 | 37.7735850356272 | -122.501737802253 | (37.7735850356272, -122.501737802253) | 11 | 6 | 2 | 55 | 26 | |
| 29613 | 218232 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 371 Wawona St | 1 | : | Tree | Private 2 | 33 | Width 2ft | 5991901.5455 | 2097060.86466 | 37.7376641082099 | -122.47051476505 | (37.7376641082099, -122.47051476505) | 1 | 8 | 4 | 59 | 40 | |||
| 29996 | 83821 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1514 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50163 | 5981890.7885 | 2104754.0668 | 37.7582035604252 | -122.505696289301 | (37.7582035604252, -122.505696289301) | 1 | 8 | 3 | 56 | 35 | |
| 30965 | 90685 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3940 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5983336.42617 | 2110385.20717 | 37.7737500419678 | -122.501113213178 | (37.7737500419678, -122.501113213178) | 11 | 6 | 2 | 55 | 26 | ||
| 31198 | 84402 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1852 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51006 | 6000688.3478 | 2111734.5053 | 37.778458498926 | -122.441187160325 | (37.778458498926, -122.441187160325) | 15 | 5 | 11 | 29490 | 41 | |
| 31207 | 32474 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 7 Ord St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1996 12:00:00 AM | 15 | Permit Number 36982 | 6000854.39467 | 2106273.37873 | 37.7634730690508 | -122.440221013784 | (37.7634730690508, -122.440221013784) | 15 | 5 | 5 | 28862 | 3 | |
| 31637 | 117427 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 690 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2016 12:00:00 AM | 3 | Permit Number 776915 | 6002940.91679 | 2089412.44819 | 37.7172954225231 | -122.431800455543 | (37.7172954225231, -122.431800455543) | 9 | 7 | 6 | 28861 | 5 | ||
| 32001 | 221822 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 129 Ellert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6007356.42456 | 2097004.67982 | 37.7383913638823 | -122.417075731561 | (37.7383913638823, -122.417075731561) | 2 | 7 | 7 | 28859 | 2 | |||
| 32465 | 96841 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4426 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2011 12:00:00 AM | 3 | 3x3 | Permit Number 54781 | 5981806.97545 | 2111010.8887 | 37.7753780521761 | -122.506450142023 | (37.7753780521761, -122.506450142023) | 11 | 6 | 2 | 55 | 26 |
| 33222 | 203575 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 60 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 5ft | 6001009.56246 | 2095231.0134 | 37.7331622045591 | -122.438892966938 | (37.7331622045591, -122.438892966938) | 9 | 7 | 5 | 63 | 40 | |||
| 33233 | 67291 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 701 Peru Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1992 12:00:00 AM | 19 | Permit Number 30767 | 6005304.50618 | 2092488.24493 | 37.725874593313 | -122.423849212975 | (37.725874593313, -122.423849212975) | 9 | 7 | 7 | 309 | 5 | |
| 33356 | 138630 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1702 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6000078.3648 | 2114795.7207 | 37.7868290426993 | -122.443517270296 | (37.7868290426993, -122.443517270296) | 13 | 6 | 1 | 29490 | 27 | |||
| 34536 | 221809 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1216 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5998224.25103 | 2106127.66613 | 37.7629228845101 | -122.449307297897 | (37.7629228845101, -122.449307297897) | 15 | 5 | 11 | 29492 | 9 | |||
| 35034 | 221861 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 246 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6004637.65749 | 2096950.59035 | 37.7380895280136 | -122.426472056954 | (37.7380895280136, -122.426472056954) | 2 | 7 | 5 | 63 | 7 | |||
| 35107 | 90767 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3927 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5983459.813129 | 2110340.073929 | 37.7736333636338 | -122.50068306697 | (37.7736333636338, -122.50068306697) | 11 | 6 | 2 | 55 | 26 | |
| 35299 | 203521 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 54 Aloha Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5991886.81261 | 2104359.60659 | 37.757703719373 | -122.471097283818 | (37.757703719373, -122.471097283818) | 1 | 8 | 4 | 56 | 12 | |||
| 36087 | 67371 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1009 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1992 12:00:00 AM | 17 | Permit Number 30864 | 5992480.35304 | 2110659.61111 | 37.7750361697588 | -122.469503188985 | (37.7750361697588, -122.469503188985) | 11 | 6 | 2 | 54 | 11 | |
| 36626 | 245863 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 138 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781995 | 6005228.3599 | 2109588.7098 | 37.7728242280559 | -122.42532879528 | (37.7728242280559, -122.42532879528) | 7 | 9 | 11 | 28852 | 10 | |
| 38029 | 203546 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 431 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 2ft | 5997874.7531 | 2094083.70134 | 37.7298331050033 | -122.449648149961 | (37.7298331050033, -122.449648149961) | 9 | 7 | 4 | 28861 | 40 | |||
| 38083 | 90692 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4040 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/06/2013 12:00:00 AM | 3 | 3x3 | 5983028.8678 | 2110374.29859 | 37.7737020255392 | -122.502176281286 | (37.7737020255392, -122.502176281286) | 11 | 6 | 2 | 55 | 26 | ||
| 38326 | 221845 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Marys Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6004371.42755 | 2095618.1193 | 37.7344158100226 | -122.427297656166 | (37.7344158100226, -122.427297656166) | 2 | 7 | 5 | 28861 | 25 | |||
| 39037 | 124123 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 83 Stanyan Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 5ft | 5996382.54086 | 2112452.81509 | 37.7801845808517 | -122.456134428556 | (37.7801845808517, -122.456134428556) | 11 | 6 | 2 | 54 | 16 | |||
| 39358 | 203544 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 522 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 2ft | 5997938.28847 | 2094411.07212 | 37.730735622335 | -122.449452080662 | (37.730735622335, -122.449452080662) | 9 | 7 | 4 | 59 | 40 | |||
| 39918 | 41209 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3241 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/1999 12:00:00 AM | 48 | Permit Number 41916 | 6000362.60573 | 2119451.91027 | 37.7996299225355 | -122.442868349911 | (37.7996299225355, -122.442868349911) | 13 | 9 | 1 | 57 | 17 | |
| 40098 | 182924 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2627 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5981795.9682 | 2097192.3992 | 37.7374357552632 | -122.505463727969 | (37.7374357552632, -122.505463727969) | 1 | 8 | 3 | 29491 | 35 | |||
| 41894 | 221832 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 573 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007293.28891 | 2103997.59658 | 37.7575887842104 | -122.417789563935 | (37.7575887842104, -122.417789563935) | 2 | 4 | 7 | 28859 | 19 | |||
| 42770 | 221831 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 569 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007292.05586 | 2104018.90213 | 37.7576472149557 | -122.417795338504 | (37.7576472149557, -122.417795338504) | 2 | 4 | 7 | 28859 | 19 | |||
| 43315 | 38214 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 331 Wayland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | 11 | Permit Number 40337 | 6010588.27199 | 2092325.30166 | 37.7257240567036 | -122.405572039215 | (37.7257240567036, -122.405572039215) | 10 | 3 | 7 | 309 | 28 | |
| 44449 | 117949 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3851 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5983596.58663 | 2110338.47485 | 37.7736370016896 | -122.500209835883 | (37.7736370016896, -122.500209835883) | 11 | 6 | 2 | 55 | 26 | |||
| 45102 | 52520 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 54 Norton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | 30 | Permit Number 48621 | 6001810.81862 | 2092293.71669 | 37.7251426126309 | -122.4359127153 | (37.7251426126309, -122.4359127153) | 9 | 7 | 6 | 28861 | 25 | |
| 45404 | 221907 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1217 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6003244.02772 | 2101149.87665 | 37.7495409130801 | -122.431590240821 | (37.7495409130801, -122.431590240821) | 2 | 4 | 5 | 28862 | 22 | |||
| 47768 | 221885 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 100 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008227.02437 | 2099369.61702 | 37.7449338966774 | -122.414232888254 | (37.7449338966774, -122.414232888254) | 2 | 7 | 7 | 28859 | 2 | |||
| 47876 | 37084 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1487 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 9 | Permit Number 39685 | 5982148.9004 | 2105004.528 | 37.7589064434103 | -122.504822200215 | (37.7589064434103, -122.504822200215) | 1 | 8 | 3 | 56 | 35 | |
| 48427 | 109287 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2646 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773636 | 5982487.2 | 2097095.3 | 37.7372098007713 | -122.503066669454 | (37.7372098007713, -122.503066669454) | 1 | 8 | 3 | 29491 | 35 |
| 48932 | 221930 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2134 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6003302.06195 | 2107147.52772 | 37.7660123210304 | -122.431817741407 | (37.7660123210304, -122.431817741407) | 15 | 5 | 5 | 28862 | 3 | |||
| 48944 | 203504 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1443 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5991444.34023 | 2105597.09319 | 37.761075927938 | -122.472717747032 | (37.761075927938, -122.472717747032) | 1 | 8 | 4 | 56 | 12 | |||
| 49629 | 221833 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 577 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007293.94274 | 2103980.62531 | 37.7575422218038 | -122.417786099775 | (37.7575422218038, -122.417786099775) | 2 | 4 | 7 | 28859 | 19 | |||
| 49802 | 117893 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4126 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5982758.1361 | 2110364.11873 | 37.773658165069 | -122.503112014996 | (37.773658165069, -122.503112014996) | 11 | 6 | 2 | 55 | 26 | |||
| 50392 | 203557 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 377 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5995020.43667 | 2088328.90175 | 37.7138680909275 | -122.459099244044 | (37.7138680909275, -122.459099244044) | 9 | 8 | 6 | 28861 | 24 | |||
| 50747 | 65523 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 721 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1990 12:00:00 AM | 21 | Permit Number 28410 | 6001369.75843 | 2089371.25057 | 37.7170931137224 | -122.437228255287 | (37.7170931137224, -122.437228255287) | 9 | 7 | 6 | 28861 | 5 | |
| 51850 | 83832 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1311 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50170 | 5981489.3468 | 2106129.5123 | 37.7619565050576 | -122.507186662869 | (37.7619565050576, -122.507186662869) | 1 | 8 | 3 | 56 | 35 | |
| 52750 | 90677 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3822 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5983703.21809 | 2110398.38448 | 37.7738077542579 | -122.49984541634 | (37.7738077542579, -122.49984541634) | 11 | 6 | 2 | 55 | 26 | ||
| 53331 | 203580 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 118 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 3ft | 5999938.98985 | 2094086.49898 | 37.7299586665457 | -122.442512069977 | (37.7299586665457, -122.442512069977) | 9 | 7 | 4 | 63 | 40 | |||
| 53408 | 37793 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 347 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/06/1998 12:00:00 AM | 15 | Permit Number 40121 | 6009401.77176 | 2092702.5768 | 37.7266935573585 | -122.409700314138 | (37.7266935573585, -122.409700314138) | 10 | 3 | 7 | 309 | 28 | |
| 53970 | 221876 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 24 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 6006954.78098 | 2099597.50642 | 37.7454880840995 | -122.418648240225 | (37.7454880840995, -122.418648240225) | 2 | 7 | 7 | 28859 | 2 | |||
| 54980 | 203512 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1742 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 5993754.13818 | 2103625.89987 | 37.7557969785536 | -122.464586080687 | (37.7557969785536, -122.464586080687) | 1 | 8 | 4 | 56 | 12 | |||
| 57235 | 125546 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1070 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6007858.97154 | 2118915.83985 | 37.798582528908 | -122.416890128576 | (37.798582528908, -122.416890128576) | 5 | 1 | 10 | 308 | 32 | |||
| 58364 | 27336 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 615 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2000 12:00:00 AM | 3 | 2X3 | 6002282.10236 | 2095328.35794 | 37.7335018092598 | -122.434500417276 | (37.7335018092598, -122.434500417276) | 9 | 7 | 5 | 63 | 40 | ||
| 58662 | 90802 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3443 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984840.95767 | 2110382.4709 | 37.7738307601846 | -122.495908677168 | (37.7738307601846, -122.495908677168) | 11 | 6 | 2 | 55 | 26 | ||
| 59484 | 221933 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4166 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001253.22781 | 2105851.44827 | 37.7623372504834 | -122.438811343586 | (37.7623372504834, -122.438811343586) | 15 | 5 | 5 | 28862 | 3 | |||
| 59779 | 221868 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 30 Woodland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5997080.14125 | 2106419.81481 | 37.7636595407827 | -122.45328544896 | (37.7636595407827, -122.45328544896) | 15 | 5 | 11 | 29492 | 12 | |||
| 59999 | 38206 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 756 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | 11 | Permit Number 40330 | 6010781.48445 | 2091161.67808 | 37.7225397893635 | -122.404822228563 | (37.7225397893635, -122.404822228563) | 10 | 3 | 7 | 309 | 28 | |
| 60136 | 108565 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 521 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772537 | 6010495.60195 | 2092202.94019 | 37.7253828953025 | -122.405883778414 | (37.7253828953025, -122.405883778414) | 10 | 3 | 7 | 309 | 28 |
| 60145 | 38581 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1483 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 15 | Permit Number 40541 | 6015866.8585 | 2094128.4257 | 37.7309688285238 | -122.387449938884 | (37.7309688285238, -122.387449938884) | 10 | 3 | 8 | 58 | 1 | |
| 60245 | 108910 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 129 Ellert St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773054 | 6007361.2 | 2097016.9 | 37.7384251864379 | -122.417060086005 | (37.7384251864379, -122.417060086005) | 2 | 7 | 7 | 28859 | 2 |
| 60476 | 90761 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4031 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/06/2013 12:00:00 AM | 3 | 3x3 | 5983060.28234 | 2110318.76307 | 37.7735513866791 | -122.502063505002 | (37.7735513866791, -122.502063505002) | 11 | 6 | 2 | 55 | 26 | ||
| 60571 | 250774 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 261 32nd Ave | 1 | : | Tree | Private 2 | 30 | Width 3ft | 5985867.52173 | 2114167.09587 | 37.7842823263074 | -122.49263646502 | (37.7842823263074, -122.49263646502) | 11 | 6 | 1 | 55 | 33 | |||
| 61694 | 26511 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2850 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008945.12722 | 2101866.39993 | 37.7518298180943 | -122.411926215341 | (37.7518298180943, -122.411926215341) | 2 | 4 | 7 | 28859 | 19 | |||
| 62410 | 203526 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2424 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5992054.19197 | 2098908.13909 | 37.7427450799172 | -122.470121471754 | (37.7427450799172, -122.470121471754) | 1 | 8 | 4 | 29491 | 40 | |||
| 63890 | 35857 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 28 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1998 12:00:00 AM | 28 | 4x6 | Permit Number 39076 | 6002203.07861 | 2092639.23336 | 37.7261135989609 | -122.434581409299 | (37.7261135989609, -122.434581409299) | 9 | 7 | 6 | 28861 | 25 |
| 64032 | 221815 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3734 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008428.67762 | 2097499.17078 | 37.7398093887782 | -122.413403351802 | (37.7398093887782, -122.413403351802) | 2 | 7 | 7 | 28859 | 2 | |||
| 64228 | 114566 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 633 Spruce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | Permit Number 774120 | 5997130.5 | 2113555.2 | 37.7832543439484 | -122.45362653243 | (37.7832543439484, -122.45362653243) | 11 | 6 | 1 | 54 | 31 | |||
| 64528 | 90764 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3951X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5983298.61127 | 2110327.61433 | 37.773589688119 | -122.501239757976 | (37.773589688119, -122.501239757976) | 11 | 6 | 2 | 55 | 26 | ||
| 64776 | 221819 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 68 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006048.67396 | 2097610.71259 | 37.7399817402673 | -122.421640334157 | (37.7399817402673, -122.421640334157) | 2 | 7 | 7 | 28859 | 2 | |||
| 65100 | 221877 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 22 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006964.5888 | 2099612.44373 | 37.7455296507747 | -122.418615385312 | (37.7455296507747, -122.418615385312) | 2 | 7 | 7 | 28859 | 2 | |||
| 65306 | 43793 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 170 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | 6 | Permit Number 43423 | 5989012.43621 | 2114211.91029 | 37.7845887590001 | -122.481759578125 | (37.7845887590001, -122.481759578125) | 11 | 6 | 2 | 55 | 26 | |
| 65646 | 122045 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 207 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5990216.73059 | 2113968.78837 | 37.783991172797 | -122.477575394407 | (37.783991172797, -122.477575394407) | 11 | 6 | 2 | 55 | 26 | |||
| 65829 | 68256 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 243 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 16 | Permit Number 32061 | 6009551.9423 | 2093241.4503 | 37.7281816043806 | -122.409219186739 | (37.7281816043806, -122.409219186739) | 10 | 3 | 7 | 309 | 28 | |
| 66471 | 221841 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 5 Marsily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 2ft | 6004259.60988 | 2095362.69857 | 37.7337081577855 | -122.42766605444 | (37.7337081577855, -122.42766605444) | 2 | 7 | 5 | 28861 | 25 | |||
| 67738 | 221916 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 429 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6004184.08219 | 2101438.38346 | 37.7503863234716 | -122.428360063075 | (37.7503863234716, -122.428360063075) | 2 | 4 | 5 | 28862 | 22 | |||
| 68583 | 38114 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1296 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1998 12:00:00 AM | 7 | Permit Number 40278 | 5987111.1601 | 2106473.2531 | 37.7632298344396 | -122.487768520051 | (37.7632298344396, -122.487768520051) | 1 | 8 | 3 | 56 | 35 | |
| 69194 | 175204 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 653 Peru Ave | 1 | Side Yard : Yard | Tree | Private 2 | 7 | 6005107.43376 | 2092594.03644 | 37.72615394614 | -122.424538001034 | (37.72615394614, -122.424538001034) | 9 | 7 | 6 | 28861 | 5 | ||||
| 69898 | 175184 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 190 Newton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001047.00422 | 2087602.25445 | 37.7122174923141 | -122.438217204682 | (37.7122174923141, -122.438217204682) | 9 | 7 | 6 | 28861 | 5 | |||
| 69909 | 175176 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 226 Rome St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 5998630.92665 | 2088821.65601 | 37.7154279802818 | -122.446655529047 | (37.7154279802818, -122.446655529047) | 9 | 7 | 6 | 28861 | 25 | |||
| 70357 | 221879 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 43 Powers Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6006986.90322 | 2099718.335 | 37.745821660643 | -122.418545732803 | (37.745821660643, -122.418545732803) | 2 | 7 | 7 | 28859 | 2 | |||
| 71152 | 221844 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 127 Saint Marys Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6004153.19016 | 2095736.31086 | 37.7347279926082 | -122.428060594226 | (37.7347279926082, -122.428060594226) | 2 | 7 | 5 | 28861 | 25 | |||
| 71384 | 221875 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 319 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 4ft | 6006211.14692 | 2098216.1896 | 37.7416534045787 | -122.421121550328 | (37.7416534045787, -122.421121550328) | 2 | 7 | 7 | 28859 | 2 | |||
| 71659 | 221855 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 310 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6000611.21677 | 2101947.64163 | 37.7515818030572 | -122.440751776575 | (37.7515818030572, -122.440751776575) | 2 | 4 | 5 | 28862 | 22 | |||
| 72457 | 221800 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 170 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 2ft | 6004805.17774 | 2099321.48503 | 37.7446089338676 | -122.42606158838 | (37.7446089338676, -122.42606158838) | 2 | 7 | 5 | 63 | 22 | |||
| 72559 | 221853 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 430 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6002339.61262 | 2100938.00703 | 37.7489078650277 | -122.434702583968 | (37.7489078650277, -122.434702583968) | 2 | 4 | 5 | 28862 | 22 | |||
| 72768 | 90770 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3899X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5983556.085422 | 2110343.567935 | 37.7736486085903 | -122.500350310129 | (37.7736486085903, -122.500350310129) | 11 | 6 | 2 | 55 | 26 | ||
| 72775 | 125543 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 511 Webster St | 1 | : | Tree | Private 2 | 1 | Width 4ft | 6004027.82216 | 2110630.44547 | 37.7756166793921 | -122.429555900592 | (37.7756166793921, -122.429555900592) | 7 | 9 | 11 | 29492 | 10 | |||
| 72933 | 221807 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3720 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6004936.8002 | 2102544.12819 | 37.7534650059101 | -122.425835807291 | (37.7534650059101, -122.425835807291) | 2 | 4 | 5 | 28862 | 22 | |||
| 73567 | 83915 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1218 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50159 | 5982131.5385 | 2106775.0727 | 37.763766832166 | -122.505013452733 | (37.763766832166, -122.505013452733) | 1 | 8 | 3 | 56 | 35 | |
| 73816 | 203517 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 301 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5993021.77901 | 2102511.9902 | 37.7526962240514 | -122.467037812458 | (37.7526962240514, -122.467037812458) | 1 | 8 | 4 | 29491 | 12 | |||
| 73986 | 221859 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 861 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6000847.19345 | 2101982.10251 | 37.7516898602076 | -122.439938212095 | (37.7516898602076, -122.439938212095) | 2 | 4 | 5 | 28862 | 22 | |||
| 74291 | 164206 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2539 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 5991384.96424 | 2098131.18541 | 37.7405730525915 | -122.472378820421 | (37.7405730525915, -122.472378820421) | 1 | 8 | 4 | 29491 | 40 | |||
| 75216 | 221785 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 69 Scott St | 1 | : | Tree | Private 2 | 19 | Width 3ft | 6002359.55948 | 2108655.68222 | 37.7700998701305 | -122.435185544178 | (37.7700998701305, -122.435185544178) | 15 | 5 | 5 | 29492 | 9 | |||
| 75795 | 118877 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 732 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5981379.17338 | 2110733.6758 | 37.7745917102455 | -122.507909405784 | (37.7745917102455, -122.507909405784) | 11 | 6 | 2 | 55 | 26 | |||
| 76373 | 175196 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 149 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6002904.02638 | 2092823.59155 | 37.7266595719653 | -122.432171435767 | (37.7266595719653, -122.432171435767) | 9 | 7 | 6 | 28861 | 5 | |||
| 76757 | 203585 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 122 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 5999428.77785 | 2093578.76175 | 37.7285354426355 | -122.444239456297 | (37.7285354426355, -122.444239456297) | 9 | 7 | 4 | 63 | 40 | |||
| 76975 | 203510 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1366 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5993979.28828 | 2106206.5915 | 37.7628958661671 | -122.46399477014 | (37.7628958661671, -122.46399477014) | 1 | 5 | 11 | 56 | 12 | |||
| 77457 | 175216 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 240 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6010752.32605 | 2091460.28671 | 37.7233580771044 | -122.404944037249 | (37.7233580771044, -122.404944037249) | 10 | 3 | 7 | 309 | 28 | |||
| 77808 | 104992 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2423 47TH AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 01/14/2016 12:00:00 AM | 10 | 2x6 | Permit Number 775156 | 5981729.7 | 2098576.9 | 37.7412333126477 | -122.505795454359 | (37.7412333126477, -122.505795454359) | 1 | 8 | 3 | 29491 | 35 | |
| 78891 | 115281 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2320 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | Permit Number 774954 | 5988790.4 | 2098360 | 37.7410508098993 | -122.481366468975 | (37.7410508098993, -122.481366468975) | 1 | 8 | 3 | 29491 | 35 | |||
| 79042 | 95674 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1898X Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x6 | 5989702.02326 | 2113382.65311 | 37.7823519280112 | -122.479313179938 | (37.7823519280112, -122.479313179938) | 11 | 6 | 2 | 55 | 26 |
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) );