6,344 rows where qSpecies_id = 19 sorted by Neighborhoods (old)

View and edit SQL

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) ▼
22848 1398 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 47 Ardath Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/13/2004 12:00:00 AM 3 3X4   6017352.5573683 2095370.395604 37.7344612068158 -122.382399955055 (37.7344612068158, -122.382399955055) 10 3 8 58 1
23333 193069 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1601 Evans Ave 28 : Tree Private 2     2 Width 4ft   6015210.26637 2098805.13987 37.7437737433553 -122.390046486977 (37.7437737433553, -122.390046486977) 10 3 8 58 1
23487 199865 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1600 Jennings St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6016268.2217 2093791.063 37.7300647191695 -122.386038837831 (37.7300647191695, -122.386038837831) 10 3 8 58 1
23682 40078 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 300 Thornton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/19/1999 12:00:00 AM 8   Permit Number 41301 6013786.28999 2094199.42847 37.73104833461 -122.394647835845 (37.73104833461, -122.394647835845) 10 3 8 58 1
24154 17430 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1887 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6013360.18498 2096350.84555 37.7369319827098 -122.396271694904 (37.7369319827098, -122.396271694904) 10 3 8 58 1
24187 29860 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1900X Evans Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   09/11/2006 12:00:00 AM 3 4X4   6014068.9121897 2099730.7814701 37.746251993267 -122.394057835868 (37.746251993267, -122.394057835868) 10 3 8 58 1
24791 29820 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 1695X Evans Ave 18 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18   09/11/2006 12:00:00 AM 3 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
25092 50848 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 1636REVISED Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/21/2004 12:00:00 AM     Permit Number 47364 6014694.26637327 2095422.25015862 37.7344563934175 -122.391594241924 (37.7344563934175, -122.391594241924) 10 3 8 58 1
25931 193290 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1 Ardath Ct 13 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6017463.55131 2095291.12818 37.734249684563 -122.382010696451 (37.734249684563, -122.382010696451) 10 3 8 58 1
26200 29874 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1900X Evans Ave 16 Sidewalk: Curb side : Cutout Tree DPW 1   09/11/2006 12:00:00 AM 3 4X4   6014068.9121897 2099730.7814701 37.746251993267 -122.394057835868 (37.746251993267, -122.394057835868) 10 3 8 58 1
26664 199882 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1131 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6017363.6575 2093361.8884 37.728946855007 -122.382221895551 (37.728946855007, -122.382221895551) 10 3 8 58 1
26979 29831 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 1695X Evans Ave 29 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18   09/11/2006 12:00:00 AM 3 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
27122 29840 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1700X Evans Ave 7 Sidewalk: Curb side : Cutout Tree PUC 8   09/11/2006 12:00:00 AM 3 4X4   6014944.2776 2099085.41213 37.7445285569526 -122.390985805465 (37.7445285569526, -122.390985805465) 10 3 8 58 1
27503 199762 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1255 Thomas Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6016551.909 2092571.4831 37.726731689633 -122.384973150968 (37.726731689633, -122.384973150968) 10 3 8 58 1
28003 53147 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1511@ LANE Thomas Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/2006 12:00:00 AM 2   Permit Number 49075 6015192.9639 2093582.5577 37.7294326375383 -122.389741612555 (37.7294326375383, -122.389741612555) 10 3 8 58 1
28528 200025 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1572 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6015230.3375 2094325.3586 37.7314742920109 -122.3896642664 (37.7314742920109, -122.3896642664) 10 3 8 58 1
29180 193062 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1601 Evans Ave 12 : Tree Private 2     1 Width 4ft   6014912.02528 2099027.76176 37.7443684713257 -122.391093299634 (37.7443684713257, -122.391093299634) 10 3 8 58 1
29674 193022 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1675 Bay Shore Blvd 1 : Tree Private 2     5 Width 3ft   6012164.65845 2090962.85285 37.7220710717127 -122.400026921111 (37.7220710717127, -122.400026921111) 10 3 8 58 1
30796 193064 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1601 Evans Ave 23 : Tree Private 2     3 Width 4ft   6015121.07948 2098872.18165 37.7439528793244 -122.390359559858 (37.7439528793244, -122.390359559858) 10 3 8 58 1
31443 193304 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1502 Innes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6016023.1071 2096881.43664 37.7385366952096 -122.3871017028 (37.7385366952096, -122.3871017028) 10 3 8 58 1
31592 193294 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1013 Oakdale Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6017423.21493 2093673.93611 37.729806966204 -122.382037696797 (37.729806966204, -122.382037696797) 10 3 8 58 1
31612 29821 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 1695X Evans Ave 19 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18   09/11/2006 12:00:00 AM 3 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
31649 177325 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 499 Lathrop Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6012707.89529 2086680.32707 37.7103423833654 -122.397848820678 (37.7103423833654, -122.397848820678) 10 3 8 309 1
31736 26607 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1485 Bay Shore Blvd 6 Sidewalk: Curb side : Cutout Tree Private 2   03/14/2006 12:00:00 AM 3 3X3   6011745.1373 2092507.28125 37.7262883561197 -122.401585605396 (37.7262883561197, -122.401585605396) 10 3 8 58 1
31872 193018 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 3600 03rd St 6 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6015871.31513 2098824.58498 37.743863776308 -122.38776207318 (37.743863776308, -122.38776207318) 10 3 8 58 1
32025 193019 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 3600 03rd St 7 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6015859.74339 2098809.06176 37.7438205117227 -122.387801003014 (37.7438205117227, -122.387801003014) 10 3 8 58 1
32879 85590 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1570 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/21/2007 12:00:00 AM 3 3x3   6015074.2477 2095138.5099 37.7336983845847 -122.390260693216 (37.7336983845847, -122.390260693216) 10 3 8 58 1
33440 85582 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1486 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/21/2007 12:00:00 AM 3 3x3   6015517.7847 2094813.6891 37.7328310842891 -122.388704574636 (37.7328310842891, -122.388704574636) 10 3 8 58 1
33916 29854 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1800X Evans Ave 8 Sidewalk: Curb side : Cutout Tree DPW 1   09/11/2006 12:00:00 AM 3 4X4   6014413.12367 2099481.40364 37.7455863790999 -122.392850141433 (37.7455863790999, -122.392850141433) 10 3 8 58 1
34133 85609 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1551 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/21/2007 12:00:00 AM 3 3x3   6015130.3081 2095032.4348 37.7334102332415 -122.390059466624 (37.7334102332415, -122.390059466624) 10 3 8 58 1
34576 193303 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 807 Newhall St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   6015505.86141 2097146.99817 37.739237216732 -122.388908640419 (37.739237216732, -122.388908640419) 10 3 8 58 1
35159 6743 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1300X Fairfax Ave 13 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6016859.78768 2097310.83297 37.7397620268834 -122.384238731741 (37.7397620268834, -122.384238731741) 10 3 8 58 1
35168 17406 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1788 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/28/1996 12:00:00 AM 6 3x3   6013914.85019 2096007.19001 37.7360192239038 -122.39432990213 (37.7360192239038, -122.39432990213) 10 3 8 58 1
35682 26609 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1485 Bay Shore Blvd 8 Sidewalk: Curb side : Cutout Tree DPW 1   03/14/2006 12:00:00 AM 3 3X3   6011735.62232 2092555.25526 37.7264195519176 -122.401621868778 (37.7264195519176, -122.401621868778) 10 3 8 58 1
36680 38607 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1560 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/01/2006 12:00:00 AM 3   Permit Number 49071 6015315.5274 2094264.9013 37.7313130118825 -122.389365525835 (37.7313130118825, -122.389365525835) 10 3 8 58 1
37013 193088 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1445 Fairfax Ave 3 : Tree Private 2     3 Width 3ft   6016353.82584 2097602.79871 37.7405357172446 -122.386008496795 (37.7405357172446, -122.386008496795) 10 3 8 58 1
37553 193086 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1601 Evans Ave 53 : Tree Private 2     3 Width 4ft   6015572.85588 2098535.43446 37.7430532910692 -122.388773903118 (37.7430532910692, -122.388773903118) 10 3 8 58 1
37674 193286 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1333 Hudson Ave 15 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6017977.93865 2094591.23202 37.7323563014062 -122.380183654476 (37.7323563014062, -122.380183654476) 10 3 8 58 1
39517 85585 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1516 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/21/2007 12:00:00 AM 3 3x3   6015333.6646 2094945.596 37.733183067921 -122.389350338061 (37.733183067921, -122.389350338061) 10 3 8 58 1
39797 193106 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 70 Reddy St 1 : Tree Private 2     4 Width 3ft   6013577.9178 2093886.35961 37.7301771244662 -122.395346296097 (37.7301771244662, -122.395346296097) 10 3 8 58 1
40194 17471 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2050X Palou Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   11/17/1992 12:00:00 AM 6 3X3   6012415.17187 2097121.80295 37.7389962397742 -122.399593159205 (37.7389962397742, -122.399593159205) 10 3 8 58 1
40209 193100 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1224 Fairfax Ave 2 : Tree Private 2     1 Width 4ft   6017433.94384 2096880.5876 37.7386123884484 -122.382223599248 (37.7386123884484, -122.382223599248) 10 3 8 58 1
40448 10840 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1139X Hudson Ave 47 Sidewalk: Curb side : Cutout Tree DPW 1   02/24/2008 12:00:00 AM 3 3X4   6017999.90001 2094605.73201 37.7323973271712 -122.380108735409 (37.7323973271712, -122.380108735409) 10 3 8 58 1
40594 193298 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1040 Palou Ave 13 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6017507.81667 2093329.78992 37.7288666800305 -122.38172129012 (37.7288666800305, -122.38172129012) 10 3 8 58 1
41122 22500 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 6400 03rd St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6013113.36636 2090284.89866 37.7202623949849 -122.396699945652 (37.7202623949849, -122.396699945652) 10 3 8 58 1
41327 193049 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1940 Evans Ave 10 : Tree Private 2     5 Width 4ft   6013830.70731 2099917.50727 37.7467514607167 -122.394894600811 (37.7467514607167, -122.394894600811) 10 3 8 58 1
41367 29849 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1800X Evans Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1   09/11/2006 12:00:00 AM 3 4X4   6014521.43542 2099403.82747 37.7453793866416 -122.392470187744 (37.7453793866416, -122.392470187744) 10 3 8 58 1
41415 83660 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1588 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/01/2009 12:00:00 AM 2 3x3 Permit Number 52296 6015346.3057 2094590.2717 37.7322081198817 -122.389281830592 (37.7322081198817, -122.389281830592) 10 3 8 58 1
41533 29838 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1700X Evans Ave 5 Sidewalk: Curb side : Cutout Tree PUC 8   09/11/2006 12:00:00 AM 3 4X4   6014986.46906 2099054.93467 37.7444472132656 -122.39083778516 (37.7444472132656, -122.39083778516) 10 3 8 58 1
41584 29827 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 1695X Evans Ave 25 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18   09/11/2006 12:00:00 AM 3 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
41932 29823 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 1695X Evans Ave 21 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18   09/11/2006 12:00:00 AM 3 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
41960 193087 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1601 Evans Ave 54 : Tree Private 2     4 Width 4ft   6015589.76226 2098523.56065 37.7430216250434 -122.38871461621 (37.7430216250434, -122.38871461621) 10 3 8 58 1
43054 26608 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1485 Bay Shore Blvd 7 Sidewalk: Curb side : Cutout Tree Private 2   01/15/1998 12:00:00 AM 6 3X3   6011741.31334 2092529.41169 37.7263489083674 -122.401600379453 (37.7263489083674, -122.401600379453) 10 3 8 58 1
43072 47243 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 874 Jamestown Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/09/2002 12:00:00 AM 1   Permit Number 45192 6014744.2406 2089184.4725 37.7173314758058 -122.390985635281 (37.7173314758058, -122.390985635281) 10 3 8 58 1
43271 193072 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1601 Evans Ave 37 : Tree Private 2     3 Width 4ft   6015318.00876 2098725.46335 37.7435609430974 -122.389668372422 (37.7435609430974, -122.389668372422) 10 3 8 58 1
43549 29790 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 1985X Evans Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   09/11/2006 12:00:00 AM 3 4x4   6013589.41889 2100022.1973941 37.7470254980848 -122.395736292585 (37.7470254980848, -122.395736292585) 10 3 8 58 1
45640 201340 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1 Bitting Ave 2 Sidewalk: Property side : Yard Tree Private 2     4     6012714.10336 2092626.08619 37.7266685912663 -122.398244248089 (37.7266685912663, -122.398244248089) 10 3 8 58 1
45709 193052 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1998 Evans Ave 2 : Tree Private 2     3 Width 4ft   6013779.11033 2099954.16592 37.7468492484883 -122.395075586663 (37.7468492484883, -122.395075586663) 10 3 8 58 1
46884 199866 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1600 Jennings St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6016259.959 2093780.5969 37.7300355240413 -122.386066673972 (37.7300355240413, -122.386066673972) 10 3 8 58 1
46898 17389 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1696 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6014412.72216 2095634.17289 37.7350226581581 -122.392582460038 (37.7350226581581, -122.392582460038) 10 3 8 58 1
47220 85575 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1354 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/21/2007 12:00:00 AM 3 3x3   6016198.73439 2094304.25494 37.7314699961365 -122.386314831963 (37.7314699961365, -122.386314831963) 10 3 8 58 1
47975 17379 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1616 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6014755.80631 2095377.01944 37.7343356147903 -122.391378315473 (37.7343356147903, -122.391378315473) 10 3 8 58 1
48269 29808 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 1695X Evans Ave 5 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18   09/11/2006 12:00:00 AM 3 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
48390 193098 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1301 Fairfax Ave 2 : Tree Private 2     3 Width 3ft   6017070.0677 2097067.7936 37.7391063141074 -122.383494750497 (37.7391063141074, -122.383494750497) 10 3 8 58 1
48812 193038 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1925 Evans Ave 6 : Tree Private 2     3 Width 4ft   6013953.00674 2099743.1247 37.7462794425459 -122.394459489924 (37.7462794425459, -122.394459489924) 10 3 8 58 1
49057 193306 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1499 Mendell St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6015779.37833 2096310.48205 37.7369554703275 -122.387904577927 (37.7369554703275, -122.387904577927) 10 3 8 58 1
49175 17407 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1798 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6013883.27463 2096029.33044 37.7360782617048 -122.394440622145 (37.7360782617048, -122.394440622145) 10 3 8 58 1
49287 193284 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 6404 03rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6013063.29248 2090204.76107 37.7200395661428 -122.396867420218 (37.7200395661428, -122.396867420218) 10 3 8 58 1
49330 26604 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1485 Bay Shore Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   10/14/2011 12:00:00 AM 6 3X3 Permit Number 768158 6011777.20808 2092336.0059 37.7258198587868 -122.401462705844 (37.7258198587868, -122.401462705844) 10 3 8 58 1
49675 22110 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 3600X 03rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6015973.48399 2098973.66495 37.744278778308 -122.387419191637 (37.744278778308, -122.387419191637) 10 3 8 58 1
50008 82714 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1434 Shafter Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2009 12:00:00 AM 3 3x3 Permit Number 52468 6015808.2627 2093548.1385 37.7293722301295 -122.387612046257 (37.7293722301295, -122.387612046257) 10 3 8 58 1
50164 85608 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1481 Palou Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/21/2007 12:00:00 AM 3 3x3   6015511.739 2094744.9876 37.7326421087341 -122.38872068208 (37.7326421087341, -122.38872068208) 10 3 8 58 1
50419 193058 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1601 Evans Ave 6 : Tree Private 2     3 Width 4ft   6014802.29213 2099111.00932 37.7445909618204 -122.391478555688 (37.7445909618204, -122.391478555688) 10 3 8 58 1
50582 6838 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1475 Fairfax Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   03/14/2001 12:00:00 AM 5 3X3   6016138.23461 2097761.58271 37.7409597718784 -122.386765004722 (37.7409597718784, -122.386765004722) 10 3 8 58 1
52047 200719 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1530 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6015256.7189 2095000.5573 37.7333297142714 -122.389620199661 (37.7333297142714, -122.389620199661) 10 3 8 58 1
52363 40040 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 1358 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/03/1999 12:00:00 AM     Permit Number 41277 6016192.43464744 2094305.95322391 37.7314743105785 -122.386336729935 (37.7314743105785, -122.386336729935) 10 3 8 58 1
52443 88472 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1525 Jerrold Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM 3 3x3 Permit Number 51425 6015767.14868 2096650.26303 37.7378877623999 -122.387970564791 (37.7378877623999, -122.387970564791) 10 3 8 58 1
52567 193041 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1940 Evans Ave 2 : Tree Private 2     5 Width 4ft   6013966.95235 2099815.66783 37.7464794059188 -122.394416345849 (37.7464794059188, -122.394416345849) 10 3 8 58 1
53983 193042 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1940 Evans Ave 3 : Tree Private 2     5 Width 4ft   6013950.14435 2099829.5265 37.7465165245336 -122.394475436714 (37.7465165245336, -122.394475436714) 10 3 8 58 1
54610 193006 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 901 Rankin St 3 Sidewalk: Property side : Yard Tree Private 2     2 Width 3ft   6013524.80106 2097799.85374 37.7409198159039 -122.395804042044 (37.7409198159039, -122.395804042044) 10 3 8 58 1
54653 6760 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1275 Fairfax Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2006 12:00:00 AM 3 3x3   6017216.38852 2096959.46054 37.7388169392625 -122.382981296967 (37.7388169392625, -122.382981296967) 10 3 8 58 1
54907 39985 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 64 Flora St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/27/1999 12:00:00 AM     Permit Number 41243 6013841.23785102 2094410.9727181 37.7316322467041 -122.394472677257 (37.7316322467041, -122.394472677257) 10 3 8 58 1
55234 85591 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1574 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/21/2007 12:00:00 AM 3 3x3   6015045.6678 2095162.1433 37.7337616917971 -122.390361153846 (37.7337616917971, -122.390361153846) 10 3 8 58 1
55331 200216 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2524 Hawes St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6015239.1246 2090204.9839 37.7201610490527 -122.38934626171 (37.7201610490527, -122.38934626171) 10 3 8 58 1
55428 192998 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 901 Rankin St 12 Sidewalk: Property side : Yard Tree Private 2     2 Width 3ft   6013640.58193 2097957.11926 37.74135807441 -122.395414726402 (37.74135807441, -122.395414726402) 10 3 8 58 1
56423 29810 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 1695X Evans Ave 7 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18   09/11/2006 12:00:00 AM 3 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
56556 6813 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1400X Fairfax Ave 5 Sidewalk: Curb side : Cutout Tree Fire Dept 16   12/15/1998 12:00:00 AM 6 3X3   6016463.58165 2097607.01609 37.7405533709401 -122.385629294058 (37.7405533709401, -122.385629294058) 10 3 8 58 1
57238 193050 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1940 Evans Ave 11 : Tree Private 2     5 Width 4ft   6013815.46024 2099929.58477 37.7467837751701 -122.394948169817 (37.7467837751701, -122.394948169817) 10 3 8 58 1
57843 17404 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1783 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/19/1991 12:00:00 AM 30 3X3   6013910.33363 2095939.87898 37.7358341506251 -122.394340806408 (37.7358341506251, -122.394340806408) 10 3 8 58 1
58018 11386 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1435 Innes Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/16/1994 12:00:00 AM 6 3X4   6016388.35933 2096530.18404 37.7375924457244 -122.385814348454 (37.7375924457244, -122.385814348454) 10 3 8 58 1
58677 193077 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1601 Evans Ave 42 : Tree Private 2     4 Width 4ft   6015396.678 2098666.74648 37.7434040806449 -122.389392251751 (37.7434040806449, -122.389392251751) 10 3 8 58 1
58807 199698 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2098 Jennings St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6015533.013 2092802.5784 37.7273098206339 -122.388511598483 (37.7273098206339, -122.388511598483) 10 3 8 58 1
59127 85564 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1180 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/21/2007 12:00:00 AM 3 3x3   6017158.96801 2093588.13352 37.7295567721058 -122.38294526831 (37.7295567721058, -122.38294526831) 10 3 8 58 1
59199 193071 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1601 Evans Ave 36 : Tree Private 2     2 Width 4ft   6015306.71167 2098734.27336 37.743584507126 -122.389708050508 (37.743584507126, -122.389708050508) 10 3 8 58 1
60255 29807 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 1695X Evans Ave 4 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18   09/11/2006 12:00:00 AM 3 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
61225 85588 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1548 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/21/2007 12:00:00 AM 3 3x3   6015180.3228 2095061.0146 37.7334914813832 -122.389888545959 (37.7334914813832, -122.389888545959) 10 3 8 58 1
62347 38545 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 1553 Jennings St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40517 6016422.80620482 2093917.0086828 37.7304190951777 -122.385513188555 (37.7304190951777, -122.385513188555) 10 3 8 58 1
62392 200117 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1579 Wallace Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6014870.5488 2092777.8609 37.7272052174491 -122.390800027524 (37.7272052174491, -122.390800027524) 10 3 8 58 1
62492 29848 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1800X Evans Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   09/11/2006 12:00:00 AM 3 4X4   6014537.29909 2099390.62466 37.745344015429 -122.392414410014 (37.745344015429, -122.392414410014) 10 3 8 58 1
63403 193081 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1601 Evans Ave 46 : Tree Private 2     2 Width 4ft   6015460.55021 2098619.62663 37.7432782402895 -122.389168106536 (37.7432782402895, -122.389168106536) 10 3 8 58 1

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);