trees
1,121 rows where qSpecies_id = 6 sorted by DBH 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9738 | 79640 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 168 Orsi Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6012982.50067 | 2092948.34875 | 37.727568405236 | -122.397338990501 | (37.727568405236, -122.397338990501) | 10 | 3 | 8 | 58 | 1 | |||
| 21404 | 129375 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 454 Walnut St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5998637.858 | 2115126.26996 | 37.7876543864995 | -122.448524881439 | (37.7876543864995, -122.448524881439) | 13 | 6 | 1 | 54 | 31 | |||
| 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 | |||
| 65951 | 191221 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Mississippi St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6014015.89789 | 2106592.91783 | 37.7650909952748 | -122.394721628821 | (37.7650909952748, -122.394721628821) | 14 | 3 | 8 | 28856 | 29 | |||
| 84495 | 52937 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 436@THERESA Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | 9 | Permit Number 48924 | 6002078.69882 | 2093873.61529 | 37.7294958700207 | -122.435099629266 | (37.7294958700207, -122.435099629266) | 9 | 7 | 6 | 28861 | 25 | |
| 86875 | 227097 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1650 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009272.78227 | 2099754.56661 | 37.7460495695343 | -122.410644014106 | (37.7460495695343, -122.410644014106) | 2 | 7 | 7 | 28859 | 2 | |||
| 102966 | 206997 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1290 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5992719.48539 | 2106665.14578 | 37.7640822509305 | -122.46838531524 | (37.7640822509305, -122.46838531524) | 11 | 8 | 11 | 56 | 12 | |||
| 107198 | 50036 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 73 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | 9 | Permit Number 46766 | 6007832.62107 | 2093714.43935 | 37.7293838567558 | -122.415196429982 | (37.7293838567558, -122.415196429982) | 9 | 3 | 7 | 309 | 28 | |
| 115282 | 207013 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 178 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6000221.87075 | 2094376.84303 | 37.7307720044131 | -122.441554946711 | (37.7307720044131, -122.441554946711) | 9 | 7 | 4 | 63 | 40 | |||
| 120653 | 200835 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1101 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6013058.6169 | 2107038.7182 | 37.7662617940431 | -122.398063928568 | (37.7662617940431, -122.398063928568) | 14 | 3 | 8 | 28856 | 20 | |||
| 123672 | 227562 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4567 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6000777.25512 | 2104640.3736 | 37.7589848458951 | -122.440370692454 | (37.7589848458951, -122.440370692454) | 2 | 4 | 5 | 28862 | 38 | |||
| 135643 | 227554 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 359 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001158.33464 | 2104306.33401 | 37.7580893450524 | -122.439028803251 | (37.7580893450524, -122.439028803251) | 2 | 4 | 5 | 28862 | 3 | |||
| 142405 | 227565 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 290 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001097.22568 | 2104712.62438 | 37.7592014422066 | -122.439269264885 | (37.7592014422066, -122.439269264885) | 2 | 4 | 5 | 28862 | 3 | |||
| 144465 | 227561 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 84 Seward St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6000738.66154 | 2104570.78605 | 37.7587915779822 | -122.44049917592 | (37.7587915779822, -122.44049917592) | 2 | 4 | 5 | 28862 | 38 | |||
| 146089 | 52362 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1438ASHINGTON Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | 9 | Permit Number 48498 | 6007994.93646 | 2117377.76116 | 37.7943669936906 | -122.416310648633 | (37.7943669936906, -122.416310648633) | 5 | 1 | 10 | 28858 | 21 | |
| 148398 | 227552 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4058 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002586.75589 | 2105341.84005 | 37.7610137667981 | -122.43416274072 | (37.7610137667981, -122.43416274072) | 15 | 4 | 5 | 28862 | 3 | |||
| 152989 | 47678 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 536 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/21/2002 12:00:00 AM | 9 | Permit Number 45462 | 6014348.84456 | 2104603.39752 | 37.7596467118443 | -122.393430795897 | (37.7596467118443, -122.393430795897) | 10 | 3 | 8 | 28856 | 29 | |
| 177874 | 42963 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 560 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | 9 | Permit Number 42852 | 5981647.94996 | 2111905.75128 | 37.7778257173711 | -122.507066636025 | (37.7778257173711, -122.507066636025) | 11 | 6 | 2 | 55 | 26 | ||
| 618 | 238270 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 4102 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6002298.332 | 2104734.40291 | 37.7593295173753 | -122.435116825204 | (37.7593295173753, -122.435116825204) | 2 | 4 | 5 | 28862 | 3 | |||
| 3613 | 227144 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 266 Rivoli St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997515.89511 | 2105898.72706 | 37.7622537322474 | -122.451740727559 | (37.7622537322474, -122.451740727559) | 15 | 5 | 11 | 29492 | 9 | |||
| 8363 | 238269 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 4102 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6002324.68279 | 2104735.52248 | 37.7593340877084 | -122.435025771543 | (37.7593340877084, -122.435025771543) | 2 | 4 | 5 | 28862 | 3 | |||
| 12282 | 83440 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2230 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6011076.92464 | 2105580.38381 | 37.7621469638337 | -122.404815578978 | (37.7621469638337, -122.404815578978) | 8 | 3 | 8 | 28856 | 29 | |||
| 27719 | 250553 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 130 El Camino Del Mar | 1 | : | Tree | Private 2 | 8 | Width 4ft | 5988175.48547 | 2115367.76095 | 37.7877136895948 | -122.484739928202 | (37.7877136895948, -122.484739928202) | 11 | 6 | 1 | 55 | 33 | |||
| 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 | |||
| 43943 | 227551 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 571 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003034.11181 | 2104925.46753 | 37.7598958878974 | -122.432585790315 | (37.7598958878974, -122.432585790315) | 2 | 4 | 5 | 28862 | 3 | |||
| 54965 | 191246 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 22 Rausch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009574.51886 | 2111002.08454 | 37.776949608681 | -122.410394686976 | (37.776949608681, -122.410394686976) | 8 | 2 | 9 | 28853 | 34 | |||
| 60778 | 227145 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 266 Rivoli St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997490.50245 | 2105894.70205 | 37.7622412262784 | -122.451828260367 | (37.7622412262784, -122.451828260367) | 15 | 5 | 11 | 29492 | 9 | |||
| 62739 | 227079 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 7ft | 6006194.41732 | 2099504.07308 | 37.7451886989034 | -122.421270828796 | (37.7451886989034, -122.421270828796) | 2 | 7 | 5 | 28859 | 2 | |||
| 64767 | 227098 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1646 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009270.38668 | 2099790.72722 | 37.7461487242839 | -122.410654850958 | (37.7461487242839, -122.410654850958) | 2 | 7 | 7 | 28859 | 2 | |||
| 70068 | 207041 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1414 Plymouth Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5995889.45634 | 2093373.14104 | 37.727768297568 | -122.456460143934 | (37.727768297568, -122.456460143934) | 9 | 7 | 4 | 28861 | 40 | |||
| 71720 | 227560 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 84 Seward St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6000737.03493 | 2104555.7602 | 37.7587502280493 | -122.440503723791 | (37.7587502280493, -122.440503723791) | 2 | 4 | 5 | 28862 | 38 | |||
| 83985 | 227091 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Alemany Blvd | 29 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 5ft | 6009293.03444 | 2095834.73547 | 37.735287702767 | -122.410297269721 | (37.735287702767, -122.410297269721) | 10 | 7 | 7 | 28859 | 2 | |||
| 89299 | 227085 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009638.60709 | 2096225.80995 | 37.7363808745699 | -122.409130079214 | (37.7363808745699, -122.409130079214) | 10 | 7 | 7 | 28859 | 2 | |||
| 92790 | 37817 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 450X Moscow St | 5 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003961.27408 | 2090526.10251 | 37.7204110616965 | -122.428352887393 | (37.7204110616965, -122.428352887393) | 9 | 7 | 6 | 28861 | 5 |
| 102299 | 82807 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 130 Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52471 | 6006613.17369 | 2094127.50126 | 37.7304494265868 | -122.419441474643 | (37.7304494265868, -122.419441474643) | 9 | 7 | 7 | 309 | 5 | |
| 109069 | 227555 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4611 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000604.66017 | 2104640.67953 | 37.7589758571809 | -122.440967627376 | (37.7589758571809, -122.440967627376) | 2 | 4 | 5 | 28862 | 38 | |||
| 110146 | 227090 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Alemany Blvd | 22 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 6009411.625 | 2095915.20486 | 37.7355153013828 | -122.409892935407 | (37.7355153013828, -122.409892935407) | 10 | 7 | 7 | 28859 | 2 | |||
| 121429 | 191228 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 901 Newhall St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6015254.00871 | 2096807.91476 | 37.7382922001146 | -122.38975576401 | (37.7382922001146, -122.38975576401) | 10 | 3 | 8 | 58 | 1 | |||
| 133607 | 83264 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 483 Paris St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52321 | 6001958.21107 | 2090814.31383 | 37.7210888771378 | -122.43529742254 | (37.7210888771378, -122.43529742254) | 9 | 7 | 6 | 28861 | 5 | |
| 138661 | 27273 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2095X Silver Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2011 12:00:00 AM | 8 | 3X3 | 6012407.8106259 | 2096047.4553772 | 37.7360458965855 | -122.399543203223 | (37.7360458965855, -122.399543203223) | 10 | 3 | 8 | 58 | 1 | ||
| 138739 | 82870 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 110 Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/2009 12:00:00 AM | 8 | 3x3 | Permit Number 53934 | 6006630.39976 | 2094273.0498 | 37.730850041274 | -122.419392243064 | (37.730850041274, -122.419392243064) | 9 | 7 | 7 | 309 | 5 |
| 153170 | 191220 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2300 18th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6010900.2167 | 2105543.22676 | 37.762035060293 | -122.405424130428 | (37.762035060293, -122.405424130428) | 8 | 3 | 8 | 28856 | 29 | |||
| 154237 | 60223 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1230 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52240 | 6009426.59197 | 2117542.6242 | 37.7949000677337 | -122.411368584404 | (37.7949000677337, -122.411368584404) | 3 | 1 | 10 | 28857 | 4 | |
| 158624 | 49803 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Mississippi St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | 8 | Permit Number 46598 | 6014016.82872 | 2106570.58674 | 37.7650297307661 | -122.394716845308 | (37.7650297307661, -122.394716845308) | 14 | 3 | 8 | 28856 | 29 | |
| 161401 | 37831 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 450X Moscow St | 18 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003870.23097 | 2090403.35388 | 37.7200688687581 | -122.428658848427 | (37.7200688687581, -122.428658848427) | 9 | 7 | 6 | 28861 | 5 |
| 172005 | 227579 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 77 Landers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004499.29505 | 2107353.29779 | 37.7666451110058 | -122.427691415339 | (37.7666451110058, -122.427691415339) | 8 | 4 | 5 | 28862 | 3 | |||
| 179565 | 129387 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2507 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006679.63776 | 2119843.90732 | 37.8010643609816 | -122.421036932226 | (37.8010643609816, -122.421036932226) | 5 | 9 | 1 | 28858 | 32 | |||
| 185726 | 200836 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1101 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6013076.6871 | 2107039.6693 | 37.7662654119853 | -122.398001493496 | (37.7662654119853, -122.398001493496) | 14 | 3 | 8 | 28856 | 20 | |||
| 194372 | 37826 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 450X Moscow St | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003896.37457 | 2090444.78719 | 37.7201841150858 | -122.428571430748 | (37.7201841150858, -122.428571430748) | 9 | 7 | 6 | 28861 | 5 |
| 887 | 60297 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1101 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/27/1982 12:00:00 AM | 7 | Permit Number 19862 | 6013032.9382 | 2107035.865 | 37.7662525295396 | -122.398152546702 | (37.7662525295396, -122.398152546702) | 14 | 3 | 8 | 28856 | 20 | |
| 12096 | 83834 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2300X Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6013045.53048 | 2096356.5558 | 37.7369301480983 | -122.397360003177 | (37.7369301480983, -122.397360003177) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 20503 | 129384 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 91 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6008749.2926 | 2112454.62361 | 37.7808916402666 | -122.413352154294 | (37.7808916402666, -122.413352154294) | 7 | 10 | 9 | 28852 | 36 | |||
| 21599 | 129376 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2500 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6002240.59165 | 2116825.10443 | 37.7925242837291 | -122.436181762774 | (37.7925242837291, -122.436181762774) | 13 | 9 | 1 | 29490 | 27 | |||
| 22543 | 227116 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 133 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6006472.0378 | 2105330.58155 | 37.761202600143 | -122.420724416907 | (37.761202600143, -122.420724416907) | 2 | 4 | 7 | 28859 | 19 | |||
| 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 | |
| 31711 | 227556 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 95 Seward St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6000674.34081 | 2104608.13246 | 37.7588904593411 | -122.440724304978 | (37.7588904593411, -122.440724304978) | 2 | 4 | 5 | 28862 | 38 | |||
| 34441 | 227139 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 280 Grattan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5997445.29759 | 2106455.57152 | 37.7637786424842 | -122.452025073424 | (37.7637786424842, -122.452025073424) | 15 | 5 | 11 | 29492 | 9 | |||
| 35620 | 227157 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3330 20th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007941.59674 | 2104465.0078 | 37.7589086508255 | -122.41558053851 | (37.7589086508255, -122.41558053851) | 2 | 4 | 7 | 28859 | 19 | |||
| 41803 | 48448 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 238 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2002 12:00:00 AM | 7 | Permit Number 45820 | 5997868.1487 | 2109737.2703 | 37.7728135614974 | -122.45079920227 | (37.7728135614974, -122.45079920227) | 15 | 5 | 11 | 29492 | 16 | ||
| 42267 | 83686 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1250-1262 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52242 | 6009408.29288 | 2117660.17543 | 37.7952218082983 | -122.411440210903 | (37.7952218082983, -122.411440210903) | 3 | 1 | 10 | 28857 | 4 | |
| 43690 | 52885 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2500@ JACKSON Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2006 12:00:00 AM | 7 | Permit Number 48890 | 6002243.8338 | 2116804.81477 | 37.7924687577648 | -122.436169092224 | (37.7924687577648, -122.436169092224) | 13 | 9 | 1 | 29490 | 27 | ||
| 44173 | 49818 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1300 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | 7 | 3x3 | Permit Number 46609 | 6012222.38132 | 2102319.17957 | 37.7532563730854 | -122.400624753529 | (37.7532563730854, -122.400624753529) | 10 | 3 | 8 | 28856 | 29 |
| 47522 | 84344 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 581 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2007 12:00:00 AM | 7 | 3x3 | Permit Number 49738 | 5987802.43921 | 2112041.11408 | 37.7785579296732 | -122.485786324881 | (37.7785579296732, -122.485786324881) | 11 | 6 | 2 | 55 | 26 | |
| 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 | |||
| 56885 | 207029 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 835 Sargent St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5991723.94975 | 2089189.17612 | 37.7160401362134 | -122.470555641023 | (37.7160401362134, -122.470555641023) | 9 | 8 | 6 | 64 | 24 | |||
| 59335 | 227553 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4445 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001135.34377 | 2105211.25899 | 37.760572740148 | -122.439173173223 | (37.760572740148, -122.439173173223) | 2 | 4 | 5 | 28862 | 3 | |||
| 77796 | 83657 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 7 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 7 | Permit Number 769748 | 6003905.60089 | 2093401.91906 | 37.728304266518 | -122.428750235745 | (37.728304266518, -122.428750235745) | 9 | 7 | 6 | 28861 | 5 | |
| 112005 | 227095 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3651 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 6ft | 6005946.52179 | 2104309.35666 | 37.7583689226977 | -122.422469389447 | (37.7583689226977, -122.422469389447) | 2 | 4 | 5 | 28859 | 19 | |||
| 115087 | 207027 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 43 Lakeview Ave | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5997356.56263 | 2089224.02458 | 37.7164599136667 | -122.451089274853 | (37.7164599136667, -122.451089274853) | 9 | 8 | 6 | 28861 | 24 | |||
| 119325 | 129374 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 454 Walnut St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5998634.47077 | 2115144.95556 | 37.7877054985629 | -122.448537946784 | (37.7877054985629, -122.448537946784) | 13 | 6 | 1 | 54 | 31 | |||
| 123991 | 65594 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1221 Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/1990 12:00:00 AM | 7 | Permit Number 28496 | 6014809.91986 | 2096215.04668 | 37.7366396697686 | -122.391249786165 | (37.7366396697686, -122.391249786165) | 10 | 3 | 8 | 58 | 1 | ||
| 127633 | 52071 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 939 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2005 12:00:00 AM | 7 | Permit Number 48265 | 6009677.58908 | 2117754.14875 | 37.7954949369081 | -122.410515038747 | (37.7954949369081, -122.410515038747) | 3 | 1 | 10 | 28857 | 4 | ||
| 137268 | 176906 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 769 Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006512.6379 | 2093630.87617 | 37.7290801395131 | -122.419753817278 | (37.7290801395131, -122.419753817278) | 9 | 7 | 7 | 309 | 5 | |||
| 163097 | 129372 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2133 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5999985.51807 | 2120890.75849 | 37.8035591091338 | -122.444276660352 | (37.8035591091338, -122.444276660352) | 13 | 9 | 1 | 57 | 17 | |||
| 180998 | 227573 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4658 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000184.94355 | 2105205.65777 | 37.7605032342671 | -122.442459762729 | (37.7605032342671, -122.442459762729) | 15 | 4 | 5 | 28862 | 3 | |||
| 185300 | 207030 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 835 Sargent St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 5991738.49074 | 2089190.01168 | 37.7160432712657 | -122.470505441771 | (37.7160432712657, -122.470505441771) | 9 | 8 | 6 | 64 | 24 | |||
| 187106 | 227136 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1536 Willard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5996925.1738 | 2105904.39227 | 37.7622354382362 | -122.453784207601 | (37.7622354382362, -122.453784207601) | 15 | 5 | 11 | 29492 | 12 | |||
| 194195 | 52070 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 939 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2005 12:00:00 AM | 7 | Permit Number 48265 | 6009656.25559 | 2117750.51311 | 37.7954837583147 | -122.410588599703 | (37.7954837583147, -122.410588599703) | 3 | 1 | 10 | 28857 | 4 | ||
| 1417 | 88463 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 955X Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51410 | 6015306.946426 | 2096847.395831 | 37.7384035424873 | -122.389575486471 | (37.7384035424873, -122.389575486471) | 10 | 3 | 8 | 58 | 1 |
| 2780 | 79224 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3562 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5997807.39537 | 2115154.90167 | 37.7876854832564 | -122.451400172276 | (37.7876854832564, -122.451400172276) | 11 | 6 | 1 | 54 | 31 | |||
| 3636 | 83176 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3301 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 3x3 | 5985317.61354 | 2111082.30707 | 37.7757802155228 | -122.494311467187 | (37.7757802155228, -122.494311467187) | 11 | 6 | 2 | 55 | 26 | ||
| 8734 | 227141 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 266 Rivoli St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5997670.57496 | 2105917.36363 | 37.7623137611024 | -122.451207095032 | (37.7623137611024, -122.451207095032) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | |||
| 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 | ||
| 13622 | 207003 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2380 Funston Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5992355.41935 | 2099194.17897 | 37.7435478822362 | -122.469100735806 | (37.7435478822362, -122.469100735806) | 1 | 8 | 4 | 29491 | 40 | |||
| 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 | ||
| 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 | ||
| 22554 | 88615 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 521 03rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51567 | 5994972.63478 | 2111950.42136 | 37.7787241118896 | -122.460975481067 | (37.7787241118896, -122.460975481067) | 11 | 6 | 2 | 54 | 11 | |
| 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 | ||
| 32976 | 207036 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1645 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5990861.16949 | 2098351.90974 | 37.7411487751831 | -122.474205983836 | (37.7411487751831, -122.474205983836) | 1 | 8 | 4 | 29491 | 40 | |||
| 41781 | 207002 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2380 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5992354.33739 | 2099175.8386 | 37.7434974617379 | -122.469103142406 | (37.7434974617379, -122.469103142406) | 1 | 8 | 4 | 29491 | 40 | |||
| 44849 | 88614 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 521 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51567 | 5994972.3051 | 2111963.78431 | 37.7787607840169 | -122.460977590338 | (37.7787607840169, -122.460977590338) | 11 | 6 | 2 | 54 | 11 | |
| 52224 | 129373 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2133 Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000002.55629 | 2120892.7221 | 37.8035654727314 | -122.444217840184 | (37.8035654727314, -122.444217840184) | 13 | 9 | 1 | 57 | 17 | |||
| 57139 | 83205 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3437 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52337 | 6002190.72031 | 2120034.66861 | 37.8013340766633 | -122.436584154541 | (37.8013340766633, -122.436584154541) | 13 | 9 | 1 | 57 | 17 | |
| 60494 | 27052 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1016 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/1999 12:00:00 AM | 6 | 3X3 | 6007658.95865 | 2093571.88726 | 37.7289826781912 | -122.415786708996 | (37.7289826781912, -122.415786708996) | 9 | 3 | 7 | 309 | 5 | ||
| 60551 | 227567 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 308 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001758.47595 | 2103911.51009 | 37.7570393829676 | -122.436924995793 | (37.7570393829676, -122.436924995793) | 2 | 4 | 5 | 28862 | 3 | |||
| 68285 | 27051 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1008 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2007 12:00:00 AM | 6 | 3x3 | 6007619.46607 | 2093557.16905 | 37.7289400449304 | -122.415922196353 | (37.7289400449304, -122.415922196353) | 9 | 3 | 7 | 309 | 5 | ||
| 68376 | 27287 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1036 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2008 12:00:00 AM | 6 | 3X3 | 6007731.14975 | 2093596.42391 | 37.729054108643 | -122.415538874723 | (37.729054108643, -122.415538874723) | 9 | 3 | 7 | 309 | 5 |
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) );