trees
493 rows where qSpecies_id = 133 sorted by qAddress descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12720 | 115537 | Planning Code 138.1 required 2 | Crataegus laevigata :: English Hawthorn 133 | 99X Lech Walesa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | 3x10 | Permit Number 770842 | 6007116.50228 | 2111387.72892 | 37.7778703965252 | -122.418925098047 | (37.7778703965252, -122.418925098047) | 7 | 9 | 9 | 28852 | 36 | |
40425 | 115540 | Planning Code 138.1 required 2 | Crataegus laevigata :: English Hawthorn 133 | 99X Lech Walesa St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | 3x5 | Permit Number 770842 | 6007116.50228 | 2111387.72892 | 37.7778703965252 | -122.418925098047 | (37.7778703965252, -122.418925098047) | 7 | 9 | 9 | 28852 | 36 | |
75364 | 115539 | Planning Code 138.1 required 2 | Crataegus laevigata :: English Hawthorn 133 | 99X Lech Walesa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | 3x10 | Permit Number 770842 | 6007116.50228 | 2111387.72892 | 37.7778703965252 | -122.418925098047 | (37.7778703965252, -122.418925098047) | 7 | 9 | 9 | 28852 | 36 | |
164265 | 115538 | Planning Code 138.1 required 2 | Crataegus laevigata :: English Hawthorn 133 | 99X Lech Walesa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | 3x10 | Permit Number 770842 | 6007116.50228 | 2111387.72892 | 37.7778703965252 | -122.418925098047 | (37.7778703965252, -122.418925098047) | 7 | 9 | 9 | 28852 | 36 | |
185440 | 115536 | Planning Code 138.1 required 2 | Crataegus laevigata :: English Hawthorn 133 | 99X Lech Walesa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | 3x10 | Permit Number 770842 | 6007116.50228 | 2111387.72892 | 37.7778703965252 | -122.418925098047 | (37.7778703965252, -122.418925098047) | 7 | 9 | 9 | 28852 | 36 | |
54373 | 223035 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 99 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008263.26696 | 2099462.20339 | 37.7451901540099 | -122.414114116572 | (37.7451901540099, -122.414114116572) | 2 | 7 | 7 | 28859 | 2 | |||
185390 | 206632 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 99 Castenada Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5994454.48924 | 2101216.21265 | 37.7492209405946 | -122.46198932515 | (37.7492209405946, -122.46198932515) | 1 | 8 | 4 | 29491 | 40 | |||
70202 | 223024 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 979 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009975.92603 | 2103539.78877 | 37.756482348292 | -122.408479582484 | (37.756482348292, -122.408479582484) | 2 | 4 | 7 | 28859 | 19 | |||
171037 | 182595 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 955 Rivera St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5990177.9035 | 2100379.6188 | 37.7466767317389 | -122.4767165565 | (37.7466767317389, -122.4767165565) | 1 | 8 | 3 | 29491 | 35 | |||
123636 | 182596 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 945 Rivera St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5990197.9307 | 2100380.5725 | 37.7466805119975 | -122.47664737489 | (37.7466805119975, -122.47664737489) | 1 | 8 | 3 | 29491 | 35 | |||
36175 | 68120 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 94 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | Permit Number 31866 | 6006215.83488054 | 2099558.94321569 | 37.7453405673201 | -122.421200665955 | (37.7453405673201, -122.421200665955) | 2 | 7 | 5 | 28859 | 2 | ||
40090 | 206631 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 89 Ventura Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994365.26522 | 2101880.85976 | 37.7510407556506 | -122.462346061026 | (37.7510407556506, -122.462346061026) | 1 | 8 | 4 | 29491 | 40 | |||
28142 | 121663 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5998939 | 2095554 | 37.7339310276146 | -122.446074655004 | (37.7339310276146, -122.446074655004) | 9 | 7 | 4 | 59 | 40 | ||||
40567 | 206697 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5998934.95382 | 2095541.69667 | 37.7338970145182 | -122.446087759167 | (37.7338970145182, -122.446087759167) | 9 | 7 | 4 | 59 | 40 | |||
62246 | 121661 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5998939 | 2095554 | 37.7339310276146 | -122.446074655004 | (37.7339310276146, -122.446074655004) | 9 | 7 | 4 | 59 | 40 | ||||
72896 | 206698 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5998920.6207 | 2095542.64427 | 37.7338987978865 | -122.446137381059 | (37.7338987978865, -122.446137381059) | 9 | 7 | 4 | 59 | 40 | |||
86826 | 121662 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5998939 | 2095554 | 37.7339310276146 | -122.446074655004 | (37.7339310276146, -122.446074655004) | 9 | 7 | 4 | 59 | 40 | ||||
96906 | 206702 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5998869.22619 | 2095565.73707 | 37.7339592701108 | -122.446316727449 | (37.7339592701108, -122.446316727449) | 9 | 7 | 4 | 59 | 40 | |||
108186 | 206701 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5998876.80466 | 2095558.49789 | 37.7339398258586 | -122.446290005877 | (37.7339398258586, -122.446290005877) | 9 | 7 | 4 | 59 | 40 | |||
137361 | 206699 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5998907.63682 | 2095545.72944 | 37.7339065275492 | -122.446182491946 | (37.7339065275492, -122.446182491946) | 9 | 7 | 4 | 59 | 40 | |||
162377 | 121664 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5998939 | 2095554 | 37.7339310276146 | -122.446074655004 | (37.7339310276146, -122.446074655004) | 9 | 7 | 4 | 59 | 40 | ||||
179732 | 121660 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5998939 | 2095554 | 37.7339310276146 | -122.446074655004 | (37.7339310276146, -122.446074655004) | 9 | 7 | 4 | 59 | 40 | ||||
180598 | 206700 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5998900.28229 | 2095547.61505 | 37.7339112849776 | -122.446208054284 | (37.7339112849776, -122.446208054284) | 9 | 7 | 4 | 59 | 40 | |||
44249 | 24588 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 820 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/1996 12:00:00 AM | 20 | 3X3 | 6008195.26733 | 2097153.24719 | 37.7388464504963 | -122.414185921141 | (37.7388464504963, -122.414185921141) | 2 | 7 | 7 | 28859 | 2 | ||
20290 | 206629 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 81 Ventura Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994298.95446 | 2101835.26425 | 37.7509117433916 | -122.462572061571 | (37.7509117433916, -122.462572061571) | 1 | 8 | 4 | 29491 | 40 | |||
189652 | 206630 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 81 Ventura Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994323.8061 | 2101846.41662 | 37.7509437961254 | -122.462486931727 | (37.7509437961254, -122.462486931727) | 1 | 8 | 4 | 29491 | 40 | |||
1063 | 32734 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 808 Capitol Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37117 | 5995081.95862964 | 2089664.82981262 | 37.7175397705127 | -122.458983271916 | (37.7175397705127, -122.458983271916) | 9 | 8 | 6 | 28861 | 24 | ||
142812 | 24587 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 804 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/1996 12:00:00 AM | 18 | 3X3 | 6008146.87115 | 2097150.77398 | 37.738836941075 | -122.414353078142 | (37.738836941075, -122.414353078142) | 2 | 7 | 7 | 28859 | 2 | ||
101700 | 247588 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 800 Tompkins Ave | 9 | Front Yard : Yard | Tree | Private 2 | 6 | 6008943.01163 | 2096440.06729 | 37.7369301858647 | -122.411550186315 | (37.7369301858647, -122.411550186315) | 10 | 7 | 7 | 28859 | 2 | ||||
133368 | 247587 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 800 Tompkins Ave | 8 | Front Yard : Yard | Tree | Private 2 | 6 | 6008949.04431 | 2096428.80776 | 37.7368996080238 | -122.411528533315 | (37.7368996080238, -122.411528533315) | 10 | 7 | 7 | 28859 | 2 | ||||
31183 | 206625 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 80 Ventura Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5994283.13326 | 2101793.571 | 37.7507963531822 | -122.46262374829 | (37.7507963531822, -122.46262374829) | 1 | 8 | 4 | 29491 | 40 | |||
44186 | 206624 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 80 Ventura Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5994298.51296 | 2101800.25271 | 37.7508155851791 | -122.46257104893 | (37.7508155851791, -122.46257104893) | 1 | 8 | 4 | 29491 | 40 | |||
112602 | 63806 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 8 Putnam St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24493 | 6009169.73778237 | 2097426.78712757 | 37.7396522194543 | -122.410835957293 | (37.7396522194543, -122.410835957293) | 10 | 7 | 7 | 28859 | 2 | ||
99367 | 176074 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 786 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6001892.13578 | 2089268.05693 | 37.7168394482606 | -122.435415271495 | (37.7168394482606, -122.435415271495) | 9 | 7 | 6 | 28861 | 5 | |||
124950 | 176073 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 774 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6001923.16259 | 2089317.3719 | 37.7169766182659 | -122.43531155268 | (37.7169766182659, -122.43531155268) | 9 | 7 | 6 | 28861 | 5 | |||
101641 | 35101 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 774 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | Permit Number 38642 | 6001926.16682464 | 2089330.25640032 | 37.71701216685 | -122.435302089615 | (37.71701216685, -122.435302089615) | 9 | 7 | 6 | 28861 | 5 | ||
149638 | 223046 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 77 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005471.50149 | 2099604.561 | 37.7454238329391 | -122.423777694396 | (37.7454238329391, -122.423777694396) | 2 | 7 | 5 | 28859 | 22 | |||
61766 | 35377 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 767 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | Permit Number 38834 | 6011637.61839103 | 2091581.433538 | 37.7237401685956 | -122.401892240977 | (37.7237401685956, -122.401892240977) | 10 | 3 | 7 | 309 | 28 | ||
4849 | 43803 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 762 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | Permit Number 43433 | 5988853.6653409 | 2110130.11231626 | 37.7733720498685 | -122.482009746097 | (37.7733720498685, -122.482009746097) | 11 | 6 | 2 | 55 | 26 | ||
22790 | 63803 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 75 Putnam St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24490 | 6009186.19603238 | 2097034.65488427 | 37.7385764323817 | -122.410751365299 | (37.7385764323817, -122.410751365299) | 10 | 7 | 7 | 28859 | 2 | ||
80974 | 62145 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 75 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/06/1985 12:00:00 AM | Permit Number 22258 | 6005427.84181989 | 2099597.4165714 | 37.7454017512266 | -122.423928154749 | (37.7454017512266, -122.423928154749) | 2 | 7 | 5 | 28859 | 22 | ||
87754 | 43489 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 731 Banks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2000 12:00:00 AM | Permit Number 43170 | 6008504.61569086 | 2095547.09041526 | 37.7344536647683 | -122.413002801242 | (37.7344536647683, -122.413002801242) | 10 | 7 | 7 | 28859 | 2 | ||
140870 | 43490 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 731 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2000 12:00:00 AM | Permit Number 43170 | 6008504.61569086 | 2095547.09041526 | 37.7344536647683 | -122.413002801242 | (37.7344536647683, -122.413002801242) | 10 | 7 | 7 | 28859 | 2 | ||
146015 | 68553 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 724 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/20/1996 12:00:00 AM | Permit Number 32442 | 5982311.44586787 | 2110822.57803578 | 37.7748906946614 | -122.50469113477 | (37.7748906946614, -122.50469113477) | 11 | 6 | 2 | 55 | 26 | ||
25870 | 223054 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 701 Church St | 15 | Front Yard : Yard | Tree | Private 2 | 5 | Width 3ft | 6004339.17113 | 2104460.25399 | 37.7586924448242 | -122.428039072561 | (37.7586924448242, -122.428039072561) | 2 | 4 | 5 | 28862 | 3 | |||
110897 | 223053 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 701 Church St | 13 | Front Yard : Yard | Tree | Private 2 | 4 | Width 3ft | 6004342.54387 | 2104435.23189 | 37.7586239308804 | -122.42802562499 | (37.7586239308804, -122.42802562499) | 2 | 4 | 5 | 28862 | 3 | |||
7001 | 225622 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 67 Woodland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5997067.03037 | 2106173.30325 | 37.7629819312842 | -122.453312997018 | (37.7629819312842, -122.453312997018) | 15 | 5 | 11 | 29492 | 12 | |||
126152 | 206533 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 665 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5995361.50595 | 2093791.16395 | 37.7288857636427 | -122.458315510062 | (37.7288857636427, -122.458315510062) | 9 | 7 | 4 | 28861 | 40 | |||
128797 | 206534 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 665 Miramar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5995362.10243 | 2093779.40423 | 37.7288535085691 | -122.458312597175 | (37.7288535085691, -122.458312597175) | 9 | 7 | 4 | 28861 | 40 | |||
136667 | 206535 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 665 Miramar Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5995362.41808 | 2093767.65006 | 37.7288212525964 | -122.458310655534 | (37.7288212525964, -122.458310655534) | 9 | 7 | 4 | 28861 | 40 | |||
65411 | 82956 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 660X Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2005 12:00:00 AM | 3 | 3x3 | 6009636 | 2110586 | 37.7758105844997 | -122.410152621086 | (37.7758105844997, -122.410152621086) | 8 | 2 | 9 | 28853 | 34 | |
77895 | 82955 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 660X Clementina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2005 12:00:00 AM | 3 | 3x3 | 6009636 | 2110586 | 37.7758105844997 | -122.410152621086 | (37.7758105844997, -122.410152621086) | 8 | 2 | 9 | 28853 | 34 | |
84636 | 82952 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 660X Clementina St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2005 12:00:00 AM | 3 | 3x3 | 6009636 | 2110586 | 37.7758105844997 | -122.410152621086 | (37.7758105844997, -122.410152621086) | 8 | 2 | 9 | 28853 | 34 | |
112891 | 82953 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 660X Clementina St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2005 12:00:00 AM | 3 | 3x3 | 6009636 | 2110586 | 37.7758105844997 | -122.410152621086 | (37.7758105844997, -122.410152621086) | 8 | 2 | 9 | 28853 | 34 | |
167164 | 82954 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 660X Clementina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2005 12:00:00 AM | 3 | 3x3 | 6009636 | 2110586 | 37.7758105844997 | -122.410152621086 | (37.7758105844997, -122.410152621086) | 8 | 2 | 9 | 28853 | 34 | |
20681 | 206679 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 657 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995939.36036 | 2096013.8239 | 37.7350218397738 | -122.456478499997 | (37.7350218397738, -122.456478499997) | 9 | 7 | 4 | 59 | 40 | |||
49032 | 206680 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 657 Los Palmos Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995948.68471 | 2096013.62894 | 37.7350218397753 | -122.456446248507 | (37.7350218397753, -122.456446248507) | 9 | 7 | 4 | 59 | 40 | |||
72421 | 206678 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 657 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5995925.9256 | 2096013.73306 | 37.7350208190394 | -122.456524941888 | (37.7350208190394, -122.456524941888) | 9 | 7 | 4 | 59 | 40 | |||
165991 | 206681 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 657 Los Palmos Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995960.60425 | 2096012.63655 | 37.735019799206 | -122.456404966934 | (37.735019799206, -122.456404966934) | 9 | 7 | 4 | 59 | 40 | |||
57524 | 47492 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 657 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 5 | Permit Number 45386 | 6001676.19021 | 2093232.03842 | 37.7277113821718 | -122.436445238065 | (37.7277113821718, -122.436445238065) | 9 | 7 | 6 | 28861 | 25 | |
158231 | 190925 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 651 Kansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6011562.19337 | 2105343.91486 | 37.761524784975 | -122.40312057635 | (37.761524784975, -122.40312057635) | 10 | 3 | 8 | 28856 | 29 | |||
119767 | 84504 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 650X Clementina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/2006 12:00:00 AM | 3 | 3x3 | 6009485.16866501 | 2110503.49163991 | 37.7755755804602 | -122.410668559049 | (37.7755755804602, -122.410668559049) | 8 | 2 | 9 | 28853 | 34 | |
128208 | 84505 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 650 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/2006 12:00:00 AM | 3 | 3x3 | 6009485.16866501 | 2110503.49163991 | 37.7755755804602 | -122.410668559049 | (37.7755755804602, -122.410668559049) | 8 | 2 | 9 | 28853 | 34 | |
20331 | 95111 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 649 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 54039 | 6001701.74477 | 2093288.67335 | 37.7278683408513 | -122.436360947301 | (37.7278683408513, -122.436360947301) | 9 | 7 | 6 | 28861 | 25 |
164008 | 95110 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 649 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2010 12:00:00 AM | 2 | 3x3 | Permit Number 54039 | 6001693.52474 | 2093271.82828 | 37.7278216210543 | -122.436388158988 | (37.7278216210543, -122.436388158988) | 9 | 7 | 6 | 28861 | 25 |
21541 | 206683 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 647 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995995.17419 | 2096006.34018 | 37.7350044954584 | -122.456284991974 | (37.7350044954584, -122.456284991974) | 9 | 7 | 4 | 59 | 40 | |||
133547 | 206684 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 647 Los Palmos Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5996011.49185 | 2096001.54035 | 37.7349922529962 | -122.456228229446 | (37.7349922529962, -122.456228229446) | 9 | 7 | 4 | 59 | 40 | |||
175150 | 206682 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 647 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5995986.28507 | 2096009.4987 | 37.7350126577011 | -122.456315952937 | (37.7350126577011, -122.456315952937) | 9 | 7 | 4 | 59 | 40 | |||
28113 | 206685 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 641 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996053.59921 | 2095980.96691 | 37.734938180348 | -122.456081163331 | (37.734938180348, -122.456081163331) | 9 | 7 | 4 | 59 | 40 | |||
10533 | 71420 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 637 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6009832.0273 | 2120182.0847 | 37.8021701092209 | -122.410152151595 | (37.8021701092209, -122.410152151595) | 3 | 1 | 10 | 308 | 23 | |||
9795 | 94076 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 629 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2010 12:00:00 AM | 2x4 | Permit Number 53465 | 5996116 | 2095941 | 37.734832022473 | -122.455862534884 | (37.734832022473, -122.455862534884) | 9 | 7 | 4 | 59 | 40 | ||
45262 | 94075 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 629 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2010 12:00:00 AM | 2x4 | Permit Number 53465 | 5996116 | 2095941 | 37.734832022473 | -122.455862534884 | (37.734832022473, -122.455862534884) | 9 | 7 | 4 | 59 | 40 | ||
52704 | 94078 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 629 Los Palmos Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2010 12:00:00 AM | 2x4 | Permit Number 53465 | 5996116 | 2095941 | 37.734832022473 | -122.455862534884 | (37.734832022473, -122.455862534884) | 9 | 7 | 4 | 59 | 40 | ||
68840 | 206686 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 629 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996075.55271 | 2095969.20127 | 37.7349071348466 | -122.456004412496 | (37.7349071348466, -122.456004412496) | 9 | 7 | 4 | 59 | 40 | |||
101316 | 94077 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 629 Los Palmos Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2010 12:00:00 AM | 2x4 | Permit Number 53465 | 5996116 | 2095941 | 37.734832022473 | -122.455862534884 | (37.734832022473, -122.455862534884) | 9 | 7 | 4 | 59 | 40 | ||
111864 | 206687 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 629 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996087.44674 | 2095957.96527 | 37.7348769661929 | -122.45596247889 | (37.7348769661929, -122.45596247889) | 9 | 7 | 4 | 59 | 40 | |||
181962 | 206688 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 629 Los Palmos Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5996101.05251 | 2095948.39142 | 37.7348514596286 | -122.455914747394 | (37.7348514596286, -122.455914747394) | 9 | 7 | 4 | 59 | 40 | |||
172908 | 94074 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 628 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2010 12:00:00 AM | 2x4 | Permit Number 53464 | 5996021 | 2096021 | 37.7350462302618 | -122.456196763121 | (37.7350462302618, -122.456196763121) | 9 | 7 | 4 | 59 | 40 | ||
21549 | 94071 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 616 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2010 12:00:00 AM | 2x4 | Permit Number 53462 | 5996098 | 2095984 | 37.7349490569452 | -122.455927874303 | (37.7349490569452, -122.455927874303) | 9 | 7 | 4 | 59 | 40 | ||
47735 | 206689 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 616 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5996145.20311 | 2095954.15677 | 37.734869823774 | -122.455762520949 | (37.734869823774, -122.455762520949) | 9 | 7 | 4 | 59 | 40 | |||
127288 | 206690 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 616 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5996131.5818 | 2095962.98776 | 37.7348932897948 | -122.45581025245 | (37.7348932897948, -122.45581025245) | 9 | 7 | 4 | 59 | 40 | |||
154235 | 94070 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 616 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2010 12:00:00 AM | 2x4 | Permit Number 53462 | 5996098 | 2095984 | 37.7349490569452 | -122.455927874303 | (37.7349490569452, -122.455927874303) | 9 | 7 | 4 | 59 | 40 | ||
79608 | 206693 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 609 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5997804.54909 | 2098010.1173 | 37.7406100866944 | -122.45017375512 | (37.7406100866944, -122.45017375512) | 9 | 7 | 4 | 59 | 40 | |||
166632 | 47955 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 59 Homestead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2002 12:00:00 AM | Permit Number 45685 | 6001000.20919275 | 2101375.03881203 | 37.7500317183297 | -122.439365554728 | (37.7500317183297, -122.439365554728) | 2 | 4 | 5 | 28862 | 22 | |||
86717 | 206692 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 582 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5996416.06092 | 2095880.87144 | 37.7346841407625 | -122.454820783252 | (37.7346841407625, -122.454820783252) | 9 | 7 | 4 | 59 | 40 | |||
97367 | 206691 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 582 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5996439.41867 | 2095873.69496 | 37.7346657757093 | -122.454739509716 | (37.7346657757093, -122.454739509716) | 9 | 7 | 4 | 59 | 40 | |||
27447 | 223034 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 578 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007664.49403 | 2096661.03983 | 37.7374651296141 | -122.415986246062 | (37.7374651296141, -122.415986246062) | 2 | 7 | 7 | 28859 | 2 | |||
155351 | 62920 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 578 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/05/1986 12:00:00 AM | Permit Number 23300 | 6007655.13385737 | 2096670.74814693 | 37.7374912602593 | -122.41601929598 | (37.7374912602593, -122.41601929598) | 2 | 7 | 7 | 28859 | 2 | ||
123517 | 49836 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 572 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/2005 12:00:00 AM | Permit Number 46619 | 6011764.04798466 | 2105724.17808831 | 37.7625801734793 | -122.402449179614 | (37.7625801734793, -122.402449179614) | 8 | 3 | 8 | 28856 | 29 | ||
13396 | 42456 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 570 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42599 | 5997659.71395367 | 2095289.95204904 | 37.7331328776169 | -122.450478486701 | (37.7331328776169, -122.450478486701) | 9 | 7 | 4 | 59 | 40 | ||
139743 | 223040 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 567 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007699.61186 | 2096703.50741 | 37.7375837106174 | -122.415867833228 | (37.7375837106174, -122.415867833228) | 2 | 7 | 7 | 28859 | 2 | |||
174811 | 161273 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 566 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 0 | Width 0ft | 6002889.18037 | 2090346.52899 | 37.7198572690851 | -122.432045948864 | (37.7198572690851, -122.432045948864) | 9 | 7 | 6 | 28861 | 5 | ||
55106 | 102412 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 55X Lyon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000310.8 | 2109142 | 37.7713186232103 | -122.442307075209 | (37.7713186232103, -122.442307075209) | 15 | 5 | 11 | 29492 | 9 | |||||
192920 | 64244 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 554 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | Permit Number 33284 | 6005149.6274741 | 2111313.35504132 | 37.7775552357395 | -122.425723916077 | (37.7775552357395, -122.425723916077) | 7 | 9 | 11 | 28852 | 10 | ||
92777 | 247816 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 550 30th St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6003030.78831 | 2098349.34835 | 37.7418392269952 | -122.432127661269 | (37.7418392269952, -122.432127661269) | 2 | 7 | 5 | 63 | 22 | |||
183578 | 35403 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 550 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1998 12:00:00 AM | Permit Number 38858 | 6003059.40190018 | 2098358.03858994 | 37.7418647106265 | -122.432029345324 | (37.7418647106265, -122.432029345324) | 2 | 7 | 5 | 63 | 22 | ||
18348 | 98409 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 55 19th Ave | 1 | Sidewalk: Curb side : | Tree | Private 2 | 5990099.2 | 2106073.1 | 37.7623049568555 | -122.477404745944 | (37.7623049568555, -122.477404745944) | 1 | 8 | 3 | 56 | 35 | |||||
116102 | 223039 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 543 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007708.38718 | 2096815.60919 | 37.7378920108046 | -122.415845428432 | (37.7378920108046, -122.415845428432) | 2 | 7 | 7 | 28859 | 2 | |||
126962 | 62916 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 543 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/05/1986 12:00:00 AM | Permit Number 23296 | 6007721.5198304 | 2096821.74854603 | 37.7379096064175 | -122.415800456905 | (37.7379096064175, -122.415800456905) | 2 | 7 | 7 | 28859 | 2 | ||
38958 | 40752 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 54 Cerritos Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/13/1999 12:00:00 AM | Permit Number 41722 | 5992568.54395141 | 2093000.42735623 | 37.72655370366 | -122.46791340088 | (37.72655370366, -122.46791340088) | 9 | 8 | 4 | 59 | 40 |
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) );