trees
8,659 rows where qSpecies_id = 11 sorted by qCaretaker_id 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 175720 | 113865 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 301x BRODERICK ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001207 | 2109749 | 37.7730363312645 | -122.439250600749 | (37.7730363312645, -122.439250600749) | 15 | 5 | 11 | 29492 | 10 | ||||
| 181717 | 246848 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 10 | : | Tree | DPW for City Agency 14 | 14 | Width 3ft | 6001221.88417 | 2109765.97896 | 37.7730837982073 | -122.439200331843 | (37.7730837982073, -122.439200331843) | 15 | 5 | 11 | 29492 | 10 | |||
| 193628 | 129872 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2051 Beach St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 7 | Width 4ft | Permit Number 771149 | 6000353.54628 | 2120943.15919 | 37.803723977331 | -122.443006850904 | (37.803723977331, -122.443006850904) | 13 | 9 | 1 | 57 | 17 | ||
| 88348 | 105149 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1X COTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | 7 | 3x3 | 6002672 | 2093020 | 37.7271857072251 | -122.432987568669 | (37.7271857072251, -122.432987568669) | 9 | 7 | 6 | 28861 | 25 | |||
| 34636 | 22980 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 630 Valencia St | 4 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 09/30/2006 12:00:00 AM | 6 | 3X3 | 6006179.6291421 | 2105955.3041542 | 37.7629014568562 | -122.42178011092 | (37.7629014568562, -122.42178011092) | 8 | 4 | 5 | 28859 | 19 | ||
| 55785 | 115946 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3403x 17TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 3x3 | 6006158 | 2105944 | 37.7628691985612 | -122.421854115722 | (37.7628691985612, -122.421854115722) | 8 | 4 | 5 | 28859 | 19 | ||||
| 75152 | 22982 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 630 Valencia St | 6 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 11/30/1994 12:00:00 AM | 20 | 3X3 | 6006179.6291421 | 2105955.3041542 | 37.7629014568562 | -122.42178011092 | (37.7629014568562, -122.42178011092) | 8 | 4 | 5 | 28859 | 19 | ||
| 76085 | 115945 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3403x 17TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 3x3 | 6006158 | 2105944 | 37.7628691985612 | -122.421854115722 | (37.7628691985612, -122.421854115722) | 8 | 4 | 5 | 28859 | 19 | ||||
| 88744 | 22983 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 630 Valencia St | 7 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 01/25/1995 12:00:00 AM | 18 | 3X3 | 6006179.6291421 | 2105955.3041542 | 37.7629014568562 | -122.42178011092 | (37.7629014568562, -122.42178011092) | 8 | 4 | 5 | 28859 | 19 | ||
| 94707 | 22978 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 630 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 03/14/1995 12:00:00 AM | 18 | 3X3 | 6006171.13469 | 2105920.83028 | 37.7628063206751 | -122.421807041478 | (37.7628063206751, -122.421807041478) | 8 | 4 | 5 | 28859 | 19 | ||
| 103432 | 22985 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 630 Valencia St | 9 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 11/29/1994 12:00:00 AM | 20 | 3X3 | 6006179.6291421 | 2105955.3041542 | 37.7629014568562 | -122.42178011092 | (37.7629014568562, -122.42178011092) | 8 | 4 | 5 | 28859 | 19 | ||
| 114383 | 115944 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3403x 17TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 3x3 | 6006158 | 2105944 | 37.7628691985612 | -122.421854115722 | (37.7628691985612, -122.421854115722) | 8 | 4 | 5 | 28859 | 19 | ||||
| 124910 | 22981 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 630 Valencia St | 5 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 01/25/1995 12:00:00 AM | 18 | 3X3 | 6006179.6291421 | 2105955.3041542 | 37.7629014568562 | -122.42178011092 | (37.7629014568562, -122.42178011092) | 8 | 4 | 5 | 28859 | 19 | ||
| 125871 | 115943 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3403x 17TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 3x3 | 6006158 | 2105944 | 37.7628691985612 | -122.421854115722 | (37.7628691985612, -122.421854115722) | 8 | 4 | 5 | 28859 | 19 | ||||
| 126318 | 22977 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 630 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 03/14/1995 12:00:00 AM | 20 | 3X3 | 6006170.03999 | 2105955.48094 | 37.7629014015073 | -122.421813289079 | (37.7629014015073, -122.421813289079) | 8 | 4 | 5 | 28859 | 19 | ||
| 136299 | 22984 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 630 Valencia St | 8 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 11/29/1994 12:00:00 AM | 20 | 3X3 | 6006179.6291421 | 2105955.3041542 | 37.7629014568562 | -122.42178011092 | (37.7629014568562, -122.42178011092) | 8 | 4 | 5 | 28859 | 19 | ||
| 149163 | 22979 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 630 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 11/29/1994 12:00:00 AM | 20 | 3X3 | 6006179.6291421 | 2105955.3041542 | 37.7629014568562 | -122.42178011092 | (37.7629014568562, -122.42178011092) | 8 | 4 | 5 | 28859 | 19 | ||
| 173013 | 115947 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3403x 17TH ST | 6 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 3x3 | 6006158 | 2105944 | 37.7628691985612 | -122.421854115722 | (37.7628691985612, -122.421854115722) | 8 | 4 | 5 | 28859 | 19 | ||||
| 180143 | 82224 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3403x 17TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 02/26/2005 12:00:00 AM | 12 | 3x3 | 6006158 | 2105944 | 37.7628691985612 | -122.421854115722 | (37.7628691985612, -122.421854115722) | 8 | 4 | 5 | 28859 | 19 | ||
| 21625 | 14774 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1000X McAllister St | 9 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 05/13/1992 12:00:00 AM | 6 | 4X4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | 7 | 9 | 11 | 29490 | 41 | ||
| 46399 | 14769 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1000X McAllister St | 4 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 07/11/1995 12:00:00 AM | 6 | 4X4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | 7 | 9 | 11 | 29490 | 41 | ||
| 43608 | 112287 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 50 Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 5 | 6007006.5 | 2110627.3 | 37.7757762467653 | -122.419251679167 | (37.7757762467653, -122.419251679167) | 7 | 9 | 9 | 28852 | 36 | ||||
| 55672 | 23150 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 50 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 3 | 3X3 | 6007031.8302252 | 2110521.0652082 | 37.7754859780082 | -122.419156518057 | (37.7754859780082, -122.419156518057) | 7 | 9 | 9 | 28852 | 36 | |||
| 65065 | 23151 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 50 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 08/24/1993 12:00:00 AM | 8 | 3X3 | 6007030.5326516 | 2110530.1061031 | 37.7755107290659 | -122.419161648128 | (37.7755107290659, -122.419161648128) | 7 | 9 | 9 | 28852 | 36 | ||
| 128940 | 23156 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 50 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 08/24/1993 12:00:00 AM | 18 | 3X3 | 6007006.484382 | 2110627.274272 | 37.7757761752428 | -122.419251731369 | (37.7757761752428, -122.419251731369) | 7 | 9 | 9 | 28852 | 36 | ||
| 190500 | 23152 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 50 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 10/03/2000 12:00:00 AM | 12 | 6007026.70172 | 2110556.798269 | 37.7755838036152 | -122.419176794071 | (37.7755838036152, -122.419176794071) | 7 | 9 | 9 | 28852 | 36 | |||
| 615 | 262077 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 565 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | Private | 04/16/2020 12:00:00 AM | 3 | 3x3 | 6003870.34162 | 2109702.301 | 37.7730593047529 | -122.430034440005 | (37.7730593047529, -122.430034440005) | 7 | 9 | 11 | 29492 | 10 | |
| 7035 | 3622 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 58 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6017832.21147 | 2098347.65106 | 37.7426626399605 | -122.380948529647 | (37.7426626399605, -122.380948529647) | 10 | 3 | 8 | 58 | 1 | |||
| 11075 | 3596 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 32 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 05/01/2017 03:07:00 PM | 3 | 3X3 | 6018288.66955 | 2098007.43076 | 37.7417536466133 | -122.379346585295 | (37.7417536466133, -122.379346585295) | 10 | 3 | 8 | 58 | 1 | ||
| 13263 | 27467 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3255 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/10/1999 12:00:00 AM | 3 | 3X3 | 6016160.2227 | 2100486.94206 | 37.7484442654916 | -122.386878998841 | (37.7484442654916, -122.386878998841) | 10 | 3 | 8 | 58 | 1 | ||
| 31657 | 3663 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 99 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/12/1990 12:00:00 AM | 3 | 3X3 | 6017184.0839 | 2098879.25737 | 37.744086528482 | -122.383226584333 | (37.744086528482, -122.383226584333) | 10 | 3 | 8 | 58 | 1 | ||
| 38829 | 22089 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3400X 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 3X3 | 6016009.5802 | 2099538.74144 | 37.7458323609698 | -122.387333787882 | (37.7458323609698, -122.387333787882) | 10 | 3 | 8 | 58 | 1 | |||
| 46985 | 83041 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 11 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 04/10/2017 09:47:00 AM | 3 | 6018722.37051 | 2097684.4746 | 37.7408907812923 | -122.377824564564 | (37.7408907812923, -122.377824564564) | 10 | 3 | 8 | 58 | 1 | |||
| 47874 | 3638 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 74 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6017567.18226 | 2098548.9302 | 37.7432006800566 | -122.381878930467 | (37.7432006800566, -122.381878930467) | 10 | 3 | 8 | 58 | 1 | |||
| 51450 | 22094 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3400X 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 3 | 3X3 | 6016017.00918 | 2099367.08567 | 37.7453614410817 | -122.38729612742 | (37.7453614410817, -122.38729612742) | 10 | 3 | 8 | 58 | 1 | |||
| 55257 | 27468 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3255 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/10/1999 12:00:00 AM | 3 | 3X3 | 6016160.2227 | 2100486.94206 | 37.7484442654916 | -122.386878998841 | (37.7484442654916, -122.386878998841) | 10 | 3 | 8 | 58 | 1 | ||
| 62490 | 22091 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3400X 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/16/1995 12:00:00 AM | 3 | 3X3 | 6016010.69646 | 2099489.56952 | 37.7456974068511 | -122.387326498503 | (37.7456974068511, -122.387326498503) | 10 | 3 | 8 | 58 | 1 | ||
| 67468 | 22078 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3240 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/07/1995 12:00:00 AM | 3 | 3X3 | 6015962.98615 | 2100528.59711 | 37.7485477189018 | -122.387563950724 | (37.7485477189018, -122.387563950724) | 10 | 3 | 8 | 58 | 1 | ||
| 74679 | 3651 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 87 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/10/1999 12:00:00 AM | 3 | 3X3 | 6017363.38197 | 2098733.24342 | 37.7436955104472 | -122.382596447366 | (37.7436955104472, -122.382596447366) | 10 | 3 | 8 | 58 | 1 | ||
| 84066 | 22080 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3240 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/07/1995 12:00:00 AM | 3 | 3X3 | 6015965.08966 | 2100473.24055 | 37.7483958378055 | -122.387552815329 | (37.7483958378055, -122.387552815329) | 10 | 3 | 8 | 58 | 1 | ||
| 84328 | 3645 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 81 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017457.23238 | 2098648.52258 | 37.7434680683118 | -122.382266039154 | (37.7434680683118, -122.382266039154) | 10 | 3 | 8 | 58 | 1 | ||
| 94317 | 3573 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 8 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 04/10/2017 09:44:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | ||
| 95138 | 22079 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3240 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/07/1995 12:00:00 AM | 3 | 3X3 | 6015964.59871 | 2100502.10987 | 37.7484750797647 | -122.387556526832 | (37.7484750797647, -122.387556526832) | 10 | 3 | 8 | 58 | 1 | ||
| 100477 | 22088 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3400X 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 6016008.97261 | 2099546.31799 | 37.7458531309618 | -122.387336417288 | (37.7458531309618, -122.387336417288) | 10 | 3 | 8 | 58 | 1 | ||||
| 104870 | 22081 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3240 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/07/1995 12:00:00 AM | 3 | 3X3 | 6015967.58513 | 2100424.02181 | 37.7482608315927 | -122.387540752722 | (37.7482608315927, -122.387540752722) | 10 | 3 | 8 | 58 | 1 | ||
| 112320 | 3614 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 50 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 3X3 | 6017985.84349 | 2098232.4529 | 37.7423548074344 | -122.380409304248 | (37.7423548074344, -122.380409304248) | 10 | 3 | 8 | 58 | 1 | |||
| 112592 | 3588 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 24 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 04/10/2017 10:07:00 AM | 3 | 3X3 | 6018423.14615 | 2097904.9005 | 37.7414795341434 | -122.37887448618 | (37.7414795341434, -122.37887448618) | 10 | 3 | 8 | 58 | 1 | ||
| 113657 | 22077 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3240 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/07/1995 12:00:00 AM | 3 | 3x3 | 6015962.92433 | 2100554.91453 | 37.748619977641 | -122.387566000296 | (37.748619977641, -122.387566000296) | 10 | 3 | 8 | 58 | 1 | ||
| 115474 | 22092 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3400X 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 3 | 3X3 | 6016011.14545 | 2099476.05696 | 37.7456603290167 | -122.387324003523 | (37.7456603290167, -122.387324003523) | 10 | 3 | 8 | 58 | 1 | |||
| 123687 | 3607 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 43 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3x3 | 6018106.23722 | 2098142.91565 | 37.7421155985579 | -122.37998679465 | (37.7421155985579, -122.37998679465) | 10 | 3 | 8 | 58 | 1 | |||
| 125869 | 3592 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 28 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 05/31/1996 12:00:00 AM | 3 | 3X3 | 6018357.04475 | 2097955.64275 | 37.7416152175818 | -122.379106567936 | (37.7416152175818, -122.379106567936) | 10 | 3 | 8 | 58 | 1 | ||
| 129131 | 22096 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3400X 03rd St | 9 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/16/1995 12:00:00 AM | 3 | 3X3 | 6016015.13995 | 2099327.44393 | 37.7452524895199 | -122.38729982623 | (37.7452524895199, -122.38729982623) | 10 | 3 | 8 | 58 | 1 | ||
| 129690 | 3597 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 33 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 11/03/2017 12:00:00 AM | 3 | 3X3 | 6018273.82586 | 2098018.15438 | 37.7417822729228 | -122.379398655143 | (37.7417822729228, -122.379398655143) | 10 | 3 | 8 | 58 | 1 | ||
| 140288 | 3585 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 21 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 05/01/2017 03:02:00 PM | 3 | 3x3 | 6018473.32905 | 2097868.47388 | 37.7413822805579 | -122.378698440283 | (37.7413822805579, -122.378698440283) | 10 | 3 | 8 | 58 | 1 | ||
| 148452 | 22090 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3400X 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/03/1995 12:00:00 AM | 3 | 3X3 | 6016009.63374 | 2099530.63966 | 37.7458101181201 | -122.387333037689 | (37.7458101181201, -122.387333037689) | 10 | 3 | 8 | 58 | 1 | ||
| 149272 | 22083 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3240 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/07/1995 12:00:00 AM | 3 | 6015972.44529 | 2100358.98918 | 37.7480825346922 | -122.38751940999 | (37.7480825346922, -122.38751940999) | 10 | 3 | 8 | 58 | 1 | |||
| 156533 | 27477 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 20 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 04/10/2017 09:59:00 AM | 3 | 3X3 | 6018492.70308 | 2097854.80306 | 37.7413458112573 | -122.378630501891 | (37.7413458112573, -122.378630501891) | 10 | 3 | 8 | 58 | 1 | ||
| 167448 | 22095 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3400X 03rd St | 8 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6016014.43703 | 2099301.13659 | 37.7451802160606 | -122.387300422076 | (37.7451802160606, -122.387300422076) | 10 | 3 | 8 | 58 | 1 | |||
| 174733 | 3572 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 7 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 04/10/2017 09:42:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | ||
| 177473 | 83048 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 4 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 04/10/2017 09:41:00 AM | 3 | 6018843.8838 | 2097592.61577 | 37.7406452501696 | -122.3773980395 | (37.7406452501696, -122.3773980395) | 10 | 3 | 8 | 58 | 1 | |||
| 185865 | 3655 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 91 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6017319.27606 | 2098771.24223 | 37.7437974108278 | -122.382751600221 | (37.7437974108278, -122.382751600221) | 10 | 3 | 8 | 58 | 1 | |||
| 188967 | 3649 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 85 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 05/31/1996 12:00:00 AM | 3 | 3X3 | 6017394.85513 | 2098704.55396 | 37.7436184736271 | -122.382485623916 | (37.7436184736271, -122.382485623916) | 10 | 3 | 8 | 58 | 1 | ||
| 190744 | 27469 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3201 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/10/1999 12:00:00 AM | 3 | 3X3 | 6016045.2641 | 2100630.70669 | 37.7488326475194 | -122.387286553937 | (37.7488326475194, -122.387286553937) | 10 | 3 | 8 | 58 | 1 | ||
| 633 | 9792 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 36 | 3x3 | 6005630.9126204 | 2113075.2727517 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | 7 | 9 | 11 | 28852 | 41 | |||
| 7597 | 9777 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 30 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.7814929008439 | -122.42399680549 | (37.7814929008439, -122.42399680549) | 7 | 9 | 11 | 28852 | 41 | |||
| 15513 | 9780 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.7814929008439 | -122.42399680549 | (37.7814929008439, -122.42399680549) | 7 | 9 | 11 | 28852 | 41 | |||
| 25322 | 9783 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 11 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.7814929008439 | -122.42399680549 | (37.7814929008439, -122.42399680549) | 7 | 9 | 11 | 28852 | 41 | |||
| 27261 | 22398 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 5755X 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 5 | 3X3 | 6013951.2697336 | 2092275.7830743 | 37.7257755649285 | -122.393942861008 | (37.7257755649285, -122.393942861008) | 10 | 3 | 8 | 58 | 1 | |||
| 30006 | 9774 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 05/26/1992 12:00:00 AM | 34 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.7814929008439 | -122.42399680549 | (37.7814929008439, -122.42399680549) | 7 | 9 | 11 | 28852 | 41 | ||
| 30529 | 22400 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 5755X 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 5 | 4X4 | 6013951.2697336 | 2092275.7830743 | 37.7257755649285 | -122.393942861008 | (37.7257755649285, -122.393942861008) | 10 | 3 | 8 | 58 | 1 | |||
| 30841 | 87987 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300x Jones St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 04/23/2015 03:33:00 PM | 3 | 3x3 | Permit Number 51027 | 6008990.567 | 2113714.34992 | 37.7843640908799 | -122.412606542572 | (37.7843640908799, -122.412606542572) | 14 | 10 | 9 | 28852 | 36 | |
| 32890 | 9796 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/08/2006 12:00:00 AM | 3X3 | 6005630.9126204 | 2113075.2727517 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | 7 | 9 | 11 | 28852 | 41 | |||
| 41503 | 22401 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 5755X 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 5 | 3X3 | 6013951.2697336 | 2092275.7830743 | 37.7257755649285 | -122.393942861008 | (37.7257755649285, -122.393942861008) | 10 | 3 | 8 | 58 | 1 | |||
| 47663 | 9776 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 30 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.7814929008439 | -122.42399680549 | (37.7814929008439, -122.42399680549) | 7 | 9 | 11 | 28852 | 41 | |||
| 62906 | 20507 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1211X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 60 | 5984783.6901595 | 2107169.3790132 | 37.7650051676015 | -122.495869700491 | (37.7650051676015, -122.495869700491) | 11 | 6 | 2 | 55 | 8 | |||
| 64609 | 26148 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1500 Oakdale Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3x3 | 6015586.3934773 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | 10 | 3 | 8 | 58 | 1 | |||
| 78052 | 26146 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1500 Oakdale Ave | 16 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3x3 | 6015586.3934773 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | 10 | 3 | 8 | 58 | 1 | |||
| 94516 | 9794 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 26 | 3x3 | 6005630.9126204 | 2113075.2727517 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | 7 | 9 | 11 | 28852 | 41 | |||
| 98926 | 26147 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1500 Oakdale Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3x3 | 6015586.3934773 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | 10 | 3 | 8 | 58 | 1 | |||
| 111440 | 20508 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1211X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 60 | 5984783.6901595 | 2107169.3790132 | 37.7650051676015 | -122.495869700491 | (37.7650051676015, -122.495869700491) | 11 | 6 | 2 | 55 | 8 | |||
| 111531 | 9800 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 11 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6005630.9126204 | 2113075.2727517 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | 7 | 9 | 11 | 28852 | 41 | ||
| 115788 | 9782 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 02/25/1997 12:00:00 AM | 12 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.7814929008439 | -122.42399680549 | (37.7814929008439, -122.42399680549) | 7 | 9 | 11 | 28852 | 41 | ||
| 119557 | 26145 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1500 Oakdale Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3x3 | 6015586.3934773 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | 10 | 3 | 8 | 58 | 1 | |||
| 125043 | 9775 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 40 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.7814929008439 | -122.42399680549 | (37.7814929008439, -122.42399680549) | 7 | 9 | 11 | 28852 | 41 | |||
| 125985 | 101312 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 4244X 19th St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 4x4 | 6001912 | 2104709 | 37.7592378221466 | -122.436451128899 | (37.7592378221466, -122.436451128899) | 2 | 4 | 5 | 28862 | 3 | |||
| 126295 | 22399 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 5755X 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 5 | 3X3 | 6013951.2697336 | 2092275.7830743 | 37.7257755649285 | -122.393942861008 | (37.7257755649285, -122.393942861008) | 10 | 3 | 8 | 58 | 1 | |||
| 128881 | 9778 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 30 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.7814929008439 | -122.42399680549 | (37.7814929008439, -122.42399680549) | 7 | 9 | 11 | 28852 | 41 | |||
| 130141 | 6291 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1700X Ellis St | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/04/2008 12:00:00 AM | 3 | 4x4 | 6002728.2699376 | 2113059.4201816 | 37.7822123689276 | -122.434225051326 | (37.7822123689276, -122.434225051326) | 15 | 9 | 11 | 29490 | 41 | ||
| 132578 | 9791 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3x3 | 6005630.9126204 | 2113075.2727517 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | 7 | 9 | 11 | 28852 | 41 | |||
| 139434 | 26150 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1500 Oakdale Ave | 20 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3x3 | 6015586.3934773 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | 10 | 3 | 8 | 58 | 1 | |||
| 139725 | 9793 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 40 | 3x3 | 6005630.9126204 | 2113075.2727517 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | 7 | 9 | 11 | 28852 | 41 | |||
| 144623 | 96617 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3555@ Valencia 19th St | 251 | Sidewalk: Property side : | Tree | Rec/Park 5 | Permit Number 771218 | 6006277 | 2104934 | 37.7601026853586 | -122.42137080656 | (37.7601026853586, -122.42137080656) | 2 | 4 | 7 | 28859 | 19 | ||||
| 147003 | 9799 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/30/2006 12:00:00 AM | 30 | 3x3 | 6005630.9126204 | 2113075.2727517 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | 7 | 9 | 11 | 28852 | 41 | ||
| 150401 | 9773 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 02/25/1997 12:00:00 AM | 18 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.7814929008439 | -122.42399680549 | (37.7814929008439, -122.42399680549) | 7 | 9 | 11 | 28852 | 41 | ||
| 151415 | 20509 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1211X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 60 | 5984783.6901595 | 2107169.3790132 | 37.7650051676015 | -122.495869700491 | (37.7650051676015, -122.495869700491) | 11 | 6 | 2 | 55 | 8 | |||
| 152187 | 9795 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 26 | 3x3 | 6005630.9126204 | 2113075.2727517 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | 7 | 9 | 11 | 28852 | 41 | |||
| 155714 | 83680 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300X Jones St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 04/23/2015 03:26:00 PM | 3 | 6008994.04445 | 2113694.03545 | 37.7843085073855 | -122.412593075226 | (37.7843085073855, -122.412593075226) | 14 | 10 | 9 | 28852 | 36 | |||
| 159184 | 9781 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 18 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.7814929008439 | -122.42399680549 | (37.7814929008439, -122.42399680549) | 7 | 9 | 11 | 28852 | 41 | |||
| 170957 | 96618 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3555@ 19th St 19th St | 268 | Sidewalk: Property side : | Tree | Rec/Park 5 | Permit Number 771218 | 6006277 | 2104934 | 37.7601026853586 | -122.42137080656 | (37.7601026853586, -122.42137080656) | 2 | 4 | 7 | 28859 | 19 | ||||
| 173276 | 9797 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/08/2006 12:00:00 AM | 3 | 3X3 | 6005630.9126204 | 2113075.2727517 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | 7 | 9 | 11 | 28852 | 41 |
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) );