trees
6,714 rows where qSpecies_id = 7 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
604 | 20034 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
1515 | 31846 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
3055 | 20039 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
3242 | 43297 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1501 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2000 12:00:00 AM | Permit Number 43066 | |||||||||||||
4991 | 20043 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
6396 | 36746 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 5555 Woodward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39516 | |||||||||||||
7114 | 20035 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
7286 | 33084 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37336 | ||||||||||||||
7976 | 20040 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | ST | |||||||||||||
9521 | 35167 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 240 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1998 12:00:00 AM | Permit Number 38700 | |||||||||||||
9968 | 31847 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
14278 | 31848 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
14721 | 20044 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
18188 | 33083 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37336 | ||||||||||||||
18800 | 20042 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
19322 | 46857 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2002 12:00:00 AM | Permit Number 44926 | ||||||||||||||
1627 | 35149 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 11 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/1998 12:00:00 AM | Permit Number 38681 | 6004664.75137838 | 2109286.2995173 | 37.7719620248453 | -122.427256837171 | (37.7719620248453, -122.427256837171) | 7 | 9 | 11 | 28852 | 10 | ||
12052 | 32168 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 400 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | 6 | Permit Number 35510 | 6004141.09622 | 2110159.63618 | 37.7743303655916 | -122.429130480813 | (37.7743303655916, -122.429130480813) | 7 | 9 | 11 | 28852 | 10 | |
12301 | 81771 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 118 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2007 12:00:00 AM | 7 | 3x3 | Permit Number 50018 | 6009093.57763 | 2112998.11082 | 37.7824032504549 | -122.41219952199 | (37.7824032504549, -122.41219952199) | 14 | 10 | 9 | 28852 | 36 | |
14653 | 47070 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 610 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/2002 12:00:00 AM | 7 | Permit Number 45053 | 6004032.90703 | 2110923.42535 | 37.7764214179404 | -122.429559210103 | (37.7764214179404, -122.429559210103) | 7 | 9 | 11 | 28852 | 10 | |
15408 | 138826 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 640 IVY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004239.9171 | 2111001.0303 | 37.7766462209107 | -122.428848637655 | (37.7766462209107, -122.428848637655) | 7 | 9 | 11 | 28852 | 10 | |||
16259 | 48679 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 581 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2002 12:00:00 AM | 2 | Permit Number 45960 | 6005059.5328 | 2110905.0392 | 37.7764290087682 | -122.426006510169 | (37.7764290087682, -122.426006510169) | 7 | 9 | 11 | 28852 | 10 | ||
17953 | 30574 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 170 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1995 12:00:00 AM | 6 | Permit Number 34551 | 6004467.68034 | 2108789.06417 | 37.7705855903724 | -122.427903083363 | (37.7705855903724, -122.427903083363) | 7 | 9 | 11 | 28852 | 10 | |
20215 | 33650 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 228 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37741 | 6006293.44854624 | 2110954.16637531 | 37.7766335593155 | -122.421741530175 | (37.7766335593155, -122.421741530175) | 7 | 9 | 11 | 28852 | 10 | |||
22377 | 235701 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 530 Hickory St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 2ft | 6004254.58515 | 2110310.97621 | 37.7747523319835 | -122.428748692499 | (37.7747523319835, -122.428748692499) | 7 | 9 | 11 | 28852 | 10 | |||
26151 | 244927 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 250 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6005378.3818 | 2109958.5916 | 37.7738483085574 | -122.424836171267 | (37.7738483085574, -122.424836171267) | 7 | 9 | 11 | 28852 | 10 | |||
27342 | 135791 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 211 Larch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6006517.33983 | 2113030.04427 | 37.7823460391879 | -122.42111445739 | (37.7823460391879, -122.42111445739) | 7 | 9 | 11 | 28852 | 41 | |||
33200 | 42998 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 205X Rose St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42873 | 6005609.30796774 | 2109736.9244771 | 37.7732527046739 | -122.424021592666 | (37.7732527046739, -122.424021592666) | 7 | 9 | 11 | 28852 | 10 | |||
33634 | 65438 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 155 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/03/1989 12:00:00 AM | Permit Number 28312 | 6009256.14047234 | 2113222.54142077 | 37.7830286035896 | -122.411652986137 | (37.7830286035896, -122.411652986137) | 14 | 10 | 9 | 28852 | 36 | ||
34908 | 235692 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 17 Laussat St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6004588.55294 | 2109288.87963 | 37.7719647996542 | -122.427520597194 | (37.7719647996542, -122.427520597194) | 7 | 9 | 11 | 28852 | 10 | |||
36105 | 235691 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 61 Laussat St | 1 | : | Tree | Private 2 | 6 | Width 2ft | 6004436.15344 | 2109270.60375 | 37.771905997508 | -122.428046455984 | (37.771905997508, -122.428046455984) | 7 | 9 | 11 | 28852 | 10 | |||
37170 | 135794 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 210 Larch St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6006462.88254 | 2113039.98936 | 37.7823702759156 | -122.421303562328 | (37.7823702759156, -122.421303562328) | 7 | 9 | 11 | 28852 | 41 | |||
51617 | 235981 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 410 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004130 | 2110185 | 37.7743993802832 | -122.429170673587 | (37.7743993802832, -122.429170673587) | 7 | 9 | 11 | 28852 | 10 | |||
61425 | 235690 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 63 Laussat St | 1 | : | Tree | Private 2 | 8 | Width 2ft | 6004411.60055 | 2109266.67882 | 37.7718938314631 | -122.428131106459 | (37.7718938314631, -122.428131106459) | 7 | 9 | 11 | 28852 | 10 | |||
63948 | 138969 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 610 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004035.3418 | 2110925.4845 | 37.776427209717 | -122.429550934434 | (37.776427209717, -122.429550934434) | 7 | 9 | 11 | 28852 | 10 | |||
65200 | 135792 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 210 Larch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6006538.43664 | 2113050.20731 | 37.7824025912374 | -122.421042903704 | (37.7824025912374, -122.421042903704) | 7 | 9 | 11 | 28852 | 41 | |||
69272 | 138933 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 676 IVY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004115.5674 | 2110982.311 | 37.776587783373 | -122.429277464518 | (37.776587783373, -122.429277464518) | 7 | 9 | 11 | 28852 | 10 | |||
70477 | 235982 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 412 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004132.39397 | 2110220.08046 | 37.7744958381478 | -122.429164894259 | (37.7744958381478, -122.429164894259) | 7 | 9 | 11 | 28852 | 10 | |||
72606 | 48678 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 581 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2002 12:00:00 AM | 2 | Permit Number 45960 | 6005081.6405 | 2110909.2726 | 37.7764418820736 | -122.425930334752 | (37.7764418820736, -122.425930334752) | 7 | 9 | 11 | 28852 | 10 | ||
76657 | 67485 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 414 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/1992 12:00:00 AM | Permit Number 31008 | 6004136.98940863 | 2110216.53827017 | 37.7744863723053 | -122.429148745132 | (37.7744863723053, -122.429148745132) | 7 | 9 | 11 | 28852 | 10 | ||
76837 | 135793 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 210 Larch St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6006519.16372 | 2113046.92514 | 37.7823924927531 | -122.421109346535 | (37.7823924927531, -122.421109346535) | 7 | 9 | 11 | 28852 | 41 | |||
78815 | 12893 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 255X Larch St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1990 12:00:00 AM | 3 | 3X3 | 6006421.0816 | 2113018.78056 | 37.7823096849762 | -122.421446668727 | (37.7823096849762, -122.421446668727) | 7 | 9 | 11 | 28852 | 41 | ||
80169 | 12891 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 255X Larch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2005 12:00:00 AM | 3 | 3X3 | 6006369.20019 | 2113010.28335 | 37.7822834283719 | -122.421625551994 | (37.7822834283719, -122.421625551994) | 7 | 9 | 11 | 28852 | 41 | ||
81096 | 30573 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 164 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1995 12:00:00 AM | Permit Number 34550 | 6004481.83420946 | 2108792.73976924 | 37.7705964833806 | -122.42785438691 | (37.7705964833806, -122.42785438691) | 7 | 9 | 11 | 28852 | 10 | ||
86174 | 55624 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 428 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1992 12:00:00 AM | 9 | Permit Number 30322 | 6005737.866 | 2111395.9106 | 37.7778151358824 | -122.423694870717 | (37.7778151358824, -122.423694870717) | 7 | 9 | 11 | 28852 | 10 | ||
87450 | 235689 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 98 Laussat St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6004329.17404 | 2109279.26981 | 37.7719237393213 | -122.428417123276 | (37.7719237393213, -122.428417123276) | 7 | 9 | 11 | 28852 | 10 | |||
98010 | 235693 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 17 Laussat St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6004598.97629 | 2109290.88002 | 37.7719708817873 | -122.427484684569 | (37.7719708817873, -122.427484684569) | 7 | 9 | 11 | 28852 | 10 | |||
102712 | 43001 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 205X Rose St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42873 | 6005609.30796774 | 2109736.9244771 | 37.7732527046739 | -122.424021592666 | (37.7732527046739, -122.424021592666) | 7 | 9 | 11 | 28852 | 10 | |||
106510 | 135789 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 299 Larch St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6006301.79804 | 2113001.36971 | 37.7822551528071 | -122.421858100471 | (37.7822551528071, -122.421858100471) | 7 | 9 | 11 | 28852 | 41 | |||
109120 | 81929 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 118 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2007 12:00:00 AM | 6 | 3x3 | Permit Number 50018 | 6009095.92555 | 2112986.00249 | 37.7823701356165 | -122.412190543152 | (37.7823701356165, -122.412190543152) | 14 | 10 | 9 | 28852 | 36 | |
112279 | 235695 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 451 Lily St | 1 | : | Tree | Private 2 | 13 | Width 4ft | 6004373.81316 | 2109952.00813 | 37.773773440623 | -122.428310668716 | (37.773773440623, -122.428310668716) | 7 | 9 | 11 | 28852 | 10 | |||
116532 | 47035 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 261 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/2016 12:00:00 AM | 3 | Permit Number 46582 | 6004459.88025308 | 2109084.15296601 | 37.771395391316 | -122.427951094743 | (37.771395391316, -122.427951094743) | 7 | 9 | 11 | 28852 | 10 | |
120211 | 65439 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 165 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/2000 12:00:00 AM | 6 | Permit Number 28313 | 6009223.95051 | 2113218.56201 | 37.7830158713234 | -122.411764069357 | (37.7830158713234, -122.411764069357) | 14 | 10 | 9 | 28852 | 36 | |
122930 | 235983 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 400 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6004138.91627 | 2110174.54091 | 37.7743711669246 | -122.429139084622 | (37.7743711669246, -122.429139084622) | 7 | 9 | 11 | 28852 | 10 | |||
129277 | 103959 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 460X Lily St | 1 | unknown : Pot | Tree | Private 2 | 6004484.08045 | 2109981.44374 | 37.773860502373 | -122.427931334456 | (37.773860502373, -122.427931334456) | 7 | 9 | 11 | 28852 | 10 | |||||
132457 | 235694 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 11 Laussat St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6004612.357 | 2109292.45069 | 37.7719759512668 | -122.427438511585 | (37.7719759512668, -122.427438511585) | 7 | 9 | 11 | 28852 | 10 | |||
146591 | 237806 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 261 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004462.69471 | 2109085.95761 | 37.7714005056533 | -122.427941488015 | (37.7714005056533, -122.427941488015) | 7 | 9 | 11 | 28852 | 10 | |||
157175 | 67484 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 412 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/1992 12:00:00 AM | 3x3 | Permit Number 31007 | 6004139.01779577 | 2110201.94666072 | 37.7744464221464 | -122.42914068792 | (37.7744464221464, -122.42914068792) | 7 | 9 | 11 | 28852 | 10 | |
158149 | 244970 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 213 Rose St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6005502.3661 | 2109765.322 | 37.7733246390847 | -122.424393539592 | (37.7733246390847, -122.424393539592) | 7 | 9 | 11 | 28852 | 10 | |||
160321 | 235979 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 366 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004814.25 | 2109877.79907 | 37.7735945924434 | -122.426781841029 | (37.7735945924434, -122.426781841029) | 7 | 9 | 11 | 28852 | 10 | |||
161582 | 42779 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 530 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | Permit Number 42748 | 6004423.52781871 | 2110347.44356744 | 37.7748620225999 | -122.428166884567 | (37.7748620225999, -122.428166884567) | 7 | 9 | 11 | 28852 | 10 | |||
163761 | 135788 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 299 Larch St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6006281.06347 | 2112998.85336 | 37.7822470741855 | -122.421929654142 | (37.7822470741855, -122.421929654142) | 7 | 9 | 11 | 28852 | 41 | |||
170066 | 244971 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 211 Rose St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6005518.168 | 2109768.3608 | 37.7733338752015 | -122.424339094756 | (37.7733338752015, -122.424339094756) | 7 | 9 | 11 | 28852 | 10 | |||
176514 | 12892 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 255X Larch St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1990 12:00:00 AM | 3 | 3X3 | 6006398.20739 | 2113019.98592 | 37.7823117048675 | -122.421525889114 | (37.7823117048675, -122.421525889114) | 7 | 9 | 11 | 28852 | 41 | ||
180497 | 67558 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 408 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 6 | 3x3 | Permit Number 31108 | 6004143.07457091 | 2110172.76343568 | 37.7743665218092 | -122.429124573519 | (37.7743665218092, -122.429124573519) | 7 | 9 | 11 | 28852 | 10 |
182082 | 12894 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 255X Larch St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1990 12:00:00 AM | 3 | 3X3 | 6006443.29256 | 2113021.2667 | 37.7823177635948 | -122.421370005133 | (37.7823177635948, -122.421370005133) | 7 | 9 | 11 | 28852 | 41 | ||
183958 | 138828 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 644 IVY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6004227.2147 | 2111000.0275 | 37.7766427485075 | -122.428892507468 | (37.7766427485075, -122.428892507468) | 7 | 9 | 11 | 28852 | 10 | |||
183998 | 138834 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 676 IVY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6004097.5166 | 2110979.6368 | 37.7765794187635 | -122.429339716726 | (37.7765794187635, -122.429339716726) | 7 | 9 | 11 | 28852 | 10 | |||
185950 | 235702 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 599 Hickory St | 1 | : | Tree | Private 2 | 7 | Width 2ft | 6004146.37122 | 2110271.75391 | 37.7746385120028 | -122.42912022942 | (37.7746385120028, -122.42912022942) | 7 | 9 | 11 | 28852 | 10 | |||
186620 | 135787 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 299 Larch St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6006264.69881 | 2112993.30473 | 37.7822309160781 | -122.421985874363 | (37.7822309160781, -122.421985874363) | 7 | 9 | 11 | 28852 | 41 | |||
190118 | 49800 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 61@ WEBSTER Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | Permit Number 46592 | 6004436.15215025 | 2109254.48297957 | 37.7718617337201 | -122.428045311452 | (37.7718617337201, -122.428045311452) | 7 | 9 | 11 | 28852 | 10 | ||
190620 | 140058 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 428 GROVE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6005721.0754 | 2111392.7623 | 37.7778055435978 | -122.42375273139 | (37.7778055435978, -122.42375273139) | 7 | 9 | 11 | 28852 | 10 | |||
192278 | 235980 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 412 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004129.70882 | 2110250.68111 | 37.774579708026 | -122.429176365099 | (37.774579708026, -122.429176365099) | 7 | 9 | 11 | 28852 | 10 | |||
193009 | 135790 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 299 Larch St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6006313.68731 | 2113004.80337 | 37.7822652512815 | -122.421817212808 | (37.7822652512815, -122.421817212808) | 7 | 9 | 11 | 28852 | 41 | |||
152 | 235666 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1301 Jessie St | 4 | : | Tree | Private 2 | 3 | Width 2ft | 6006462.25734 | 2109005.38337 | 37.7712921868165 | -122.421019169707 | (37.7712921868165, -122.421019169707) | 8 | 2 | 9 | 28853 | 19 | |||
1775 | 196240 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 477 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010588.30864 | 2112340.27099 | 37.7806807348789 | -122.406982002622 | (37.7806807348789, -122.406982002622) | 14 | 2 | 9 | 28853 | 34 | |||
1813 | 25410 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 153 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/22/1996 12:00:00 AM | 3 | 3X3 | 6005712.73498 | 2108443.02914 | 37.7697058178046 | -122.423571815294 | (37.7697058178046, -122.423571815294) | 8 | 4 | 5 | 28853 | 19 | ||
2505 | 196318 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 323 11th St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6008553.79261 | 2109149.29537 | 37.7718050135221 | -122.413794615322 | (37.7718050135221, -122.413794615322) | 8 | 2 | 9 | 28853 | 34 | |||
3685 | 42239 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 526 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 5 | Permit Number 42488 | 6010182.46318 | 2111990.4424 | 37.7796974691974 | -122.408361341411 | (37.7796974691974, -122.408361341411) | 14 | 2 | 9 | 28853 | 34 | |
6844 | 235670 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 69 Elgin Park | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6005833.06667 | 2108709.07327 | 37.7704431026896 | -122.423174504696 | (37.7704431026896, -122.423174504696) | 8 | 2 | 5 | 28853 | 19 | |||
9072 | 235773 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1449 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007770.63381 | 2107353.8886 | 37.7668312365099 | -122.416376430431 | (37.7668312365099, -122.416376430431) | 8 | 4 | 7 | 28853 | 19 | |||
9610 | 196158 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 390x Hampshire St | 4 | Median : Cutout | Tree | DPW 1 | 8 | Width 5ft | 6010042.15672 | 2106501.92637 | 37.7646194177702 | -122.408459468244 | (37.7646194177702, -122.408459468244) | 8 | 4 | 8 | 28853 | 19 | |||
10532 | 79204 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 175 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6010493.03003 | 2110416.65916 | 37.7753936142481 | -122.407175982785 | (37.7753936142481, -122.407175982785) | 8 | 2 | 9 | 28853 | 34 | |||
10828 | 196319 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 83 Lafayette St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6007736.57644 | 2109492.64153 | 37.7727018336483 | -122.416645755806 | (37.7727018336483, -122.416645755806) | 8 | 2 | 9 | 28853 | 19 | |||
11344 | 196242 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 463 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6010684.26644 | 2112432.48387 | 37.7809392989608 | -122.406656537094 | (37.7809392989608, -122.406656537094) | 14 | 2 | 9 | 28853 | 34 | |||
11418 | 84345 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 925 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6010983.26021 | 2109758.62597 | 37.773614230057 | -122.405433799926 | (37.773614230057, -122.405433799926) | 14 | 2 | 9 | 28853 | 34 | |||
12329 | 236272 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 99 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/26/2019 12:00:00 AM | 3 | Width 3ft | 6007737.48047 | 2107411.94537 | 37.7669887824256 | -122.416495215585 | (37.7669887824256, -122.416495215585) | 8 | 4 | 7 | 28853 | 19 | ||
13125 | 196236 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 457 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010494.60827 | 2112515.413 | 37.7811563899075 | -122.407318509161 | (37.7811563899075, -122.407318509161) | 14 | 2 | 9 | 28853 | 34 | |||
14381 | 59534 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1117 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/14/1981 12:00:00 AM | 11 | Permit Number 18916 | 6009775.37323 | 2111231.47163 | 37.7775907092861 | -122.409716062169 | (37.7775907092861, -122.409716062169) | 8 | 2 | 9 | 28853 | 34 | |
14420 | 235664 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1301 Jessie St | 1 | : | Tree | Private 2 | 3 | Width 2ft | 6006467.28289 | 2108921.03594 | 37.7710608721893 | -122.42099579632 | (37.7710608721893, -122.42099579632) | 8 | 2 | 9 | 28853 | 19 | |||
14902 | 236271 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 99 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/26/2019 12:00:00 AM | 3 | Width 3ft | 6007736.0102 | 2107427.57543 | 37.7670316162303 | -122.416501408308 | (37.7670316162303, -122.416501408308) | 8 | 4 | 7 | 28853 | 19 | ||
15163 | 31818 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 195 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 5 | Permit Number 35284 | 6009861.68421 | 2111431.68624 | 37.7781452879246 | -122.409431615589 | (37.7781452879246, -122.409431615589) | 14 | 2 | 9 | 28853 | 34 | |
16236 | 41079 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 314 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/27/1999 12:00:00 AM | Permit Number 41836 | 6008273.99883854 | 2108752.45095329 | 37.7706996552947 | -122.414734354421 | (37.7706996552947, -122.414734354421) | 8 | 2 | 9 | 28853 | 19 | ||
18272 | 70670 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 52 Langton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6009955.96597 | 2110945.62551 | 37.7768159613156 | -122.40907115382 | (37.7768159613156, -122.40907115382) | 8 | 2 | 9 | 28853 | 34 | |||
19009 | 196230 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 945 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010940.27995 | 2109717.00714 | 37.7734975511022 | -122.405579544073 | (37.7734975511022, -122.405579544073) | 14 | 2 | 9 | 28853 | 34 | |||
19558 | 31090 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 107 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34826 | 6007750.16699625 | 2107319.28125593 | 37.7667350618817 | -122.416444770373 | (37.7667350618817, -122.416444770373) | 8 | 4 | 7 | 28853 | 19 | ||
19706 | 42174 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 468 09th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42462 | 6009925.08941952 | 2109046.40040251 | 37.7715994018396 | -122.409043924996 | (37.7715994018396, -122.409043924996) | 8 | 2 | 9 | 28853 | 34 | ||
20132 | 235665 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1301 Jessie St | 3 | : | Tree | Private 2 | 3 | Width 2ft | 6006464.5058 | 2108970.07849 | 37.7711953747872 | -122.421008885051 | (37.7711953747872, -122.421008885051) | 8 | 2 | 9 | 28853 | 19 | |||
20453 | 235745 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 44 Albion St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005774.17318 | 2106987.36156 | 37.765712369245 | -122.423255811501 | (37.765712369245, -122.423255811501) | 8 | 4 | 5 | 28853 | 19 | |||
21594 | 196222 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 50 Lucerne St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6012123.02143 | 2109681.25094 | 37.7734654372126 | -122.40148573028 | (37.7734654372126, -122.40148573028) | 14 | 2 | 9 | 28853 | 34 |
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) );