trees
6,714 rows where qSpecies_id = 7 sorted by Latitude 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
62453 | 41226 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 155 Retiro Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1999 12:00:00 AM | 8 | Permit Number 41932 | 6001878.60529 | 2121714.18401 | 37.8059278397599 | -122.437784566908 | (37.8059278397599, -122.437784566908) | 13 | 9 | 1 | 57 | 17 | |
74062 | 106161 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 827 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770049 | 6006757.57528 | 2121490.32366 | 37.8055893943007 | -122.420884191365 | (37.8055893943007, -122.420884191365) | 5 | 1 | 1 | 28858 | 32 | |
39924 | 41234 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3743 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1999 12:00:00 AM | 5 | Permit Number 41939 | 6002518.8447 | 2121486.57255 | 37.8053392631726 | -122.435552627664 | (37.8053392631726, -122.435552627664) | 13 | 9 | 1 | 57 | 17 | |
89350 | 142736 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 15 VANDEWATER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6009218.8197 | 2121322.4003 | 37.805266741303 | -122.412354799662 | (37.805266741303, -122.412354799662) | 3 | 1 | 10 | 308 | 23 | |||
81844 | 112372 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 15 Vandewater St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6009194.601 | 2121319.3086 | 37.8052568931935 | -122.412438393162 | (37.8052568931935, -122.412438393162) | 3 | 1 | 10 | 308 | 23 | |||
99006 | 143215 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 215 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6010264.7976 | 2121285.9953 | 37.805225422299 | -122.408732475128 | (37.805225422299, -122.408732475128) | 3 | 1 | 10 | 308 | 23 | |||
26062 | 142655 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 55 VANDEWATER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6009102.8791 | 2121306.4263 | 37.8052163739487 | -122.412754898161 | (37.8052163739487, -122.412754898161) | 3 | 1 | 10 | 308 | 23 | |||
154208 | 118370 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 55 Vandewater St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 2x2 | 6009076.084 | 2121302.8193 | 37.8052049660579 | -122.412847371079 | (37.8052049660579, -122.412847371079) | 3 | 1 | 10 | 308 | 23 | |||
140281 | 118368 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 55 Vandewater St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2x2 | 6009048.7736 | 2121299.2122 | 37.8051935288948 | -122.412941627226 | (37.8051935288948, -122.412941627226) | 3 | 1 | 10 | 308 | 23 | |||
115679 | 98564 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 301X Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |||
145225 | 98567 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 301X Francisco St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |||
159114 | 98563 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 301X Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |||
177484 | 98565 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 301X Francisco St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |||
149171 | 142656 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 382 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6009478.0111 | 2121215.2198 | 37.8049869916815 | -122.411450254798 | (37.8049869916815, -122.411450254798) | 3 | 1 | 10 | 308 | 23 | |||
145599 | 142657 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 392 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6009464.6135 | 2121214.7045 | 37.8049848253291 | -122.411496582459 | (37.8049848253291, -122.411496582459) | 3 | 1 | 10 | 308 | 23 | |||
25627 | 142658 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 396 Francisco St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6009447.6089 | 2121213.6739 | 37.8049810417497 | -122.411555356166 | (37.8049810417497, -122.411555356166) | 3 | 1 | 10 | 308 | 23 | |||
157859 | 142744 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 410 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6009308.9956 | 2121195.6387 | 37.804923745513 | -122.41203376959 | (37.804923745513, -122.41203376959) | 3 | 1 | 10 | 308 | 23 | |||
191008 | 142543 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 301 FRANCISCO ST | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | Width 0ft | 6009503.7886 | 2121178.1337 | 37.8048866083098 | -122.411358426924 | (37.8048866083098, -122.411358426924) | 3 | 1 | 10 | 308 | 23 | |||
24124 | 142520 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 301 FRANCISCO ST | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 7 | Width 0ft | 6009467.3323 | 2121175.1455 | 37.8048763586912 | -122.411484377145 | (37.8048763586912, -122.411484377145) | 3 | 1 | 10 | 308 | 23 | |||
153778 | 142519 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 301 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | Width 0ft | 6009452.9889 | 2121171.5596 | 37.8048657081731 | -122.411533760714 | (37.8048657081731, -122.411533760714) | 3 | 1 | 10 | 308 | 23 | |||
134500 | 142542 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 301 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 8 | Width 0ft | 6009433.8643 | 2121170.962 | 37.8048629945672 | -122.411599901453 | (37.8048629945672, -122.411599901453) | 3 | 1 | 10 | 308 | 23 | |||
53654 | 142540 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2100 POWELL ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6009421.7884 | 2121061.7254 | 37.8045623807522 | -122.411633968656 | (37.8045623807522, -122.411633968656) | 3 | 1 | 10 | 308 | 23 | |||
52923 | 249809 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 258 Chestnut St | 8 | Back Yard : Yard | Tree | Private 2 | 5 | Width 0ft | 6010708.45628 | 2121025.23541 | 37.8045342790877 | -122.407178739215 | (37.8045342790877, -122.407178739215) | 3 | 1 | 10 | 308 | 23 | |||
3324 | 100985 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2190 Powell St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 03/23/2016 02:34:00 PM | 3 | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257169 | (37.8045319114054, -122.41088257169) | 3 | 1 | 10 | 308 | 23 | |
106695 | 100983 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2190 Powell St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257169 | (37.8045319114054, -122.41088257169) | 3 | 1 | 10 | 308 | 23 | |||
132915 | 100984 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2190 Powell St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257169 | (37.8045319114054, -122.41088257169) | 3 | 1 | 10 | 308 | 23 | |||
191936 | 100987 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2190 Powell St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257169 | (37.8045319114054, -122.41088257169) | 3 | 1 | 10 | 308 | 23 | |||
27328 | 249807 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 258 Chestnut St | 6 | Back Yard : Yard | Tree | Private 2 | 7 | Width 0ft | 6010752.11734 | 2121021.55825 | 37.8045266258517 | -122.407027386026 | (37.8045266258517, -122.407027386026) | 3 | 1 | 10 | 308 | 23 | |||
125056 | 249810 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 258 Chestnut St | 9 | Back Yard : Yard | Tree | Private 2 | 5 | Width 0ft | 6010696.08755 | 2121019.21593 | 37.8045170588744 | -122.407221117962 | (37.8045170588744, -122.407221117962) | 3 | 1 | 10 | 308 | 23 | |||
47208 | 249808 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 258 Chestnut St | 7 | Back Yard : Yard | Tree | Private 2 | 12 | Width 0ft | 6010714.23144 | 2121016.75548 | 37.8045113184913 | -122.407158155531 | (37.8045113184913, -122.407158155531) | 3 | 1 | 10 | 308 | 23 | |||
81940 | 142537 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 2100 POWELL ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6009436.3973 | 2120993.5505 | 37.8043760089549 | -122.411578593269 | (37.8043760089549, -122.411578593269) | 3 | 1 | 10 | 308 | 23 | |||
149373 | 142536 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2100 POWELL ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6009440.4553 | 2120971.6371 | 37.8043160678486 | -122.411563000977 | (37.8043160678486, -122.411563000977) | 3 | 1 | 10 | 308 | 23 | |||
30486 | 142534 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2100 POWELL ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6009442.0785 | 2120933.4916 | 37.8042114208681 | -122.411554687027 | (37.8042114208681, -122.411554687027) | 3 | 1 | 10 | 308 | 23 | |||
106099 | 50376 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1620 Montgomery St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2003 12:00:00 AM | Permit Number 47039 | 6011351.83248495 | 2120835.88186523 | 37.804050345434 | -122.404938924734 | (37.804050345434, -122.404938924734) | 3 | 1 | 10 | 28860 | 6 | |||
143700 | 50379 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1620 Montgomery St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2003 12:00:00 AM | Permit Number 47039 | 6011351.83248495 | 2120835.88186523 | 37.804050345434 | -122.404938924734 | (37.804050345434, -122.404938924734) | 3 | 1 | 10 | 28860 | 6 | |||
188493 | 50380 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1620 Montgomery St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2003 12:00:00 AM | Permit Number 47039 | 6011351.83248495 | 2120835.88186523 | 37.804050345434 | -122.404938924734 | (37.804050345434, -122.404938924734) | 3 | 1 | 10 | 28860 | 6 | |||
42347 | 135851 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 787 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007518.53532 | 2120901.3436 | 37.8040150672041 | -122.418208991563 | (37.8040150672041, -122.418208991563) | 5 | 1 | 1 | 308 | 32 | |||
95368 | 31868 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3633 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/1999 12:00:00 AM | 7 | Permit Number 41912 | 5999648.6988 | 2121058.91348 | 37.8040015953726 | -122.445454333359 | (37.8040015953726, -122.445454333359) | 13 | 9 | 1 | 57 | 17 | |
108691 | 135850 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2456 Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6007513.5376 | 2120862.81684 | 37.8039090011686 | -122.418223553398 | (37.8039090011686, -122.418223553398) | 5 | 1 | 1 | 308 | 32 | |||
7922 | 135849 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2456 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007515.30382 | 2120841.49853 | 37.8038505659037 | -122.418215928918 | (37.8038505659037, -122.418215928918) | 5 | 1 | 1 | 308 | 32 | |||
137709 | 135855 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 220 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011218.6149 | 2120762.89652 | 37.8038424981016 | -122.405394792746 | (37.8038424981016, -122.405394792746) | 3 | 1 | 10 | 28860 | 23 | |||
60169 | 135857 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 220 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011195.52799 | 2120759.07991 | 37.8038307277799 | -122.405474417834 | (37.8038307277799, -122.405474417834) | 3 | 1 | 10 | 308 | 23 | |||
76016 | 135859 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 220 Lombard St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6011176.6986 | 2120755.37641 | 37.8038195060395 | -122.405539317394 | (37.8038195060395, -122.405539317394) | 3 | 1 | 10 | 308 | 23 | |||
79948 | 135854 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 220 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011219.52919 | 2120749.38326 | 37.8038054451262 | -122.405390676534 | (37.8038054451262, -122.405390676534) | 3 | 1 | 10 | 28860 | 23 | |||
28687 | 135856 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 220 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011197.01398 | 2120748.14382 | 37.803800783049 | -122.405468504785 | (37.803800783049, -122.405468504785) | 3 | 1 | 10 | 308 | 23 | |||
45294 | 135858 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 220 Lombard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011178.53707 | 2120744.35584 | 37.8037893490595 | -122.405532178584 | (37.8037893490595, -122.405532178584) | 3 | 1 | 10 | 308 | 23 | |||
146104 | 142610 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2424 JONES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6008008.0914 | 2120777.2854 | 37.8037019783089 | -122.416506051836 | (37.8037019783089, -122.416506051836) | 5 | 1 | 10 | 308 | 32 | |||
128106 | 135848 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2434 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6007523.24086 | 2120777.27009 | 37.8036746576187 | -122.418183905875 | (37.8036746576187, -122.418183905875) | 5 | 1 | 1 | 308 | 32 | |||
71064 | 135847 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2434 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6007523.40269 | 2120763.66368 | 37.8036373069691 | -122.418182380615 | (37.8036373069691, -122.418182380615) | 5 | 1 | 1 | 308 | 32 | |||
50273 | 135846 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2430 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6007526.598 | 2120747.58183 | 37.8035933301309 | -122.41817018222 | (37.8035933301309, -122.41817018222) | 5 | 1 | 1 | 308 | 32 | |||
168118 | 135845 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2430 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6007529.20491 | 2120735.02221 | 37.8035589913248 | -122.418160269894 | (37.8035589913248, -122.418160269894) | 5 | 1 | 1 | 308 | 32 | |||
65747 | 53178 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2420 REVISED Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/14/2006 12:00:00 AM | 5 | Permit Number 49096 | 6007531.88349 | 2120715.221 | 37.8035047729776 | -122.418149595852 | (37.8035047729776, -122.418149595852) | 5 | 1 | 1 | 308 | 32 | ||
53270 | 143244 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1913 STOCKTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6009926.8482 | 2120632.4472 | 37.8034120074717 | -122.409855833569 | (37.8034120074717, -122.409855833569) | 3 | 1 | 10 | 308 | 23 | |||
42447 | 68974 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3555 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | 8 | Permit Number 32964 | 5999680.68438 | 2120824.08507 | 37.8033586457513 | -122.445326751025 | (37.8033586457513, -122.445326751025) | 13 | 9 | 1 | 57 | 17 | |
64171 | 249873 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 230 Greenwich St | 9 | Back Yard : Yard | Tree | Private 2 | 26 | Width 0ft | 6011670.78297 | 2120474.23594 | 37.8030751776447 | -122.403809705266 | (37.8030751776447, -122.403809705266) | 3 | 1 | 10 | 28860 | 6 | |||
163020 | 249875 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 230 Greenwich St | 11 | Back Yard : Yard | Tree | Private 2 | 19 | Width 0ft | 6011656.00691 | 2120465.55697 | 37.8030505218387 | -122.403860227375 | (37.8030505218387, -122.403860227375) | 3 | 1 | 10 | 28860 | 6 | |||
121772 | 65968 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 990 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/1990 12:00:00 AM | 4 | Permit Number 28992 | 6007125.46509 | 2120550.16631 | 37.8030286907859 | -122.419544310327 | (37.8030286907859, -122.419544310327) | 5 | 1 | 1 | 28858 | 32 | ||
185098 | 249891 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 230 Greenwich St | 27 | Back Yard : Yard | Tree | Private 2 | 15 | Width 0ft | 6011455.07282 | 2120426.06234 | 37.8029308517393 | -122.404552786308 | (37.8029308517393, -122.404552786308) | 3 | 1 | 10 | 308 | 6 | |||
189324 | 249882 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 230 Greenwich St | 18 | Back Yard : Yard | Tree | Private 2 | 27 | Width 0ft | 6011509.07243 | 2120419.37331 | 37.8029155030083 | -122.404365447615 | (37.8029155030083, -122.404365447615) | 3 | 1 | 10 | 308 | 23 | |||
191182 | 41205 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3525 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/1999 12:00:00 AM | 6 | Permit Number 41911 | 5999706.5792 | 2120652.81241 | 37.8028898552495 | -122.445224820077 | (37.8028898552495, -122.445224820077) | 13 | 9 | 1 | 57 | 17 | |
40310 | 13074 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 645X Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 18 | 3X3 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | 3 | 1 | 10 | 308 | 23 | |||
77449 | 13073 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 645X Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 18 | 3X3 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | 3 | 1 | 10 | 308 | 23 | |||
156562 | 48595 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2820 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2002 12:00:00 AM | 7 | Permit Number 45905 | 6006103.67928 | 2120512.11503 | 37.802866605061 | -122.423077520915 | (37.802866605061, -122.423077520915) | 5 | 9 | 1 | 28858 | 32 | |
130873 | 143252 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 661 LOMBARD ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6009254.6269 | 2120447.319 | 37.8028659958274 | -122.412168998949 | (37.8028659958274, -122.412168998949) | 3 | 1 | 10 | 308 | 23 | |||
140036 | 81692 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1756-1758 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52334 | 6002382.95834 | 2120580.66995 | 37.8028441750767 | -122.43595801776 | (37.8028441750767, -122.43595801776) | 13 | 9 | 1 | 57 | 17 | |
118915 | 249847 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 289 Greenwich St | 4 | Side Yard : Yard | Tree | Private 2 | 5 | Width 0ft | 6011426.79495 | 2120392.20909 | 37.8028363185975 | -122.40464825831 | (37.8028363185975, -122.40464825831) | 3 | 1 | 10 | 308 | 23 | |||
111901 | 143251 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 661 LOMBARD ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6009160.7844 | 2120435.4058 | 37.8028280191875 | -122.412492900836 | (37.8028280191875, -122.412492900836) | 3 | 1 | 10 | 308 | 23 | |||
69988 | 249835 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 333 Greenwich St | 3 | Front Yard : Yard | Tree | Private 2 | 10 | Width 0ft | 6011233.03828 | 2120380.52255 | 37.8027933993566 | -122.40531793578 | (37.8027933993566, -122.40531793578) | 3 | 1 | 10 | 308 | 23 | |||
161855 | 249834 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 333 Greenwich St | 2 | Front Yard : Yard | Tree | Private 2 | 9 | Width 0ft | 6011234.1519 | 2120371.94769 | 37.8027699171526 | -122.405313477854 | (37.8027699171526, -122.405313477854) | 3 | 1 | 10 | 308 | 23 | |||
77623 | 249829 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 339 Greenwich St | 2 | Front Yard : Yard | Tree | Private 2 | 5 | Width 0ft | 6011201.84726 | 2120367.04696 | 37.8027546547757 | -122.405424923615 | (37.8027546547757, -122.405424923615) | 3 | 1 | 10 | 308 | 23 | |||
40495 | 249833 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 333 Greenwich St | 1 | Front Yard : Yard | Tree | Private 2 | 7 | Width 0ft | 6011234.89731 | 2120366.37397 | 37.8027546547576 | -122.405310505601 | (37.8027546547576, -122.405310505601) | 3 | 1 | 10 | 308 | 23 | |||
9410 | 79837 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2808 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6006109.45612 | 2120466.37489 | 37.8027413403128 | -122.423054277046 | (37.8027413403128, -122.423054277046) | 5 | 9 | 1 | 28858 | 32 | |||
31713 | 107635 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 1150 Lombard St | 10 | Front Yard : Yard | Tree | Private 2 | 10/01/2014 12:00:00 AM | 3 | Permit Number 773092 | 6006825.00646 | 2120436.80144 | 37.8027004912885 | -122.420576003873 | (37.8027004912885, -122.420576003873) | 5 | 1 | 1 | 28858 | 32 | ||
130372 | 135809 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1154 Chestnut St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 6006309.30935 | 2120436.02736 | 37.8026692893277 | -122.422360524716 | (37.8026692893277, -122.422360524716) | 5 | 9 | 1 | 28858 | 32 | |||
35699 | 121688 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 800 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 6008462.12689 | 2120388.3747 | 37.8026596503908 | -122.414907290765 | (37.8026596503908, -122.414907290765) | 5 | 1 | 10 | 308 | 32 | ||||
160910 | 121689 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 800 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 6008443.30153 | 2120385.20754 | 37.8026498963393 | -122.414972211914 | (37.8026498963393, -122.414972211914) | 5 | 1 | 10 | 308 | 32 | ||||
157990 | 69527 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2209 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/1997 12:00:00 AM | 6 | Permit Number 37887 | 6000084.88337 | 2120557.1111 | 37.8026486714458 | -122.443908816957 | (37.8026486714458, -122.443908816957) | 13 | 9 | 1 | 57 | 17 | ||
109415 | 65833 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2217 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/1990 12:00:00 AM | 6 | Permit Number 28823 | 6000063.66175 | 2120554.12794 | 37.8026392699554 | -122.443982039751 | (37.8026392699554, -122.443982039751) | 13 | 9 | 1 | 57 | 17 | ||
165905 | 65835 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2223 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/1990 12:00:00 AM | 4 | Permit Number 28825 | 6000036.05694 | 2120549.43371 | 37.802624806145 | -122.444077228483 | (37.802624806145, -122.444077228483) | 13 | 9 | 1 | 57 | 17 | ||
98213 | 143084 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 463 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6010663.1497 | 2120298.4418 | 37.8025361473527 | -122.407284261185 | (37.8025361473527, -122.407284261185) | 3 | 1 | 10 | 308 | 23 | |||
177502 | 249974 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 28 Napier Ln | 1 | Front Yard : Yard | Tree | Private 2 | 18 | Width 0ft | 6011652.50252 | 2120258.92401 | 37.8024829623787 | -122.403857805517 | (37.8024829623787, -122.403857805517) | 3 | 1 | 10 | 308 | 23 | |||
128965 | 135853 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 12 Filbert St | 9 | Sidewalk: Curb side : Pot | Tree | Private 2 | 26 | 6012286.0131 | 2120198.43277 | 37.8023522396158 | -122.401661277048 | (37.8023522396158, -122.401661277048) | 3 | 1 | 10 | 28860 | 6 | ||||
116460 | 249982 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 224 Filbert St | 3 | Front Yard : Yard | Tree | Private 2 | 12 | Width 0ft | 6011639.74764 | 2120113.25639 | 37.8020822820333 | -122.403891687471 | (37.8020822820333, -122.403891687471) | 3 | 1 | 10 | 308 | 23 | |||
101994 | 142615 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 701 GREENWICH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6009481.4553 | 2120134.1797 | 37.8020189178421 | -122.411361918128 | (37.8020189178421, -122.411361918128) | 3 | 1 | 10 | 308 | 23 | |||
136640 | 249970 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 213 Filbert St | 1 | Back Yard : Yard | Tree | Private 2 | 31 | Width 0ft | 6011737.03783 | 2120086.51138 | 37.8020142816062 | -122.403553132272 | (37.8020142816062, -122.403553132272) | 3 | 1 | 10 | 308 | 23 | |||
92199 | 250005 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 232 Filbert St | 3 | Side Yard : Yard | Tree | Private 2 | 8 | Width 0ft | 6011493.8796 | 2120090.77159 | 37.802012393927 | -122.404394879735 | (37.802012393927, -122.404394879735) | 3 | 1 | 10 | 308 | 23 | |||
97682 | 249969 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 213 Filbert St | 2 | Back Yard : Yard | Tree | Private 2 | 28 | Width 0ft | 6011730.79134 | 2120085.86253 | 37.8020121511077 | -122.403574702535 | (37.8020121511077, -122.403574702535) | 3 | 1 | 10 | 308 | 23 | |||
5789 | 142614 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 701 GREENWICH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6009469.9119 | 2120131.871 | 37.8020119312896 | -122.411401700731 | (37.8020119312896, -122.411401700731) | 3 | 1 | 10 | 308 | 23 | |||
17117 | 142613 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 701 GREENWICH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6009456.5216 | 2120130.9476 | 37.8020086448232 | -122.411447972427 | (37.8020086448232, -122.411447972427) | 3 | 1 | 10 | 308 | 23 | |||
14977 | 71423 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 701 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6009442.6696 | 2120129.5624 | 37.8020040644534 | -122.411495809181 | (37.8020040644534, -122.411495809181) | 3 | 1 | 10 | 308 | 23 | |||
187680 | 135817 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1083 Lombard St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 6007203.65947 | 2120166.57987 | 37.8019798636266 | -122.419246489941 | (37.8019798636266, -122.419246489941) | 5 | 1 | 1 | 28858 | 32 | |||
36477 | 249963 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 271 Filbert St | 1 | Front Yard : Yard | Tree | Private 2 | 10 | Width 0ft | 6011592.60874 | 2120072.38059 | 37.8019674134157 | -122.404051933175 | (37.8019674134157, -122.404051933175) | 3 | 1 | 10 | 308 | 23 | |||
83714 | 135818 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1071 Lombard St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 6007217.26018 | 2120160.17933 | 37.8019630553145 | -122.419198970666 | (37.8019630553145, -122.419198970666) | 5 | 1 | 1 | 28858 | 32 | |||
37974 | 142616 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1867 POWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6009512.0452 | 2120108.7843 | 37.801950904005 | -122.411254267134 | (37.801950904005, -122.411254267134) | 3 | 1 | 10 | 308 | 23 | |||
165416 | 116893 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 176 ALHAMBRA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001452 | 2120263 | 37.8019190076456 | -122.439156822678 | (37.8019190076456, -122.439156822678) | 13 | 9 | 1 | 57 | 17 | ||||
147517 | 135837 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2333 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007565.4054 | 2120114.29452 | 37.8018566673237 | -122.417990966211 | (37.8018566673237, -122.417990966211) | 5 | 1 | 1 | 28858 | 32 | |||
118467 | 249937 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 339 Filbert St | 2 | Front Yard : Yard | Tree | Private 2 | 7 | Width 0ft | 6011248.56733 | 2120031.66705 | 37.8018363956996 | -122.405239616532 | (37.8018363956996, -122.405239616532) | 3 | 1 | 10 | 308 | 23 | |||
158476 | 249945 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 325 Filbert St | 1 | Front Yard : Yard | Tree | Private 2 | 24 | Width 0ft | 6011292.48387 | 2120026.50548 | 37.8018246784261 | -122.405087280374 | (37.8018246784261, -122.405087280374) | 3 | 1 | 10 | 308 | 23 | |||
95678 | 249933 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 345 Filbert St | 2 | Front Yard : Yard | Tree | Private 2 | 7 | Width 0ft | 6011225.47356 | 2120026.31802 | 37.801820417444 | -122.405319155254 | (37.801820417444, -122.405319155254) | 3 | 1 | 10 | 308 | 23 | |||
166724 | 249931 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 345 Filbert St | 5 | : | Tree | Private 2 | 5 | Width 0ft | 6011214.74621 | 2120016.06231 | 37.8017916580081 | -122.405355554416 | (37.8017916580081, -122.405355554416) | 3 | 1 | 10 | 308 | 23 |
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) );