trees
1,746 rows where qSpecies_id = 10 sorted by rowid descending
This data as json, CSV (advanced)
| rowid ▲ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 194472 | 203213 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 626 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2018 12:00:00 AM | 3 | 10x4 | Permit Number 781523 | 6001387 | 2090021 | 37.7188781603148 | -122.437215155763 | (37.7188781603148, -122.437215155763) | 9 | 7 | 6 | 28861 | 5 | |
| 194456 | 265094 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 172 Locksley Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 5994312 | 2104105 | 37.7571446085096 | -122.462691582653 | (37.7571446085096, -122.462691582653) | 1 | 5 | 4 | 63 | 12 | ||||
| 194423 | 15800 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 4950 Mission St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/05/2018 02:11:00 PM | 3 | 4x4 | 6000889.9210477 | 2090200.0223298 | 37.7193414459012 | -122.438946180066 | (37.7193414459012, -122.438946180066) | 9 | 7 | 6 | 28861 | 25 | ||
| 194325 | 163425 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 402X Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2020 12:00:00 AM | 3 | 4x6 | 5995055.45495 | 2088438.70724 | 37.7141716040183 | -122.458986154313 | (37.7141716040183, -122.458986154313) | 9 | 8 | 6 | 28861 | 24 | ||
| 194130 | 177545 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 763 Morse St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5998675.35081 | 2087179.20711 | 37.7109207265908 | -122.446383892402 | (37.7109207265908, -122.446383892402) | 9 | 7 | 6 | 28861 | 5 | |||
| 194126 | 31573 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1823 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/1995 12:00:00 AM | Permit Number 35112 | 5989355.93017954 | 2102934.99499768 | 37.7536454065053 | -122.479745775823 | (37.7536454065053, -122.479745775823) | 1 | 8 | 3 | 56 | 35 | ||
| 194080 | 27554 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1299X Illinois St | 5 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/10/1999 12:00:00 AM | 12 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | 10 | 3 | 8 | 28856 | 29 | ||
| 193833 | 210156 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 351 Judson Ave | 33 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 1ft | 5997905.64065 | 2093516.80298 | 37.7282783030945 | -122.449500537045 | (37.7282783030945, -122.449500537045) | 9 | 7 | 4 | 28861 | 40 | |||
| 193713 | 210113 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 816 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 1ft | 5991488.40902 | 2102519.55417 | 37.7526283666271 | -122.47234097878 | (37.7526283666271, -122.47234097878) | 1 | 8 | 4 | 56 | 12 | |||
| 193593 | 41004 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1200 Illinois St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/1999 12:00:00 AM | Permit Number 41817 | 6016113.76612701 | 2103352.32554079 | 37.7563094360414 | -122.387239488996 | (37.7563094360414, -122.387239488996) | 10 | 3 | 8 | 28856 | 29 | |||
| 193589 | 193572 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1101 Illinois St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6016141.07153 | 2103821.89861 | 37.7576002964362 | -122.38717780882 | (37.7576002964362, -122.38717780882) | 10 | 3 | 8 | 28856 | 29 | |||
| 193566 | 210162 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 251 Harold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5996802.41479 | 2091448.36499 | 37.7225356893565 | -122.453165155657 | (37.7225356893565, -122.453165155657) | 9 | 8 | 4 | 28861 | 24 | |||
| 193490 | 51708 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 164 Gambier St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/2005 12:00:00 AM | 10 | Permit Number 47984 | 6005827.00268 | 2092955.60813 | 37.727187353502 | -122.422076163594 | (37.727187353502, -122.422076163594) | 9 | 7 | 7 | 309 | 5 | |
| 193346 | 178671 | Undocumented 4 | Melaleuca quinquenervia :: Cajeput 10 | 624 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6002757.8843 | 2087321.68 | 37.7115442544376 | -122.432283877092 | (37.7115442544376, -122.432283877092) | 9 | 7 | 6 | 28861 | 5 | |||
| 193207 | 201338 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 51 Bitting Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 2ft | 6012714.99003 | 2092651.13548 | 37.7267374208889 | -122.398242939583 | (37.7267374208889, -122.398242939583) | 10 | 3 | 8 | 58 | 1 | |||
| 193118 | 246906 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 491 Frederick St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2010 12:00:00 AM | 3 | Width 5ft | Permit Number 53958 | 5997348.6484 | 2107404.24528 | 37.7663779224388 | -122.452427814987 | (37.7663779224388, -122.452427814987) | 15 | 5 | 11 | 29492 | 9 | |
| 192881 | 210180 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 433 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2000 12:00:00 AM | 10 | Width 2ft | Permit Number 42521 | 6000082.86486 | 2095135.84132 | 37.7328481163341 | -122.4420899714 | (37.7328481163341, -122.4420899714) | 9 | 7 | 4 | 63 | 40 | |
| 192844 | 39329 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 0 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40896 | 6017074.59942826 | 2104815.9109509 | 37.7603812969624 | -122.384018475054 | (37.7603812969624, -122.384018475054) | 10 | 3 | 8 | 310 | 29 | |||
| 192811 | 193737 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 65 Whitney Young Cir | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6016863.97708 | 2094923.85728 | 37.733208101477 | -122.384058069641 | (37.733208101477, -122.384058069641) | 10 | 3 | 8 | 58 | 1 | |||
| 192810 | 193582 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 500 24th St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6016596.34163 | 2102622.43103 | 37.7543320117256 | -122.385519695483 | (37.7543320117256, -122.385519695483) | 10 | 3 | 8 | 28856 | 29 | ||||
| 192772 | 41918 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 548 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 7 | Permit Number 42279 | 5995332.21219 | 2111809.65905 | 37.7783583003595 | -122.459721372742 | (37.7783583003595, -122.459721372742) | 11 | 6 | 2 | 54 | 11 | |
| 192732 | 217750 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 441 West Portal Ave | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5991793.70279 | 2096430.09279 | 37.7359259318322 | -122.470841691116 | (37.7359259318322, -122.470841691116) | 1 | 8 | 4 | 59 | 40 | |||
| 192337 | 16463 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2X Newhall St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6018612.88561 | 2097134.80009 | 37.7393754506279 | -122.378164978648 | (37.7393754506279, -122.378164978648) | 10 | 3 | 8 | 58 | 1 | |||
| 192335 | 25933 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1980 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2008 12:00:00 AM | 8 | 3x3 | 6013124.42835 | 2096948.99329 | 37.7385612502888 | -122.397128745193 | (37.7385612502888, -122.397128745193) | 10 | 3 | 8 | 58 | 1 | ||
| 192311 | 42482 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 50 Phelan Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997095.77501 | 2092473.49801 | 37.7253672722814 | -122.452225013165 | (37.7253672722814, -122.452225013165) | 9 | 7 | 4 | 28861 | 40 | ||
| 192248 | 193655 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1789 Oakdale Ave | 3 | : | Tree | Private 2 | 8 | Width 3ft | 6014068.72917 | 2096173.21483 | 37.7364836463956 | -122.393809494134 | (37.7364836463956, -122.393809494134) | 10 | 3 | 8 | 58 | 1 | |||
| 192180 | 52397 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 24@ MISSION Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/2005 12:00:00 AM | Permit Number 48518 | 6005766.44533291 | 2097758.87496961 | 37.7403726422988 | -122.422626691285 | (37.7403726422988, -122.422626691285) | 2 | 7 | 7 | 28859 | 2 | ||
| 192147 | 232095 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 92 Homestead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6000964.07837 | 2101203.45021 | 37.7495585209273 | -122.439478198057 | (37.7495585209273, -122.439478198057) | 2 | 4 | 5 | 28862 | 22 | |||
| 192109 | 34639 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1526 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 10 | Permit Number 38319 | 5988094.3754 | 2104901.5335 | 37.7589716213063 | -122.484252671851 | (37.7589716213063, -122.484252671851) | 1 | 8 | 3 | 56 | 35 | |
| 192082 | 41007 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1200 Illinois St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/1999 12:00:00 AM | Permit Number 41817 | 6016113.76612701 | 2103352.32554079 | 37.7563094360414 | -122.387239488996 | (37.7563094360414, -122.387239488996) | 10 | 3 | 8 | 28856 | 29 | |||
| 192050 | 50412 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1547 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2003 12:00:00 AM | Permit Number 47069 | 6003347.72444158 | 2099240.85386141 | 37.7443050588333 | -122.431095416401 | (37.7443050588333, -122.431095416401) | 2 | 7 | 5 | 63 | 22 | ||
| 191915 | 39592 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 45 Southern Heights Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1998 12:00:00 AM | 6 | Permit Number 41001 | 6012253.42141 | 2104014.73236 | 37.757913720955 | -122.400636511287 | (37.757913720955, -122.400636511287) | 10 | 3 | 8 | 28856 | 29 | ||
| 191694 | 193748 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 130 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6016385.91828 | 2095926.87226 | 37.7359357380287 | -122.385780749793 | (37.7359357380287, -122.385780749793) | 10 | 3 | 8 | 58 | 1 | |||
| 191685 | 193733 | Undocumented 4 | Melaleuca quinquenervia :: Cajeput 10 | 210 Channel | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6014775.46671 | 2109801.19254 | 37.7739424115586 | -122.392318855239 | (37.7739424115586, -122.392318855239) | 14 | 3 | 9 | 310 | 20 | |||
| 191680 | 177535 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 502 Wayland St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6010045.83235 | 2092207.48214 | 37.7253702022583 | -122.407438917579 | (37.7253702022583, -122.407438917579) | 10 | 3 | 7 | 309 | 28 | |||
| 191662 | 15826 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 5081 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/27/1995 12:00:00 AM | 6 | 3X3 | 6000584.2194 | 2089509.24781 | 37.7174273368683 | -122.439953370494 | (37.7174273368683, -122.439953370494) | 9 | 7 | 6 | 28861 | 5 | ||
| 191547 | 41390 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1250 Sunnydale Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.7112689138709 | -122.413443728962 | (37.7112689138709, -122.413443728962) | 9 | 7 | 8 | 309 | 39 | ||
| 191514 | 232096 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 478 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6000648.78824 | 2101235.50246 | 37.7496285799007 | -122.440570777222 | (37.7496285799007, -122.440570777222) | 2 | 4 | 5 | 28862 | 22 | |||
| 191482 | 42487 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 50 Phelan Ave | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997102.28501 | 2092882.56901 | 37.7264908574219 | -122.452232012211 | (37.7264908574219, -122.452232012211) | 9 | 7 | 4 | 28861 | 40 | ||
| 191111 | 24137 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 120X Whitney Young Cir | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/1996 12:00:00 AM | 12 | 3x3 | 6016341.4043773 | 2096017.7564546 | 37.7361828243942 | -122.385940986699 | (37.7361828243942, -122.385940986699) | 10 | 3 | 8 | 58 | 1 | ||
| 191087 | 210128 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 162 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6000339.37921 | 2094372.42579 | 37.730766569808 | -122.441148385712 | (37.730766569808, -122.441148385712) | 9 | 7 | 4 | 63 | 40 | |||
| 191034 | 46464 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 2098 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2002 12:00:00 AM | Permit Number 44668 | 6002328.64862435 | 2119517.88465055 | 37.7999229605029 | -122.436069860968 | (37.7999229605029, -122.436069860968) | 13 | 9 | 1 | 57 | 17 | |||
| 190679 | 37917 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1300 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/1998 12:00:00 AM | Permit Number 40178 | 6013279.95089898 | 2106637.32404771 | 37.765171979803 | -122.397270220878 | (37.765171979803, -122.397270220878) | 14 | 3 | 8 | 28856 | 20 | |||
| 190586 | 41889 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 401 Duboce Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2000 12:00:00 AM | Permit Number 42259 | 6004099.97108515 | 2108358.83625404 | 37.7693834800973 | -122.429144312501 | (37.7693834800973, -122.429144312501) | 7 | 9 | 5 | 28862 | 3 | |||
| 190380 | 193713 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1200 Owen St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6013718.46135 | 2108204.21031 | 37.7694987057225 | -122.395863312765 | (37.7694987057225, -122.395863312765) | 14 | 3 | 9 | 310 | 20 | |||
| 190338 | 109032 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 263 Whitney St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773222 | 6004405.4 | 2096899 | 37.7379347402636 | -122.427271413206 | (37.7379347402636, -122.427271413206) | 2 | 7 | 5 | 63 | 7 |
| 190235 | 93071 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 10 Kirkham St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2010 12:00:00 AM | 3x3 | Permit Number 53153 | 5994911.9 | 2105351.2 | 37.7606008853336 | -122.460707220473 | (37.7606008853336, -122.460707220473) | 15 | 5 | 11 | 56 | 12 | ||
| 190146 | 232081 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 4026 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6008356.52925 | 2096353.07327 | 37.7366584044677 | -122.413571772338 | (37.7366584044677, -122.413571772338) | 10 | 7 | 7 | 28859 | 2 | |||
| 190114 | 177556 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1272 Sunnydale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 6008061.6956 | 2087168.18272 | 37.7114220887421 | -122.413941594254 | (37.7114220887421, -122.413941594254) | 9 | 7 | 8 | 309 | 39 | |||
| 190101 | 193743 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 106 Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6016637.85786 | 2095631.91909 | 37.7351397939695 | -122.384889143935 | (37.7351397939695, -122.384889143935) | 10 | 3 | 8 | 58 | 1 | |||
| 190058 | 51619 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 396(REVISED) Diamond St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52286 | 6001775.40578603 | 2103546.80768569 | 37.7560389603583 | -122.436840338915 | (37.7560389603583, -122.436840338915) | 2 | 4 | 5 | 28862 | 3 | ||
| 189850 | 88612 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 10 Kirkham St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2010 12:00:00 AM | 3x3 | Permit Number 53153 | 5994911.9 | 2105351.2 | 37.7606008853336 | -122.460707220473 | (37.7606008853336, -122.460707220473) | 15 | 5 | 11 | 56 | 12 | ||
| 189833 | 42317 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 301 Edna St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42532 | 5998734.92164885 | 2093801.38025355 | 37.7291070907004 | -122.446654155848 | (37.7291070907004, -122.446654155848) | 9 | 7 | 4 | 28861 | 40 | ||
| 189832 | 85902 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2278 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988268.6501 | 2099821.6607 | 37.7450337963146 | -122.483277586342 | (37.7450337963146, -122.483277586342) | 1 | 8 | 3 | 29491 | 35 | ||
| 189551 | 42293 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 116 Detroit St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42522 | 5999442.6223058 | 2093534.55961029 | 37.7284148636898 | -122.44418842044 | (37.7284148636898, -122.44418842044) | 9 | 7 | 4 | 63 | 40 | ||
| 189506 | 1975 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 81 Bertha Ln | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/04/2004 12:00:00 AM | 3 | 3X4 | 6017802.6674425 | 2094895.5028312 | 37.7331820975243 | -122.380810758122 | (37.7331820975243, -122.380810758122) | 10 | 3 | 8 | 58 | 1 | ||
| 189430 | 16465 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2X Newhall St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6018666.35636 | 2097096.27558 | 37.7392726167438 | -122.37797742504 | (37.7392726167438, -122.37797742504) | 10 | 3 | 8 | 58 | 1 | |||
| 189355 | 250018 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1 Peter Yorke Way | 7 | : | Tree | Private 2 | 11 | Width 5ft | 6005787.19276 | 2114383.50511 | 37.7860211214227 | -122.423736711387 | (37.7860211214227, -122.423736711387) | 13 | 9 | 1 | 28858 | 41 | |||
| 189243 | 42011 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1265 Monterey Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42338 | 5994087.78224082 | 2094315.91155995 | 37.7302533156885 | -122.4627568813 | (37.7302533156885, -122.4627568813) | 9 | 8 | 4 | 59 | 40 | ||
| 189212 | 92269 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1650 Portola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 775372 | 5991807.6 | 2096246.3 | 37.7354220869049 | -122.470780259887 | (37.7354220869049, -122.470780259887) | 1 | 8 | 4 | 59 | 40 | ||
| 188873 | 163311 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 261 Sadowa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 08:33:00 AM | 3 | Width 0ft | 5994382.20064 | 2087745.46311 | 37.7122293948338 | -122.461262941842 | (37.7122293948338, -122.461262941842) | 9 | 8 | 6 | 28861 | 24 | ||
| 188596 | 250010 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1 Peter Yorke Way | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6005626.07306 | 2114211.10885 | 37.7855386675272 | -122.424281876805 | (37.7855386675272, -122.424281876805) | 13 | 9 | 1 | 28858 | 41 | |||
| 188555 | 201325 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 48 Bitting Ave | 1 | : | Tree | Private 2 | 8 | Width 2ft | 6012695.3869 | 2092711.09099 | 37.7269009545069 | -122.398314912307 | (37.7269009545069, -122.398314912307) | 10 | 3 | 8 | 58 | 1 | |||
| 188373 | 177567 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 686 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6002012.03154 | 2089965.68745 | 37.7187617949906 | -122.435050717836 | (37.7187617949906, -122.435050717836) | 9 | 7 | 6 | 28861 | 5 | |||
| 188315 | 193579 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 500 24th St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6016687.20636 | 2102628.57061 | 37.7543538967387 | -122.385205886941 | (37.7543538967387, -122.385205886941) | 10 | 3 | 8 | 28856 | 29 | ||||
| 188291 | 232063 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 3698 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005251.12993 | 2101974.94833 | 37.7519199283637 | -122.424708299369 | (37.7519199283637, -122.424708299369) | 2 | 4 | 5 | 28859 | 19 | |||
| 188232 | 31779 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 926 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 9 | Permit Number 35253 | 5990034.0009 | 2097707.4772 | 37.7393313765523 | -122.477018926471 | (37.7393313765523, -122.477018926471) | 1 | 8 | 3 | 29491 | 35 | |
| 188043 | 51469 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 4062 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/2004 12:00:00 AM | Permit Number 47781 | 6008336.24160536 | 2096237.49941263 | 37.736339924628 | -122.413633743736 | (37.736339924628, -122.413633743736) | 2 | 7 | 7 | 28859 | 2 | ||
| 188041 | 25943 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2040 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/1997 12:00:00 AM | 16 | 3x3 | 6012631.62363 | 2097312.63548 | 37.739532288795 | -122.398858153188 | (37.739532288795, -122.398858153188) | 10 | 3 | 8 | 58 | 1 | ||
| 188030 | 210144 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 351 Judson Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 1ft | 5997313.23103 | 2093525.39973 | 37.7282680004512 | -122.451549131482 | (37.7282680004512, -122.451549131482) | 9 | 7 | 4 | 28861 | 40 | |||
| 187899 | 201298 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 65 Lydia Ave | 1 | : | Tree | Private 2 | 7 | Width 2ft | 6012703.34992 | 2092907.69585 | 37.727441234813 | -122.398301172475 | (37.727441234813, -122.398301172475) | 10 | 3 | 8 | 58 | 1 | |||
| 187719 | 115198 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 363 Collingwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2016 12:00:00 AM | Permit Number 777367 | 6002146.7 | 2103751.7 | 37.7566226407212 | -122.43557093896 | (37.7566226407212, -122.43557093896) | 2 | 4 | 5 | 28862 | 3 | |||
| 187688 | 232130 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 433 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001837.0462 | 2103325.03213 | 37.7554335211665 | -122.436611292486 | (37.7554335211665, -122.436611292486) | 2 | 4 | 5 | 28862 | 22 | |||
| 187623 | 193591 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 500 24th St | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6016298.28126 | 2102605.60806 | 37.7542693235748 | -122.386549300519 | (37.7542693235748, -122.386549300519) | 10 | 3 | 8 | 28856 | 29 | |||
| 187367 | 40801 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 639 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/1999 12:00:00 AM | Permit Number 41750 | 6002663.32456729 | 2108833.89352983 | 37.7706064393691 | -122.434147567313 | (37.7706064393691, -122.434147567313) | 15 | 5 | 5 | 29492 | 9 | |||
| 187333 | 25977 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2065 Oakdale Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/1997 12:00:00 AM | 16 | 2x3 | 6012520.92453 | 2097295.50422 | 37.7394790811646 | -122.399239702796 | (37.7394790811646, -122.399239702796) | 10 | 3 | 8 | 58 | 1 | ||
| 187117 | 193653 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2141 Oakdale Ave | 3 | : | Tree | Private 2 | 9 | Width 3ft | 6012086.86387 | 2097641.741 | 37.7404055736715 | -122.400764822055 | (37.7404055736715, -122.400764822055) | 10 | 3 | 8 | 58 | 1 | |||
| 187113 | 41002 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1200 Illinois St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/1999 12:00:00 AM | Permit Number 41817 | 6016113.76612701 | 2103352.32554079 | 37.7563094360414 | -122.387239488996 | (37.7563094360414, -122.387239488996) | 10 | 3 | 8 | 28856 | 29 | |||
| 186987 | 193571 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1101 Illinois St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6016142.2557 | 2103801.55064 | 37.7575444907985 | -122.387172294173 | (37.7575444907985, -122.387172294173) | 10 | 3 | 8 | 28856 | 29 | |||
| 186959 | 182144 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1671 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5988395.3489 | 2103938.992 | 37.7563462621617 | -122.483141224479 | (37.7563462621617, -122.483141224479) | 1 | 8 | 3 | 56 | 35 | |||
| 186899 | 191765 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1650 Owen St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2018 12:00:00 AM | 3 | Width 5ft | Permit Number 781163 | 6014318.27741 | 2107455.19183 | 37.7674754172788 | -122.393736122949 | (37.7674754172788, -122.393736122949) | 14 | 3 | 9 | 310 | 20 | |
| 186844 | 193570 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1101 Illinois St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6016143.75214 | 2103780.87867 | 37.7574878128173 | -122.38716567697 | (37.7574878128173, -122.38716567697) | 10 | 3 | 8 | 28856 | 29 | |||
| 186741 | 202228 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1 Kalmanovitz St | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6013179.65142 | 2093067.6055 | 37.7279068345108 | -122.396665790418 | (37.7279068345108, -122.396665790418) | 10 | 3 | 8 | 58 | 1 | |||
| 186679 | 39849 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 3151 Ortega St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41160 | 5984281.43555925 | 2102217.56111428 | 37.7513794309419 | -122.49724128025 | (37.7513794309419, -122.49724128025) | 1 | 8 | 3 | 29491 | 35 | ||
| 186604 | 27538 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1300 Illinois St | 4 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/10/1999 12:00:00 AM | 15 | 3X3 | 6016138.60969 | 2102846.2663 | 37.7549212799101 | -122.3871182746 | (37.7549212799101, -122.3871182746) | 10 | 3 | 8 | 28856 | 29 | ||
| 186546 | 258448 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 540 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 6010043 | 2105722 | 37.7624779645344 | -122.408401534669 | (37.7624779645344, -122.408401534669) | 8 | 4 | 8 | 28859 | 19 | |||
| 186464 | 104419 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 622 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 5982284.66916 | 2111506.09662 | 37.7767658616231 | -122.504834418682 | (37.7767658616231, -122.504834418682) | 11 | 6 | 2 | 55 | 26 | ||||
| 186395 | 193634 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 200 Jennings St | 6 | : | Tree | Private 2 | 2 | Width 3ft | 6018590.82237 | 2096922.85924 | 37.7387922870281 | -122.378226555236 | (37.7387922870281, -122.378226555236) | 10 | 3 | 8 | 58 | 1 | |||
| 186391 | 34018 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 323 El Camino Del Mar | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/1997 12:00:00 AM | 7 | Permit Number 37952 | 5987618.80889 | 2115290.48543 | 37.7874690769039 | -122.486660221281 | (37.7874690769039, -122.486660221281) | 11 | 6 | 1 | 55 | 33 | ||
| 186386 | 201324 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 38 Bitting Ave | 1 | : | Tree | Private 2 | 9 | Width 2ft | 6012718.52546 | 2092694.78991 | 37.7268574839648 | -122.398233779091 | (37.7268574839648, -122.398233779091) | 10 | 3 | 8 | 58 | 1 | |||
| 186323 | 35274 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 297 Glenview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | Permit Number 38757 | 5999307.03749607 | 2100822.69240149 | 37.7484186077529 | -122.445180906559 | (37.7484186077529, -122.445180906559) | 2 | 5 | 5 | 63 | 38 | ||
| 186321 | 193681 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 256 Terry A Francois Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6016349.95209 | 2108890.81717 | 37.7715300224208 | -122.386808897031 | (37.7715300224208, -122.386808897031) | 14 | 3 | 9 | 310 | 20 | |||
| 186287 | 202215 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1 Kalmanovitz St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6013165.33275 | 2092944.54355 | 37.7275681345508 | -122.396706667284 | (37.7275681345508, -122.396706667284) | 10 | 3 | 8 | 58 | 1 | |||
| 186167 | 177550 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1232 Sunnydale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6008203.75149 | 2087114.38987 | 37.7112823619554 | -122.413446808849 | (37.7112823619554, -122.413446808849) | 9 | 7 | 8 | 309 | 39 | |||
| 185904 | 43092 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 421 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/2000 12:00:00 AM | Permit Number 42928 | 6008429.64272938 | 2113903.18576208 | 37.7848510917262 | -122.4145605189 | (37.7848510917262, -122.4145605189) | 7 | 10 | 9 | 28858 | 36 | ||
| 185881 | 233238 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 363 Collingwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002122.54543 | 2103738.23701 | 37.756584302647 | -122.435653510901 | (37.756584302647, -122.435653510901) | 2 | 4 | 5 | 28862 | 3 | |||
| 185866 | 182139 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1489 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5988394.5038 | 2105191.4729 | 37.7597851868608 | -122.483235952305 | (37.7597851868608, -122.483235952305) | 1 | 8 | 3 | 56 | 35 | |||
| 185648 | 202233 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1 Kalmanovitz St | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6013185.99227 | 2093116.53756 | 37.7280415448743 | -122.39664729856 | (37.7280415448743, -122.39664729856) | 10 | 3 | 8 | 58 | 1 | |||
| 185642 | 202256 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1 Kalmanovitz St | 48 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6013218.75497 | 2093350.94152 | 37.7286869936936 | -122.396550460457 | (37.7286869936936, -122.396550460457) | 10 | 3 | 8 | 58 | 1 | |||
| 185486 | 210183 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 601 Foerster St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 5998096.05658 | 2095294.61707 | 37.7331706509866 | -122.448970276062 | (37.7331706509866, -122.448970276062) | 9 | 7 | 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) );