trees
7,157 rows where qSpecies_id = 36 sorted by XCoord 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31799 | 11399 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1462 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6016280.69423 | 2096695.13026 | 37.7380393961916 | -122.386198097279 | (37.7380393961916, -122.386198097279) | 10 | 3 | 8 | 58 | 1 | |||
43429 | 2537 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1575 Burke Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/03/2016 12:00:00 AM | 6 | 3X3 | 6016279.43485 | 2099056.14622 | 37.7445221951468 | -122.386367018739 | (37.7445221951468, -122.386367018739) | 10 | 3 | 8 | 58 | 1 | ||
129748 | 195015 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1427x Innes Ave | 14 | Median : Yard | Tree | DPW 1 | 5 | 6016257.18354 | 2096668.39459 | 37.737964684134 | -122.386277522713 | (37.737964684134, -122.386277522713) | 10 | 3 | 8 | 58 | 1 | ||||
26747 | 194877 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 411 China Basin St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6016229.27559 | 2109093.14578 | 37.7720788903636 | -122.387240442995 | (37.7720788903636, -122.387240442995) | 14 | 3 | 9 | 310 | 20 | |||
112543 | 194876 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 411 China Basin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6016202.88987 | 2109091.6784 | 37.7720734000081 | -122.387331611766 | (37.7720734000081, -122.387331611766) | 14 | 3 | 9 | 310 | 20 | |||
22063 | 93539 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 325 China Basin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2010 12:00:00 AM | 3x3 | Permit Number 53240 | 6016190.6 | 2109941.9 | 37.774407241214 | -122.387433446454 | (37.774407241214, -122.387433446454) | 14 | 3 | 9 | 310 | 20 | ||
63825 | 93544 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 325 China Basin St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2010 12:00:00 AM | 3x3 | Permit Number 53240 | 6016190.6 | 2109941.9 | 37.774407241214 | -122.387433446454 | (37.774407241214, -122.387433446454) | 14 | 3 | 9 | 310 | 20 | ||
92378 | 93540 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 325 China Basin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2010 12:00:00 AM | 3x3 | Permit Number 53240 | 6016190.6 | 2109941.9 | 37.774407241214 | -122.387433446454 | (37.774407241214, -122.387433446454) | 14 | 3 | 9 | 310 | 20 | ||
100882 | 93542 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 325 China Basin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2010 12:00:00 AM | 3x3 | Permit Number 53240 | 6016190.6 | 2109941.9 | 37.774407241214 | -122.387433446454 | (37.774407241214, -122.387433446454) | 14 | 3 | 9 | 310 | 20 | ||
141658 | 93543 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 325 China Basin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2010 12:00:00 AM | 3x3 | Permit Number 53240 | 6016190.6 | 2109941.9 | 37.774407241214 | -122.387433446454 | (37.774407241214, -122.387433446454) | 14 | 3 | 9 | 310 | 20 | ||
188490 | 93541 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 325 China Basin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2010 12:00:00 AM | 3x3 | Permit Number 53240 | 6016190.6 | 2109941.9 | 37.774407241214 | -122.387433446454 | (37.774407241214, -122.387433446454) | 14 | 3 | 9 | 310 | 20 | ||
125004 | 194747 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1580 Burke Ave | 2 | : | Tree | Private 2 | 3 | Width 4ft | 6016181.61808 | 2099214.241 | 37.7449508758992 | -122.386716274933 | (37.7449508758992, -122.386716274933) | 10 | 3 | 8 | 58 | 1 | |||
167154 | 194875 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 411 China Basin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6016177.98947 | 2109089.18113 | 37.7720651639932 | -122.387417570779 | (37.7720651639932, -122.387417570779) | 14 | 3 | 9 | 310 | 20 | |||
29525 | 74025 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 409 Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6016159.9 | 2106964.2 | 37.766229426257 | -122.387331885576 | (37.766229426257, -122.387331885576) | 14 | 3 | 9 | 310 | 20 | ||
51279 | 116420 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 409 Illinois St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 6016159.9 | 2106964.2 | 37.766229426257 | -122.387331885576 | (37.766229426257, -122.387331885576) | 14 | 3 | 9 | 310 | 20 | ||||
96304 | 72481 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 409 Illinois St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6016159.9 | 2106964.2 | 37.766229426257 | -122.387331885576 | (37.766229426257, -122.387331885576) | 14 | 3 | 9 | 310 | 20 | ||
160187 | 72482 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 409 Illinois St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6016159.9 | 2106964.2 | 37.766229426257 | -122.387331885576 | (37.766229426257, -122.387331885576) | 14 | 3 | 9 | 310 | 20 | ||
125820 | 11412 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1482 Innes Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X4 | 6016154.87706 | 2096787.24136 | 37.7382853499827 | -122.386639534879 | (37.7382853499827, -122.386639534879) | 10 | 3 | 8 | 58 | 1 | |||
146852 | 194874 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 411 China Basin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6016148.88439 | 2109089.76822 | 37.772065164008 | -122.387518289441 | (37.772065164008, -122.387518289441) | 14 | 3 | 9 | 310 | 20 | |||
53264 | 194878 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 414 China Basin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6016145.01396 | 2109134.45243 | 37.772187642686 | -122.387534795613 | (37.772187642686, -122.387534795613) | 14 | 3 | 9 | 310 | 20 | |||
26809 | 194873 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 411 China Basin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6016122.98032 | 2109087.29125 | 37.7720569280033 | -122.387607721645 | (37.7720569280033, -122.387607721645) | 14 | 3 | 9 | 310 | 20 | |||
187298 | 194872 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 411 China Basin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6016098.84287 | 2109085.27848 | 37.7720500643794 | -122.38769107529 | (37.7720500643794, -122.38769107529) | 14 | 3 | 9 | 310 | 20 | |||
30648 | 195014 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1409 Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6016094.42849 | 2094603.13506 | 37.732284887124 | -122.386696274914 | (37.732284887124, -122.386696274914) | 10 | 3 | 8 | 58 | 1 | |||
129194 | 194857 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 13 Bridgeview Way | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 6016092.3761 | 2108385.26667 | 37.7701276268135 | -122.387664596547 | (37.7701276268135, -122.387664596547) | 14 | 3 | 9 | 310 | 20 | |||
101439 | 26130 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1407 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6016047.647 | 2094692.1402 | 37.7325266873331 | -122.38686421566 | (37.7325266873331, -122.38686421566) | 10 | 3 | 8 | 58 | 1 | |||
15178 | 26129 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1411 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016032.5768 | 2094704.0708 | 37.7325586119483 | -122.386917149192 | (37.7325586119483, -122.386917149192) | 10 | 3 | 8 | 58 | 1 | |||
97259 | 194748 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3450 03rd St | 6 | : | Tree | Private 2 | 16 | Width 3ft | 6016023.22407 | 2099430.69434 | 37.7455364415514 | -122.387279073371 | (37.7455364415514, -122.387279073371) | 10 | 3 | 8 | 58 | 1 | |||
61953 | 22093 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 3400X 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 3 | 3X3 | 6016015.95987 | 2099423.81611 | 37.745517153054 | -122.387303712363 | (37.745517153054, -122.387303712363) | 10 | 3 | 8 | 58 | 1 | |||
66596 | 194871 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 409 China Basin St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015990.53014 | 2109078.96537 | 37.7720267296814 | -122.388065300271 | (37.7720267296814, -122.388065300271) | 14 | 3 | 9 | 310 | 20 | |||
50806 | 200705 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1462 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6015971.3542 | 2095172.8163 | 37.7338423029692 | -122.387161496165 | (37.7338423029692, -122.387161496165) | 10 | 3 | 8 | 58 | 1 | |||
156794 | 194870 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 409 China Basin St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015967.91832 | 2109077.92188 | 37.7720226116927 | -122.388143444175 | (37.7720226116927, -122.388143444175) | 14 | 3 | 9 | 310 | 20 | |||
90227 | 194869 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 409 China Basin St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015941.01057 | 2109075.46534 | 37.7720143756979 | -122.388236349523 | (37.7720143756979, -122.388236349523) | 14 | 3 | 9 | 310 | 20 | |||
11527 | 50695 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Harrison St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2004 12:00:00 AM | 4 | Permit Number 47259 | 6015937.15224 | 2115364.30383 | 37.7892819048945 | -122.388688779581 | (37.7892819048945, -122.388688779581) | 6 | 2 | 9 | 28855 | 6 | |
165052 | 194803 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 503 Beale St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 6ft | 6015935.90952 | 2113992.90584 | 37.785516288784 | -122.38859731131 | (37.785516288784, -122.38859731131) | 6 | 2 | 9 | 28856 | 6 | |||
50293 | 200703 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1470 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6015933.6787 | 2095201.0729 | 37.7339178034813 | -122.387293723271 | (37.7339178034813, -122.387293723271) | 10 | 3 | 8 | 58 | 1 | |||
192116 | 199878 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1408 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6015930.5512 | 2093462.2061 | 37.7291430496929 | -122.387183288185 | (37.7291430496929, -122.387183288185) | 10 | 3 | 8 | 58 | 1 | |||
10530 | 50696 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Harrison St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2004 12:00:00 AM | 4 | Permit Number 47259 | 6015925.73831 | 2115354.86226 | 37.7892553479159 | -122.388727611399 | (37.7892553479159, -122.388727611399) | 6 | 2 | 9 | 28855 | 6 | |
158851 | 194804 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 503 Beale St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 6ft | 6015924.34546 | 2114008.18628 | 37.7855576045419 | -122.388638386948 | (37.7855576045419, -122.388638386948) | 6 | 2 | 9 | 28856 | 6 | |||
21757 | 199887 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1501 Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6015922.2993 | 2094373.9993 | 37.7316461950184 | -122.387275392579 | (37.7316461950184, -122.387275392579) | 10 | 3 | 8 | 58 | 1 | |||
143630 | 194868 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 409 China Basin St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015915.65393 | 2109075.22699 | 37.7720123162411 | -122.388324044236 | (37.7720123162411, -122.388324044236) | 14 | 3 | 9 | 310 | 20 | |||
14640 | 50694 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Harrison St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2004 12:00:00 AM | 3 | Permit Number 47259 | 6015915.16555 | 2115344.32909 | 37.7892258402606 | -122.388763456582 | (37.7892258402606, -122.388763456582) | 6 | 2 | 9 | 28855 | 6 | |
4909 | 194805 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 503 Beale St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 6ft | 6015913.1436 | 2114020.02003 | 37.7855894765281 | -122.388677968825 | (37.7855894765281, -122.388677968825) | 6 | 2 | 9 | 28856 | 6 | |||
16266 | 60348 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1404 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 6 | Permit Number 19926 | 6015899.7652 | 2094527.3411 | 37.7320659929368 | -122.387363991073 | (37.7320659929368, -122.387363991073) | 10 | 3 | 8 | 58 | 1 | |
8322 | 50693 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Harrison St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2004 12:00:00 AM | 3 | Permit Number 47259 | 6015899.29772 | 2115328.09963 | 37.7891803984034 | -122.388817224359 | (37.7891803984034, -122.388817224359) | 6 | 2 | 9 | 28855 | 6 | |
92363 | 194806 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 503 Beale St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 6015898.48961 | 2114031.92346 | 37.785621348501 | -122.388729499078 | (37.785621348501, -122.388729499078) | 6 | 2 | 9 | 28856 | 6 | |||
48150 | 194867 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 409 China Basin St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015891.51619 | 2109073.21474 | 37.7720054535224 | -122.388407398805 | (37.7720054535224, -122.388407398805) | 14 | 3 | 9 | 310 | 20 | |||
11364 | 50692 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Harrison St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/2004 12:00:00 AM | 4 | 4x4 | Permit Number 47259 | 6015887.62882 | 2115316.72883 | 37.7891485300247 | -122.388856803509 | (37.7891485300247, -122.388856803509) | 6 | 2 | 9 | 28855 | 6 | |
67338 | 194807 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 503 Beale St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 6015887.13283 | 2114046.76968 | 37.7856614834305 | -122.388769827389 | (37.7856614834305, -122.388769827389) | 6 | 2 | 9 | 28856 | 6 | |||
31835 | 194825 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 502 Beale St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6015880.685 | 2113956.19903 | 37.785412439566 | -122.388785810138 | (37.785412439566, -122.388785810138) | 6 | 2 | 9 | 28856 | 6 | |||
12182 | 50691 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Harrison St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2004 12:00:00 AM | 5 | Permit Number 47259 | 6015877.9319 | 2115306.82257 | 37.7891207922267 | -122.388889662052 | (37.7891207922267, -122.388889662052) | 6 | 2 | 9 | 28855 | 6 | |
160393 | 194808 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 503 Beale St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 6ft | 6015874.86953 | 2114059.48463 | 37.7856957161173 | -122.388813143229 | (37.7856957161173, -122.388813143229) | 6 | 2 | 9 | 28856 | 6 | |||
83439 | 194824 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 502 Beale St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6015871.5156 | 2113965.50811 | 37.785437491981 | -122.388818183917 | (37.785437491981, -122.388818183917) | 6 | 2 | 9 | 28856 | 6 | |||
190570 | 194866 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 409 China Basin St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015868.42271 | 2109073.181 | 37.7720040811672 | -122.388487279274 | (37.7720040811672, -122.388487279274) | 14 | 3 | 9 | 310 | 20 | |||
15854 | 50686 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2004 12:00:00 AM | 5 | Permit Number 47259 | 6015866.59166 | 2115301.03346 | 37.7891042680871 | -122.388928493857 | (37.7891042680871, -122.388928493857) | 6 | 2 | 9 | 28855 | 6 | |
135631 | 194823 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 502 Beale St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 6ft | 6015860.26158 | 2113977.77101 | 37.7854705393653 | -122.388857976238 | (37.7854705393653, -122.388857976238) | 6 | 2 | 9 | 28856 | 6 | |||
52071 | 194809 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 503 Beale St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6015859.99532 | 2114071.17734 | 37.7857269972351 | -122.388865420803 | (37.7857269972351, -122.388865420803) | 6 | 2 | 9 | 28856 | 6 | |||
99608 | 194822 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 502 Beale St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 6ft | 6015848.99975 | 2113989.64596 | 37.7855025210802 | -122.38889776852 | (37.7855025210802, -122.38889776852) | 6 | 2 | 9 | 28856 | 6 | |||
60540 | 194810 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 503 Beale St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 6ft | 6015847.99108 | 2114086.03666 | 37.7857671321996 | -122.388907990207 | (37.7857671321996, -122.388907990207) | 6 | 2 | 9 | 28856 | 6 | |||
44581 | 15029 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 900 Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/23/2015 12:00:00 AM | 18 | 3X3 | 6015841.7954 | 2096558.94819 | 37.7376411655934 | -122.387706102953 | (37.7376411655934, -122.387706102953) | 10 | 3 | 8 | 58 | 1 | ||
33031 | 194821 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 502 Beale St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6015838.92258 | 2114002.27356 | 37.785536635052 | -122.388933514791 | (37.785536635052, -122.388933514791) | 6 | 2 | 9 | 28856 | 6 | |||
165227 | 194811 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 503 Beale St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 6ft | 6015836.63435 | 2114100.8829 | 37.7858072671247 | -122.388948318521 | (37.7858072671247, -122.388948318521) | 6 | 2 | 9 | 28856 | 6 | |||
2341 | 50690 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Harrison St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2004 12:00:00 AM | 5 | Permit Number 47259 | 6015829.14658 | 2115263.74647 | 37.7889998109335 | -122.389055445747 | (37.7889998109335, -122.389055445747) | 6 | 2 | 9 | 28855 | 6 | |
140195 | 194865 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 409 China Basin St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015826.7116 | 2109071.02334 | 37.7719958451713 | -122.38863141183 | (37.7719958451713, -122.38863141183) | 14 | 3 | 9 | 310 | 20 | |||
5350 | 50689 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2004 12:00:00 AM | 6 | Permit Number 47259 | 6015816.80871 | 2115251.31458 | 37.7889649918797 | -122.389097265149 | (37.7889649918797, -122.389097265149) | 6 | 2 | 9 | 28855 | 6 | |
136610 | 194812 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 503 Beale St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6015809.85045 | 2114121.4147 | 37.7858621581513 | -122.389042418166 | (37.7858621581513, -122.389042418166) | 6 | 2 | 9 | 28856 | 6 | |||
10738 | 50688 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2004 12:00:00 AM | 4 | Permit Number 47259 | 6015806.91345 | 2115242.27212 | 37.7889396148166 | -122.389130870094 | (37.7889396148166, -122.389130870094) | 6 | 2 | 9 | 28855 | 6 | |
123715 | 194820 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 502 Beale St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 6ft | 6015805.84171 | 2114034.19556 | 37.7856224519498 | -122.389050195514 | (37.7856224519498, -122.389050195514) | 6 | 2 | 9 | 28856 | 6 | |||
14807 | 194864 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 409 China Basin St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015802.5335 | 2109067.01209 | 37.7719834911837 | -122.38871476639 | (37.7719834911837, -122.38871476639) | 14 | 3 | 9 | 310 | 20 | |||
12585 | 50687 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2004 12:00:00 AM | 5 | Permit Number 47259 | 6015799.79693 | 2115231.88408 | 37.7889106971282 | -122.389154766877 | (37.7889106971282, -122.389154766877) | 6 | 2 | 9 | 28855 | 6 | |
91125 | 194847 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 649 Delancey St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6015799.34257 | 2113102.0592 | 37.78306265587 | -122.389007576633 | (37.78306265587, -122.389007576633) | 6 | 2 | 9 | 28856 | 6 | |||
17981 | 50697 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2004 12:00:00 AM | 5 | Permit Number 47259 | 6015787.30845 | 2115222.67912 | 37.7888847301024 | -122.389197332691 | (37.7888847301024, -122.389197332691) | 6 | 2 | 9 | 28855 | 6 | |
98402 | 194863 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 409 China Basin St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015775.69154 | 2109067.8038 | 37.7719841773656 | -122.388807670855 | (37.7719841773656, -122.388807670855) | 14 | 3 | 9 | 310 | 20 | |||
6779 | 60387 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1436 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 15 | Permit Number 19967 | 6015759.6141 | 2094635.0651 | 37.7323540184412 | -122.387856042206 | (37.7323540184412, -122.387856042206) | 10 | 3 | 8 | 58 | 1 | |
54801 | 194819 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 502 Beale St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6015759.00914 | 2114080.17835 | 37.7857461141309 | -122.389215436053 | (37.7857461141309, -122.389215436053) | 6 | 2 | 9 | 28856 | 6 | |||
76439 | 194846 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 650 Delancey St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6015752.06117 | 2113052.07865 | 37.7829227995854 | -122.38916766137 | (37.7829227995854, -122.38916766137) | 6 | 2 | 9 | 28856 | 6 | |||
80654 | 194862 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 409 China Basin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015745.56234 | 2109067.41204 | 37.771981431721 | -122.388911863596 | (37.771981431721, -122.388911863596) | 14 | 3 | 9 | 310 | 20 | |||
11162 | 194818 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 502 Beale St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 6ft | 6015745.50684 | 2114096.95158 | 37.785791421082 | -122.389263322262 | (37.785791421082, -122.389263322262) | 6 | 2 | 9 | 28856 | 6 | |||
164168 | 194817 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 502 Beale St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 6ft | 6015735.95562 | 2114106.65654 | 37.7858175391931 | -122.389297045023 | (37.7858175391931, -122.389297045023) | 6 | 2 | 9 | 28856 | 6 | |||
84336 | 194845 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 650 Delancey St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6015735.87001 | 2113070.1809 | 37.782971606706 | -122.389224940988 | (37.782971606706, -122.389224940988) | 6 | 2 | 9 | 28856 | 6 | |||
147903 | 194848 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 649 Delancey St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6015734.88679 | 2113167.75638 | 37.7832394724674 | -122.389235158202 | (37.7832394724674, -122.389235158202) | 6 | 2 | 9 | 28856 | 6 | |||
23296 | 194861 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 409 China Basin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015726.19209 | 2109065.3037 | 37.7719745690081 | -122.388978720114 | (37.7719745690081, -122.388978720114) | 14 | 3 | 9 | 310 | 20 | |||
137162 | 194849 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 649 Delancey St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6015724.28903 | 2113176.66757 | 37.7832633530665 | -122.389272444991 | (37.7832633530665, -122.389272444991) | 6 | 2 | 9 | 28856 | 6 | |||
29949 | 194816 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 502 Beale St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 6ft | 6015723.9379 | 2114119.71149 | 37.7858527188632 | -122.389339535303 | (37.7858527188632, -122.389339535303) | 6 | 2 | 9 | 28856 | 6 | |||
145285 | 194844 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 650 Delancey St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6015722.72472 | 2113085.38787 | 37.7830126328712 | -122.38927148089 | (37.7830126328712, -122.38927148089) | 6 | 2 | 9 | 28856 | 6 | |||
146318 | 194815 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 502 Beale St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 6ft | 6015713.04634 | 2114130.60822 | 37.7858820349716 | -122.389377978618 | (37.7858820349716, -122.389377978618) | 6 | 2 | 9 | 28856 | 6 | |||
114295 | 194850 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 649 Delancey St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6015710.69376 | 2113193.59629 | 37.783309081801 | -122.389320662137 | (37.783309081801, -122.389320662137) | 6 | 2 | 9 | 28856 | 6 | |||
41406 | 194860 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 409 China Basin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015703.58503 | 2109064.51023 | 37.7719711371777 | -122.389056864908 | (37.7719711371777, -122.389056864908) | 14 | 3 | 9 | 310 | 20 | |||
132944 | 200681 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1535 Newcomb Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6015701.3552 | 2095304.4928 | 37.7341889046426 | -122.388104158222 | (37.7341889046426, -122.388104158222) | 10 | 3 | 8 | 58 | 1 | |||
71109 | 194814 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 502 Beale St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 6ft | 6015698.88503 | 2114143.70647 | 37.7859172146572 | -122.389427888293 | (37.7859172146572, -122.389427888293) | 6 | 2 | 9 | 28856 | 6 | |||
152822 | 194851 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 649 Delancey St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6015697.22479 | 2113207.56159 | 37.7833466806351 | -122.389368235381 | (37.7833466806351, -122.389368235381) | 6 | 2 | 9 | 28856 | 6 | |||
31420 | 194852 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 649 Delancey St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6015686.66814 | 2113218.50724 | 37.7833761496389 | -122.389405522161 | (37.7833761496389, -122.389405522161) | 6 | 2 | 9 | 28856 | 6 | |||
101722 | 194813 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 502 Beale St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6015685.49931 | 2114156.59484 | 37.7859518610407 | -122.389475100001 | (37.7859518610407, -122.389475100001) | 6 | 2 | 9 | 28856 | 6 | |||
95074 | 194843 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 650 Delancey St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6015685.47074 | 2113123.75159 | 37.7831159056175 | -122.389403045422 | (37.7831159056175, -122.389403045422) | 6 | 2 | 9 | 28856 | 6 | |||
11546 | 60372 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1447 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 16 | Permit Number 19950 | 6015678.2715 | 2094616.9279 | 37.7322997108216 | -122.388135999617 | (37.7322997108216, -122.388135999617) | 10 | 3 | 8 | 58 | 1 | |
131712 | 194842 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 650 Delancey St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6015673.27674 | 2113134.81775 | 37.7831456147243 | -122.389446005136 | (37.7831456147243, -122.389446005136) | 6 | 2 | 9 | 28856 | 6 | |||
122351 | 194853 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 649 Delancey St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6015671.76147 | 2113234.90729 | 37.7834203540004 | -122.389458239501 | (37.7834203540004, -122.389458239501) | 6 | 2 | 9 | 28856 | 6 | |||
39678 | 194859 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 409 China Basin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015665.14575 | 2109062.78658 | 37.7719642735598 | -122.389189710044 | (37.7719642735598, -122.389189710044) | 14 | 3 | 9 | 310 | 20 | |||
58657 | 194854 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 649 Delancey St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6015659.2847 | 2113251.99818 | 37.7834665899554 | -122.389502598585 | (37.7834665899554, -122.389502598585) | 6 | 2 | 9 | 28856 | 6 | |||
84900 | 31873 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 650 Delancey St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1995 12:00:00 AM | 9 | Permit Number 35313 | 6015657.86651 | 2113153.16171 | 37.7831951286877 | -122.389500600267 | (37.7831951286877, -122.389500600267) | 6 | 2 | 9 | 28856 | 6 | ||
25914 | 75352 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 499 Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6015655 | 2107201 | 37.766851652402 | -122.389094788361 | (37.766851652402, -122.389094788361) | 14 | 3 | 9 | 310 | 29 |
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) );