trees
7,157 rows where qSpecies_id = 36 sorted by Location 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5801 | 68207 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2048 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1993 12:00:00 AM | 10 | Permit Number 31989 | 6009891.7858 | 2121179.0457 | 37.8049108661303 | -122.410015779346 | (37.8049108661303, -122.410015779346) | 3 | 1 | 10 | 308 | 23 | |
172592 | 143204 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1960 GRANT AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6010358.5927 | 2121168.7241 | 37.804908677608 | -122.408399607103 | (37.804908677608, -122.408399607103) | 3 | 1 | 10 | 308 | 23 | |||
98442 | 142544 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301 FRANCISCO ST | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 03/23/2016 02:55:00 PM | 26 | Width 0ft | 6009534.8661 | 2121184.7078 | 37.8049064021217 | -122.411251344133 | (37.8049064021217, -122.411251344133) | 3 | 1 | 10 | 308 | 23 | ||
97772 | 249771 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 102 Pfeiffer St | 2 | Side Yard : Yard | Tree | Private 2 | 9 | Width 0ft | 6010450.87532 | 2121165.29 | 37.8049044157696 | -122.408080009188 | (37.8049044157696, -122.408080009188) | 3 | 1 | 10 | 308 | 23 | |||
136364 | 249772 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 102 Pfeiffer St | 3 | Side Yard : Yard | Tree | Private 2 | 5 | Width 0ft | 6010438.89548 | 2121163.96639 | 37.8049001107042 | -122.408121373518 | (37.8049001107042, -122.408121373518) | 3 | 1 | 10 | 308 | 23 | |||
150688 | 110834 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3810 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6000148.86097 | 2121373.58259 | 37.8048941320222 | -122.443746114315 | (37.8048941320222, -122.443746114315) | 13 | 9 | 1 | 57 | 17 | |||
55266 | 142521 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301 FRANCISCO ST | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 05/04/2013 12:00:00 AM | 0 | Width 0ft | 6009485.2617 | 2121177.5361 | 37.8048839283261 | -122.411422499274 | (37.8048839283261, -122.411422499274) | 3 | 1 | 10 | 308 | 23 | ||
192800 | 249773 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 102 Pfeiffer St | 4 | Side Yard : Yard | Tree | Private 2 | 6 | Width 0ft | 6010432.56007 | 2121153.50484 | 37.8048710311487 | -122.408142559726 | (37.8048710311487, -122.408142559726) | 3 | 1 | 10 | 308 | 23 | |||
122724 | 143226 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1931 GRANT AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6010322.1986 | 2121149.6678 | 37.804854315613 | -122.408524208369 | (37.804854315613, -122.408524208369) | 3 | 1 | 10 | 308 | 23 | |||
122002 | 132738 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3733 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5999608.12652 | 2121369.28167 | 37.8048514663784 | -122.445617068392 | (37.8048514663784, -122.445617068392) | 13 | 9 | 1 | 57 | 17 | |||
167772 | 249779 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 119 Pfeiffer St | 3 | Back Yard : Yard | Tree | Private 2 | 8 | Width 0ft | 6010421.07006 | 2121139.10534 | 37.8048308503332 | -122.408181306135 | (37.8048308503332, -122.408181306135) | 3 | 1 | 10 | 308 | 23 | |||
106503 | 132766 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3700 Buchanan St | 10 | : | Tree | Private 2 | 17 | Width 4ft | 6003086.27955 | 2121288.88096 | 37.8048286658607 | -122.433574810742 | (37.8048286658607, -122.433574810742) | 13 | 9 | 1 | 57 | 17 | |||
66053 | 249778 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 119 Pfeiffer St | 4 | Back Yard : Yard | Tree | Private 2 | 10 | Width 0ft | 6010409.80858 | 2121137.78544 | 37.804826595643 | -122.408220184708 | (37.804826595643, -122.408220184708) | 3 | 1 | 10 | 308 | 23 | |||
70218 | 132758 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3749 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003031.35696 | 2121288.72022 | 37.8048251081519 | -122.433764864481 | (37.8048251081519, -122.433764864481) | 13 | 9 | 1 | 57 | 17 | |||
120001 | 249777 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 119 Pfeiffer St | 5 | Back Yard : Yard | Tree | Private 2 | 7 | Width 0ft | 6010400.42707 | 2121136.58311 | 37.8048227690275 | -122.40825256571 | (37.8048227690275, -122.40825256571) | 3 | 1 | 10 | 308 | 23 | |||
119114 | 66054 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 25 Rico Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1990 12:00:00 AM | 11 | Permit Number 29197 | 6001587.72578 | 2121314.5208 | 37.8048139268712 | -122.43876254188 | (37.8048139268712, -122.43876254188) | 13 | 9 | 1 | 57 | 17 | ||
144848 | 132739 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3733 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5999611.44383 | 2121352.30895 | 37.8048050532662 | -122.445604367256 | (37.8048050532662, -122.445604367256) | 13 | 9 | 1 | 57 | 17 | |||
67950 | 132522 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3800 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6000153.13784 | 2121337.01981 | 37.8047939844061 | -122.443728685448 | (37.8047939844061, -122.443728685448) | 13 | 9 | 1 | 57 | 17 | |||
110049 | 132759 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3749 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003033.65619 | 2121274.57925 | 37.8047864112348 | -122.433755896443 | (37.8047864112348, -122.433755896443) | 13 | 9 | 1 | 57 | 17 | |||
24810 | 98782 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3601X Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6003524.69819 | 2121256.99917 | 37.8047659921228 | -122.432055339588 | (37.8047659921228, -122.432055339588) | 13 | 9 | 1 | 28858 | 17 | |||
121727 | 132760 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3749 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003037.22114 | 2121261.32463 | 37.8047502198217 | -122.433742611654 | (37.8047502198217, -122.433742611654) | 13 | 9 | 1 | 57 | 17 | |||
107813 | 110835 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1890 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6000231.18574 | 2121318.34492 | 37.8047471594158 | -122.443457251152 | (37.8047471594158, -122.443457251152) | 13 | 9 | 1 | 57 | 17 | |||
159591 | 132765 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3700 Buchanan St | 9 | : | Tree | Private 2 | 7 | Width 4ft | 6003091.99833 | 2121255.71658 | 37.8047379296645 | -122.433552648755 | (37.8047379296645, -122.433552648755) | 13 | 9 | 1 | 57 | 17 | |||
51242 | 110836 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1890 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6000204.7386 | 2121313.59603 | 37.8047326119758 | -122.443548432539 | (37.8047326119758, -122.443548432539) | 13 | 9 | 1 | 57 | 17 | |||
102710 | 110837 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1890 Jefferson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6000182.65415 | 2121311.53208 | 37.8047256854064 | -122.443624709408 | (37.8047256854064, -122.443624709408) | 13 | 9 | 1 | 57 | 17 | |||
93686 | 132740 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3751 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6000600.96692 | 2121301.27056 | 37.8047213587755 | -122.442176362963 | (37.8047213587755, -122.442176362963) | 13 | 9 | 1 | 57 | 17 | |||
132663 | 132761 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3749 Buchanan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 1ft | 6003037.73932 | 2121248.03209 | 37.8047137514062 | -122.433739867809 | (37.8047137514062, -122.433739867809) | 13 | 9 | 1 | 57 | 17 | |||
27955 | 98783 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3601X Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6003517.50088 | 2121237.52457 | 37.80471211193 | -122.432078855049 | (37.80471211193, -122.432078855049) | 13 | 9 | 1 | 57 | 17 | |||
191247 | 142717 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1150 COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6008054.1886 | 2121138.8091 | 37.8046972234707 | -122.41637215184 | (37.8046972234707, -122.41637215184) | 5 | 1 | 10 | 308 | 23 | |||
100486 | 4737 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1120 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3X3 | 6008092.82938 | 2121137.35417 | 37.804695401428 | -122.416238328085 | (37.804695401428, -122.416238328085) | 5 | 1 | 10 | 308 | 23 | |||
145521 | 4739 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1120 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/29/1992 12:00:00 AM | 8 | 3X3 | 6008092.82938 | 2121137.35417 | 37.804695401428 | -122.416238328085 | (37.804695401428, -122.416238328085) | 5 | 1 | 10 | 308 | 23 | ||
165782 | 98784 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3601X Laguna St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6003528.38693 | 2121221.7367 | 37.8046693797454 | -122.43204005471 | (37.8046693797454, -122.43204005471) | 13 | 9 | 1 | 57 | 17 | |||
124851 | 98773 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1500X North Point St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6003452.6 | 2121222.8 | 37.8046680023994 | -122.432302398634 | (37.8046680023994, -122.432302398634) | 13 | 9 | 1 | 57 | 17 | ||||
817 | 132762 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3749 Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003038.53227 | 2121230.80772 | 37.8046665028104 | -122.43373589191 | (37.8046665028104, -122.43373589191) | 13 | 9 | 1 | 57 | 17 | |||
128934 | 66141 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1873 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/1990 12:00:00 AM | 8 | Permit Number 29204 | 6000289.95407 | 2121281.29897 | 37.8046487924648 | -122.443251215576 | (37.8046487924648, -122.443251215576) | 13 | 9 | 1 | 57 | 17 | ||
132123 | 97164 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 158 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6x3 | Permit Number 768038 | 6001191.42375 | 2121259.29018 | 37.8046397245941 | -122.440130020405 | (37.8046397245941, -122.440130020405) | 13 | 9 | 1 | 57 | 17 | ||
139149 | 65527 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3741 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/1990 12:00:00 AM | 7 | Permit Number 28425 | 6003040.03045 | 2121216.48482 | 37.8046272609043 | -122.433729683003 | (37.8046272609043, -122.433729683003) | 13 | 9 | 1 | 57 | 17 | ||
174427 | 132741 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3751 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000605.34257 | 2121264.24104 | 37.8046199350108 | -122.442158560891 | (37.8046199350108, -122.442158560891) | 13 | 9 | 1 | 57 | 17 | |||
167327 | 98785 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3601X Laguna St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6003521.84096 | 2121200.89529 | 37.8046117835793 | -122.432061218465 | (37.8046117835793, -122.432061218465) | 13 | 9 | 1 | 57 | 17 | |||
120461 | 142715 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1150 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6008089.7742 | 2121106.9415 | 37.8046117241212 | -122.416246745544 | (37.8046117241212, -122.416246745544) | 5 | 1 | 10 | 308 | 23 | |||
78437 | 55223 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3625 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/07/1972 12:00:00 AM | 10 | Permit Number 11141 | 5999129.45992 | 2121290.85934 | 37.8046088005251 | -122.447267890916 | (37.8046088005251, -122.447267890916) | 13 | 9 | 1 | 57 | 17 | ||
80428 | 67461 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1913 Grant Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/1992 12:00:00 AM | 9 | Permit Number 30972 | 6010350.2843 | 2121059.4182 | 37.8046080854206 | -122.408420644539 | (37.8046080854206, -122.408420644539) | 3 | 1 | 10 | 308 | 23 | ||
52051 | 100288 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 3755X Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6003046.2 | 2121203.4 | 37.804591683504 | -122.433707396943 | (37.804591683504, -122.433707396943) | 13 | 9 | 1 | 57 | 17 | |||
73467 | 100290 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 3755X Buchanan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6003046.2 | 2121203.4 | 37.804591683504 | -122.433707396943 | (37.804591683504, -122.433707396943) | 13 | 9 | 1 | 57 | 17 | |||
92764 | 100287 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 3755X Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6003046.2 | 2121203.4 | 37.804591683504 | -122.433707396943 | (37.804591683504, -122.433707396943) | 13 | 9 | 1 | 57 | 17 | |||
108094 | 100289 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 3755X Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6003046.2 | 2121203.4 | 37.804591683504 | -122.433707396943 | (37.804591683504, -122.433707396943) | 13 | 9 | 1 | 57 | 17 | |||
159235 | 100291 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 3755X Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6003046.2 | 2121203.4 | 37.804591683504 | -122.433707396943 | (37.804591683504, -122.433707396943) | 13 | 9 | 1 | 57 | 17 | |||
121500 | 98779 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 3700X Buchanan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003247.3 | 2121194.2 | 37.8045778314901 | -122.433010814251 | (37.8045778314901, -122.433010814251) | 13 | 9 | 1 | 57 | 17 | ||||
85565 | 98786 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3601X Laguna St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6003533.09447 | 2121186.45287 | 37.8045727664737 | -122.432021242695 | (37.8045727664737, -122.432021242695) | 13 | 9 | 1 | 57 | 17 | |||
92277 | 100973 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 450X Chestnut St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 0 | Permit Number 37341 | 6009614 | 2121059.9 | 37.8045681487804 | -122.410968670823 | (37.8045681487804, -122.410968670823) | 3 | 1 | 10 | 308 | 23 | ||
75351 | 132543 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 51 Prado St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000738.025 | 2121236.40419 | 37.8045510631517 | -122.441697402908 | (37.8045510631517, -122.441697402908) | 13 | 9 | 1 | 57 | 17 | |||
118925 | 132542 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 51 Prado St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000719.09431 | 2121234.21114 | 37.8045439630017 | -122.441762756646 | (37.8045439630017, -122.441762756646) | 13 | 9 | 1 | 57 | 17 | |||
174683 | 132541 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 51 Prado St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000698.95451 | 2121230.63283 | 37.8045329903671 | -122.441832195112 | (37.8045329903671, -122.441832195112) | 13 | 9 | 1 | 57 | 17 | |||
155393 | 132540 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 51 Prado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000678.86835 | 2121229.63931 | 37.8045291178891 | -122.441901633567 | (37.8045291178891, -122.441901633567) | 13 | 9 | 1 | 57 | 17 | |||
68344 | 98787 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3601X Laguna St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6003526.90224 | 2121166.28084 | 37.8045170283068 | -122.432041230117 | (37.8045170283068, -122.432041230117) | 13 | 9 | 1 | 57 | 17 | |||
27927 | 132763 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3735 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003047.69207 | 2121172.45725 | 37.8045068075103 | -122.433700020641 | (37.8045068075103, -122.433700020641) | 13 | 9 | 1 | 57 | 17 | |||
144797 | 143229 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 262 CHESTNUT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6010526.9978 | 2121016.5666 | 37.8045003199195 | -122.407806084267 | (37.8045003199195, -122.407806084267) | 3 | 1 | 10 | 308 | 23 | |||
170071 | 66121 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 341 Avila St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1990 12:00:00 AM | 10 | Permit Number 29183 | 6000875.659 | 2121214.03728 | 37.8044974905357 | -122.441219503176 | (37.8044974905357, -122.441219503176) | 13 | 9 | 1 | 57 | 17 | ||
191852 | 143230 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 268 CHESTNUT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6010512.5066 | 2121014.371 | 37.8044934800863 | -122.407856077689 | (37.8044934800863, -122.407856077689) | 3 | 1 | 10 | 308 | 23 | |||
142494 | 30473 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 274 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/1956 12:00:00 AM | 15 | Permit Number 120 | 6010471.2287 | 2121008.6623 | 37.8044754944375 | -122.407998521413 | (37.8044754944375, -122.407998521413) | 3 | 1 | 10 | 308 | 23 | ||
11570 | 66036 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3737 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1990 12:00:00 AM | 7 | Permit Number 29073 | 6000613.44807 | 2121211.22675 | 37.8044748339084 | -122.442126703295 | (37.8044748339084, -122.442126703295) | 13 | 9 | 1 | 57 | 17 | ||
352 | 98788 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3601X Laguna St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6003538.80686 | 2121150.47161 | 37.804474295204 | -122.431998903525 | (37.804474295204, -122.431998903525) | 13 | 9 | 1 | 57 | 17 | |||
59893 | 132764 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3735 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003049.36463 | 2121156.9395 | 37.8044642947518 | -122.433693122861 | (37.8044642947518, -122.433693122861) | 13 | 9 | 1 | 57 | 17 | |||
120307 | 30451 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 298 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1956 12:00:00 AM | 11 | Permit Number 100 | 6010449.7115 | 2121003.8319 | 37.8044610266311 | -122.408072643082 | (37.8044610266311, -122.408072643082) | 3 | 1 | 10 | 308 | 23 | ||
92177 | 142955 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 298 CHESTNUT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6010436.9768 | 2121000.7581 | 37.8044518737137 | -122.408116495929 | (37.8044518737137, -122.408116495929) | 3 | 1 | 10 | 308 | 23 | |||
133215 | 142956 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 298 CHESTNUT ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6010420.7291 | 2120999.4407 | 37.8044473467174 | -122.408172629815 | (37.8044473467174, -122.408172629815) | 3 | 1 | 10 | 308 | 23 | |||
92045 | 142957 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 298 CHESTNUT ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6010404.0423 | 2120997.245 | 37.8044403835129 | -122.408230221262 | (37.8044403835129, -122.408230221262) | 3 | 1 | 10 | 308 | 23 | |||
95762 | 65536 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3750 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1990 12:00:00 AM | 7 | Permit Number 29012 | 6000660.38848 | 2121196.27662 | 37.804436459834 | -122.44196318856 | (37.804436459834, -122.44196318856) | 13 | 9 | 1 | 57 | 17 | |
150250 | 110301 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3727 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775502 | 6003051.71719 | 2121145.37774 | 37.8044326826855 | -122.4336841548 | (37.8044326826855, -122.4336841548) | 13 | 9 | 1 | 57 | 17 | |
86790 | 133076 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 929 Bay St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6006356.93871 | 2121072.04496 | 37.8044183178065 | -122.422240916685 | (37.8044183178065, -122.422240916685) | 5 | 1 | 1 | 28858 | 32 | |||
50188 | 132742 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3737 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000616.2484 | 2121189.59851 | 37.8044156081446 | -122.442115459069 | (37.8044156081446, -122.442115459069) | 13 | 9 | 1 | 57 | 17 | |||
137735 | 66049 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 333 Avila St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1990 12:00:00 AM | 10 | Permit Number 29182 | 6000880.15791 | 2121180.56294 | 37.8044058352172 | -122.441201531147 | (37.8044058352172, -122.441201531147) | 13 | 9 | 1 | 57 | 17 | ||
131186 | 110302 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3727 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6003053.67126 | 2121133.82421 | 37.804401070605 | -122.433676566343 | (37.804401070605, -122.433676566343) | 13 | 9 | 1 | 57 | 17 | |||
56126 | 132539 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1999 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5999735.73415 | 2121201.4853 | 37.8043980273161 | -122.445163399071 | (37.8043980273161, -122.445163399071) | 13 | 9 | 1 | 57 | 17 | |||
30378 | 110304 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 3735 BUCHANAN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002991 | 2121133 | 37.8043952513031 | -122.433893386438 | (37.8043952513031, -122.433893386438) | 13 | 9 | 1 | 57 | 17 | ||||
139972 | 110303 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 3735 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002991 | 2121133 | 37.8043952513031 | -122.433893386438 | (37.8043952513031, -122.433893386438) | 13 | 9 | 1 | 57 | 17 | ||||
22170 | 100293 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 3725 Buchanan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6003057 | 2121128 | 37.8043852677309 | -122.433664630457 | (37.8043852677309, -122.433664630457) | 13 | 9 | 1 | 57 | 17 | |||
105159 | 100295 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 3725 Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6003057 | 2121128 | 37.8043852677309 | -122.433664630457 | (37.8043852677309, -122.433664630457) | 13 | 9 | 1 | 57 | 17 | |||
19887 | 30431 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 255 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1956 12:00:00 AM | 9 | Permit Number 84 | 6010587.196 | 2120972.0532 | 37.8043814669615 | -122.407594621587 | (37.8043814669615, -122.407594621587) | 3 | 1 | 10 | 308 | 23 | ||
113944 | 30465 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 263 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1956 12:00:00 AM | 7 | Permit Number 114 | 6010570.0583 | 2120972.0532 | 37.8043805076484 | -122.407653928331 | (37.8043805076484, -122.407653928331) | 3 | 1 | 10 | 308 | 23 | ||
156986 | 30466 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 263 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1956 12:00:00 AM | 11 | Permit Number 114 | 6010554.7058 | 2120969.554 | 37.8043727860541 | -122.407706880882 | (37.8043727860541, -122.407706880882) | 3 | 1 | 10 | 308 | 23 | ||
23511 | 132749 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2068 Jefferson St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 5999296.53972 | 2121195.84078 | 37.8043574507926 | -122.446682856733 | (37.8043574507926, -122.446682856733) | 13 | 9 | 1 | 57 | 17 | |||
141306 | 30452 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 273 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1956 12:00:00 AM | 11 | Permit Number 101 | 6010525.072 | 2120964.5555 | 37.8043574024879 | -122.40780907895 | (37.8043574024879, -122.40780907895) | 3 | 1 | 10 | 308 | 23 | ||
27406 | 44181 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3731 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2000 12:00:00 AM | 8 | Permit Number 43642 | 6000618.49035 | 2121167.17319 | 37.8043541619898 | -122.442106089925 | (37.8043541619898, -122.442106089925) | 13 | 9 | 1 | 57 | 17 | ||
70422 | 65642 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 324 Avila St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/22/1990 12:00:00 AM | 9 | Permit Number 28555 | 6000917.13129 | 2121158.05026 | 37.8043461274204 | -122.441071965805 | (37.8043461274204, -122.441071965805) | 13 | 9 | 1 | 57 | 17 | ||
148731 | 65863 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3738 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/1990 12:00:00 AM | 2 | Permit Number 28855 | 6000664.77895 | 2121157.36382 | 37.8043298658938 | -122.441945200307 | (37.8043298658938, -122.441945200307) | 13 | 9 | 1 | 57 | 17 | |
181051 | 100303 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3727 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/2012 12:00:00 AM | 1 | 3x3 | Permit Number 769497 | 6003057.09868 | 2121106.75706 | 37.804326945799 | -122.43366276982 | (37.804326945799, -122.43366276982) | 13 | 9 | 1 | 57 | 17 | |
159642 | 132538 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2015 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5999553.84029 | 2121177.76729 | 37.8043225202228 | -122.445791149248 | (37.8043225202228, -122.445791149248) | 13 | 9 | 1 | 57 | 17 | |||
151919 | 132757 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3601 Laguna St | 10 | : | Tree | Private 2 | 8 | Width 4ft | 6003537.25934 | 2121091.97197 | 37.8043135827752 | -122.432000078959 | (37.8043135827752, -122.432000078959) | 13 | 9 | 1 | 57 | 17 | |||
47465 | 132537 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2015 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5999535.53321 | 2121174.61585 | 37.8043128219315 | -122.445854275378 | (37.8043128219315, -122.445854275378) | 13 | 9 | 1 | 57 | 17 | |||
105008 | 98776 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1500X North Point St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 14 | 3x3 | 6003515.54038 | 2121088.88501 | 37.8043038754771 | -122.43207501857 | (37.8043038754771, -122.43207501857) | 13 | 9 | 1 | 57 | 17 | |||
61844 | 98775 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1500X North Point St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 9 | 3x3 | 6003497.24376 | 2121086.80663 | 37.8042971314615 | -122.432138186954 | (37.8042971314615, -122.432138186954) | 13 | 9 | 1 | 57 | 17 | |||
59066 | 98774 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1500X North Point St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 13 | 3x3 | 6003476.9646 | 2121084.27758 | 37.8042890375842 | -122.432208183857 | (37.8042890375842, -122.432208183857) | 13 | 9 | 1 | 57 | 17 | |||
70734 | 100297 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 3725 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6003062 | 2121090 | 37.8042812134182 | -122.43364461008 | (37.8042812134182, -122.43364461008) | 13 | 9 | 1 | 57 | 17 | |||
92515 | 100299 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 3725 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6003062 | 2121090 | 37.8042812134182 | -122.43364461008 | (37.8042812134182, -122.43364461008) | 13 | 9 | 1 | 57 | 17 | |||
140422 | 132747 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2100 Jefferson St | 1 | Front Yard : Yard | Tree | Private 2 | 25 | 5999125.84165 | 2121169.76474 | 37.8042761008346 | -122.447271691431 | (37.8042761008346, -122.447271691431) | 13 | 9 | 1 | 57 | 17 | ||||
186125 | 98780 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 3601X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003551.8 | 2121073.9 | 37.8042647862028 | -122.431948468614 | (37.8042647862028, -122.431948468614) | 13 | 9 | 1 | 57 | 17 | ||||
10596 | 98772 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1500X North Point St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10 | 3x3 | 6003427.71574 | 2121076.45183 | 37.804264757687 | -122.432378054112 | (37.804264757687, -122.432378054112) | 13 | 9 | 1 | 57 | 17 | |||
109366 | 98771 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1500X North Point St | 6 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10 | 3x3 | 6003408.14062 | 2121072.18905 | 37.8042519432217 | -122.432445490669 | (37.8042519432217, -122.432445490669) | 13 | 9 | 1 | 57 | 17 | |||
133932 | 132748 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2100 Jefferson St | 5 | Front Yard : Yard | Tree | Private 2 | 35 | 5999067.6485 | 2121161.91588 | 37.8042512246639 | -122.447472507359 | (37.8042512246639, -122.447472507359) | 13 | 9 | 1 | 57 | 17 |
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) );