trees
253 rows where Police Districts = 8 and qSpecies_id = 6 sorted by PermitNotes
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2908 | 93406 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1408 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/24/2015 11:15:00 AM | 3 | 3x3 | 5988828.0589 | 2099030.2661 | 37.7428933746541 | -122.48128533094 | (37.7428933746541, -122.48128533094) | 1 | 8 | 3 | 29491 | 35 | ||
| 4850 | 262150 | Private 9 | Lagunaria patersonii :: Primrose Tree 6 | 1295 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2020 12:00:00 AM | 3 | 3x3 | 5981486.26206 | 2106277.60943 | 37.7623629555319 | -122.50720831894 | (37.7623629555319, -122.50720831894) | 1 | 8 | 3 | 56 | 35 | ||
| 6683 | 262152 | Private 9 | Lagunaria patersonii :: Primrose Tree 6 | 1295 47th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2020 12:00:00 AM | 3 | 3x3 | 5981486.26206 | 2106277.60943 | 37.7623629555319 | -122.50720831894 | (37.7623629555319, -122.50720831894) | 1 | 8 | 3 | 56 | 35 | ||
| 8142 | 262151 | Private 9 | Lagunaria patersonii :: Primrose Tree 6 | 1295 47th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2020 12:00:00 AM | 3 | 3x3 | 5981486.26206 | 2106277.60943 | 37.7623629555319 | -122.50720831894 | (37.7623629555319, -122.50720831894) | 1 | 8 | 3 | 56 | 35 | ||
| 9692 | 183446 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2511 26th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/08/2020 12:00:00 AM | 3 | Width 0ft | 5988279.6214 | 2098205.3016 | 37.7405963382743 | -122.483121197886 | (37.7405963382743, -122.483121197886) | 1 | 8 | 3 | 29491 | 35 | ||
| 10037 | 183693 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1341 42nd Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983046.6569 | 2105897.5428 | 37.7614111825323 | -122.501783460946 | (37.7614111825323, -122.501783460946) | 1 | 8 | 3 | 56 | 35 | ||
| 10383 | 264872 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2426 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/2020 06:03:00 PM | 3 | 4x6 | 5985846 | 2098694 | 37.7417962544182 | -122.491571569344 | (37.7417962544182, -122.491571569344) | 1 | 8 | 3 | 29491 | 35 | |
| 13074 | 264871 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2430 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/15/2020 12:00:00 AM | 3 | 4x6 | 5985228 | 2098648 | 37.7416338152793 | -122.493704989969 | (37.7416338152793, -122.493704989969) | 1 | 8 | 3 | 29491 | 35 | ||
| 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 | |||
| 15585 | 258769 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 1633 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2019 12:00:00 AM | 3 | 3x3 | 5988962.35654 | 2103065.4403 | 37.7539807026125 | -122.481116375927 | (37.7539807026125, -122.481116375927) | 1 | 8 | 3 | 56 | 35 | ||
| 16581 | 258150 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2485 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 5989205.22412 | 2098441.55094 | 37.7412988370865 | -122.479938140892 | (37.7412988370865, -122.479938140892) | 1 | 8 | 3 | 29491 | 35 | |||
| 18909 | 262153 | Private 9 | Lagunaria patersonii :: Primrose Tree 6 | 1295 47th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2020 12:00:00 AM | 3 | 3x3 | 5981486.26206 | 2106277.60943 | 37.7623629555319 | -122.50720831894 | (37.7623629555319, -122.50720831894) | 1 | 8 | 3 | 56 | 35 | ||
| 19993 | 182699 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1659 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5989088.7291 | 2103739.8915 | 37.7558399109499 | -122.480728726959 | (37.7558399109499, -122.480728726959) | 1 | 8 | 3 | 56 | 35 | |||
| 20055 | 206989 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1304 11th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5992723.56277 | 2106565.73006 | 37.7638095171187 | -122.468363979738 | (37.7638095171187, -122.468363979738) | 1 | 8 | 11 | 56 | 12 | |||
| 20319 | 106193 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 3040 TARAVAL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5983698.2 | 2098878.7 | 37.742177638004 | -122.499011481047 | (37.742177638004, -122.499011481047) | 1 | 8 | 3 | 29491 | 35 | ||||
| 25751 | 182700 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1651 Moraga St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5989102.9459 | 2103739.8915 | 37.7558407372502 | -122.480679561224 | (37.7558407372502, -122.480679561224) | 1 | 8 | 3 | 56 | 35 | |||
| 28327 | 162331 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 26 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 02:09:00 PM | 3 | Width 0ft | 5996526.61739 | 2090076.51041 | 37.7187530886569 | -122.454019490912 | (37.7187530886569, -122.454019490912) | 9 | 8 | 6 | 28861 | 24 | ||
| 29174 | 183692 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1341 42nd Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983047.3598 | 2105912.7714 | 37.761453037237 | -122.501782156698 | (37.761453037237, -122.501782156698) | 1 | 8 | 3 | 56 | 35 | ||
| 30044 | 254525 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3906 Judah St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 09/07/2012 12:00:00 AM | 3x3 | 5982400 | 2105639 | 37.7606632919303 | -122.504000789622 | (37.7606632919303, -122.504000789622) | 1 | 8 | 3 | 56 | 35 | ||
| 30373 | 184599 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1795 40th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5983770.6594 | 2102984.6576 | 37.7534557168171 | -122.499064248064 | (37.7534557168171, -122.499064248064) | 1 | 8 | 3 | 56 | 35 | |||
| 30581 | 252889 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 301x Howth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2019 08:45:00 AM | 3 | 3x3 | 5997131 | 2090234 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | 9 | 8 | 6 | 28861 | 24 | ||
| 30582 | 183121 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2327 41st Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5983581.7952 | 2099373.3538 | 37.7435289932417 | -122.49945051311 | (37.7435289932417, -122.49945051311) | 1 | 8 | 3 | 29491 | 35 | |||
| 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 | |||
| 34235 | 207024 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 85 Williar Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5997067.34432 | 2090557.59428 | 37.7201050223995 | -122.452185117661 | (37.7201050223995, -122.452185117661) | 9 | 8 | 6 | 28861 | 24 | |||
| 34355 | 80237 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1675 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5985295.5529 | 2103816.7715 | 37.7558298048279 | -122.493852234736 | (37.7558298048279, -122.493852234736) | 1 | 8 | 3 | 56 | 35 | |||
| 39727 | 182826 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1781 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5986558.6884 | 2103101.4836 | 37.7539396409234 | -122.48943136929 | (37.7539396409234, -122.48943136929) | 1 | 8 | 3 | 56 | 35 | |||
| 40337 | 254524 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3906 Judah St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 07/10/2015 07:56:00 AM | 3 | 3x3 | 5982400 | 2105639 | 37.7606632919303 | -122.504000789622 | (37.7606632919303, -122.504000789622) | 1 | 8 | 3 | 56 | 35 | |
| 41606 | 207031 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1528 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992776.06817 | 2105054.20165 | 37.7596622898883 | -122.468072424026 | (37.7596622898883, -122.468072424026) | 1 | 8 | 4 | 56 | 12 | |||
| 41654 | 112585 | Section 143 10 | Lagunaria patersonii :: Primrose Tree 6 | 3400x WAWONA ST | 6 | Sidewalk: Property side : Cutout | Tree | Private 2 | 4x4 | 5982411 | 2096792 | 37.7363725426512 | -122.503307672629 | (37.7363725426512, -122.503307672629) | 1 | 8 | 3 | 29491 | 35 | ||||
| 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 | |||
| 42322 | 24532 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1395 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/28/2017 12:21:00 PM | 3 | 3X3 | 5981507.2257 | 2105680.0147 | 37.7607233666377 | -122.507091481475 | (37.7607233666377, -122.507091481475) | 1 | 8 | 3 | 56 | 35 | ||
| 44650 | 206994 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 607 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992653.289 | 2105901.13559 | 37.761980656709 | -122.468558674846 | (37.761980656709, -122.468558674846) | 1 | 8 | 4 | 56 | 12 | |||
| 44798 | 184494 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1875 38th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984410.615 | 2102424.5695 | 37.7519553887834 | -122.496809845733 | (37.7519553887834, -122.496809845733) | 1 | 8 | 3 | 56 | 35 | |||
| 46414 | 112583 | Section 143 10 | Lagunaria patersonii :: Primrose Tree 6 | 3400x WAWONA ST | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 1 | 4x4 | 5982411 | 2096792 | 37.7363725426512 | -122.503307672629 | (37.7363725426512, -122.503307672629) | 1 | 8 | 3 | 29491 | 35 | |||
| 48766 | 207033 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Quintara St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5993145.27059 | 2101214.49823 | 37.7491407714503 | -122.466516461993 | (37.7491407714503, -122.466516461993) | 1 | 8 | 4 | 29491 | 12 | |||
| 50194 | 183672 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1254 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5984312.3195 | 2106638.1262 | 37.7635188796404 | -122.497460805156 | (37.7635188796404, -122.497460805156) | 1 | 8 | 3 | 56 | 35 | |||
| 51774 | 184549 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3501 Moraga St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5983411.1343 | 2103548.3965 | 37.754982490057 | -122.500349218821 | (37.754982490057, -122.500349218821) | 1 | 8 | 3 | 56 | 35 | |||
| 52327 | 835 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1396X 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2017 10:55:00 AM | 3 | 3X3 | 5981242.3727 | 2105595.8151 | 37.7604765764936 | -122.5080012238 | (37.7604765764936, -122.5080012238) | 1 | 8 | 3 | 56 | 35 | ||
| 52445 | 251444 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 244 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 07:40:00 AM | 3 | 3x3 | 5994545 | 2088436 | 37.7141348140673 | -122.460750275072 | (37.7141348140673, -122.460750275072) | 9 | 8 | 6 | 28861 | 24 | ||
| 53815 | 207037 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2642 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5990833.84583 | 2097410.6031 | 37.7385626055711 | -122.474231788985 | (37.7385626055711, -122.474231788985) | 1 | 8 | 4 | 29491 | 40 | |||
| 54340 | 840 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1412 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/06/2015 01:14:00 PM | 3 | 3x3 | 5981250.4206842 | 2105445.3666043 | 37.7600639622975 | -122.507962224252 | (37.7600639622975, -122.507962224252) | 1 | 8 | 3 | 56 | 35 | ||
| 54999 | 101252 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 1290X 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992716.9 | 2106688.9 | 37.7641473244126 | -122.468395985577 | (37.7641473244126, -122.468395985577) | 11 | 8 | 11 | 56 | 12 | ||||
| 55470 | 11606 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4200x Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/28/2017 11:54:00 AM | 3 | 3X3 | 5981492.2847 | 2105581.1189 | 37.7604509471428 | -122.507135818078 | (37.7604509471428, -122.507135818078) | 1 | 8 | 3 | 56 | 35 | ||
| 56104 | 182307 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1509 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5987118.7965 | 2104973.5941 | 37.7591126281614 | -122.487631931758 | (37.7591126281614, -122.487631931758) | 1 | 8 | 3 | 56 | 35 | |||
| 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 | |||
| 56938 | 206999 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 404 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5991570.38275 | 2099794.54343 | 37.7451509372588 | -122.471858917877 | (37.7451509372588, -122.471858917877) | 1 | 8 | 4 | 29491 | 40 | |||
| 58640 | 11589 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4050X Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/19/2016 11:29:00 AM | 3 | 3X3 | 5981992.3567285 | 2105594.1635633 | 37.7605162040396 | -122.505407296146 | (37.7605162040396, -122.505407296146) | 1 | 8 | 3 | 56 | 35 | ||
| 59994 | 11598 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4134 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/28/2017 11:51:00 AM | 3 | 3X3 | 5981663.7126 | 2105589.2786 | 37.7604834464148 | -122.506543543521 | (37.7604834464148, -122.506543543521) | 1 | 8 | 3 | 56 | 35 | ||
| 60258 | 184208 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1474 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5983740.5189 | 2105133.2538 | 37.7593533930501 | -122.49932723943 | (37.7593533930501, -122.49932723943) | 1 | 8 | 3 | 56 | 35 | |||
| 63550 | 93407 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1414 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/24/2015 11:09:00 AM | 3 | 3x3 | 5988810.4689 | 2099030.2661 | 37.7428923519808 | -122.481346151554 | (37.7428923519808, -122.481346151554) | 1 | 8 | 3 | 29491 | 35 | ||
| 63727 | 207043 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 73 Keystone Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5994097.83418 | 2093287.06293 | 37.7274289275879 | -122.46264752637 | (37.7274289275879, -122.46264752637) | 9 | 8 | 4 | 59 | 40 | |||
| 69798 | 207032 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1672 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992498.79373 | 2104084.7245 | 37.7569843426628 | -122.468960816591 | (37.7569843426628, -122.468960816591) | 1 | 8 | 4 | 56 | 12 | |||
| 70295 | 11573 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3906 Judah St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/10/2015 07:56:00 AM | 3 | 3X3 | 5982438 | 2105598 | 37.7605529521075 | -122.503866330302 | (37.7605529521075, -122.503866330302) | 1 | 8 | 3 | 56 | 35 | ||
| 71829 | 206984 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1498 17th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5990877.91026 | 2105249.91359 | 37.7600898599821 | -122.474651424322 | (37.7600898599821, -122.474651424322) | 1 | 8 | 4 | 56 | 12 | |||
| 72364 | 216718 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 978 Capitol Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/13/2017 11:36:00 AM | 3 | Width 3ft | 5995057.03199 | 2090421.24862 | 37.7196152839906 | -122.459124173263 | (37.7196152839906, -122.459124173263) | 9 | 8 | 6 | 28861 | 24 | ||
| 72730 | 251681 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 02:36:00 PM | 3 | 3x5 | 5996550 | 2089909 | 37.7182944850221 | -122.453926576307 | (37.7182944850221, -122.453926576307) | 9 | 8 | 6 | 28861 | 24 | ||
| 78293 | 116736 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1799x 25TH AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5988397 | 2103119 | 37.7540948807956 | -122.483075414994 | (37.7540948807956, -122.483075414994) | 1 | 8 | 3 | 56 | 35 | ||||
| 79084 | 207006 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 243 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992316.05801 | 2097825.56846 | 37.7397877510963 | -122.469137249186 | (37.7397877510963, -122.469137249186) | 1 | 8 | 4 | 59 | 40 | |||
| 80153 | 183694 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1341 42nd Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983048.5312 | 2105875.9885 | 37.7613521106328 | -122.501775383852 | (37.7613521106328, -122.501775383852) | 1 | 8 | 3 | 56 | 35 | ||
| 85415 | 207038 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 270 Magellan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 5994641.46146 | 2100307.89339 | 37.7467376875983 | -122.461276941602 | (37.7467376875983, -122.461276941602) | 1 | 8 | 4 | 29491 | 40 | |||
| 87952 | 207035 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Quintara St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5993108.07657 | 2101214.12996 | 37.7491376139164 | -122.466645051533 | (37.7491376139164, -122.466645051533) | 1 | 8 | 4 | 29491 | 12 | |||
| 88773 | 216845 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 194 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 07:48:00 AM | 3 | Width 3ft | 5995118.95449 | 2088413.12295 | 37.7141050056202 | -122.458764825742 | (37.7141050056202, -122.458764825742) | 9 | 8 | 6 | 28861 | 24 | ||
| 92387 | 184697 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1616 43rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5982844.3503 | 2104136.3629 | 37.7565635951525 | -122.502352798468 | (37.7565635951525, -122.502352798468) | 1 | 8 | 3 | 56 | 35 | |||
| 92547 | 106331 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1651 TARAVAL ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/02/2015 05:38:00 PM | 3 | 3x3 | 5988118.12003 | 2098953.52216 | 37.7426413556222 | -122.483734446336 | (37.7426413556222, -122.483734446336) | 1 | 8 | 3 | 29491 | 35 | ||
| 93431 | 11602 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4150 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/06/2011 12:00:00 AM | 3 | 3X3 | 5981591.6344 | 2105586.8054 | 37.7604724115264 | -122.506792641078 | (37.7604724115264, -122.506792641078) | 1 | 8 | 3 | 56 | 35 | ||
| 93687 | 206996 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1607 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5993365.5475 | 2104527.17443 | 37.7582492355186 | -122.465995428957 | (37.7582492355186, -122.465995428957) | 1 | 8 | 4 | 56 | 12 | |||
| 96117 | 184640 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1650 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5983160.9711 | 2103902.0944 | 37.7559389581009 | -122.501240500695 | (37.7559389581009, -122.501240500695) | 1 | 8 | 3 | 56 | 35 | |||
| 97071 | 183696 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1341 42nd Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983051.3079 | 2105837.6039 | 37.7612468805065 | -122.501762940556 | (37.7612468805065, -122.501762940556) | 1 | 8 | 3 | 56 | 35 | ||
| 98805 | 254526 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3906 Judah St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 5982400 | 2105639 | 37.7606632919303 | -122.504000789622 | (37.7606632919303, -122.504000789622) | 1 | 8 | 3 | 56 | 35 | |||
| 99461 | 216848 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 258 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2017 02:39:00 PM | 3 | Width 3ft | 5994378.76562 | 2088424.12647 | 37.7140926462446 | -122.461323980613 | (37.7140926462446, -122.461323980613) | 9 | 8 | 6 | 28861 | 24 | ||
| 102267 | 207020 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 230 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5996253.66444 | 2091441.06295 | 37.7224841734802 | -122.455061523672 | (37.7224841734802, -122.455061523672) | 9 | 8 | 4 | 28861 | 24 | |||
| 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 | |||
| 104950 | 183303 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1286 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5982766.9656 | 2106385.9546 | 37.7627357893861 | -122.502786935917 | (37.7627357893861, -122.502786935917) | 1 | 8 | 3 | 56 | 35 | |||
| 106816 | 181949 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2450 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5986451.9754 | 2098568.253 | 37.7414863814969 | -122.489467090095 | (37.7414863814969, -122.489467090095) | 1 | 8 | 3 | 29491 | 35 | |||
| 109442 | 206995 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1584 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5993720.55073 | 2104714.02617 | 37.7587827556425 | -122.464781251568 | (37.7587827556425, -122.464781251568) | 1 | 8 | 4 | 56 | 12 | |||
| 109495 | 184723 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1635 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5983115.9866 | 2103988.5253 | 37.7561736313112 | -122.501402462618 | (37.7561736313112, -122.501402462618) | 1 | 8 | 3 | 56 | 35 | |||
| 111662 | 252898 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 501x Mount Vernon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997879 | 2089997 | 37.7186122227881 | -122.449339142229 | (37.7186122227881, -122.449339142229) | 9 | 8 | 6 | 28861 | 24 | ||||
| 111974 | 206992 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 633 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992553.59441 | 2105897.35752 | 37.761964523762 | -122.468903201544 | (37.761964523762, -122.468903201544) | 1 | 8 | 4 | 56 | 12 | |||
| 112582 | 207022 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 85 Williar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5997053.5846 | 2090532.92812 | 37.7200365066592 | -122.452230901246 | (37.7200365066592, -122.452230901246) | 9 | 8 | 6 | 28861 | 24 | |||
| 112687 | 207000 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 404 Santiago St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5991556.48203 | 2099793.0654 | 37.7451460746357 | -122.471906875997 | (37.7451460746357, -122.471906875997) | 1 | 8 | 4 | 29491 | 40 | |||
| 115054 | 11582 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4000 Judah St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/28/2017 11:49:00 AM | 3 | 3X3 | 5982109.291 | 2105604.0369 | 37.7605501938414 | -122.505003612665 | (37.7605501938414, -122.505003612665) | 1 | 8 | 3 | 56 | 35 | ||
| 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 | |||
| 115203 | 183690 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1341 42nd Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983045.4855 | 2105953.0685 | 37.7615635715471 | -122.50179162058 | (37.7615635715471, -122.50179162058) | 1 | 8 | 3 | 56 | 35 | ||
| 118421 | 183902 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2101 22nd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x3 | 5989433.6077 | 2100684.129 | 37.7474696361105 | -122.479312499521 | (37.7474696361105, -122.479312499521) | 1 | 8 | 3 | 29491 | 35 | |||
| 119754 | 116735 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1799x 25TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5988397 | 2103119 | 37.7540948807956 | -122.483075414994 | (37.7540948807956, -122.483075414994) | 1 | 8 | 3 | 56 | 35 | ||||
| 120285 | 207025 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 85 Williar Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5997075.91635 | 2090573.81293 | 37.7201500460637 | -122.452156656813 | (37.7201500460637, -122.452156656813) | 9 | 8 | 6 | 28861 | 24 | |||
| 129143 | 181684 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1347 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5986459.3313 | 2106064.8642 | 37.7620704697574 | -122.489992909675 | (37.7620704697574, -122.489992909675) | 1 | 8 | 3 | 56 | 35 | |||
| 132066 | 207026 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 229 Lobos St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5994724.72263 | 2088692.24537 | 37.7148487422402 | -122.460147642199 | (37.7148487422402, -122.460147642199) | 9 | 8 | 6 | 28861 | 24 | |||
| 132551 | 112584 | Section 143 10 | Lagunaria patersonii :: Primrose Tree 6 | 3400x WAWONA ST | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 4x4 | 5982411 | 2096792 | 37.7363725426512 | -122.503307672629 | (37.7363725426512, -122.503307672629) | 1 | 8 | 3 | 29491 | 35 | ||||
| 133037 | 206993 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 615 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992617.51095 | 2105899.81469 | 37.7619749630815 | -122.468682319958 | (37.7619749630815, -122.468682319958) | 1 | 8 | 4 | 56 | 12 | |||
| 134028 | 181690 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1374 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5982168.1662 | 2105754.9295 | 37.7609679655916 | -122.504811174863 | (37.7609679655916, -122.504811174863) | 1 | 8 | 3 | 56 | 35 | |||
| 134756 | 19062 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 174 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/10/2017 08:47:00 AM | 3 | 3X3 | 5995225.08055 | 2087462.80286 | 37.7115017488702 | -122.458329272374 | (37.7115017488702, -122.458329272374) | 9 | 8 | 6 | 28861 | 24 | ||
| 137435 | 206990 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1383 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5992691.68575 | 2106051.40057 | 37.7623954627053 | -122.468436809505 | (37.7623954627053, -122.468436809505) | 1 | 8 | 11 | 56 | 12 | |||
| 137770 | 206987 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1248 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5992091.43933 | 2106913.61789 | 37.7647281934706 | -122.470575621288 | (37.7647281934706, -122.470575621288) | 11 | 8 | 11 | 56 | 12 | |||
| 138543 | 183699 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1341 42nd Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983053.3747 | 2105791.1008 | 37.7611193175785 | -122.501752351825 | (37.7611193175785, -122.501752351825) | 1 | 8 | 3 | 56 | 35 | ||
| 140348 | 183523 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2542 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5986781.4828 | 2097933.2945 | 37.7397621847049 | -122.488281131206 | (37.7397621847049, -122.488281131206) | 1 | 8 | 3 | 29491 | 35 | |||
| 140513 | 86510 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1280 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5987725.9187 | 2106586.638 | 37.7635769970805 | -122.485650622827 | (37.7635769970805, -122.485650622827) | 1 | 8 | 3 | 56 | 35 | |
| 140576 | 207034 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Quintara St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5993127.03688 | 2101215.11136 | 37.7491414027515 | -122.466579558421 | (37.7491414027515, -122.466579558421) | 1 | 8 | 4 | 29491 | 12 | |||
| 140729 | 206991 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1383 11th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5992691.10596 | 2106043.86409 | 37.7623747360262 | -122.468438266429 | (37.7623747360262, -122.468438266429) | 1 | 8 | 11 | 56 | 12 | |||
| 140883 | 184598 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1795 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5983770.321 | 2103008.0087 | 37.7535198125919 | -122.499067143504 | (37.7535198125919, -122.499067143504) | 1 | 8 | 3 | 56 | 35 |
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) );