trees
290 rows where Police Districts = 7 and qSpecies_id = 6
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8 | 264824 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1x Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 6012032 | 2089425 | 37.7178410421308 | -122.400377527521 | (37.7178410421308, -122.400377527521) | 10 | 7 | 8 | 309 | 39 | |||
| 25 | 49783 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 130 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/2020 12:00:00 AM | 3 | Permit Number 46568 | 6011944.29976 | 2088937.30454 | 37.7164970376796 | -122.400646428989 | (37.7164970376796, -122.400646428989) | 10 | 7 | 8 | 309 | 39 | |
| 1269 | 262440 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 99 San Gabriel Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 4ft | 6001119 | 2093653 | 37.728835569179 | -122.438401596107 | (37.728835569179, -122.438401596107) | 9 | 7 | 6 | 28861 | 25 | ||
| 1415 | 171287 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 339 Avalon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 3ft | 6003711.94249 | 2092708.61039 | 37.7263896332495 | -122.429370301207 | (37.7263896332495, -122.429370301207) | 9 | 7 | 6 | 28861 | 5 | ||
| 1481 | 172310 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 63 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/23/2020 12:00:00 AM | 3 | Width 3ft | 6001999.53893 | 2087418.49495 | 37.7117670587831 | -122.434911834617 | (37.7117670587831, -122.434911834617) | 9 | 7 | 6 | 28861 | 5 | ||
| 1882 | 170658 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 399X San Juan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2019 12:00:00 AM | 3 | 4x6 | 6000800.50336 | 2092551.29112 | 37.7257924078835 | -122.439423717141 | (37.7257924078835, -122.439423717141) | 9 | 7 | 6 | 28861 | 25 | ||
| 2103 | 262299 | Section 806 (d) 5 | Lagunaria patersonii :: Primrose Tree 6 | 209 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2020 12:00:00 AM | 3 | 3x3 | Permit Number 773443 | 6008837.63968 | 2097618.9316 | 37.7401611793174 | -122.411997789374 | (37.7401611793174, -122.411997789374) | 10 | 7 | 7 | 28859 | 2 | |
| 2299 | 27284 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 636 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2009 12:00:00 AM | 3 | 3X3 | 6005588.17954 | 2093528.26307 | 37.7287462653044 | -122.422942457136 | (37.7287462653044, -122.422942457136) | 9 | 7 | 7 | 309 | 5 | ||
| 2654 | 108556 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 62 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/09/2019 12:00:00 AM | 3 | 3x3 | Permit Number 773715 | 6001062.72482 | 2093636.21513 | 37.7287862806562 | -122.43859494063 | (37.7287862806562, -122.43859494063) | 9 | 7 | 6 | 28861 | 25 |
| 2939 | 262442 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 99 San Gabriel Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 4ft | 6001119 | 2093653 | 37.728835569179 | -122.438401596107 | (37.728835569179, -122.438401596107) | 9 | 7 | 6 | 28861 | 25 | ||
| 3013 | 109184 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 5 Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774827 | 6002270 | 2092514.4 | 37.7257746335194 | -122.434341145327 | (37.7257746335194, -122.434341145327) | 9 | 7 | 6 | 28861 | 25 |
| 3652 | 248155 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 235 Rutledge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6010048.23979 | 2099492.44346 | 37.7453732829604 | -122.40794409015 | (37.7453732829604, -122.40794409015) | 2 | 7 | 7 | 28859 | 2 | |||
| 5588 | 227150 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 808 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008185.20329 | 2095640.92661 | 37.7346933830922 | -122.414113755053 | (37.7346933830922, -122.414113755053) | 2 | 7 | 7 | 28859 | 2 | |||
| 6051 | 207048 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 658 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 772511 | 5997718.79866 | 2095007.66028 | 37.7323611532403 | -122.450253874818 | (37.7323611532403, -122.450253874818) | 9 | 7 | 4 | 59 | 40 | |
| 7686 | 116544 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1041x Naples St | 7 | Median : Yard | Tree | DPW 1 | 5 | 3x3 | 6001586.02621 | 2088182.95127 | 37.7138425996209 | -122.436395723209 | (37.7138425996209, -122.436395723209) | 9 | 7 | 6 | 28861 | 5 | |||
| 9404 | 176900 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 167 Madison St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6005606.72127 | 2092829.97134 | 37.7268299557374 | -122.422828750447 | (37.7268299557374, -122.422828750447) | 9 | 7 | 7 | 309 | 5 | |||
| 9408 | 259103 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 625 Visitacion Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | 6010501.76504 | 2086856.29359 | 37.7107024439005 | -122.405486089504 | (37.7107024439005, -122.405486089504) | 9 | 7 | 8 | 309 | 39 | |||
| 10101 | 180653 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 245 Chicago Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/11/2017 07:56:00 AM | 3 | Width 6ft | 6002847.75966 | 2086772.69306 | 37.7100419513527 | -122.431934068713 | (37.7100419513527, -122.431934068713) | 9 | 7 | 6 | 28861 | 5 | ||
| 10461 | 170660 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 301X San Juan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2020 12:00:00 AM | 3 | Width 3ft | 6000886.10189 | 2092489.73569 | 37.7256282618212 | -122.439123400224 | (37.7256282618212, -122.439123400224) | 9 | 7 | 6 | 28861 | 25 | ||
| 10786 | 95722 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 950 Avalon Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | 9 | 7 | 6 | 28861 | 5 | |
| 12664 | 45661 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 315 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/06/2001 12:00:00 AM | 6 | Permit Number 44357 | 6002302.86118 | 2091870.52112 | 37.7240085522374 | -122.434181537449 | (37.7240085522374, -122.434181537449) | 9 | 7 | 6 | 28861 | 5 | |
| 12813 | 207010 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 305 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5999351.3193 | 2094355.62728 | 37.7306641145479 | -122.444563045861 | (37.7306641145479, -122.444563045861) | 9 | 7 | 4 | 28861 | 40 | |||
| 12847 | 171236 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 39 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 3ft | 6003761.27522 | 2093172.4115 | 37.7276659205371 | -122.429232817353 | (37.7276659205371, -122.429232817353) | 9 | 7 | 6 | 28861 | 5 | ||
| 12906 | 27193 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 284 Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/27/2009 12:00:00 AM | 6 | 3X3 | 6003096.09594 | 2093601.65823 | 37.7288068562446 | -122.431562981455 | (37.7288068562446, -122.431562981455) | 9 | 7 | 6 | 28861 | 25 | ||
| 13726 | 80104 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 425 Brazil Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 52309 | 6003144.80516 | 2091503.70271 | 37.7230491006299 | -122.43124489935 | (37.7230491006299, -122.43124489935) | 9 | 7 | 6 | 28861 | 5 | ||
| 13775 | 68397 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 88 Lyell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/02/2020 12:00:00 AM | 3 | Permit Number 785230 | 6003105.95459 | 2094517.30646 | 37.7313215783119 | -122.43159424368 | (37.7313215783119, -122.43159424368) | 9 | 7 | 5 | 28861 | 25 | |
| 14207 | 176903 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 290 Maynard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005283.95555 | 2093790.15237 | 37.7294481843731 | -122.424012796049 | (37.7294481843731, -122.424012796049) | 9 | 7 | 6 | 28861 | 5 | |||
| 14410 | 170659 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 399X San Juan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2019 12:00:00 AM | 3 | 6x4 | 6000830.95965 | 2092528.01217 | 37.7257302224446 | -122.439316764384 | (37.7257302224446, -122.439316764384) | 9 | 7 | 6 | 28861 | 25 | ||
| 14976 | 160069 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 11:26:00 AM | 3 | Width 0ft | 6000296.79811 | 2090527.78789 | 37.7202076512361 | -122.441019880684 | (37.7202076512361, -122.441019880684) | 9 | 7 | 6 | 28861 | 25 | ||
| 15013 | 170657 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 399X San Juan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2019 12:00:00 AM | 3 | Width 3ft | 6000770.58972 | 2092571.08998 | 37.7258450685777 | -122.439528544816 | (37.7258450685777, -122.439528544816) | 9 | 7 | 6 | 28861 | 25 | ||
| 15168 | 259102 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 619 Visitacion Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | 6010517.89431 | 2086850.21293 | 37.7106866494876 | -122.405429914879 | (37.7106866494876, -122.405429914879) | 9 | 7 | 8 | 309 | 39 | |||
| 15310 | 262443 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 99 San Gabriel Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 4ft | 6001119 | 2093653 | 37.728835569179 | -122.438401596107 | (37.728835569179, -122.438401596107) | 9 | 7 | 6 | 28861 | 25 | ||
| 15346 | 262448 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 145 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/09/2019 12:00:00 AM | 3 | 3x3 | 6001496 | 2093037 | 37.7271656105126 | -122.43705419947 | (37.7271656105126, -122.43705419947) | 9 | 7 | 6 | 28861 | 25 | |
| 15368 | 262300 | Section 806 (d) 5 | Lagunaria patersonii :: Primrose Tree 6 | 209 Prentiss St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2020 12:00:00 AM | 3 | 3x3 | Permit Number 773443 | 6008837.63968 | 2097618.9316 | 37.7401611793174 | -122.411997789374 | (37.7401611793174, -122.411997789374) | 10 | 7 | 7 | 28859 | 2 | |
| 15599 | 262439 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 99 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 4ft | 6001119 | 2093653 | 37.728835569179 | -122.438401596107 | (37.728835569179, -122.438401596107) | 9 | 7 | 6 | 28861 | 25 | ||
| 16773 | 70408 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 266 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6006531.16259 | 2092699.03842 | 37.7265225593592 | -122.419623688079 | (37.7265225593592, -122.419623688079) | 9 | 7 | 7 | 309 | 5 | |||
| 17284 | 81630 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 50 Paulding St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5999996.8419 | 2093367.66723 | 37.7279882186648 | -122.44226048643 | (37.7279882186648, -122.44226048643) | 9 | 7 | 6 | 28861 | 25 | |||
| 17357 | 116552 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1041x Naples St | 8 | Median : Yard | Tree | DPW 1 | 3 | 3x3 | 6001598.03525 | 2088202.06693 | 37.7138957693564 | -122.436355582838 | (37.7138957693564, -122.436355582838) | 9 | 7 | 6 | 28861 | 5 | |||
| 17874 | 170661 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 301X San Juan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2019 12:00:00 AM | 3 | Width 3ft | 6000920.86362 | 2092466.57168 | 37.7255666366796 | -122.439001572678 | (37.7255666366796, -122.439001572678) | 9 | 7 | 6 | 28861 | 25 | ||
| 17906 | 219682 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 250 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2019 12:00:00 AM | 3 | 3x3 | 6008245.78846 | 2097431.26822 | 37.7396126728914 | -122.414030905009 | (37.7396126728914, -122.414030905009) | 2 | 7 | 7 | 28859 | 2 | ||
| 18371 | 27202 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 302 Silver Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1999 12:00:00 AM | 6 | 3X3 | 6003502.33889 | 2093475.71167 | 37.7284840526724 | -122.430149591636 | (37.7284840526724, -122.430149591636) | 9 | 7 | 6 | 28861 | 5 | ||
| 19808 | 207047 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 654 Joost Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5997739.24902 | 2095008.66176 | 37.7323650733825 | -122.450183245677 | (37.7323650733825, -122.450183245677) | 9 | 7 | 4 | 59 | 40 | |||
| 19865 | 227149 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 530 Crescent Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007719.36141 | 2095678.53729 | 37.7347704774588 | -122.415726995823 | (37.7347704774588, -122.415726995823) | 2 | 7 | 7 | 28859 | 2 | |||
| 19897 | 102064 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 102 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52559 | 6007929.8 | 2098099.2 | 37.7414289135067 | -122.415170728099 | (37.7414289135067, -122.415170728099) | 2 | 7 | 7 | 28859 | 2 | |
| 21610 | 83554 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 117X Peru Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769748 | 6003920.58239 | 2093359.59743 | 37.7281889086723 | -122.428695428367 | (37.7281889086723, -122.428695428367) | 9 | 7 | 6 | 28861 | 5 |
| 21651 | 27207 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 302 Silver Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1999 12:00:00 AM | 6 | 3X3 | 6003623.95003 | 2093470.28644 | 37.7284760433174 | -122.429728788952 | (37.7284760433174, -122.429728788952) | 9 | 7 | 6 | 28861 | 5 | ||
| 23429 | 176881 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3303 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6011991.79808 | 2090250.44255 | 37.7201052985 | -122.400574440964 | (37.7201052985, -122.400574440964) | 10 | 7 | 8 | 309 | 28 | |||
| 23899 | 95684 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 334 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767433 | 6006626.2 | 2092405.9 | 37.72572301772 | -122.419274361386 | (37.72572301772, -122.419274361386) | 9 | 7 | 7 | 309 | 5 | |
| 24139 | 95719 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 950 Avalon Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | 9 | 7 | 6 | 28861 | 5 | |
| 25141 | 95718 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 950 Avalon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | 9 | 7 | 6 | 28861 | 5 | |
| 25424 | 176901 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 167 Madison St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6005600.43917 | 2092849.05844 | 37.7268820102711 | -122.422851823466 | (37.7268820102711, -122.422851823466) | 9 | 7 | 7 | 309 | 5 | |||
| 26675 | 207018 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 466 Staples Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5997114.73821 | 2093838.00202 | 37.7291149630685 | -122.452257872798 | (37.7291149630685, -122.452257872798) | 9 | 7 | 4 | 28861 | 40 | |||
| 27543 | 83558 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 483 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52321 | 6001949.50225 | 2090800.06366 | 37.7210492547906 | -122.435326507535 | (37.7210492547906, -122.435326507535) | 9 | 7 | 6 | 28861 | 5 | |
| 27595 | 63507 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 574 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/1987 12:00:00 AM | 4 | Permit Number 24113 | 6001588.8915 | 2090307.92108 | 37.7196774559426 | -122.436537823274 | (37.7196774559426, -122.436537823274) | 9 | 7 | 6 | 28861 | 5 | ||
| 28544 | 159338 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 517 Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 11:04:00 AM | 3 | Width 0ft | 5998112.9338 | 2087183.20699 | 37.7108995709325 | -122.448328017142 | (37.7108995709325, -122.448328017142) | 9 | 7 | 6 | 28861 | 25 | ||
| 28945 | 157260 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1059 Portola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781960 | 5995594.16193 | 2098091.79633 | 37.7407076181758 | -122.457822284089 | (37.7407076181758, -122.457822284089) | 9 | 7 | 4 | 59 | 40 | |
| 29101 | 176889 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 277 Athens St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004392.5622 | 2091665.65248 | 37.7235644112504 | -122.426943181195 | (37.7235644112504, -122.426943181195) | 9 | 7 | 6 | 28861 | 5 | |||
| 29210 | 176917 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1002x Naples St | 9 | Median : Yard | Tree | DPW 1 | 3 | 6001514.03799 | 2088123.65893 | 37.7136757052349 | -122.436640299224 | (37.7136757052349, -122.436640299224) | 9 | 7 | 6 | 28861 | 5 | ||||
| 29381 | 94673 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 662 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53809 | 5997706.3 | 2095032.9 | 37.7324297402139 | -122.450298904109 | (37.7324297402139, -122.450298904109) | 9 | 7 | 4 | 59 | 40 | |
| 29761 | 176907 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 769 Silver Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006492.03782 | 2093629.408 | 37.7290749477448 | -122.419824929392 | (37.7290749477448, -122.419824929392) | 9 | 7 | 7 | 309 | 5 | |||
| 30385 | 181018 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 197 Rolph St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 11:31:00 AM | 3 | Width 4ft | 6001005.57228 | 2088396.04691 | 37.7143947132291 | -122.43841724089 | (37.7143947132291, -122.43841724089) | 9 | 7 | 6 | 28861 | 5 | ||
| 30613 | 227099 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 75 Montcalm St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010635.77556 | 2100089.10311 | 37.7470444571367 | -122.405954501114 | (37.7470444571367, -122.405954501114) | 2 | 7 | 7 | 28859 | 2 | |||
| 30949 | 176888 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 13 Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002306.40089 | 2092528.29831 | 37.7258148612434 | -122.434216303453 | (37.7258148612434, -122.434216303453) | 9 | 7 | 6 | 28861 | 25 | |||
| 31662 | 27080 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 799X Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/29/2009 12:00:00 AM | 6 | 2X3 | 6006577.59669 | 2093640.72947 | 37.7291108536609 | -122.419529947915 | (37.7291108536609, -122.419529947915) | 9 | 7 | 7 | 309 | 5 | ||
| 31769 | 227126 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1689 Noe St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 4ft | 6003395.21055 | 2098417.4445 | 37.742046857971 | -122.430872467617 | (37.742046857971, -122.430872467617) | 2 | 7 | 5 | 63 | 22 | |||
| 33674 | 27102 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 669 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2009 12:00:00 AM | 3 | 3X3 | 6005822.11431 | 2093583.57584 | 37.7289113394767 | -122.422137656546 | (37.7289113394767, -122.422137656546) | 9 | 7 | 6 | 28861 | 5 | ||
| 35156 | 26976 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 504X Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2007 12:00:00 AM | 3 | 3x3 | 6004631.39194 | 2093482.01374 | 37.7285652398765 | -122.426246843332 | (37.7285652398765, -122.426246843332) | 9 | 7 | 6 | 28861 | 5 | ||
| 36462 | 227586 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 494 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6003707.36504 | 2095900.15245 | 37.7351526308975 | -122.429613645169 | (37.7351526308975, -122.429613645169) | 2 | 7 | 5 | 63 | 7 | |||
| 37676 | 176896 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 70 La Grande Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6005242.33299 | 2091887.73518 | 37.7242222149627 | -122.424021456542 | (37.7242222149627, -122.424021456542) | 9 | 7 | 6 | 28861 | 5 | |||
| 39381 | 181028 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 95 Rolph St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/05/2017 04:38:00 PM | 3 | Width 4ft | 6000533.08885 | 2088674.46766 | 37.7151323074928 | -122.440070279342 | (37.7151323074928, -122.440070279342) | 9 | 7 | 6 | 28861 | 5 | ||
| 39385 | 227113 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 201 Ogden Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007896.8692 | 2096132.1903 | 37.736026086627 | -122.415145389863 | (37.736026086627, -122.415145389863) | 2 | 7 | 7 | 28859 | 2 | |||
| 41225 | 82433 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 235 Rutledge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/11/2008 12:00:00 AM | 3x3 | Permit Number 50249 | 6010057.43217179 | 2099484.04645755 | 37.745350741274 | -122.407911712216 | (37.745350741274, -122.407911712216) | 2 | 7 | 7 | 28859 | 2 | ||
| 41454 | 253116 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 26 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 12:00:00 PM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.7197834059472 | -122.442045963044 | (37.7197834059472, -122.442045963044) | 9 | 7 | 6 | 28861 | 25 | ||
| 41858 | 83563 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 422 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769753 | 6002333.87212 | 2090986.92404 | 37.7215841526661 | -122.434011205875 | (37.7215841526661, -122.434011205875) | 9 | 7 | 6 | 28861 | 5 | |
| 42520 | 27117 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 415 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/03/2009 12:00:00 AM | 3 | 3X3 | 6004172.1589 | 2093507.51269 | 37.7286092859714 | -122.427836253857 | (37.7286092859714, -122.427836253857) | 9 | 7 | 6 | 28861 | 5 | ||
| 44017 | 116540 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1002x Naples St | 3 | Median : Yard | Tree | DPW 1 | 3 | 3x3 | 6001555.50616 | 2088195.95431 | 37.7138765688354 | -122.436502141754 | (37.7138765688354, -122.436502141754) | 9 | 7 | 6 | 28861 | 5 | |||
| 44532 | 227109 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 72 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008318.15108 | 2098296.22562 | 37.741991719651 | -122.41384187381 | (37.741991719651, -122.41384187381) | 2 | 7 | 7 | 28859 | 2 | |||
| 45123 | 107987 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 233 Laidley St | Sidewalk: Property side : Yard | Tree | Private 2 | 11/10/2014 12:00:00 AM | 3 | Permit Number 771182 | 6004231.95883 | 2097050.3446 | 37.7383404878499 | -122.427881865747 | (37.7383404878499, -122.427881865747) | 2 | 7 | 5 | 63 | 7 | |||
| 45396 | 227112 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 82 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6007863.71848 | 2099963.32211 | 37.7465436642568 | -122.41553116305 | (37.7465436642568, -122.41553116305) | 2 | 7 | 7 | 28859 | 2 | |||
| 45819 | 207011 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 16 Circular Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6001351.22893 | 2094512.68179 | 37.7312092646733 | -122.437660309391 | (37.7312092646733, -122.437660309391) | 9 | 7 | 4 | 63 | 40 | |||
| 46761 | 27182 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 214 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/03/2015 07:50:00 AM | 3 | 2X3 | 6002674.64617 | 2093876.57211 | 37.7295378108224 | -122.433039593603 | (37.7295378108224, -122.433039593603) | 9 | 7 | 6 | 28861 | 25 | ||
| 47209 | 165132 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 929 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781230 | 5995776.8676 | 2094560.79185 | 37.7310228361347 | -122.456935228771 | (37.7310228361347, -122.456935228771) | 9 | 7 | 4 | 28861 | 40 |
| 47657 | 207016 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 409 Edna St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 1ft | 5998750.98669 | 2094179.12135 | 37.7301451967391 | -122.446625784855 | (37.7301451967391, -122.446625784855) | 9 | 7 | 4 | 28861 | 40 | |||
| 48472 | 207040 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 115 Greenwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996029.16987 | 2093727.86128 | 37.7287502942706 | -122.456002788314 | (37.7287502942706, -122.456002788314) | 9 | 7 | 4 | 28861 | 40 | |||
| 48782 | 83518 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 117X Peru Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769748 | 6003951.4498 | 2093338.17621 | 37.7281318376981 | -122.428587192249 | (37.7281318376981, -122.428587192249) | 9 | 7 | 6 | 28861 | 5 |
| 49312 | 227087 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Alemany Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009571.14847 | 2096096.9094 | 37.7360231620273 | -122.409354219042 | (37.7360231620273, -122.409354219042) | 10 | 7 | 7 | 28859 | 2 | |||
| 49657 | 46433 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2St. Ankeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 777225 | 6011103.47209 | 2089684.58226 | 37.718501979072 | -122.403605308234 | (37.718501979072, -122.403605308234) | 10 | 7 | 8 | 309 | 28 |
| 51610 | 176885 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 191 Rey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6008580.05361 | 2087004.56736 | 37.7110019335603 | -122.412138452652 | (37.7110019335603, -122.412138452652) | 9 | 7 | 8 | 309 | 39 | |||
| 53300 | 95720 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 950 Avalon Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | 9 | 7 | 6 | 28861 | 5 | |
| 53980 | 207012 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 16 Circular Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6001339.26796 | 2094505.80603 | 37.731189705325 | -122.437701168268 | (37.731189705325, -122.437701168268) | 9 | 7 | 4 | 63 | 40 | |||
| 55754 | 176898 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 167 Madison St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6005619.38027 | 2092788.13013 | 37.7267157831975 | -122.422782016296 | (37.7267157831975, -122.422782016296) | 9 | 7 | 7 | 309 | 5 | |||
| 55846 | 227161 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Leese St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005575.79788 | 2096114.93647 | 37.7358479983778 | -122.423169051236 | (37.7358479983778, -122.423169051236) | 2 | 7 | 7 | 28859 | 2 | |||
| 56393 | 176895 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 70 La Grande Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6005265.09064 | 2091962.62602 | 37.7244291336757 | -122.42394810962 | (37.7244291336757, -122.42394810962) | 9 | 7 | 6 | 28861 | 5 | |||
| 57710 | 181021 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 179 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 12:49:00 PM | 3 | 8x6 | 6000934.69942 | 2088437.13017 | 37.71450348711 | -122.438665147076 | (37.71450348711, -122.438665147076) | 9 | 7 | 6 | 28861 | 5 | ||
| 57763 | 207044 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 755 Foerster St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5998014.32968 | 2095894.50831 | 37.7348131350024 | -122.44929603208 | (37.7348131350024, -122.44929603208) | 9 | 7 | 4 | 59 | 40 | |||
| 57846 | 159339 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 517 Ellington Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 11:12:00 AM | 3 | Width 0ft | 5998126.45786 | 2087195.02696 | 37.7109327990681 | -122.44828212563 | (37.7109327990681, -122.44828212563) | 9 | 7 | 6 | 28861 | 25 | ||
| 58866 | 116551 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1002x Naples St | 7 | Median : Yard | Tree | DPW 1 | 4 | 3x3 | 6001523.56178 | 2088140.13665 | 37.713721490625 | -122.436608560332 | (37.713721490625, -122.436608560332) | 9 | 7 | 6 | 28861 | 5 | |||
| 59014 | 95404 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 395 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767278 | 6003403.3 | 2099172.9 | 37.7441216223731 | -122.430898399301 | (37.7441216223731, -122.430898399301) | 2 | 7 | 5 | 63 | 22 | |
| 59553 | 237223 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 478 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/28/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 781633 | 6003374.63036 | 2100117.41801 | 37.7467134247776 | -122.431064932422 | (37.7467134247776, -122.431064932422) | 2 | 7 | 5 | 63 | 22 | |
| 60329 | 255502 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 248 Arlington St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781971 | 6004730.8147 | 2096705.01729 | 37.7374205056678 | -122.426132488181 | (37.7374205056678, -122.426132488181) | 2 | 7 | 5 | 63 | 7 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );